Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

need cgi FormMail to append csv

Locked

Thanks All!
I’m using a server side that supports all the fancy emailing ‘out of the box’ (nms-Formmail) which works flawlessly, for which it was designed, but…

Problem is, nms won’t/can’t ? save or store!?
I need it to APPEND to an existing .csv file, output (in an order I choose) one field of info per comma delimit, allowing for the possibility of a comma included in a field entry… (more specifically only the last field called “Comments”) and then end of line or CRLF (or whatever gets it done) so it is ready to accept the next input string or form submission posting. ?!?!?!?
Ending up with a .csv file that when opened up in a spreadsheet, every “form submission” is on it’s own line and NOT all in one cell !
I really don’t see why this should be that hard???
🙂

Can ANYONE get it to do this?
(the London Perl Mongers seem uninitiated for this, they say to use a different cgi called “tfmail” of theirs – but it doesn’t do all the fancy emailings!)

form: http://www.i-zoe.com/MyForm.html
nms cgi: http://www.i-zoe.com/MynmsFormail.html
csv: http://www.i-zoe.com/content/ccsfla2.csv

Topic

What is your solution?

In reply to need cgi FormMail to append csv

Hi Matthew,

I am in the same dilemma you posted about at techrepublic.com in November 2004. I was hoping you would share your solution with me, if you have one.

I know of a script that might work for you but doesn’t work for me because I have checkboxes on my form.

Any help would be greatly appreciated. Thanks for your time.

Have a great day.

Regards,

Mark Harrison

[Author]

Replies