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}}

How to use Javascript with iMacro and find out the end of file in CSV file.

1. Once you recorded your Macro using iMacro you need to change to file to (.js) extension. This will enable you to use javascript code inside to macro to give what you need.

Example of use of JavaScript can be found here on my Github account.

https://github.com/ber5ien/imacros_scripts/blob/master/javascript/daily_calls_update_v2.js

This piece of code will be found at the finish of CSV files so you can iterate over rows in cvs files.

This is very useful with imacro otherwise you need to type in manually how many rows you got in to CSV files.

 

datasource – this is path to your datasource C://…

Hylas – this can be ignored ­čÖé

csv_file_name = your csv name which need to be put into Datasource directory.

function count_rows(datasource,hylas,csv_file_name)
{
 // COUNT THE NUMBERS OF ROWS IN CSV FOR LOOP
┬áconst CRLF = “\r\n”;
┬áconst LF = “\n”;
 
 var lines = new Array();
 
 var file_i = imns.FIO.openNode(datasource+hylas+csv_file_name);
 var text = imns.FIO.readTextFile(file_i); // Read file into one string
 
 // Determine end-of-line marker
 var eol = (text.indexOf(CRLF) == -1) ? LF : CRLF;
 
 // Split into lines (number of lines) NUMBER OF LINES IN CSV
 lines = text.split(eol);
 eol = lines.length;
 //iimDisplay(eol);
 // FINISH COUNTING EOL = NUmber of LInes
 return eol;
}

SSD Hosting for 5 dollars a month https://www.digitalocean.com/?refcode=71a52388956e

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.