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 schema.ini file is the "blueprint" that identifies the table structure and access rights.

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

There are two ways to work with export files in Costpoint:

If you decide to use the first option, click in the File Location field to select the alternate file location to which you want to save the files. If you choose the second option, leave the File Location field blank when you export the files.

Location

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Receiving Location

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

Option

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

The default for this field is All.

Start

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 is inactive.

End

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 is inactive.

Generate

File Location

Enter the location of the files you are exporting. There are two ways to do this:

or

If you have files in the designated directory for the same location as the one to which you are now exporting, you 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 Costpoint names them automatically using the receiving location.