Background

Often times, customers have years (decades?) of spreadsheets or other sources with data in them that they'd like to see in Waterly.  Sometimes it's in a well formed and sometimes not so clean.  Either way, it's pretty nice to see multiple years of your average daily flows, for example.  Waterly offers two options to import data into the app:

1. Option 1: No charge.  Pre-format and prep the data for import for us.
2. Option 2:  Hourly but reasonable charge.  Upload all of your data to us and have a water operator work with you to prep and import your data.  We will even import scanned paper data for less that you would believe!

Importing Data - Option 1

Option 1 involves you doing a bit of work to get your data ready, but the upside is we can import years (decades) of data with no fee.  Basically we need you to clean up your data so that it is in a simple format that matches a pattern like is shown below.  Note that the first column is the report date and the second column is the ID of the metric, which is unique.  You get this Waterly Metric ID from a Data Model that we provide you that shows your data structure as such:

• Site
• Process
• Component
• Metric

For each metric, you'll see the units and you from there you should be able to match your existing data to the SPECIFIC Waterly metric that it represents.  Once you have the metric id, for each imported metric, your import template will look something like this when you're done (but probably a whole lot longer than this sample):

On the ImportData tab, you copy/paste your data here

From the Data Model Tab, Waterly will provide you this data for YOUR SYSTEM: 

You can download the import data tool from our website Excel Tools page.  We'll populate the data model on the second tab for you and we are here for questions, but you'll have to 'line up all of the data' in a nice column for the Waterly machine to ingest it and put it in the right place.

Importing Data - Option 2

Option 2 involves a few steps but we take care of (almost) everything for you.  

1. Review - 30-60 Minute meeting with Waterly staff to review your data. Schedule your meeting by creating a support ticket here or from the app using the Support link in the lower left navigation bar.
   
   
2. Upload Data - Your Waterly onboarding agent will give you a link to upload one year of your data and indicate which fields you want imported.  You may not want or need to import the scale weights of your chlorine cylinders from 1989, but you may want the daily chlorine usage, for example.
   
   
3. Estimate and Trial Import - We review a month or two of data, tag map it for you, import it, and and share the results with you along with an estimate to import the balance of data. You'll review this trial import, give our team feedback, and then (when you are ready), provide the rest of the data for a full import. You'll still have a chance to review the data once it is imported in your System Dashboard (our charts are very useful for looking at large data sets).
   
   BTW - most small and medium sized utilities pay less than a thousand dollars to import a year of data. And two or more years is usually just a small amount more. Larger systems depend on how many metrics you want imported, but may be a couple to a few thousand dollars.
   
   
4. Import all data - We import the balance of the data to your app, notify you to review, and then approve the finalization. 

You will receive a bill for the service with Option 2, but the value of having historical data all in one spot is generally worth more than the cost, as we do this type of work often, making it very cost efficient for everyone.