EXPORT IWO ALLOCATIONS

Use this screen to export IWO allocations. The export process does not actually move the data into the receiving database. Rather, it creates three Comma-Separated Value (.csv) files and a schema.ini file. The files are named by the export process and use the receiving location code as owner of the tables. The files created are for the allocation header, transaction, and labor tables. The scema.ini file is the "blueprint" that identifies the table structure and access rights.

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 system. See Special Topic IW-1, "Data Source Installation," for complete installation instructions.

Use this screen only for those IWO processes that involve transfer of projects to external databases. This is the seventh step for external transfers. Once you are satisfied with your selection of IWO allocations, use this screen to export them.

Select Receiving Location

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

Range Option

Use the 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.

Output Path

Select

Click this button to select the directory in which you want the export files created, or enter the file path in the field to the right.

Process

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

If you have files in the designated directory for the same location as the one to which you are now exporting, you will receive a message stating "Output files for location XXX will be overridden. Continue?" You CANNOT rename the file or append an existing one. If you have multiple entries going to the same receiving database, you must import one before exporting the next because the system names them automatically using the receiving location.

Process/Print

Click this icon on the toolbar to print the report and then post.