Question Status

Verified
Suresh Sorde asked a question on 5 Feb 2015 5:20 AM

Hi All

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.

Please help

Urgent.

Note :below image shows transforming but after status complete total processed shows 296. it must show 480 records

Reply
Deepesh Somani responded on 5 Feb 2015 5:22 AM

so other than 296 are failed or what?

If my answer helped you, Please mark it as verified answer.

Thanks and Regards,

Deepesh Somani

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

Reply
Verified Answer
Aileen Gusni responded on 5 Feb 2015 6:52 AM

Suresh,

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.

Example:

When you export at the very first originally

Guid      Name      

===========

guid1     A

guid2     B

guid3     C

guid4     D

guid5     E

guid6     F

guid7     G

guid8     H

guid9     I

guid10   J

then you update to

Guid      Name      

===========

guid1     AAAAA       //updated

guid2     B

guid3     C

guid4     D

guid5     EXYASYAS   //updated

guid6     FUNNY        //updated

guid7     G

guid8     H

guid9     IJKLASAS     //updated

guid10   J

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.

Thanks.

Reply
Suresh Sorde responded on 5 Feb 2015 7:05 AM

Thanks Aillen

Reply
Verified Answer
Aileen Gusni responded on 5 Feb 2015 6:52 AM

Suresh,

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.

Example:

When you export at the very first originally

Guid      Name      

===========

guid1     A

guid2     B

guid3     C

guid4     D

guid5     E

guid6     F

guid7     G

guid8     H

guid9     I

guid10   J

then you update to

Guid      Name      

===========

guid1     AAAAA       //updated

guid2     B

guid3     C

guid4     D

guid5     EXYASYAS   //updated

guid6     FUNNY        //updated

guid7     G

guid8     H

guid9     IJKLASAS     //updated

guid10   J

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.

Thanks.

Reply