Re: Issues with Unicode uploads

Josh_Hill13
Level 10 - Champion Alumni

Re: Issues with Unicode uploads

Interesting thread. I had an odd thing yesterday that was likely related to Excel 2011 Mac where I saved as CSV, but Marketo claimed it had an "Unclosed quotation" which I had not noticed before. I looked at the text file and it had somehow created a mess on the header. When I opened in Excel again, the first two rows were misaligned.

Then I saved as Windows CSV with no further problems.

I know there are better Mac text editors that'd help here. Hope this is fixed soon.

SanfordWhiteman
Level 10 - Community Moderator

Re: Issues with Unicode uploads

But no non-Latin-1 characters in there, yes?  Windows CSV uses Windows-1252 so you can store

     þþþ

but not

     āāā

(to use an example of crossing the character boundary from #255 to #257)

SanfordWhiteman
Level 10 - Community Moderator

Re: Issues with Unicode uploads

Gary_Verster2
Level 2

Re: Issues with Unicode uploads

Thanks, Sandford. As per Dan's reply, thanks for working on this and coming up with an interim solution.

That said, I won't be retraining my marketers on how to upload using this process just yet... explaining that they need to enable macro's and then showing them how to run the fix is probably a step too far for more than a few of them, especially if it's an interim fix. But it will definitely help me to fill the gap myself more painlessly in the meantime!

Thanks, chap!

Dan_Stevens_
Level 10 - Champion Alumni

Re: Issues with Unicode uploads

On Monday (3/27), engineering pushed a patch into production to address this.  I did hear back from my team and they confirmed that the Unicode import is now working as expected.