Issue sending CSV via ColdFusion to user reading email in Lotus Notes

Asked By 0 points N/A Posted on -
qa-featured

Hello,

I use ColdFusion to build a CSV file and then send it as an email attachment to a user.

I copy myself on the emails, and I receive the attachment as a CSV file in both Gmail and Outlook, and I can open the attachment as a CSV file in Microsoft Excel.

I am attaching the file using the CFMAILPARAM tag. I have tried sending it in two ways:

<cfmailparam file="C:/temp/myfile.csv" type="text/plain" />

This results in the user seeing a .txt file. When I receive the email, the Header reads:

Content-Type: text/plain
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename*=myfile.csv

Using:

<cfmailparam file="C:/temp/myfile.csv" type="text/csv" />

This results in the user seeing a .dat file, which they cannot open in Microsoft Excel. When I receive the email, the Header reads:

Content-Type: text/csv
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename*=myfile.csv

Any idea about what's going on here?

I seek your help.

SHARE
Answered By 10 points N/A #142112

Issue sending CSV via ColdFusion to user reading email in Lotus Notes

qa-featured

Hello Cait,

The error you are getting is usually caused by messages, TO DOs or calendar entries that have got old style layout regions. To resolve it, you will need to follow the steps below:

Note that kind of problem has been reported to Lotus Quality Engineering in SPR SRDE7XU996 and found out to be software Limitation in the Notes 8 Editor. The following are the only known workarounds that you can use to fix it:

  • You will need to revert the database design back to mail7 or DWA7
  • You will also need to edit the message that has got  the old layout regions in an older design mail db as well as get rid of the link message icon graphics.

Regards,

Carl

 

Related Questions