Table of Contents

Data Source

Andres Andresson Updated by Andres Andresson

Data Source is the place for adding new data into VDV. It supports numerous structure of data such as FTP, SFTP, Local or Network drive. Also allows for a single file or incremental files.

File Format

For each data file that is imported into VDV there needs to be a File Format that matches the data file format. Using the File Format editor VDV can import almost any kind of delimited text based data file.

To Access: Data Source -> File Format

Before creating a new File Format it is a good practice to open the data file to be added in a Text Editor (Notepad++ for example) to better understand how the data file is structured.

Click the button in top-right corner to create a new File Format.

  • Name: Identify the File Format with a descriptive name
  • File Type: The file ending (typically csv or txt)
  • Delimiter: Choose the correct Delimiter as in the file
  • Decimal Point: Choose the correct Decimal point
  • Owner: Choose which Owner the File Format belongs to. This is used so Users with access to specific Owner can only see File Formats that are connected to their Owners. If the File Format should be visible to all users then select the Fixed checkbox below.
  • Header Line: If the file includes a header line with variable name then select Yes.
  • Header Line Number: Select in which line the Header Line is located.
  • Timestamp: Can be in one or more columns. Add columns as needed and type in the format of the Timestamp

File Locations

A File Location are predefined locations where data can be imported from. It can be FTP, SFTP, Local network on local server.

To Access: Data Source -> File Location

Click the button in top-right corner to create a new File Location.

Local Directory

Adding a local directory is used to allow users to add new Data Sources from the web from the server running VDV. This can be used to add a directory where data is being collected.

If data is stored on a FTP that is on the same network as VDV Server then it is recommended to add a Local Directory with \\FTPServerName as the path instead of setting up FTP location as that will improve speed.
  • Name: Identify the File Location with a descriptive name
  • Owner: Choose which Owner the File Location belongs to. Users with access to that owner can see and use the File Location
  • Type: Choose Local
  • Directory: Type in the path to the folder containing the data files. A list of all files and folders in that directory will be listed below

System Directories that are not allowed.
C: or any root
C:\Windows
C:\Program Files
C:\Program Files (x86)
C:\ProgramData
C:\Windows.old
C:\Users

FTP Location

FTP Location allows users to import directly from FTP Servers. This allows data import from any external FTP/SFTP Server.

  • Name: Identify the File Location with a descriptive name
  • Owner: Choose which Owner the File Location belongs to. Users with access to that owner can see and use the File Location
  • Type: Choose FTP /SFTP
  • Address: Type in the address to the FTP Server (skip the ftp://)
  • Type in Username and Password.
  • Click Test Connection. If everything is working then a Successful notification will appear.

File Import

To Access: Data Source -> File Import

File Format and File Location must be configured before adding a new File.

Click the button in top-right corner to create a new File to VDV.

Data files can either be Incremental or Single where all data is appended to the same file.

Single File

  • Start with typing in the Site Name that will appear in VDV and choose the Ownerof the data.
  • Choose Single File in File Structure
  • Choose correct Format of the file to add
  • Choose the Location of the file
  • Open the Folder and select the correct File (click on the EYE icon to see the data file content)
  • Click Next

Incremental Files

  • Start with typing in the Site Name that will appear in VDV and choose the Owner of the data.
  • Choose Incremental File
  • Choose correct Format of the file to add
  • Choose the Location of the file
  • Type in File Prefix (Required). The import process will only match the incremental files that match the File Prefix.
  • Open the Folder and select the correct File that matches the selected File Prefix. It does not matter which file you choose, they will all be processed in the import process.
  • click on the EYE icon to see the data file content
  • Click Next
Override Data. If selected then VDV will import all data regardless if it has been imported before. This is handy if corrected data is sent afterwards or when importing forecast data that is always being updated.

How did we do?

Contact Support