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