GL Import/Export window
You can import or export certain information in Denali. Use this window to specify the type, format, and location of the information you want to transfer.
Caution: Be sure to back up your data before you use this option so you have a record of transaction details before you delete them.
Import/Export 
Select the type of transfer you want to perform from this drop-down list.
File Definition 
Select the type of information you will transfer with this process. The options available in this drop-down list vary depending on the module from which you opened this window. Use the drop-down, or type the first few characters in the field to choose the definition you want to use.
GL Account(s): this option imports/exports General Ledger account data to/from the master record and does not include amounts or balances. If you are importing data, you will have the transfer methods of Append Only, Update Only, or Update & Append. If you are exporting data, the transfer methods are unnecessary and unavailable.
GL Account(s) with Balance Forward: this option imports General Ledger account data only to existing master records and includes forwarding balances. If you are importing data, only the Append Only transfer method is available with this file definition. This import option is only available if you have not yet selected the Balance Forward Entries Completed check box in the GL Module Preferences window. If you are exporting data, the transfer methods are unnecessary and unavailable.
Transfer Method 
This field is only available if you select Import as your transfer type. Use this option to set the type of import transfer you want to do. Depending on the file definition you chose, all or some of the following options are available.
Append Only: this option only adds new data to the table. If you selected AP Vendor(s) with Balance Forward from the File Definition drop-down, this option is selected by default and you cannot change it.
Update Only: this option only updates existing data in the table.
Update & Append: this option updates existing data and adds new data to the table.
For more information about data tables, see Viewing Table Information.
Column Position File (Fixed Length) 
Each field in the file to be imported/exported begins 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/exported are separated by tabs.
Comma Delimited File 
The fields in the file to be imported/exported are separated by commas.
First Row is Column Header 
This option is only available when you import information. If the file you are importing contains column headers, you need to select this check box to indicate this.
Input/Output File 
You can type the path to the transfer file location or use the Browse button to locate the file.
Browse 
Use the ellipses button to locate the file and insert its file path into the Input/Output File field.
Import/Export Log 
The name of this text box depends on the type of transfer you select. This text box displays the fields that are being imported/exported, any errors associated with the transfer, and a message showing that the transfer was successful. When the process is complete, you can print the log using the Print Log button.
Server Name/Table Name label 
This label is at the bottom of the window and displays the server and table name(s) that are being imported or exported.
Begin Import/Export 
The name of this button depends on the type of information transfer you selected in the Import/Export field. Once you complete the information in this window, you are ready to import/export data. Select this button to start the import/export process.
After you select this button, the status of the process will display in the Import/Export Log text box and all buttons, except the Cancel button, will be disabled until the process is complete.
Print Log 
If you want to print a copy of any messages that appear in the Import/Export Log text box, select this button.
 
 
Published date: 03/18/2020