Static list import failing second step | Community
Skip to main content
A
Anonymous
October 13, 2017
Question

Static list import failing second step

  • October 13, 2017
  • 3 replies
  • 2583 views

The text below is directly borrowed from this post.  I see it hasn't been resolved.

Hi, the list import wizard gets stuck in the second step. I’ve tried a couple times and I get the “spinning wheel of death” (it never loads). Anybody facing the same problem and any solution to this?

Specific details:

  • Other files are uploading properly into the exact same campaign, it just so happens that the specific .csv I'm uploading continues to fail: this makes me believe there is a problem in the file, not Marketo

Things I have tried and have failed to generate results

  • Formatting any and all columns into text in the file
  • Eliminating redundant columns, spaces, and rows
  • Finding and eliminating additional spaces in any of my cells
  • Creating a brand new csv with a different file name and uploading

Here is a solution that works, but is unacceptable for my needs

  • Deleting random rows of my file eventually removed whatever offending cell locked my upload down.

Thanks in advance

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Josh_Hill13
Josh_Hill13
Level 10
October 16, 2017

Things like this have happened to me as well, but I've almost never received good guidance or fixes from Marketo Support.

BUT

What does seem to be a common thread are non Western special characters that are in the cell OR already in the database that seem to cause a problem on import. One way to look is to pull down the list with use Email Address so you can examine the fields in Marketo without having the import break.

UTF8 is your friend.

Gerard_Donnell4
Gerard_Donnell4
Level 9
October 16, 2017

Chris Lu​,

You mention creating a brand new .csv with a different file name.  Does this mean you saved the current version with a new name or have you copied the contents and pasted it in a new blank file and saved it again? The later could be worth a try.

Also, if it was urgent, you could try halving the data and uploading each half separately.  Whichever half doesn't work you know it has the bad data.  You could do this a few more times to narrow it down.  This isn't at all a proper solution and if your list is huge it would take a long time.

Josh_Hill13
Josh_Hill13
Level 10
October 16, 2017

also, if you open CSV in notepad or text editor, you may spot random characters better.

A
Anonymous
October 18, 2017

I'm going to go ahead and bump this in hopes there are moderators or folks in Marketo who've seen this issue before.

Josh_Hill13
Josh_Hill13
Level 10
October 18, 2017

When I can't figure this out, I send a support ticket. Eventually some engineer figures out the problem.

Terms & ConditionsAccessibility statement

Loading footer...