Cannot Upload Jobs from Spreadsheet

Sanket Ghia
  • Updated
Follow

Overview

You are unable to upload jobs in bulk and encounter one of the following errors:

  • Job ID (formerly Reference Number): 'Demo Job' already exists - this issue happens when jobs with the same Job IDs were created previously and you try to upload them without changing Job IDs, which must be unique. Even if you have deleted the jobs with the same IDs from the web portal, they are still stored in our database and you will not be able to use the same IDs.

  • Assigned to: 'jsmith1' is Invalid worker - you have entered an incorrect worker username into the Assigned To field.

  • Job Type: 'DemoJobType' is not configured for the company - you have entered a Job Type that does not exist in the system. 


Solution

Please follow the solution steps according to the encountered error:

  • Job ID (formerly Reference Number): 'Demo Job' already exists:
    1. Open the file containing the information about jobs.
    2. Update all existing Job IDs - you can add _1 (or any other number) to the first Job ID in the list and autofill the values for all other IDs.
      Note: You don't need to update Job Names - they can be the same.

      In this example, our first Job ID was Demo Job1230 and it was changed to Demo Job1230_1.

      mceclip1.png

    3. Save the updated file.

  • Invalid worker:
    1. Navigate to Administration > Users and check the usernames of workers to which you want to assign uploaded jobs.
      Also, you can download the list of all selected workers in XLS format to retrieve their usernames.

      mceclip2.png

    2. Replace values of the Assigned To field with the usernames retrieved from the web portal.
    3. Save the updated file.

  • Job Type: 'DemoJobType' is not configured for the company:
    • If you are using the Basic FFM package - enter Basic in the Job Type field, which is the only job type available for this package, and save the updated file.
    • If you are using the Advanced FFM package - enter Advanced in the Job Type field (default job type) or the name of a custom Job Type that can be checked under Administration > Job Types; then save the updated file.

      mceclip1.png
      Note: Make sure to keep columns in the file in the same order as they are present in the downloaded template.


Testing


You should be able to upload the jobs again without any issues.

 

Related articles