Connections Dashboard

When you open your Connections Dashboard, the File to Custom Bullhorn Object connection should be located below the Bullhorn to isolved connection. It may be lower on the page if you have more connections set up, but should display the following information under and beside the header File to Custom Bullhorn Object – 

“Failed Records” – this displays the number of records found, within the last 30 days, to contain invalid, unexpected, or missing data, preventing their transfer to Bullhorn. Each row can send multiple different records (i.e. Worker's Compensation, Employer Tax, Health, etc.), so the number of rows needing attention will likely be much smaller than the number displayed. You may click the number to open the File View.

“Successful records” – this displays the number of records in the last seven days that were successfully transferred to Bullhorn. You may click the number to open the File View. 

“Last Run” – this displays the date and time of the connection’s last attempt to transfer data to the Bullhorn custom object.

File View

Clicking the number under Failed Records or Successful Records should open the File View, listing any files that have not been ignored. The File View table can be filtered using the controls at the top-left of the page. Files containing failed records will be highlighted red and display the following from left to right:

• Start date and time of attempted upload to Bullhorn
• End date and time of attempted upload to Bullhorn
• Number of rows containing invalid data and, in parentheses, any rows intentionally filtered out of the upload
• Number of records successfully transferred to Bullhorn
• Total number of records that were unable to transfer

There should also be three buttons on the right side of the screen for each file:

“Go To Details” – opens a detailed view of the data contained in the upload

“Delete from Bullhorn” – undoes the upload by deleting the file's data from Bullhorn

“Ignore this File” – Moves the file to the “Show All” filter, removing it from the others.

Managing Errors

Error management on the custom object connection is typically a 5-step process:

1. Identify a file with errors from the File View
2. Open the file details
3. Note the error/s on the row
4. Correct the data in bulk using the Edit Row Level Data menu or on individual records using the Edit button
5. Select and push the edited rows to Bullhorn

Below is an in-depth example using one of our demo connections.

From the File View, click Go to Details. The following page should open, displaying, in red, the rows that could not transfer to Bullhorn and each record in the row:

In our example, Row 2 has errors on nine records. The Type column describes the data in each record. To fix the errors, make note of the error message displayed under Status. Our example's error is “Placement Number is required but is not populated” for all records in Row 2. Most connections use Placement Number as a Key to determine where to send the data. Since our demo connection uses it as a Key and also as a text field to send to the custom object, the Placement Number will need to be input to two columns. To do this for all records in the row, click the green Edit Row Level Data button*. The following window will appear when Edit Row Level Data is clicked:

*Additional Methods: The blue Edit button on the right side of a record enables input directly to the table for an individual record. Any records not needed for transfer can be aborted by clicking Ignore.

Add the missing data and click Apply to Records. The data should populate in the background. Click Close.

To push all records associated with a row to Bullhorn, click the checkbox next to the Status column and then click the blue Push Selected for Row button.**

**Additional Methods: To push an individual record, click the checkbox on the far left of the record and click Push Selected for Row. Records selected across multiple rows can be pushed at once using the Push All Selected button near the top of the page. 

Successfully pushed records will turn green and note their send-out time in the Status column:

When the page is refreshed, any sent records should disappear. To see sent records again, click Show All Rows near the top of the page. Sent records should appear in white.

Our example has successfully sent its data to Placement #55's Bullhorn custom object. In the File View, the file is white and displays 0 failed records, indicating all data was uploaded to Bullhorn:

We've successfully cleaned the file and transferred our data!

Closing Note on Errors: Most custom object errors can be corrected by either filling in missing data or correcting invalid data, then sending the record. If an error says 500 Internal Server Error or exceptionMessage: The server was unable to process, it can likely be selected and sent again without change, as the error was probably caused by a lapse in internet connectivity rather than invalid data.