Send plenty data from a csv-file to a web page

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
George

Send plenty data from a csv-file to a web page

Post by George » Wed Feb 16, 2005 8:38 pm

Hello,

where could a bloody beginner find further info on sending data from a csv-file to a webpage and retrieve the upcoming data? Means do automatic research of prices?

Really big thanks,

George

User avatar
Captive
Macro Veteran
Posts: 213
Joined: Sun Oct 20, 2002 8:37 pm
Location: Colorado, USA

Post by Captive » Thu Feb 17, 2005 12:53 am

The help file! ;)

CSV files are plain text, and you can read any specific line with "ReadLn". (There's a nice looping example in the help file).

You can use the "Seperate" command (again, example in the help file) to split each comma-seperated field in to individual variables.

As for submitting the info to the web page, that depends on what it expects. If you can put the info in the URL, that's a very convenient way and can be done with "HTTPRequest".

If you have to manually navigate in to a web page form, there is a nice VBScript method in these forums to submit values to fields, but requires a fancier routine in your script.

For many problems, Macro Scheduler often provides multiple ways to arrive at a solution. Check out the above commands in the help file and if you need help with loops or variables, just mention it (but be specific) - other people here will help you too.

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts