25
When I look at the contacts, I know we have in excess of 5000+ (don't know exactly how many, if I try to export them it never completes the task).
If I do a query on Active contacts, and Inactive contacts the total is about 1750 - so where are all the others? There are therefore at least 3250 that are neither active nor inactive - how does that happened and where do I find them?
Hi JMGTaylor,
You can use ODATA, FetchXML or Query object for more than 5000+ records. Hereby take as a reference following links:
azurefunda.blogspot.com/.../retrieve-5000-records-in-dynamics-crm.html
hachecrm2011.wordpress.com/.../
community.dynamics.com/.../985543
community.dynamics.com/.../odata-web-api-crm-online-how-to-query-more-than-5000-records
Re Advanced find
Do not use Selection criteria but add the Status column instead.
Re Export
How do you export before it hangs?
Re legacy data
When you import data and the status column in your import file does not contain data, then the record is active by default. Therefore I do not understand how this problem occurred in the first place.
Re add status
Maybe you could fill empy status fields by using a workflow. IF ContactStatus does not contain data, THEN Update Contact .....
I have been using advanced find but something drops them out, I have found that some contacts now don't have an active or inactive status - ie. the field is blank, but the advanced find function wont allow me to search for these - if I do "not active" and are "not inactive" then nothing comes back BUT I know there are some in that manner. Sadly the advanced find wont allow you to search for NULL, the "does not contain data" does not pick them up either so not sure how I can find them from 11000 contacts.
Would be nice if I could just export these 11000 contacts but that just hangs too.
Not sure how we ended up with contacts that are neither active nor inactive - suspect its legacy data from before we got MS CRM.
Hi JMGTaylor,
I would query the database using Advanced Find. If you start hitting the button New, you are sure there are no selection criteria whatever. Then you should get all records in the Contact entity.
Regards,
Thijs
Hi Partner,
You could use Advanced Find to find all the contacts with your own filter conditions.
And please check if your conditions are only active and Inactive?
Please share more details about your query conditions.
Best Regards,
Leo
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (