SORTAM: SOR Archive Migration
The SOR Archive Migration business object lets you migrate archived sales orders from XML to SQL tables (SorArcMaster and SorArcDetail).
Properties
| Syspro Module | Sales Orders |
| Class | Transaction |
| Methods | Post |
| Functional Area | Sales Orders Primary Posting |
| Initial version released | Syspro 8 2018 R2 |
Input XML
The .XML and .XSD input files indicate the parameters schema and an instance of an XML document for this business object.
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2017 SYSPRO Ltd.-->
<!--
This is an example XML instance to demonstrate
use of the SOR Archive Migration business object
-->
<PostSORArchiveMigration xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="SORTAM.XSD">
<Parameters>
<IgnoreWarnings>N</IgnoreWarnings>
<Company>0</Company>
</Parameters>
</PostSORArchiveMigration>
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2017 SYSPRO Ltd.-->
<!--
Schema for the parameters for the SOR Archive Migration business object
-->
<xsd:schema elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="IgnoreWarnings">
<xsd:annotation>
<xsd:documentation>This element indicates whether or not a transaction must be rejected if there are any warnings such as "Document value is zero". (N - No, Y - Yes) If not supplied it defaults to 'N'. </xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Parameters">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="IgnoreWarnings" minOccurs="0"/>
<xsd:element ref="Company" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="PostSORArchiveMigration">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="Parameters"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Company" type="xsd:string">
<xsd:annotation>
<xsd:documentation>This element specifies the company which will have it's archived sales order invoices converted.</xsd:documentation>
</xsd:annotation>
</xsd:element>
</xsd:schema>
The DOC.XML and DOC.XSD files indicate the schema and an instance of an XML document for this business object.
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2017 SYSPRO Ltd.-->
<!--
This is an example XML instance to demonstrate
use of the SOR Archive Migration business object
-->
<PostSORArchiveMigration xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="SORTAMDOC.XSD">
<Function>A</Function>
<ArchiveFileName/>
</PostSORArchiveMigration>
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2017 SYSPRO Ltd.-->
<!--
Schema for the SOR Archive Migration business object
-->
<xsd:schema elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="PostSORArchiveMigration">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="Function" minOccurs="0"/>
<xsd:element ref="ArchiveFileName" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Function" default="A">
<xsd:annotation>
<xsd:documentation>This element specifies whether the business object should parse all archived files or a single one (A - All; S-Single).</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="A"/>
<xsd:enumeration value="S"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ArchiveFileName" type="xsd:string">
<xsd:annotation>
<xsd:documentation>This element specifies the file to parse if the Function is set to 'S' (Single).</xsd:documentation>
</xsd:annotation>
</xsd:element>
</xsd:schema>
Output XML
The OUT.XML indicates a sample of the XML returned by this business object.
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2015 SYSPRO Ltd.-->
<!--
Sample XML for the SO Archive Migration Business Object
-->
<SORArchiveMigration Language="05" Language2="EN" CssStyle="" DecFormat="1" DateFormat="01" Role="01" Version="8.0.000" OperatorPrimaryRole=" ">
<FailedItems>
<FailedItem>
<FailedFile>0SO00002.XML</FailedFile>
<FailedReason>Table '"..\Work\0SO00002.XML"' not found</FailedReason>
</FailedItem>
</FailedItems>
<MigrationSummary>
<FilesSuccessful>1</FilesSuccessful>
<FilesFailed>1</FilesFailed>
</MigrationSummary>
</SORArchiveMigration>
Prerequisites
No prerequisites are required to use this business object.
Limitations
No limitations apply to this business object.
Copyright © 2026 Syspro PTY Ltd.