Results 1 to 3 of 3

Thread: Help create a CSV via BI-Publisher

  1. #1

    Exclamation Help create a CSV via BI-Publisher

    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

  2. #2
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    471
    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.
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  3. #3
    Member
    Join Date
    Oct 2001
    Location
    New Zealand
    Posts
    400
    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 by jolly; 06-25-2017 at 07:35 PM. Reason: added
    Contract JD Edwards Development Consultant.
    EnterpriseOne Xe through 9.2. Windows/Unix/OS400. SQLServer/Oracle/DB2 for i.
    ER, C/C++, BI Publisher, SQL

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.