Import data into the VTS table

You can import data to the VTS table, either from a database or from a CSV file.

You can import data multiple times into the same table. Each time you import data, the data is appended to the existing data in the table - the existing data is not deleted. If you want the imported data to be the only data in the table, click Delete Table on the VTS toolbar before importing the new data.

Import from a database

When you import data from a database, you are required to enter an ADO connection string. The VTS server connects to the database using this connection string. A typical connection will include the following properties:

  • Provider
  • Data Source
  • Initial Catalog

Refer to the Microsoft documentation for details about the ADO connection string format.

To import from a database:

Run the command line utility vts_import from the VTS\bin folder using this syntax:

C:\Program Files\OpenText\VTS\bin>vts_import –connection “connection_string” -query “sql_query_string” [-inst “vts_instance_name”]

The command line options are:

-connection

The string that VTS will use to connect to the database.
-query

The SQL statement to use to query the database.
-inst

The VTS instance name for which the operation is applied. When not set, it uses the “Default” instance.

The provider specified in the connection string should already be installed on the web server.

Note: If the connection string specifies the use of windows authentication (for example, Integrated Security=SSPI), the credentials of the Windows service that runs the website will be used to access the server.

This may cause a problem when running VTS Service under local machine accounts. If you encounter problems, try to run the VTS Service under a domain account that has access to the remote database.

Back to top

Import from a CSV file

When you import data from a CSV file, you must specify the name and location of the CSV file, and the delimiter that is used in the file.

To import data from a CSV file

  1. Click Import on the VTS toolbar.
  2. In the Import dialog box, click Import from CSV file.
  3. Click Select File, and specify the file that contains the data to import.
  4. From the Delimiter list, select the delimiter that is used in the CSV file. Keep the <Auto Detect> option to let VTS determine the delimiter that is used in the CSV file.
  5. Click Start Import to begin importing the data into the VTS table.

Back to top

Use the sample files

Sample tables are provided (Customers, Employees, Products, Orders) which can be imported into any VTS instance. Additionally, you can add your own .csv files to the Samples folder.

To import a sample table:

  1. Click Options > Import Samples
  2. Select one of the sample tables

To add and import files from the samples directory:

  1. Copy your .csv file into the Samples folder. By default, the folder location is <VTS root folder>\web\Samples.
  2. Click Options > Import Samples. Select your .csv file from the drop-down list to populate the data table.

Back to top

See also: