Find Text & Tag Pos using csv

Support for iMacros. The iMacros software is the unique solution for automating every activity inside a web browser, for data extraction and web testing.
Forum rules
iMacros EOL - Attention!

The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.

Thank you again for your business and support.

Sincerely,
The Progress Team

Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
Tamilselvan
Posts: 129
Joined: Mon Mar 07, 2016 10:49 am

Find Text & Tag Pos using csv

Post by Tamilselvan » Mon Oct 30, 2017 1:15 pm

Hi,

Firefox 53.0.3
Imacros 9.0.3
Windows 10 (32 bit)

I have Name list in name.csv file. Using this name i need to search name and find the Tag Position Number in web.

Tag Position Number should be extracted and stored in variable do some task.

Could you please help me.

in name.csv file contents
For example.
1. Sekar
2. Sumathi
3. Velan
4. Govinthammal
5. poinnusami
and so on.,
i don't know how to search name and find the Tag Position Number in web.
Demand-.jpg
then fill Date.

TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_app CONTENT=12/10/2017
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_from CONTENT=12/10/2017
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_d3 CONTENT=6
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_to CONTENT=18/10/2017
ONDIALOG POS=1 BUTTON=OK CONTENT=
ONDIALOG POS=2 BUTTON=OK CONTENT=
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_btnProceed
Demand-1.jpg
i have tried below manually. but its does not have any changes in TAG POS.
SEARCH SOURCE=TXT:Velan
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl02_job
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl03_job
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl04_job

Demand-2.jpg
The above images are shows that no.of rows depends on id from drop down list.
Note : ( i have already code to select id from drop-down automatically. Now i want to search name and find tag position)
Thanks in advance
chivracq
Posts: 10301
Joined: Sat Apr 13, 2013 1:07 pm
Location: Amsterdam (NL)

Re: Find Text & Tag Pos using csv

Post by chivracq » Mon Oct 30, 2017 2:00 pm

Tamilselvan wrote:Hi,

Code: Select all

Firefox 53.0.3
Imacros 9.0.3
Windows 10 (32 bit)
I have Name list in name.csv file. Using this name i need to search name and find the Tag Position Number in web.

Tag Position Number should be extracted and stored in variable do some task.

Could you please help me.

in name.csv file contents
For example.

Code: Select all

1. Sekar
2. Sumathi
3. Velan
4. Govinthammal
5. poinnusami
and so on.,
i don't know how to search name and find the Tag Position Number in web.
Demand-.jpg
then fill Date.

Code: Select all

TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_app CONTENT=12/10/2017
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_from CONTENT=12/10/2017
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_d3 CONTENT=6
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_to CONTENT=18/10/2017
ONDIALOG POS=1 BUTTON=OK CONTENT=
ONDIALOG POS=2 BUTTON=OK CONTENT=
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_btnProceed
Demand-1.jpg
i have tried below manually. but its does not have any changes in TAG POS.

Code: Select all

SEARCH SOURCE=TXT:Velan
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl02_job
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl03_job
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl04_job
Demand-2.jpg
The above images are shows that no.of rows depends on id from drop down list.
Note : ( i have already code to select id from drop-down automatically. Now i want to search name and find tag position)
Thanks in advance
Oh..., I see you are still editing your OP... But OK, if I understand correctly your "Need", you need the 'POS' Number for the Date Fields corresponding to a given Name. => Then simply use "Relative Positioning" for those Date Fields, with the Name as Anchor... :idea:
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
Tamilselvan
Posts: 129
Joined: Mon Mar 07, 2016 10:49 am

Re: Find Text & Tag Pos using csv

Post by Tamilselvan » Mon Oct 30, 2017 2:15 pm

No 1st image shows that i filled date manually.



i used !VAR2 variable for tag pos

After finding out tag position its fill date automatically.

TAG POS={{!VAR2}} TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_app CONTENT=12/10/2017
TAG POS={{!VAR2}} TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_from CONTENT=12/10/2017
TAG POS={{!VAR2}} TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_d3 CONTENT=6
TAG POS={{!VAR2}} TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_to CONTENT=18/10/2017
ONDIALOG POS=1 BUTTON=OK CONTENT=
ONDIALOG POS=2 BUTTON=OK CONTENT=
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_btnProceed
chivracq
Posts: 10301
Joined: Sat Apr 13, 2013 1:07 pm
Location: Amsterdam (NL)

Re: Find Text & Tag Pos using csv

Post by chivracq » Mon Oct 30, 2017 2:43 pm

Tamilselvan wrote:No 1st image shows that i filled date manually.

i used !VAR2 variable for tag pos

After finding out tag position its fill date automatically.

Code: Select all

TAG POS={{!VAR2}} TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_app CONTENT=12/10/2017
TAG POS={{!VAR2}} TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_from CONTENT=12/10/2017
TAG POS={{!VAR2}} TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_d3 CONTENT=6
TAG POS={{!VAR2}} TYPE=INPUT:TEXT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_to CONTENT=18/10/2017
ONDIALOG POS=1 BUTTON=OK CONTENT=
ONDIALOG POS=2 BUTTON=OK CONTENT=
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_btnProceed
Yeah, but no..., your Approach is cumbersome, use Relative Positioning like I said... :idea:

If "ctl02" corresponds to "Velan" in your:

Code: Select all

TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl02_job
... , then that would give stg like:

Code: Select all

SET App_Name "Velan"
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_job&&TXT:*{{App_Name}}*

TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_app CONTENT=12/10/2017
TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_from CONTENT=12/10/2017
TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_d3 CONTENT=6
TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_to CONTENT=18/10/2017
ONDIALOG POS=1 BUTTON=OK CONTENT=
ONDIALOG POS=2 BUTTON=OK CONTENT=
TAG POS=1 TYPE=INPUT:SUBMIT ATTR=ID:ctl00_ContentPlaceHolder1_btnProceed
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
Tamilselvan
Posts: 129
Joined: Mon Mar 07, 2016 10:49 am

Re: Find Text & Tag Pos using csv

Post by Tamilselvan » Mon Oct 30, 2017 3:08 pm

I am just learning now.

i used .csv file instead of
SET App_Name "Velan"

Code is :

VERSION BUILD=11.5.498.2403
TAB T=1
SET !TIMEOUT_STEP 0
SET !DATASOURCE "C:\\Users\\OFFICE\\Documents\\iMacros\\Datasources\\Name.csv"
SET !LOOP 2
SET !DATASOURCE_LINE {{!LOOP}}


SET App_Name {{!COL1}}
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_job&&TXT:*{{App_Name}}*

TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_app CONTENT=12/10/2017
TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_from CONTENT=12/10/2017
TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_d3 CONTENT=6
TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_to CONTENT=18/10/2017
ONDIALOG POS=1 BUTTON=OK CONTENT=
ONDIALOG POS=2 BUTTON=OK CONTENT=
TAG POS=1 TYPE=INPUT:SUBMIT ATTR=ID:ctl00_ContentPlaceHolder1_btnProceed

Finally its working.
Thank you !!! :D
chivracq
Posts: 10301
Joined: Sat Apr 13, 2013 1:07 pm
Location: Amsterdam (NL)

Re: Find Text & Tag Pos using csv

Post by chivracq » Mon Oct 30, 2017 5:37 pm

Tamilselvan wrote:I am just learning now.

i used .csv file instead of

Code: Select all

SET App_Name "Velan"
Code is :

Code: Select all

VERSION BUILD=11.5.498.2403
TAB T=1
SET !TIMEOUT_STEP 0
SET !DATASOURCE "C:\\Users\\OFFICE\\Documents\\iMacros\\Datasources\\Name.csv"
SET !LOOP 2
SET !DATASOURCE_LINE {{!LOOP}}

SET App_Name {{!COL1}}
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_job&&TXT:*{{App_Name}}*

TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_app CONTENT=12/10/2017
TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_from CONTENT=12/10/2017
TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_d3 CONTENT=6
TAG POS=R1 TYPE=INPUT:TEXT ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl*_dt_to CONTENT=18/10/2017
ONDIALOG POS=1 BUTTON=OK CONTENT=
ONDIALOG POS=2 BUTTON=OK CONTENT=
TAG POS=1 TYPE=INPUT:SUBMIT ATTR=ID:ctl00_ContentPlaceHolder1_btnProceed
Finally its working.
Thank you !!! :D
Yep, very good...!, exactly what I meant... :D
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
Post Reply