When create the resource activate "delete after use"
Multi-threading Signup with Excel Data
-
I explored free version, and all seems good n I learned except one thing.
I am going to sign up a webpage with name, email and password.
I have these data in excel file.I need to read and fill details from that excel file. I am to do multi-threading of "10".
so, during that time each thread should use unique data from excel.How can I do it.
-
@sarankavalan You cannot use multithreading in Excel, only 1 thread
- You need to create an onapplication function
Find out more here from bablosoft https://teletype.in/@bablosoft/functions-in-BAS-en - In it, you need to “create a resource” action. In the action settings, there is a “simultaneous use” parameter. Set it to 999
- Read the Excel document with the “Read cell” action.
- Get the list that needs to be processed in a Foreach cycle. Be sure to set a delay in the loop using the “Sleep” action.
- Next, it is your task to fill in the data into the resource. Do this using actions 1) “Parse CSV” and 2) “Add element.”
- The result will be a filled resource that can be used in BAS logic as usual.
- You need to create an onapplication function
-
if excel cannot be used.
what is other way to process multi threading and for each thread using unique data without duplicate. -
the instruction above you said is bit confusing. for my purpose it is not mandatory to use excel.
I am ok to feed data in any form which is easy to deal. -
@sarankavalan You wrote to me to create logic with Excel, and I wrote to you.
It is best to use resources or the internal BAS database, but if you are a beginner, it is better to use conventional resources.
-
Multi threading is possible using resources. You have to put your data in a resource. This video can be actually pretty helpful: https://youtu.be/fLggFllTWws?si=9Z1s_Mip63GlLUW6
-
Thank you so much guys. I finally achieved it
