Databuild XML Format

Databuild XML

<Databuild>

   <Bill>

       <BillRecord>

           <BLoad>4</BLoad>

           <CostCentre>001</CostCentre>

           <ItemCode>0016</ItemCode>

           <JobNo>1</JobNo>

           <Price>0</Price>

           <PriceLevel>1</PriceLevel>

           <PriceLock>False</PriceLock>

           <Quantity>1</Quantity>

           <UnitPrice>0</UnitPrice>

           <XDescription>Please provide soil report, levels.</XDescription>  extra description

       </BillRecord>

       <BillRecord>

           <BLoad>4</BLoad>

           <CostCentre>001</CostCentre>

           <ItemCode>0022</ItemCode>

           <JobNo>1</JobNo>

           <Price>640</Price>

           <PriceLevel>1</PriceLevel>

           <PriceLock>False</PriceLock>

           <QGen>GFAREA</QGen>

           <Quantity>2</Quantity>

           <UnitPrice>320</UnitPrice>

       </BillRecord>

       <BillRecord>

           <BLoad>1</BLoad>

           <CostCentre>ITX</CostCentre>

           <ItemCode>0004</ItemCode>

           <JobNo>1</JobNo>

           <Price>15.5</Price>

           <PriceLevel>0</PriceLevel>

           <PriceLock>False</PriceLock>

           <Quantity>1</Quantity>

           <UnitPrice>15.5</UnitPrice>

       </BillRecord>

   </Bill>

</Databuild>

Notes:  Bold Entries are mandatory for importing

Databuild XML - Importing Other Data

As well as importing quantities, other data can be imported simultaneously:

Job Variables

These are numerical values attributed to the current job Examples are FloorArea, Wall Perimeter, No doors etc.  Each Job Variable is a name of up to 20 characters that represents a value for each job.

To set the values, enter text in the QGEN fields of the XML file:

<QGEN> 110.5^^[FloorArea] <\QGEN>                Sets job variable [FloorArea] to 110.5

<QGEN> 1.5^[FloorArea] <\QGEN>                Adds 1.5 to job varaiable [FloorArea]

Job Variables are used to build up quantities for OTHER items in the bill

It is good practice to load up all job variables into a single bill item

Hard line feeds are converted into [LF] for XML fields, so a multiple line XML field would look like:

<QGEN> 110.5^^[FloorArea] [LF] 137.5^^[Perimeter]<\QGEN>

Text Variables

These are texts attributed to the current job Examples are colour selections, Council Names, handing on doors, Wall Perimeter, No doors etc. 

Each Text Variable is a name of up to 20 characters that represents a different text for each job.

Text variables generally do not have any effect on price or code selections, but are used to further specify items.

To set the values, enter text in the QGEN fields of the XML file:

<QGEN> Yellow^^{Bathcolour} <\QGEN>                Sets text varaiable [Bathcolour] to "Yellow"

It is good practice to load up all text variables into a single bill item

Hard line feeds are converted into [LF] for XML fields, so a multiple line XML field would look like:

<QGEN> Yellow^^{Bathcolour} [LF] Green^^{Basincolour}<\QGEN>