What is an acceptable import value into a custom type of Currency?

Anonymous
Not applicable

What is an acceptable import value into a custom type of Currency?

I have a column in my spreadsheet that is formatted as the Currency Format in Marketo is setup.  (e.g. "$5.55", "$10.00", $125.01", etc)

The Import Preview shows the sample value as importing correctly, no problem.  When I process the import, all values are set to 0.  What gives?

When I change the spreadsheet value to "Double" formatting, the numbers import, but there is no formatting in Marketo.  (e.g. "5.55" imports directly and shows up in Marketo as "5.55", without any formatting)  I'll probably leave it as this Double Value for now, so I at least have the data there and can setup smart lists that work properly, but I'm puzzled as to why the data won't come through...

Any thoughts?  Is this a bug?

Thanks!
John
Tags (1)
1 REPLY 1
Edward_Masson
Level 10

Re: What is an acceptable import value into a custom type of Currency?

are you loading with the dollar sign?
Also, what type is the field your loading too? That field might not be compatible.