|
SliQ supports import and export of customer data and product data.
The main purpose of the data import/ export facilities is to
allow synchronisation of data between installations of SliQ. For
example if 2 people are using copies of SliQ on different PCs and
are adding new customers and products, they can export their
definitions to each other.
The product data exported from SliQ is in XML into a file with
extension .slp. The following is an example products export file
containing 2 product definitions:
Example Exported
Products File: productsexport.slp
<?xml
version="1.0"?>
<Products>
<ItemCodes>
<Format>1</Format>
<ItemCode>
<ItemCode>Gate
Posts</ItemCode>
<UniqueID>653bf5cc-a13c-45e1-942b-39941f5a48b2</UniqueID>
<Description>Standard
Gate Posts</Description>
<UnitPrice>10</UnitPrice>
<ItemKind>Product</ItemKind>
<DiscountType>0</DiscountType>
<VATRate>
<VATRateValue>0.00</VATRateValue>
</VATRate>
</ItemCode>
<ItemCode>
<ItemCode>Regular
Purchase Discount</ItemCode>
<UniqueID>62168948-b5da-4eb0-90a3-5ca2c2f9acc8</UniqueID>
<Description>10%
discount for regular purchases</Description>
<UnitPrice>10</UnitPrice>
<ItemKind>Discount</ItemKind>
<DiscountType>0</DiscountType>
<VATRate>
<VATRateValue>0.00</VATRateValue>
</VATRate>
</ItemCode>
</ItemCodes>
</Products>
Product Details File
Structure
The XML file contains a series of nested XML elements. These are
explained in the following table.
|
Element
|
Description
|
|
<?xml
version="1.0"?>
<Products>
<ItemCodes>
</ItemCodes>
</Products>
|
These elements must surround the list of
product definitions.
|
|
<Format>1</Format>
|
This is the version of the format of the
product details file.
SliQ 1.4 exports and imports files with
format version 1.
|
|
<ItemCode>
...
</ItemCode>
|
Place each product definition inside an
<ItemCode> element.
|
|
<ItemCode>Fence
Wire</ItemCode>
|
The name of the product.
|
|
<UniqueID></UniqueID>
|
This is an internal value used by SliQ. If you have written
product information from an external application, this value can be
left out or left blank, i.e. written as:
<UniqueID></UniqueID>
Whenever SliQ imports product
data it assigns a new ID so this value is effectively not used
during the export/ import process.
|
|
<Description>Standard
Gate Posts</Description>
|
The product description.
|
|
<UnitPrice>12.1</UnitPrice>
|
A floating point value giving the unit
price of the product. Do not include a currency symbol.
|
|
<ItemKind>Discount</ItemKind>
|
Define whether the ItemCode is an Product or Discount.
|
|
<DiscountType>0</DiscountType>
|
Define whether a discount is a percentage (0) or absolute amount
(1).
|
|
<VATRate>
<VATRateValue>0.00</VATRateValue>
</VATRate>
|
The VAT/ Tax Rate for the product, e.g.
0.00 or 17.5.
|
See Also
|
