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

Advertisements

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

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