@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.
Saving data to file or database after script completes
-
So I am making a script to visit a site and register an account and then save that account info into one file.
I need the bot to save the username:password in that format and each new username and password should write to a new line in the same file.
Problem is I cannot figure out how to set this up to save the info into one file without the bot creating a new file for each entry. Need help
Is the solution to use the database? If so how do i get the script to enter the registered username:password after the script successfully runs
-
Hey @cleez
Create a new database, a new table "Accounts". Add column, Username & Password.
Save & Restart the script, inside the recorder use the Database functions "Insert" Select "Accounts" for the table and put the new Username & password inside there.You can also use Results which are located in the scripts directory\appslocal\logs{RESULT_NAME}\Time_Stamped.txt
& it's viewed inside the bot on the tab next to "Logs".
Recorder command is Tools> Result. You can edit these by "stopping" the recorder & down at the bottom to the right/left of the "log" tab. Change Title & checkbox "Visible".If you have your own file you can use the Write List To File command inside "Filesystem" on the recorder. Make sure you check "Append"
Let me know if this helps!
Allister ☯
-
-
Sure can, if you're using Database Resource, Edit it and check "Mix Lines". Make sure you set the setting accordingly if you want to re-use the lines. if you're using Select Records Command via the script, you can use [cate]List ---> Random Element command using the Select Record Variable (pre-set: [[RECORD_LIST]]).
Allister ☯
