@GaG Thank you for your help. Till now i found my way to manage easy csv tasks , since csv files are just text with comma for change column, and new lines for change row i can deal this on BAS by creating lists from "Read File to List" and then i can break each list item from "Parse string" with comma as separator. Then i use "Write File" for saving and i can live visualize the edited results on the csv file with a program called "Modern CSV". Thing is that on more advanced scripts i have big CSV files with a lots of rows and columns , sometimes i must to constant return to BAS the index position of partial value search terms on those files. I have found also an alternative way to manage by creating and executing a bat file with call for python for converting csv to xlsx and then i may use "module Excel" that haves all the actions im looking for, but Im wondering why BAS haves those actions only for xslx files, why not for csv also? Anyways till now im very satisfied to BAS but i might need more help in the future on this matter.
Multi parse csv string
-
@to-nice said in Multi parse csv string:
Hello everyone, what is the fastest way to achieve this?
It depends on which database server you are using.
If you are using MariaDB, the fastest way to insert data into the database is by using the command LOAD DATA INFILE.
- Enable local_infile in my.cnf on your server:
[mysqld] local_infile=1- Sql:
LOAD DATA LOCAL INFILE '/path/to/your/file.csv' INTO TABLE your_cool_table FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES; -- Skips the header row if exists -
@sergerdn A quick question: with my other bot, when I have 100 accounts using the 'perfect fingerprint,' the bot completely freezes. Would using an external database help avoid this issue?
Wiki... I lost a post that explained how to set up threads on the graphical interface... Do you happen to have it handy? I remember it made a blue selection bar appear -
@to-nice said in Multi parse csv string:
@sergerdn A quick question: with my other bot, when I have 100 accounts using the 'perfect fingerprint,' the bot completely freezes. Would using an external database help avoid this issue?
I don't know.