1.1 Upload File Formats

This topic provides information on upload file formats.

The external files containing the information that is to be imported from the bulk client are required to be in the following format:

Table 1-1 File Format

File Type	ASCII EXCEL
ASCII file format	Delimited Fixed width
Field delimiter	Comma Tab Colon Semi colon Space
String delimiter	Single quotes Double quotes NULL
Date Format (all dates will have 4 digit years)	DMY MDY DMonY YMD
Date delimiter	/ (Slash) Hyphen (Space) From registry
Decimal symbol	Point Comma
Digit grouping symbol	Point Comma
Negative Sign symbol	Hyphen Parenthesis
Time delimiter	Null Colon Semi colon Space
Column Header on first line	True / False

Note:

Using the client country flag ‘UPLDFILEMODULE’, business can configure to use the module ID in the uploaded file or the logged in Module ID for the User-function access validation.

User-Function access is validated for uploads based on the Module ID, User ID and Function ID.

• If this client country flag is enabled, then the module details provided in the upload file will be used for the User-Function access validation.
• If this client country flag is disabled, then the logged in Module ID will be used for the User-Function access validation.

You can maintain only one sheet in the template. For Excel Upload, the data should be in text format.