Toggle Side Panel
Close search

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 10 years, 2 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.

  • [adinserter block='9']

  • 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