The Smart Production Excel Interface is a simple tool for importing data into the database. The columns in the interface can be modified to meet your needs, so that only the data you actually use is included. The column order can also be easily changed so that the data from an external system can be just copy pasted to the interface Excel sheet. The overall workflow is:
-
Modify the definition and insert Excel sheets.
Modify the definition to match the data from the external system. Then insert the Excel sheets according to the definition to create the interface excel sheets. This needs only to be done once when interfaces are taken into use and is usually done by the support personnel.
-
Copy and check data.
Copy the data from an external system to the interface Excel sheet. Then use the Check Data functionality to ensure that the data is valid, that is, the material used in the order exists in the database.
-
Import to DB.
After the data is checked, it can be imported to the database.
Customer Support
Hexagon Policy Against Software Piracy
Copyright 2017-2021, Intergraph Corporation and/or its subsidiaries and affiliates
Version 20
Published Friday, December 9, 2022 at 2:54 PM