Database Files

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

Overview 

Database Files enable you to import delimited text files to be used in creating Views.  Once created, Database Files act like any other table in a database connection profile.

 

Step by Step Example

1. Right click on Database Files in the Tables/Fields section and select Add From Text File > Delimited.

mceclip0.png

 

2. Select the Text File that will be used. 

mceclip2.png

 

3. If only using one file, leave the file selection on Single. VDM supports Single, Multi and Directory file selections.

mceclip4.png

 

4. Select Delimiter. This is the value used to parse the text file. For example: Comma would be ',' (without the quotes). For a tab, use the word tab.

mceclip3.png

 

5. If the headers are present inside the file set this to True. This will bring in the Column Names as well as their datatype.

mceclip5.png

 

6. Give the new table a name. If you would like to add the Import Date and File Name into the database, set these options to True

mceclip7.png

 

7. If you would like the table to use the most current data when a view is ran, enable the Refresh on View Search option.

mceclip8.png

 

8. Once the options have been set, click Preview to see the Columns and Datatype layout. You can then modify the column names as you like as well as set the datatypes.

mceclip10.png

 

9. Last verify the import by clicking Test Import. If the import fails check that all datatypes are correct. If the import is successful click finish.

 

Import Failed:mceclip11.png

 

Import Successful:mceclip12.png

 

10. The new database file will be located under Tables and Fields, ready to be used like any other table in a view.

mceclip0.png

 

If you would like to see a video on the process, click here.

Have more questions? Submit a request

Comments