Flat File Format |
Ultriva Import Process can cosume files in Flat file format like TAB or Commma or any other character seperated.
General GuidelinesThis section describes the guideline for the File Name, File Location, and File Contents
File Location
The data is exchanged between Ultriva and ERP through FTP for flat file integration. The File will be placed on the Ultriva FTP Site or Customer FTP Site daily. The URL will be designated prior to implementation.
File Name
Each Interface point must have a unique File naming convention. The name of the file must start with minimum four letters specific to Interface point and then a time stamp must be appeneded. The extension of the file must be txt.
Here is an example for Item Synch process:
ITEM_<year><month><day><hour><minutes><seconds>.txt Year, month, day, hour, minutes, seconds are formatted as 0 padded two digit values. Example: ITEM_080126142510.txt (2008-Jan-26 2:25:10 PM)
Upload Frequency
Each Interface point may follow different upload frequency. Typically bulk load (or master data sync) runs every day once and transaction data interface runs every half hour. This must be defined prior to go Live.
File Contents
The file must be of type text. The file must always have a header line followed by zero or more data lines.
Header Line Format
A header line must always exist as the first line in the file. The line is terminated by either new line character or a combination of Carriage Return/New Line. The line contains all field names for which data is provided and each field name is separated by tab character (or the character which is idenfied as delimited). The actual field name is case insensitive.
Data Line Format
A data line is terminated by either new line character or a combination of Carriage Return/New Line. Each field value in the data line is separated by tab character (or the character which is idenfied as delimited). Each field value must correspond to the header field name in that position. Required field values must be non empty. All field values whether empty or non-empty must be given.
If you have a decimal value then the decimal separator must be same for all data lines and for all files. No group separator may be used.
If you have a string value then please make sure that the string does not have a tab character, new line character or carriage return character. If such characters exist then replace them with space before writing to file. A String value map be encoded in double quotes.