ecc storage scope - export reports to csv.

Question

Hi,

I have got strange problem when I choose export to
csv in storage scope I get file where are ,= instead
; between values. I checked local settings in windows
(firefox, ie) and everything is ok, the same problem
is in linux (firefox). I would be grateful for any
advice.

I forgot to add : Version 5.2.0.4.0
Message was edited by:
krzyh

owen4 · Answer

This is actually a feature.

The seperator is , (comma), the values are defined as ="value". This way, every value will be imported as string, avoiding problems with auto-interpretation done by excel or other spreadsheet programs. For example, symvols like 0100 don't get imported incorrectly as number 100, but as the string "0100".

Hi,

I have got strange problem when I choose export to
csv in storage scope I get file where are ,= instead
; between values. I checked local settings in windows
(firefox, ie) and everything is ok, the same problem
is in linux (firefox). I would be grateful for any
advice.

I forgot to add : Version 5.2.0.4.0
Message was edited by:
krzyh

krzyh · Answer

I fought so, but I wrote an application that uses csv file in "old fashion" format and now I must do global replace in report before I can import to my application. Is there any way to change separator from , (comma) to ; (semicolon).
Thanks for replay owen.

michaelf1 · Answer

I attempted to see if this could be changed in a lab environment and so far haven't found anyway to do so.

If you want this feature added, you could always see if its possible to request it through your account team, or the other option is (as your already using) is to pre-process the output to clean it up before using it elsewhere.

Storage Resource Management (SRM Suite)

ecc storage scope - export reports to csv.

Was this post helpful?