SUbmitting Form Data as CSV when client presses submit button on Form

Your code looks very nice. there are no problems the way you've setup the validation. But unfortunately CSV just isn't a format that can be submitted directly from a PDF. I suppose your client would like CSV because it can be imported directly into an Excel file, or some other data tool? XML is of course very flexible and well understood by most software so there should be a way form them to use it.


Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Then most important JavaScript Development tool in Acrobat
[url=http://www.pdfscripting.com/public/34.cfm#JSIntro][b]The Console Window (Video tutorial)[/b][/url]
[url=http://www.acrobatusers.com/tutorials/2006/javascript_console][b]The Console Window(article)[/b][/url]

What you can do is create the CSV contents, and send it as the plain-text body of the email (use app.mailMsg instead of this.submitForm).
The recipient can then copy the text to a file, and save it with a CSV extension.

Hey Try67, that's a good one. It was actually quite common on old mainframe systems to route data and commands as email contents. You could even create an Outlook VBA add-in to grab the data and save it somewhere.

thanks, guys...this might be out of my league. I was able to persuade the client that I wasn't able to do it.

Hey Guys,

I was able to get this java to work with app.mailMsg with Adobe Acrobat Pro 9 Extended but will not execute the same script in Adobe Reader 9. Another forms forum here informs me that the java properties of app.mailMsg are not supported in Adobe Reader 9. Looks like I have to come up with another way of using this code on a button. Any ideas ? - Basic idea = User fills in form > Hits submit button > Form data is displayed in body of email for submission to Help Desk
Thanks,
GW

Here's the code:
var to = this.getField("to");

var statetagv = this.getField("st_tag");

var pov = this.getField("po_num");
var unitv = this.getField("unit_num");
var loccodev = this.getField("loc_code");
var modelv = this.getField("model_num");
var serialv = this.getField("serial_num");

var brandv = this.getField("brand_comp");

var deptv = this.getField("dept");

var bldlocationv = this.getField("located");

var softofficev = this.getField("soft_msoffice");

var softsymantecv = this.getField("soft_symantec");

var softxpvistav = this.getField("soft_xpvista");

var namev = this.getField("Name");

var phonenumv = this.getField("phone_num");

var emailv = this.getField("e_mail");

var subbyv = this.getField("sub_by");


var subject = "New PC Notification"

var emailBody = "";
emailBody += "NEW PC\r\n";
emailBody += "STATE TAG NUMBER: " + statetagv.value + "\r\n";
emailBody += "\r\n";
emailBody += "PURCHASE ORDER:";
emailBody += pov.value + "\r\n";
emailBody += "UNIT NUMBER:" + unitv.value + "\r\n";
emailBody += "LOC CODE:" + loccodev.value + "\r\n";
emailBody += "MODEL:" + modelv.value + "\r\n";
emailBody += "SERIAL NUMBER:";
emailBody += serialv.value + "\r\n";
emailBody += "BRAND:";
emailBody += brandv.value + "\r\n";
emailBody += "\r\n";
emailBody += "DEPARTMENT:";
emailBody += deptv.value + "\r\n";
emailBody += "LOCATION:" + bldlocationv.value + "\r\n";
emailBody += "\r\n";
emailBody += "SOFTWARE MS OFFICE:" + softofficev.value + "\r\n";
emailBody += "SOFTWARE SYMANTEC:" + softsymantecv.value + "\r\n";
emailBody += "SOFTWARE MS XP OR VISTA:" + softxpvistav.value + "\r\n";
emailBody += "\r\n";
emailBody += "NAME:" + namev.value + "\r\n";
emailBody += "PHONE:" + phonenumv.value + "\r\n";
emailBody += "EMAIL:" + emailv.value + "\r\n";
emailBody += "\r\n";
emailBody += "SUBMITTED BY:";
emailBody += subbyv.value + "\r\n";




app.mailMsg({

bUI: true,

cTo: to.value,

cSubject: subject,

cMsg: emailBody

} );

According to the Acrobat JavaScript documentation (which you definitely should get), the app.mailMsg() method is not available for Reader (not even with ARES Extended Rights...) ... complaints to be directed at Adobe...

HTH