Importing Component Data Tables (Elements)

The following steps provide an example of importing Component Data Tables using the Data Import.

Note: Importing Values into Composition Tracking and Quality Tracking Initialization Tables is a feature supported by the 'Load Any Data Table' option. The 'Load Data Table' option is only maintained for backward compatibility only.

To import Component Data Tables:

1. Double-click on the Data Importer file (Pimsoft.DataImport.exe).

   The Data Importer main window opens.

2. Click on the System down-arrow and select the AF Server or System.

   If the server or system you are seeking does not appear in the drop-down menu, use the ellipsis button to locate and select the correct server or system.

3. Click the Database down-arrow and select the database that exists on the AF Server.

   Only the databases available on the selected server or system will be available in the list of database selections.

   Note: The Databases cannot be modified within Data Importer, nor can new databases be created.

4. Click on the Model down-arrow and select a model.

   Only those Models that exist in the selected database are available.

5. Click on the Analysis down-arrow and select the Analysis Rule for the selected model.

   Only those analyses that exist for the selected Model are available. For our example, we have selected Sigmafine Mass Balance.

6. Click on the Case down-arrow and select the Case to which the data will be imported.

   If the Case you are seeking does not appear in the drop-down menu, use the Search button to locate and select the Case into which you want to import the data. Clicking the Search button opens the Case Search window. See Using Case Search for more details.

7. Under Type, select Element (as shown in the following figure).

8. Check the Adjustment checkbox (as shown in the following figure).

9. Check the Load Any Data Table checkbox for your load table option (as shown in the above figure).

10. Click on the Select Data File Folder button to choose the folder where the Excel file (or .csv file) is located.

    A Browse For Folder window opens.

11. Locate and select the Excel (or .csv) file.

12. Click OK to save your selection and close the Browser For Folder window.

    You are returned to the main Data Importer window.

13. Double-click on the Excel or .csv file to open it and ensure that:

• For Excel; the correct worksheet is active

• For both Excel and a .csv file; the columns and data are in the correct format.

  The specified format can be found under either Import File Format for Analyzers or Import File Format for Tanks and Processes.

  For more information regarding adding Editable Comments to your import file, see Editable Comments for Data Tables.

  Note: While working with Excel Files, it is common to have several Workbooks open at the same time. We recommended that you close all Excel Files and keep them closed, while working with Data Importer. Double-clicking on another Excel file while running the Data Importer will cause a message to appear stating that you need to close the workbook that is being used for the import.

14. (Optional) To view the log from the most recent import, click the View Log button.

15. Click the Import Data button to begin the import.

    When the import finishes, a confirmation window opens.

16. Click OK to close the confirmation window.

17. Click on the View Log button to open the log file in Notepad.

    Any attribute, that does not already exist in the Case into which you are importing, will be ignored (it will not be added). This holds true for any Attribute with a name that differs from an existing Attribute in the case.

18. Close the log file when you are done viewing it.