How to Import Recurring Jobs

Overview

In Simpro Premium, you can manually create recurring jobs through Recurring A screenshot of a recurring icon with a two arrows circling each other. > Create New Recurring Jobs, or save time and reduce data entry errors by importing a recurring jobs list to create multiple recurring job templates at once. Learn more in How to Create Recurring Jobs.

It is recommended to test the import process with one or two recurring jobs before importing an entire list.

In order to view content or perform actions referred to in this article you need to have the appropriate permissions enabled in your security group. Go to System A screenshot of a schedule icon with a grey calendar icon and an arrow. > Setup > Security Groups and access your security group to update your permissions. The relevant security group tab and specific permissions for this article can be found here:

Import Recurring Jobs

To prepare to import recurring jobs into Simpro Premium:

  1. Download and add data to Simpro Premium's Recurring Job Import Template for:
  2. Alternatively, you can create your own import list and leave out any fields that do not apply to your recurring jobs. The file must contain:
    • Customer IDs or Customer Names
    • Site IDs or Site Names
    • Frequency. Must be formatted with a number and then a letter referencing whether the frequency is Weeks, Months or Years. For example, 2W for two weeks, 6M for every 6 months.
    • Start Date. Must be formatted as DD/MM/YYYY or MM/DD/YYYY in the US.
    • If a recurring job is using a customer contract, the contract must exist in Simpro Premium and the contract must be for the listed customer.
  3. Save your file in your system as a compatible file type: CSV, TXT, or ZIP. Consult your spreadsheet software for file saving instructions if required.
  4. Separate your data using the same or similar headings as the Recurring Job Import Template.
  5. Ensure information is accurate, up-to-date and spelled correctly.
  6. Remove any special characters (such as ? # $ % @ !) as these may not import correctly.
  7. Save your file again.

Simpro Premium can recognise and import all headings and information listed in the Recurring Job Import Template.

After preparing your recurring job list, work through the following steps to import your list into Simpro Premium.

A screenshot of the Customer Import Settings page.

To adjust recurring job import settings, go to Utilities A screenshot of a schedule icon with a grey calendar icon and an arrow. > Import > Recurring Jobs.

The options available include:

First Record Is Select Header Record if the first row contains column titles, or select Data Record if the first row contains specific data.
If Custom List Value Not Found If any of the entries are a drop-down list in Simpro Premium and your file contains any additional values or 'custom list values' not available in the relevant list, select Create New List Option to add the additional value to the drop-down list in your recurring job templates. Select Reject and Warn to ignore the field and receive a warning when the recurring job list is uploaded that the field was not created.
If Cost Centre cannot be found

Select Do not Create Cost Centre to leave no cost centre if a recurring job in the import has a cost centre that cannot be found in Simpro Premium.

Select Use a default cost centre to apply the default cost centre to the recurring job if the cost centre cannot be found in Simpro Premium.
Price

Select to apply the Price in the import file as a:

  • Service Fee
  • Pre-Build
  • Catalogue Item
  • One Off Item

If no item is selected, the price in the template will override the cost centre price.

To select an import file:

  1. Go to Utilities A screenshot of a schedule icon with a grey calendar icon and an arrow. > Import > Recurring Jobs.
  2. Adjust recurring job import settings, then click Choose File / Browse.
  3. Locate your recurring job import file and click Open.
  4. Click Next.

After selecting a recurring job import file, manually match or review your list columns with the fields available in Simpro Premium. You may have both Simpro Premium and your list open at the same time.

To match import columns:

  1. Select your import file as above.
  2. Use the drop-down lists to match your import file columns with the fields available in Simpro Premium.
    • To leave a field out of the import, select Ignore.
  3. Click Import Recurring Jobs.

If you have a large list of recurring jobs, you can navigate away and work in other areas of Simpro Premium, then return to the import page to check on your import. You can only perform one import at a time.

After uploading an import file, the Recurring Jobs Import Complete page displays a breakdown of your import, including Recurring Jobs Added / Updated / Ignored.

Click Recurring jobs imported successfully to download a CSV file of imported recurring jobs for your records, with each recurring job line containing their new Simpro Premium-assigned Recurring Job ID.

Click Continue to perform another import.

After a successful import, it is recommended you manually check recurring jobs to ensure data has imported correctly. To do this, go to Recurring A screenshot of a recurring icon with a two arrows circling each other. > Recurring Jobs, click an imported recurring job, and check for errors. Manually amend if required.

If your file contains errors, an error message displays on the Import Recurring Jobs Summary page, and the table displays the number of errors found.

Click the blue link to download a CSV file of import errors. The Error Text column explains why entries failed. Amend your recurring job import list accordingly and restart the import process.