Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. After login the web client. Select the Home menu and open the Settings menu.
    - Login detail can reference this quick guide.


  2. All needed functions are shown in the left navigation menu.


  3. Select the Configuration package button to open it.


  4. Select the "Item" package to open it.


  5. Select the tables which use to create items. Select the Excel menu of the Tables ribbon and click the Export to Excel button to export the item import data file as of the template.


  6. Click the Yes button to continue and wait for the system to generate the file.


  7. Select a location to save the file.


  8. Follow highlighted columns and fill in related data on that column.
    Note: Can't change anything of the top 3 rows. Otherwise, it can't import.
    注意: 匯出匯入的檔案不能修改它前3行的任何資料。 否則系統無法讀取相關檔案


  9. After saving the file, Select the Excel menu of the Tables ribbon and click the Import from Excel button to import the file. Or select the Home menu and click the Import from Excel button.


  10. Click the Choose... button and select the file to import.



  11. The system will show how much data has been imported into this package and waiting to apply the change.


  12. Select the Functions menu of the Tables ribbon and click the Apply Data button to create/update selected tables data. Or select the Home menu and click the Apply Package button.
    If using the Apply Package button please pay attention to another table of imported data that didn't apply yet. Otherwise, when clicking the Apply Package button will import all data of that package.


  13. It will show the result of this import file.


  14. If everything is alright, the No. of Package Errors columns won't show any number and vice versa.
    The System will check the data correctly from the import process.


    Secondly, the system will check the data on apply data process.


  15. Click the error number will open the error detail page. It can show the error detail of that data
    Image Added

  16. Select the record and click the Show Error button to check the error message.
    Image Added

    If the message can't show the full sentence, move the cursor to the Error Text it will show complete text.
    Image Added
  17. Update the error data and import again. (If the import data error occurred, normal data will creating/updating data to the system as well)
    Repeat steps 9 - 13 to import the data file.