I'm wondering if this scenario would be possible with contour...
When the form has been submitted I want this to happen:
Save the form as a CSV file and attach the file to an e-mail that is sent to a predefined e-mail address.
Currently I'm using the trial and I'm not sure how to get the CSV file created. When I change the extension from XML to something else I still get XML files...don't know if this is a limitation in the trial?
I'm thinking that it must somehow be possible to e-mail the CSV file as an attached file using the XSLT. But I can't seem to figure it out atm.
it's definitly possible in a custom workflow. As I see it you have two tasks which must be completed:
1. Create csv for record 2. Send e-mail with attached file.
As the e-mail part is covered in this forum (except attaching a file, but that's trivial) I'll only deal with the csv creation, you can either write code to do this, i.e. work through each field and append it to a string builder (see code snippet 3 in http://is.gd/7Koq8 and http://is.gd/7Koyp for inspiration). Or you can as you suggest use an xslt transformation, for samples see http://stackoverflow.com/questions/365312/xml-to-csv-using-xslt.
CSV creation with Contour...Possible?
Hi
I'm wondering if this scenario would be possible with contour...
When the form has been submitted I want this to happen:
Save the form as a CSV file and attach the file to an e-mail that is sent to a predefined e-mail address.
Currently I'm using the trial and I'm not sure how to get the CSV file created. When I change the extension from XML to something else I still get XML files...don't know if this is a limitation in the trial?
I'm thinking that it must somehow be possible to e-mail the CSV file as an attached file using the XSLT. But I can't seem to figure it out atm.
Is it at all possible to do this using contour?
Looking forward to hear from you guys.
/Jan
Hi Jan,
it's definitly possible in a custom workflow. As I see it you have two tasks which must be completed:
1. Create csv for record
2. Send e-mail with attached file.
As the e-mail part is covered in this forum (except attaching a file, but that's trivial) I'll only deal with the csv creation, you can either write code to do this, i.e. work through each field and append it to a string builder (see code snippet 3 in http://is.gd/7Koq8 and http://is.gd/7Koyp for inspiration). Or you can as you suggest use an xslt transformation, for samples see http://stackoverflow.com/questions/365312/xml-to-csv-using-xslt.
Best regards,
Harald
is working on a reply...