Skip to main content
Question

Cloud Migration Job Procedure EXCEL_MIGRATION error

  • Jul 10, 2025 8:12 AM UTC
  • 9 replies
  • 162 views

Patrycja_MM
Sidekick (Customer)
Forum|alt.badge.img+5

In the customer card, under the Address tab, I have added a new Custom Field – Account Manager.

I would like to use a migration job targeting the view CUST_ORD_CUSTOMER_ADDRESS to insert/update this field.

I created the following migration job based on my experience with IFS 9.


 

9 replies

Patrycja_MM
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • Jul 10, 2025 11:52 AM UTC

The full description is in the file. I'd appreciate your help.

 

Best regards,
Patrycja


Forum|alt.badge.img+3

Hi Patrycja,

 

I guess the “METHOD LIST” is not setup correctly.

 

Can you show a screenshot of the method list?

 

Best regards,

 

Johannes

 


Forum|alt.badge.img+3

 Hi Patrycja,

 

attached an “easy” example for COMPANY:

 

Method List

 

 

As only one method is used, you don´t need a fetch condition.

 

Is that working for you?

 

Best regards,

 

Johannes


Patrycja_MM
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • Jul 21, 2025 12:22 PM UTC

Through trial and error, I managed to configure the excel migration job to a custom field.
I'm attaching screenshots.


Thank you for the tips. :)


Best,
Patrycja


Forum|alt.badge.img+3

Hi Patrycja,

that looks good.

Best regards,

Johannes


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • Oct 10, 2025 3:28 PM UTC

Patrycja,  can you describe what this screen shot from your documentation is all about?

 


Patrycja_MM
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • Oct 30, 2025 10:11 AM UTC

Hi,

 

The data visible in the screenshot is:
- CFV view
- selected fields with numbers (Pos column), the rest set to zero,
- descriptions in the Source Column only for the fields used in the migration task (Flags = P and those you want to add or modify).

I'm not removing the remaining fields from the migration task. The task is universal, meaning you can change them and edit another field if necessary.

 

Best,

Patrycja


Patrycja_MM
Sidekick (Customer)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • Oct 30, 2025 10:11 AM UTC

Hi,

The data visible in the screenshot is:
- CFV view
- selected fields with numbers (Pos column), the rest set to zero,
- descriptions in the Source Column only for the fields used in the migration task (Flags = P and those you want to add or modify).

I'm not removing the remaining fields from the migration task. The task is universal, meaning you can change them and edit another field if necessary.

Best, 

Patrycja


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • Oct 30, 2025 1:42 PM UTC

Thanks for some clarification.  So you chose to be more selective with what is available for add/modify instead of ALL columns.  Got it.

Your solution has been a Godsend.  thanks again!