Fill in web forms with CSV data ... Is it possible?

[kilowatt]

I think this might be beyond the scope of this forum but I am at a loss here. Figured I'd through it out there and see if anyone knows of a product or method to do this.

We have a software product our company sells that we currently get a new clients existing data and convert it into a format that is compatible with our system. Currently we are releasing a SQL version of this product but the data conversion still has to go to our original software and then there is another conversion process to go to our SQL product.

The problem I am having is our development team is doing all this and they take to long. I am in need of converting some smaller clients in an expidited manner and their data is quite simple.

What I am thinking would work for smaller tasks like this is if there is a way to programatically submit row by row in the CSV file to a web form.

Each column in the CSV would be a specific form on the website. But there could be a variable number of rows in the files depending on the client.

Is there a way to read a CSV file and load each cells data into a different field and then click the save button. There would be a few extra steps in there after submission. Like clicking the links to get back to the submission page.

I can put the data in other formats too if I need to. Any thoughts or ideas would be greatly appreciated.

 

[Legacy 98055]

My experience with automating [Excel to web] data entry is that just about any user action can be imitated using code. There are a few exceptions but these would not likely be encountered in your case.

The problem we have is giving you specific help. Since web pages are unique, the code to automate the transfer of data will also be unique.

So the answer to your question...

"Is there a way to read a CSV file and load each cells data into a different field and then click the save button. There would be a few extra steps in there after submission. Like clicking the links to get back to the submission page. "

...is yes. You should pursue this if it will be a time saver. There are several members on this board who are quite apt in this area. However, you will need to provide URL's (though I would assume that this an intranet site - in this case, provide the source HTML if possible). Also provide other details.

 

[TTom]

Kilowatt,
Could you keep me posted on your progress?
I may have similar project coming up.
You can drop a note to my PM box. Thanks.