What is an acceptable import value into a custom type of Currency? | Community
Skip to main content
January 26, 2014
Question

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

  • January 26, 2014
  • 1 reply
  • 989 views
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
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Edward_Masson
Level 10
February 15, 2014
are you loading with the dollar sign?
Also, what type is the field your loading too? That field might not be compatible.