Page 1 of 1

Datasource CSV data extraction error

Posted: Thu May 13, 2010 1:07 pm
by nveeravalli
I am working on refreshing my resume multiple times so i was using this macro code, initially it worked perfectly but now i am getting the problem.

1st time it is working perfect, when it executes 2nd time it is not detecting the csv file information and unable to enter the login id and password. Please help me with the right solution.

VERSION BUILD=5100314
TAB T=1
TAB CLOSEALLOTHERS
CMDLINE !DATASOURCE dice.csv
'Number of columns in the CSV file. This must be accurate!
SET !DATASOURCE_COLUMNS 2
'Increase the current position in the file with each loop
'SET !DATASOURCE_LINE 1
URL GOTO=http://seeker.dice.com/profman/servlet/ ... 00&pg=1000
SIZE X=1132 Y=579
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:INFO ATTR=NAME:SJT_USER_NAME CONTENT={{!COL1}}
TAG POS=1 TYPE=INPUT:PASSWORD FORM=NAME:INFO ATTR=NAME:SJT_PASSWD CONTENT={{!COL2}}
ONSECURITYDIALOG BUTTON=YES CONTINUE=YES
TAG POS=1 TYPE=BUTTON ATTR=TXT:Login
TAG POS=1 TYPE=A ATTR=TXT:MyResume
TAG POS=1 TYPE=BUTTON ATTR=TXT:Edit
TAG POS=1 TYPE=IMG ATTR=HREF:http://seeker.dice.com/profman/captcha.jpg
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:REVIEW ATTR=NAME:SecurityCode
PROMPT Please<SP>enter<SP>security<SP>code: !VAR1
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:REVIEW ATTR=NAME:SecurityCode CONTENT={{!VAR1}}
TAG POS=1 TYPE=BUTTON ATTR=TXT:Post<SP>Resume
TAG POS=1 TYPE=IMG ATTR=TXT:<IMG<SP>style="BORDER-TOP-WIDTH:<SP>0px;<SP>BORDER-LEFT-WIDTH:<SP>0px;<SP>BORDER-BOTTOM-WIDTH:<SP>0px;<SP>BORDER-RIGHT-WIDTH:<SP>0px"<SP>src="images/no_thank_you.jpg">
TAG POS=1 TYPE=A ATTR=TXT:Logout

--------------
dice.csv

syedahmed.bo@gmail.com mercury123
lakshmikumari.bo@gmail.com mercury123 -- my macro is unable to take from this data.
sohail.sqlm@gmail.com mercury123

Re: Datasource CSV data extraction error

Posted: Fri May 14, 2010 12:17 pm
by MattBell7
replace

Code: Select all

'SET !DATASOURCE_LINE 1
with

Code: Select all

SET !DATASOURCE_LINE {{!LOOP}}