Text file splitter

[Legend 181]

I have a .csv file of roughly 5000 domains that I need to check for availability. I need to split it into sublists of 500 (godaddy won't check more than 500 at a time) domains and then individually check these sublists.

 

What I have so far is:

 

navigate("http://www.godaddy.com/default.aspx", "Wait")

click(<innertext="Bulk Search">, "Left Click", "No")

clear table(&domains2check)

create table from file("{$special folder("Desktop")}\\domains2check.csv", &domains2check)

set(#rows, $table total rows(&domains2check), "Global")

set(#loops, $divide(#rows, 500), "Global")

loop(#loops) {

type text(<data-clear="true">, "good question", "Standard")

}

 

but I'm stumped as to how to set up the loop.

 

Any advise?

 

Thanks!

http://ubotstudio.com/forum/public/style_emoticons/default/smile.gif

 

 

 

[JohnB 255]

I would set up the csv with ten columns of 500 and then just increment the column number after 500 cycles (two loops...the outer loop is 10 cycles and the inner loop is 500 cycles).

 

 

John

[Legend 181]

Interesting idea... how would you designate a data range to include in a column though? http://ubotstudio.com/forum/public/style_emoticons/default/blink.gif

[JohnB 255]

Personally I would use lists and not a table. Put the lists in text files in a directory. The you could use read file to fill the form. It's compact and reusable regardless of how many domains you have..

 

(Yeah, the range makes it a pain...therefore the individual lists are the better option)

 

 

 

John

[Legend 181]

This keeps freezing up on me... any idea why? Is it just me? http://ubotstudio.com/forum/public/style_emoticons/default/blink.gif

navigate("http://www.godaddy.com/default.aspx", "Wait")click(<innertext="Bulk Search">, "Left Click", "No")

clear table(&domains2check)

create table from file("{$special folder("Desktop")}\\domains2check.csv", &domains2check)

set(#rows, $table total rows(&domains2check), "Global")

set(#loops, $divide(#rows, 500), "Global")

loop(#loops) {

set(#filename, "dmoz-domians-0.txt", "Global")

set(#first batch, $list from file("{$special folder("Desktop")}\\split dmox domains\\{#filename}"), "Global")

type text(<data-clear="true">, #first batch, "Standard")

}

[JohnB 255]

Hey Duane...I don't have any files to run it with, but in looking at the code and the site, I think you may want to use change attribute instead of type text (change the value attribute) as it will erase the current text in the field.

 

Also, your click command needs to be on the second line (not sure if it showed up this way when you pasted it)

 

John