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"
