Skip to content

Exporting Factory Floor Status data

There are two means through which users can export Factory Floor Status data. They can choose to export using the UserClient GUI or by carrying out an auto export (using the command line).

Exports of the AssetState type contain an overview of the Factory Floor Status job.

The export can be output either as a CSV or JSON file.

An authentication token, generated in the AdminClient, is required.

Exporting using UserClient GUI

See here

Exporting using auto export (via command line)

In addition to the keys described in the Parameter file section, the parameter file can also contain the following keys specifically for this export.

Key Description Values
AsInfoType Specifies which data is to be exported from the Factory Floor Status. Safety (default value), Module, Raw

Example call

VDogAutoExport.exe /at:c "/rd:D:\vdClientArchive" "/CFile:D:\Test\AssetState.ini"

Parameter file AssetState.ini (for the value Safety)

[Common]
ReportType=AssetState
AsInfoType=Safety
ExportFile=D:\Test\AssetState.csv
PathRef=D:\Test\AssetStateSafetyRef.csv
ComponentId=1234567890ABCDEF1234567890ABCDEF
Dir=\SmartShopFloor

[User]
Account={User}
Password={Password}

Parameter file AssetState.ini (for the value Module)

[Common]
ReportType=AssetState
ExportFile=D:\Test\AssetStateModule.csv
AsInfoType=Module
ComponentId=1234567890ABCDEF1234567890ABCDEF
Dir=\SmartShopFloor

[User]
Account={User}
Password={Password}

Parameter file AssetState.ini (for the value Raw)

[Common]
ReportType=AssetState
ExportFile=D:\Test\AssetStateRaw.csv
AsInfoType=Raw

[User]
Account={User}
Password={Password}

Overview of the columns that appear in the resulting file

Column Description
JobName Name of the Job
JobId ID of the Job
Component Relative path to the component
ComponentId ID of the component
UploadClass Name of the upload class
Modules Name of the module or target system (dependent on upload class)
Only for AsInfoType=Safety
SafetyChecksum Name of the module or target system (dependent on upload class).
TimeStamp Timestamp at which the checksum was generated (presence depends on the upload class).
Only for AsInfoType=Module
OrderNumber Order number (presence depends on the Upload class)
SerialNumber Serial number (presence depends on the Upload class)
FirmwareVersion Firmware version (presence depends on the Upload class)
HardwareVersion Hardware version (presence depends on the Upload class)
Only for AsInfoType=Raw
Data XML encoded as Base64Buffer of all information available for the Module

Excluding jobs from the filter for device data

  1. Start the AdminClient and select INI files in the menu bar.
  2. In the Edit INI files dialog, select the server.ini file and select Edit.
  3. The server.ini file is opened.
  4. Enter the jobs to exclude in the [AssetState] section using the ExcludeJob{n}={JobId} value. n is the placeholder for numbering from 1 to 65535. It does not have to be sequential. JobID is the ID of the job with exactly 32 characters.
  5. Save the changes and close the file.

Example:

[AssetState]
ExcludedJob1=A1B2C3D4E5F6A1B2C3D4E5F6A1B2C312
ExcludedJob9=A1B2C3D4E5F6A1B2C3D4E5F6A1B2C313