Meta-Update deals with all parts of a currency field both on updating and on extraction.
Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: September-02-11 17:01 To: [email protected] Subject: Re: How to Extract Currency Type and Value in an Csv - Urgent Hi, My currency-field-experience tells me that the functionality is not widely used. Much of the results are unexpected or obscure. I had to create a general purpose service-call that can add, subtract, multiply currency-fields and get expected results. It was impossible to make heads or tails of it otherwise. Each currency field stores a value, currency-type and date. In addition to this it stores a conversion for each functional currency defined. All is stored in a single string in the database. To import the complete thing, you will need to the ARX file format. 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. > Bhupesh, > > Despite the fact that Remedy stores Currency fields as two fields in > the DB, it is still considered a 'single' field that contains both > numbers and the currency, so it makes sense that it would export to a > single column when doing a csv export, and I assume also expect it as > such on an import as well, so I'm not entirely sure where the problem > lies, but once in CSV you should be able to use Excel's 'Text to > Columns' feature to parse the one field into two columns if you are > needing it to be separate. > > > > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Bhupesh Gupta > Sent: Friday, September 02, 2011 2:11 AM > To: [email protected] > Subject: How to Extract Currency Type and Value in an Csv - Urgent > > > > ** > > Can some one please help how to pull currency fields in remedy by > using standard reporting procedures? > > > > Tools --> Reporting > > > > Select fields and Report to .csv. > > > > CSV does not extract currency.type and currency.value as separate columns. > > > > > > Can some please help here? It is urgent. > > -- > Regards, > Bhupesh Gupta > > _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" > _______________________________________________________________________________ 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"
