Excel Migration job (w/ custom field) -- Error Message Help

THANK YOU SO MUCH 😀 I made those exact changes and it “Updated” upon execution AND the updates are reflected in the IEE client. If you have a good link or anything that could help explain why those changes are what I needed, that would be awesome.. I can see more requests coming for similar jobs. I’ve scoured the IFS Docs site, but the information is limited.

You’ve made my day, Jens!!

-Jenna

Hi Jenna,

• - Always map fields with a value where you have the flags P, K or M because these are mandatory fields
• - If you have a field with the suffix _DB and a correspondig field without _DB, e.g. SALES_PRICE_TYPE_DB and SALES_PRICE_TYPE, map the field with the suffix _DB and keep the field without the suffix _DB empty. Why? The field without _DB is the translated content of the field with _DB. 

Example:

PARTY_TYPE = 'Customer', PARTY_TYPE_DB is empty

If you create your migration job with an english client and execute it then it works but if you execute the same migration job with a german client then it fails because the right value for PARTY_TYPE in german is 'Kunde'. 

Solution:

Mapping for PARTY_TYPE has to be empty, mapping for PARTY_TYPE_DB has to be 'CUSTOMER'. Then you can execute your migration job with every language in 99.99% of your cases.

Special feature:
If such fields/combinations (e.g. PARTY_TYPE and PARTY_TYPE_DB) declared as key fields (Flags K and P) then you have to go to the screen Method List Attribute and you have to do a kind of "key manipulation" for the migration job. No worries, there will be no change for the table in the database, it's only related to this migration job.
The migration tool checks depending on the key fields (flags K and P) in the screen Method List Attributes if a record already exists. If yes then an update will be done, otherwise an insert will be performed.

The minus sign means:

Ignore this field in the search if a record already exists because searching for a translated field ends with your error above.

The combination of all key fields (flags P and K) in the screen Method List Attribute must be unique and all these key fields must have a mapped value in the Source Mapping. NULL (or 'NULLVALUE') is not a value for a key field.

I hope that helps a bit and there is also the opportunity to order a training incl. tips and tricks for data migration by IFS.

Happy migration and have a wonderful day.

/Jens