Is there a way in DCE with scheduling to export reports in csv rather than txt?

DCIM_Support · ‎2020-07-02

I am using DCE and set up a scheduled report to export to e-mail, but I see it only comes trough in a zip file with a txt document. Is there a way of setting this up to just send in .csv?

DCIM_Support · ‎2020-07-02

Hi Quinton,

The email files are always set up to be sent as zip files with the report being in .txt extension format. This is by design. When the report is emailed (comma, delimiter option), you can rename the file from a .txt extension to a .csv extension and you will then be able to open this report in Excel.

Hope this helps.

Regards,

B

See Answer In Context

DCIM_Support · ‎2020-07-02

Hi Quinton,

The email files are always set up to be sent as zip files with the report being in .txt extension format. This is by design. When the report is emailed (comma, delimiter option), you can rename the file from a .txt extension to a .csv extension and you will then be able to open this report in Excel.

Hope this helps.

Regards,

B

DCIM_Support · ‎2020-07-02

Hi Breda

That's exactly what i was doing but it takes a lot of time to do if you have numerous reports to rename, that's why i asked if there isn't an easier way to get it to .csv. If I had to export it to a windows folder would it also save in .txt?

DCIM_Support · ‎2020-07-02

Hi Quinton, welcome to the community! When commenting on the answer, please use "add comment" instead of giving "your answer". Thank you.

DCIM_Support · ‎2020-07-02

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.