How to Open CSV files using iMacro

1. Let’s make it happened.

The below is just an example which will not work for you as I am using it on bespoke system.

‘open 1 tab only type

TAB T=1
‘ignore errors. this is to allow proceed with macro even if the ip has already been removed
SET !ERRORIGNORE YES
‘wait 2 second instead of default 6s if errors occurs (to speed up the work also sometimes you need to increase because the web page might not appear in the right time and some steps will be missing)
SET !TIMEOUT_PAGE 2
‘set up datasource (this is where the CSV is)
SET !DATASOURCE bulk_reconfiguring.csv
‘ you need to specify the number of rows
SET !DATASOURCE_COLUMNS 2
‘set up loop ( this is what will be repeated from 1 row as the loop is setup as 1 next loop is basically a next row)
SET !LOOP 1
SET !DATASOURCE_LINE {{!LOOP}}
‘open a device search do some work and repeat with the next row
‘ you can see that the {{!COL1}} is build in variable from iMacro this is where your data from CSV will be.
URL GOTO=http://xx.xx.xx/ABLDevice
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:OSSMeta-filter-form ATTR=ID:edit-Value CONTENT={{!COL1}}
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:OSSMeta-filter-form ATTR=ID:edit-submitonce
TAG POS=1 TYPE=A ATTR=TXT:{{!COL1}}
Advertisements

Web Automation with iMacro Software. No more repetetive task! Boost your Web Productivity

Hi Guys,

I though I will share some of my knowledge regards the automation tool and how you can improve your work and any repetitive task.

What we need first is to get right tools for the job. You can use any

1. iMacro Software (Free)

http://imacros.net/overview

You can see my scripts on GitHub

https://github.com/ber5ien/imacros_scripts/tree/master/imacros_scripts

The one based on Javascript. This will give you some more flexibility as you can use them to change your iMacros scripts depending on some data which you can scrap/export from web itself

https://github.com/ber5ien/imacros_scripts/tree/master/javascript

2. Firefox 🙂

http://www.mozilla.org/firefox/new/

3. Some plugins! ( will add some plugins soon )

xMark – Save your bookmarks and sync them anywhere

Autofill Forms – You can use this to automate filling some forms. You can predefine forms so then you can just right click and select the one you need. This is a great tool especially for any web based ticketing systems.

InstantFox – Search Via your Address. This can save few click as you can open some pages directly for instance : open g – This would open a website named as g.

MyWords – You can predefined some sentence and they use keyboard shortcut to it.

4. Let’s get started. I will just give you a quick introduction to it. It’s a quite nice tool and you can use their api to integrate it with language such as vb script php javascript etc.

5.What you need to do first is to records your Macro. Press F8 to get the info then you can start recording.

Once you finish your imacro script you can then see current.imm file which contain what you have recorded.

This is just a beginning more to go which I will be posting soon.