Login | Register

Change log file datestamp to yyyy-mm-dd

User feature requests
Planned features for Core Temp
  • Author
    Message

Change log file datestamp to yyyy-mm-dd

Postby BanditQuest » Fri Jan 04, 2013 5:39 am

I have re-edited this request:
Hard coding mm/dd/yyyy is great for USA but the rest of the world uses other formats as default. It is exceeding difficult to do an excel graph. I tried this with excel 2003 using the "text to column" conversion but it gets your date format wrong and I get a converted result assuming text is dd/mm/yy. That screws up graphing day is swapped with month. It did this in my case and probably depends on OS regional setting.

To future proof updates I suggest changing heading in log file header "Time" to literal "Time (hh:mm:ss mm/dd/yy)" so I can write an excel macro that will reformat the data for now. That change will allow me to detect the format changes in some future release. Data for last month like 12/01/12 is ambiguous depending on what your used to.

In my opinion log files should be yyyy-mm-dd hh:mm:ss (which is not necessarily what your OS regional settings are). I think excel will detect that correctly. What do others think is there a general agreement on this?

(Also noticed an extra comma on end of every CPU temperature data line which is not really needed)
Last edited by BanditQuest on Fri Jan 04, 2013 11:03 am, edited 2 times in total.
BanditQuest
New User
 
Posts: 2
Joined: Fri Jan 04, 2013 4:04 am

Re: Change log file datestamp use system default

Postby Naki » Fri Jan 04, 2013 9:53 am

BanditQuest wrote:Could you please get the logging to use the date format set by the OS in regional settings. Hard coding mm/dd/yyyy is great for you but the rest of the world uses other formats as default. It is exceeding difficult to do an excel graph because it does auto conversion (open csv file) to internal serial is using dd/mm/yyyy (for me it did this) and that screws up the graphing.

Yes, please do this!

EDIT: Ooops, sorry. If Core Temp log files adhere to System Regional Settings, that is good enough for me.
Last edited by Naki on Sun Jan 06, 2013 3:21 pm, edited 1 time in total.
Naki
Registered User
Registered User
 
Posts: 129
Joined: Sun Oct 14, 2012 2:13 pm
Location: Eastern Europe

Re: Change log file datestamp use system default

Postby BanditQuest » Fri Jan 04, 2013 11:06 am

Naki wrote:Yes, please do this!

I re-worded the request after a lot of testing in excel 2003 I found I can work around problem.
BanditQuest
New User
 
Posts: 2
Joined: Fri Jan 04, 2013 4:04 am

Re: Change log file datestamp to yyyy-mm-dd

Postby The Coolest » Fri Jan 04, 2013 12:30 pm

As I see it there are 2 options:

  1. Keep using what we have right now. It does conform to your regional setting as in DD\MM\YY or MM\DD\YY.
  2. Have a custom hard coded time format, similar to what we see in the log file title.

I can't find anything which will return the correct string with the format you have set in the Regional Settings configuration window.
Member of our O/C Folding @ Home team
"<The_Coolest> you can't unwaste wasted CPU cycles" - Start FOLDing now!
Main rig:
Core i7 2600K 3.4GHz @ 4.5GHz (Scythe Mugen2) / Mobo: Biostar TP67XE / SSD: Crucial M4 128GB (+ HDDs) / GPU: HD5450 / Mem: 4x4GB DDR3-1600 G.Skill 4GBXL RipJaws X - 16GB total / PSU: Seasonic S12II 620W.
Secondary rig:
Core i3 540 3.06GHz @ Stock / Mobo: MSI H55M-ED55 / GPU: Integrated / Mem: 2x2GB DDR3-1600 G.Skill 4GBRL RipJaws - 4GB total / PSU: FSP ATX350-PNR 350W.

Core Temp - Accurate temperature monitor for Intel's Core/Core 2 and AMD64 processors
User avatar
The Coolest
Site Admin
Site Admin
 
Posts: 2961
Joined: Tue Feb 18, 2003 7:48 pm
Location: Tel Aviv, Israel

Return to Development

Who is online

Users browsing this forum: No registered users and 1 guest