Data interface requirements > Meta data (trigger file)

Meta data (trigger file)

File name control.csv
Importance Required
Description Information about the interface and data extraction.
This data must be artificially constructed.
To ensure that NETSTOCK does not begin the batch process before complete files are available, it is necessary to provide either MD5 checksums (preferable) or validation totals.
Example data
INTERFACE_VERSION,2.0.8
EXTRACTION_DATE,2014/11/06
EXTRACTION_TIME,13:32:59
HOST_SYSTEM_NAME,TheERPname
HOST_SYSTEM_VERSION,36A
MD5_STOCK,07f7251c325609f41dddec3a948e06a0
MD5_SALES,7070be3d7c8196bd958b35254d3732ba
        
 

Columns

Pos Name Type Importance Description
1 Key Char Required A name to identify the type of data in the Value field
2 Value Char Required The value relating to the Key field

Keys

Key Importance Value
INTERFACE_VERSION Required The data interface version
Current version is 2.0.8
EXTRACTION_DATE Required The date when the data is extracted
YYYY/MM/DD FORMAT
EXTRACTION_TIME Required The time (in 24-hour format) when the data is extracted
MD5_SALES Preferred MD5 checksum value for the sales.csv file
IF MD5 VALUES CANNOT BE PROVIDED, USE VALIDATION TOTALS INSTEAD
VALIDATION_STOCK If Applicable Sum of "Stock on Hand" (column 4) in stock.csv
VALIDATION TOTALS MUST PRECISELY MATCH THE DATA PROVIDED IN THE REFERENCED FILES
VALIDATION_SALES If Applicable Sum of "Sales Quantity" (column 7) in sales.csv
VALIDATION TOTALS MUST PRECISELY MATCH THE DATA PROVIDED IN THE REFERENCED FILES
HOST_SYSTEM_NAME Preferred The name of the host system (e.g. ACCPAC)
NETSTOCK will advise of the precise value to use for each system
HOST_SYSTEM_VERSION Preferred The version of the host system