Convert Historical Data

Datum: 2020-12-03
Versie: 1.0

General

How do you migrate from another system to Ecmanage where your customer can be helped to convert historical data?

There are two areas we often see the request for conversion, the first is the balance of points for a wearer of clothing and the second is the number of items a wearer of clothing has in his or her possession.

Import balance of points per person

In order to import the balance of points please first setup the environment in Ecmanage and create all persons. Using the “Person budget” import facility you can ensure each person has the correct balance.

Please follow instructions 17. Person budget

Import items in possession

In Ecmanage we have the option to import historical orders. It is important to provide information about the person for who these items are and the date at which these items have been ordered. To make the order complete we need the identification of the items that have been ordered with their respective quantities.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<orders>
   <order consigneeid="johndoe" purchaserid="johndoe" historical="2020-11-16 15:00:00" outofbudget="Y">
      <address addresstypeid="4" />
      <orderdetails>
         <orderdetail assortmentid_extern="SHIRT_XL" quantity="1" />
         <orderdetail assortmentid_extern="TROUSER_BROWN_54" quantity="1" />
         <orderdetail assortmentid_extern="SOCKS_BLACK" quantity="2" />
      </orderdetails>
   </order>
</orders>

A description of all the fields can be found below:

Field name in XML: consigneeid
Type of field: Max 20 characters
Mandatory: Yes
Description: This is the personid_extern for the wearer.
   
Field name in XML: purchaserid
Type of field: Max 20 characters
Mandatory: Yes
Description: This is the personid_extern for the person that places the order. This can be identical to consigneeid.
   
Field name in XML: historical
Type of field: YYYY-MM-DD HH24:MM:SS
Mandatory: Yes
Description: This is the historical date for the order.
   
Field name in XML: outofbudget
Type of field: Y/N max. 1 character
Mandatory: Yes
Description: This ensures the order has no influence on the budget of the wearer.
   
Field name in XML: assortmentid_extern
Type of field: Max 50 characters
Mandatory: Yes
Description: This is the unique id of an article with a specific size.
   
Field name in XML: quantity
Type of field: numeric
Mandatory: Yes
Description: Amount of items.

Use the import data facility in ecmanage to process these historical orders in the respective environment.

We also have an Excel template to assist in the creation of this order xml file using Excel: orderimport_en.xlsm