eLearning is available for this topic. Check it out here: HxGN SDx® | Administration | Using the Loader
The Loader allows you to use Extensible Markup files (XML), delimited text files (.TXT files), or Microsoft Excel files to import data, relationships, and configuration information into the database.
System administrators use the Loader to perform the following tasks:
-
Import the SmartPlant schema into the system administration database when the SmartPlant schema changes.
-
Export the data in the SmartPlant schema to an .XML file in preparation for reloading the schema.
-
Delete everything specific to the SmartPlant schema from the system administration database tables in preparation for reloading the schema. However, deleting the SmartPlant schema does not delete users, methods, and so on that are not loaded with the SmartPlant schema.
The Loader command allows you to process XML and text load files to add objects and relationships to the database. After the load files have been processed, you can view your load results and exceptions report from the Load Results window.
The Loader connects with the data warehouse, administers the load, applies lifecycle information, performs error handling, and creates reload files. This utility acts as a middle tier between various data sources and the calling program objects. The Loader reduces the number of load programs by reusing the calling program objects directly.
The Loader interface contains the following areas: the Directory area where you can browse and select your files to load; the Selected load files area with up and down arrows to allow you to control the load order; and the Processed load files area where you can view information about the processed load files.
