variable {{!colN}}
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: 4
- Joined: Thu May 03, 2018 1:29 pm
variable {{!colN}}
I am creating Imacros bot to submit site in the directory. So I want to give {{!colN}} custom value
I have 2 CSV file, info.csv and category.csv files.
In file.csv i am writing a custom number for example 3, and want to fill a form with {{!col3}} from category.csv
What I tried
1 - {{!col{!col16}} This isn't working
2
set !var1 {{!col16}}
SET !var3 EVAL("var r='{{!var1}}'; var x='{{!col' + r + '}}'; x;")
PROMPT Var_N:<SP>_{{Var_N}}_{{!Var1}}
TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:Address CONTENT={{!var3}}
This text writing {{!col3}} and not value from file
3) I used some javascript and my site to get back value
macro += "tab open" + "\n";
macro += "tab t=2" + "\n";
macro += "URL GOTO=http://example.com/email/gela.php/{{!col16}}" + "\n";
var url = window.location.pathname;
var id = url.substring(url.lastIndexOf('/') + 1);
macro += "tab close" + "\n";
macro += "tab t=1" + "\n";
But this code getting URL from the site where is was first. for example, home file is google.com and then redirect to example.com/email/gela.php/{{!col16}} this code take value from google.com
Do you have any idea I am working on it for 3 days
Pleaseeee........
I have 2 CSV file, info.csv and category.csv files.
In file.csv i am writing a custom number for example 3, and want to fill a form with {{!col3}} from category.csv
What I tried
1 - {{!col{!col16}} This isn't working
2
set !var1 {{!col16}}
SET !var3 EVAL("var r='{{!var1}}'; var x='{{!col' + r + '}}'; x;")
PROMPT Var_N:<SP>_{{Var_N}}_{{!Var1}}
TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:Address CONTENT={{!var3}}
This text writing {{!col3}} and not value from file
3) I used some javascript and my site to get back value
macro += "tab open" + "\n";
macro += "tab t=2" + "\n";
macro += "URL GOTO=http://example.com/email/gela.php/{{!col16}}" + "\n";
var url = window.location.pathname;
var id = url.substring(url.lastIndexOf('/') + 1);
macro += "tab close" + "\n";
macro += "tab t=1" + "\n";
But this code getting URL from the site where is was first. for example, home file is google.com and then redirect to example.com/email/gela.php/{{!col16}} this code take value from google.com
Do you have any idea I am working on it for 3 days
Pleaseeee........
Re: variable {{!colN}}
Try to select the correct Sub-Forum when you open a Thread, your Qt has nothing to do with 'Data Extraction'... (Thread might be moved to the 'General' Sub-Forum "one day"... (But no need to open a Duplicate yourself...))vajavaja16 wrote:I am creating Imacros bot to submit site in the directory. So I want to give {{!colN}} custom value
I have 2 CSV file, info.csv and category.csv files.
In file.csv i am writing a custom number for example 3, and want to fill a form with {{!col3}} from category.csv
What I tried
1 - {{!col{!col16}} This isn't working
2This text writing {{!col3}} and not value from fileCode: Select all
set !var1 {{!col16}} SET !var3 EVAL("var r='{{!var1}}'; var x='{{!col' + r + '}}'; x;") PROMPT Var_N:<SP>_{{Var_N}}_{{!Var1}} TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:Address CONTENT={{!var3}}
3) I used some javascript and my site to get back valueBut this code getting URL from the site where is was first. for example, home file is google.com and then redirect to example.com/email/gela.php/{{!col16}} this code take value from google.comCode: Select all
macro += "tab open" + "\n"; macro += "tab t=2" + "\n"; macro += "URL GOTO=http://example.com/email/gela.php/{{!col16}}" + "\n"; var url = window.location.pathname; var id = url.substring(url.lastIndexOf('/') + 1); macro += "tab close" + "\n"; macro += "tab t=1" + "\n";
Do you have any idea I am working on it for 3 days
Pleaseeee........
(F)CIM...! (Read my Sig...)
Well, no luck, "{{!COL{{!COL1}}" is indeed not supported in iMacros, all Versions, all Browsers...
I have it as an Enhancement Request here... (Item_14)
If you search the Forum a bit, you'll find a Solution/Workaround in JS as you are using a '.js' Script where you can concatenate the "!COL"+"n" in Javascript, that works...-14- Implement a "Super" Built-in Var that could contain Commands like 'OPEN' / 'CLOSE' / 'REFRESH' / 'CLEAR' / etc and other (Built-in) Vars like for example in '{{!COL{{!LOOP}}}}'.
And there is another Workaround in pure '.iim' but that works as well only in FF, by "misusing" the '!DATASOURCE_DELIMITER' Command (which is only supported on FF) to retrieve a complete Row at once from your '.CSV', to then re-split that whole Row into an Array with its original Columns, and the Index within the Array corresponds to the original Cols/Cells.
For other Browsers than FF, you can still use more or less the same "Trick" but you then need to "format" your '.CSV' with one extra Col between all Cols containing some "fake" Delimiter for each Cell and each Row and to open that File as a '.TXT' File and not as a '.CSV'... But it's a bit cumbersome... And there are other Methods, using a Googlesheet or saving your '.CSV' as an '.HTML' File and identifying all Cols with a separate Colour etc..., but it then gets more and more cumbersome, ah-ah...!
- (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: 4
- Joined: Thu May 03, 2018 1:29 pm
Re: variable {{!colN}}
I research all post on this forum and stackoverflow and can't find solution.
can anyone helps me?
can anyone helps me?
Re: variable {{!colN}}
Hum..., "I research all post on this forum" sounds a bit like a "Joke", ah-ah...!, as you didn't even read my Reply..., in which I mentioned, among other things, NOT to open a Duplicate...!vajavaja16 wrote:I research all post on this forum and stackoverflow and can't find solution.
can anyone helps me?
And the first thing you do..., is create a Duplicate...! OK, fair enough, both Threads will eventually get merged or one will be deleted, which is always a bit of a hassle for the Forum Admin..., but this is always a "Show-killer" for me for (further) help Users...
Good luck with other Advanced Users..., and your Boss, oops...!
+ For those interested, parallel Thread on SOF:vajavaja16 wrote:Hello I am trying to solve this problem too much time and please help me
I promise my boss that I will do some bot but I have this problem
So i want to go on use varieble colN
I tryied everyithing I think
this code dont gives me value fromThis code is doing same, only gives me {{!col2}} and dont gives me valueCode: Select all
VERSION BUILD=10.0.501.6698 TAB T=1 TAB CLOSEALLOTHERS SET !DATASOURCE category.csv SET !DATASOURCE_LINE 2 URL GOTO=http://xuxup.com/email/gela.php?id=2 TAG POS=1 TYPE=* ATTR=* EXTRACT=TXT SET !VAR2 EVAL("var s=\"{{!EXTRACT}}\"; var x='{{!col' + s + '}}'; x;") prompt {{!VAR2}}
I tried this and this code takes url from home page.Code: Select all
set !var1 {{!col16}} SET !var3 EVAL("var r='{{!var1}}'; var x='{{!col' + r + '}}'; x;") PROMPT Var_N:<SP>_{{Var_N}}_{{!Var1}} TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:Address CONTENT={{!var3}}
I really need help, pleaseeCode: Select all
macro += "tab open" + "\n"; macro += "tab t=2" + "\n"; macro += "URL GOTO=http://example.com/email/gela.php/{{!col16}}" + "\n"; var url = window.location.pathname; var id = url.substring(url.lastIndexOf('/') + 1); macro += "tab close" + "\n"; macro += "tab t=1" + "\n";
- Imacros variable column with JavaScript
(No Replies yet...)
- (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: 4
- Joined: Thu May 03, 2018 1:29 pm
Re: variable {{!colN}}
I still can't find solution