IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
Importing dates into foo_playcount, trouble getting correct info into %added% and %last_played%
bobo_bobbins
post 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...
Go to the top of the page
+Quote Post
fbuser
post Oct 21 2012, 20:37
Post #2





Group: Developer
Posts: 673
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
Go to the top of the page
+Quote Post
bobo_bobbins
post 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!
Go to the top of the page
+Quote Post
bobo_bobbins
post 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!
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 18th April 2014 - 15:41