 |
dBworxPE Help File |
 |
Design |
 |
Special Field Types |
 |
Operation |
 |
Listings, Reports and Labels |
 |
Templates |
|
|
XML IMPORT/EXPORT:
dBworxPE allows you to import and export data in XML format. If you
don't know already, "XML" stands for "eXtensible Markup Language".
It's similar to HTML (the under-lying language of all web pages) but
XML is used to define and simplfy the transfer of data over the
internet rather than to display documents.
Like HTML, XML is a text-based markup language that uses opening
and closing tags, but the tags identify data instead of display formats.
An address database in XML format might look something like this:
<addresses>
<record>
<First_Name>Thomas</First_Name>
<Last_Name>Richards Jr.</Last_Name>
<Street_Address>187 Maple Ave.</Street_Address>
<City_State_Zip>Anytown, USA 77777</City_State_Zip>
</record>
<record>
<First_Name>Marilyn L.</First_Name>
<Last_Name>Porter</Last_Name>
<Street_Address>P.O. Box 2562</Street_Address>
<City_State_Zip>Anytown, USA 77777</City_State_Zip>
</record>
.
.
.
</addresses>
The database file itself has beginning and ending tags
(<addresses> and </addresses>), as does each record in
the database (<record> and </record>) and each field in each
record. dBworxPE allows you to import XML data into a dBworxPE
database and export the data in a dBworxPE database to an XML file.
If you are importing data from an XML formatted file, the field names
in your dBworxPE database must match the field name tags in the
XML file. dBworxPE will import data from any field in the XML file
where the field name tag matches a field name in the dBworxPE file.
The beginning and ending tags in an exported file will be <data>
and </data> and each record will have beginning and ending
tags of <record> and </record>. The tags for the different fields
will consist of the field name (with any spaces in the field name
replaced by an underscore character). For example, the field "First
Name" will be written in the export file as:
<First_Name>....</First_Name>
|