Skip to content

Export Departments from Sage 200 Evolution

This task will export departments from Sage 200 Evolution to an XML file.

Settings

Connection

Required
The Sage 200 Evolution connection to use. See Connecting to Sage 200 Evolution

Export New, Modified or All Records

Required
Choose the type of export to perform against Sage. The following options are available:

  • New - Will output any record that has not been output by Zynk before. This is determined based on the entries in the Truth Table.
  • Modified - Will output any record that has not been output by Zynk before, or has changed since it was last output by Zynk. This is determined based on the entries in the Truth Table.
  • All - Will output all records.

Filter

Optional
Provide an SQL where clause if you would like to filter the records returned by export. You will need to consult the Sage 200 Evolution database via the SQL Server Management Studio application to obtain the field names.

Output File

Required
The XML file to save the exported records to.

Zynk Settings

See Common Task Settings

Examples

A sample output file is shown below.

<?xml version="1.0" encoding="utf-8"?>
<Departments>
  <Department>
    <Id>1</Id>
    <Code>MAIN</Code>
    <Description>Main Department</Description>
    <Information>Main Department</Information>
  </Department>
</Departments>