Results 1 to 8 of 8

Thread: Help creating csv through BI publisher

  1. #1
    New Member
    Join Date
    Dec 2013
    Location
    Sydney
    Posts
    47

    Lightbulb Help creating csv through BI publisher

    Hi All,

    We have a requirement to use Bi-Publisher to generate CSV but unfortunately this output format is not supported by BIP. We need to use BIP only as the output has to be emailed to customers based on ship to address.

    We also are looking into converting excel into csv before sending to customers but the problem is automatic formatting...

    Never created etext so not sure if that will work. The main idea is that we need to send customers a file which they can modify and send us back... if that makes sense...

    Does anybody have an ideas?

    Thanks in advance...
    Sonal
    JDE Techincal Consultant, Sydney
    Enterprise 9.10

  2. #2
    BI publisher can produce output in excel format . The best way you can verify yourself is - open P95620 , open any RD or report definition , go to its output types and you will see the types available , it can be pdf , rtf , html excel , even xml .So try creating a rtf template with table and columns as we normally do while designing xml publisher object , then choose output type as excel and see how it works .

    I dont know how bursting and data driven emailing will work but you gotta try that .

  3. #3
    The other alternative could be to check in with certain developers who can parse pdf output and then convert into csv and send . So from BI it will burst and email and then there could be a script or some other parsing to read through pdf and convert to csv . I think this is possible too

    Regarding formatting while converting excel to csv , what kind of issues are you facing ?

  4. #4
    Are we talking embedded BI/XMLP?
    EnterpriseOne 8.12 to 9.2
    AIX, Linux, Windows, IBM i
    Oracle DB, MSSQL, DB2
    WAS, WLS

  5. #5
    New Member
    Join Date
    Dec 2013
    Location
    Sydney
    Posts
    47
    I have worked with excel but requirement is for csv as the customers need that format only...
    Sonal
    JDE Techincal Consultant, Sydney
    Enterprise 9.10

  6. #6
    New Member
    Join Date
    Dec 2013
    Location
    Sydney
    Posts
    47
    Will explore alternatives... the problem converting from excel is auto formatting of data... which will be an issue.
    Sonal
    JDE Techincal Consultant, Sydney
    Enterprise 9.10

  7. #7
    New Member
    Join Date
    Dec 2013
    Location
    Sydney
    Posts
    47
    Yes... the standalone BI does produce csv but this one's embedded.
    Sonal
    JDE Techincal Consultant, Sydney
    Enterprise 9.10

  8. #8
    Member
    Join Date
    Mar 2009
    Location
    Phoenix, AZ USA
    Posts
    58
    My two cents worth: A while back, I solved a similar problem by using a UBE that directly created multiple flat files, one for each recipient (AN8). No need to use BI Publisher.
    In your main section's Initialize Section event, create a manifest flat file.
    In a level break header by recipient AN8, or in your case perhaps by ship to address, create a unique file name and open a flat file with that name.
    In the Do Section event, create a line in CSV format and write it to the flat file.
    In the recipient level break footer, close the flat file and write a line to a manifest file with at least the unique file name and the recipient's email address.
    In the End Section event, close the manifest file. You can then call a conditional section that reads and loops through your manifest file, sending the detail CSV file as an attachment to the email.
    Your process may differ if you need to encrypt the CSV payload.
    Regards,
    Kim Schmidt

    - E1 9.1.4 ,TR 9.2.2 , iSeries, DB2
    - formerly Xe, 8.0, SQL Server, Oracle

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 and, or Oracle.