Importing Inventories (Tanks)
The command line syntax and a table of parameters are provided here.
DataLoader.exe -filename=file name –afserver=Server name –afdatabase=AF database name -format=Sigmafine version -type=Tank –adjustment=yes –timestamp=Date Time –dayoffset=Number of days –timeoffset=Time offset –Debug=Yes or No –afmodel=AF Model name –afmodelanalysis= AF Model analysis name
Command Line Parameters – Tanks
| Parameter | Required | Description |
|---|---|---|
| Filename = Drive:\Path\Filename | Yes | Full path name of the data file. Relative file paths are not supported. |
| AFServer = AFServerName | Yes | Name of the PI server that hosts the AF Database. |
| AFDatabase = AFDatabaseName | Yes | Name of AF database that contains the elements used for the imported data. |
| AFModel = AFModelName | No1 | Name of AF Model that contains the elements used for the imported data. If present along with the AFModelAnalysis parameter, this argument specifies that data will be written as inputs to a Case rather than to PI Tags. |
| AFModelAnalysis = AFModelAnalysisName | No1 | Name of AF Model Analysis that contains Cases used for the imported data. If present along with the AFModel parameter, this argument specifies the data will be written as inputs to a Case rather than to PI Tags. |
| Format = Sigmafine4 | Yes | Use the Sigmafine4 keyword to indicate that the file has a Sigmafine 4.x format. |
| Type | Yes | To import tank data, use the “Tank” keyword. |
| Adjustment = yes | Yes | To handle inputs as adjustments. |
| Timestamp = “Timestamp” | No | Local date and time for the data to write data to the PI System archive. The format of the time stamp depends on the Windows regional settings.For example, for English US time stamp use:12/24/2010 14:00:00for the date December 24, 2010 at 2:00 PM.If not supplied, the Data Loader uses the dayoffset and timeoffset arguments. If none of these arguments is used, the Data Loader uses the current local computer time as the time stamp.In the context of a case, the Data Loader uses the first timestamp from the data file that it finds, then updates the existing Case or creates a new Case based on this time stamp. The time stamp must be the same for all records. If the time stamp is not specified in the data file, the Data Loader uses the time stamp from the command line. |
| DayOffset = NumberOfDays | No (See Timestamp) | Use the dayoffset argument to specify the date of the data. This is a relative offset from today.This is a relative offset from today.For example, for yesterday use –dayoffset = -1This number must be negative or zero. |
| TimeOffset = HH:MM:SS | No (See Timestamp) | Use the Timeoffset argument to determine the time of the data. This is relative to midnight.For example, four hours after midnight is represented as: -timeoffset=4:00:00 |
| Debug = YesorDebug = No | No | Use the keyword “Yes” to enable debugging messaging to the PIPC Log file. Use “No” to disable debugging. If not present, debugging is off. |
| 1 The parameter is required with importing values under a case. It should not be used to write values to PI tags. |
Note: For importing analyzer data (component data) in a tank attribute, import it as you would an analyzer Element attribute. See section "Sigmafine 4 Format for Analyzer Data File."