What happens to CSV File after import?

[Erik Nelson]

This might seem like a weird question, but what happens to the actual .csv file when it is imported? I can find the data we've imported based on Import Set Tables information, however I'm hoping to locate the actual .csv file for comparison as a proof of the data being exported by the "sending" system. I don't see the file in deleted records, is it being held anywhere? As a side note, I can get the file from someone working in the "sending" system, however they may have changed the export already, so I'm covering my bases.

Thanks!

[EricDohr]

When you load data, it will create a record on the Data Source table [sys_data_source].  The spreadsheet will show as an attachment.

If you review the Attachments [sys_attachment] table, you will see the file with the table name sys_data_source. 

[Erik Nelson]

Hi Eric,

I'm not seeing an attachment either in the Data Source or in the attachments table with sys_data_source name. I can see the Import sets and all their related information, but I'm not seeing the .csv file attached anywhere or in the attachments table.

Thanks, Erik

[EricDohr]

Interesting.  To confirm your process are you going through is System Import Sets > Load Data and creating a new table via the file as the source of import?  The CSV is being used as the file source?  

[Erik Nelson]

It's updating an existing custom table, so it's a daily scheduled job that handles the import/transform.