I have posted 2 downloadable databases at
http://www.bmwmdata.com
Choose: Data
One was created using Access 2007. The other is an SQL script that will build and populate tables for MySQL. Both are based upon the data from wildag scraping scripts. I'm trying to create a web based database which will give all the details (including pictures) for a vehicle when the VIN is input. Ultimately, I would like to incorporate current mileage, owner info, etc...
However, I am still learning PHP/MySQL. Any help would be greatly appreciated.
Last edited by akreis; 04-20-2010 at 02:43 PM.
Here is some SQL to use on the MySQL database to:
Select All Vehicles
SELECT tblVehicles.VIN, tblVehicles.ShortVIN, tblVehicles.ProductionDate, tblVehicles.Series, tblVehicles.ESeries, tblVehicles.BodyType, tblPaint.EnglishColor AS Paint_EnglishColor, tblInterior.EnglishColor AS Interior_EnglishColor
FROM tblPaint INNER JOIN (tblInterior INNER JOIN tblVehicles ON tblInterior.InteriorCode = tblVehicles.InteriorCode) ON tblPaint.PaintCode = tblVehicles.PaintCode
ORDER BY tblVehicles.ProductionDate;
Select S52 Roadsters
SELECT tblVehicles.VIN, tblVehicles.ShortVIN, tblVehicles.ProductionDate, tblVehicles.Series, tblVehicles.ESeries, tblVehicles.BodyType, tblPaint.EnglishColor AS Paint_EnglishColor, tblInterior.EnglishColor AS Interior_EnglishColor
FROM tblPaint INNER JOIN (tblInterior INNER JOIN tblVehicles ON tblInterior.InteriorCode = tblVehicles.InteriorCode) ON tblPaint.PaintCode = tblVehicles.PaintCode
WHERE (((tblVehicles.ShortVIN) Like "LC%") AND (tblVehicles.BodyType = "Roadster"))
ORDER BY tblVehicles.ProductionDate;
Select S52 Coupes
SELECT tblVehicles.VIN, tblVehicles.ShortVIN, tblVehicles.ProductionDate, tblVehicles.Series, tblVehicles.ESeries, tblVehicles.BodyType, tblPaint.EnglishColor AS Paint_EnglishColor, tblInterior.EnglishColor AS Interior_EnglishColor
FROM tblPaint INNER JOIN (tblInterior INNER JOIN tblVehicles ON tblInterior.InteriorCode = tblVehicles.InteriorCode) ON tblPaint.PaintCode = tblVehicles.PaintCode
WHERE (((tblVehicles.ShortVIN) Like "LC%") AND (tblVehicles.BodyType = "Coupe"))
ORDER BY tblVehicles.ProductionDate;
Select S54 Roadsters
SELECT tblVehicles.VIN, tblVehicles.ShortVIN, tblVehicles.ProductionDate, tblVehicles.Series, tblVehicles.ESeries, tblVehicles.BodyType, tblPaint.EnglishColor AS Paint_EnglishColor, tblInterior.EnglishColor AS Interior_EnglishColor
FROM tblPaint INNER JOIN (tblInterior INNER JOIN tblVehicles ON tblInterior.InteriorCode = tblVehicles.InteriorCode) ON tblPaint.PaintCode = tblVehicles.PaintCode
WHERE (((tblVehicles.ShortVIN) Like "LJ%"))
ORDER BY tblVehicles.ProductionDate;
Select S54 Coupes
SELECT tblVehicles.VIN, tblVehicles.ShortVIN, tblVehicles.ProductionDate, tblVehicles.Series, tblVehicles.ESeries, tblVehicles.BodyType, tblPaint.EnglishColor AS Paint_EnglishColor, tblInterior.EnglishColor AS Interior_EnglishColor
FROM tblPaint INNER JOIN (tblInterior INNER JOIN tblVehicles ON tblInterior.InteriorCode = tblVehicles.InteriorCode) ON tblPaint.PaintCode = tblVehicles.PaintCode
WHERE (((tblVehicles.ShortVIN) Like "LK%"))
ORDER BY tblVehicles.ProductionDate;
Select Special Vehicles
SELECT tblVehicles.VIN, tblVehicles.ShortVIN, tblVehicles.ProductionDate, tblVehicles.Series, tblVehicles.ESeries, tblVehicles.BodyType, tblPaint.EnglishColor AS Paint_EnglishColor, tblInterior.EnglishColor AS Interior_EnglishColor
FROM tblPaint INNER JOIN (tblInterior INNER JOIN tblVehicles ON tblInterior.InteriorCode = tblVehicles.InteriorCode) ON tblPaint.PaintCode = tblVehicles.PaintCode
WHERE (((tblVehicles.PaintCode) = 490) OR (tblVehicles.InteriorCode = "490"))
ORDER BY tblVehicles.ProductionDate;
nerd.
Please make it non-nerd friendly
2000 Z3 MCoupe, '01 LSB E46 M3, '99 GTI VR6, '06 Audi A4, Andrew '95 Avus M3
i'm pretty sure that i don't understand any of this.
What program(s) do I need to have installed to use this? BTW thanks for doing it!
Kelvin
These are two databases that I have created using wildag data.
Just clicking on either one of them will not do anything. You must first download them onto your computer. Then, if you have one of the programs installed, you can use the database.
The first (Z3M Database_Shared.accdb) is a Microsoft Access 2007 database, therefore, you need Microsoft Access 2007. Right click on the link and save it to your computer. Be sure to add the .accdb extension. Then, if you have Microsoft Access 2007, you can open it up and use it.
The second (z3m_mysql.sql) is a SQL script that you can run to create the tables and populate them with data. I'm using MySQL which is a free progam that you can download from www.mysql.com.
Eventually, I would like to make the database available to everyone through a web page. The web page would accept input from you, give it to MySQL running on the web server, and return a result back to you in a web page. This allows for one central database accessible to everyone through the web, without any additional programs installed on their computers.
However, one must know web scripting languages (PHP, Perl,Java, etc.) in order to make the data on the server available to clients on the web.
I'm in the process of learning this scripting language (PHP). I just made these available so that all can use, and some can help make it better. Any help is appreciated.
Last edited by akreis; 12-07-2009 at 07:16 PM.
dude - put it all in excel or something that everyone has. Great idea - only if we can use it.
2000 Z3 MCoupe, '01 LSB E46 M3, '99 GTI VR6, '06 Audi A4, Andrew '95 Avus M3
I agree with MCoupeVet, create it in Excel, you will have alot of options with that. One thing that is of concern to me is who will have access to this information. When I had my Cobra, we had an owners directory that was only available to the owners, so our private info was not released to the public.
If you want it in your spreadsheet program, just download the original file. I applaud the OPs idea and enthusiasm (though I agree on the privacy issues). Alas. my knowledge is limited to the muttering and cussing necessary to get MySQL and MythTV talking.
/.randy
Your efforts are appreciated.
+1
Ever looked at www.lynda.com?
Last edited by 01MCoupe; 12-07-2009 at 08:46 PM. Reason: Automerged Doublepost
01 M S54 Estoril Coupe (Fun)16 Mini Clubman S(Daily)03 325i (Wifes Car)Your never further away from oblivion than a distracted soccer mom in a SUV.
Here's a link to the original thread, which includes a link to a CSV file that can be used directly in Excel.
http://forums.bimmerforums.com/forum....php?t=1310936
If anyone really cares to have the original MySQL dump, I could set that up somewhere. Its as raw as you'll get.
Hahaha, sorry OP, i was, in fact, messing around. Thanks everyone else for knowing me too well. OP, I've got a masters in Computer Engineering...I was lovingly calling you a nerd...or am I a nerd for understanding what you posted? damn it....
Bookmarks