SBX - Search With Button

SBX - Forum Post Title

Import problems

Microsoft Dynamics CRM Forum

Davor S asked a question on 5 Nov 2018 6:37 PM

Question Status

Suggested Answer

Hi,

I am facing strange problems with data import.


Usually for option set fields I am able to select value for mapping,
but currently I am not able to do so, i am offered only with Ignore value.

In field settings I have this value defined.

Thanks in advance for sharing help 

Reply
Suggested Answer

Hi Davor S,

There may be an issue with the Excel document. Did you download a template for data import?

Reply
Ravi Kashyap responded on 5 Nov 2018 7:08 PM
Suggested Answer

Hi,

Try publish all customization and import/ map again.

Hope this helps.

Reply
Ravi Kashyap responded on 5 Nov 2018 7:18 PM
Suggested Answer

It is observed that others are also facing the same/ similar issue. It is best you contact MS Support on this issue.

community.dynamics.com/.../300222

Hope this helps.

Reply
Davor S responded on 5 Nov 2018 7:20 PM

Thank you all for quick answers.

This isn't my first time i do the import so the process should be the same.

I save the excel file as cvs format.

The error is sometimes like the one on picture above, and sometimes i get:

Meaning that i cant select mapping for option set fields. 

Reply
Ravi Kashyap responded on 5 Nov 2018 7:38 PM

Hi Davor,

Did you check my above message, it seems like an issue with the product as there are other facing the same issue.

Reply
Davor S responded on 6 Nov 2018 12:55 AM

Thank you, I just saw other thread

Reply
BusyIntelligence responded on 6 Nov 2018 2:17 PM
My Badges

Glad to see I'm not the only one with this error.

I have a ticket raised with MS Support last Saturday and am trying to escalate it...

Kind regards,

Maurits

Reply
Davor S responded on 7 Nov 2018 12:39 AM

Please share with us the progress with resolving the issue.

Reply
Simon Niederkircher responded on 9 Nov 2018 10:22 AM
My Badges
Suggested Answer

A workaround to that is to name your source datas header columns exactly as the Dynamics crm fields.

Also the values in your source must have exactly the values available in Two Options Fields and Option Sets.

Then the wizard does an auto mapping (you do not need to click through the buggy user interface) and will import the data.

Hope that helps.

Reply
BusyIntelligence responded on 9 Nov 2018 3:18 PM
My Badges

Hi Simon, I must admit I haven't tried that. Might work.

Nevertheless, I received this info from Microsoft Support this morning:

"...this is a known issue and it is going to fix by the end of this week or probably by the coming week."

Reply
BusyIntelligence responded on 11 Nov 2018 5:37 AM
My Badges

Hi All, yesterday this issue was solved by MS on my tenant!

Import Wizard works okay again.

Reply
Suggested Answer

Hi Davor S,

There may be an issue with the Excel document. Did you download a template for data import?

Reply
Ravi Kashyap responded on 5 Nov 2018 7:08 PM
Suggested Answer

Hi,

Try publish all customization and import/ map again.

Hope this helps.

Reply
Ravi Kashyap responded on 5 Nov 2018 7:18 PM
Suggested Answer

It is observed that others are also facing the same/ similar issue. It is best you contact MS Support on this issue.

community.dynamics.com/.../300222

Hope this helps.

Reply
Simon Niederkircher responded on 9 Nov 2018 10:22 AM
My Badges
Suggested Answer

A workaround to that is to name your source datas header columns exactly as the Dynamics crm fields.

Also the values in your source must have exactly the values available in Two Options Fields and Option Sets.

Then the wizard does an auto mapping (you do not need to click through the buggy user interface) and will import the data.

Hope that helps.

Reply

SBX - Two Col Forum

SBX - Migrated JS