Welcome to Bimmerfest -- The #1 Online Community for BMW related information! Please enjoy the discussion forums below and share your experiences with the 200,000 current, new and past BMW owners. The forums are broken out by car model and into other special interest sections such as BMW European Delivery and a special forum to voice your questions to the many BMW dealers on the site to assist our members!

Please follow the links below to help get you started!

Go Back   Bimmerfest - BMW Forums > BMW Model Discussions > General BMW

General BMW
Use this forum to talk about general BMW news/stories and to chat with fellow enthusiasts about the direction that BMW is going in for their cars and/or motorcycles!

Reply
 
Thread Tools Display Modes
  #1  
Old 08-29-2012, 04:29 PM
KrisL's Avatar
KrisL KrisL is offline
Ubergeek
Location: San Jose, CA
 
Join Date: Dec 2001
Posts: 15,642
Send a message via AIM to KrisL Send a message via Yahoo to KrisL
Mein Auto: 330i ZHP
I've tracked my maintenance online with a system I wrote for awhile now...



I put a bit of polish on the script I wrote and registered a domain last night.

If anybody else wants to try it feel free!

http://www.motorlogbook.com


(If you want to view my 330s maintenance, go here:
http://www.motorlogbook.com/kris/zhp


Just another service by KrisL .
__________________

Last edited by KrisL; 09-04-2012 at 12:10 AM.
Reply With Quote
Ads by Google
  #2  
Old 08-29-2012, 04:34 PM
marlin1881 marlin1881 is offline
Officially Welcomed to the 'Fest
Location: Colorado
 
Join Date: Jun 2008
Posts: 932
Mein Auto: 2003 330i ZHP
Cool! Thanks. I'll take a look.
Reply With Quote
  #3  
Old 08-29-2012, 04:49 PM
mlukas161's Avatar
mlukas161 mlukas161 is offline
Officially Welcomed to the 'Fest
Location: WNY
 
Join Date: Oct 2008
Posts: 884
Mein Auto: 03 330i, 04 X3
That's awesome. Thanks for sharing it.
__________________
Reply With Quote
  #4  
Old 08-29-2012, 05:20 PM
av98's Avatar
av98 av98 is offline
ZHP = Patlabor
Location: SF Bay Area
 
Join Date: Dec 2006
Posts: 2,325
Mein Auto: Mini Clubmn,Odyssey,Miata
Thanks KrisL! This is great!

Is there any way to modify the existing entries w/o deleting them?
Reply With Quote
  #5  
Old 08-29-2012, 05:52 PM
KrisL's Avatar
KrisL KrisL is offline
Ubergeek
Location: San Jose, CA
 
Join Date: Dec 2001
Posts: 15,642
Send a message via AIM to KrisL Send a message via Yahoo to KrisL
Mein Auto: 330i ZHP
Quote:
Originally Posted by av98 View Post
Thanks KrisL! This is great!

Is there any way to modify the existing entries w/o deleting them?
Thats the next thing I need to work on - form validation and inline editing.

Early alpha and all that ...
__________________
Reply With Quote
  #6  
Old 08-29-2012, 06:50 PM
smolck's Avatar
smolck smolck is online now
ROLL TIDE!
Location: Birmingham, AL
 
Join Date: Jul 2007
Posts: 22,335
Mein Auto: 2004 ZHP Sedan
Thanks Kris! Any way to import an excel spreadsheet I already have going or am I going to have to pay my son for data entry? Where is this info stored? Is it safe? Reason being if I lose my spreadsheet in a CPU crash I am hosed, I have no backup.
__________________

Check out my YouTube Channel for DIY's and other fun stuff HERE
Check out my BMWBLOG!
Quote:
Originally Posted by Fast Bob View Post
now, go burn your Man Card, and buy yourself a Camry....
Reply With Quote
  #7  
Old 08-29-2012, 11:12 PM
av98's Avatar
av98 av98 is offline
ZHP = Patlabor
Location: SF Bay Area
 
Join Date: Dec 2006
Posts: 2,325
Mein Auto: Mini Clubmn,Odyssey,Miata
Quote:
Originally Posted by smolck View Post
Thanks Kris! Any way to import an excel spreadsheet I already have going or am I going to have to pay my son for data entry? Where is this info stored? Is it safe? Reason being if I lose my spreadsheet in a CPU crash I am hosed, I have no backup.
If you have an Amazon account use the free cloud drive. That's where I store my excel spreadsheet files on top of the external HDD backups.
__________________
Reply With Quote
  #8  
Old 08-30-2012, 05:39 AM
SPDSKTR SPDSKTR is offline
I'm a DlCK! So what?
Location: Birmingham, AL, USA
 
Join Date: Sep 2011
Posts: 1,980
Mein Auto: E30 with an S52
Quote:
Originally Posted by smolck View Post
Thanks Kris! Any way to import an excel spreadsheet I already have going or am I going to have to pay my son for data entry? Where is this info stored? Is it safe? Reason being if I lose my spreadsheet in a CPU crash I am hosed, I have no backup.
I'll do said data entry in exchange for certain services...
Reply With Quote
  #9  
Old 08-30-2012, 07:10 AM
stlmethod stlmethod is offline
Registered User
Location: St. Louis
 
Join Date: Jul 2009
Posts: 83
Mein Auto: 2003 325xi
Just signed up. Looks very good. Would like to import an excel spreadsheet like others have mentioned. I haven't had much time to play around with the log book but is there a way to schedule future items, similar to Mike Miller's Maintence schedule? I've done this manually on my excel sheet with most wear and tear items just looking for an easier/quicker way to to input data.
Thanks!
Reply With Quote
  #10  
Old 08-30-2012, 08:15 AM
KrisL's Avatar
KrisL KrisL is offline
Ubergeek
Location: San Jose, CA
 
Join Date: Dec 2001
Posts: 15,642
Send a message via AIM to KrisL Send a message via Yahoo to KrisL
Mein Auto: 330i ZHP
Quote:
Originally Posted by smolck View Post
Thanks Kris! Any way to import an excel spreadsheet I already have going or am I going to have to pay my son for data entry? Where is this info stored? Is it safe? Reason being if I lose my spreadsheet in a CPU crash I am hosed, I have no backup.
If you send me the spreadsheet I could import it. Its being stored in mysql and is backed up.
__________________
Reply With Quote
  #11  
Old 08-30-2012, 12:12 PM
numindast numindast is offline
Properly chastised re: Xi
Location: Chicago
 
Join Date: Apr 2008
Posts: 1,007
Mein Auto: 2005 325xi
I signed up too! Nice and clean, looks good, and covers exactly the kind of information I want to start keeping better track of.

I'll see if I can break it and let you know of course... Thanks Kris!
__________________
Quote:
Originally Posted by Fast Bob View Post
...the last thing you need is unpredictable rubber
Reply With Quote
  #12  
Old 08-30-2012, 12:54 PM
fauchpj fauchpj is offline
Registered User
Location: Birmingham
 
Join Date: Jun 2007
Posts: 83
Mein Auto: 03 540i 6MT | 05 X5 3.0i
Can you add cost and get it to show a sum at the bottom? (I'm sure most of us are too scared to know)
__________________
Reply With Quote
  #13  
Old 08-30-2012, 01:09 PM
MalibuMafiaV's Avatar
MalibuMafiaV MalibuMafiaV is offline
L4P
Location: Malibu, CA
 
Join Date: Jul 2005
Posts: 11,200
Send a message via AIM to MalibuMafiaV
Mein Auto: E46 stg 2.5 & E60 M5
This is awesome. Appreciate it Kris. Although for a case like mine I'm not entirely sure of some of the things I've done. I can't even remember a lot of it.
__________________
http://www.luxury4play.com
2006 BMW M5 - REALLY LOUD
2000 3-series BMW supercharged Because race car.
2004 Maserati M128 GT SOLD
2006 BMW M3 - SOLD
Reply With Quote
  #14  
Old 08-31-2012, 01:27 AM
moverman68 moverman68 is offline
pocojo68
Location: British Columbia Canada
 
Join Date: Mar 2011
Posts: 39
Mein Auto: 2004/320i
I just signed up.This is a great idea thanks Kris.
Reply With Quote
  #15  
Old 09-01-2012, 05:07 AM
PerfectStorm01 PerfectStorm01 is offline
Officially Welcomed to the 'Fest
Location: Melbourne, Australia
 
Join Date: Jan 2012
Posts: 233
Mein Auto: 2001 320Ci
Kris, this is awesome! I've been tracking my maintenance by writing on the parts/services invoice. This puts it all in one spot for me. Great job and thanks!

Besides the couple enhancements below that other people have mentioned here are a few more that I noticed: can't add my vin once login created (I just know the last 7 digits); ability to print-out log; email reminder or alert system (I buy parts sometimes months in advance and forget about the DIY , seasonal alerts like a spring reminder to make sure you have all you wash/wax essentials, bi annual fluid flushes or even a monthly check the oil reminder) Just ideas...thanks again!


Quote:
Originally Posted by av98 View Post
Thanks KrisL! This is great!

Is there any way to modify the existing entries w/o deleting them?
+1

Quote:
Originally Posted by fauchpj View Post
Can you add cost and get it to show a sum at the bottom? (I'm sure most of us are too scared to know)
+2 for next version
__________________

Last edited by PerfectStorm01; 09-01-2012 at 05:09 AM.
Reply With Quote
  #16  
Old 09-02-2012, 02:49 PM
ChiefAndy ChiefAndy is offline
Registered User
Location: Stuttgart, GE
 
Join Date: Sep 2012
Posts: 3
Mein Auto: 2000 323i
Thanks KrisL. I finally got off my bottom and decided to treat our 2000 323i as it deserves so this is a rather timely item!

An option to add potentially is how long a DiY took to complete.
Reply With Quote
  #17  
Old 09-03-2012, 10:44 PM
KrisL's Avatar
KrisL KrisL is offline
Ubergeek
Location: San Jose, CA
 
Join Date: Dec 2001
Posts: 15,642
Send a message via AIM to KrisL Send a message via Yahoo to KrisL
Mein Auto: 330i ZHP
Quote:
Originally Posted by fauchpj View Post
Can you add cost and get it to show a sum at the bottom? (I'm sure most of us are too scared to know)
You can now edit items (in-line editing, click on an item from the add maintenance page) ... and there is a tab at the top for spending reports .
__________________
Reply With Quote
  #18  
Old 09-04-2012, 12:53 AM
heztheone heztheone is offline
Officially Welcomed to the 'Fest
Location: Lebanon (The Country)
 
Join Date: Oct 2009
Posts: 1,369
Mein Auto: 330i ZHP M/T
my advice is to add a button that imports excel files based on the following:
1. put a template spreadsheet design for the users to know in which format the excel file needs to be saved
2. user browses a file from his PC
3. an upload button to upload the file's data and store them in the database

as for the validation of the file, i would recommend something like handling exceptions for each cell being read, on a row basis.
if a cell triggers an exception, store the entire row (or only the row ID) to be displayed for the user to know which ones he needs to update, with the exception caught, if u want.
the rows that were imported successfully with no errors should be saved, the others to be displayed on the screen based on how u see it fit.

great job on the website
and hope i was a little helpful
__________________


Give a man a fish and you feed him for a day. Give a man a Chef and he feeds him for a lifetime
Reply With Quote
  #19  
Old 09-04-2012, 08:05 AM
KrisL's Avatar
KrisL KrisL is offline
Ubergeek
Location: San Jose, CA
 
Join Date: Dec 2001
Posts: 15,642
Send a message via AIM to KrisL Send a message via Yahoo to KrisL
Mein Auto: 330i ZHP
Quote:
Originally Posted by heztheone View Post
my advice is to add a button that imports excel files based on the following:
1. put a template spreadsheet design for the users to know in which format the excel file needs to be saved
2. user browses a file from his PC
3. an upload button to upload the file's data and store them in the database

as for the validation of the file, i would recommend something like handling exceptions for each cell being read, on a row basis.
if a cell triggers an exception, store the entire row (or only the row ID) to be displayed for the user to know which ones he needs to update, with the exception caught, if u want.
the rows that were imported successfully with no errors should be saved, the others to be displayed on the screen based on how u see it fit.

great job on the website
and hope i was a little helpful

Hi Heztheone,

Thanks, I was thinking of adding excel input. Realistically, it's a lot of work - if someone wants me to import an excel spreadsheet to the site, I recommend they email it to me. I can do it in a matter of a minute or two. Coding it would take a few hours. If it gets to the point where I'm spending too much time doing it by hand, I'll code it .
__________________
Reply With Quote
  #20  
Old 09-04-2012, 09:21 PM
heztheone heztheone is offline
Officially Welcomed to the 'Fest
Location: Lebanon (The Country)
 
Join Date: Oct 2009
Posts: 1,369
Mein Auto: 330i ZHP M/T
Quote:
Originally Posted by KrisL View Post
Hi Heztheone,

Thanks, I was thinking of adding excel input. Realistically, it's a lot of work - if someone wants me to import an excel spreadsheet to the site, I recommend they email it to me. I can do it in a matter of a minute or two. Coding it would take a few hours. If it gets to the point where I'm spending too much time doing it by hand, I'll code it .
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime
i'm a software engineer and believe me, coding it in a couple of hours will save u lots of headaches from getting a mailbox full of "Dear Kris, please upload my excel file"
__________________


Give a man a fish and you feed him for a day. Give a man a Chef and he feeds him for a lifetime
Reply With Quote
  #21  
Old 09-05-2012, 12:47 PM
KrisL's Avatar
KrisL KrisL is offline
Ubergeek
Location: San Jose, CA
 
Join Date: Dec 2001
Posts: 15,642
Send a message via AIM to KrisL Send a message via Yahoo to KrisL
Mein Auto: 330i ZHP
Quote:
Originally Posted by heztheone View Post
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime
i'm a software engineer and believe me, coding it in a couple of hours will save u lots of headaches from getting a mailbox full of "Dear Kris, please upload my excel file"
Indeed, I'm working on it. I've written scripts to import csv into mysql before, I just need to dig up that code .
__________________
Reply With Quote
  #22  
Old 12-19-2012, 05:49 PM
mr29 mr29 is offline
Officially Welcomed to the 'Fest
Location: ohio
 
Join Date: Sep 2012
Posts: 574
Mein Auto: bmw
i'll have to check this out later.
Reply With Quote
  #23  
Old 09-24-2013, 09:52 PM
Bill1100 Bill1100 is offline
Registered User
Location: Dallas, TX
 
Join Date: Aug 2013
Posts: 43
Mein Auto: 2013 BMW 550i Msport
Just registered - thanks! My car is still quite new so I only had two entries. More to come, no doubt...
__________________

2013 550i MSport - Oyster/Black Dakota Leather/Driver Assistance/Executive Package/Luxury Seating
Reply With Quote
  #24  
Old 09-29-2013, 09:08 AM
mackkjack45 mackkjack45 is offline
Registered User
Location: uk
 
Join Date: Aug 2013
Posts: 7
Mein Auto: bmw
hi

Hye,
Welcome to this forum , here you can find lots of thing, I suggest you for your question you have to contact any other expert, sorry for that.
--------------------------
healthy living
Reply With Quote
  #25  
Old 09-29-2013, 09:11 AM
mackkjack45 mackkjack45 is offline
Registered User
Location: uk
 
Join Date: Aug 2013
Posts: 7
Mein Auto: bmw
hello

Hye,
Welcome to my website , here you can find lots of information about your health & prevention of dangerous diseases, I suggest you for your question you have to contact any other expert, sorry for that.
--------------------------
healthy living
Reply With Quote
Reply

Bookmarks


Forum Navigation
Go Back   Bimmerfest - BMW Forums > BMW Model Discussions > General BMW
Today's Posts Search
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On



Forum Jump


All times are GMT -7. The time now is 02:22 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
© 2001-2011 performanceIX, Inc. All Rights Reserved .: guidelines .:. privacy .:. terms