Import Pipeline Series

Use Bridge to import pipeline series in PCS. The import transition file must include fields that you can map to the following required PCS fields:

  • ROW Code

  • Series Number

  • Start Milepost

  • End Milepost

Refer to Set Basic Bridge Definition Properties for more information on creating a Basic Bridge definition.

Complete the following steps to import pipeline series:

  1. Click Tools > Bridge to open the Bridge window. Then click Basic to open the basic definition pane. The Selected ROWs and Bridge Definitions panes can be moved or closed.

    Basic Definition Panel

    Basic Definition pane

  2. Type a unique name for the Bridge definition in the Name field.

  3. Click the Import check box.

  4. If you want PCS to automatically run the import file at a scheduled time, click the Scheduled check box and then click the icon to set up frequency, dates, and times for the schedule. Refer to Set Basic Bridge Definition Properties for additional details on schedules.

    1. When the import file is not scheduled to run automatically, click Importto run it manually.

    2. When scheduling a time to run Bridge, choose a time that does not impact other net work 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 pane:

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

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

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

  6. Click Save and then click Full View to hide the Data Transfer and Options panes. Clicking Full View again displays these panes.

    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:

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

      Data Items - Series

      Data Items - Series

    2. Click OK to close the window and return to the definition pane.

    3. Click Save.

  8. Click the ellipsis button … in the Import File Name field to open the Import File window. Navigate to the import file and then select it. Click Open to close the window and return to the definition pane. The path to the import transition file displays in the 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 pane as required:

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

    2. 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 with fields in the import transition file, follow these steps:

    1. Click Edit in the Maps pane to open a field mapping window.

      Fields in the Mappings pane with are required fields for mapping, such as ROW Code, Series, End Milepost, and Start Milepost.

      Field Mappings

      Field Mappings

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

    3. To map PCS fields with fields in the import transition file, follow these steps:

      • Select a PCS field in the Mappings pane.

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

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

    4. Click Preview to view how the data in the import file would map with the configured mappings. Click Close to close the preview window.

  11. Click OK to close the mapping window and return to the definition window.

  12. Click Save.

    Field mappings display in the Maps pane.

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

    1. If the Bridge Definitions window is open for the import file, click import icon Import.

    2. If the Job Status window is open, click Run for a selected import file listed in the window. Then click Refresh to update status information.

  14. To view the status of a Bridge session, click job status icon Job Status in the Definitions window to open the Job Status window. Click Log for a Bridge session opens the log file for the selected session.

  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 imports this data in the facility Inspections grid (Data Entry > Edit <module> Data).