This article is for Backflow Testers. Water purveyors should refer to our Data Import Template Guidelines for Purveyors article to learn more.
Syncta can import certain data using an Excel template that we created. This template provides the exact fields that our developers need to import your data into Syncta correctly.
The data must be provided to Syncta in this template and follow the EXACT guidelines listed below; otherwise, there could be additional clean-up charges added to the import fee.
What the Import Does/Does Not Include
The import includes the following data:
The import does not include the following data:
Water purveyor information
Guidelines for Populating the Excel Template
Use the following guidelines to correctly populate the Excel data import template.
Do not remove any columns from the spreadsheet.
You may add columns to the end of the spreadsheet; this will create custom fields on the Device page.
Customer columns are Orange.
Service Location columns are Blue.
Device columns are Green.
Each row of the spreadsheet is a device - this means that customer information and service location information will need to be repeated for each row if there are multiple devices for the same customer or location.
Only include one piece of data per column - don't include city, state, and zip in one column.
All date fields need to be formatted as MM/DD/YYYY.
All nine-digit zip code fields need to be formatted as XXXXX-XXXX.
You must include data in two required columns: Customer/Company Name and Mailing Address Line 1.
We recommend adding information in the optional columns, but you can leave other columns blank if you do not need that information. The following section lists some of the optional columns that can be populated, with instructions as needed.
Parent Customer: If you want to add a name in the Parent Customer column, that name must also exist in a separate row for a Customer/Company Name. This means the Parent Customer must exist as a customer before it can be added as a parent to a Customer/Company Name.
Customer Phone 1 must be populated before Customer Phone 2 can be used.
Auto Test/Annual Test Program: This is used to keep track of customers enrolled in your automatic annual testing program. Enter Yes or No, or leave this column blank.
Water Purveyor: The data in this column must match EXACTLY with the water purveyor name you have selected in Syncta; check here to see the names as you set up them up in Syncta: https://app.syncta.com/en/water_purveyors
Device Type: The device type you enter must match the options available in Syncta:
Device Manufacturer: The manufacturer you enter must match the options available in Syncta:
Device Size: The device size you select must match the options available in Syncta:
Needs Appointment? Enter Yes or No, or leave this column blank.
Proper Installation: Enter Yes or No, or leave this column blank.
Containment: Enter the options that you typically use. For example, isolation and containment.
Freeze Protection: Enter Yes or No, or leave this column blank.
Orientation: This column must be populated with one of the following values, or it can be left blank:
Confined Space: Enter Yes or No, or leave this column blank.
Approved Assembly: Enter Yes or No, or leave this column blank.
Device Testing Frequency: This column must be populated with one of the following values:
Every 1.5 Years
Every 3.5 Years
Every 5.5 Years
Every 2 Years
Every 4 Years
Every 6 Years
Every 2.5 Years
Every 4.5 Years
Every 6.5 Years
Every 3 Years
Every 5 Years
Every 7 Years
Device Next Test Due Date: Enter the date when this device is due to be tested again in format MM/DD/YYYY.
If you want to add columns that are not part of this spreadsheet, you can do so at the end of the spreadsheet; this will create custom fields on the Device page.
Send Your File to Syncta
Once you have filled in the data import template, save it as a .xlsx file and email it to Syncta at: email@example.com to have the import scheduled.