Is it possible to retrieve a CSV File that Was Used In an Import | Community
Skip to main content
A
Anonymous
April 8, 2016
Solved

Is it possible to retrieve a CSV File that Was Used In an Import

  • April 8, 2016
  • 3 replies
  • 2354 views

I would like to be able to retrieve original CSV files that were used in an upload to Marketo (in this instance in particular it was a Member List Import).

Is this list cached and can it be accessed? If this is possible, from where can these files be retrieved?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grégoire_Miche2

Hi Rob,

No, this is not possible, at least not by yourself. May be the Support can help.

What are you trying to achieve ?

-Greg

3 replies

Grégoire_Miche2
Grégoire_Miche2
New Participant
April 8, 2016

Hi Rob,

There are various ways of doing this.

One is to use the data value changed, as proposed by Jenn, but adding source and reason constraints to limit to those DVC that were due to your import.

The other is to use the API and export all the DVC. The interest of this is that it will give you the new and previous values for each, so the reverse will be quite easy. You will just have to reimport the previous values to override the new ones.

-Greg

Jenn_DiMaria2
Jenn_DiMaria2
New Participant
April 8, 2016

You might be able to rig a Smart List to get you a downloadable file resembling the original CSV. Something like:

  • Original Source Type = List Import
  • Created Date = When the original list was uploaded (if you know this)

However, this assumes the names weren't originally in your database. You could also use:

  • Was Added to List = Date added to list

Neither of these solutions may be 100% accurate, but can get you fairly close.

Grégoire_Miche2
Grégoire_Miche2Accepted solution
New Participant
April 8, 2016

Hi Rob,

No, this is not possible, at least not by yourself. May be the Support can help.

What are you trying to achieve ?

-Greg

A
Anonymous
April 8, 2016

Thanks Greg.

This need was raised because we imported a csv file with values transposed into incorrect columns (likely because of how the csv was opened in Excel, etc.). This updated our records with information from the wrong fields.

The easiest way I could think of to correct the issue would be to get access to the original csv as read in by Marketo to find the transposition error, reverse it and re-upload it.

I know that Pardot had the ability to view an import log at least of import results but couldn't find the same functionality in Marketo.

Do you have any other tricks for reversing a list import / record update (without re-uploading the corrected csv)?

Jenn_DiMaria2
Jenn_DiMaria2
New Participant
April 8, 2016

You could pull a Smart List of "Data Value Changed" using date constraints, then export the resulting list, transpose, and re-upload. You'd have to use two "Data Value Changed" filters and select ALL filters. See below:

Terms & ConditionsAccessibility statement

Loading footer...