Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

Datashed is a utility for extracting data from IMOS and exporting it in various formats. It can be run stand-alone from the command line as an ad hoc utility, or it can be run from the Messaging Service. Datashed accepts many arguments, some of which may be incompatible with one another.

Info

For more information, see the Messaging Service Manual.


Command line option*Description
--action=valueA vnccmd:command action, in URI format, to perform, inclusive of that action's arguments
--actionLimit=valueUsed in conjunction with --action to specify the maximum number of actions that will be executed
--bulksize=valueThe maximum number of records to output to DB in one call (500 by default)
--emailAttach=value

(optional)

  • True (default): Email output in the specified format as an attachment
  • False: Email as embedded HTML
--emailBlank=value
  • True: Email blank outputs
  • False (default): Email non-blank outputs only
--emailFrom=valueSender's email address (as specified in Messaging Service Configuration Outgoing Message Locations, e.g., xxxx@gmail.com) to use when emailing report output (optional, to be used with emailTo option)
--emailTo=valueA comma-separated list of user names, Distribution List(s), and/or companyNo (for Address Book report distribution) to receive the output by email
--env=valueIMOS environment to use (optional)
--httpHeader headerName headerValue

HTTP header fields added to outgoing HTTP messages generated by imosmail.exe to support external systems that require additional parameters to accompany the message payload (e.g., a user name and password)

--httpRequest URLMethod for sending an HTTP request, supported by imosmail.exe
--locale=VALUELocale format for the report to export in; the value comes from OS Language Value Codes
--multithreadCommands Datashed to run across multiple threads, taking full use of available CPU cores to perform its query faster
--outputPath=value

Output location (optional, overrides Report Designer view settings):

  • If rvOutputType=doc, the value is a full path to the output file.
  • Otherwise, the value is an output directory (folder).
--rvFile=valueAn exported Report Designer FORM file to run
--rvFilter=valueA series of logical filters that can apply to the object specified by rvForm
--rvForm=valueAn IMOS Dataforms Object to run
--rvOutputType=value
  • list (default)
  • doc (requires using at least the --rvFile and --outputPath options): Exports a report definition with the data you want, including joins, to a hierarchical XML that can be used in stylesheets
    • --rvFile must specify a Report Designer FORM file that outputs only one instance of the first Table selected. To do this, use report filters in the report definition or use the --rvFilter option with the Datashed. For example, to export a Voyage object to an XML, the FORM file must be a report that filters all voyages down to a single voyage.
    • When the data is exported, a structured XML file is created with the first Table set as the root of the XML file. Fields that are included in the report definition are exported to the XML file. Joined tables are created as child elements of the root and their joined fields are exported as well. The system supports nesting joined tables to any level.
--rvTitle=valueReport Designer view title to run
--rvBaseID=value

Value of the viewID from the query retrieved when running:

  • select viewID, * from reportview where title = '{YOUR_REPORT_TITLE}'
--streamReads data from the database in chunks of 5,000 records to prevent out-of-memory exceptions that might occur from loading all the data at once. The report being run must be uniquely sorted using only standard columns, and output must be set to XML or CSV
--streamBatchSize numberUsed in conjunction with --stream to specify how many records should be loaded per batch
--user=valueUser name to use for resolving meta-user fields in reports (optional)
--webpost URLMethod for sending an HTTP request, supported by imosmail.exe
--webprocess URLMethod for sending an HTTP request, supported by imosmail.exe
--webquery URLMethod for sending an HTTP request, supported by imosmail.exe
  • When running datashed.exe from the command line, for some arguments you may need to have an IMOS shell open, and also to set the IMOSENV environment variable to the intended IMOS environment name.
  • *When providing values to arguments, it is a good idea to wrap the VALUE in double-quotes (" ").

...