Bablosoft

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

What is the quickest way to extract data from a single column on Database ?

Support

1 Posts 1 Posters 490 Views

P Offline

P Offline
ptt.bds
wrote on last edited by

#1

Main/Database/Select Records By Criteria
I use this method to retrieve data from the Database; however, the list I receive is in the format column1:column2:column3:column4...
What is the quickest way to extract data from a single column?
I have tried the Main/String/Parse CSV string tool, but it takes a long time to process with a large amount of data.
1 Reply Last reply
0

P

using the same data and order across threads.
Scheduled Pinned Locked Moved Support

0 Votes

4 Posts

743 Views

P

@SuperMario I have no idea how to do this. Could you please send me a sample file?

"Get the list by thread number." I don't quite understand how to do this?
H

How to split a list data to multiple thread ?
Scheduled Pinned Locked Moved Support

0 Votes

2 Posts

595 Views

K

First, you have to use "{{BrowserThread}}" variable and "Element Number" command. So you can create a new variable where "[[SUBLIST_LENGTH]]" can be calculate by ([[MAIN_LIST_LENGTH]]/{{BrowserThreads}}). Lets say, you have list contains 10,000 URLs and you want to run 5 browsers threads. So "[[SUBLIST_LENGTH]]" will be (10000/5)= 2000 (check screenshot_1)

Now, you can split your MAIN_LIST in using built in variable "[[Thread Index]]" and "SUBLIST" command. (check screenshot_2)

screenshot_2.png screenshot_1.png
H

Search the whole of database table for a string
Scheduled Pinned Locked Moved Support

0 Votes

2 Posts

742 Views

F

@HELP_ME said in Search the whole of database table for a string:

Hi, I have seen this https://community.bablosoft.com/topic/3750/how-to-avoid-duplicates-in-database/3
and want to know if its possible to search the whole of the database table for a string.

I have tried what the OP has tried, list functions such as get index and list contains aren't working as expected, it doesn't let you search the whole database for a string(it returns false / no result) nor select records by criteria.

Use the filter in the "Select Records By Criteria" action
a368082a-159a-418d-899e-adecf8b1887d-изображение.png

892282f3-a72a-444a-aa5a-4b17b110f873-изображение.png
R

Best way to implement this bot?
Scheduled Pinned Locked Moved Support

0 Votes

4 Posts

1598 Views

A

@rokiroki I would use a while loop and compare the current date with the time it should run (VAR_RUNAT = current + 2 hours) WHILE (currenttime < VAR_RUNAT) sleep(1000)! , or a for and compare the index with sleep. I.e i < 5 sleep(60000)! Would sleep 5 minutes.
Y

I got mysql output from database using node and tutorial in manual. Cant change it to bas variable
Scheduled Pinned Locked Moved Support

0 Votes

1 Posts

1144 Views

No one has replied

Bablosoft

What is the quickest way to extract data from a single column on Database ?

using the same data and order across threads.

How to split a list data to multiple thread ?

Search the whole of database table for a string

Best way to implement this bot?

I got mysql output from database using node and tutorial in manual. Cant change it to bas variable