topic RE: How to export csv file attached in the mail from workflow in ExtremeCloud IQ- Site Engine Management Center

How to export csv file attached in the mail from workflow

Lunee — Mon, 06 Dec 2021 16:29:00 GMT

I want to export csv file attached in the mail from workflow. I am able to export the textfile but I want to export csv file instead of textfile.

RE: How to export csv file attached in the mail from workflow

SamPirok — Mon, 06 Dec 2021 21:15:00 GMT

Hi Lunee, could you give us a screen shot of the email you're referring to so I know we're talking about the same thing here?

RE: How to export csv file attached in the mail from workflow

Zdeněk_Pala — Tue, 07 Dec 2021 10:32:00 GMT

if your workflow creates a CSV file then the email activity can send it as an attachment.
The CSV attachment then can be opened in your application (e.g. Excel).

Please explain in more details where is the issue. An example will help.

RE: How to export csv file attached in the mail from workflow

Lunee — Tue, 07 Dec 2021 12:13:00 GMT

Hi,
I have a workflow that runs a command in switch and I can send the output of the switch in email in textformat but I want that to be send as a CSV format. Here is the exampleworkflow.

RE: How to export csv file attached in the mail from workflow

Zdeněk_Pala — Tue, 07 Dec 2021 12:41:00 GMT

The CSV format is text format where columns are delimited by comma (https://en.wikipedia.org/wiki/Comma-separated_values).
The code you shared should generate a file. I expect there is another activity that sends the file by email.
Can you share the attachment from that email?

I still do not understand what is not working. 😞

RE: How to export csv file attached in the mail from workflow

Lunee — Tue, 07 Dec 2021 12:49:00 GMT

Yes, it generate a file. I do not have a smtp server in lab so I am using a standard python email sending program which works for text file.

RE: How to export csv file attached in the mail from workflow

Lunee — Tue, 07 Dec 2021 12:53:00 GMT

From the above program I only receive a name of the file but not the content of the file in my email.---> /tmp/.csv

RE: How to export csv file attached in the mail from workflow

Zdeněk_Pala — Tue, 07 Dec 2021 13:04:00 GMT

You do not need SMTP server in your lab. you can use Google the same way = https://extremeportal.force.com/ExtrArticleDetail?an=000083346

RE: How to export csv file attached in the mail from workflow

Lunee — Tue, 07 Dec 2021 15:04:00 GMT

Now my smtp is working . Thank you.