The data import or export of process instance-independent data series is executed using the command line program runpikidata:
runpikidata -user <user name> -password <password>
[-client <name>]
-mode (import|export|delete)
[-compatible4]
-file <file1>[,<file2>...]
[-format {XML|CSV|XLS} [-csvchar "<character>"
[-encoding "<encodingname>"]]]
-pikicube <cubename>[,<cubename>...]
-ps <filename>
[-sheet <name>[:<cell>] [<name>[:<cell>]]]
[-version]
[-language <ISO code>][ protocoloptions ]
[-recoveryfile {yes|no}]
-user <user name> Name of user
-password <password> User password
-client <name> Name of client If
no client is specified
the server of the
default client will be used.
-language <ISO code> Import language
-mode (import|export|delete) Import, export,
or deletion of data
-compatible4 Import of dimension values as
in PPM 4.x without checking the
refinement level
-file <file1>[,<file2>...] Import files (-mode import)
or export files
(-mode export).
ZIP files are supported.
-format {XML|CSV|XLS} Data format for the import
(default: XML)
-csvchar "<character>" Data separator for the
"CSV" import format
(Default: comma)
-encoding "<encodingname>" Encoding of the CSV file
(default:
Default encoding for
workstation)
-pikicube <cubename> Data series from which data
[,<cubename>...] is to be deleted or
exported (-mode delete|export)
-ps <filename> Paramset specifying the
data to be deleted (-mode delete)
-sheet <name>[:<cell>]> Specifies Excel sheets for the
"XLS" import format. The
cell specifies the position from
which the data is to be
imported.
-recoveryfile {yes|no} Creates after successful
import the new
process analysis-relevant
analysis server recovery files
Default: yes)
-version Version number of the application
and the database database schema
protocoloptions can consist of the following instructions:
-protocolfile <file name> Log to file
<file name<
-information {yes|no} Logging of
information
-warning {yes|no} Logging of warnings
-error {yes|no} Logging of errors
-version
The version of the PPM software and the database schema are output on the console. Other arguments are ignored.
-user <user name> -password <password>
With this parameter, you specify the user name and the password of the PPM user who is executing the import. The user must have the Data import function privilege.
-client <client name>
With this parameter, you specify the PPM client in whose database schema the imported process fragments are to be saved. If you do not use this option the default client is used.
-mode import|export|delete)
For example, with this parameter you specify that you want to import (-mode import -file <file1>[,<file2>...]) a source file (or several source files) including data of the selected import format (-format {XML|CSV|XLS}) or export (-mode export -pikicube <cubename> -file <filename>) data of a data series existing in the PPM system into an XML file, or that you want to delete entirely (-mode delete -pikicube <cubename>[,<cubename>...]) or in part (-mode delete -pikicube <cubename> -ps <filename>) data from the specified data series.
-compatible4
With the optional parameter, you specify that when importing values of referenced, multi-level text dimensions (refdim) the refinement level (refinement) of the import data will not take place, just as in PPM versions 4.x. This is necessary if dimension values of process instance-independent measure import data for PPM from version 5 exist with a refinement level other than the one specified in the definition of the data series (see technical reference PPM Customizing).
-file <file1>[,<file2>,…]
With this parameter you specify the import file(s) and the path to the import file(s). The source file can be a ZIP file, which contains one or more import files with the same data format.
-format {XML|CSV|XLS}
With this parameter you specify the data import format used.
-csvchar <character>
With this parameter you specify the separator for data field values in CSV import format (default value is the comma).
-encoding "<encodingname>"
With this parameter you specify the name of the optional CSV encoding you want to use. By default, encoding CP-1250 is used for CSV files under Windows.
-sheet <name>[:<cell>]>
With this parameter you specify the name of the Excel worksheet from which you want to import the data. You can specify the names of multiple worksheets, separated by spaces. The <cell> argument can be used for each worksheet to specify the relative start position (cell containing the name of the data series) from which the data is to be imported.
-recoveryfile {yes|no}
With this parameter you specify if analysis server recovery files relevant for process analysis are to be created after import or deletion of values of process instance-independent data series. The default value is yes.