I am trying to reimport existing data. For this I have created excel file from advance find with selected columns.
While on import completion, It shows me total processed records is 296 but in my excel sheet it contains 480 records.
I am not able to find where the remaining excel records gone.
Note :below image shows transforming but after status complete total processed shows 296. it must show 480 records
so other than 296 are failed or what?
If my answer helped you, Please mark it as verified answer.
Thanks and Regards,
My blog: http://dynamicsofdynamicscrm.wordpress.com/
Microsoft Specialist: Microsoft Dynamics CRM 2013 Applications,Extending Microsoft Dynamics CRM 2013,Microsoft Dynamics CRM 2013 Deployment,Microsoft Dynamics CRM 2013 Customization and Configuration
MCTS: Dynamics CRM 2011
The CRM will only process those records that are updated.
For example you have 10 records, you keep remain 6 records, so only 4 that will be processed and you will only see total processed = 6.
When you export at the very first originally
then you update to
guid1 AAAAA //updated
guid5 EXYASYAS //updated
guid6 FUNNY //updated
guid9 IJKLASAS //updated
you have 10 records in your excel sheet, that is correct/
But in fact you only update 4 records as per example, so what will happen when you re-import it back? You will see only 4 records in the total processed column.
This is also will happen exactly the same on your record. 296 of 480 your records were updated so that you will see 296, while the rest (480-296) is still remain the same value, so CRM detected it, wont process it.
Its counter does not mean how many records rows you have in excel, but how many records have changed in their value, either Update or create new line there, this is how CRM calculate the total processed if you import, different if you Create (not using re-import), CRM will process all to create all records.
Hope this helps.