Partners
Firebird Maestro online Help
| Prev | Return to chapter overview | Next |
Setting source file name and format
1. Select the format of the source file.
2. Specify the file you want to import. The file name extension in the File name box varies according to the selected import type.
3. For ODBC data sources specify the connection string to be used to connect to the data source.
4. Select the data source to import: a table of MS Access database or a spreadsheet of MS Excel.
5. Enter the password to the database (MS Access).
6. For CSV file set the delimiter and quote characters.
7. Select source file Encoding.
To exclude the first file row, use the File contains column header checkbox.
For .XML files, define the XPath to the data to be imported to the selected SQLite table and select whether data are stored in Attributes or Subnodes.
Example 1:
To import data from the following .xml file, use XPath=/Employees/Employee and Data location=Subnodes
<?xml version="1.0" encoding="utf-8"?>
<Employees>
<Employee>
<ID>1</ID>
<FirstName>Klaus</FirstName>
<LastName>Salchner</LastName>
<PhoneNumber>410-727-5112</PhoneNumber>
</Employee>
<Employee>
<ID>2</ID>
<FirstName>Peter</FirstName>
<LastName>Pan</LastName>
<PhoneNumber>604-111-1111</PhoneNumber>
</Employee>
</Employees>
Example 2:
To import data from the .xml file below, use XPath=DATAPACKET/Data/Item and Data location=Attributes
<?xml version="1.0"?>
<DATAPACKET Version="2.0">
<Data>
<Item ID="1" FirstName="Klaus" LastName="Salchner" PhoneNumber="410-727-5112" />
<Item ID="2" FirstName="Peter" LastName="Pan" PhoneNumber="604-111-1111" />
</Data>
</DATAPACKET>
| Prev | Return to chapter overview | Next |
