Data Export Task

With the Data Export Task it is easy for Users to export data from VDV Database to a file format of choice.

Configuring

To set up a Data Export first navigate to the Data Export Task through the left-hand side menu in VDV, setup -> Data Export Task

A list of all active Data Export Task will appear where the User can both edit the existing tasks as well and delete the ones not needed anymore.

Create a new Data Export Task

To create a new Data Export Task click on the + icon in the top right corner to open up the Data Export Task menu.

To set up the data export task give the task a name, assign an owner and select the export time period.

  • Add the file name, file type, and variable format.
It is important to note that pre and post-fixes can be added to the file name using %Y for the year (4 digits), %y for the year (2 digits), %m for month, %d for the day of the month, %H for hours, %M for minutes and %S for seconds. If the file name does not include any pre or postfixes the file will be overwritten anytime the task runs.
The Variable format can be in 3 different formats, the $VARIABLE_NAME$, $SITE_NAME$ and $UNIT_NAME$, this will tell the system what should be in the variable name, for example, if the user wants to export 10 temperature variables from different sites it would be less than ideal to have them all called temp so more ideal way would be $VARIABLE_NAME$ - $SITE_NAME$( $UNIT_NAME$) making the export something like this: Temperature - SiteA(C)
  • Fill out the File format, the Delimiter, and the Decimal point, and select the line ending.
Include header lines is whether an information line will be at the top of the file, this line is created in the variable and the fixed Lines/Columns tab.

Fill out the Timestamp setup, select the Record ID checkmark if that should be included in the export, and finally the Schedule for the Task (as in how often the task should run).

Export to FTP

It is optional to send the file straight to an FTP server, for this option simply check the FTP option under Export Settings.

Add the information for the FTP server and test the connection to make sure everything is connected correctly.

Passive mode is generally used in situations where the FTP server is not able to establish the data channel. One of the major reasons for this is network firewalls where Passive mode works through any kind of firewall. Active Mode needs to have ports 20 and 21 open in the Firewall. Advise with IT department which option the FTP server supports or try which one works
Please note that FTP subfolders need to be part of the file name, not the URL

Adding Variables to the Export

Under the Variables tab add the variables that should be exported through the VDV variable selector, the Variables that are selected will appear in the list below with their name and station.

Fixed Lines/Columns

If the export should have Fixed lines or Columns this is added under the Fixed Lines/Columns tab by adding New Column or Line

How did we do?

Completeness

Documents

Contact Support