Getting Data from Text Files

Getting Data from Text Files

The SaveToDB add-in getting data from files extracting data from JSON, XML, HTML, CSV, and plain text.

Users can connect to files using the connection wizard.

Database developers can configure such connections in a database and even configure merging data.

To configure the query, use any schema and name, the TEXT object type, and place the file path with parser parameters into the TABLE_CODE field of the xls.objects table.

Here is a sample:


Alternatively, you can configure queries in the query list views. For example:


You can use parameters in curly brackets like in URLs.

The text file and web data parsers have the same parser parameters. See details in HTTP Commands.

See also Merging Data.