You can name the file to best meets your needs, but there are other requirements for the format which are covered in this section. The file you import will contain multiple records, each having a CR/LF (carriage return/line feed) at the end and an “H” or “D” as the first character. Records with an “H” at the beginning are header or master records, and subsequent records with a “D” at the beginning are the detail lines (sometimes referred to as “child lines”) for that header record.

The external text file must be in one of the formats supported by Denali:

Any dates in the external file that you want to import must be in a specific format that uses a separator to distinguish the day, month, and year. With the exception of colons and semi-colons, you can use any symbol such as a forward slash or an asterisk as the separator. For example, if you want to import the date February 19, 2012, you could format it as 02/19/2012.

The file format sample contained in this topic is for reference purposes only and might not reflect the same type of information as your text file(s). Refer to Format Requirements for the Import/Export Feature and select the module you are importing data to for a list of the required fields and the order of the fields.

 

 

 

To view the requirements for your file format before importing transactions, refer to Use the Export Feature to View File Formats.