1. Export package for fill up the import data
(1) Select Excel then
(2) Select Export to Excel
Click Yes to continue
Excel file export to system, the file name to structure is "Default_"date/time.xlsx"
Excel file with selected field and existing database record to be export.
NOTE:
(1) DON'T change the package information in Row 1
(2) DON'T change the table field name (i.e. column name) and the column sequence
2. Import package and apply data
Prepare the data for import
(1) Clear all unnecessary item from the excel template (e.g. if no change on the existing record, delete all item from the excel it exported from the system)
NOTE: Please see Configuration Package - Filter Functionto filter out all unnecessary item before export the package
If the item no. in the import file is matched with the item in system, system will update the record according to the import file.
(2) Import excel file to configuration. Select Excel => Import from Excel
(3) Click Choose... to select file for import
(4) Click Import to import the excel file
(5) No. of Package Records to be shows, user can click the link to preview the data
(6) Select “Functions” => “Apply Data”