Getting Data from Text Files

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:

IDTABLE_SCHEMATABLE_NAMETABLE_TYPETABLE_CODEINSERT_OBJECTUPDATE_OBJECTDELETE_OBJECT
pricesImportTEXTd:\import\prices.xml

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

IDTABLE_SCHEMATABLE_NAMETABLE_TYPETABLE_CODEINSERT_PROCEDUREUPDATE_PROCEDUREDELETE_PROCEDUREPROCEDURE_TYPE
pricesImportTEXTd:\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.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.