Importing worker records

As a Beeline Professional administrator, you can import worker records using the Import Data tool. You can use an import template to upload worker information, edit existing worker records, or offboard workers in bulk.

When creating the worker records file for import, use the template provided by your Implementation Consultant. If you don’t have one, ask your Implementation Consultant to provide it. Alternatively, you can download a previously uploaded template.

Before you begin

  • You must have administrator access to the tenant site you’re setting up.

  • Identify the workers you want to import and gather the information required to create their records.

Steps

To import workers for your program, complete these steps from any supported browser.

  1. Log in to the Professional site you’re setting up.

  2. From the left navigation, go to Home and select Import Data.

  3. From the Data type field, select Worker.

  4. Depending on which template you are using, perform one of the following actions:

    • Locate the template provided by your Implementation Consultant.

    • Download the pre-uploaded template from the Import Templates list.

  5. Open the template file in Microsoft Excel ©. These columns are required for the template:

    • Legal First Name

    • Legal Last Name

    • Personal Email: This displays as the Primary Email on the Worker Profile page.

    • Engagement Status

    • Job Profile Reference Id

    • Classification Reference Id

    • Supplier Reference Id

    • Supervisory Org Reference Id

    • Accountable Person Id: This field is optional if your program doesn’t use accountable persons.

    • Cost Center Reference Id

    • Business Site Reference Id

    • Start Date

    • End Date

    • Timesheets Enabled: Enter TRUE to enable timesheets.

    • Work Schedule Reference Id

    • Holiday Schedule Reference Id

    • Entry Type: You can enter any of the options used in your program. For example, Hours or Clock.

    • Rates: When populating rates, you must import all rates applicable to the engagement. In most cases, this includes Bill Rate, Pay Rate, and, if applicable, Overtime. Each rate name needs the following fields (the example below uses Bill Rate):

      • Bill Rate Amount: Enter the bill amount.

      • Bill Rate Currency: Enter the currency ISO code, for example, USD.

      • Bill Rate Frequency: You can enter any of the options used in your program. For example, HOURLY, DAILY, WEEKLY, BI-WEEKLY, or MONTHLY.

  6. To populate the template, add each worker as a separate entry; for example, one row for each worker you want to add.

  7. Save the populated template with a different file name.

  8. Go to the Import Data dialog and in the Note field, enter a description of your import to help you find it faster in the import monitoring logs and select Continue.

  9. Upload the populated template.

  10. Confirm the column headers by selecting the header row and then selecting Next.

  11. Map the headers from your template to their corresponding fields in Professional and select Next.

  12. Review your data to identify any typos, missing values, or incorrectly formatted data. You can edit your data directly in the dialog. Hover over any highlighted areas to view warning or error details.

  13. Optional: To review any potential errors, turn on the Show only rows with errors toggle in the upper right. If errors exist, you can hover over each error to view advice on resolving it. After you resolve the errors, select Import Data.

  14. Select Import Data to start the import.

After you submit the template, a message confirms you’ve submitted it successfully. The message doesn’t mean the data was successfully loaded in Professional. Check the Notifications area to view the status of your import.

notifications area import status
Figure 1. Example of the Notifications area message

Administrators can select Settings  Monitoring  Import Logs and determine whether the import was processed successfully or find details about any errors. For more information, see Checking the status of an import process.

If the import process fails, make corrections to the template and try again.

Documentation Assistant

Delete Chat Conversation

Are you sure you want to permanently delete the chat history?

Hi, I am Beeline Professional Docs Assistant. Here's how I can help you:
  • Type your question in the input below
  • I'll understand your query and provide a helpful response
  • You can ask follow-up questions