HomeSearchRegisterLog in
Registration DOES NOT need an email verification.
Welcome to the biggest MyBrute forum on the internet.
Look at the sections' stickies: you'll find there everything you need to know about the game!

Share
 

 BC databases to Excel

Go down 
Go to page : 1, 2  Next
AuthorMessage
Subman(R)
admin
admin
Subman(R)

Posts : 2213
Join date : 2009-07-17
Age : 60
Location : Florida

BC databases to Excel Empty
PostSubject: BC databases to Excel   BC databases to Excel Icon_minitimeMon 08 Feb 2010, 20:09

This is my method to retrieve brutes out of a DB and import into Excel. Other's may have different methods and maybe easier. Post them!

1-in the bc folder you wish to export from, just open the “brutal-combo.jar” file

2-When opened select “Fichier” tab and select “Exporter”. Pick the folder you wish to
save to and name it but with .txt in it. ie: name.txt.(you can close BC now)

3-Open Excel

4-Now select open file, and in the window navigate to the folder where the txt was saved. In the “File of Type” dropdown window” select
“Text” and the file will appear you made. Select the file





5-A import wizard will appear BC databases to Excel IPwizard

6-“Delimited” should already be selected. Click “Next”

7-Add a check to “Simicolon” click “Next”

8-click “Finish”

Now to Sort:

1-click on the “letter” u wish to sort and that will
highlight the column to sort.(ie; F for agile)

2-At the top in the “Data” tab select Sort, In the window select “sort” Then Sort By” click
Descending and then ok. Now let the hunt begin.

Tip: data is for level 80. For receiving a skill or weapon it is by level up to level 80. If the brute gains a skill or weapon after lvl 80 it will not be shown.

When you find a brute to look at; Copy the name in Column “A” and overwrite it onto another brutes
name in his cell and enter.

When done save as a xls file


This was done with Excel 2003. Your’s may difer.

_________________
BC databases to Excel Subsride


Last edited by Subman(R) on Sat 22 May 2010, 11:18; edited 4 times in total
Back to top Go down
http://submans.shutterfly.com/
xteenager
* * * * * * * * * * *
* * * * * * * * * * *
xteenager

Posts : 5988
Join date : 2009-09-11
Age : 27
Location : The couch

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeMon 08 Feb 2010, 20:47

thanks for the AMAZING tutorial, i didnt know how to expcept before this post by 24 hours lol!


i was taking already xml dbs to search in
Back to top Go down
http://xteenager.yolasite.com/
Sioc
admin
admin
Sioc

Posts : 2784
Join date : 2009-12-19

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeMon 08 Feb 2010, 20:50

Subman(R) wrote:

Other's may have different methods and maybe easier. Post them!

Well, about my method... I have written a small Excel (2003) tool that automatically imports the BC-export into Excel and automatically analyzes the data in order to show a scatter plot with promising brutes that are highlighted.
There are some other features as well to make the reviewing process a bit faster.

It turned out to be quite useful for me in order to search through large amounts of brutes...

The only problem is that I've not written a real instruction manual. If a few people here are interested I may write a small instruction manual and make the tool available... and I will need time to write an instruction manual.

Below you can find some screenshots.

Spoiler:
 

_________________
BC databases to Excel A11BC databases to Excel B13
BC databases to Excel C10


Last edited by Sioc on Fri 21 May 2010, 20:58; edited 2 times in total
Back to top Go down
Subman(R)
admin
admin
Subman(R)

Posts : 2213
Join date : 2009-07-17
Age : 60
Location : Florida

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeMon 08 Feb 2010, 20:55

Now I feel humbled. Nice work Soic!

_________________
BC databases to Excel Subsride
Back to top Go down
http://submans.shutterfly.com/
Ajdija
VIP
VIP
Ajdija

Posts : 547
Join date : 2009-08-19
Location : http://www.ajdija.com

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeMon 08 Feb 2010, 21:33

yep nice work :)

if you would public it I won't even try to create such thing in the future as I always needed it :)
Back to top Go down
http://www.ajdija.com
Sioc
admin
admin
Sioc

Posts : 2784
Join date : 2009-12-19

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeMon 08 Feb 2010, 21:36

Ok then. I'll try to write this instruction manual and release the tool. Will just need a bit of time.

_________________
BC databases to Excel A11BC databases to Excel B13
BC databases to Excel C10
Back to top Go down
Subman(R)
admin
admin
Subman(R)

Posts : 2213
Join date : 2009-07-17
Age : 60
Location : Florida

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeMon 08 Feb 2010, 21:42

And when he does publicize it. THANK him with some pupils.

_________________
BC databases to Excel Subsride
Back to top Go down
http://submans.shutterfly.com/
kenichiro
* * * * * * * *
* * * * * * * *
kenichiro

Posts : 431
Join date : 2009-05-23

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeTue 09 Feb 2010, 06:49

Wow. That's just cool. cheers
Back to top Go down
Sioc
admin
admin
Sioc

Posts : 2784
Join date : 2009-12-19

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeThu 11 Feb 2010, 08:04

Ok, here is finally the instruction manual and the Brutal Combo database analysis tool (link at the end of the message).

I tried to make the manual as comprehensive as possible in order to anticipate any question so that individual support shouldn't be required at all. Most likely if you carefully read the manual you will find the answer to all of your questions. The manual is too long for being displayed here in the post itself but it can instead be downloaded from the link as a pdf file.


LINK: zip file containing the PDF manual and the EXCEL database analysis tool: http://sioc.webs.com/MyBrute-ToolPack.zip
After you have opened that hyperlink, in order to download the file locate "Request download ticket" on the page and click it, then click on "Download".

Screenshots:
Spoiler:
 
Current versions:
- Brutal Combo database analysis tool: 1.02
- Instruction manual: 1.00



      EDIT:
      In case you want to search for any target level you may try the MyBrute Search Engine that was released after this.
      I strongly suggest to use the MyBrute Search Engine instead of this tool which is now obsolete.


_________________
BC databases to Excel A11BC databases to Excel B13
BC databases to Excel C10


Last edited by Sioc on Sun 22 Sep 2013, 15:08; edited 11 times in total
Back to top Go down
Subman(R)
admin
admin
Subman(R)

Posts : 2213
Join date : 2009-07-17
Age : 60
Location : Florida

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 12 Feb 2010, 18:17

I am playing with the tool I am impressed with it. But I still have lots to learn.

Love the feature of showing the cell of a promising brute.

I used your tool in an old db I have and had went through. I missed some GOOD brutes.

_________________
BC databases to Excel Subsride
Back to top Go down
http://submans.shutterfly.com/
nga-24
* * * *
* * * *
nga-24

Posts : 41
Join date : 2009-10-24

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 12 Feb 2010, 19:53

this is awesome, thanx a lot subman
Back to top Go down
Sioc
admin
admin
Sioc

Posts : 2784
Join date : 2009-12-19

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 12 Feb 2010, 20:36

Glad you like it Sub ;-)

_________________
BC databases to Excel A11BC databases to Excel B13
BC databases to Excel C10
Back to top Go down
Yaboirobby
* * * * * * * * * * *
* * * * * * * * * * *
Yaboirobby

Posts : 4322
Join date : 2009-05-21
Age : 24
Location : Atlanta, GA

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 12 Feb 2010, 20:42

Sioc wrote:
Glad you like it Sub ;-)
Just curious, but do you know how to make this tool work on a Mac?
Back to top Go down
http://mybrute-nomercy.webs.com/
Sioc
admin
admin
Sioc

Posts : 2784
Join date : 2009-12-19

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 12 Feb 2010, 20:48

Quote :

Just curious, but do you know how to make this tool work on a Mac?
Excel for Mac. And cross fingers Microsoft did a good job with Mac VBA compatibility ;-)
But for sure the part with Firefox won't work since Firefox won't be installed in c:\Program Files\Mozilla Firefox\ or c:\Program Files (x86)\Mozilla Firefox\ (moreover shell32.exe doesn't exist on mac, see the VBA code in the last section of the instruction manual).

_________________
BC databases to Excel A11BC databases to Excel B13
BC databases to Excel C10
Back to top Go down
Yaboirobby
* * * * * * * * * * *
* * * * * * * * * * *
Yaboirobby

Posts : 4322
Join date : 2009-05-21
Age : 24
Location : Atlanta, GA

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 12 Feb 2010, 21:01

Sioc wrote:
Quote :

Just curious, but do you know how to make this tool work on a Mac?
Excel for Mac. And cross fingers Microsoft did a good job with Mac VBA compatibility ;-)
But for sure the part with Firefox won't work since Firefox won't be installed in c:\Program Files\Mozilla Firefox\ or c:\Program Files (x86)\Mozilla Firefox\ (moreover shell32.exe doesn't exist on mac, see the VBA code in the last section of the instruction manual).
When I run it, and push import BC database, it says:

BC databases to Excel Pictur42
Back to top Go down
http://mybrute-nomercy.webs.com/
Sioc
admin
admin
Sioc

Posts : 2784
Join date : 2009-12-19

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 12 Feb 2010, 21:07

Lol, then you should ask Bill and Steve (or is it now Steve & Steve...?) to have a drink together in order to study this particular issue... ;-) ... just to say it won't work until Microsoft and Apple enhance the compatibility of their products. Nothing I can do.

_________________
BC databases to Excel A11BC databases to Excel B13
BC databases to Excel C10


Last edited by Sioc on Fri 12 Feb 2010, 21:10; edited 1 time in total
Back to top Go down
Yaboirobby
* * * * * * * * * * *
* * * * * * * * * * *
Yaboirobby

Posts : 4322
Join date : 2009-05-21
Age : 24
Location : Atlanta, GA

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 12 Feb 2010, 21:08

Sioc wrote:
Lol, then you should ask Bill and Steve (or is it now Steve & Steve...?) to have a drink together in order to study this particular issue... ;-) ... just to say it won't work until Microsoft and Aplpe enhance the compatibility of their products. Nothing I can do.
Ah, ok Laughing Thanks for the tool... will try it on my PC later i guess!
Back to top Go down
http://mybrute-nomercy.webs.com/
Sioc
admin
admin
Sioc

Posts : 2784
Join date : 2009-12-19

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeThu 25 Feb 2010, 20:45

Btw w13winni released yesterday a rather interesting BC database analysis tool on the French forum:

http://forumlabrute.forumactif.org/trucs-et-astuces-f26/labrute-search-engine-new-t10439.htm

One of the big advantage of this tool is that for the stat points analysis the target level is not set at 80 but it is a free parameter (and that's a real kick-ass feature).
For example, you can ask:
  • what are the brutes that have untouchable and implaccable before level 80?
  • out of these brutes, what are the brutes that have more than 150 agility at level 200?

Moreover it doesn't seem to have a restriction on the size of the database (no 65'000 rows limitation or such) and it is a plain executable (doesn't rely on M$ Excel for example).

However it has imo a few backdrafts as well:
  • you better have to understand French...,
  • it seems that the threshold level for abilities is still set at 80 (based on the BC export),
  • it can take just an enormous amount of time to do searches by stats (even if one starts from the restricted set obtained at first step),
  • it doesn't allow to look for filters on the sum of all stat points or the number of abilities,
  • it doesn't allow to do ranking-like searches like "what are the highest agility brutes that..." etc, but only threshold-like searches "what are the brutes with agility above..." (however refining searches should restrict to smaller found sets in order to easily do such a ranking),
  • it is seriously lacking a user friendly interface.


Anyway, the free target level parameter for the stat points is just a great feature.

_________________
BC databases to Excel A11BC databases to Excel B13
BC databases to Excel C10


Last edited by Sioc on Thu 25 Feb 2010, 21:01; edited 3 times in total
Back to top Go down
Subman(R)
admin
admin
Subman(R)

Posts : 2213
Join date : 2009-07-17
Age : 60
Location : Florida

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeThu 25 Feb 2010, 20:49

Looks like you did to register first to see it.

_________________
BC databases to Excel Subsride
Back to top Go down
http://submans.shutterfly.com/
Sioc
admin
admin
Sioc

Posts : 2784
Join date : 2009-12-19

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeThu 25 Feb 2010, 20:53

Oh yes. You have to register first on the French forum in order to see the threads.
Here is the direct download link (it may become obsolete if w13winni updates the link):
http://www.megaupload.com/?d=W0SXPEN7

_________________
BC databases to Excel A11BC databases to Excel B13
BC databases to Excel C10
Back to top Go down
GC.XVZ
* * * * * *
* * * * * *
GC.XVZ

Posts : 106
Join date : 2010-02-06
Age : 25
Location : UK

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeThu 25 Feb 2010, 21:42

Thanks For Sharing This Amazing Thing!
Back to top Go down
http://bugdarkbrute13.mybrute.com/cellule
w13winni
VIP
VIP
w13winni

Posts : 282
Join date : 2009-04-17

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 26 Feb 2010, 00:11

hmmm , now there is an english release^^
https://mybrute.forumotion.com/cheats-scripts-f13/labrute-search-engine-new-t7309.htm

Quote :

* it doesn't allow to look for filters on the sum of all stat points or the number of abilities
yes great idea,
in fact its just the first release , i'll add new features , if you have idea for new feature, post on my topic^^
Back to top Go down
Subman(R)
admin
admin
Subman(R)

Posts : 2213
Join date : 2009-07-17
Age : 60
Location : Florida

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 26 Feb 2010, 00:36

Went to the link but don't see a COM release or do I need better glasses?

_________________
BC databases to Excel Subsride
Back to top Go down
http://submans.shutterfly.com/
w13winni
VIP
VIP
w13winni

Posts : 282
Join date : 2009-04-17

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 26 Feb 2010, 00:42

Subman(R) wrote:
Went to the link but don't see a COM release or do I need better glasses?
yes you need^^

Downloads :
Labrute Search Engine v1.0 EN release : http://forumlabrute.netau.net/Labrute_Search_Engine_v1.0_EN.rar

if you want ill go replace "EN" by "COM"
Back to top Go down
Subman(R)
admin
admin
Subman(R)

Posts : 2213
Join date : 2009-07-17
Age : 60
Location : Florida

BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitimeFri 26 Feb 2010, 00:44

cheers lol!

_________________
BC databases to Excel Subsride
Back to top Go down
http://submans.shutterfly.com/
Sponsored content




BC databases to Excel Empty
PostSubject: Re: BC databases to Excel   BC databases to Excel Icon_minitime

Back to top Go down
 
BC databases to Excel
Back to top 
Page 1 of 2Go to page : 1, 2  Next

Permissions in this forum:You cannot reply to topics in this forum
My Brute Forum :: Guides & Info :: Cheats & Scripts-
Jump to: