Change log file datestamp to yyyy-mm-dd

User feature requests
Planned features for Core Temp
Post Reply
BanditQuest
Registered User
Registered User
Posts: 4
Joined: Fri Jan 04, 2013 4:04 am

Change log file datestamp to yyyy-mm-dd

Post by BanditQuest »

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.

Naki
Registered User
Registered User
Posts: 213
Joined: Sun Oct 14, 2012 2:13 pm
Location: Eastern Europe
Contact:

Re: Change log file datestamp use system default

Post by Naki »

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.

BanditQuest
Registered User
Registered User
Posts: 4
Joined: Fri Jan 04, 2013 4:04 am

Re: Change log file datestamp use system default

Post by BanditQuest »

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.

User avatar
The Coolest
Site Admin
Site Admin
Posts: 3379
Joined: Tue Feb 18, 2003 7:48 pm
Location: Tel Aviv, Israel
Contact:

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

Post by The Coolest »

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.
Main rig:
AMD Ryzen 9 5950X (True Spirit 140 Direct) / Mobo: Asrock Fatal1ty X470 / EVO 970 500GB + WD Blue 250GB + HDD / GPU: Dell RX 570 4GB / Mem: 2x16GB DDR4-3200 G.Skill 32GTZKW TridentZ - 32GB total / PSU: Seasonic Prime Ultra Gold 650W
NAS:
Core i7 2600K 3.4GHz @ 4.3GHz (Scythe Mugen2) / Mobo: Biostar TP67XE / 2x Inland Pro 120GB + HDDs / GPU: ATi Mach64 VT2 / Mem: 4x4GB DDR3-1600 G.Skill 8GBXL RipJawsX - 16GB total / PSU: Seasonic S12II 620W.
Secondary rigs:
Core i3 7130U / MiniPC / SanDisk SDSSDP-128G / GPU: Intel HD 620 / Mem: 1x8GB DDR3L-1600
Xeon X3430 2.40GHz @ 3.06GHz or Core i3 540 3.06GHz @ 4.0GHz (Freezer 7 Pro) / Mobo: MSI H55M-ED55 / PNY CS1111 240GB / GPU: ATI FirePro V3800 / Mem: 4x2GB DDR3-1600 G.Skill 4GBRL RipJaws - 8GB total / PSU: Seasonic S12II 620W
AMD Phenom II X4 B93 / Mobo: ASUS M2A-VM / GPU: ATI Radeon Xpress X1250 / Crucial M4 120GB / Mem: 2x2GB DDR2-800 - 4GB total / PSU: Antec 380W.

Core Temp - Accurate temperature monitor for Intel's Core/Core 2 and AMD64 processors

BanditQuest
Registered User
Registered User
Posts: 4
Joined: Fri Jan 04, 2013 4:04 am

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

Post by BanditQuest »

The Coolest wrote: Fri Jan 04, 2013 12:30 pm ... It does conform to your regional setting as in DD\MM\YY or MM\DD\YY.
Even with version 1.0RC4 32 bit on win 10 (x64) it has always ignored regional settings.
Tested on a few machines all set for "English (Australia)" short date "dd/mm/yy" but log data is "mm/dd/yy", so puzzled by your comment.

Naki
Registered User
Registered User
Posts: 213
Joined: Sun Oct 14, 2012 2:13 pm
Location: Eastern Europe
Contact:

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

Post by Naki »

Try latest version. What you listed is VERY old.

Post Reply

Return to “Development”