Re: how to import into currency fields?

2009-06-10 Thread Michiel Beijen
What always worked for me, is to import with an additional zero to the end, like this: "123.95 USD 0". That's *a lot* simpler than using additional workflow. In this example, the 0 is the epoch value for the currency conversion date. If you are not using other currencies and the conversion function

Re: how to import into currency fields? - Resolved

2009-06-10 Thread Ben Chernys
e Bernales [mailto:kristine.berna...@macquarie.com] Sent: June 10, 2009 11:01 AM To: ben.cher...@softwaretoolhouse.com Subject: RE: how to import into currency fields? it worked! the approach to set non aud currencies to 0 :) thanks! kaye _ From: Ben Chernys [mailto:ben.cher...@softwaretoolhouse.

Re: how to import into currency fields?

2009-06-10 Thread Rick Cook
*Sent:* Wednesday, June 10, 2009 2:28 AM > *To:* arslist@ARSLIST.ORG > *Subject:* how to import into currency fields? > > ** > > Hi, > > We are trying to update asset records and one of the fields we need to > import value into is a currency field. We are using Remedy import

Re: how to import into currency fields?

2009-06-10 Thread Fariss, Ron
Global Services Service Desk Automation Office: 713-831-2365 Cell: 281-782-0979 From: "Action Request System discussion list(ARSList)" [mailto:arsl...@arslist.org] On Behalf Of Kaye Bernales Sent: Wednesday, June 10, 2009 2:28 AM To: arslist@ARSLIST.ORG Su

how to import into currency fields?

2009-06-10 Thread Kaye Bernales
Hi, We are trying to update asset records and one of the fields we need to import value into is a currency field. We are using Remedy import tool and have tried to import with values: 0.00, 0, 0.00 AUD to no avail...We are always getting error that the imported value is not a correct value for th