Customer experience | Sales, Customer Insights,...

Opportunities Entity import error

(0) Share

Report

Posted on by Sara Imran

An excel file was uploaded in Opportunities entity and all the existing records in entity just went blank like (title, account name, contact name etc.) just disappeared and a dashed line appeared in their place instead. (screenshot attached). 2437.a.PNG

1) what actually went wrong here??

2) Can I recover the lost data in the future?

2) What security measures should I take to avoid data loss in the future?

I have the same question (0)

All responses (6)

Answers (0)

Temmy Wahyu Raharjo 2,916 on at

Like (0)

Report

RE: Opportunities Entity import error

Hi, how you prepare your excel in the first place? Do you export it from advanced find, then fill it again using the formatted result?

Was this reply helpful? Yes No
Suggested answer

Pradeep Rai 5,489 Moderator on at

Like (0)

Report

RE: Opportunities Entity import error

Hi,

Below are suggestions for your questions:

1) what actually went wrong here? - This may happen because excel values are not proper or may be during the import mapping fields are ignored

2) Can I recover the lost data in the future? - Better to take backup whenever we are importing data.

3) What security measures should I take to avoid data loss in the future?-Better take backup of existing entity data.
You can use below plugin of Xrmtoolbox to take backup:
https://www.xrmtoolbox.com/plugins/ITLec.RaiseYourVoice.D365RestorePoint/

Thanks,
Pradeep.
Please mark this as VERIFIED if it helps.

Was this reply helpful? Yes No
Rakesh90 200 on at

Like (0)

Report

RE: Opportunities Entity import error

Hi Sara Imran

If you have Auditing enabled in the entity, you can recover the lost data.

To recover the lost data use Recycle Bin app from Xrmtoolbox.

When bulk updating fields, make sure you delete the columns from the excel that you dont want to update (except the hidden A,B,C columns)

If the above suggestion worked, please mark my answer as verified

Was this reply helpful? Yes No
Suggested answer

Yoshika Suzuki on at

Like (0)

Report

RE: Opportunities Entity import error

Did the existing record get overwritten?

Did you export the original data, modify it and import it?

How about allowing duplicate records and importing them?

You can restore the environment from PPAC. However, not only Opportunity, but all data in the environment will be restored.

Was this reply helpful? Yes No
Sara Imran 20 on at

Like (0)

Report

RE: Opportunities Entity import error

Yes. I export the excel file with the existing data that's already there and then add the new data in the fields and then import it again

Was this reply helpful? Yes No
Sara Imran 20 on at

Like (0)

Report

RE: Opportunities Entity import error

Yes it seems it got overwritten but like instead of names and values, the data fields are displaying these dashed lines. So the data has been replaced by these dashed lines idk how and why

Yes. I export the excel file with the existing data that's already there and then add the new data in the fields and then import it again

I'm selecting no for the allow duplicate records option;

Yes looking into PPAC but I just want to ensure it doesn't happen again

Was this reply helpful? Yes No

Join the conversation

Community site session details

Opportunities Entity import error

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Opportunities Entity import error

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates