• State Suggested Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 93 subscribers
  • Views 6296 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

ReportComponent Export options

Rich Linley
over 6 years ago

I need to set the "Bands Filter" to "All bands" in a ReportComponent Export step for a CSV file.
I see there is a CustomText parameter for additional parameters. What is the format for that parameter so I can get all bands in that exported report?

  • 0 over 6 years ago

    Hi Rich,

    currently only the following CSV parameters can be used:

    • CsvEncoding
    • CsvSeparator
    • CsvSkipColumnHeaders

    If you would explain your use-case and your version of OneIM we might find a different solution for you.

  • 0 over 6 years ago

    Hi Markus,

    I need to create a CSV that looks like this:

    Type=Upload Custom Fields Update,,,
    Transaction=False,,,
    Language=English (United States),,,
    Module=Worker,,,
    Comments=,,,
    ,,,
    Object ID,[c] Network ID,[c] Email Address,[c] Has Resource Worked for here Previously?
    W00012003,rnderipo,rnderipo@xxxxx.com,No

    Six bands of information for the target system followed by one column header row and then data.

    I wrote a report that does this and in Subscribable Reports in Manager I can preview the report and save it with the bands filter set to "All bands".

    Which gives me the report I require.

    It would be nice to use a ReportComponent Export step.

    If CsvSkipColumnHeaders is set to "false" I just get the data if "true" I get "Text8,Text12,Text13,Text11" (no kidding).

    Rich

     

  • 0 over 6 years ago

    In regards to the case where you set SkipColumnHeaders to true you should take a look at the post https://www.quest.com/community/products/one-identity/f/identity-manager/20421/export-report-as-a-csv that describes that behavior and the solution.

    As written before you cannot set the parameter to use AllBands to solve you problem but how about this workaround.

    The information you are getting from the other data bands could be moved to the HeaderBand of the data to be exported as they are static, meaning you only get one data point for each of the items (Type, Transaction, ...).

    So you HeaderBand would contain all the items you need and you could use SkipColumnHeaders=False.

    HtH

    Markus