1

How can I automate copying records from an Excel file or CSV and interacting with a browser?

Example Task:

  1. Extract or Copy record(s) from an Excel file row
  2. Go to a URL (probably using Google Chrome)
  3. Put that data that was copied from the Excel file to the form of the page
  4. Run some scripts or press some bookmarklets I prepared inside the browser (Google Chrome)
  5. Save or Done!
  6. Go to next record/row of the Excel or CSV file.

I like the built-in Automator of Mac but I am not sure if it's capable of what I am asking to do. One complicated task that I see is looping the records from the Excel file or CSV.

For example, after a task is done, going to the next record and repeat the task.

4
  • That looks like a Rube Goldberg solution — what kind of scripts would that be? If those aren't too complicated you can probably submit a form through command line, which would be much easier.
    – slhck
    Aug 1, 2012 at 8:29
  • I prepared some bookmarklet done in javascript also interacting with the DOM elements. eg, override dates or submit form etc. If it can interact with the browser, like it can click my bookmarklet, then it's good.
    – Pennf0lio
    Aug 1, 2012 at 8:34
  • my main functionality I am looking for is, go thru my excel file. get the records, go to a url, interact with the form (fill form and submit etc), and interact with my browser, click some bookmarklets.
    – Pennf0lio
    Aug 1, 2012 at 8:35
  • Certainly doable, but probably hell of a job since you will be automating a lot. I'll see if I have the time to check it out, but at that point, just for making things easier, trying (or buying) UIBrowser would be an idea worth considering I guess ;)
    – slhck
    Aug 1, 2012 at 8:42

2 Answers 2

1

You can use Selenium IDE plugin for Firefox (if you can't find the right version, go to their website), it's very advanced (you can record and do some customization later), but it doesn't work outside of the web browser, so I'd have to import your Excel document into Google Docs. The other alternatives are BadBoy or JMeter (more advanced, you can paste the rows from CSV format and parse it from there), iMacros, Watij, etc.

0

Have you considered a programable keyboard like the Razer Nostromo?

I have one & it comes with a scripting functionality that starts up at the hit of a button. I have used it for loading files over and over again when I have 100's of them that need to be loaded one at a time.

Here's a link to what I'm talking about. http://www.amazon.com/Razer-Nostromo-Gaming-Keypad-RZ07-00490100-R3/dp/B004AM5RB6

1
  • No, I haven't... but it looks cool. But I'll try first my luck on software side. thanks!
    – Pennf0lio
    Aug 3, 2012 at 9:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .