Data upload

Overview

While relays are set up to establish connections from live data sources to Devo, there is also a tool for uploading static data files from either Dropbox or from your local computer. Go to Data upload in the Devo navigation panel to upload your files.

Learn in no more than 3 minutes how to send to Devo the data stored in local files or in Dropbox folders.


About the date format

The following date formats are currently supported by Devo:

Format Sample Regex
DD/MM/YYYY 30/05/2017 \d{2}\/\d{2}\/\d{4}
DD/MM/YYYY HH:mm:ss 30/05/2017 18:00:00 \d{2}\/\d{2}\/\d{4}\s\d{2}\:\d{2}\:\d{2}
DD:MM:YYYY 30:05:2017 \d{2}\:\d{2}\:\d{4}
DD:MM:YYYY-HH:mm:ss 30:05:2017-18:00:00 \d{2}\:\d{2}\:\d{4}\-\d{2}\:\d{2}\:\d{2}
ddd MMM DD HH:mm:ss YYYY Tue May 30 18:00:00 2017 \w{3}\s\w{3}\s\d{2}\s\d{2}\:\d{2}\:\d{2}\s\d{4}
DD-MMM-YYYY HH:mm:ss.SSS 30-May-2017 18:00:00.123 \d{2}\-\w{3}\-\d{4}\s\d{2}\:\d{2}\:\d{2}\.\d{3}
DD-MM-YYYY 30-05-2017 \d{2}\-\d{2}\-\d{4}
MMM dd HH:mm:ss May 30 18:00:00 \w{3}\s\d{2}\s\d{2}\:\d{2}\:\d{2}
x (epoch milliseconds with dot separator) 1496167200 \d{10}\.\d{3}
YYYY/MM/DD 2017/05/30 \d{4}\/\d{2}\/\d{2}
YYYY/MM/DD HH:mm:ss 2017/05/30 18:00:00 \d{4}\/\d{2}\/\d{2}\s\d{2}\:\d{2}\:\d{2}
YYYY/MM/DD hh:mm:ss 2017/09/14 15:10:23 \d{4}\/\d{2}\/\d{2}\s\d{2}\:\d{2}\:\d{2}
YYYY:MM:DD 2017:05:30 \d{4}\:\d{2}\:\d{2}
YYYY:MM:DD-HH:mm:ss 2017:05:30-18:00:00 \d{4}\:\d{2}\:\d{2}\-\d{2}\:\d{2}\:\d{2}
YYYY-MM-DD 2017-05-30 \d{4}\-\d{2}\-\d{2}
YYYY-MM-DD hh:mm:ss 2017-09-14 15:10:23 \d{4}\-\d{2}\-\d{2}\s\d{2}\:\d{2}\:\d{2}
YYYY-MM-DD HH:mm:ss.SSS 2017-05-30 18:00:00.123 \d{4}\-\d{2}\-\d{2}\s\d{2}\:\d{2}\:\d{2}\.\d{3}
YYYY-MM-DD HH:mm:ss.SSSSSS 2013-01-17 00:54:01.744909 \d{4}\-\d{2}\-\d{2}\s\d{2}\:\d{2}\:\d{2}\.\d{6}
YYYY-MM-DDThh:mm:ss 2017-09-13T19:01:15 \d{4}-\d{2}-\d{2}T\d{2}\:\d{2}\:\d{2}
YYYY-MM-DDThh:mm:ss.SSSZ 2017-09-13T19:01:15.000Z \d{4}-\d{2}-\d{2}T\d{2}\:\d{2}\:\d{2}\.\d{3}Z
YYYY-MM-DDThh:mm:ssZ 2017-09-13T19:01:15Z \d{4}-\d{2}-\d{2}T\d{2}\:\d{2}\:\d{2}Z

Uploading data files

  1. Go to Data upload in the navigation panel.
  2. Select either Dropbox or Local files. 

    • If you select Dropbox, you will be prompted to grant Devo access to your Dropbox files, then log into Dropbox. Navigate to the folder and select the file you want to upload. 

    • If you select Local files, you can either drag and drop the file or navigate to the necessary folder and select it for upload.

  3. When you have selected the file, click the Upload File button. A configuration page appears.

    This page contains several fields that allow you to tag the table in Devo and indicate how to parse the data in the file.


  4. Click the Confirm Settings button. If there were any errors when parsing the file, you will be notified.


When the file has been uploaded, notifications will be published in the Notifications area as seen below:


To access the table in Devo and work with the new data, go to Data search.

Have we answered your question?

If not, please contact our technical support team via email by clicking the button below.

CONTACT US