CSV Format Parameters Page (DB Table Variable Wizards)

On the CSV Format Parameters page, you can specify the format parameters of the CVS file that will be used as a data storage.

The CSV Format Parameters page is part of the wizards that assist you in adding DB Table variables to your test. These wizards are: Add Variable to Keyword Test and Add Variable.

Select the Use these custom parameters instead of system settings option to specify custom format parameters for the CSV file. If this option is enabled, the rest of the options are available.

Important: If you disable this option, TestComplete x64 will use the Microsoft Office 12.0 Access Database Engine OLE DB Provider to retrieve data from CSV files. It is part of the Microsoft Access Database Engine 2010 Redistributable package, which you can download from the Microsoft website:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Make sure to download and install the 32- or 64-bit package that matches the “bitness” of your TestComplete version.

If you have 32-bit Microsoft Office 2010, the installation of the 64-bit provider will fail. In this case, perform the following steps to install it: Show Steps Show StepsHide Steps Run the installer with the /passive command-line argument. Run the Registry Editor. To do this, open the Start menu, type regedit and press Enter. Find the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths. Delete or rename the mso.dll registry value. Otherwise, the data provider will get corrupted after the first Excel run.

The Delimiters field lets you specify characters that separates columns in the .csv file. The available values are: Tab, Semicolon, Comma, Space and Other.

Select the Treat consecutive delimiters as one option if the CSV file contains a delimiter of more than one character between data fields or if the CSV file contains multiple custom delimiters.

The Text qualifier field lets you select the character that encloses values in the CSV file.

The First row contains column names option specifies whether the first row of the CSV file will be used to label the .csv file columns.

The Preview field lets you view how TestComplete recognizes the selected CSV file in accordance with the specified format parameters.

After specifying the needed parameters, click Next to store the data to the DB table variable. Back will return you to the previous page of the wizard. Cancel will close the wizard and abort adding the variable.

See Also

Add DB Table Variable Wizard
Add Variable to Keyword Test Wizard
Add Variable Wizard