URL GOTO={{!COLn}} Error

[Rylock]

I have an eight-column csv ('UTF-8, with BOM' formatted), where the eighth column is a URL. I have the following code that's simple enough:

Code: Select all

SET !DATASOURCE /Users/Ryan/iMacros/test.csv
SET !DATASOURCE_COLUMNS 8
SET !LOOP 2
SET !DATASOURCE_LINE {{!LOOP}}
TAB T=1
URL GOTO={{!COL8}}

There's more to it than that, but I essentially just need the URL in column 8 to populate before the rest of the code. Anybody know why I'm getting a crazy error message?

Error loading page http://api.mybrowserbar.com/cgi/searchp ... oogle.com/, line 7 (Error code: -933)

Seems like the "https://www.google.com/" at the end of the error message is just whichever website I was currently on while trying to run the macro; the URL currently in column 8, row 2 is http://www.facebook.com, which appears nowhere in the error. And "Error code: -933" means "Network error while file or page loading." Any ideas? I'm using the newest version of iMacros and Firefox on Mac OS X.

[Edoctoor]

Code: Select all

SET !DATASOURCE /Users/Ryan/iMacros/test.csv
SET !DATASOURCE_COLUMNS 8
SET !LOOP 2
SET !DATASOURCE_LINE {{!LOOP}}
TAB T=1
URL GOTO={{!COL8}}

I would first insert PROMPTS to see if what your doing is what your intending to do.
Secondly, I would try to add a wait... timing is everything when using a url goto= statement
They are my two guesses

Code: Select all

' ========================================================================
' Initialize standard macro starting configurations
' ========================================================================
' Make tab 1 active
TAB T=1
' Don't stop if a button is missing or if page hasn't loaded
SET !ERRORIGNORE 		YES
' If button is missing don't wait a minute for the button to appear
SET !TIMEOUT_STEP 		60
' Don't show popups 
SET !EXTRACT_TEST_POPUP 	YES
' Clear contents stored in !EXTRACT in case of loop
SET !EXTRACT NULL

SET !DATASOURCE /Users/Ryan/iMacros/test.csv
SET !DATASOURCE_COLUMNS 8
SET !LOOP 2
SET !DATASOURCE_LINE {{!LOOP}}
TAB T=1
PROMPT {{!COL8}}
URL GOTO={{!COL8}}
WAIT SECONDS=10

If that doesn't help... please include your Operating System, your iMacro version, and your Browser information so we have a starting point... best regards

[Rylock]

Thanks for responding! But I figured it out after a bit. I needed to make the URL in each cell in Column 8 look like "=http://www.facebook.com" instead of just http://www.facebook.com. Then it worked great!

[Edoctoor]

thank you so much for posting your solution.... as the time you wasted.. struggling with this strange issue.. will not be wasted on the next person with the same issue.

I would edit your thread with [SOLVED] URL GOTO={{!COLn}} Error

if this was my thread... thanks again. I learned something today

[chivracq]

Thanks for responding! But I figured it out after a bit. I needed to make the URL in each cell in Column 8 look like "=http://www.facebook.com" instead of just http://www.facebook.com. Then it worked great!

Yep, Thanks for sharing indeed even if you could have done so proactively even if nobody had replied to your Thread (yet), but it's not clear to me if the '=' Sign is making the "Trick" (and this is new for me then...) together with the Double Quotes or if it's a typo like I suspect and only the Double Quotes are needed and you didn't mention your FCI (that's why I didn't react to your Thread when you opened it...) but the Double Quotes are only needed for FF, I would think... and/or at the Condition of course that the rest of your Data doesn't contain any Commas or whichever Char you defined as the Separator...

But if the '=' Sign is actually the Trick, then OK, good to know, though I'm a bit surprised I had never heard of that before... (and I don't use URL's pulled out of a DataSource for 'URL GOTO', so I never encountered that Pb myself as I use iMacros for FF (as well (if I'm correct that you are on FF)...)
=> So that would still be interesting/useful if you could mention your FCI... (and required for me if you want that I answer any of your (future) Threads...)

[Edoctoor]

Thanks for responding! But I figured it out after a bit. I needed to make the URL in each cell in Column 8 look like "=http://www.facebook.com" instead of just http://www.facebook.com. Then it worked great!

If you have time... I would like to see more details... like a one line test.csv file and a full working macro (snippet) so I can see this and examine fully. Just because, want a working example for my records... special thanks if you have time for my request.