• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • 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 creating csv through BI publisher

sonal_m

Member
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...
 
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 .
 
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 ?
 

sonal_m

Member
Will explore alternatives... the problem converting from excel is auto formatting of data... which will be an issue.
 
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.
 
Top