Skip to content

Importing Vendors into Sage 50 CA

This task will create new or update existing vendors in Sage, based on the data supplied in an XML file.

Settings

Sage 50 CA Connection

Required
Select a Sage 50 CA connection to use. See the Connecting to Sage 50 CA article if you require more information on how to create/manage connections.

Fail File

Required
The name of the file to write failed records to. The data will be output in the same XML format as the Input File. A sample can be found below.

Input File

Required
The name of the file containing the data you want to import into Sage. The data must be in XML format, a sample of which is shown below.

Success File

Required
The name of the file to write successfully processed records to. The data will be output in the same XML format as the Input File. A sample can be found below.

Alert Management Rules

Optional
Sage may generate alerts when importing data, which will cause the record to fail to import unless a response is provided. These alerts will appear as a warning in Zynk's logs, which will also show what responses can be provided.

This setting allows you to configure a series of rules which will provide a response to these alerts. The settings for each rule are as follows:

  • Match Type - The type of matching to apply to the alert message. The following options are available: Equals, Contains, StartsWith and EndsWith.
  • Match Value - The value to match the alert message with.
  • Response - The response that should be provided to Sage when a matching alert is raised.

Prevent Reprocessing

Required
Set to 'True' to prevent the same record being processed more than once. This works based on the value of the ExternalId element provided within the Input File.

Match Fields

Optional
Select fields to use to try and identify matching vendors that already exist in Sage. This setting will only take effect when a Name is not provided in the input file.

Zynk Settings

See Common Task Settings

Examples

A sample input file is shown below. For more information about the XML format, please refer to Sage 50 CA Vendor XML.

<?xml version="1.0" encoding="utf-8"?>
<Vendors>
  <Vendor>
    <ExternalId>123</ExternalId>
    <Name>Zynk Software</Name>
    <CurrencyCode>CAD</CurrencyCode>
    <Contact>John Smith</Contact>
    <Street1>i6</Street1>
    <Street2>6-8 Charlotte Square</Street2>
    <City>Newcastle</City>
    <Province>Tyne &amp; Wear</Province>
    <PostalCode>NE1 4XF</PostalCode>
    <Country>Great Britain</Country>
    <Phone1>0191 820 1484</Phone1>
    <Phone2>0191 820 1484</Phone2>
    <Fax>0191 820 1484</Fax>
    <Email>[email protected]</Email>
    <Website>www.zynk.com</Website>
  </Vendor>
</Vendors>