With the Data Export Task it is easy for Users to export data from VDV Database to a file format of choice.
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.
- Fill out the File format, the Delimiter, and the Decimal point, and select the line ending.
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.
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.
If the export should have Fixed lines or Columns this is added under the Fixed Lines/Columns tab by adding New Column or Line