How to Create a Feed

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 > 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:

Data Feed

To create feeds in Simpro Data Feed, you need to identify workflows you frequently create in Simpro Premium using information received in an email and / or email attachment, and create a mailbox. Each Simpro Premium build includes three free feeds. Once you’ve identified these workflows you can start setting up a feed yourself or contact our Professional Services team to set up a feed at an additional cost. Learn more in How to Use Simpro Data Feed and Set Up Simpro Data Feed.

When you create a new feed the fixed data and rules that can be applied to the feed vary based on what you want the feed to do. For example, a feed that receipts purchase orders has configuration settings that include defining a fixed vendor name and a rule to create a new purchase order if it doesn’t exist. A feed that creates jobs has configuration settings that include defining a fixed customer and a rule to include email attachments in the job attachments.

In the following steps the configuration settings for a completely new feed that receipts purchase orders will be used as an example.

To create a new feed:

1. Go to Utilities > Data Feed > Feeds > Create Feed.
2. Select the type of feed. For example, click Receipt a Purchase Order.
3. Select the required option to create the feed.
   • Select Create a New Feed to create a new feed for Materials, Quotes, Jobs and Others. For more information around the feed types, learn more in Which fields are populated in Simpro Premium?.
   • Select Copy an Existing Feed to select and use an existing feed as a template for a new feed.
   • Select Apply a Feed Template to apply the feed to select from existing templates.
   • Select Create from Template and search and select from the available templates.
4. Select the Company Name. If you are using a multi-company build, select the company for the feed to be processed in.
   • For example the company that you want the purchase orders to be receipted in.
5. Enter an Email address to send an email notification whenever a feed is processed.
6. Select Only send for failed Feed processing to only receive a notification when a feed fails to process and needs to be actioned, rather than receiving an email every time a feed is processed.
7. Select an Attachment Type for the email.
8. Select the Feed Process for the feed that you are creating:
   • Interactive Testing - On-screen only and will not trigger email notifications
   • Online Testing - Stores only the data, without any further processing
   • Ask for confirmation - Stores the data, and then asks you to verify before processing
   • Production mode - run feed automatically
   • Paused - Feed will not run
     

     It is recommended to put your feed in Interactive Testing to ensure that your feed is processing correctly before putting the feed into production mode.

9. Click Next to proceed after completing all the mandatory fields, as required.
10. Upload a file or select an existing document. Access existing documents from Utilities > Data Feed > Documents. Learn more in View documents.
    • It is recommended to use PDF files.
    • Note that the document should be in the standard format and layout to match the feed you normally receive and process in the future, to ensure the feed works correctly.
11. Click Next to select a Mailbox.
12. Select Create new mailbox for this feed to create a new mailbox. In the current example workflow, to create a mailbox for where receipts will be sent to from your suppliers, for Data Feed to be able to process the feeds from. Alternatively, select Reuse another feed’s mailbox to select from existing mailboxes you have set up previously. Learn more in Create mailboxes.
13. Enter a New Mailbox Alias Name.
14. Note down and copy the uniquely generated email address shown.
15. Click Next to proceed to Fixed Data.
16. Enter Fixed Data, as required to use the same information every time the feed is processed, rather than the extracted information from the document.
    • For example, if all of the documents processed by this feed are from the same supplier, who is set up in your Simpro Premium build, enter their Vendor Name as fixed data to be used on the purchase order receipts that are created by the feed, rather than the feed extracting the name from the document each time.
      

      If you have multiple suppliers that you receipt purchase orders from, it is recommended that you create a different feed with different mailboxes, and send each supplier their unique mailbox / email address that they can send their purchase order receipts to.

17. Click Next to proceed to Rules.
18. Select the Business Rules for the Feed. Depending on what the feed is set up to accomplish the rules are different.
• For example, for a feed that receipts purchase orders you can set a rule to Create a purchase order if there is not an existing purchase order when feed is processed.
• Under Attachments, Select whether to include all email attachments to record or select to attach a copy of send email to record.
19. Click Next to proceed to Formats.
20. Select the Amount and Date format for the feed to use after it extracts the accurate amounts and date when processing the documents received.
    • Select the Amounts format as either default or european
    • Select the Date format for Day / Month / Year
    • Select the Date format used for when sending notifications
21. Click Finish to finish Feed Configuration and to proceed to Data Extraction setup.

US only: If you use Simpro Premium in the United States, the term 'vendor' is used instead of 'supplier'.

Data Feed uses US terminology regardless of your build's country.

To edit a Feed Configuration, go to Utilities > Data Feed > Feeds and click the relevant feed. All the Feed Configuration settings are displayed here on a single page and are available for editing, as required.

The Create New Feed (Guided) button will provide you detailed instructions on each page for creating a feed.

If the feed you are setting up has the relevant information in the body of the email rather than an attached document an example of the email will need to be sent to a Data Feed Mailbox before the feed is configured. Complete the following steps to configure a feed to extract form the body of an email:

1. Go to Mailboxes, click CREATE A NEW MAILBOX and copy the new mailbox email address.
   • If you already have a mailbox without any feeds assigned to it, you can use it instead of creating a new one.
   • Click the None field in the Name column in the associated mailbox row to label the mailbox as required.
   • The mailboxes must have no existing feeds associated with it.
2. Open your email inbox.
3. Compose an email that includes the content that you want Data Feed to import into Simpro Premium. The email should be formatted as it is going to be when future emails of this kind are sent. For example if it is being used to create a quote, it should have fields such as the customer name, site name, quote description etc.
   • You can use dummy data for fields such as customer, invoice or job details. But the structure of the fields in the email should be consistent with an actual email of this type that will be processed by this feed.
   • If this email is normally received from a form, you can forward the email on rather than recreating the email from scratch.
   • Data Feed does not support HTML formatted emails.
4. Enter details in the Subject field to help identify the message in Data Feed.
   • If you will be using a single mailbox for multiple feeds, Email Matching Rule must be applied for the feed in the Mailbox window.
5. Paste the copied email in the To field and click Send.
6. In Data Feed, go to the Messages tab to confirm you have received the email. It may take a few minutes to receive the email.
7. Go to Feeds > CREATE FEED > Create new feed.
8. Select what you would like the feed to do.
9. Enter a Feed Name.
10. Under What type of attachment will the message contain? select No attachments.
11. Select other options as required.
    • Under How do you want this feed to be processed? select Interactive Testing. This can be updated to Production Mode once you are happy with the setup.
12. Click Next.
13. Click Example Message.
14. Under Select Email select the message that you've sent. Messages are identified by their email subject.
15. Click Next.
16. In the Mailbox window, select the Reuse another feed's mailbox option and select the applicable mailbox.
17. Click Next.
18. Continue configuring the feed as normal.

To allow the feed to recognise what information in the email or document it needs to extract and feed into Simpro Premium, you must map the relevant information for extraction.

• For example, if you want the invoice number to be extracted from a supplier invoice PDF and fed onto a newly created invoice in Simpro Premium, you must identify where on the PDF the supplier invoice is typically located or how it is identified.

To allow the feed to recognise what information should be extracted, you must set up data extraction with an email or document that has the same formatting and general layout as emails or documents that will be processed by the feed once it is active.

The type of data that can be extracted from a document varies depending on what process the feed is being set up to accomplish.

• For example, a feed that receipts purchase orders will have options to extract information, such as the invoice number, packing slip number, and vendor. A feed that creates jobs will have options to extract information, such as customer names, site addresses and job details.

In the following steps the data extraction options for a feed that receipts purchase orders is used as an example.

To set up data extraction:

1. Once you have completed feed configuration you are taken to the Data Extraction sub-tab.
2. In the Data Extraction sub-tab, if data in the document is recognised as a Simpro field, that data is matched automatically.
   • For example, if Invoice Number followed by a string of numbers is present on the document, Data Feed could recognise this as one of the fields required to receipt a purchase order and match this automatically.
3. If the automated data extraction detects multiple possible instances of data that could be extracted for a single field, select the relevant results and click Save.
   • For example, if Invoice Number is automatically found on the document and Data Feed has detected the actual invoice number to the right and other irrelevant numbers below, select the correct number that appears to the right.
4. If a field is not recognised or it matches incorrectly click Manually Update to match the data using a different Data source and Technique.
5. Proceed to select and Save all information listed under each section under the Data Extraction Settings.

If some of the information to be extracted is not matched automatically, you can manually match the data to ensure it is extracted. When manually setting data extraction, the Technique and Approach determines where the data is being extracted from.

For accurate extraction settings setup, ensure that your web browser and the file zoom (above image preview) are set to 100%.

To select a technique, first select the Data source to define where the data should be extracted from:

Select the Technique and Approach that should be used to find the data in the document:

Need additional help?

Try Walk Me Through, our step-by-step guidance tool, to create a feed.

The Create New Feed (Guided) button will provide you detailed instructions on each page for creating a feed.

Learn more in How to Use Walk Me Through in Simpro Premium.