All Collections
Other Questions and Information
Data Imports
Data Import Template Guidelines for Testers
Data Import Template Guidelines for Testers

Guidelines for testing companies to add data to Syncta's data import template

Angela avatar
Written by Angela
Updated over a week ago

Overview

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:

  • Customers

  • Service Locations

  • Devices/Assemblies

The import does not include the following data:

  • Test history

  • Invoice history

  • Existing invoices

  • 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.


Required Columns

You must include data in two required columns: Customer/Company Name and Mailing Address Line 1.


Optional Columns

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:

Air Gap

DCDA II

PVB

SC

AVB

Dual Check

RPDA

SCDA

DC

HBVB

RPDA II

SVB

DCDA

Other

RPZ

  • Device Manufacturer: The manufacturer you enter must match the options available in Syncta:

American Dish

Beeco

Diversey

Kennedy

Orion

Unknown

Ames

Buckner

Ecolab

Lawler

Other

Viking

Apollo

Caleffi

Febco

Lawn Genie

Rain-Bird

Water Master

A.R.I.

Cash Acme

Flomatic

Legend

RainJet

Watts

Auto-Chlor

Champion

Grinnell

Mueller

Rockwell

Wilkins

AVK

Cla-Val

Hersey

Neptune

SMR

Backflow Direct

Conbraco

Irritol

Orbit

Toro

  • Device Size: The device size you select must match the options available in Syncta:

1/4

1-1/4

2-1/2

6

3/8

1-1/2

2-3/4

8

1/2

1-3/4

3

10

3/4

2

4

12

1

2-1/4

5

N/A

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

H

VD

VUH

VU

VUVD

VDVU

VDVD

HVD

VUVU

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

Annually

Every 1.5 Years

Every 3.5 Years

Every 5.5 Years

Semi-Annually

Every 2 Years

Every 4 Years

Every 6 Years

Quarterly

Every 2.5 Years

Every 4.5 Years

Every 6.5 Years

Monthly

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: support@syncta.com to have the import scheduled. 

Did this answer your question?