Thanks for the reply. I tried a bunch of different variation and I do not fully understand it but I know that this format works
32.00 32.12 You are right it does not like the thousand-delimiter. On Tue, Jun 7, 2011 at 7:55 AM, Misi Mladoniczky <m...@rrr.se> wrote: > Hi, > > I would suspect that the thousand-delimiter will not work. > > You should probably also put a currency type at the end, for example > "345.99 USD". > > Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > > > List, > > Has anyone successfully mapped values from a .csv file into the CMBD via > > AIE > > for a currency field. Error message I am getting is > > > > > > [Fri Jun 03 2011 12:08:35.7880] - <TID: 001> <ERR > Error: Bad decimal > > value > > was supplied Attr Name: UnitPrice --- The curreny value is not a valid > > decimal value > > > > [Fri Jun 03 2011 12:08:35.7880] - <TID: 001> <ERR > Entry 2087, was not > > updated due to error > > > > [Fri Jun 03 2011 12:08:35.7880] - <TID: 001> <ERR > DataExchangeOnMatch: > > CompareAssetsForPull failed key = 2087, rc = 1 > > > > > > I am passing numbers such as > > > > 345.99 > > 4,156 > > 7,890.88 > > > > etc.... > > > > ARS 7.5 > > ITSM, Atrium Core 7.6 > > > > > > -- > > Kevin Begosh > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > -- Kevin Begosh _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"