Bulk Upload Locations

Follow these steps to upload locations in bulk.

To upload your locations:

  1. On the Locations Management screen, click Bulk Upload Locations.
  2. On the Locations screen, click the link to download the sample locations template and save the file on your computer.
  3. The first row in the spreadsheet is the row that determines where your data belongs in the database.

    Enter the data in the spreadsheet. The listing below does not enumerate all of the fields in the sample template, just those that you need a little more detail on.

    • location_name: This name must be unique and cannot already exist in the system.

    • company: The company value must exactly match an existing company name in your organizational structure.

    • country_abbreviation: The abbreviation used must exactly match an abbreviation in the system. For example, USA will result in an error if US is the abbreviation used by the system.

    • location_group: This is not a required field, but if it is completed, the value in the cell must exactly match an existing Location Group name in the system.

    • location_business_partner_email: While this is not a required field, this is the field that allows the administrator to designate a default recruiter for the location being uploaded. The email address in this cell must exactly match an existing user in the system so the recruiting user can be assigned. If there is no match in the system, an error will occur.

  4. After you have completed the required fields, save the file on your computer.
    Note:

    You must save the file in the same CSV format in which you downloaded the file. A TXT or XLS format will not upload correctly to our system.

  5. Go back to the screen in the system, and click Browse to find the file you just saved.
  6. Click Upload.