Skip to content

Export SDO Query from Sage 50 UK

This task will export data using the Sage 50 SDO based on the settings you provide. This is mainly used to retrieve fields that are not available via ODBC.

Settings

Sage 50 Connection

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

Export Data Type

Required
The type of data you wish to export

  • Customer
  • Invoice
  • Product
  • SalesOrder

Export Settings

Required

  • Date Modified - Only records modified after this date will be exported. The date will update automatically each time the task runs.
  • Export Modified, New or All Records - Used to choose which records should be included in the export. Note that the 'Modified' setting will also export any new records.

Fields

Required
The list of fields you wish to export.

Where

Required
The collection of where clauses you wish to append to your query.

Output File

Required
The name of the file to export to. Data is exported in Zynk XML format

Zynk Settings

See Common Task Settings

Sample output file:

<?xml version="1.0" encoding="utf-8"?>
<Company
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Records>
    <Record>
      <UniqueId>88</UniqueId>
      <Fields>
        <Field>
          <Name>INVOICE_NUMBER</Name>
          <Value>88</Value>
        </Field>
        <Field>
          <Name>ACCOUNT_REF</Name>
          <Value>JOE001</Value>
        </Field>
        <Field>
          <Name>EMAILED</Name>
          <Value>0</Value>
        </Field>
      </Fields>
    </Record>
  </Records>
</Company>