473,703 Members | 2,333 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Automated Form submission

World,
I work at a university where the professors have a system to input
grades for assignments and calculate final grades, which is output to
an excel file. they are then required to get on a different system and
click radio buttons in a form to input final grades. i would like to
automate this by doing some sort of automated form submission that
grabs the information from the excel sheet and selects the correct
radio button and then submits the form. does anyone have any idea on
how to get me started on this? is javascript even a possible solution?
would other languages do it better?

Brett

May 30 '06 #1
6 3052
br*****@gmail.c om wrote:
World,
I work at a university where the professors have a system to input
grades for assignments and calculate final grades, which is output to
an excel file. they are then required to get on a different system and
click radio buttons in a form to input final grades. i would like to
automate this by doing some sort of automated form submission that
grabs the information from the excel sheet and selects the correct
radio button and then submits the form. does anyone have any idea on
how to get me started on this? is javascript even a possible solution?
would other languages do it better?

Brett


Brett, you have not been clear about what resides where: is the system
to input grades for assignments a local program producing a local
output (the excel file), or is the excel file remote. If not, how is
the remote excel file obtained. What is the "different system" - does
it mean web page (I'm guessing yes since you mention radio buttons and
submitting a form), a local program, an excel program or what? - and
where do the web pages come in? And is the operating system windows,
linux, or something else?

So, here is my "shoot from the hip" response. Yes, I assume your task
can be automated, but I would go with (client side) PHP or VBScript or
something that supports automation (I assume a windows based system
since you mention Excel). Specifically, using either VBScript (which
has more documentation on this type of thing) or PHP, you can automate
excel to open and extract the information into your VBScript (or PHP)
program. Then you can bring up an instance of IE, have IE alter the
form, and then submit it.

I suggest researching the microsoft.publi c.scripting.vbs cript usenet
group in pursuing your goal.

Good luck,
Csaba Gabor from Vienna

May 30 '06 #2

In article <11************ *********@j55g2 000cwa.googlegr oups.com>,
br*****@gmail.c om writes:
I work at a university where the professors have a system to input
grades for assignments and calculate final grades, which is output to
an excel file. they are then required to get on a different system
What kind of "system"?
and click radio buttons in a form to input final grades.
What kind of form? An HTML form in a web page? Do you maintain
this form? Is the form protected by any security features?
i would like to automate this by doing some sort of automated
form submission that grabs the information from the excel sheet
and selects the correct radio button and then submits the form.
Do you want this automated form filler to run a web server or be
a downloadable script or executable of some sort or what?
does anyone have any idea on how to get me started on this?
is javascript even a possible solution?


There are numerous possibilities depending on the answers above.

For example, you might write a script (in whatever language you
prefer) that runs on the client and uses the COM interface to
Internet Explorer to fill out a form on a web page. You might
write a server-side application that uploads the excel sheet and
sends direct HTTP POSTs to a web page. Perhaps you might use
Javascript with XMLHTTPRequest, but since I've never tried that,
I don't know for sure.

--

Warren S. Sarle SAS Institute Inc. The opinions expressed here
sa****@unx.sas. com SAS Campus Drive are mine and not necessarily
(919) 677-8000 Cary, NC 27513, USA those of SAS Institute.
May 30 '06 #3
to clarify, the system that generates the excel file is on one server
that is out of my control. it is a web based system where the
professors can export their grades to the excel file. assume you can't
do anything to that system.
secondly, the system to input grades is on a separate web server, run
by a different group, who also refuses to add the functionality of
adding grades via excel file. assume you can't change anything there.
it is a web form with radio buttons, etc.
i need a client or script that pulls the data from the excel file and
fills out the web form intelligently.
having said that, would javascript be a viable solution? i think a
client side language is going to work better here. also, i need
something that will work with the forms fairly well and easily.
having said that, any more advice??

Brett Evanson

Warren Sarle wrote:
In article <11************ *********@j55g2 000cwa.googlegr oups.com>,
br*****@gmail.c om writes:
I work at a university where the professors have a system to input
grades for assignments and calculate final grades, which is output to
an excel file. they are then required to get on a different system


What kind of "system"?
and click radio buttons in a form to input final grades.


What kind of form? An HTML form in a web page? Do you maintain
this form? Is the form protected by any security features?
i would like to automate this by doing some sort of automated
form submission that grabs the information from the excel sheet
and selects the correct radio button and then submits the form.


Do you want this automated form filler to run a web server or be
a downloadable script or executable of some sort or what?
does anyone have any idea on how to get me started on this?
is javascript even a possible solution?


There are numerous possibilities depending on the answers above.

For example, you might write a script (in whatever language you
prefer) that runs on the client and uses the COM interface to
Internet Explorer to fill out a form on a web page. You might
write a server-side application that uploads the excel sheet and
sends direct HTTP POSTs to a web page. Perhaps you might use
Javascript with XMLHTTPRequest, but since I've never tried that,
I don't know for sure.

--

Warren S. Sarle SAS Institute Inc. The opinions expressed here
sa****@unx.sas. com SAS Campus Drive are mine and not necessarily
(919) 677-8000 Cary, NC 27513, USA those of SAS Institute.


Jun 5 '06 #4
br*****@gmail.c om wrote:
I work at a university where the professors have a system to input
grades for assignments and calculate final grades, which is output to
an excel file. they are then required to get on a different system and
click radio buttons in a form to input final grades. i would like to
automate this by doing some sort of automated form submission that
grabs the information from the excel sheet and selects the correct
radio button and then submits the form. does anyone have any idea on
how to get me started on this? is javascript even a possible solution?
would other languages do it better?


Perl could do all this for you:
- read the Excel file
- tie Excel's fields to variables
- fire off http request using GET or POST with the variables as values
of the form names

Hope this helps,

--
Bart

Jun 5 '06 #5
Any suggestions as to some classes or functions that would be extremely
useful? i haven't coded in perl much.
Bart Van der Donck wrote:
br*****@gmail.c om wrote:
I work at a university where the professors have a system to input
grades for assignments and calculate final grades, which is output to
an excel file. they are then required to get on a different system and
click radio buttons in a form to input final grades. i would like to
automate this by doing some sort of automated form submission that
grabs the information from the excel sheet and selects the correct
radio button and then submits the form. does anyone have any idea on
how to get me started on this? is javascript even a possible solution?
would other languages do it better?


Perl could do all this for you:
- read the Excel file
- tie Excel's fields to variables
- fire off http request using GET or POST with the variables as values
of the form names

Hope this helps,

--
Bart


Jun 5 '06 #6
brettev wrote:
Any suggestions as to some classes or functions that would be extremely
useful? i haven't coded in perl much.


Then you will probably have a hard time.

The Excel part:
http://search.cpan.org/dist/Spreadsh.../ParseExcel.pm

The HTTP part:
http://cpan.uwinnipeg.ca/htdocs/libw...UserAgent.html

This has nothing to do with javascript though, please move to
comp.lang.perl. misc for Perl related discussions.

--
Bart

Jun 5 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
2015
by: Tom | last post by:
I have created the following code for a product select/payment form (don't know if there is a better way) and I have been trying to make the following changes (unsuccessfully so far): 1) Eliminate the submit button and submit the form with onchange. 2) Open the action php page in a new window. I am using this code for different payment options (i.e., cc processing and paypal). As such, there are multiple forms on the page. The...
2
7042
by: Andy Goldstein | last post by:
I have a table where all the TRs have an onClick handler registered. One (and only one) of the rows has 2 text input boxes, where each textbox has an onChange handler registered. Both the onClick and onChange handlers do some minor manipulation of form data (although they work on different form elements). If the onChange event fires, I need the form to be submitted. If the onClick event fires for a TR, I also need the form to be...
8
4790
by: yawnmoth | last post by:
Say I have the following HTML: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title></title> </head> <body> <form action="">
6
11895
by: Oleg Konovalov | last post by:
Hi, I have a Java/JavaScript GUI application where I perform a lot of long DB operations , which takes 5-60 secs to perform. Sometimes user double-clicks the button or just gets impatient and clicks again, which created duplicate forcm submission and hence duplicate records. So I am trying to disable the button as soon as it is clicked, and as soon as it's done,
9
3893
by: Steve Poe | last post by:
I work for an animal hospital trying to use PHP to store an animal's dental x-rays to a file server. I can browse for the xray on the local desktop computer then click "Upload Image". This works fine. The doctors want fewer steps to follow. So, it was asked if I can configure the browser to load/submit the image 'xray.tif' each time they click "Upload Image" instead of the doctor/animal technician having to look for for dental x-ray...
1
2505
by: Homer | last post by:
Hi, I just got a requirement from my HR department to automate their form submission process and integrate it into the Intranet project that I had just completed Phase 1 of. Because of the short time frame that I've been given, a week to be exact, I do not have the luxury to explore it on my own so here are the requirements: 1. Automate the personnel forms that employees use for changing their information, which is currently in pdf...
1
2254
by: rn5arn5a | last post by:
Nowadays, most websites make use of CAPTCHA to prevent automated Form submission. Can someone please give me examples of how automated Form submission can be achieved? It's not that I intend to do some nefarious activities; rather I don't understand how can automated Form submission be done other than the website developer coding it (for e.g. using JavaScript to automatically post a Form, say, after 2 minutes). Thanks,
8
4363
Megalog
by: Megalog | last post by:
Hey guys.. my turn to ask a question: I'm having a weird issue with a form I've reworked. This form has a combo box, which when used is changing the recordsource of a subform. This subform has no Master/Child relationship set to the main form. Specifically the problem seems to be that everytime the recordsource of the subform is changed, the subform object itself tries to set a default Master/Child value (both fields fill with the "ID"...
0
1836
Thekid
by: Thekid | last post by:
I'm trying to auto send a form submission to a website but it isn't working. I've done this before and it worked but for some reason, using the same basic code, it doesn't seem to submit it. I'm using urllib & urllib2 to open the page and re to parse the info. On the page is a text entry field and a 'submit' button. I've compared the source code of both pages and they appear the same as far as the submission goes. Anything else I can try? I...
0
9121
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9017
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8962
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7867
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4432
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4687
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3123
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2450
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2069
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.