User avatar
garygid
Gold Member
Posts: 12415
Joined: Wed Apr 21, 2010 8:10 am
Delivery Date: 29 Mar 2011
Leaf Number: 000855
Location: Laguna Hills, Orange Co, CA

Re: Leaf Log Viewer Website for Leaf Spy Users

Thu Feb 13, 2014 7:41 am

In databases, date-time is usually stored as the number of seconds past the
beginning of 1970, rather than a text string. Then, that date-time data is
displayed according to the local or requested text format.
See SOC/GID-Meter and CAN-Do Info
2011 LEAF, sold in 2015
2010 Prius, 2014 silver Tesla S
Nissan EVSE, mod to 240/120v 16A
PU: SDG&E
Solar PV: 33 x 225W -> 7 kW max AC
To Sell: X-treme 5000Li EV motorcycle

User avatar
garygid
Gold Member
Posts: 12415
Joined: Wed Apr 21, 2010 8:10 am
Delivery Date: 29 Mar 2011
Leaf Number: 000855
Location: Laguna Hills, Orange Co, CA

Re: Leaf Log Viewer Website for Leaf Spy Users

Thu Feb 13, 2014 7:47 am

If you are going to store a text date, the YYYY/MM/DD is probably the best,
and the least misunderstood, since YYYY/DD/MM is rarely ever used.
See SOC/GID-Meter and CAN-Do Info
2011 LEAF, sold in 2015
2010 Prius, 2014 silver Tesla S
Nissan EVSE, mod to 240/120v 16A
PU: SDG&E
Solar PV: 33 x 225W -> 7 kW max AC
To Sell: X-treme 5000Li EV motorcycle

DaveinOlyWA
Gold Member
Posts: 11792
Joined: Sat Apr 24, 2010 7:43 pm
Delivery Date: 10 Nov 2016
Leaf Number: 314199
Location: Olympia, WA
Contact: Website

Re: Leaf Log Viewer Website for Leaf Spy Users

Thu Feb 13, 2014 9:34 am

wondering if there is anyway to group the trips by charging events or daily? or simply ways to manually combine separate trips together?
2011 SL; 44,598 miles. 2013 S; 44,840 miles. 2016 S30; 18,297 miles. 363 GIDs, Ahr 82.34, Hx; 100.00% kwh 28.1 QCs 165, L2's 190
My Blog; http://daveinolywa.blogspot.com" onclick="window.open(this.href);return false;

kevinleaf
Posts: 178
Joined: Mon Jun 03, 2013 4:19 pm
Delivery Date: 03 Jun 2013

Re: Leaf Log Viewer Website for Leaf Spy Users

Sun Feb 16, 2014 1:20 am

Yeah I have suggested to turbo3 using epoch time as a more universal timecode. It removes any ambiguity.

I plan on making the "trips" more flexible at some point in the future. Right now it just checks for a gap in time of more than 20 minutes. So for 2 log points more than 20 minutes apart it assumes this is a new "trip".

Turbo3
Gold Member
Posts: 1778
Joined: Mon Jul 19, 2010 8:34 pm
Delivery Date: 12 May 2011
Leaf Number: 002191
Location: San Jose, CA

Re: Leaf Log Viewer Website for Leaf Spy Users

Sun Feb 16, 2014 1:14 pm

kevinleaf wrote:Yeah I have suggested to turbo3 using epoch time as a more universal timecode. It removes any ambiguity.

I plan on making the "trips" more flexible at some point in the future. Right now it just checks for a gap in time of more than 20 minutes. So for 2 log points more than 20 minutes apart it assumes this is a new "trip".

Adding Unix epoch time in column EE. Column ED is the android device battery level (0-100).

kevinleaf
Posts: 178
Joined: Mon Jun 03, 2013 4:19 pm
Delivery Date: 03 Jun 2013

Re: Leaf Log Viewer Website for Leaf Spy Users

Wed Feb 26, 2014 3:06 pm

Thanks!
in what version of the code are you adding this? I have 0.29.20 and I don't see the change.

DaveinOlyWA
Gold Member
Posts: 11792
Joined: Sat Apr 24, 2010 7:43 pm
Delivery Date: 10 Nov 2016
Leaf Number: 314199
Location: Olympia, WA
Contact: Website

Re: Leaf Log Viewer Website for Leaf Spy Users

Sun Mar 02, 2014 12:04 pm

tried to view latest file upload and its listed in options for selecting trips but not populating any data so i tried viewing previous uploads that worked fine before and they are showing nothing either?
2011 SL; 44,598 miles. 2013 S; 44,840 miles. 2016 S30; 18,297 miles. 363 GIDs, Ahr 82.34, Hx; 100.00% kwh 28.1 QCs 165, L2's 190
My Blog; http://daveinolywa.blogspot.com" onclick="window.open(this.href);return false;

Turbo3
Gold Member
Posts: 1778
Joined: Mon Jul 19, 2010 8:34 pm
Delivery Date: 12 May 2011
Leaf Number: 002191
Location: San Jose, CA

Re: Leaf Log Viewer Website for Leaf Spy Users

Tue Mar 25, 2014 1:57 pm

Was just testing the viewer with a log using the latest Leaf Spy Pro test version 0.29.21 which supports background logging.

I started up Leaf Spy Pro on the phone then put the phone to sleep and put it in the glove box just before my wife went out this morning.

When she got back I thought I would edit the csv file so it would just have today's trips. Big mistake. I used excel to read the file in then deleted the earlier entries then resaved as csv. When I uploaded it to Leaflogger the samples were only every minute not the every 3 seconds that were in the original log. Problem was that default excel date/time only shows minutes not down to seconds so when it wrote the file out again it stripped off the seconds information.

I ended up just using a text editor to modify the csv file and delete the earlier entries. However, when I re-uploaded to Leaflogger it made no difference. The new data would not replace the old bad data. I had to go in and change the date to make it finally display the data with full resolution.

We really need a way to delete bad uploads or the app should not try to filter and keep old data if the new data is different.

kevinleaf
Posts: 178
Joined: Mon Jun 03, 2013 4:19 pm
Delivery Date: 03 Jun 2013

Re: Leaf Log Viewer Website for Leaf Spy Users

Tue Mar 25, 2014 5:04 pm

Thanks for doing that test Jim. That is a good reason for allowing deletion of trips. I need to add a lot of trip-related features and the ability to treat trips as a thing onto their own, which will allow things like deleting, naming trips, tagging trips (like "To Work", "From Work" to make it easier to show all trips of a certain type together) and sharing trips. Coming soon!

For now let me know if you have a bad upload that I need to remove from the database. It takes me just a few minutes to do this deletion manually.

Turbo3
Gold Member
Posts: 1778
Joined: Mon Jul 19, 2010 8:34 pm
Delivery Date: 12 May 2011
Leaf Number: 002191
Location: San Jose, CA

Re: Leaf Log Viewer Website for Leaf Spy Users

Tue Mar 25, 2014 5:14 pm

kevinleaf wrote:Thanks for doing that test Jim. That is a good reason for allowing deletion of trips. I need to add a lot of trip-related features and the ability to treat trips as a thing onto their own, which will allow things like deleting, naming trips, tagging trips (like "To Work", "From Work" to make it easier to show all trips of a certain type together) and sharing trips. Coming soon!

For now let me know if you have a bad upload that I need to remove from the database. It takes me just a few minutes to do this deletion manually.

The bad uploads are the 3/25/2014 ones. I re-dated them to 3/26/2014 (tomorrow) to get the new good ones in.

Return to “LEAF CANBus”