Find Text & Tag Pos using csv
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
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
-
- Posts: 129
- Joined: Mon Mar 07, 2016 10:49 am
Find Text & Tag Pos using csv
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. 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
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
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
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. 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
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
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
Re: Find Text & Tag Pos using csv
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...Tamilselvan wrote:Hi,
I have Name list in name.csv file. Using this name i need to search name and find the Tag Position Number in web.Code: Select all
Firefox 53.0.3 Imacros 9.0.3 Windows 10 (32 bit)
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.i don't know how to search name and find the Tag Position Number in web. then fill Date.Code: Select all
1. Sekar 2. Sumathi 3. Velan 4. Govinthammal 5. poinnusami and so on.,
i have tried below manually. but its does not have any changes in TAG POS.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
The above images are shows that no.of rows depends on id from drop down list.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
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
- (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...
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
-
- Posts: 129
- Joined: Mon Mar 07, 2016 10:49 am
Re: Find Text & Tag Pos using csv
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
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
Re: Find Text & Tag Pos using csv
Yeah, but no..., your Approach is cumbersome, use Relative Positioning like I said...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
If "ctl02" corresponds to "Velan" in your:
Code: Select all
TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_ContentPlaceHolder1_gvData_ctl02_job
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...
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
-
- Posts: 129
- Joined: Mon Mar 07, 2016 10:49 am
Re: Find Text & Tag Pos using csv
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 !!!
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 !!!
Re: Find Text & Tag Pos using csv
Yep, very good...!, exactly what I meant...Tamilselvan wrote:I am just learning now.
i used .csv file instead ofCode is :Code: Select all
SET App_Name "Velan"
Finally its working.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
Thank you !!!
- (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...
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...