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 customer data exported from SliQ is in XML into a file with extension .slc. The following is an example customers export file containing 2 customer definitions:

 

Example Exported Customers File: customersexport.slc

 

<?xml version="1.0"?>

<AllCustomers>

<Customers>

  <Format>1</Format>

  <Customer>

    <CompanyName>ACompany Ltd</CompanyName>

    <Title>Mr</Title>    

     <FirstName>Jim</FirstName>

    <LastName>Evans</LastName>

    <ContactName>Mr Jim Evans</ContactName>

    <ID>93bdcb6f-19a5-4e23-8223-eedc8b018892</ID>

    <Address>

       2, The High St,

       A town,

       A County

       PY1 12D

    </Address>

    <DeliveryAddress>

       3, The High St,

       A town,

       A County

       PY1 12D

    </DeliveryAddress>

    <PhoneNumber>01987 111222</PhoneNumber>

    <FaxNumber>01234 567896</FaxNumber>

    <EmailAddress>Jim@Acompany.com</EmailAddress>

    <Website>www.acompany.com</Website>

    <Notes>These are notes on the customer preferences</Notes>

    <Term>0</Term>

  </Customer>

  <Customer>

    <CompanyName>AnotherCompany Ltd</CompanyName>

    <ContactName></ContactName>

    <ID>f7fb568e-6c2e-41c5-bc97-e2998621852a</ID>

    <Address></Address>

     <DeliveryAddress></DeliveryAddress>

     <PhoneNumber></PhoneNumber>

     <FaxNumber></FaxNumber>

     <EmailAddress></EmailAddress>

     <Website></Website>

     <Notes></Notes>

    <Term>0</Term>

  </Customer>

</Customers>

</AllCustomers>

 

 

Customer 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"?>

<AllCustomers>

<Customers>

...

...

</Customers>

</AllCustomers>

These elements must surround the list of customer definitions.

<Format>1</Format>

This is the version of the format of the customer details file.

 

SliQ 1.4 exports and imports files with format version 1.

<Customer>

....

....

</Customer>

Place each customer definition inside a <Customer> element.

<CompanyName>ACompany Ltd</CompanyName>

The name of the customer.

<Title>Mr</Title>

The title from the customer's contact name.

<FirstName>Jim</FirstName>

The first name from the customer's contact name.

<LastName>Evans</LastName>

The last name from the customer's contact name.

<ContactName>Jim</ContactName>

The customer's contact name.

 

Note: If a file is imported and the title, first name and last name fields are not present, the contact name will be imported into the last name field in SliQ versions 2.2.9 or greater.

<ID></ID>

This is an internal value used by SliQ. If you have written customer information from an external application, this value can be left out or left blank, i.e. written as:

 

<ID></ID>

 

Whenever SliQ imports customer data it assigns a new ID so this value is effectively not used during the export/ import process.

<Address>

 2, The High St,

 A town,

 A County

 PY1 12D

</Address>

The customer's address.

<DeliveryAddress>

 3, The High St,

 A town,

 A County

 PY1 12D

</DeliveryAddress>

The customer's delivery address.

<PhoneNumber>01987 111222</PhoneNumber>

The customer's telephone number.

<FaxNumber>01234 567896</FaxNumber>

The customer's fax number.

<EmailAddress>Jim@Acompany.com</EmailAddress>

The customer's contact email address.

<Website>www.acompany.com</Website>

The customer's website.

<Notes>

Some notes on the customer

</Notes>

Any notes you wish to keep about the customer.

<Term>0</Term>

The customers standard payment terms - the number of days after invoicing before payment is overdue. 0 = pay on receipt.

 

 

See Also