The oim-csv command loads and validates an XBRL Open Information Model (OIM) xBRL-CSV report and converts it to other OIM formats (JSON and/or XML).
raptorxmlxbrl oim-csv [options] InputFile |
•The InputFile argument locates the JSON file that contains the metadata of the CSV tables of OIM xBRL-CSV data you want to load.
•To convert to OIM JSON and OIM XML formats, use the --json-output and --xml-output options, respectively. You can use both options in one command (see the third example below), but you can generate only one output in each format.
Examples
Examples of the oim.csv command:
•raptorxmlxbrl oim-csv --xml-output=c:\MyOIMxml.xml c:\MyOIMcsv.json
•raptorxmlxbrl oim-csv --json-output=c:\MyOIMjson.json c:\MyOIMcsv.json
•raptorxmlxbrl oim-csv --xml-output=c:\MyOIMxml.xml --json-output=c:\MyOIMjson.json c:\MyOIMcsv.json
RaptorXMLXBRL (and RaptorXMLXBRLServer for administration commands) on Windows raptorxmlxbrl (and raptorxmlxbrlserver for administration commands) on Windows and Unix (Linux, Mac) * Note that lowercase (raptorxmlxbrl and raptorxmlxbrlserver) works on all platforms (Windows, Linux, and Mac), while upper-lower (RaptorXMLXBRL) works only on Windows and Mac. * Use forward slashes on Linux and Mac, backslashes on Windows. |
On Windows systems: When spaces or special characters occur in strings (for example in file or folder names, or company, person or product names), use quotes: for example, "My File". Note, however, that a backslash followed by a double-quotation mark (for example, "C:\My directory\") might not be read correctly. This is because the backslash character is also used to indicate the start of an escape sequence, and the escape sequence \" stands for the double-quotation mark character. If you want to escape this sequence of characters, use a preceding backslash, like this: \\". To summarize: If you need to write a file path that contains spaces or an end backslash, write it like this: "C:\My Directory\\". |
Options
Options are listed in short form (if available) and long form. You can use one or two dashes for both short and long forms. An option may or may not take a value. If it takes a value, it is written like this: --option=value. Values can be specified without quotes except in two cases: (i) when the value string contains spaces, or (ii) when explicitly stated in the description of the option that quotes are required. If an option takes a Boolean value and no value is specified, then the option's default value is TRUE. Use the --h, --help option to display information about the command.
--additional-dts-entry-point = FILE Forces the specified entry-point file to be included in the DTS discovery process. Add the option multiple times to specify more than one entry point. |
--additional-filing-rules = none|auto|eba|srb|eiopa Specifies which additional filing rules to apply (EBA, SRB, EIOPA, or none). The default is none. |
--calc11.rounding = round-to-nearest|truncate Specifies the XBRL Calculations 1.1 rounding mode. Default is round-to-nearest. |
--calculations-mode = only_10 | only_11 | 10_and_11 | force_11 Specifies the XBRL Calculations versions to use and to which relationships they are applied. This only has an effect if --summation-item-checks are not disabled. Default is 10_and_11. |
--ct-restrict-mode = 1.0|1.1|default Specifies how to check complex type restrictions. A value of 1.0 checks complex type restrictions as defined in the XSD 1.0 specification—even in XSD 1.1 validation mode. A value of 1.1 checks complex type restrictions as defined in the XSD 1.1 specification—even in XSD 1.0 validation mode. A value of default checks complex type restrictions as defined in the XSD specification of the current validation mode (1.0 or 1.1). The default value is default. |
--deduplicate = true|false Enables de-duplication according to the Handling Duplicate Facts in XBRL and Inline XBRL 1.0 specification. Removes facts that are (i) complete duplicates, (ii) consistent duplicates (by definition these are numeric facts; the most accurate of the duplicates is retained for processing). Inconsistent and multi-language duplicates are not affected by this option. Default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--dimensions = true|false Enables XBRL Dimension 1.0 extensions. Default is true. Note: Boolean option values are set to true if the option is specified without a value. |
--dts = FILE Preloads the DTS entry point given in FILE, and uses it for the validation of instance files. Add the option multiple times to specify more than one entry point. Entry points in instance files will be ignored. The command is used to batch validate multiple instance files that all refer to the same taxonomy. The --dts option instructs the Raptor engine to load the DTS only a single time—and not for each instance in the file list. (A file list is given either on the CLI, or in a text file that is indicated as a file list by setting the --listfile option to true.) If an instance file in the file list references a different taxonomy, then a warning is issued. This command can greatly speed up validation time when validating many small instance files each that have a large supporting DTS; it provides no advantage when validating a single instance file. |
--essence-alias-checks = true|false Enables reporting of essence-alias inconsistencies. Default value is true. Note: Boolean option values are set to true if the option is specified without a value. |
--generic-links = true|false Enables the XBRL Generic Links 1.0 extension. Default value is true. Note: Boolean option values are set to true if the option is specified without a value. |
--generic-preferred-label = true|false Enables the XBRL Generic Preferred Label 1.0 extension. Default value is true. Note: Boolean option values are set to true if the option is specified without a value. |
--i, --ignore-certificate-errors = true|false If set to true, ignores certificate errors during verification of XML signatures (the SignedInfo elements) in an XML document. The default is false. Note: Boolean option values are set to true if the option is specified without a value. |
--inconsistencies-limit = N | unlimited Specifies the XBRL inconsistencies limit, with values being in the range 1-65535 or unlimited. Processing continues if the limit is reached, but further inconsistencies are not reported. The default value is 100. |
--preload-xbrl-schemas = true|false Preloads schemas of the XBRL 2.1 specification. Default is true. Note: Boolean option values are set to true if the option is specified without a value. |
--report-duplicates = all|complete|consistent|inconsistent|inconsistent-numeric|inconsistent-non-numeric|multi-language Enables the reporting of duplicate facts of the specified duplicate class. Add the option multiple times to specify more than one duplicate class. There is no default value. If no value is specified, then no check for duplicates is carried out. |
--report-duplicates-severity = info|warning|inconsistency|error Specifies whether the detected duplicate facts should be reported as errors or warnings. If they are reported as errors, then the XBRL validation of the instance will fail. The default is error. |
--report-import-namespace-mismatch-as-warning = true|false Downgrades namespace or target-namespace mismatch errors when importing schemas with xs:import from errors to warnings. The default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--requires-element-checks = true|false Enables reporting of requires-element inconsistencies. The default value is true. Note: Boolean option values are set to true if the option is specified without a value. |
--schema-imports = load-by-schemalocation | load-preferring-schemalocation | load-by-namespace | load-combining-both | license-namespace-only Specifies the behaviour of xs:import elements, each of which has an optional namespace attribute and an optional schemaLocation attribute: <import namespace="someNS" schemaLocation="someURL">. The option specifies whether to load a schema document or just license a namespace, and, if a schema document is to be loaded, which information should be used to find it. Default: load-preferring-schemalocation. The behavior is as follows: •load-by-schemalocation: The value of the schemaLocation attribute is used to locate the schema, taking account of catalog mappings. If the namespace attribute is present, the namespace is imported (licensed). •load-preferring-schemalocation: If the schemaLocation attribute is present, it is used, taking account of catalog mappings. If no schemaLocation attribute is present, then the value of the namespace attribute is used via a catalog mapping. This is the default value. •load-by-namespace: The value of the namespace attribute is used to locate the schema via a catalog mapping. •load-combining-both: If either the namespace or schemaLocation attribute has a catalog mapping, then the mapping is used. If both have catalog mappings, then the value of the --schema-mapping option (XBRL option and XML/XSD option) decides which mapping is used. If no catalog mapping is present, the schemaLocation attribute is used. •license-namespace-only: The namespace is imported. No schema document is imported. |
--schema-mapping = prefer-schemalocation | prefer-namespace If schema location and namespace are both used to find a schema document, specifies which of them should be preferred during catalog lookup. (If either the --schemalocation-hints or the --schema-imports option has a value of load-combining-both, and if the namespace and URL parts involved both have catalog mappings, then the value of this option specifies which of the two mappings to use (namespace mapping or URL mapping; the prefer-schemalocation value refers to the URL mapping).) Default is prefer-schemalocation. |
--schemalocation-hints = load-by-schemalocation | load-by-namespace | load-combining-both | ignore Specifies the behavior of the xsi:schemaLocation and xsi:noNamespaceSchemaLocation attributes: Whether to load a schema document, and, if yes, which information should be used to find it. Default: load-by-schemalocation. •The load-by-schemalocation value uses the URL of the schema location in the xsi:schemaLocation and xsi:noNamespaceSchemaLocation attributes in XML or XBRL instance documents. This is the default value. •The load-by-namespace value takes the namespace part of xsi:schemaLocation and an empty string in the case of xsi:noNamespaceSchemaLocation and locates the schema via a catalog mapping. •If load-combining-both is used and if either the namespace part or the URL part has a catalog mapping, then the catalog mapping is used. If both have catalog mappings, then the value of the --schema-mapping option (XBRL option and XML/XSD option) decides which mapping is used. If neither the namespace nor URL has a catalog mapping, the URL is used. •If the option's value is ignore, then the xsi:schemaLocation and xsi:noNamespaceSchemaLocation attributes are both ignored. |
--summation-item-checks = true|false Enables reporting of summation-item inconsistencies. Use the --calculations-mode option to specify which version of XBRL Calculations check should be applied. The default value is true. Note: Boolean option values are set to true if the option is specified without a value. |
--taxonomy-package = FILE Specifies the absolute path to an additional taxonomy package as described in the Taxonomy Package 1.0 and Taxonomy Packages 1.0 working drafts. The value of FILE gives the location of the taxonomy package. Add the option multiple times to specify more than one taxonomy package. |
--taxonomy-packages-config-file = FILE Specifies the path to the TaxonomyPackagesConfig.json file, which is used to load XBRL taxonomy packages. The file's convenience is that it serves as a catalog of taxonomy packages. The structure of the JSON file is as in the example listing below. The value of the uri key gives the location of the package. The active key (of a set of packages) switches on usage of those packages. {"taxonomies": {"EIOPA Solvency II XBRL Taxonomy 2.1.0": {"packages":[ {"uri":"C:\\test\\XBRL\\EIOPA_SolvencyII_XBRL_Taxonomy_2.1.0.zip"}, {"uri":"C:\\test\\XBRL\\AdditionalTestPkg.zip"} ],"active":true },"Test Taxonomy": {"packages":[{"uri":"C:\\test\\XBRL\\test.zip"}],"active":true } } } |
--treat-custom-role-errors-as-warnings = true|false Reports non-critical XBRL errors related to custom role/arcrole types (for example, missing roleRefs) as warnings. Default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--treat-inconsistencies-as-errors = true|false Causes XBRL validation to fail if the file contains any inconsistency as defined by the XBRL 2.1 specification. Default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--treat-invalid-use-of-standard-role-as-warning = true|false Specifies whether the invalid use of standard roles should be reported only as a warning. Default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--uri-transformation = none|make-absolute|make-relative|keep-relative Specifies how URIs should written to the generated XBRL document. •none: Copy URI verbatim to target document •make-absolute: Make any relative URIs absolute by resolving against the in-scope base URI at the respective element in the input document. For example: if the input file is c:\test\inlinexbrl.xhtml, and it contains a relative reference to a schema, schemas\schema.xsd, then the relative reference would be resolved to: c:\test\schemas\schema.xsd. Note that xml:base attributes in the input document can change the base URI. •make-relative: If possible, make any absolute and relative URIs relative to the output document (otherwise write the resolved absolute URI) •keep-relative: If possible, make only the relative URIs relative to the output document (and copy any absolute URI) |
--utr-file = FILE Specifies the path to the Units Registry file. The default is: http://www.xbrl.org/utr/utr.xml. |
--utr-status = PWD|CR|REC|NIE|PROPOSED|IWD|ACK|RR Enables support of unit definitions with the given status in the Units Registry. Add the option multiple times to specify more than one unit status. Default is REC. |
--validate-dts-only = true|false The DTS is discovered by starting from the XBRL instance document. All referenced taxonomy schemas and linkbases are discovered and validated. The rest of the XBRL instance document is ignored. Default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--xinclude = true|false Enables XML Inclusions (XInclude) support. Default value is false. When false, XInclude's include elements are ignored. Note: Boolean option values are set to true if the option is specified without a value. |
|
--assertion-severity = true|false Enables the Assertion Severity 1.0 and 2.0 extensions. Default is true. Note: Boolean option values are set to true if the option is specified without a value. |
--assertions-output = FILE Writes the output of the assertion evaluation to the specified FILE. If set, automatically specifies --formula-execution=true. |
--assertions-output-format = json|xml Specifies the output format of the assertion evaluation. Default is json. |
--enable-formula-optimizations = true|false Enables optimizations for variable sets in which there are no explicit dependencies between fact variables. Default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--evaluate-referenced-parameters-only = true|false If false, forces evaluation of all parameters even if they are not referenced by any formulas/assertions/tables. Default is: true. |
--formula = true|false Enables the XBRL Formula 1.0 extension. Default is true. Note: Boolean option values are set to true if the option is specified without a value. |
--formula-assertion-set = VALUE Limits formula execution to the given assertion set only. Add the option multiple times to specify more than one assertion set. Short form is --as. The VALUE is either the value of the @id attribute, or a URI with an XPointer fragment that identifies the resource. The special values ##none and ##all can also be used. |
--formula-execution = true|false Enables evaluation of XBRL formulas. Default is true. If true, automatically specifies --formula=true. Note: Boolean option values are set to true if the option is specified without a value. |
--formula-output = FILE Writes the output of formula evaluation to the specified FILE. If set, automatically specifies --formula-execution=true. |
--formula-parameters = JSON-ARRAY Specifies parameters for XBRL formula evaluation as array of JSON maps directly on the CLI. See the section Formula Parameters for details. |
--formula-parameters-file = FILE Specifies a FILE containing the parameters for XBRL formula evaluation. The file can be either an XML file or JSON file. See the section, Formula Parameters. |
--ignore-assertion = VALUE Excludes the given assertion from the execution. Add this option multiple times to specify more than one assertion. |
--ignore-assertions-file = FILE Specifies a path to a file that contains a list of IDs/XPointers of assertions to exclude from processing. In the file, enter one assertion per line. |
--ignore-formula = VALUE Excludes the given formula from the execution. Add this option multiple times to specify more than one formula. |
--ignore-formulas-file = FILE Specifies a path to a file that contains a list of formula IDs/XPointers to exclude from processing. In the file, enter one formula per line. |
--message-lang = VALUE Specifies the language to use when displaying validation messages. Default is: en. Other accepted values are de, es, fr, ja, for, respectively, German, Spanish, French, and Japanese. |
--message-role = VALUE Specifies the preferred message role to use when displaying validation messages. Default is: http://www.xbrl.org/2010/role/message. |
--preload-formula-schemas = true|false Preloads schemas of the XBRL Formula 1.0 specification. Default is false. Note: Boolean option values are set to true if the option is specified without a value. |
--a | --process-assertion = VALUE Limits formula execution to the given assertion only. Add the option multiple times to specify more than one assertion. Short form is --a. The VALUE is either the value of the @id attribute, or a URI with an XPointer fragment that identifies the resource. The special values ##none and ##all can also be used. |
--as | --process-assertion-set = VALUE Limits formula execution to the given assertion set only. Add the option multiple times to specify more than one assertion set. Short form is --as. The VALUE is either the value of the @id attribute, or a URI with an XPointer fragment that identifies the resource. The special values ##none and ##all can also be used. |
--process-assertions-file = FILE Specifies a path to a file that contains a list of IDs/XPointers of assertions to execute. In the file, enter one assertion per line. |
--f | --process-formula = VALUE Limits formula execution to the given formula only. Add the option multiple times to specify more than one formula. Short form is --f. The VALUE is either the value of the @id attribute, or a URI with an XPointer fragment that identifies the resource. The special values ##none and ##all can also be used. |
--process-formulas-file = FILE Specifies a path to a file that contains a list of IDs/XPointers of formulas to execute. In the file, enter one formula per line. |
--report-unsatisfied-assertion-evaluations = true|false Reports the evaluation of unsatisfied assertion as errors or warnings depending on the assigned assertion severity level. The default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--validate-formula-output = true|false Enables XBRL validation of Formula output instance. The default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--variableset-execution-timeout = VALUE Applied when executing formulas (--formula-execution=true). Specifies the maximum time allowed for executing a single variable set (a formula or a value, or an existence or consistency assertion). The time is specified in minutes and must be a positive number. The default is 30min. If a particular variable set doesn’t finish execution before the timeout is reached, then it is aborted. An error message is displayed (and entered in the verbose log). Note, however, that the timeout check is carried out only after every variable set evaluation—and not during execution of individual XPath expressions. So, if a single XPath expression takes long to execute, the timeout limit might be crossed. Execution of a variable set is aborted only once a complete variable set evaluation has been executed. |
|
--aspect-node-order = lexical|instance Specifies the layout order of an open aspectNode. The default is lexical. |
--concept-label-linkrole = VALUE Specifies the preferred extended link role to use when rendering concept labels. |
--concept-label-role = VALUE Specifies the preferred label role to use when rendering concept labels. Default is: http://www.xbrl.org/2003/role/label. |
--generic-label-linkrole = VALUE Specifies the preferred extended link role to use when rendering generic labels. |
--generic-label-role = VALUE Specifies the preferred label role to use when rendering generic labels. Default is: http://www.xbrl.org/2003/role/label. |
--label-lang = VALUE Specifies the preferred language to use when rendering labels. Default is: en. |
--preload-table-schemas = true|false Preloads schemas of the XBRL Table 1.0 specification. Default is false. Note: Boolean option values are set to true if the option is specified without a value. |
--t | --process-table = VALUE Limits formula execution to the given table only. Add the option multiple times to specify more than one table. Short form is --t. The VALUE is either the value of the @id attribute, or a URI with an XPointer fragment that identifies the resource. The special values ##none and ##all can also be used. |
--table = true|false Enables the XBRL Table 1.0 extension. Default value is true. If true, automatically specifies --formula=true and --dimensions=true. Note: Boolean option values are set to true if the option is specified without a value. |
--table-elimination = true|false Enables elimination of empty table rows/columns in HTML output. Default is true. Note: Boolean option values are set to true if the option is specified without a value. |
--table-execution = true|false Enables evaluation of XBRL tables. Default is false. Will be set to true if --table-output is specified. If true, automatically specifies --table=true. Note: Boolean option values are set to true if the option is specified without a value. |
--table-linkbase-namespace = ##detect | http://xbrl.org/PWD/2013-05-17/table | http://xbrl.org/PWD/2013-08-28/table | http://xbrl.org/CR/2013-11-13/table | http://xbrl.org/PR/2013-12-18/table | http://xbrl.org/2014/table Enables loading of table linkbases written with a previous draft specification. Table linkbase validation, resolution, and layout is, however, always performed according to the Table Linkbase 1.0 Recommendation of 18 March 2014. Use ##detect to enable auto-detection. |
--table-output = FILE Writes the table output to the specified FILE. If set, automatically specifies --table-execution=true. |
--table-output-format = xml|html Specifies the format of the table output. Default is xml. |
|
--ignore-taxonomy = VALUE Specifies a taxonomy that should not be referenced by a schema reference in the generated xBRL-XML report. Add this option multiple times to specify more than one taxonomy. |
--json-output = FILE Writes the XBRL data in OIM xBRL-JSON format to file. The File value must be a path to a .json file. |
--oim-xbrl-namespace = NAMESPACE The default namespace used by RaptorXML+XBRL Server is https://xbrl.org/2021, which corresponds to the Open Information Model (OIM) 1.0 Recommendation of 13 October 2021. However, if you are processing OIM documents that were written to conform to a previous draft specification, then you must specify the corresponding OIM namespace to avoid errors. You can use the --oim-xbrl-namespace option to specify that namespace. If you do not know the specification that is used in the OIM document, then use the value ##detect to auto-detect the document's specification and apply the appropriate namespace. Note that, even if a previous specification is referenced in the OIM doc, processing is still performed according to the OIM 1.0 Recommendation. |
--validate = true|false Specifies whether to perform an XBRL validation of the data model. The default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--xml-output = FILE Writes the XBRL data in OIM xBRL-XML format to file. The File value must be a path to a .xml file. |
|
--catalog = FILE Specifies the absolute path to a root catalog file that is not the installed root catalog file. The default value is the absolute path to the installed root catalog file (<installation-folder>\Altova\RaptorXMLXBRLServer2024\etc\RootCatalog.xml). See the section, XML Catalogs, for information about working with catalogs. |
--user-catalog = FILE Specifies the absolute path to an XML catalog to be used in addition to the root catalog. See the section, XML Catalogs, for information about working with catalogs. |
--enable-globalresources = true|false Enables global resources. Default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
|
--error-format = text|shortxml|longxml Specifies the format of the error output. Default value is text. The other options generate XML formats, with longxml generating more detail. |
--error-limit = N | unlimited Specifies the error limit with a value range of 1 to 9999 or unlimited. The default value is 100. Processing stops when the error limit is reached. Useful for limiting processor use during validation/transformation. |
--info-limit = N | unlimited Specifies the information message limit in the range 1-65535 or unlimited. Processing continues if the specified info limit is reached, but further messages are not reported. The default value is 100. |
--help Displays help text for the command. For example, valany --h. (Alternatively the help command can be used with an argument. For example: help valany.) |
--listfile = true|false If true, treats the command's InputFile argument as a text file containing one filename per line. Default value is false. (An alternative is to list the files on the CLI with a space as separator. Note, however, that CLIs have a maximum-character limitation.) Note that the --listfile option applies only to arguments, and not to options. Note: Boolean option values are set to true if the option is specified without a value. |
--log-output = FILE Writes the log output to the specified file URL. Ensure that the CLI has write permission to the output location. |
--network-timeout = VALUE Specifies the timeout in milliseconds for remote I/O operations. Default is: 40000. |
--recurse = true|false Used to select files within sub-directories, including in ZIP archives. If true, the command's InputFile argument will select the specified file also in subdirectories. For example: "test.zip|zip\test.xml" will select files named test.xml at all folder levels of the zip folder. References to ZIP files must be given in quotes. The wildcard characters * and ? may be used. So, *.xml will select all .xml files in the (zip) folder. The option's default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--verbose = true|false A value of true enables output of additional information during validation. Default value is false. Note: Boolean option values are set to true if the option is specified without a value. |
--verbose-output = FILE Writes verbose output to FILE. |
--version Displays the version of RaptorXML+XBRL Server. If used with a command, place --version before the command. |
--warning-limit = N | unlimited Specifies the warning limit in the range 1-65535 or unlimited. Processing continues if this limit is reached, but further warnings are not reported. The default value is 100. |
|