Separate datas

I want to separate data bases but some old pupils have no password, some are mixed with wasusuge brutes, some are with the same password, etc... I have datas 1.2, 1.3, 1.4...

someone knows how can I separate all? I have 10 datas maybe some pupils are repeat in more than 1 data

You can have a look in section "That way you can as well clean BC 1.3+ databases:" of the topic https://mybrute.forumotion.com/t10032-com-fr-es-de-browser-pupilling-script-com-fr-es-de-server-free-bc-trainer

Did it for several databases with total amount of about 400'000 pupils. Painful but you have definitely all required flexibility.

I have a db service ...........................

I tried mybrute list manager time ago but the program freeze and doesn't respond

Download the latest version (there were quite a lot of updates recently - current version is 1.4.3).
It may sometimes look like frozen but it shouldn't be the case (at least I have used it to download about 1 million IDs on all servers combined and it didn't freeze).
You may eventually have to decrease the number of threads for the download in order to increase stability if you have a fast internet connection (menu "Tool" -> "Number of threads").

Thanks Sioc, I prove this but I don't understand the out file, I can't see the masters ¿?

hiei435017;98793;;2996;
hiei789244;77384;;1934;
hiei869668;439162;;1652;
hiei21273;989311;;1496;
hiei381412;595843;;1334;
hiei703288;926753;;1328;
hiei214670;276063;;1316;
hiei273211;954810;;1280;
hiei269880;264144;;1256;
hiei5976222961;706242;;1238;


and what is spreadsheet tool?

I think I have mixed pupils in all servers and that program only can read one server at time

flipflip wrote:

I think I have mixed pupils in all servers and that program only can read one server at time

Yes.
Make 4 copy of your file, run it on each server, and erase the entries where there is no ID (i.e. second column is empty, i.e. you have "bruteName;;....", i.e. after the brute name you have two consecutive ; ).

Running the List Manager on your file for DE gives:

hiei435017;98793;vilker71;6;
hiei789244;77384;vilker71;3;
hiei869668;439162;ff-ceszbxzx;6;
hiei21273;989311;ff-ceszbxzx;3;
hiei381412;595843;vilker71;3;
hiei703288;926753;ff-ceszbxzx;6;
hiei214670;276063;vilker71;3;
hiei273211;954810;ff-ceszbxzx;4;
hiei269880;264144;ff-ceszbxzx;5;
hiei5976222961;706242;ff-ceszbxzx;4;

which means

pupil_name;ID_of_pupil_name;Master_name;level_of_pupil;

You can then directly browse your list using the myBrute Search Engine, or do all kind of sorting / splitting by Master etc using Excel of OpenOffice.

I don't want to search any brute only delete all the pupils who aren't mine. Then I have to run the Mybrute list manager 4 times for each data?

If you have pupils on each of the 4 servers, yes :-)
Why? Most people know for which server are their pupils, and running the List Manager automatically on 4 servers would have 1) slowed it down by 4 times 2) produced potentially incorrect results due to brutes with same name existing on more than one server.

Uff I have brutes in all 4 servers :pale:

But when I delete all pupils who I don't want, how can I insert pupils in a data? the password of the brutes is missed! :S

Passwords can be retrieved from a Squirel export and a joint on the pupil name. Please look here for hints on how to do it: https://mybrute.forumotion.com/t10032-com-fr-es-de-browser-pupilling-script-com-fr-es-de-server-free-bc-trainer , or use xteen's DB service if can't figure it out.

Well, I try to retrieve passwords with squirrel but with squirrel you haven't the name of pupils, the only reference is the ID and only by the ID I don't know how to put the password to my pupils, it's very messy... see this:

https://2img.net/h/oi56.tinypic.com/1440mdg.jpg

And sorry but I prefer do it for myself because will be impossible for me to know if xteen will do a good job with my pupils or not :S

I see you are using Excel. You can therefore make a joint on the two lists using VLOOKUP worksheet function.
More precisely, in column 5 you can type in the following formula:

Code:

=VLOOKUP(RC2;C8:C10;3;FALSE)

However be careful in case you have several brutes with same ID: this method will not give the correct result. You will have to check these brutes manually in case the passwords may differ. You may therefore use the following formula in column 5 in order to make a joint if and only if the ID is unique and if it is found in the Squirrel export:

Code:

=IF(ISERROR(VLOOKUP(RC2;C8:C10;3;FALSE));"Not found in Squirrel export";IF(COUNTIF(C2;RC2)>1;"Multiple Ids";VLOOKUP(RC2;C8:C10;3;FALSE)))

Sioc wrote:

I see you are using Excel. You can therefore make a joint on the two lists using VLOOKUP worksheet function.
More precisely, in column 5 you can type in the following formula:

Code:

=VLOOKUP(RC2;C8:C10;3;FALSE)

However be careful in case you have several brutes with same ID: this method will not give the correct result. You will have to check these brutes manually in case the passwords may differ. You may therefore use the following formula in column 5 in order to make a joint if and only if the ID is unique and if it is found in the Squirrel export:

Code:

=IF(ISERROR(VLOOKUP(RC2;C8:C10;3;FALSE));"Not found in Squirrel export";IF(COUNTIF(C2;RC2)>1;"Multiple Ids";VLOOKUP(RC2;C8:C10;3;FALSE)))

Thanks you very much Sioc, I will prove this, I was looking for the right formula

Edit: shit I dind't remember I use spanish formulas

flipflip wrote:

Edit: shit I dind't remember I use spanish formulas

Google is your friend: translation of Excel functions (all languages), or here (Spanish only).

Thanks Sioc, a bit difficult but I did it! :)