Universal Excel Import Export

Universal Excel Import Export

Download Tool and Document

According to demand and the beauty of simplicity, we developed “Universal Excel Import Export” for new NAV Systems. With our tool, users manage to import/export master data, sales, purchase, financial data … via Excel files.

Watch all videos at YouTube

Main features of Universal Excel Import:

1. Export data to Excel:

• Support export data with Dimensions.
• Select and arrange desired Fields to export.
• Adjust auto Excel Format Value.
• Filter data before exporting, including Normal, FlowField and FlowFilter Fields.
• Define Excel Data Header Caption, Excel Sheet Name.
• Set Number of Rows to be exported.
• Indicate Excel Top Left Cell, and include/exclude Header.

2. Simply import data from Excel with 4 steps:

• Step 1: Browse Excel file.
• Step 2: Select Excel Sheet.
• Step 3: Choose Database Table.
• Step 4: Review auto mapped Fields.

3. All 4 steps can be run without user interaction if predefined.
4. Import data with dimension values.
5. Smart Choose Database Table by Sheet Name or predefined in Excel file.
6. Save time with auto map Excel Headers to nearest Fields Name/Caption.
7. Support insert new records only or update existed records only or both insert and update.
8. Field Validate trigger: can be invoked separately or skipped.
9. Record OnInsert and OnModify triggers: can be run or skipped.
10. Flexible settings in Excel file to adapt your business requirements:

• Constant Values such as #Const;GENERAL#Const;100.
• Auto Number such as #AutoNum#AutoNum;10000;10000.
• Not Import Columns such as #NotImport.
• Not Validate Columns such as #NotValidate.
• Not Insert New Record such as #NotInsert.
• Not Modify Existed Record such as #NotModify.
• Predefined Table ID/Name/Caption such as #TableID;18#TableName;Customer.
• Skip Field Mapping such as #SkipFieldMapping.
• ...

11. Support Web Client.

Price:

• Apply per NAV License.
• Not include NAV Objects Fee if needed.
• Yearly License Price: 1,170 USD/Year + Transfer Fee 5.5%.