Appendix > Appendix > Format Requirements for the Import/Export Feature > File Formats Supported by Denali for Importing Data
File Formats Supported by Denali for Importing Data
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:
Column Position File (fixed length): Each field in the text file starts at a specific position and contains a fixed number of characters. This file type is sometimes referred to as “fixed length”.
Tab Delimited File: The fields in the file to be imported are separated by tabs.
Comma Delimited File: The fields in the file to be imported are separated by commas.
Semi-Colon Delimited File: The fields in the file to be imported are separated by semi-colons.
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.
This image is applicable to Accounts Payable, Accounts Receivable, and General Ledger. Click thumbnail for a larger view of image.
 
This image is applicable to Inventory. Click thumbnail for a larger view of image.
 
This image is applicable to Payroll. Click thumbnail for a larger view of image.
 
To view the requirements for your file format before importing transactions, refer to Use the Export Feature to View File Formats.
Published date: 06/04/2021