First Account Creator, Pulling Data From Csv, Please Help

[amitbot 0]

hi

Can you help please? I have followed some tutorials and got this far but I think this is not correct. basically I need to use my own data for email and password pulled from .csv and name/surname from $account data. I created table from file  and have it in a loop so every time it starts from the next row. but the way i have scripted this I am sure it will just keep filling the sign up page over and over again, rather than create one account and then on the next cycle (which will run 31 to 56 sec later) create another account from the next row and so on. here is what I mean:

 

loop(30) {

    navigate("www.eaxample-signup-page.com","Wait")
    wait($rand(1,3))

    forexample navigate to www.signup.com

    type text(<name="customerName">,"{$account data("First Name")} {$account data("Last Name")}","Standard")
    clear table(&ukaddy)
    create table from file("C:\\Users\\triosi\\Documents\\UBot Studio\\data\\uk test.csv",&ukaddy)
    set(#row,0,"Global")
    loop($table total rows(&ukaddy)) {
        type text($element offset(<email field>,0),$table cell(&ukaddy,"",""),"Standard")
        type text($element offset(<email field>,1),$table cell(&ukaddy,"",""),"Standard")
        type text($element offset(<password field>,0),$table cell(&ukaddy,"",""),"Standard")
        type text($element offset(<password field>,1),$table cell(&ukaddy,"",""),"Standard")
        increment(#row)
    }
    wait($rand(31,56))
    click(<id="continue">,"Left Click","No")

}

 

any help or advice would be much appreciated

[amitbot 0]

sorry delete the forexample navigate to www.signup.com from the script:

 

loop(30) {

    navigate("www.eaxample-signup-page.com","Wait")
    wait($rand(1,3))

    type text(<name="customerName">,"{$account data("First Name")} {$account data("Last Name")}","Standard")
    clear table(&ukaddy)
    create table from file("C:\\Users\\triosi\\Documents\\UBot Studio\\data\\uk test.csv",&ukaddy)
    set(#row,0,"Global")
    loop($table total rows(&ukaddy)) {
        type text($element offset(<email field>,0),$table cell(&ukaddy,"",""),"Standard")
        type text($element offset(<email field>,1),$table cell(&ukaddy,"",""),"Standard")
        type text($element offset(<password field>,0),$table cell(&ukaddy,"",""),"Standard")
        type text($element offset(<password field>,1),$table cell(&ukaddy,"",""),"Standard")
        increment(#row)
    }
    wait($rand(31,56))
    click(<id="continue">,"Left Click","No")

}

[pash 504]

type text

type text($element offset(<email field>,1),$table cell(&ukaddy,#row,0),"Standard")

loop(30) {
    navigate("www.eaxample-signup-page.com","Wait")
    wait for browser event("Everything Loaded","")
    wait($rand(1,3))
    type text(<name="customerName">,"{$account data("First Name")} {$account data("Last Name")}","Standard")
    clear table(&ukaddy)
    create table from file("C:\\Users\\triosi\\Documents\\UBot Studio\\data\\uk test.csv",&ukaddy)
    set(#row,0,"Global")
    loop($table total rows(&ukaddy)) {
        type text($element offset(<email field>,0),$table cell(&ukaddy,"",""),"Standard")
        type text($element offset(<email field>,1),$table cell(&ukaddy,#row,0),"Standard")
        type text($element offset(<password field>,0),$table cell(&ukaddy,#row,1),"Standard")
        type text($element offset(<password field>,1),$table cell(&ukaddy,#row,2),"Standard")
        increment(#row)
    }
    wait($rand(31,56))
    click(<id="continue">,"Left Click","No")
}

 

[amitbot 0]

thank you Pash... I have written this script with your instructions. as soon as it gets to the sign up page of prnewswire it just refreshes the page and starts again. i just have a simple csv with 3 rows and 2 columns and want to create 3 account every 30sec for this test. The csv is like this with just email and phone number:

 

harry57599fio9@yahoo.com  442084478928

d4e76yuu3wu@outlook.com  442084573894

skeanz439hj@hotmail.co.uk  442082785987

 

the rest of the data i am pulling from $account data

 

 

loop(3) {
    navigate("http://www.prnewswire.com/","Wait")
    wait(2)
    click(<id="mobile-menu-btn">,"Left Click","No")
    wait(2)
    click($element offset(<login link>,1),"Left Click","No")
    wait(1)
    click($element offset(<create account link>,3),"Left Click","No")
    type text(<first name field>,$account data("First Name"),"Standard")
    type text(<last name field>,$account data("Last Name"),"Standard")
    create table from file("C:\\Users\\triosi\\Documents\\UBot Studio\\data\\uk test.csv",&tableuk1)
    set(#row,0,"Global")
    loop($table total rows(&tableuk1)) {
        type text(<email field>,$table cell(&tableuk1,#row,0),"Standard")
        change dropdown(<country dropdown>,"United Kingdom")
        type text(<name="Phone">,$table cell(&tableuk1,#row,1),"Standard")
        change dropdown(<name="typeofCompany">,"Random")
        type text(<company field>,$account data("Last Name"),"Standard")
        click(<terms of service checkbox>,"Left Click","No")
        increment(#row)
    }
    wait(10)
    click(<create account button>,"Left Click","No")
    wait(30)
}

[amitbot 0]

Can anyone help with this please? The script keeps filling in the sign up page over and over. But i want it to be filling it in once, create account and then go to the next line on csv to fill in the sign up page... and so on

 

loop(3) {

    navigate("http://www.prnewswire.com/","Wait")

    wait(2)

    click(<id="mobile-menu-btn">,"Left Click","No")

    wait(2)

    click($element offset(<login link>,1),"Left Click","No")

    wait(1)

    click($element offset(<create account link>,3),"Left Click","No")

    type text(<first name field>,$account data("First Name"),"Standard")

    type text(<last name field>,$account data("Last Name"),"Standard")

    create table from file("C:\\Users\\triosi\\Documents\\UBot Studio\\data\\uk test.csv",&tableuk1)

    set(#row,0,"Global")

    loop($table total rows(&tableuk1)) {

        type text(<email field>,$table cell(&tableuk1,#row,0),"Standard")

        change dropdown(<country dropdown>,"United Kingdom")

        type text(<name="Phone">,$table cell(&tableuk1,#row,1),"Standard")

        change dropdown(<name="typeofCompany">,"Random")

        type text(<company field>,$account data("Last Name"),"Standard")

        click(<terms of service checkbox>,"Left Click","No")

        increment(#row)

    }

    wait(10)

    click(<create account button>,"Left Click","No")

    wait(30)

}

[Pete 121]

create table from file("C:\\Users\\triosi\\Documents\\UBot Studio\\data\\uk test.csv",&tableuk1)
set(#row,0,"Global")
loop($table total rows(&tableuk1)) {
    navigate("http://www.prnewswire.com/","Wait")
    wait for element(<id="mobile-menu-btn">,60,"Appear")
    click(<id="mobile-menu-btn">,"Left Click","No")
    wait for element(<innerhtml="Log in to Services">,60,"Appear")
    click(<innerhtml="Log in to Services">,"Left Click","No")
    wait for element(<innertext="Sign Up">,60,"Appear")
    click(<innertext="Sign Up">,"Left Click","No")
    wait for element(<first name field>,"60","Appear")
    reset account("Any")
    type text(<first name field>,$account data("First Name"),"Standard")
    type text(<last name field>,$account data("Last Name"),"Standard")
    type text(<email field>,$table cell(&tableuk1,#row,0),"Standard")
    change dropdown(<country dropdown>,"United Kingdom")
    type text(<name="Phone">,$table cell(&tableuk1,#row,1),"Standard")
    change dropdown(<name="typeofCompany">,"Random")
    type text(<company field>,$account data("Last Name"),"Standard")
    click(<terms of service checkbox>,"Left Click","No")
    wait for element(<create account button>,60,"Disappear")
    increment(#row)
    wait(10)
    click(<create account button>,"Left Click","No")
    wait(30)
}

no idea where you are saving these accounts

[amitbot 0]

hi zap.. sorry been off this forum for a while. you are right still havent added that code for saving the account info, i got this far and got stuck. i am now looking through tutorials on how to save the acc details