Getting Data from Text Files
Special offer: 50% discount ($1440) for ODataDB Enterprise until June 24, 2024

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:

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 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.