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:

ID	TABLE_SCHEMA	TABLE_NAME	TABLE_TYPE	TABLE_CODE	INSERT_OBJECT	UPDATE_OBJECT	DELETE_OBJECT
	prices	Import	TEXT	d:\import\prices.xml

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

ID	TABLE_SCHEMA	TABLE_NAME	TABLE_TYPE	TABLE_CODE	INSERT_PROCEDURE	UPDATE_PROCEDURE	DELETE_PROCEDURE	PROCEDURE_TYPE
	prices	Import	TEXT	d:\import\prices.xml

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.