Page 1 of 7 1234567 LastLast
Results 1 to 25 of 151

Thread: M Roadster/ Coupe Database

  1. #1
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster

    M Roadster/ Coupe Database

    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.

  2. #2
    Jeremy's Avatar
    Jeremy is offline ǝoɥsuʍolƆ ǝnƃɐǝ˥ ɹoɾɐW BMW CCA Member
    Join Date
    Aug 2007
    Location
    Phoenix, AZ
    Posts
    12,113
    My Cars
    2002 Smurf Hearse
    Thanks for sharing.
    Quote Originally Posted by akreis View Post
    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...
    That would rock!
    jeremy [AT] coupecartel [DOT] com

    1 of 1 | 2002 Laguna Seca Blue/Black M Coupe | LK61201
    "I don't know the key to success, but the key to failure is trying to please everybody.."



  3. #3
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster
    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;

  4. #4
    Join Date
    Nov 2006
    Location
    Boston, MA
    Posts
    9,163
    My Cars
    S54 e36/8; e39 M5

  5. #5
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster
    Quote Originally Posted by fmcfad01 View Post
    nerd.
    Let me get this straight. You have 6,245 posts on an online bulletin board...

    Anyway, just trying to help.

  6. #6
    Join Date
    Oct 2008
    Location
    NH
    Posts
    2,169
    My Cars
    2000 M Coupe
    Please make it non-nerd friendly
    2000 Z3 MCoupe, '01 LSB E46 M3, '99 GTI VR6, '06 Audi A4, Andrew '95 Avus M3

  7. #7
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster
    Quote Originally Posted by MCoupeVet View Post
    Please make it non-nerd friendly
    I'll try. I'm actually not very computer savvy. I just happen to be taking a class in database management. Again, any help would be appreciated. I think it would be a great tool for the forum members.

  8. #8
    Join Date
    May 2002
    Location
    Honolulu
    Posts
    10,403
    My Cars
    No more BMWs :(
    Quote Originally Posted by akreis View Post
    Let me get this straight. You have 6,245 posts on an online bulletin board...

    Anyway, just trying to help.
    your point being..?



    997 Carrera 2S..the choice of 2 out of 3 Top Gear presenters.

  9. #9
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster
    Quote Originally Posted by IslandS62 View Post
    your point being..?



    Just a nerd trying to help the community.

  10. #10
    Jeremy's Avatar
    Jeremy is offline ǝoɥsuʍolƆ ǝnƃɐǝ˥ ɹoɾɐW BMW CCA Member
    Join Date
    Aug 2007
    Location
    Phoenix, AZ
    Posts
    12,113
    My Cars
    2002 Smurf Hearse
    Quote Originally Posted by akreis View Post
    Let me get this straight. You have 6,245 posts on an online bulletin board...

    Anyway, just trying to help.
    I don't think Scott was trying to be a d!ck. I think he was just messing around...
    jeremy [AT] coupecartel [DOT] com

    1 of 1 | 2002 Laguna Seca Blue/Black M Coupe | LK61201
    "I don't know the key to success, but the key to failure is trying to please everybody.."



  11. #11
    Join Date
    Jun 2008
    Location
    norcal
    Posts
    1,375
    My Cars
    e36/7/8's
    Why all the hating? It's a neat, albeit ambitious, project. If he succeeds we all benefit, if it doesn't work out, what's the harm?

    OP - GL with that, and don't let the hating nor the challenges of your project get you down.


    Quote Originally Posted by Sneezy View Post
    Don't fret, love, you're still at the top of the weirdo list and I <3 you for it.
    Quote Originally Posted by Codeman View Post
    I need to say something to get into einzlr's signature.

  12. #12
    Join Date
    Dec 2008
    Location
    Lancaster, PA
    Posts
    1,618
    My Cars
    00 Dinan M Cpe, 03 530i
    i'm pretty sure that i don't understand any of this.

  13. #13
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster
    Quote Originally Posted by Z3Couper View Post
    I don't think Scott was trying to be a d!ck. I think he was just messing around...
    I know. No problem.

    Anyway, back to the topic of a M Roadster/ Coupe Database.

  14. #14
    Jeremy's Avatar
    Jeremy is offline ǝoɥsuʍolƆ ǝnƃɐǝ˥ ɹoɾɐW BMW CCA Member
    Join Date
    Aug 2007
    Location
    Phoenix, AZ
    Posts
    12,113
    My Cars
    2002 Smurf Hearse
    Quote Originally Posted by akreis View Post
    Anyway, back to the topic of a M Roadster/ Coupe Database.
    Oh, right.
    jeremy [AT] coupecartel [DOT] com

    1 of 1 | 2002 Laguna Seca Blue/Black M Coupe | LK61201
    "I don't know the key to success, but the key to failure is trying to please everybody.."



  15. #15
    Join Date
    Jun 2007
    Location
    McLean, VA
    Posts
    3,830
    My Cars
    97 2.8 Roady, 02 M Coupe
    What program(s) do I need to have installed to use this? BTW thanks for doing it!
    Kelvin

  16. #16
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster
    Quote Originally Posted by KBH22102 View Post
    What program(s) do I need to have installed to use this? BTW thanks for doing it!
    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 08:16 PM.

  17. #17
    Join Date
    Oct 2008
    Location
    NH
    Posts
    2,169
    My Cars
    2000 M Coupe
    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

  18. #18
    Join Date
    Oct 2009
    Location
    Michigan
    Posts
    66
    My Cars
    1999 M Roadster
    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.

  19. #19
    Join Date
    Dec 2007
    Location
    Great Dismal Swamp
    Posts
    13,969
    My Cars
    E36/7 E36/8x2 E39/2 E46
    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

  20. #20
    Join Date
    Jun 2009
    Location
    Coral Springs, FL
    Posts
    1,299
    My Cars
    01 E36/8
    Quote Originally Posted by IslandS62 View Post
    your point being..?





    Quote Originally Posted by akreis View Post
    I have posted 2 downloadable databases at

    http://www.georgekaplan.net/BMW.html

    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.
    Your efforts are appreciated.

    Quote Originally Posted by Z3Couper View Post
    I don't think Scott was trying to be a d!ck. I think he was just messing around...
    +1

    Quote Originally Posted by akreis View Post
    I have posted 2 downloadable databases at

    http://www.georgekaplan.net/BMW.html

    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.

    Ever looked at www.lynda.com?
    Last edited by 01MCoupe; 12-07-2009 at 09: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.

  21. #21
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster
    Quote Originally Posted by MCoupeVet View Post
    dude - put it all in excel or something that everyone has. Great idea - only if we can use it.
    Done. Excel file is third one listed.

  22. #22
    Join Date
    Jul 2006
    Location
    Reston, VA
    Posts
    888
    My Cars
    '06 Z4M Roadster
    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.


    DreamingWell.com Web Services

  23. #23
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster
    Quote Originally Posted by wildag View Post
    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.
    I'll put the original MySQL dump up with the others if you get it to me. PM me.

    CSV file now fourth one listed.
    Last edited by akreis; 12-07-2009 at 10:14 PM.

  24. #24
    Join Date
    Nov 2006
    Location
    Boston, MA
    Posts
    9,163
    My Cars
    S54 e36/8; e39 M5
    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....

  25. #25
    Join Date
    Jun 2009
    Location
    Columbus, OH
    Posts
    198
    My Cars
    2001 M Roadster
    Quote Originally Posted by fmcfad01 View Post
    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....
    No problem. Any suggestions?

Page 1 of 7 1234567 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •