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:arsl...@arslist.org] On Behalf Of Kaye Bernales 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 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: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
