Re: AIE and Currency Fields
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 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] - 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] - Entry 2087, was not > > updated due to error > > > > [Fri Jun 03 2011 12:08:35.7880] - 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"
Re: AIE and Currency Fields
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] - 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] - Entry 2087, was not > updated due to error > > [Fri Jun 03 2011 12:08:35.7880] - 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"
Re: AIE and Currency fields
Oscar, I found that the only way to convert 5.x currency data to 6/7.x is to import it to a character field and then from the char to the 6/7.x currency field. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: Oscar Herrera Date: Thu, 19 Mar 2009 09:31:51 To: Subject: AIE and Currency fields I wonder if any has seen this in AIE and found a soloution. I'm migrating custom forms with currency fields from remedy 5 environment into Compponents class (CMD 2.1) in ars 7.1 The currency fields have a structural difference from the 7.1 environment and thus my mappings are failing. See below: 7.1 Env CurrencyField 5.5 Env: CurrencyFieldV CurrencyFieldC CurrencyFieldD I haven't found the proper syntax either in a concatenate or IF statement to make the currency field come in Here's and example of what I've tried: STMT| IF CurrencyFieldV != "." THen Currencyfieldfield = "0.00" End IF Function|Concat(currencyfieldV, "") I appreciate any suggestions Thanks in advance, Oscar Herrera ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"