Import of currency values with currency code

[ashwinipingle]

Dear All,

I am trying to import projects in pm_project table using xls where I have the data for importing.

We have a custom currency field in pm_project where I am importing USD, EUR and INR currency values.

As per documentation of ServiceNow, I have set the values in xls column as below (string value with currency code and currency value separated with semicolon and the decimal notation corresponding to the currency code. So for it EUR it is 80,0 where , is the decimal and for USD or INR it is a dot notation)

EUR;80,0
USD;1.37
EUR;1,1
INR;75.51
INR;124.91

But what I find is that the EUR values are correctly displayed in the form (after the import) e.g. EUR 80,0 however the USD and INR values show up without the decimal point. So the form shows e.g. USD 137 or INR 7551. 

The system default currency is EUR.

Any help is highly appreciated. 

Best Regards,

AP

[Sohail Khilji]

Hi @ashwinipingle ,

On your source excel make sure the text is not number or decimal. it must be of string format.

[ashwinipingle]

Hello Sohail,

I have the excel column as General and there is alphanumeric in the xlsx column hence it will not be a number or decimal.

[Sohail Khilji · Accepted solution]

try with text. 

or on the transform script use .toString(); and try 

[ashwinipingle]

Hello Sohail,

I found that for all currency values, it considers system default as (,) comma due to EUR as default currency. Hence INR;12,50 works while upload. Hence I can upload the currency values as text.

Now I want to know how to set the reference currency thru the import. Because all non-EURO currencies have to be converted to EURO.

Is there a function that I can use in transform map to set the reference currency?

Best Regards,

Ashwini Pingle