Extract Mystery

Discussions and Tech Support related to website data extraction, screen scraping and data mining using iMacros.

Moderators: Community Moderators, iMacros Moderators

Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the Google search box (at the top of each forum page) to see if a similar problem or question has already been addressed. This will search the entire contents of the forums as well as the iMacros Wiki.
3. We can respond much faster to your posts if you include the following information:

CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST

Answering your own posts (e.g. attempting to "bump" your topic) drops your topic from the list of unanswered threads, so it may actually receive less views.

Extract Mystery

by gchichester on Sat Aug 13, 2016 7:28 am

Somewhere in one of these 3 scripts
Billing_First.iim
Code: Select all
VERSION BUILD=9052613
SET !REPLAYSPEED FAST
SET MyWait 3
SET PID "023967496"
SET POS "99"
SET Proc "S5102"
SET Mod "UC"
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Datapanel:_ctl0:_ctl4:ClaimRecipient:ds_ClaimRecipient:mb_ds_ClaimRecipient CONTENT={{ConsumerID}}
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl2:PerformingProvider_ProviderID:mb_PerformingProvider_ProviderID CONTENT={{PID}}
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
IMAGESEARCH POS=1 IMAGE=MCD.png CONFIDENCE=80
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl3:FirstServiceDate:mb_FirstServiceDate CONTENT={{DateOfService}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl4:LastServiceDate:mb_LastServiceDate CONTENT={{LDateOfService}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl5:PlaceOfService:ds_PlaceOfService:mb_ds_PlaceOfService CONTENT={{POS}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl6:Procedure:ds_Procedure:mb_ds_Procedure CONTENT={{Proc}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl7:Modifier1:ds_Modifier1:mb_ds_Modifier1 CONTENT={{Mod}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl10:BilledQuantity:mb_BilledQuantity CONTENT={{Units}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl11:BilledAmount:mb_BilledAmount CONTENT={{Rate}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
TAG POS=3 TYPE=A FORM=NAME:Form ATTR=TXT:add
'TAG POS=3 TYPE=A FORM=NAME:Form ATTR=TXT:add<SP>N


Billing_First2.iim
Code: Select all
' Macro without ConsumerID
VERSION BUILD=9052613
SET !REPLAYSPEED FAST
SET MyWait 1
SET PID "023967496"
SET POS "99"
SET Proc "S5102"
SET Mod "UC"
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl2:PerformingProvider_ProviderID:mb_PerformingProvider_ProviderID CONTENT={{PID}}
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
IMAGESEARCH POS=1 IMAGE=MCD.png CONFIDENCE=80
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl3:FirstServiceDate:mb_FirstServiceDate CONTENT={{DateOfService}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl4:LastServiceDate:mb_LastServiceDate CONTENT={{LDateOfService}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl5:PlaceOfService:ds_PlaceOfService:mb_ds_PlaceOfService CONTENT={{POS}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl6:Procedure:ds_Procedure:mb_ds_Procedure CONTENT={{Proc}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl7:Modifier1:ds_Modifier1:mb_ds_Modifier1 CONTENT={{Mod}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl10:BilledQuantity:mb_BilledQuantity CONTENT={{Units}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl11:BilledAmount:mb_BilledAmount CONTENT={{Rate}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
TAG POS=3 TYPE=A FORM=NAME:Form ATTR=TXT:add
'TAG POS=3 TYPE=A FORM=NAME:Form ATTR=TXT:add<SP>N


PaidAmt.iim
Code: Select all
VERSION BUILD=10002738
SET !EXTRACT_TEST_POPUP NO
ADD !EXTRACT {{ConsumerID}}
TAG POS=2 TYPE=A FORM=NAME:Form ATTR=TXT:Paid EXTRACT=TXT
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Status:Datapanel:_ctl1:_ctl4:PaidAmo* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=status.csv


The extract is sending data to a file named BillingStaus.csv in folder BillingData
I can't seem to find where to change the path to the folder or change the filename
Or where the extract code is called, I thought I would see a call to PaidAmt.iim

Thank you in advance for any all suggestions
gchichester
gchichester
 
Posts: 3
Joined: Wed Dec 11, 2013 3:50 am

Re: Extract Mystery

by chivracq on Sat Aug 13, 2016 6:35 pm

gchichester wrote:Somewhere in one of these 3 scripts
Billing_First.iim
Code: Select all
VERSION BUILD=9052613
SET !REPLAYSPEED FAST
SET MyWait 3
SET PID "023967496"
SET POS "99"
SET Proc "S5102"
SET Mod "UC"
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Datapanel:_ctl0:_ctl4:ClaimRecipient:ds_ClaimRecipient:mb_ds_ClaimRecipient CONTENT={{ConsumerID}}
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl2:PerformingProvider_ProviderID:mb_PerformingProvider_ProviderID CONTENT={{PID}}
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
IMAGESEARCH POS=1 IMAGE=MCD.png CONFIDENCE=80
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl3:FirstServiceDate:mb_FirstServiceDate CONTENT={{DateOfService}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl4:LastServiceDate:mb_LastServiceDate CONTENT={{LDateOfService}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl5:PlaceOfService:ds_PlaceOfService:mb_ds_PlaceOfService CONTENT={{POS}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl6:Procedure:ds_Procedure:mb_ds_Procedure CONTENT={{Proc}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl7:Modifier1:ds_Modifier1:mb_ds_Modifier1 CONTENT={{Mod}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl10:BilledQuantity:mb_BilledQuantity CONTENT={{Units}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl11:BilledAmount:mb_BilledAmount CONTENT={{Rate}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
TAG POS=3 TYPE=A FORM=NAME:Form ATTR=TXT:add
'TAG POS=3 TYPE=A FORM=NAME:Form ATTR=TXT:add<SP>N


Billing_First2.iim
Code: Select all
' Macro without ConsumerID
VERSION BUILD=9052613
SET !REPLAYSPEED FAST
SET MyWait 1
SET PID "023967496"
SET POS "99"
SET Proc "S5102"
SET Mod "UC"
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl2:PerformingProvider_ProviderID:mb_PerformingProvider_ProviderID CONTENT={{PID}}
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
WAIT SECONDS={{MyWait}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
IMAGESEARCH POS=1 IMAGE=MCD.png CONFIDENCE=80
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl3:FirstServiceDate:mb_FirstServiceDate CONTENT={{DateOfService}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl4:LastServiceDate:mb_LastServiceDate CONTENT={{LDateOfService}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl5:PlaceOfService:ds_PlaceOfService:mb_ds_PlaceOfService CONTENT={{POS}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl6:Procedure:ds_Procedure:mb_ds_Procedure CONTENT={{Proc}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl7:Modifier1:ds_Modifier1:mb_ds_Modifier1 CONTENT={{Mod}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl10:BilledQuantity:mb_BilledQuantity CONTENT={{Units}}
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Detail:Datapanel:_ctl0:_ctl11:BilledAmount:mb_BilledAmount CONTENT={{Rate}}
TAG POS=1 TYPE=ACRONYM FORM=NAME:Form ATTR=TXT:Hard-Copy<SP>Attachments
TAG POS=3 TYPE=A FORM=NAME:Form ATTR=TXT:add
'TAG POS=3 TYPE=A FORM=NAME:Form ATTR=TXT:add<SP>N


PaidAmt.iim
Code: Select all
VERSION BUILD=10002738
SET !EXTRACT_TEST_POPUP NO
ADD !EXTRACT {{ConsumerID}}
TAG POS=2 TYPE=A FORM=NAME:Form ATTR=TXT:Paid EXTRACT=TXT
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:Form ATTR=NAME:dnn:ctr366:ClaimPhysicianInformation:_ctl2:Status:Datapanel:_ctl1:_ctl4:PaidAmo* EXTRACT=TXT
SAVEAS TYPE=EXTRACT FOLDER=* FILE=status.csv


The extract is sending data to a file named BillingStaus.csv in folder BillingData
I can't seem to find where to change the path to the folder or change the filename
Or where the extract code is called, I thought I would see a call to PaidAmt.iim

Thank you in advance for any all suggestions
gchichester

FCIM for me to have a look, (read my Sig), I don't know this v9.0.5 Version... Some older iMB Version...?

And hum... :shock: , you never followed up on your 2 previous Threads, so that doesn't motivate much to want to help you..., the first one, OK, nobody replied but I guess you managed to solve it, otherwise you should/would have bumped it, so you should share your Solution as that can make the Thread useful for other Users, and the second one, you never bothered to thank TechSup for providing some Answer (and to confirm that it was the (correct) Answer/Solution to your Qt/Pb...).
And in none of your Threads you mentioned correctly your FCI either...

Sorry for this mini-Rant..., but I only help Users using the Forum a bit correctly (for all their Threads), with Descriptive Thread Title ("Extract Mystery" is a bit vague on that point...) + FCI mentioned + neat Follow-up + sharing their Solution to make their Threads useful as well for other Users searching the Forum...
=> If you could improve the "Quality" of your 3 Threads on those points for me to have a look at this one... :idea:
- (F)CIM = (Full) Config Info Missing: iMacros + Browser + OS with all 3 Versions...
- I usually don't even read the Question if that (required) Info is not mentioned...
- Script & URL usually help a lot for a more "educated" Help...
chivracq
 
Posts: 6477
Joined: Sat Apr 13, 2013 6:07 am
Location: Amsterdam (NL)


Return to Data Extraction and Web Screen Scraping

Who is online

Users browsing this forum: No registered users and 3 guests

cron
-->