XML

 Top  Previous  Next

What is XML ?

 

Databuild supports Extensible Markup Language (XML) as its prime data interface with the outside world.

 

XML is basically a way of storing data in a simple text file. An XML file contains data and the definition of that data. Because the files contain data as well as a definition of that data, other applications and web sites can readily

recognise, display and manipulate that data.

 

Because the files are straight ASII text, they can be viewed, edited or even created using simple editors or word processors. A file might look like:

 

<Databuild>

<Bank>

<BankRecord>

                          <Number>1</Number>

<Branch>Collins st</Branch>

                          <AccountName>ABC Bank </AccountName>

                          <BSB>013 555</BSB>

                          <CurrentBalance>55179.7</CurrentBalance>

                          <NextCheque>10013</NextCheque>

</BankRecord>

<BankRecord>

                          <Number>2</Number>

<Branch>Bourke st</Branch>

                          <AccountName>CBA Bank </AccountName>

                          <BSB>013 666</BSB>

                          <CurrentBalance>3.55</CurrentBalance>

                          <NextCheque>65321</NextCheque>

</BankRecord>

</Bank>

</Databuild>

 

How Does Databuild use XML ?

 

•Any Table in your databases may be exported or imported ( Edit/XML Files/ Import or Export). As the data is imported or exported, the data integrity is checked. Thus exporting and importing can be used to clean up a problem database.

 

•The following areas allow export of selected records: Jobs, Suppliers, Contacts, Prices, Setup/Database Tables, Bill of Quantities, Transactions

 

•Databuild now ships with a utility to convert Databuild DOS export files (*.WEX) or Databuild Bill format (*.dbw)

 

•Databuild can read invoice XML batch files from your suppliers to create invoice batches automatically

 

•Databuild can create XML order or Quotation Request files and Email them to your suppliers. These can be read and processed using DBW Partner.

 

•The whole or part of your system can be exported to a single file for Email or Backup. The files, especially after compressing, are usually much smaller than the database files.

 

•Import & Export of tables has replaced the table copy function in setup/databases