• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Help create a CSV via BI-Publisher

Michael_P

Member
Hi there,
i've been asked to use Bi-Publisher to generate CSV. I've tried to create the RD and the Template for eText but i haven't menaged to get a CSV file generated.
Does anybody have an idea?

Thanks for all!

Michael
 

nkuebelbeck

VIP Member
You don't need BI Publisher to make a CSV. regular UBE's can do this. You can make XLS files with BI Publisher though.

good luck.
 

jolly

Reputable Poster
True but BI publisher has some advantages over the original CSV option - most useful is configuring automatic delivery either to e-mail or a shared folder. Also, you can setup RD by version without having to do a spec override on your UBE to make it go CSV automatically. With legacy CSV output you have to carefully align all your columns on a 52pt horizontal grid layout whereas BIP doesn't care about or use your RDA layout at all.

We've used eText for CSV - I don't have the how-to at hand but I've certainly found good pointers with google. Your template is basically a list of columns, the column delimiters and the line delimiters, all in an RTF template.

The downside is that building the eText template is a bit of work if there are many columns.

Edit: There is a Oracle KG article with sample template - see Doc ID 836643.1
 
Last edited:
Top