King Connector - Customer Update
The King connector synchronizes customer data by processing an XML file named customers.xml from an FTP server. This process updates customer core fields, addresses, contact persons, and other related data in App4Sales. The synchronization is performed by downloading the XML file, parsing its content, and mapping the data to the App4Sales database.
Data Source Configuration
The connector downloads the customers.xml file from the root folder of the configured FTP server. The FTP connection details (host, username, password, and port) are configured in the administration settings.
Customer Core Fields
App4Sales Field | Source Field (XML) | Logic/Notes |
CustomerGuid | customers.customerguid (old format) or CustomerGuid (new format) | The unique identifier for the customer. |
CustomerCode | customers.customercode (old format) or CustomerCode (new format) | The customer's code. |
CustomerName | customers.customername (old format) or CustomerName (new format) | The customer's name. |
ChamberOfCommerceCode | customers.chamberofcommercecode (old format) or ChamberOfCommerceCode (new format) | The customer's Chamber of Commerce code. |
VatCode | customers.vatcode (old format) or VatCode (new format) | The customer's VAT code. |
VatLiable | customers.isvatliable (old format) or VatLiable (new format) | A boolean indicating if the customer is VAT liable. Parsed from a string. |
Discount | customers.discount (old format) or Discount (new format) | The customer's discount percentage. Converted to a decimal. |
UsesPriceField | customers.usesprice (old format) or UsesPriceField (new format) | The price field used by the customer. Parsed as an integer. |
ActionPriceList | customers.actionpricelist (old format) or ActionPriceList (new format) | The action price list for the customer. Parsed as an integer. |
HidePrices | customers.hideprices (old format) or HidePrices (new format) | A boolean indicating if the prices should be hidden for the customer. Parsed from a string. |
LanguageCode | customers.languagecode (old format) or LanguageCode (new format) | The customer's language code. |
CustomerManager | customers.customermanager (old format) or CustomerManager (new format) | The manager responsible for the customer. |
Sysmodified | customers.lastmodified (old format) or lastmodified / sysmodified (new format) | The date and time the customer was last modified. Parsed as a DateTime. |
CustomerDashboard | customers.customerdashboard (old format) or CustomerDashboard (new format) | The customer's dashboard layout. |
DynamicFreeFields | customers.dynamicfreefields (old format) or DynamicFreeFields (new format) | XML containing dynamic free fields. |
FreeFields | customers.freefields (old format) or FreeFields (new format) | XML containing free fields. |
CustomerClassification | customers.customerclassification (old format) or CustomerClassification (new format) | The customer's classification. |
ItemFilter | customers.fixeditemfilter (old format) or ItemFilter (new format) | A fixed item filter for the customer. |
CustomerNote | customers.customernote (old format) or CustomerNote (new format) | A note for the customer. |
PaymentConditionCode | customers.paymentcondition (old format) or PaymentConditionCode (new format) | The customer's payment condition code. |
DeliveryMethod | customers.termsofdelivery / customers.deliverymethod (old format) or DeliveryMethod (new format) | The customer's delivery method. |
Filters | customers.filters (old format) or Filters (new format) | Filters for the customer. |
Addresses
App4Sales Field | Source Field (XML) | Logic/Notes |
AddressType | - | Set to "inv", "del", or "vis" for invoice, delivery, and visit addresses, respectively. |
AddressLine1 | customers.invoiceaddress1 / customers.visitaddress1 / customers.deliveryaddress1 (old format) or AddressLine1 (new format) | The first line of the address. |
AddressLine2 | customers.invoiceaddress2 / customers.visitaddress2 / customers.deliveryaddress2 (old format) or AddressLine2 (new format) | The second line of the address. |
PostCode | customers.invoicepostcode / customers.visitpostcode / customers.deliverypostcode (old format) or PostCode (new format) | The postal code. |
City | customers.invoicecity / customers.visitcity / customers.deliverycity (old format) or City (new format) | The city. |
Country | customers.countrycode (old format) or Country (new format) | The country. If not provided, it may fall back to the customer's language code. |
customers.contactemail (old format) or Email (new format) | The email address. The same email is used for all address types. | |
Phone | customers.contactphone (old format) or Phone (new format) | The phone number. The same phone number is used for all address types. |
Fax | customers.contactfax (old format) or Fax (new format) | The fax number. The same fax number is used for all address types. |
Contacts
App4Sales Field | Source Field (XML) | Logic/Notes |
FullName | customers.contactfullname (old format) or FullName (new format) | The full name of the contact person. |
customers.contactemail (old format) or Email (new format) | The contact person's email address. Inherited from the main customer contact email. | |
Phonenumber | customers.contactphone (old format) or Phonenumber (new format) | The contact person's phone number. Inherited from the main customer contact phone. |
DynamicFreeFields | DynamicFreeFields | XML containing dynamic free fields for the contact person. |
Related Settings & Prerequisites
The following settings in the administration can affect the customer synchronization process:
FTP Server Details: The FTP host, username, password, and port must be correctly configured for the connector to download the
customers.xmlfile.Webservice Port: The port for the King webservice, used for various operations.
Webservice Address: The full address of the King webservice.