Retrieve CSV file uploaded to CRM standard import

In some rare cases you wish you could retrieve the file uploaded to CRM. Unfortunately, there is no way that CRM is going to return you this file...

But luckily, in OnPremise and some Partner Hosted environments, it is possible to access the underlying database. This is where you can find the data for each of the rows which allow you to recreate the CSV (or XML) file.

The following query will retrieve all the relevant information:

SELECT ifb.ImportFileId,
    Source,
    HeaderRow,
    Data,
    LineNumber
   
  FROM ImportDataBase idb
  LEFT OUTER JOIN ImportFileBase ifb ON idb.ImportFileId = ifb.ImportFileId
  WHERE ifb.ImportFileId = 'DEAC184E-D7CA-E311-B83A-00155D083043'
  ORDER BY Source, LineNumber


Of course you'll need to change the importfileid GUID or change this to select based on the source (the name of the imported file). Then Copy the header row, followed by each of the data rows and your source file is recreated.

Good luck!

1 comment:

Kumar said...

Nice article... thank you for sharing
CRM Software Provider in India with low cost.