Importing dates into foo_playcount, trouble getting correct info into %added% and %last_played% |
  |
Importing dates into foo_playcount, trouble getting correct info into %added% and %last_played% |
 Oct 21 2012, 19:55
Post
#1
|
|
|
Group: Members Posts: 3 Joined: 21-October 12 Member No.: 104007  |
Hi all, I'm working on migrating data from an old WMP database and so far I've managed to get all the data I want added as tags in the file metadata. I then used PLayback Statistics > Import statistics from file tags to add this data to the foo_playcount database. This worked great for %play_count%, but not for %added% and %last_played%. For some reason only about 10% of the dates were added correctly (library of about 10,000 mp3 files). The rest just defaulted to today's date. I reset the statics and tried this several times to no avail. Any suggestions? I can't figure out why some of the file data imported correctly while others did not.
 Date added, date last played and play count have been added as tags.  But after import, only play count shows up in playback statistics... |
 |
 
|
|
Oct 21 2012, 20:37
Post
#2
|
|
|
Group: Developer Posts: 646 Joined: 26-September 07 Member No.: 47369 |
The dates have the wrong format. It needs to be YYY-MM-DD hh:mm:ss. A leading zero has to be prepended to single digit values. For example, 2008-9-27 6:38:17 needs to be 2008-09-27 06:38:17
|
|
|
|
|
Oct 21 2012, 23:03
Post
#3
|
|
|
Group: Members Posts: 3 Joined: 21-October 12 Member No.: 104007 |
QUOTE (fbuser @ Oct 21 2012, 21:37)  The dates have the wrong format. It needs to be YYY-MM-DD hh:mm:ss. A leading zero has to be prepended to single digit values. For example, 2008-9-27 6:38:17 needs to be 2008-09-27 06:38:17 Thanks, I wasn't sure about that when I was reformatting everything in excel. I'll let you know if it works! |
|
|
|
|
Oct 22 2012, 05:07
Post
#4
|
|
|
Group: Members Posts: 3 Joined: 21-October 12 Member No.: 104007 |
QUOTE (bobo_bobbins @ Oct 22 2012, 00:03) QUOTE (fbuser @ Oct 21 2012, 21:37) The dates have the wrong format. It needs to be YYY-MM-DD hh:mm:ss. A leading zero has to be prepended to single digit values. For example, 2008-9-27 6:38:17 needs to be 2008-09-27 06:38:17 Thanks, I wasn't sure about that when I was reformatting everything in excel. I'll let you know if it works! Man, that was much more difficult to do in excel than I thought. But it did work. Thanks again fbuser! |
|
|
|
|
|
Lo-Fi Version | Time is now: 20th May 2013 - 04:52 |
