|
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>
<ContactName>Jim</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.
|
|
<ContactName>Jim</ContactName>
|
The customer's contact name.
|
|
<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
|
