Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

This may not seem like a Perl problem but I need to get this part to work to help Perl automate one of my other tasks. So for those who know how to add form fields to a URL to make it work with that data I need your help!

My problem exists with an excel HTML document that has the EXPORT feature (some of you may be familiar with it). I have 200 reports to export from 200 links. I want to automate the process but I need to be able to change the URL for it to autoexport it if I typed in the URL that activated that part of the form.

The parts of the page conist of..

<SCRIPT language="VBScript"> Public Const sG = "False" Sub ExportReport ' Export the form by re-calling this page with export=yes document.frmReport.Action="/smsreporting_serv1/Report.asp?ReportID +=93&computername=pcname" document.frmReport.export.value="yes" document.frmReport.submit End Sub . . <FORM name=frmReport method="get" action="report.asp" style="margin-to +p: 0px; margin-bottom: 0px" tabindex=-1> <INPUT type="hidden" name="Export"> <!-- export the data to a file --> (this is the last of the HTML
For reference, the URL I use to launch the excel page is http://stpap24/smsreporting_serv1/Report.asp?ReportID=93&computername=pcname and this URL is what I want to try to break so I can just launch the export feature automatically. Ie: http://stpap24/smsreporting_serv1/Report.asp?ReportID=93&computername=pcname&Exp­ort=1 (tried that, didn't work). I don't know what all it's looking for.

Can someone help?

Replies are listed 'Best First'.
Re: For all you form "breakers"
by Anonymous Monk on Jul 29, 2009 at 20:36 UTC
    OOOPS! Can someone please change the last link I posted so it reads.. Thanks mods!
    http://stpap24/smsreporting_serv1/Report.asp?ReportID=93&computername= +pcname&Export=1
    That's a security thing I can't have out on the net when search engines come through.