@Donal McCarthy I'm not sure what you mean by what type of column is it? sorry.
I just created a text box called unique customer id. I then created a personal view and added that column in.
I tried to populate that column for all active accounts A1, A2..... etc... most took but then a few thousand never populated. I did it all via Excel online. I tried the XRM bulk data rouote first but it kept erroring off and wouldnt let me update so then I had to do it manually.
Now I am trying to ONLY remove all these populated with data in this field and clear it out since I have to do it over again and include the missing accounts. but I cannot get it to work. It keeps erroring off and I am slowly going crazy. :)
------------------------------
Heather L
------------------------------
Original Message:
Sent: Feb 18, 2021 02:52 AM
From: Donal McCarthy
Subject: Open in Excel Online- Does anyone use this option?
What type of column is it?
Some columns are not nullable via import.
You should be able to do this with Bulk Data Updater in Xrm Tool Box - it has a 'Set null' option.
------------------------------
Donal McCarthy
Digital Marketing Administrator
BrightWork
Galway
Original Message:
Sent: Feb 17, 2021 04:33 PM
From: Heather Laughlin
Subject: Open in Excel Online- Does anyone use this option?
I am looking for guidance - does anyone use this option? I don't know if I am doing something wrong on my end (its always worked before) or if there is an issue I need MS to assist with. I tried to update a field on my account form. I ran a view and it let me upload and open in excel online but now I need to remove all data in this specific field (delete for all) and I try to delete and then save back to CRM and I keep getting errors!
I don't know HOW or why since I am literally just removing data from a field.
I have large records- so unsure if this is an issue- I might need to break it up but no matter what I try I keep getting errors.
I always use this option to update records here and there and never have issues. yet now I can't get it to work.
thanks
#Admin
#Focus-D365UG/CRMUG
------------------------------
Heather L
------------------------------