Kay, I noticed the same problem in 6.3. The workaround (I won't call it a fix) was this:
1) Create a character field in the form into which you are importing the data, or identify an existing one that isn't being used. 2) Create a Filter that fires on Merge that moves the data from the character field to the currency field. 3) Map your import to push the currency data to the character field. 4) When you are done, you can delete the character field (if you created one) and the Filter. Rick On Wed, Jun 10, 2009 at 8:39 AM, Fariss, Ron <[email protected]>wrote: > ** Kaye, > > You don't say what format your load file resides in. Also, if you are > trying to send data with "$" characters, I believe you will have a problem. > You should import numeric fields with 2 decimal points (cents) - which has > worked for me in the past. > > *Ron Fariss* > *AIG Global Services* > *Service Desk Automation* > *Office: 713-831-2365* > *Cell: 281-782-0979* > > > ------------------------------ > *From:* "Action Request System discussion list(ARSList)" [mailto: > [email protected]] *On Behalf Of *Kaye Bernales > *Sent:* Wednesday, June 10, 2009 2:28 AM > *To:* [email protected] > *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 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 the > field.. > > We are using Remedy 6.3. Any ideas on how we could import values? > > Thanks! > > Kaye > > > NOTICE > > The information contained in this email is confidential. If you are not the > intended recipient, you must not disclose or use the information in this > email in any way. If you received it in error, please tell us immediately by > return email and delete the document. We do not guarantee the integrity of > any e-mails or attached files and are not responsible for any changes made > to them by any other person. > > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
