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
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>