Version 9.0.3
Windows 10
Firefox 50.1.0
Any one help this code, please
VERSION BUILD=9030808 RECORDER=FX
TAB T=1
SET !DATASOURCE "C:\\Users\\OFFICE\\Documents\\iMacros\\Datasources\\JobCard-No.csv"
SET !LOOP 2
SET !DATASOURCE_LINE {{!LOOP}}
'Select Village name
TAG POS=1 TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village EXTRACT=TXT
' Extract Length 15. : TAG POS=1 TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village CONTENT=%2906015005007<SP><SP><SP><SP><SP>
SET !VAR5 EVAL("'{{!EXTRACT}}'.trim();")
'After trim Extract Length is 13. Because i need to check both in .csv 4th column length is 13.
SET !VAR3 EVAL("if({{!COL4}}!={{!VAR5}}){TAG POS=1 TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village CONTENT={{!COL4}}} else{do nothing and move to next row until a match is found};")
I have some error.
missing ; before statement, line: 22 (Error code: -1001)
.CSV File contain
Change Drop Down Button 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
Re: Change Drop Down Button Using CSV
Hum..., I've never tried, but I don't think this Syntax works, and if it worked, it would be stg like:Tamilselvan wrote:Any one help this code, pleaseCode: Select all
Version 9.0.3 Windows 10 Firefox 50.1.0
I have some error.Code: Select all
VERSION BUILD=9030808 RECORDER=FX TAB T=1 SET !DATASOURCE "C:\\Users\\OFFICE\\Documents\\iMacros\\Datasources\\JobCard-No.csv" SET !LOOP 2 SET !DATASOURCE_LINE {{!LOOP}} 'Select Village name TAG POS=1 TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village EXTRACT=TXT ' Extract Length 15. : [b]TAG POS=1 TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village CONTENT=%2906015005007<SP><SP><SP><SP><SP>[/b] SET !VAR5 EVAL("'{{!EXTRACT}}'.trim();") 'After trim Extract Length is 13. Because i need to check both in .csv 4th column length is 13. SET !VAR3 EVAL("if({{!COL4}}!={{!VAR5}}){TAG POS=1 TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village CONTENT={{!COL4}}} else{do nothing and move to next row until a match is found};")
missing ; before statement, line: 22 (Error code: -1001)
.CSV File contain
Code: Select all
SET !VAR3 EVAL("if('{{!COL4}}'!='{{!VAR5}}'){TAG POS=1 TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village CONTENT=%'{{!COL4}}';};")
Code: Select all
SET !VAR3 EVAL("var z; if('{{!COL4}}'!='{{!VAR5}}'){z=1;} else{z=0;}; z;")
SET !ERRORIGNORE YES
TAG POS={{!VAR3}} TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village CONTENT=%{{!COL4}}
(And you had forgotten the '%' Selector for the DDLB...)
- (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: Change Drop Down Button Using CSV
Thanks a lot.
this Syntax works
SET !VAR3 EVAL("var z; if('{{!COL4}}'!='{{!VAR5}}'){z=1;} else{z=0;}; z;")
SET !ERRORIGNORE YES
TAG POS={{!VAR3}} TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village CONTENT=%{{!COL4}}
And you had forgotten the '%' Selector for the DDLB..
Sorry for forgotten the '%' Selector for the DDLB...
Once again thank you very much.
this Syntax works
SET !VAR3 EVAL("var z; if('{{!COL4}}'!='{{!VAR5}}'){z=1;} else{z=0;}; z;")
SET !ERRORIGNORE YES
TAG POS={{!VAR3}} TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village CONTENT=%{{!COL4}}
And you had forgotten the '%' Selector for the DDLB..
Sorry for forgotten the '%' Selector for the DDLB...
Once again thank you very much.
Re: Change Drop Down Button Using CSV
OK, good to hear..., Thanks for the Feedback/Follow-up...Tamilselvan wrote:Thanks a lot.
this Syntax works
And you had forgotten the '%' Selector for the DDLB..Code: Select all
SET !VAR3 EVAL("var z; if('{{!COL4}}'!='{{!VAR5}}'){z=1;} else{z=0;}; z;") SET !ERRORIGNORE YES TAG POS={{!VAR3}} TYPE=SELECT FORM=ID:aspnetForm ATTR=ID:ctl00_ContentPlaceHolder1_DDL_Village CONTENT=%{{!COL4}}
Sorry for forgotten the '%' Selector for the DDLB...
Once again thank you very much.
- (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...