Import External Structures

With this function you can import external structure files using an import structure specification and, if necessary, lookup tables. You can import several structure files at the same time for the same structure type.

You can also import structures from staging tables. When you have defined which structure files you want to import and with which import specification these are to be loaded, you can view which files are in the import queue. From this window you can:

  • Import one file at a time
  • Add more files to the queue and import them all at once
  • Look at the files in the queue
  • Delete the files from the queue.
Note: If you import several files containing more than one definition code within a structure, only the last imported definition will be saved, since structure code imported earlier will be overwritten.

Before you begin

To open this menu option, you have to select Single Mode.

Procedure

  1. On the Transfer menu, click External Structures/Import.... The Import External Structures window opens.
  2. From the Structure drop down list box, select the structure type that is to be imported. The available structure selections are Account structure, Company structure, Dim 1, Dim 2, Dim 3, Dim 4 and Currency rates.
  3. From the Import Specification drop down list box, select the import structure specification to use for importing the import file.
  4. If you are importing structures from staging tables, select File Provider. This file is not in use if you are importing from flat files.
  5. If you are importing from a flat file, in the Import File text box, enter the path and name of the file to import or click the Show Valid Choices button and select the relevant directory and file. This field is not in use if you use an import specification with staging tables as source.
  6. If you want to import several external files in a row, click the Add to Queue button. Note that if you use an import specification with flat files as a source, you can use a wildcard (*) to select all files starting or ending with a specific character.
  7. Click the Run button to start the import. A message box appears when the import is ready.

    If you are importing structures through an import specification based on staging tables, all available batch jobs with status On Hold will be displayed. Select the job you want to import and press Run. For more information about how to trigger import of structures from an external application, see Importing Data from an External Application

Results

  • It is recommended that the database optimization is run following an external structure import of the company structure.
  • Click the View the Current Queue button to view a list of all files in queue for import.