1. Implementing Product Management
  2. Import Data from Item Management Interface Tables to Item Management Production Tables

Import Data from Item Management Interface Tables to Item Management Production Tables

At this point in the import process, the data is loaded into the Item Management interface tables and is ready to be moved into the Item Management production tables.

You can use the Item Import scheduled process to move this data to the production tables. This process performs all the validations necessary to ensure that the data is correct prior to moving the data into the production tables. After successful completion of this process, the data will be available in the user interface.

To move the data from the interface tables to production tables:

  1. From the Navigator link, go to Tools and click Scheduled Processes.
  2. Click Scheduled New Process.
  3. In the Schedule New Process dialog box, select the following:

    • Type: Job

    • Name: Item Import

  4. Click OK.
  5. In the Process Details dialog box, enter item import for the import process.
  6. Specify the following information in the Process Details dialog:

    • Batch ID: Enter a unique identifier of the batch used to import the items. It should be the same as the batch ID in the FBDI excel file.

    • Process All Organizations: Select Yes to import items from all organizations. Select No to not import items from all organizations.

    • Process only: Indicate which transaction-type records need to be processed for an item batch. Values are Create, Sync, or Update.

    • Delete Processed Rows: Indicates if the rows in the interface tables must be deleted after the processing of an item batch. Values are Yes or No.

  7. Click Submit to start the process.

    A configuration dialog box is displayed with the process ID. Make a note of the ID.

  8. Multiple processes are created for all the steps in importing the item. Various child process such as Preprocessing, Data Quality Matching, Gather Stats, Definition-Reference Org Processing, Item Import and Post Item Import are involved.
  9. View the log file for any errors (if applicable), by selecting the row in the Search Results table and clicking View Log.

    Successfully imported items and related child entities can be queried, modified, and validated.

Related Topics