Support: +84 93 400 3416    Email: support@4bzsoftware.com

Register

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.
  1. 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.
  1. All 4 steps can be run without user interaction if predefined.
  2. Import data with dimension values.
  3. Smart Choose Database Table by Sheet Name or predefined in Excel file.
  4. Save time with auto map Excel Headers to nearest Fields Name/Caption.
  5. Support insert new records only or update existed records only or both insert and update.
  6. Field Validate trigger: can be invoked separately or skipped.
  7. Record OnInsert and OnModify triggers: can be run or skipped.
  8. 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.
  • ...
  1. Support Web Client.

 

Price:

 

  • Apply per NAV License.
  • Not include NAV Objects Fee if needed.
  • Order for First Year: 1080 USD/Year + Transfer Fee 5.5%.
  • Renew yearly, from Second Year: 180 USD/Year + Transfer Fee 5.5%.
  • Upgrade Tool License: free.

 

Click to share  

Universal Excel Import Export Universal Excel Import Export

According to demand and the beauty of simplicity, we developed “Universal Excel Import Export” for new NAV Systems. With our tool, users manage...

10/ 10 - 3322 phiếu bầu

Back Back      Đã xem Viewed: 11586
Support online

  +84 90 286 3390

 

Chat With
Supporter live:4bzsoftware
Contact Information

Havinh Tower F2, 57 Nguyen Van Giai,
District 1, Ho Chi Minh City, Vietnam

 

+84 93 400 3416
support@4bzsoftware.com
 

Google map view
Click here to view


Receive news and offers

 Please enter your email below
 to receive news and offers from us
 

Copyright © 2015 4BzSoftware.com. All rights reserved.