ThinkPad Machine Type - Model lookup table *PIC*

[twistero]

As people have noticed, the new Lenovo support site have very limited support for Machine Type - Models lookups of legacy systems. Right now that feature is still available at http://support1.lenovo.com, but that website may be decommissioned at any moment.

Obviously I have to step in and save the day.

A python script and several days later I have scraped everything I could from the old support site's model selector. Only ThinkPads, though. 552374 models in total.

This file is a bit large for online services like Google Spreadsheets (400000 cells max), so unfortunately no quick online lookups. Someone who already have a database backend in place may consider hosting a copy and providing a search interface for it (or I can make one if someone pays the bill ) But a complete offline copy works just as well.

Head over here to download an Excel spreadsheet containing the entire ThinkPad MTM database.

Admin edit: Added PIC warning since I added an image downthread.

[rkawakami]

Thanks for all the work! I imported the raw .CSV file into Access 2003 since Excel has a row limit of 64K. Sorted on Fields 3 and 4 and the list is in numerical order so it's easy to find whatever I need. Of course if I knew how to construct a proper query then I probably wouldn't have had to do this sort.

[Johan]

Wauw; truly another both outstanding and awesome effort by Twistero... greatly appreciated!!

I already downloaded the file, opened it with Microsoft Excel 2010 with no difficulties (although as mentioned by Twistero it's *big* containing 552374 lines), and I am able to search for all the models with no difficulties.

What a pleasure being member of such a friendly support-forum as this, and what a huge asset for the forum to have super-helpful and TOP-expert members amongst us such as Twistero!

Thank you, thank you, thank you - personally, I just wish I had, say, 1 % of your skills; man, ooh, how I'd then be clever!

Johan

[FryPpy]

Obviously I have to step in and save the day.

Thank you good MAN. When they (Lenovo) wiped their databases i have felt both hands cutted off I don't know is a S/N lookup is working now (can be saved) but it is good thing too.

I know that this work needs some time - but maybe it is worth while to divide your xlsx-file (database) to parts for models (T60, T61, T500 etc). It produce many small files that can be uploaded to free hosting providers.

[RealBlackStuff]

Made this into a Sticky. Thanks twistero!

Once you have loaded this in Excel 2010, click on Home, then Find & Select (all the way on the right) and type in e.g. (7661-E17) and include the Parentheses.

In Excel 2003/2007, click on Edit, then Find and type in e.g. (7661-E17) and include the Parentheses.

[bluefruit]

Thanks for archiving this. The MTM of both my T61 and X300 showed an error on Lenovo's new support site, but is available in your excel file!

[RealBlackStuff]

A member of the German Thinkpad forum has created an online program where you just type in the MTM, like: 2647-4MU and it comes up with the result.
http://sm.krelay.de/tp/index.php
The program was originally in German, but after I asked the programmer, it now switches automatically to English (depending on browser).

(the link was first posted here: http://forum.thinkpads.com/viewtopic.ph ... 90#p748390).

[dr_st]

A member of the German Thinkpad forum has created an online program where you just type in the MTM, like: 2647-4MU and it comes up with the result.
http://sm.krelay.de/tp/index.php
The program was originally in German, but after I asked the programmer, it now switches automatically to English (depending on browser).

This is awesome!

Now if someone just makes a Mycroft search plugin for that site, it would be already much better than what we had with Lenovo.

[rkawakami]

Along those lines, I've just added a Firefox QuickSearch that taps into that database. As long as the MTM appears on a page, I can highlight it and perform the lookup. The URL to use when defining the QuickSearch to access that German site is:

http://sm.krelay.de/tp/index.php?type=%s

In operation, the "%s" token is replaced by the highlighted string. Thus, if 2647-HNU appears on a page (or even from this message composition box; but not from Firefox's own Search box), I highlight that MTM, right-click, hover over 'Search for "2647-HNU"... on', wait for the selection list to open up on the right, then click the "Thinkpad MTM lookup" entry. That opens up another tab at the sm.krelay.de site and the system description appears. Here's how it's setup in my browser's Quick Searches folder:

[axur-delmeria]

Along those lines, I've just added a Firefox QuickSearch that taps into that database.

Nice tip!

[RealBlackStuff]

In case any of you missed it: look at the top of each forum page for: Drivers - HMM - MTM (= Machine Type Model)

[oboogie]

psref.lenovo.com : product Spec. reference; 05/15

http://www.lenovo.com/psref/psrefs_withdrawn.shtml : withdrawn product specs reference

[lexicon]

We've made simple form for quick search the mtm database (based on twisteroid excel file).

http://thinkpadder-id.com/mtm/

Feel free to use it; hope it helps...

[rkawakami]

We've made simple form for quick search the mtm database (based on twisteroid excel file).

Thanks! I just tried a random sample of four of my systems (T420, W500, T60p, T23) and it look fine.

[SkiBunny]

Lenovo removed the MTM lookup again recently, so here's a big shout-out to all of you above... Thanks!
To me it's pure genius and invaluable work!

[Ibthink]

What do you mean? Its still there: http://support.lenovo.com/us/en/product ... e%20Search

Doesn´t work anymore with older machines though^^

[SkiBunny]

It comes & goes and it can depend on your location too. But that page will be gone forever for everyone in just a few more weeks.
Their new lookup (on the lenovo homepage) fails to find some models that the old lookup could.

So again, thanks to the contributors above for providing the complete MTM database lookup and the convenient interface to it.

[cadillacmike68]

That's some spreadsheet. I was thinking "how in the haell are there over 500,000 models?" Then I did some digging, 7,000 T500 models alone - Wow.

[paulgj2]

Great spreadsheet! thanks for doing.

I was also wondering if it holds the info on the type of display whether LED or not. I have the old PSREF and it does indicated if a particular models display is LED or CCFL.

Thanks!

[TPFanatic]

That's some spreadsheet. I was thinking "how in the haell are there over 500,000 models?" Then I did some digging, 7,000 T500 models alone - Wow.

I didn't know T500s with Radeon 3470 existed? An error in Lenovo's documentation perhaps? And then there's the mysterious R400 with Nvdia 9300GM. Amazing work.