Can I access an import source file in CRM? RRS feed

  • Question

  • We've had a user export and re-import some data a few weeks back that's caused a bit of a problem on our CRM 2013 system which has only just come to light (audit histories now refuse to load). I'd like to see the source file that was imported so that I can try and understand what's caused this issue.

    The user no longer has the XML file and I was wondering if there was any way of accessing this file in either CRM or in the database. Any help would be appreciated.

    Thursday, February 12, 2015 12:32 PM

All replies

  • I haven't found a way to get the original file, but you can view spreadsheets imported in Settings -> Data Management -> Imports (change view to All Imports).  From there, you see the individual records that were Created/Updated.

    If you have access to the database (on-prem only), you can query that data via SQL:

    SELECT id.importfileidname, 
    FROM   importdata id 
    WHERE  id.createdon BETWEEN '9/22/2014' AND '9/24/2014' 

    Thursday, February 12, 2015 5:29 PM