469,646 Members | 1,596 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,646 developers. It's quick & easy.

Load web form from text file.

Does anyone know of a program that will read a text file and fill in a web
form with the contents of that file? We need to get about 3000 records (5
fields to each record) into a database owned by another company and the only
way it can be done (according to them) is to enter them one at a time into a
web form. We can get the records into a comma or tab separated text file
and would like to just read the file and auto insert the fields into the
form, adding an enter or another command at the end to write the data and
reload a blank form. Thanks for any help

Dave B
Jul 17 '05 #1
7 6456
"Dave B" <da****@earthlink.net> wrote
Does anyone know of a program that will read a text file and fill in a web
form with the contents of that file? We need to get about 3000 records (5
fields to each record) into a database owned by another company and the only
way it can be done (according to them) is to enter them one at a time into a
web form. We can get the records into a comma or tab separated text file
and would like to just read the file and auto insert the fields into the
form, adding an enter or another command at the end to write the data and
reload a blank form. Thanks for any help
This was already answered:

http://groups.google.com/groups?hl=e...newsgroups.com

To which you replied:
That works for a single field but we are needing to fill in 5 fields i.e.
name, address, city, state, zip. Can this be accomplished? I can get the
file in comma separated.


Take a look at the above link. The fields HL, ID, SAFE, SELM are all
provided in the one link. It is possible to supply more than one field.
The above link is an example of the needed format.

LFS


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Jul 17 '05 #2
That is true but we are not doing a search. The form comes up you fill it
in, click submit, it writes to a database and redirects you to a page where
you can click to enter another, return to a previous paged or logout. It
does not show the values being passed to the database.

"Larry Serflaten" <Ab***@SpamBusters.com> wrote in message
news:40********@corp.newsgroups.com...
"Dave B" <da****@earthlink.net> wrote
Does anyone know of a program that will read a text file and fill in a web form with the contents of that file? We need to get about 3000 records (5 fields to each record) into a database owned by another company and the only way it can be done (according to them) is to enter them one at a time into a web form. We can get the records into a comma or tab separated text file and would like to just read the file and auto insert the fields into the
form, adding an enter or another command at the end to write the data and reload a blank form. Thanks for any help
This was already answered:

http://groups.google.com/groups?hl=e...newsgroups.com
To which you replied:
That works for a single field but we are needing to fill in 5 fields i.e. name, address, city, state, zip. Can this be accomplished? I can get the file in comma separated.


Take a look at the above link. The fields HL, ID, SAFE, SELM are all
provided in the one link. It is possible to supply more than one field.
The above link is an example of the needed format.

LFS


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Jul 17 '05 #3
> That is true but we are not doing a search. The form comes up you fill it
in, click submit, it writes to a database and redirects you to a page where
you can click to enter another, return to a previous paged or logout. It
does not show the values being passed to the database.

Sounds as if either the page is in a frameset (a basic way to hide the page
address) or posted back to the server.
Ideas based on this:
- Use a WebBrowser control to access the page and look at WebBrowser1.document
properties.
- Create a local page using JavaScript to enter data in a mock-up of the page
from the address line.
- Use DDE somehow?
- Look at the web page's address by sending data, right-clicking the actual page
and select Properties to reveal a URL. This checks against frameset use.

Any help there? I hope there might be!

--
QuickHare
QuickHare @ Hotmail. com
Jul 17 '05 #4
"Dave B" <da****@earthlink.net> wrote
That is true but we are not doing a search. The form comes up you fill it
in, click submit, it writes to a database and redirects you to a page where
you can click to enter another, return to a previous paged or logout. It
does not show the values being passed to the database.


You indicated that one field did work:
That works for a single field but we are needing to fill in 5 fields


Does it actually work, or were you just saying that?

If the URL you are directed to (after pressing Submit) accepts the format,
then all 5 fields should work as well as the one did.

It would help to look at the page you press Submit on, is it available on
the net? The source of that page would clue you in on the names of the fields,
which need not be what you see listed on the page nor do they need to be
listed in the URL. It is not just search pages that use that format, it is
standard URL notation.

For another example, go to: http://babel.altavista.com/tr
Type in: This was translated for Dave B
Select: English to German

Then press the Translate button. Take note you are redirected to the
new page with the translated text. The point I am making is that you do
not need to fill out the page and then press the Translate button. That
is the type of things you say you need to do, you need to fill out a form
and press a button. What I am saying that you can simply submit a
formatted URL and to the server, it will look like you did fill out the form.
As an example, this link does just that:

http://babelfish.altavista.com/babel...ave+B&lp=en_de

When you pressed the Translate button, you do not see a URL in your
Address bar like this, you only see: http://babelfish.altavista.com/babelfish/tr
But the result is the same, is it not?

Other methods involve significantly more programming than simply building
and submitting URLs from data in your file. If you can go this route, then that
will be the easiest. That is why it is the first method I have suggested. It
may be the server does not respond in normal fashion (as it should), in
which case you may have to programmatically download the form, fill it out
and resubmit it. But as I said that is going to be more work than the method
above....

LFS


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Jul 17 '05 #5
Sorry, what I meant to say was that the sample worked for the single field
in the search page but you can see the actual URL that is passed to the
results page. The form we are trying to fill out has 5 fields and I don't
know how to open a url sending 5 different fields to the form. We need to
read in 5 fields, from a text file, call the web page and pass the
information that goes into each field into the web form, submit the form,
close the browser and then start the process all over again with the enxt
record. Thanks for your help

Dave B

"Larry Serflaten" <Ab***@SpamBusters.com > wrote in message
news:40********@corp.newsgroups.com...
"Dave B" <da****@earthlink.net> wrote
That is true but we are not doing a search. The form comes up you fill it
in, click submit, it writes to a database and redirects you to a page where you can click to enter another, return to a previous paged or logout. It does not show the values being passed to the database.
You indicated that one field did work:
That works for a single field but we are needing to fill in 5 fields


Does it actually work, or were you just saying that?

If the URL you are directed to (after pressing Submit) accepts the format,
then all 5 fields should work as well as the one did.

It would help to look at the page you press Submit on, is it available on
the net? The source of that page would clue you in on the names of the

fields, which need not be what you see listed on the page nor do they need to be
listed in the URL. It is not just search pages that use that format, it is standard URL notation.

For another example, go to: http://babel.altavista.com/tr
Type in: This was translated for Dave B
Select: English to German

Then press the Translate button. Take note you are redirected to the
new page with the translated text. The point I am making is that you do
not need to fill out the page and then press the Translate button. That
is the type of things you say you need to do, you need to fill out a form
and press a button. What I am saying that you can simply submit a
formatted URL and to the server, it will look like you did fill out the form. As an example, this link does just that:

http://babelfish.altavista.com/babel...ave+B&lp=en_de
When you pressed the Translate button, you do not see a URL in your
Address bar like this, you only see: http://babelfish.altavista.com/babelfish/tr But the result is the same, is it not?

Other methods involve significantly more programming than simply building
and submitting URLs from data in your file. If you can go this route, then that will be the easiest. That is why it is the first method I have suggested. It may be the server does not respond in normal fashion (as it should), in
which case you may have to programmatically download the form, fill it out
and resubmit it. But as I said that is going to be more work than the method above....

LFS


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Jul 17 '05 #6
"Dave B" <da****@earthlink.net> wrote
Sorry, what I meant to say was that the sample worked for the single field
in the search page but you can see the actual URL that is passed to the
results page. The form we are trying to fill out has 5 fields and I don't
know how to open a url sending 5 different fields to the form. We need to
read in 5 fields, from a text file, call the web page and pass the
information that goes into each field into the web form, submit the form,
close the browser and then start the process all over again with the enxt
record. Thanks for your help

Dave B

Is that page available on the net? What is the address?

LFS


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Jul 17 '05 #7
I'll have to get the page for you. It is in conjunction with a job I am
starting the middle of this month. I will see if I can get it.

Thanks

Dave B

"Larry Serflaten" <Ab***@SpamBusters.com> wrote in message
news:40********@corp.newsgroups.com...
"Dave B" <da****@earthlink.net> wrote
Sorry, what I meant to say was that the sample worked for the single field in the search page but you can see the actual URL that is passed to the
results page. The form we are trying to fill out has 5 fields and I don't know how to open a url sending 5 different fields to the form. We need to read in 5 fields, from a text file, call the web page and pass the
information that goes into each field into the web form, submit the form, close the browser and then start the process all over again with the enxt record. Thanks for your help

Dave B

Is that page available on the net? What is the address?

LFS


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Jul 17 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by John Kirksey | last post: by
4 posts views Thread by Don Wash | last post: by
5 posts views Thread by ALthePal | last post: by
2 posts views Thread by lgbjr | last post: by
3 posts views Thread by Sunny | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.