The Loader allows you to use Extensible Markup files (XML), delimited text files (.NLF or .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.
Allows you to load data into SmartPlant Foundation using structured files containing the input data.
Directory - Allows you to select the files for processing. Click 
to browse to the files to load.
Selected Load files - Lists the names of the files to be loaded.
Move Selected Item Up - Moves the selected file up one position. Click 
to move the selected file.
Move Selected Item Down - Moves the selected file down one position. Click 
to move the selected file.
Process Load Files
Name - Displays the name of the load file.
Container - Displays the container to which objects are related.
Created objects - Displays the number of objects created.
Updated objects - Displays the number of objects updated.
Processed instructions - Displays the number of process instructions executed.
Unchanged objects - Displays the number of objects that are unchanged.
Failed objects - Displays the number of objects that failed to load.
Process Time - Displays the amount of time to load the file.
The process time value indicates the server load time only. The actual time spent
processing is often higher than this value.
Put objects in new items window - Displays new objects in the New Items window.
Process - Processes all files in the Selected load files list.
Load Results - Displays the results of the processed load files in the Load Results tree view.