Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    2
    Sign in to vote

    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, 
           id.linenumber, 
           id.data, 
           id.createdbyname, 
           id.createdon 
    FROM   importdata id 
    WHERE  id.createdon BETWEEN '9/22/2014' AND '9/24/2014' 

    Thursday, February 12, 2015 5:29 PM