New feature: see the parts you own

Huw

A feature that's been requested many times over the years is to be able to see the parts you own based on the sets you own, much like you can with minifigs.

Just before I went away in December I wrote code to do just this and today I've uploaded it to the server.

Because of the potential for the feature to generate millions of rows of data and slow down parts searches slightly it's not enabled by default.  You'll need to go to http://brickset.com/profile/preferences and tick the box under 'your parts collection'.

Once you've done that you'll need to log off and on again, or close your browser and restart it, for the data to be collated.

Given our inventory data comes from LEGO.com and it's often inaccurate and incomplete, the data generated by this feature is not going to be totally accurate either. Also, the issue of seemingly identical parts having different LEGO item numbers will confuse things, too.

That said, it is what it is and you may find it useful. I'm not going to announce it on the home page to prevent hundreds of people all enabling it at once which might have a detrimental impact on the database.

Please give it a go and LMKWYT. In particular,

- Is the load time of the first page you view when you start a session at Brickset acceptable? (That's when the data is collated)
- Are load times of inventory/parts pages acceptable?

I might add 'I own xx loose' and 'I want xx' checkboxes in due course.

BooTheMightyHamster

Hi Huw,

I've updated my preferences, saved them, then logged out (of Brickset, not the forum), closed the browser and fired it all up again.

No noticeable delay, but to be honest, I'm not sure where I'm supposed to be looking to see the parts info.  The closest I can see is the 'Number of pieces' under the 'My sets' tab, but I'm pretty sure that was already there.

Is it an additional search term in the database query tool, or am I just being a bit dim and I'm missing something obvious?

My money's on the latter... 

Cheers!  (And thanks for adding the feature - probably more 'interesting' than 'useful' for most people, but nice to have the option).

Huw

In the database I can see you've enabled the feature and 3566 rows have been created in the appropriate table.

On the parts tab of this page http://brickset.com/sets/75125-1/Resistance-X-wing-Fighter you should see green boxes under the parts you own

On this page http://brickset.com/inventories/75125-1 you should see a column 'owned'

On this page http://brickset.com/parts/4609050 you should see  a your collection box in the sidebar

On this page you should see a 'my collection' drop down http://brickset.com/parts/category-System-Figure-Weapons

If not I've missed something!

BooTheMightyHamster

Aha!  My fault!

Yep - that all works - thanks Huw.  The final link (system figure weapons) took 5 or 6 seconds to load, but everything else was sub-second.

Cheers!

Huw

Good :-)

Paperballpark

Ooooh...

I think you've just opened a can of worms @Huw! I can envisage requests to be able to add loose parts and keep track of them (ACM-style), people wanting to add parts they've bought via the PAB wall, etc. etc.

It's a nice function though, and I can see it being useful too. :)

EDIT: just a thought, but looking at the numbers below the individual parts on a set page almost makes the Rebrickable integration superfluous. Not that I'm complaining, as I don't use that feature.

Huw

Adding  'I own/want' checkboxes and numbers is easy enough, in fact half the code is in place already, I thought I'd see how this landed first and whether the limitations of it generates too much criticism.

drdavewatford

Having enabled this feature via "my preferences" earlier today I'm not seeing any related data on any screen. What am I missing here....?

Huw

Even after restarting your browser?

You should do, the data for your collection is in the table and the flag is set in your profile.

I've just logged in as you to test and can see the green boxes in question OK.

adiemc

@Huw I've enabled it and it works fine. Very nice feature thank you.  

Whilst testing it I noticed I own 89 brick separators! 

drdavewatford

Huw said:

Even after restarting your browser?

You should do, the data for your collection is in the table and the flag is set in your profile.

I've just logged in as you to test and can see the green boxes in question OK.

Now visible - thanks!

Urgh - 261 orange brick separators. No wonder they seem to be everywhere I look....

Paperballpark

I 'only' own 30 of the orange ones. It feels like more than that...

I wouldn't mind them in different colours... Red, blue, pink, purple, bright yellowish orange...

BeardedCastleGuy

Neat!  I like this.
Now a question, it seems that this only shows data for sets with lego.com inventories, it doesn't appear to show any for rebrickable.com inventories.  Intended behavior or just a limitation of the way the data was collected (or entered, stored,  whatever)?
Just curious is all.

playwell

Thanks @Huw sounds great, I too will use it to find out how many brick separators I have.

Bumblepants

81 orange separators and 3 green! I knew I had a lot but that is a lot.

Recce

Nice feature!

Huw

@BeardedCastleGuy, we don't hold Rebrickable's data locally, it would be wrong to do so to duplicate a feature available there, so yes, we just use LEGO.com's inventories.

playwell

Bumblepants said:

81 orange separators and 3 green! I knew I had a lot but that is a lot.

Snap we have a match 81 brick separators.

Now @Huw we just need a drop down for quantity you own so that we can order the parts by what we have most of.

Also this is bad for my ocd as now I know I should have 81 brick separators I will need to count them to make sure I do have 81 brick separators.