Activity › Forums › Salesforce® Discussions › Account records do not match

Tagged: , , , ,

  • Salesforce® Discussions

    Account records do not match

    Posted by Bruce on August 5, 2016 at 7:06 pm

    I'm a long time user of SF and using dataloader and Excel connector but I'm very perplexed. In short, when I export all the account records to Excel using Excel Connector, without any filters, I get a count of 2600 records. However, when I run a report in Salesforce (again without any filters), I get a count of nearly twice that many. I believe these extra records that display on my SF Report are previously deleted records so the actual non-deleted count should be the 2600. It appears that using SF reports and or list views is displaying deleted accounts. Is that possible? It's the only explanation I can come up with. I need to remove these excess accounts but I would prefer to do it using the Excel connector, but (again) those records do not get exported during the export process? Very confused!

    Ravi replied 8 years, 6 months ago 3 Members · 3 Replies
  • 3 Replies

  • Bruce

    Member
    August 5, 2016 at 7:54 pm

    FYI, I no longer think the extra account records are deleted, I just don't understand why Export/Extracting all account records using Excel Connector, does not export all of them. I have no filters. Thanks.

  • Abhinav

    Member
    August 6, 2016 at 9:16 am

    Hi Bruce,

    We can filter the salesforce report such that it should not display the deleted records. Then we can get the same number of records as that with the Excel using Excel Connector.

    Thanks,

  • Ravi

    Member
    August 6, 2016 at 9:53 am

    Hi Bruce,

    I think you are exporting data By selecting Export option which exclude recycle bin's data(deleted record).
    If you want to export all data including deleted record then you should use Export All option.
    So try to export record using Export All option and let me know if you are still getting different number of
    records from report.

    Thanks,
    Ravi

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos

Report

Harassment or bullying behavior
Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Mobile App Reported Contents
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .