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

Forum rulesBefore 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

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

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

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........

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...))

(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)

-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}}}}'.

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...
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)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...

vajavaja16 wrote:I research all post on this forum and stackoverflow and can't find solution.
can anyone helps me?

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...!
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...!

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

- (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...