PlaymoFriends

General => Report & Review => Topic started by: GrahamB on June 27, 2016, 19:39:43

Title: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on June 27, 2016, 19:39:43
Here is one I have made on an Excel Spreadsheet. All sets (https://dl.dropboxusercontent.com/u/61286767/All%20sets.xlsx)

(I can make this available in other formats, just ask! I have colour coded the background or text in some cells, but this colour information may not be saved in other formats).

Why did I do this? I found no one source of information on PM sets to be totally comprehensive. I also wanted  to be able to sort and filter the information and search for words in the set titles, so a spreadsheet seemed a good idea. (If you want some tips on sorting, filtering and searching, see below!). It's a useful  way of keeping track of sets we have too (a tick list!)

I collected data from several sources and cross-referenced. I have (so far) only included 4-digit set numbers (4972 sets) and unless they appear in PlaymoDB, I have not included GIG, BASA, Antex, Kenbrite, Lyra, Japanese, Canadian, Korean, Marx-Toys, or Schaper sets (pages 359-491 of Collector). I did include all 'Export sets', many Spanish sets (35 out of 91 sets) and all Mattel and Playmobil (USA) sets.

I used the following sources:

1.   www.playmoDB.org (for set names, themes, set numbers, klickies per set)

2.   Collector 3rd edition (for many release dates, set versions; I have also given page numbers for all sets on pages 18-358, 492-540 and 550-2)

3.   Datenbank-Setinhalt mit Inhaltsverzeichnis at  http://www.klickywelt.de/viewtopic.php?f=11&t=48354&sid=d4ef1bcbea20513954b2c305f9a0562c (http://www.klickywelt.de/viewtopic.php?f=11&t=48354&sid=d4ef1bcbea20513954b2c305f9a0562c) (Photos of set contents of many pre-1990 and a few post-1990 sets, some set contents still sealed in original bags, some sets show box pictures only)

4.   www.playmobil.de (Produkt-Arkiv, Building Instructions pdfs available)

5.   www.klickypedia .com

6.   Searches of PF and klickywelt topics

7.   Google searches

I also made a list of all unused set numbers (currently 1,339) in the ranges 3000-7999 and 9000-9999. There are 291 numbers used for more than one set.

There are no links to web pages in this spreadsheet, so it will not update automatically, but I have a system (manual, time-consuming!) to check when Heather adds sets to PlaymoDB, or changes the Theme to which a set is allocated (but I will probably miss changes to set names). I also used Heather's frequent updates in the PF topic  pdfs online at playmobil.com (http://www.playmofriends.com/forum/index.php?topic=14137.180) to check on new pdfs becoming available. (Unfortunately my total for pdfs does not quite tally with Heather's).

Any corrections to data will be gratefully received. Please feel free to make use of this data elsewhere.

The data in a few columns is not yet complete (column title in red text), such as whether the klickies in a set have freely-rotatable wrists or (as in most pre-1982 sets) fixed wrists. I did not include the 'Focus' which Heather has ascribed to each set in PlaymoDB, which some might have found useful.

Some more notes, relating to each column in the spreadsheet are in the second tab of the sheet. Other tabs show analysis of themes, year of release, klickies per set, etc.
 
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on June 27, 2016, 19:43:55
Sort, Filter and Find in an Excel Spreadsheet.

I am sure similar procedures apply in other spreadsheet programs.

'Sort' means 'rearrange how the rows of data appear on the screen.'

For example, the data is currently arranged in order of set number. If you wanted it arranged in order of something else (e.g. year of release), follow these steps:
1.   Highlight all the rows you want to rearrange as follows:
    a.   click on the row numbers at the left hand side, starting with row 4
    b.   drag to highlight all rows down to row 5416- it takes a little while!
2.   Click on the 'Data' tab, then click on the 'Sort' option, then
    a.   select Column I in the drop-down list in the 'Sort by' box, then
    b.   click on OK.
3.   You can choose a second column as a subsidiary sort. For example, with 'Release date' (column I) as the primary sort criterion, you might choose 'Set number' (Column A) to put the sets in set number order within each year (this is the way in which Collector sorts sets, for example).

(Those familiar with spreadsheets may use a 'header row' as the basis of sorting, but in this spreadsheet there are 3 header rows, so that method would be possible only by deleting 2 rows, perhaps rows 1 and 3).

If you are not careful about what cells have been marked prior to sorting, Sort can really mess up a spreadsheet, so I seldom use it. A much better command is Filter...

'Filter' means 'hide certain rows so you only see the ones you are interested in'.

Filtering rarely messes up the spreadsheet data. You can filter one column or several. It is probably best to make all columns filterable to start with:
1.   Click in the extreme top left corner of the spreadsheet (above the 1 and to the left of the A) to mark all the cells in the spreadsheet
2.   Click on Filter in the Data tab. A small white arrow appears at the top of each column. (the view of the spreadsheet often jumps to the right, so scroll horizontally using the slider at the bottom right, back to the columns you are interested in)
3.   Decide what you are interested in (e.g. Theme, column E), then
   a.   click on the arrow at the top of that column,
   b.   uncheck 'Select all' at the top of the list, then
   c.   click anything you are interested in, e.g. 'Leisure' and 'Freetime'.
   d.   Click OK and the software hides all rows except those with Leisure or Freetime in column E. It also hides the column headings (rows 1, 2, 3), which can be inconvenient. To avoid this, click on the arrow again and click on the column heading in the list - 'Theme in PlaymoDB' in this case. Click on OK. All column headings will now be shown

Of course you can do the same thing on PlaymoDB ('Choose from all themes' on Home Page, or 'Show sets by theme' on any other page, select Leisure and Freetime, click List Sets) and you get set pictures too!

But with spreadsheet filters, you can filter several columns at once, so if you wanted 'Police sets issued in 1983 or earlier, with 5 or more klickies', you filter columns E (choose Police), column I (choose each year 1974, 1974.5, 1975... to 1983) and column M (choose 5 and 7 klickies- there are no sets with 6 klickies and the other two ctiteria) .. and you get 5 sets. Want to see pictures of them? Copy the block of 5 cells in column B (which have PlaymoDB set numbers) and paste the selection into the box at http://www.playmodb.org/cgi-bin/your_set_list.pl (http://www.playmodb.org/cgi-bin/your_set_list.pl), click on Submit and the set pictures are displayed.


Find

If you are looking for a specific set but can only remember part of the name, this can be very useful. For example, to find the 'Merry Men's Feast' set, searching for 'Merry' gives four hits

In the 'Home' tab, click on 'Find' at the right hand side, or a quicker way is to hold the control (CTRL) key and type F.

In the box which appears, type in the search item (e.g. a set number, part of a set name, etc.) and click on 'Find Next'. The view of the spreadsheet will jump to a cell containing that search term. If it isn't exactly what you are looking for, click on 'Find Next' again.

You can also click on 'Find all' and you get a list at the bottom of the box showing all occurrences of your search term. Click on the one you want and the view will jump to that entry.

(If you get the message 'Microsoft Excel cannot find the data you are searching for', click OK and then make sure you have not inadvertently selected a small group of cells (if so, click on any single cell and try again). Or, turn off any filters (click on 'Filter' in the 'Data' tab). Then try the 'Find' action again.)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: Macruran on June 28, 2016, 01:28:49
GrahamB this is incredible. I cannot thank you enough.

 :woohoo: :banana: :apple: :thanks:
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: cheng on June 28, 2016, 07:49:12
a work of love, thanks for sharing GrahamB, I'm sure it will be very useful, thank you for letting me save a copy :)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: Raven on June 28, 2016, 11:37:29
This is wonderful!   :)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: tigana123 on June 28, 2016, 12:19:38
This is very helpful...

Thank you
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: cheng on June 28, 2016, 14:29:09
het GrahamB,
sometimes when a plan has 2 numbers e.g.7619/7683, we should just save it twice under the second number as well, right?
and is it possible that sometimes playmobil.de removes a plan for some reasons? e.g. I can't find 3038/3050/3057  :P
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: Daniela on June 28, 2016, 17:11:52
WOW, thanks Graham, thatīs amazing!  :love:
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on June 28, 2016, 17:18:51
Thanks for your comments!

Cheng, the column showing PDFs of building plans shows all the numbers I got a result for at www.playmobil.co.uk (I think the other playmobil sites, .de, .com, etc. show the same results). 7683 doesn't give a result, although it is covered by the 7619 instructions. For now, I will enter "see 7619" on the row for 7683, to indicate that you have to look up 7619 to get the 7683 instructions (if you follow me...) I had already done this for a couple of other sets and doing this for all sets which share instructions would certainly be possible, but I don't have a list of such sets, so that would need some more research....

You are correct - 3038, 3050 and 3057 don't have PDFs available. Maybe I put these in by mistake, or maybe the PDFs have been removed from the website, I don't know. I will take them off the list. My total of PDFs now comes to 2253, while Heather's comes to 2246, so there are probably another 7 sets I have entered in error or whose PDFs have been removed. Let me know if you find them!
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on June 28, 2016, 18:25:47
some more research....

So, I checked the 209 sets listed as 'USA' in the market column (quite a few US sets were equivalent to sets issued elsewhere with a different number) on PlaymoDB and found about 40 with equivalents, but nearly all of these had 'working' pdf numbers for both sets (if you enter either number at playmobil.co.uk, you get the instructions for both sets). I found only 4 where this didn't work, so I entered 'see ----').

If anyone finds any more errors or has any more suggestions, let me know!

Updated spreadsheet available  here, All sets V2 (https://dl.dropboxusercontent.com/u/61286767/All%20sets%20V2.xlsx)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: Birdie on June 29, 2016, 07:40:25
 :o  :o  :o

Amazing!

Thanks a ton  8-)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: sbblabotw on July 02, 2016, 01:25:35
Graham, you're being phenomenal again. What a treasure!

Here's some info that looks like it'd be helpful, from a preliminary read-through:

There are official PDFs available for direct download, that don't come up when you search for them in the Building Instructions dialog. They are not included in my posted count of PDFs available, because they're not readily identifiable and so the total number of PDFs would be confusing. However, by elimination, here are the sets with stealth PDFs:
PlaymoDB List - PDFs available but not searchable (http://playmodb.org/cgi-bin/your_set_list.pl?setlist=3285,3286,3367,3761,3826,3827,4438,5359,5648,5674,5675,5683,5762,6254,7423,7498;title=PDFs%20available%20but%20not%20searchable).

I keep track of sets that have no instructions, by assigning them the fake part i0000 (Instructions Do Not Exist). It appears in 679 sets in the DB. Now, some of these are assumptions (e.g. specials, eggs) but a fair number are based on someone telling me or posting a photo of the full contents of a freshly opened set. Here's the link to the fake part, and the longest list of "sets containing this part" ever. http://playmodb.org/cgi-bin/showpart.pl?partnum=i0000 (http://playmodb.org/cgi-bin/showpart.pl?partnum=i0000)

Some error-checking...

The missing PDFs: 3038, 3050 and 3057 have never had any individual instructions of their own, in my knowledge.
3038 - Formula 1 Car (http://playmodb.org/cgi-bin/showinv.pl?setnum=3038) is probably equivalent to 3603 - Formula 1 Racing Car (Yellow) (http://playmodb.org/cgi-bin/showinv.pl?setnum=3603), which does have an official PDF.
3050 - Pirate Ship (http://playmodb.org/cgi-bin/showinv.pl?setnum=3050) is probably equivalent to 3550 - Brigantine (http://playmodb.org/cgi-bin/showinv.pl?setnum=3550), which has instructions but not an official PDF.
3057 - U.S. Artillery (http://playmodb.org/cgi-bin/showinv.pl?setnum=3057) and 3812 - U.S. Artillery (http://playmodb.org/cgi-bin/showinv.pl?setnum=3812) share an instruction sheet, labeled with both numbers although 3057 is denoted as "USA/CDN". No official PDF.

9605, 9607, 9608, 9728 (http://playmodb.org/cgi-bin/your_set_list.pl?setlist=9605,9607,9608,9728)  have always been part of the DB. 4930 - Boy with Tractor (http://playmodb.org/cgi-bin/showinv.pl?set=4930) is a recent addition - you have its theme in PlaymoDB but haven't removed the "not in DB" label.

Now, to add those 158 sets not in the DB and totally mess up Graham's system :) Thanks so much for finding them!
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on July 02, 2016, 08:02:32
Thanks for that, Heather, very helpful. I will check and update shortly.

Some of those 158 'not in DB' sets are found only in Collector. I am sure that is a reliable source of information, though it would be nice to know on what authority it is based (collective wisdom of collectors would be good enough for me, Geobra archives even better!)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on July 02, 2016, 10:23:01
The pdf total in the spreadsheet now comes to 2246, the same total as in the PF topic. But this includes three 'broken links': 3252, 5379 and 5671 all give the result '1 building instruction(s) found' but no PDF. In any case, 5671 does not exist as a set (not yet anyway). I changed the entries for sets with stealth PDFs to 'exist'. I am hoping all the sets where plans are known to exist will eventually appear as PDFs online.

9605, 9607, 9608, 9728 were double- entered, now removed. Duplicate set numbers now stands at 287.

4930 corrected. It's now 159 sets not in the DB (I found another error). I look forward to new additions to the DB, Heather! I have a system for checking additions (using sets-per-theme totals) but I will hang on a bit to do this.

All sets Version 3  here  (https://dl.dropboxusercontent.com/u/61286767/All%20sets%20V3.xlsx)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: Indianna on July 03, 2016, 15:14:57
Another tour de force, Graham!   :hatoff: 
Thank you for sharing your work with all of us!   :*)

Title: Re: Do you need a complete list of all Playmobil sets?
Post by: tahra on July 03, 2016, 16:28:39
Thanks :)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: sbblabotw on July 03, 2016, 23:36:42
...
 It's now 159 sets not in the DB (I found another error). I look forward to new additions to the DB, Heather!

New sets added!

PlaymoDB List - New Sets Added via GrahamB (http://playmodb.org/cgi-bin/your_set_list.pl?setlist=3045,3071,3101,3103,3104,3106,3108,3109,3122,3124y,3125y,3126x,3127x,3128x,3129,3130y,3131x,3131y,3132x,3132y,3133x,3135y,3136x,3137x,3153x,3154x,3158x,3163x,3165x,3166x,3167x,3168x,3169x,3173x,3175x,3176x,3177x,3180x,3181x,3182x,3183x,3184x,3185x,3186x,3188x,3190x,3191x,3192x,3193x,3194x,3211y,3212x,3213y,3214y,3220x,3221,3222x,3230x,3240x,3256y,3264x,3266y,3268x,3269y,3273x,3274x,3276x,3277x,3281y,3282x,3283x,3284x,3285x,3286x,3287x,3288x,3289x,3333x,3700,3702,3833x,3901x,3902,3918,3920,3921,3922,3923,3962,3963,3975,3999,4003,4030,4031,4935,5851,5852,5853,5862,5866,5867,6177,6188,7652,7653,7684,7685,7814,7815,7819,7820,7821,7822,7823,7824,7830,7850,7939,9001,9002,9003,9004,9300,9402,9501,9502,9503,9504,9509,9510,9511,9512,9513,9514,9515,9517,9518,9602,9604,9609,9730,9731,9732,9733,9743,9746,9748,9749,9751,9752,9762,9763,9766,9768,9805,9898,9950,9951;title=New%20Sets%20Added%20via%20GrahamB)

I'm dubious about the sets with nothing but a number (and a re-used one at that), and a year, but put them in anyway. Next: pictures needed. None of these have pictures, and there's another hundred or so besides. I don't want to take them from the Collector or Klickypedia, but any source with permission, or directly from a Playmobil source, is fine with me.

Quote
I have a system for checking additions (using sets-per-theme totals)

How about I make that a bit easier? PlaymoDB Theme Summary (http://playmodb.org/cgi-bin/theme_summary.pl)

Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on July 04, 2016, 08:37:35
Great work Heather! The DB is now just 4 sets short of the 5000 mark! That list of total sets per theme will be VERY useful, thank you.

There are box pictures of just 5 of those newly added sets in Datenbank-Setinhalt at Klickywelt. Some of the other older sets with missing pictures (do you have a list, Heather?) might be in there too. I am happy to ask the Klickywelt members who contributed box pictures if they will share them with PlaymoDB. I think the resolution of pictures on Klickywelt would be good enough so the owners would not even have to send you an image.

I could also ask ebay sellers for permission to use their pictures if any of the sets show up there (payback for sellers linking to DB images in the past?).

Failing that, an appeal for box pictures on here and on Klickywelt (and other forums) might yield results.
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: sbblabotw on July 04, 2016, 16:50:15
If you could coordinate an appeal for photos, Graham, that'd be fantastic. I'll make a list. I did find a catalogue of those 31xx Kindergarten sets and added those photos; I also put in the direct links to the Datenbank-Setinhalt for the new sets that appear there. we'll chip away at it.
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on July 04, 2016, 17:43:17
OK, I will do that once I have the list.

I have updated my spreadsheet and added all the 'sets formerly known as "not in DB"' (there are none now) as well as 9015 and 9124.

Version 4 here (https://dl.dropboxusercontent.com/u/61286767/All%20sets%20V4.xlsx)

Total 4996 sets in PlaymoDB,
       4970 'occupied' rows in the spreadsheet (the difference is due to the fact that I have not given a separate row to each version of a set- except in two cases- whereas the DB has 26 more set-versions each with their own entry).

1337 unused numbers, 287 numbers used more than once (someone should have planned ahead!)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on September 24, 2016, 18:23:57
I have updated the All Sets spreadsheet with recent releases/ updates on PlaymoDB: All Sets Version 5 (https://dl.dropboxusercontent.com/u/61286767/All%20sets%20V5.xlsx)

Total 5027 sets including 28 significant extra versions of sets

1309 unused set numbers

2317 Building Plans on Playmobil website
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on April 25, 2017, 18:42:28
Another update. This one includes details of set versions. here (https://www.dropbox.com/s/fcjrlrw79erpqcf/All%20sets%2021April2017.xlsx?dl=0)

Total 5196 sets, 1104 unused set numbers, 2431 pdfs available at playmobil websites (plus 88 'stealth pdfs' with links from PlaymoDB)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: Knight Train on April 27, 2017, 17:48:36
This is really great.  Thank you for putting this together!!
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: tahra on April 27, 2017, 20:46:42
Thank you :)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: marb2777 on April 27, 2017, 21:41:04
Thank you    :)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: marinebaer on May 09, 2017, 15:51:03
Graham, Thank You very much!

 :thanks:
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: tigana123 on May 22, 2018, 12:23:03
I wonder if there is a new version of this valuable file  ;D
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on May 24, 2018, 07:41:44
As luck would have it, I recently updated the file, Tigana 123!
I have not included the 2018 DS sets yet (Heather has not allocated names or themes on PlaymoDB yet, these sets appear in the theme '(new)'.
Let me know if the link below doesn't work.
https://www.dropbox.com/s/l357o7oetcz0zks/All%20sets%2014May2018.xlsx?dl=0 (https://www.dropbox.com/s/l357o7oetcz0zks/All%20sets%2014May2018.xlsx?dl=0)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: Klickteryx on May 24, 2018, 08:38:52
I feel there should be some sort of advisory with this.

Attention, this is for educational purposes only.
This is not intended as a shopping list.
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: tigana123 on May 24, 2018, 23:07:05
Thank you so much Graham  ;D

This is also useful to keep track one's collection !
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on May 25, 2018, 07:48:26
This is not intended as a shopping list.

 :lol: :lol: :o

This is also useful to keep track one's collection !

That is one way I use it, too!
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: tahra on May 25, 2018, 08:09:41
Thank you, GrahamB!

I feel there should be some sort of advisory with this.

Attention, this is for educational purposes only.
This is not intended as a shopping list.

:lmao: :lmao:
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on June 18, 2020, 16:51:50
Latest update, today. Includes the Greek Myths sets (not yet allocated to a theme) and all other sets in PlaymoDB.

https://www.dropbox.com/s/scuecnml45k7q20/All%20sets%2018%20Jun%202020.xlsx?dl=0 (https://www.dropbox.com/s/scuecnml45k7q20/All%20sets%2018%20Jun%202020.xlsx?dl=0)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: tahra on June 18, 2020, 18:04:01
:wow:
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: tigana123 on June 19, 2020, 08:04:13
Thank you!  :clap:
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: GrahamB on October 24, 2020, 17:22:34
Latest update:

https://www.dropbox.com/s/ybeq6abrcvekx81/All%20sets%2018%20Oct%202020.xlsx?dl=0 (https://www.dropbox.com/s/ybeq6abrcvekx81/All%20sets%2018%20Oct%202020.xlsx?dl=0)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: tahra on October 25, 2020, 15:45:45
Thank you GrahamB ;)
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: StJohn on October 25, 2020, 19:28:50
Thank you indeed, Chronicler of Playmobil! :thanks:
Title: Re: Do you need a complete list of all Playmobil sets?
Post by: Luftgaengerin on October 26, 2020, 10:01:35
Thanks a million, Graham!  :love: :wave: