473,320 Members | 1,831 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 6702
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: matt | last post by:
I am using a text file as a database, each field delimited by || I want to be able to print all lines to a page, then by selecting one (with, say, a radio button) it will load into the form at the...
4
by: Jake Lewis | last post by:
I have an HTML page that loads fine including the .js file <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Untitled Document</title> <script...
0
by: Kitchen Bin | last post by:
HELP PLEASE!! The C# Visual Studio IDE is failing to load an inherited form into the IDE from a base form when I add items to an array property of a user control on the base form. That sounds...
1
by: Greg Patrick | last post by:
My problem: I load an some assemblies (strong named) from a byte array using Assembly.Load(byte). They load fine. But one one of them is actually accessed, it's referenced assemblies can't be...
9
by: John Kirksey | last post by:
I have a page that uses an in-place editable DataGrid that supports sorting and paging. EnableViewState is turned ON. At the top of the page are several search fields that allow the user to filter...
4
by: Don Wash | last post by:
Hi All! I'm getting the following Error: No DLLs has been compiled yet and nothing in the \bin directory. So it is not the versioning problem or anything like that. And here are the...
5
by: ALthePal | last post by:
Hi, I am receiving this message when I start up VS.NET 1.0 on WinXP, File Failed to load in WEb Form designer. Please correct the following error, then load it again: Exception from...
2
by: lgbjr | last post by:
Hi All, I see that this topic was discussed back on august 23rd, but I didn't see a real answer. I have a VB.NET MDI app. A particular menu action on the MDI parent is to call an OpenFileDialog...
2
by: danishce | last post by:
I want to load a form dynamically by reading Form Name from a text file using vb.net. In visual basic 6 code works fine but when i use the same code in vb.net it gives the error. The code below...
3
by: Sunny | last post by:
Hi, Can someone tell me, How to load the Body Html from a text file that contains javascript. to Manage my files I am creating an Index Page. <html> <head> <meta http-equiv="content-type"...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.