Importing Users into Your ATS

Multiple users can be imported into your ATS instead of needing to add them individually. The importing of users can be accomplished by uploading a supported file with the proper formatting of the users. 

Supported Files

To simplify the process, we have included support for the most common file formats listed below which do not require any other manipulation from Microsoft Outlook and Linkedin

Outlook Contacts Export File

Export your contacts from Outlook and upload the resulting file into Arcoro. We have taken steps to ensure that our system "understands" this Outlook export format (.CSV) and will locate the proper fields and information from your list.

This type of file will not include User Roles, Additional System Responsibility fields, or SSO User Names. You will need to open the CSV export file to add additional required columns/fields. For more information about required fields, you can refer to the information in the Manually Created CSV File section.

If you are unfamiliar with exporting contacts from Outlook, you can expand the appropriate section below.

Exporting Contacts for Outlook Desktop App for Microsoft 365 (As of 7/2022)
  • Click File.

    Outlook_-_00.png

  • Click Open & Export and click Import/Export.

    Outlook_-_02.png

  • Select "Export to a file" and click Next.

    Outlook_-_03.png

  • Select "Comma Separated Values" and click Next.

    Outlook_-_04.png

  • Select "Contacts" for the email account that you want to export contacts from. Click Next.

    Outlook_-_05.png

  • Browse where you want to save your contacts CSV file. Click Next.

    Outlook_-_08.png

  • Click Finish.

    Outlook_-_09.png

  • Review your CSV file after it has been created.
Exporting Contacts for Outlook Web App (As of 7/2022)
  • Click the People icon on the left-hand side.

    Outlook_-_People_-_00.png

  • Click Manage and click Export Contacts on the right-hand side.

    Outlook_-_People_-_01.png

  • Use the drop-down menu to specify to export all contacts or only contacts from a specific folder. Click Export.

    Outlook_-_People_-_02.png

  • Download and review your contacts.csv.

LinkedIn Contacts Export File

Export your contacts from LinkedIn and upload the resulting file into Arcoro. We've taken steps to ensure that our system "understands" this LinkedIn export format (.CSV) and that we'll locate the proper fields and information for your list.

This type of file will not include User Roles, Additional System Responsibility fields, SSO User Names, or some emails depending on a user's LinkedIn settings. You will need to open the CSV export file to add additional required columns/fields. For more information about required fields, you can refer to the information in the Manually Created CSV File section.

If you are unfamiliar with exporting contacts from LinkedIn, you can expand the section below.

Exporting Contacts for LinkedIn (As of 7/2022)
  • Click Me from the top of the LinkedIn webpage and click Settings & Privacy.

    Linkedin_-_03.png

  • Click Data Privacy on the left-hand side.

    Linkedin_-_04.png

  • Select "Connections" to export your LinkedIn contacts.
    Click Request archive and enter your LinkedIn password to confirm the request.

    LinkedIn_-_08.png

  • You will receive an email like below when your download is ready.
    Click download your data archive using this link.
    You will be taken to the same page where you requested your data.

    LinkedIn_-_10.png

  • Click Download archive to download a zip file containing your requested data.

    LinkedIn_-_11.png

  • Extract the zip file and open the connections.csv file to review its contents.
  • The connections.csv file will give a warning that the email addresses of your connections may not be present depending on the LinkedIn settings of your connections. This data will need to be filled in for the CSV to properly import.

    Excel_-_01.png

Manually Created CSV File

You can manually create or add any other list into users. The file format you upload must be CSV (not XLS, not "Tab Delimited") and the headers for each column must match the field names below. After the file has been uploaded, it will be processed and you will be given a preview of the data before committing the changes.

Be mindful of adding commas to fields. As a comma is used to separate different sets of data, having a comma in the middle of your data can result in some data being incorrectly imported.

  • Email_Address - Required
  • First_name - Required
  • Last_name - Required
  • User_name - Required
  • Hiring_manager - Optional
    • if included, value must be YES or NO
    • if not included, value will default to NO
  • Requisition_approver - Optional
    • if included, value must be YES or NO
    • if not included, value will default to NO
  • Email Preference - Optional
    • if included, value must be DAILY, WEEKLY, EVERY or NONE
    • if not included, value will default to DAILY
  • User_roles - Required
    • To include user roles, you must include the Cross Reference Code (the unique code you have assigned to that User Role) for each User Role. The user role codes should be together in one field, separated by semi-colons. For more information about setting up user roles, you can refer to Complete Guide to User Roles.
  • External_login - Optional
    • If included, must be the username from your single-sign-on system. If you are unsure what their username should be, check with your IT team.

Importing CSV File

  1. Importing additional users is done from the "User Maintenance" sub-menu found under Administration. To begin, click Administration from the menu bar and click User Maintenance on the left-hand side.

    ATS_-_Menu_bar_-_05.png

    Administration_-_Menu_-_User_Maintenance_-_01.png

  2. Click Import Users....

    ATS_-_User_Main_-_Buttons_-_02.png

  3. Upload the file by dragging the file from your computer into the designated "Drag/Drop" dotted box or use the "Click here to select files" link then click Import Users.

    User_Maintenance_-_Import_-_04.png

  4. If the file was properly formatted, you will see a preview of the data that the system recognizers. Review the preview to ensure that the data is consistent with expectations.

    User_Maintenance_-_Import_-_02.png

  5. Click Import Users when ready.
  6. You will receive a confirmation message once everything has been successfully imported.

    User_Maintenance_-_Import_-_03.png

Was this article helpful?
0 out of 0 found this helpful