Importing Pipeline Series

The following procedure explains how to use Bridge to import pipeline series in PCS Axis. The import transition file must include fields that you can map to the following required PCS Axis fields:

1 Select one or more pipeline segments in the Select ROWs window (Figure 10-62). Select pipeline segment(s) with facilities you want to include in the Bridge definition. Click

Save to close the window.

2 Click Tools > Bridge to open the Bridge window. Then click

Basic to open the basic definition panel (Figure 10-63).

3 Type a unique name for the Bridge definition in the Name field (Figure 10-63).

Note: Clicking the Bridge Definitions bar collapses the panel allowing you to view more of the definition panel. Clicking the bar again expands the panel.

4 Set properties in the Data Transfer group box in the following manner:

a Click the Import check box.

b If you want PCS Axis to automatically run the import file at a scheduled time, click the Scheduled check box and then type a scheduled time in the adjacent field. Enter a scheduled time using 12-hour time format to specify the hour, minute, and AM/PM setting (HH:MM AM or PM).

When the import file is not scheduled to run automatically, you can run it manually by clicking the

Import button.

Important: When scheduling a time to run Bridge, choose a time that does not impact other network services or computer resources. For example, consider a staggered time schedule instead of running Bridge at the same time as other scheduled network services.

5 Set properties in the Options group box as follows (Figure 10-64):

a Click the Public check box if you want the import definition file available for use by all PCS Axis users. When the check box is empty, the definition file is available only to the user who creates it.

b Do not enable the option Use Facility Key. It is not required to import pipeline series. See Using a Facility Key in Bridge for more information if needed

c If you plan to run the Bridge definition manually and want Bridge to rename the file after importing data, click the check box Rename files on manual bridge runs.

6 Click

Save and then click

Full View to hide the group boxes Data Transfer and Options. Clicking Full View again displays these group boxes.

Note: Clicking the

toggle button in the

information bar displays important information related to required property settings.

7 Click

Add Data Item to open the Data Items window and then complete the following steps (Figure 10-65):

a Open the System Items folder and then double-click Series to move the data item to the right pane of the window.

b Click

OK to close the window and return to the definition panel. Then click

Save.

8 Identify the location of the import transition file using the following steps (Figure 10-66):

a Click the ellipsis button … in the field Import File Name to open the Import File dialog box. Navigate to the import file and then select it.

b Click Open to close the dialog box and return to the definition panel. The path to the import transition file displays in the field Import File Name.

9 To assign inspections to a survey folder based on the inspection date, complete one or both of the following steps in the Options group box as required (Figure 10-8):

a If you want to assign inspections to an annual survey folder, click the check box Assign inspections to an Annual Survey.

b If you want to assign inspections to a periodic survey folder, click the check box Assign inspections to a Periodic Survey.

10 To map fields in PCS Axis with fields in the import transition file, follow these steps:

a Click

Edit in the Maps group box to open a field mapping window (Figure 10-67).

Note: Fields in the Mappings panel with a lock icon

are required fields for mapping, such as ROW Code, Series, End Milepost, and Start Milepost shown in Figure 10-67 (page 554).

b If you want to sort import fields listed in the Transition Fields panel in alphabetical order, click the check box Sort Alphabetically.

c To map PCS Axis fields with fields in the import transition file, follow these steps:

• Map the selected field to a field in the import file by double-clicking a field listed in the Transition Fields panel. Repeat this step for remaining fields.

Note: When the

Auto Map button is enabled and the names of fields in the import transition file match those in PCS Axis, double-clicking a PCS Axis field in the Mappings panel automatically maps to an import field listed in the Transition Fields panel.

d If you want to preview fields for mapping in the import transition file, click the

Preview button to open the import file in the Preview Maps window.

11 Click

OK to close the mapping window and return to the definition window. Then click

Save.

12 To validate the definition, click the

Prevalidate button. When the validation process completes and the following message displays (Figure 10-68), click

View Job Status to open the Job Status window or

Return to Definition to open the Definitions window.

Note: The Prevalidate process confirms the definition file is set up correctly; it does not post data in the database. Only the first 1,000 records of the import file will be displayed.

13 To manually import the Pipeline Series in PCS Axis, complete one of the following steps:

a If the Job Status window is open, click

Run for a selected import file listed in the Job Status window (Figure 10-69). Then click

Refresh to update status information.

b If the Definitions window is open for the import file, click

Import.

14 To view the status of a Bridge session, click

Job Status in the Definitions window to open the Job Status window. Clicking

Log for a Bridge session opens the log file for the selected session.

Note: For a description of the icons and colors used in Job Status, see Icons and Colors Used in Bridge Job Status.

15 To view the imported Pipeline Series, click Data Entry > Pipeline Series.

When the import transition file includes facility survey readings that have also been mapped in the Bridge definition, PCS Axis imports this data in the facility Inspections grid (Data Entry > Edit <module> Data).