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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s