[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 90
  • Last Modified:

How can I assign and edit records in bulk in Microsoft Dynamics 2013

Hi,

I have received a requirement lately from the business asking to be able to bulk edit and assign records from a custom entity in one step/form. I discovered the bulk edit which is partly what we are trying to accomplish but it has some restrictions. In bulk edit, we are not allowed to change the records assignment to another user - as this is a business required field and I cannot change that. Also, the fields that we want to modify are spread out across the form. A dialog will only work for one record at a time and won't let me assign the file and a workflow will not gather user input so it is useless.

Is there a simple and better way of accomplishing this?

Please let me know.
Thanks!
0
IT-Services-TI
Asked:
IT-Services-TI
  • 4
  • 3
3 Solutions
 
Feridun KadirPrincipal ConsultantCommented:
You can assign records in groups of 250 records (this is the maximum number of records per page in views). Select all the records on the page and then Assign on the command bar.

For bulk editing other fields, you could export the records to Excel,make the changes in Excel and then import the records back.
0
 
IT-Services-TIAuthor Commented:
Is there a way to do both actions in one single step - without coding a solution? Can we edit the assignment field in excel?
0
 
Feridun KadirPrincipal ConsultantCommented:
Yes you can.

If you try this, I suggest you test it on a small group of records just to make sure that it works as you expect it to.
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
IT-Services-TIAuthor Commented:
Ok. I will give Excel a try. I'll let you know how it goes. Thanks for your help.
0
 
IT-Services-TIAuthor Commented:
Unfortunately I can see two reasons why this would not work in our situation. 1st, you have to modify each record individually even if the new value has to be the same for all of them - duplicate work and risk of typing error. 2nd, you don't get lookup values so the user could input a wrong value - again there is room for error. This would work in a situation where the system administrator would have to fix data issues without going to the database but for a user on their day to day operations, it doesn't seem convenient.

Any other ideas?
Cheers
0
 
Feridun KadirPrincipal ConsultantCommented:
Yes each record does need to changed individually, I was thinking you could use the Replace feature in Excel to change multiple records.
Regarding lookups, you are correct the value does have to be correct.

I'm sorry I don't have any other suggestions for you.
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
Hi,

I would suggest you go for SDK calls with custom .net application. The application will have the ability to bulk edit the records and assignment.

Let us know if you need any help with that.

Regards,
Rikin
0
 
IT-Services-TIAuthor Commented:
Ok. Thanks for your suggestions guys. I appreciate it. I will consult the business to see how they want to proceed.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now