Using Bridge : Adding a Bridge Definition : Adding a Bullhorn Bridge Definition

Adding a Bullhorn Bridge Definition
A Bullhorn Bridge definition specifies the property settings and options for importing data in PCS Axis from a user account on the Bullhorn Asset Tracker (BAT) website. It defines how often to run the definition; the unique Key assigned by BAT to the Extract; and field mappings for PCS Axis and data imported from BAT.
After running a Bullhorn Bridge definition, PCS Axis automatically adds the phrase Bullhorn Import in the Inspection Remarks field of the facility data entry grid.
To add a Bullhorn Bridge definition, follow these steps:
Select one or more pipeline segments in the Select ROWs window. Choose pipeline segment(s) with facilities you want to include in the Bullhorn Bridge definition. Click Save to close the window (Figure 10-43).
Figure 10-43. Select ROWs
Click Tools > Bridge to open the Bridge window (Figure 10-44).
Figure 10-44. Bridge
Click Bullhorn to open the Bullhorn definition panel (Figure 10-45).
Figure 10-45. Bullhorn Definition Panel
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.
Click the down arrow in the Time Period field and select how often you want to run the Bullhorn Bridge definition.
Important: When choosing an option in the Time Period field, 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.
Note: Clicking the toggle button in the information bar displays important information related to required property settings.
Click Save and then click Full View to hide the Name, Bullhorn Token, Time Period, and survey folder fields. Clicking Full View again displays these fields (Figure 10-46).
In the center Mappings panel, click the check box Do Not Map for each Bullhorn data point you do not plan to map, such as Battery Voltage.
A check mark inside the check box indicates a selection. To clear a selection, click the check box again to remove the check mark.
Note: Clicking any of the following options allows you to filter records in the Mappings panel based on the selected option: Un-mapped, Marked as Do Not Map, Mapped, and All. For example, clicking Mapped allows you to view only mapped data points in the Mappings panel.
Select a row in the Mappings panel that includes the Bullhorn data point and engineering units you want to map.
Note: To rearrange grid columns in the Facilities, Mappings, or Fields panel, drag and drop the name of a grid column to a new position. To resize a grid column, place the mouse over a column boundary to change the cursor to a horizontal resize cursor . Then click and drag the column boundary to resize the grid column.
In the left Facilities panel, map a PCS Axis milepost to the Bullhorn data point selected in the Mappings panel. Double-click the milepost in the Facilities panel to move it to the Milepost field in the Mappings panel.
Note: Double-clicking a mapped field in the Mappings panel allows you to unmap the selected field. When a message displays, click Yes to unmap the selected field, or No to cancel the operation.
In the right Fields panel, map a PCS Axis field to the Bullhorn Engineering Units field in the Mappings panel. Double-click a PCS Axis field in the Fields panel to move it to the Field column in the Mappings panel.
Repeat steps "a" through "d" as needed and then click Save.
Figure 10-46. PCS Axis and Bullhorn Mappings
To validate the definition, click the Prevalidate button. The Prevalidate process confirms the Bridge definition is set up correctly; it does not post data in the database.
When the validation process completes and the following message displays (Figure 10-47), click View Job Status to open the Job Status window or Return to Definition to open the Definitions window.
Figure 10-47. Validated Message
Click Run in the Definitions window.
When a date range dialog box opens, specify a date range for the data you want to import from BAT. Type a date in the Start Date and End Date fields or click the down arrow in these fields to choose a date using a calendar.
Click Apply to run the Bullhorn Bridge definition and close the date range dialog box.
When the message Completed displays, click View Job Status to open the Job Status window or Return to Definition to open the Definitions window.
Note: PCS Axis adds the phrase Bullhorn Import in the Inspection Remarks field of the facility Inspection data entry grid.
To view the status of a Bridge session, click Job Status in the Definitions window to open the Job Status window (Figure 10-48). 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.
Figure 10-48. Job Status
Click the Definitions tab if the Definitions window is not open.
Click Copy to Clipboard.
Open a new file and then Paste the definition file. Click Save.