I’ve used Excel Data Migration Tool before. But now I got this problem that when I try Validate or Execute, Excel-Add-In reads everything to the first column. I have a simple example with 2 columns A and B. But Excel-Add-In reads both column A and B to the first column. So the value for column A is getting to long and the value for column B is left empty.
Is there some configuration for this. Thankful for ideas.
BR,
Patric
Page 1 / 1
Hi @evrpatrin
Which Migration Job are you using and how many columns is the job expecting?
First I tried with a job for Inventory Location. But when I got this error I created a new job for basic data for Eng_Part_Main_Group. The job have 2 columns.
A - Part Main Group
B - Description
And when i add values to column A and B and try Validate or Execute both column A and B is added to Part_Main_Group and Description is getting NULL.
@evrpatrin I have just created an Excel Migration Job for Sales Region and all has worked.
The Migration Job:
On validating in Excel Migration the Result column displayed Validate OK
Next clicked Execute and the Excel Migration displayed ‘Inserted’
And on refreshing the Sales Regions page:
I hope this helps.
If you are still having issues please let me know.
John
@evrpatrin To help I have just created one for Eng Part Main Group
Created Migration Job
Step 2 - Excel Migration Tool
Connect and open the migration job EXCEL_ENG_PART_MAINGRP
Enter data completing the first 2 columns in this case:
Click Validate and select required option. I clicked in the data field and selected Selected rows only:
Validate OK was returned in the Result column:
As everything was OK clicked Execute and chose Selected rows only:
The Result column displayed ‘Inserted’:
On checking the Part Main Group and refreshing the row added was displayed: