Can/Should Inactive records be updated via Data Import Wizard?

(1) Share

Report

Posted on by JustJake

Is it bad practice to update Inactive records on our custom entities via an excel export-then-import using the Import Wizard?

Or do these records need to be activated before being updated?

There are no workflows or other processes that need to run after/during these record updates.

[Dynamics 365 OP 8.2.3.8]

Thanks,

Jake

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi JustJake,

There is no need to active records before importing them.

Through my test, I export them to edit and import them again directly, which can update inactive records successfully.

Before:

After:

Also, you can try to use Bulk Data Updater tool to update inactive records in XrmToolBox, which maybe one better way.

(1)Load one entity you need and select one view.

(2)Update fields with value you need.

(3) Result:

Note:

(1) Download XRM ToolBox. https://www.xrmtoolbox.com/

(2) Once you have downloaded and installed it, then connect to you crm environment.

Insert organization url and passward, you can connect successfully.

Or using SDK Login Control and next Office 365 sign-in.

https://community.dynamics.com/365/customerservice/f/dynamics-365-for-customer-service-forum/420526/xrm-tool-box-to-dynamics-crm-connection

(3) Go library to install Bulk Data Updater.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No