[Dr.Hess]

I truly HATE JSON. A 2GB JSON can have about 10K of data in it.

 

[NorCalGT]

Serverless database? e.g. SQLite?

 

[Dr.Hess]

I have used MongoDB and PostgreSQL professionally. They are certainly better than Access, but crap compared even to SQL Server, and a joke compared to Vertica. So for just simple local stuff, I'm sort of stuck with Access. Anyway, if no one has any other objections/suggestions, I'll make a PDF and a tab delimited TXT and post them here. Just haven't got to it yet.

 

[Dr.Hess]

OK, here are the 199 xrefs I have scrounged from what you guys say, what someone else said, what I've found, etc. The collumn "Confirmed" means, specifically, that I have held it in my hand and compared it to the OEM one and ACTUALLY USED ON MY CAR, a 2017 Evora 400. It's a high bar for "confirmed," but it's my database, so I make the rules on it. The TXT file is a tab delimited flat file. You can load it into MS Excel by Open, change to the directory where the TXT file is, changing the format to Text, selecting the file and Open:

Or, you can open a blank spreadsheet, open Windows Explorer, find the file, drag and drop it onto the spreadsheet and it will open.

If you have Access and know how to use it, External Data, Text File, etc. PostgreSQL, YOYO (you're on your own.)

 

[Catsailr27]

OK, here are the 199 xrefs I have scrounged from what you guys say, what someone else said, what I've found, etc. The collumn "Confirmed" means, specifically, that I have held it in my hand and compared it to the OEM one and ACTUALLY USED ON MY CAR, a 2017 Evora 400. It's a high bar for "confirmed," but it's my database, so I make the rules on it. The TXT file is a tab delimited flat file. You can load it into MS Excel by Open, change to the directory where the TXT file is, changing the format to Text, selecting the file and Open:
View attachment 1379609

Or, you can open a blank spreadsheet, open Windows Explorer, find the file, drag and drop it onto the spreadsheet and it will open.

If you have Access and know how to use it, External Data, Text File, etc. PostgreSQL, YOYO (you're on your own.)

Nice work Dr Hess!

 

[Grosbard]

Thank you, @Dr.Hess !!

 

[NorCalGT]

I could probably make a quick app that would allow you to search or add to this database. Thoughts?

 

[Grosbard]

I could probably make a quick app that would allow you to search or add to this database. Thoughts?

Sounds like a pretty great idea to me!

 

[NorCalGT]

Sounds like a pretty great idea to me!

I'll fuss with it over the weekend. Pretty busy today.

 

[QLotus]

OK, here are the 199 xrefs I have scrounged from what you guys say, what someone else said, what I've found, etc.

Thank you!Extremely helpful… may save me a couple hundred bucks already (clock spring).

FWIW, this may have been mentioned already, but the Power Folding Mirror Switch is found in the 2003-2007 Ford Mondeo (that’s the one I got off eBay). It’s plug and play.

I’ve also been told the same part was used in the 2011 Fiesta, the ‘06 - ‘12 Fusions with the option (probably SEL and maybe Sport trims?), and the Ford C-Max (again, with the optional mirrors). Haven’t confirmed that one for myself, but I can absolutely confirm the Mondeo. Just folded my mirrors yesterday with the Mondeo switch.

Just trying to give a little back. Thanks again!!!!

 

[TNEngineer]

@Dr.Hess, your data is exactly why this forum is so awesome and valuable! Thank you for compiling and maintaining it.

I've just learned, from your PDF, that my Evora GT and my Ram 3500 use the same serpentine belt. Who'da thunk that. 🤪

 

[pharriso]

S2 Fuel pump module is A132L0081H & approximately $400 from Lotus here in the US.

Looking at used eBay units:

It interchanges to Toyota 77020-33210, which lists for 2003-2006 Camry & others.

Now if you put this part number into Amazon it comes back with several parts, many available for less than $50.

 

[pharriso]

Tank Vapor Pressure Sensor A121L6004F is Toyota 89461-33020. This is the vapor sensor mounted on the gas tank near the fuel pump & is used for evaporative emissions leak detection.

 

[Frohst]

@Dr.Hess, your data is exactly why this forum is so awesome and valuable! Thank you for compiling and maintaining it.

I've just learned, from your PDF, that my Evora GT and my Ram 3500 use the same serpentine belt. Who'da thunk that. 🤪

? Huh? Am I reading it wrong? Isn't that for the S and not the 400/GT?

 

[agentdr8]

? Huh? Am I reading it wrong? Isn't that for the S and not the 400/GT?

Yeah, the S should be the one that's the same as the Ram 3500s. The S2s use a different length belt.

 

[pharriso]

Gas cap for the S2 A121L6004F ($107.19) is Jaguar Land Rover LR053665 which can be had for $45 from LR dealers, or $15-20 on eBay or Amazon.

According to eBay listings fits a bazillion Jaguars, Land Rovers & Volvos.

 

[Dr.Hess]

Yeah, the S should be the one that's the same as the Ram 3500s. The S2s use a different length belt.

My DB says:
For supercharged, same as Dodge RAM 2500/3500 truck
and a different belt for the 400:
For 400, but not Lotus recommended "gatorback" style.

I'll make a note that the Ram belt is S1.

Keep 'em coming, pharisso! I'll edit my files when I have sufficient additions.

 

[pharriso]

OK, here are the 199 xrefs I have scrounged from what you guys say, what someone else said, what I've found, etc. The collumn "Confirmed" means, specifically, that I have held it in my hand and compared it to the OEM one and ACTUALLY USED ON MY CAR, a 2017 Evora 400. It's a high bar for "confirmed," but it's my database, so I make the rules on it....

This is great, can I suggest an extra column to indicate whether the part fits S1, S2 or both? Some parts (e.g. Brake pads come to mind) are series specific.

 

[Dr.Hess]

Yeah, I can do that. I usually put what it fits in the description column, if it is known. Sometimes people leave that out. Corrections and additions are certainly welcome.

 

[Frohst]

Haven't seen it posted yet. OEM serpentine belt on 2017 400, dayco 7pk2958.

This isn't the gator back but gives the length we'd need to find an alternative part.