Set Up Simpro Data Feed

Overview

Simpro Data Feed extracts data from emails and attached documents, including PDFs, CSVs, Excel spreadsheets, and text files, to automatically generate new workflows in your Simpro Premium build and save time on manual entry. Learn more in About Simpro Data Feed.

A feed defines how this data is extracted and how a workflow, such as a lead, quote, job, supplier invoice, or task, populates in Simpro Premium using that data.

To begin automating your Simpro Premium workflows, you need to provide Simpro Premium with the information they need to set up feeds.

To express interest in using Simpro Data Feed, contact your local Simpro Premium admin team:

You then need to identify workflows you frequently create in Simpro Premium using information received in an email and / or email attachment, and provide Simpro Premium with the information they need to set up feeds using the following steps:

  1. Locate an example of an email you always use to create and populate a specific workflow in Simpro Premium. This email and applicable attachments must:
    • Always present information in the same format
    • Always be used to generate the same type of workflow in Simpro Premium, for example, a lead, quote, job, supplier invoice, or task.
  2. Highlight, outline, and / or annotate the information you use in the email and attachments to populate the relevant workflow in Simpro Premium.
    • You can also specify the exact fields in Simpro Premium this information populates, for example, text in a specific cell in a CSV or XLSX attachment is always entered in the Description field in a job. See Which fields are populated in Simpro Premium? to learn which fields can be populated using data extracted in Simpro Data Feed.
  3. Provide additional information on:
  4. Provide Simpro Premium with at least two more examples of this email.
    • This is so the rules Simpro Premium defines in the feed can account for variations when extracting data. It is not necessary to annotate these emails.

You can repeat this information-gathering process for each feed to be set up by Simpro Premium.

What the feed does

Provide Simpro Premium with a brief summary of what the feed is to achieve with this email / document. For example, which workflow do you always create and populate using the email or attached document examples you have provided?

You also need to specify additional information such as:

  • Whether the email has an attachment and the attachment's file format, for example, TXT, PDF, CSV, XLSX
  • The date format always used in the email or attachment, for example, DD/MM/YY, YYYY-MM-DD, etc
  • Whether email notifications about the feed's status are required and which email address they should be sent to
  • The company the feed is to generate workflows in if you use a Multi-company build.
How the feed interacts with Simpro Premium

Specify what the feed can and cannot do when it interacts with your Simpro Premium build, for example:

  • If a record such as a customer, customer contact, site, or purchase order related to a supplier invoice does not exist in Simpro Premium, do you require the feed to create it?
  • Do you use this attachment to create one workflow, or can you create multiple workflows of the same type from it? For example, the attachment may have a table with a different quote per line.

You can also set fields to always populate with specific values if they are not available in the email or attachment, including the:

  • Cost centre
  • Customer
  • Project manager
  • Technician
  • Salesperson
  • Initial quote status
  • Site.
Which emails the feed matches to

Specify the elements of the email that are always consistent, such as:

  • The email sender username or name
  • The email sender domain
  • The text contained in email subject line or in the email body.

This enables Simpro Premium to match the feed with the emails and applicable attachments that contain all relevant information to generate the workflow. You can also specify email elements to be excluded, for example, a supplier invoice.

Click a workflow to view which fields of information in Simpro Premium can be populated with data extracted in Simpro Data Feed.

Note that Customer Banking Account Name, BSB and Account Number will only be populated for newly created customers.

The following fields of information can be populated in a Simpro Premium lead using data extracted in Simpro Data Feed:

  • Customer
  • Customer contact
  • Site name
  • Site address, city, postal code, state, and country
  • Site contact
  • Customer Banking Account Name
  • Customer Banking BSB
  • Customer Banking Account No.
  • Description
  • Estimated price
  • Follow-up date
  • Notes
  • Project tags
  • Assigned project manager
  • Custom fields
  • Assigned salesperson.

The following fields of information can be populated in a Simpro Premium quote using data extracted in Simpro Data Feed:

  • Customer
  • Customer contact name
  • Site name
  • Site address, city, postal code, state, and country
  • Customer Banking Account Name
  • Customer Banking BSB
  • Customer Banking Account No.
  • Description at the project overview level
  • Notes at the project overview level
  • Project tags
  • Cost centre description
  • Cost centre notes
  • Order number
  • Request number
  • Date issued
  • Date due
  • Validity days
  • Pre-builds added in the cost centre Parts & Labour tab or create a new pre-build
  • Catalogue items added in the cost centre Parts & Labour tab or create a new item
  • Forecast probability of sale percentage
  • Assigned project manager
  • Assigned technician
  • Assigned salesperson.

The following fields of information can be populated in a Simpro Premium job using data extracted in Simpro Data Feed:

  • Customer
  • Customer contact name
  • Site name
  • Site address, city, postal code, state, and country
  • Customer Banking Account Name
  • Customer Banking BSB
  • Customer Banking Account No.
  • Description at the project overview level
  • Notes at the project overview level
  • Cost centre description
  • Cost centre notes
  • Order number
  • Request number
  • Project tags
  • Response time
  • Date issued
  • Date due
  • Pre-builds added in the cost centre Parts & Labour tab or create a new pre-build
  • Catalogue items added in the cost centre Parts & Labour tab or create a new item
  • Assigned project manager
  • Assigned technician
  • Assigned salesperson.

The following fields of information can be populated in a Simpro Premium import/update for Supplier Catalogue using data extracted in Simpro Data Feed:

  • Group (Ignored for Updates)
  • Subgroup 1 (Ignored for Updates)
  • Subgroup 2 (Ignored for Updates)
  • Subgroup 3 (Ignored for Updates)
  • Part Number
  • Description
  • Universal Product Code
  • Country of Origin
  • Trade Price
  • Cost Price
  • Split Price
  • Split Cost Price
  • Purchase Tax Code
  • Sales Tax Code
  • Trade Split Quantity
  • Minimum Pack Quantity
  • Est. Time (Mins)
  • Est. Time (Hrs)
  • Manufacturer
  • Supplier Quantity
  • Supplier Part Number
  • Supplier Description
  • Display Order
  • Favourite
  • Search Terms
  • Purchase Stage
  • Inventory Item
  • Notes
  • Unit of Measurement
  • Add-on Enabled
  • Markup (Tier 1 Name)
  • Sell Price (Tier 1 Name)
  • Add-on Markup (Tier 1 Name)
  • Add-on Sell Price (Tier 1 Name)
  • Markup (Tier 2 Name)
  • Sell Price (Tier 2 Name)
  • Add-on Markup (Tier 2 Name)
  • Add-on Sell Price (Tier 2 Name)

The following fields of information can be populated in a Simpro Premium purchase order using data extracted in Simpro Data Feed:

  • Assign to - by default this is Stock
  • Storage Device - this is the Default Storage Device assigned in the build
  • Stage
  • Supplier
  • Status
  • Reference - by default this is ‘Stock’
  • Order No.
  • Date Issued
  • Due Date
  • Quote No.
  • Items Table
  • Freight
  • Supplier Notes
  • Private Notes

The following fields of information can be populated in a Simpro Premium supplier invoice using data extracted in Simpro Data Feed:

  • Invoice number
  • Order number
  • Date issued
  • Items received
  • Accounting Category
  • Notes.

Note that Data Feed can process packing slips to create a Supplier Invoice that marks items as received, without receipting the items.

The following fields of information can be populated in a Simpro Premium Supplier Invoice Credit Note using data extracted in Simpro Data Feed:

  • Vendor Name
  • Invoice Number
  • Credit Invoice Number
  • Date Issued
  • Order Number
  • Items
  • Freight Price.

The following fields of information can be populated in a Simpro Premium task using data extracted in Simpro Data Feed:

  • Customer
  • Customer contact
  • Site name
  • Site address, city, postal code, state, and country
  • Customer Banking Account Name
  • Customer Banking BSB
  • Customer Banking Account No.
  • Assigned employee
  • Subject
  • Description
  • Notes
  • Whether the task is billable
  • Whether to show the task on the job card
  • Due date
  • Start date
  • Complete date
  • Custom fields
  • Project number.

The following fields of information can be populated in an existing Simpro Premium work order using data extracted in Simpro Data Feed:

  • Contractor Name
  • Contractor Invoice Number
  • Date invoice issued
  • Date invoice paid
  • Notes
  • Cost of Labour
  • Cost of Materials

Please note contractor work order data feeds are only for adding invoicing details to an existing work order, not creating new work orders.