CSV file is still encoded when Filter=CSV

[redheadkelly]

I have set FormMail up to create a CSV file of the form data & send it as an attachment to the email. When I receive the attachment the data is encrypted.

I accomplished this with
<input type="hidden" name="filter" value="csv" />
<input type="hidden" name="filter_options" value="Attach=data.csv" />
<input type="hidden" name="filter_fields" value="ProformQty,Name,Telephone" />

In my formmail.php,
$FILTER_ATTRIBS = array("encode"=>"Strips,MIME=application/vnd.fmencoded,Encrypts",
"httpencode"=>"Strips,MIME=application/vnd.fmencoded,Encrypts",
"sslencode"=>"Strips,MIME=application/vnd.fmencoded,Encrypts",
"csv"=>"Strips,MIME=text/csv",);

I'm assuming that since "csv"=>"Strips,MIME=text/csv" does not have an Encrypts at the end of it, it is not supposed to encrypt the data. Is this assumption incorrect? I do not want the data encrypted in my CSV file.

Thanks.

[russellr]

Hi,

Sorry for the slight delay in replying.

FILTER_ATTRIBS tells FormMail what each filter does.

It's stating what happens rather than telling FormMail what to do.

The values are very technical to FormMail and are not documented for that reason. We're pretty much the only people who create filters.

The "csv" filter does no encryption at all. And, yes, FILTER_ATTRIBS is indicating that because it doesn't have the Encrypt value shown for "csv".

I hope that helps.

[redheadkelly]

No worries. Happy to have a reply at all.

Still a question, though.

If my html looks like this...
<input type="hidden" name="filter" value="csv" />
<input type="hidden" name="filter_options" value="Attach=data.csv" />
<input type="hidden" name="filter_fields" value="ProformQty,Name,Telephone" />

Then my csv file should NOT look like this...
Content-Type: text/csv; name="data.csv"; charset=ISO-8859-1
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="data.csv"

IjEwIiwiSm9lIFNtaXRoIiwiNzA3LTQyMi05MjIxIgo=

Right?

My data is encrypted & it should not be, right? Or, at least I don't want it to be.

What am I doing wrong?

Thanks again.

[russellr]

Hi,

What you're seeing is the internal structure of the email that provides the file attachment.

It's not encryption, but it is encoded for transport via the internet. That encoding is performed as part of structuring the email and every email program does it.

If you're seeing that instead of an attachment, then it's probably because your server's email software is not compliant with the internet standards (or, maybe it's your email client).

FormMail has two configs for working around faulty email software:

• HEAD_CRLF
• BODY_LF

Check the doco for these and try the different settings to see if you can get the attachment to work.

If you're still stuck, please subscribe for support and I'll sort it out for you.

[redheadkelly]

Perfect.

Thank you!!!!

[redheadkelly]

Yay!!! That did it. Thanks again!

[russellr]

Excellent!