webpage input from excel

Started by MW4, March 13, 2019, 12:38:13 PM

Previous topic - Next topic

MW4

I'm trying to set up a script that will take data from an excel sheet in columns and insert it into a form on a web page.

I have inspected the web page field and it shows this:
<input id="regForm:dateSold" name="regForm:dateSold" type="text" value="03/13/2019" maxlength="11" size="11" class="date">
(it is defaulting to today's date)
<input id="regForm:vin" name="regForm:vin" type="text" value="" class="vin" title="Vehicle Identification Number">

I want to set the Value= to the date and VIN from columns in an excel sheet.

Can anyone point me in the right direction to get started?


td

If you have no experience working with Webpages in WinBatch, I suppose the best place to start would be the tutorial in the Tech Database:

http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/nftechsupt.web+Tutorials+Working~With~Web~Pages.txt

There is also this:

http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/nftechsupt.web+WIL~Extenders/WinInet+HTTP~and~WinInet~-~An~Opus.txt

and this:

http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/nftechsupt.web+WinBatch/OLE~COM~ADO~CDO~ADSI~LDAP/OLE~with~MSIE+See~What~Buttons~Pushed~in~MSIE.txt

There are many other examples in the Tech Database and on this forum.  Of course, there are always things that will trip up your best-laid plans and require some form of a workaround.  But that is to be expected when working with Webpages.

The Excel part is covered extensively in the Tech Database, as well.
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

td

Notice that you asked a very similar question back in 2014 so that thread might be another place to check out.

http://forum.winbatch.com/index.php?topic=1030.msg4728#msg4728
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

MW4

Thanks, that will get me started!!

stanl

I used to perform thousands of lookups into Edmunds.com for depreciation stats. Rather than keeping both Excel and a browser open I would first process the Excel data to a text file or list and use that as the basis for webscrapes. I may still have the script in an archive and parts of it may be of use.  You can send me a private message if interested.