Getting Data from Text Files
The SaveToDB add-in extracts data from various file formats, including JSON, XML, HTML, CSV, and plain text.
Users can connect to files using the connection wizard.
Database developers can set up these connections in a database and configure data merging as needed.
To configure a query, specify any schema and name, use the TEXT object type, and enter the file path along with parser parameters in the TABLE_CODE field of the xls.objects table.
Here’s a sample configuration:
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 enclosed in curly brackets, similar to URLs.
The text file and web data parsers share the same parser parameters. For more details, see HTTP Commands.
Also, check out Merging Data for additional information.