IMPORT IWO ALLOCATIONS

Use this screen to import IWO allocations. Once the IWO transactions have been exported from the sending database and exist as .csv files, you must import them into the receiving database. The data exported now exists, not in Costpoint-owned tables, but in tables owned by the receiving location. For example, if the receiving database location code is PARIS, the exported tables will be PARIS_H.csv (Header), PARIS_T.csv (Transaction), and PARIS_L.csv (Labor). Use the Import IWO Allocations screen to move the data to Costpoint-owned tables. The schema.ini file contains the table structure mapping for this process. After the import process is complete, the data resides in IWO_ALLOC_XXX_SUSP (suspense) tables.

Before running the export and import processes for the first time, you must run a utility in the Costpoint directory that creates the Import and Export data sources used by the application. See Special Topic IW-1, "Data Source Installation," for complete installation instructions.

Once you are satisfied with the export of your IWO tables, use this screen to import them to the receiving database. This screen is step eight. If the IWO transfer is within the same database, this screen is not necessary.

Select Sending Location

Use the fields in this group box to enter the sending location of the IWO transfers.

Range Option

Use this drop-down list to select the range of locations that you want to process. Valid options are:

All
One
Range
From Beginning
To End

The default for this field is All.

From

Enter the starting location for the range you want to process. If you select All or From Beginning in the Range Option field, this field will be inactive.

To

Enter the ending location for the range you want to process. If you select All, One, or To End in the Range Option field, this field will be inactive.

Input Path

Select

Click this button to open a window that you can use to browse for the files, or enter the file path in the field to the right.

Process

Click this icon on the toolbar to begin the import process.