Using Bridge : Importing Pipeline Series
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:
•
ROW Code
•
Series Number
•
Start Milepost
•
End Milepost
Complete the following steps:
1
Select one or more pipeline segments in the Select ROWs window. Choose pipeline segment(s) with facilities you want to include in the Bridge definition. Click Save to close the window (Figure 10-43).
2
Click Tools > Bridge to open the Bridge window. Then click Basic to open the basic definition panel (Figure 10-49).
Figure 10-49. Basic Definition Panel
3
Type a unique name for the Bridge definition in the Name field (Figure 10-49).
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-50):
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.
Figure 10-50. Bridge Import Definition
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-51):
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.
Figure 10-51. Data Items
8
Identify the location of the import transition file using the following steps (Figure 10-52):
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.
Figure 10-52. Definition
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-53).
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-53 ().
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:
•
Select a PCS Axis field in the Mappings panel.
•
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.
Figure 10-53. Field Mappings
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.
Field mappings display in the Maps group box.
12
To validate the definition, click the Prevalidate button. When the validation process completes and the following message displays (Figure 10-54), 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.
Figure 10-54. Validated Message
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-55). 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.
Figure 10-55. Job Status
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).