Looking to Hire Someone to Develope a Macro

Find a consultant or advertise your services here
Post Reply
cnicely
Posts: 2
Joined: Sat Oct 18, 2008 4:02 am
Contact:

Looking to Hire Someone to Develope a Macro

Post by cnicely » Sat Oct 18, 2008 4:11 am

Hi,
I hope this is posted in the right place, if not I apologize. I am new to this and have a tight deadline. Go to this site: http://www.weldtaxsale.com now click on "preview items for sale...click on the first link. All that data on that property I need to have extracted into a spread sheet. All the information. I have to do that for every one of those links. I can run the macro myself, just need you to create it.

There is a video that is doing similar work on the IOpus help demos, (extracting real estate data). Im told this should not take very long, but I can't figure it out. When you do it if you would record it so I could know what to do in future, I would pay for that also. Please contact me as soon as you can. Thank you
Sarah
dharmendra2000
Posts: 214
Joined: Fri Jul 04, 2008 1:28 pm
Location: Ahmedabad
Contact:

Re: Looking to Hire Someone to Develope a Macro

Post by dharmendra2000 » Tue Oct 21, 2008 10:36 am

Hi Sarah,
90% of your problem is solved, please refer below code for your solution.

weld.js

Code: Select all

iimPlay("Weld-page.iim")
s=iimGetLastExtract(1)
num = s.substr(s.indexOf("f")+2,s.length);
for(i=0;i<num;i++)
{
	iimPlay("weld-Extract.iim")
	iimPlay("weld-Next.iim")
}

for(i=1;i<5;i++)
{
	iimSet("rowcount",i)
	iimPlay("weld.iim")	
}
Weld-page.iim

Code: Select all

VERSION BUILD=6070918 RECORDER=FX
TAB T=1
SET !EXTRACT_TEST_POPUP YES
URL GOTO=https://www.weldtaxsale.com/view_bids.cfm
TAG POS=1 TYPE=STRONG ATTR=TXT:of<SP>* EXTRACT=TXT
weld-Extract.iim

Code: Select all

VERSION BUILD=6070918 RECORDER=FX
TAB T=1
'URL GOTO=https://www.weldtaxsale.com/view_bids.cfm

TAG POS=1 TYPE=TD ATTR=TXT:Status
TAG POS=R1 TYPE=A ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=A ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld1.csv

TAG POS=R1 TYPE=A ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=A ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld1.csv

TAG POS=R1 TYPE=A ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=A ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld1.csv

TAG POS=R1 TYPE=A ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=A ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld1.csv
weld-Next.iim

Code: Select all

VERSION BUILD=6070918 RECORDER=FX
TAB T=1
TAG POS=2 TYPE=IMG ATTR=SRC:https://www.weldtaxsale.com/images/buttons/btnNext.gif
weld.iim

Code: Select all

VERSION BUILD=6070918 RECORDER=FX
TAB T=1
TAB CLOSEALLOTHERS

'Mention full path in datasource where Seq Num and Parcel ID is extracted
SET !DATASOURCE D:\iMacro\Downloads\Weld1.csv
SET !DATASOURCE_COLUMNS 3
SET !DATASOURCE_LINE {{rowcount}}

PROMPT {{!COL1}}
PROMPT {{!COL2}}
URL GOTO=https://www.weldtaxsale.com/users/property_detail.cfm?pcn={{!COL2}}&adv_num={{!COL1}}

SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv
Add !EXTRACT PROPERTY<SP>INFO
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=1 TYPE=TD ATTR=TXT:Sequence<SP>Number EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv


WAIT SECONDS=1
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv
Add !EXTRACT VALUATION
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=1 TYPE=TD ATTR=TXT:Homestead<SP>Amount EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

WAIT SECONDS=1
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv
Add !EXTRACT OWNER<SP>INFO
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=1 TYPE=TD ATTR=TXT:Owner<SP>Name<SP>1 EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv

TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
TAG POS=R1 TYPE=TD ATTR=TXT:* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=Weld.csv
Hope it will help in meeting your deadline!
(10% remaining is you have to manually replace "5" with actual number of row in second FOR loop)

(Do not forget to send payment :wink: )
Dharmesh Uteshiya
http://www.dharmesh-uteshiya.co.nr
cnicely
Posts: 2
Joined: Sat Oct 18, 2008 4:02 am
Contact:

Re: Looking to Hire Someone to Develope a Macro

Post by cnicely » Tue Oct 21, 2008 10:10 pm

Thank you so much,

I have left message on your website. Hope to hear from you
Sarah :)
dharmendra2000
Posts: 214
Joined: Fri Jul 04, 2008 1:28 pm
Location: Ahmedabad
Contact:

Re: Looking to Hire Someone to Develope a Macro

Post by dharmendra2000 » Thu Nov 13, 2008 4:43 am

Its better, if you can contact through MSN(preferred)/Yahoo!! (you can get id from my profile) :)
Post Reply