Hello there,
I wanted to convert html to csv file and send CSV file in email. I have used "HTML Doc from Template" node and "Convert HTML to CSV" node. My CSV file has generated at backend folders but HTML file is going in email. How Can i send a CSV file in email?
Please suggest.
Thanks
Discussion posts and replies are publicly visible
A CSV file would be a good candidate for being attached to the email. Did you try that?
Hi Stefen,
I want to pass a CSV doc only but HTMl is sending in a email.
Is there any other way I can export data to csv?
And is there any specific reason you do not want to use the solution I posted above?
https://docs.appian.com/suite/help/23.3/Export_To_CSV_Smart_Service.html
I am trying to use the method posted above. I will let you know when done.
Hi
I am looking the above mentioned code.. When I use this code it shown up as same. I am using Node "HTML from doc template"
after that I am converting it into pdf which is successfully converted.
The issue is with multiple rows not showing up. Just wanted to know how to use above code in HTML?
This is a table I am using:
<table style="border:2px solid black" width="100%" border="1" cellpadding="5" cellspacing="0"><tr> <td><label> <b> comments</b> </label> </td> <td><label> <b> createdDate </b> </label> </td> <td><label> <b> createdBy </b> </label></td> </tr> <tr> <td> ###comments### </td> <td> ###createdDate### </td> <td> ###createdBy### </td> </tr> </table>
basically I want to repeat this row. because this row has multiple entries.<tr><td> ###comments### </td><td> ###createdDate### </td><td> ###createdBy### </td></tr>
You can check the screenshot:
Hi, could you please check if both the files HTML and CSV are stored in the same folder. Try different folder for them then try to get the doc Id of it.
I already tried to explain a solution to this earlier: community.appian.com/.../120894
Yes, you already explained. But as I send you screenshot- how can I use fv!index in html?like I have pv!eventdetiails.comment_txt that using in parameter ###comments###How can I use fv!index?
This thing is fixed as I tried to fetch doc id. Thanks for your response
This is so confusing!?!?!
You can't use fv!index in HTML! You need to write an expression in Appian that turns your actual data into a HTML formatted text. This text represents the HTML table. Then call this expression to replace a single placeholder like I described.
It worked. Thanku so much. I was confused in a single placeholder thing..