Jump to content
UBot Underground

flamerz

Members
  • Content Count

    12
  • Joined

  • Last visited

Posts posted by flamerz

  1. Hello, I'm just creating a blog post about reading some "big" csv file. Lets say, 100.000 lines, 2 columns, name and age.
     
    I wish to load the data and iterate/sum the age variable, just for documenting it.
     
    set(#total,0,"Global")
    set(#row,0,"Global")
    create table from file("C:\\Users\\Usuario\\Desktop\\names.csv",&dataTable)
    loop($table total rows(&dataTable)) {
        set(#total,$add(#total,$table cell(&dataTable,#row,1)),"Global")
        increment(#row)
    }
    
    
     
    This is my UBot code. My issue is, with 100k lines this goes a bit slow, maybe its not good idea to load it on a table.
     
    this is my mockup post:
     
    any guidance? my post is not a competition for speed, just a guide to read/iterate a csv file in a good way. I wish to have the data loaded and do not use a driver or a database query to do a SUM. Just a simple loop.
     
    thanks in advance.
     
    PD: names file attached.

     

    names.csv

  2. Just to clarify, the auto parameter starts the bot but the bot does not work as expected.

     

    My temporary solution is send

     

    Alt tab tab tab space to the bot window and activate the play button with an external macro.

  3. Same happens to me. I'm trying to click the play with winautomation because the /auto, onload, all don't work.

     

    I had partial success with JavaScript, but it's a pain to work with that auto playing from the ide while coding or retouching the bot.

×
×
  • Create New...