Page 1 of 1

Change The "Added" Date

Posted: Mon Jan 02, 2017 1:48 am
by dypsis
I made a couple of small changes to a couple of tracks outside of MediaMonkey and lost the play data.

I managed to change the Played number using Add-Remove PlayStat, but am I able to also change the Added date to bring the tracks into line with the rest of the tracks on the album?

Re: Change The "Added" Date

Posted: Mon Jan 02, 2017 4:40 am
by Peke
Each change to filenames outside MMW will tell MMW that it is new tracks and thus you loose stats.

Re: Change The "Added" Date

Posted: Tue Jan 03, 2017 1:08 am
by dypsis
Peke wrote:Each change to filenames outside MMW will tell MMW that it is new tracks and thus you loose stats.
Yes, I know I will lose stats. There was a reason why I need to do something outside of MM.

But, my question is: Is there a way to change the Added date?
I was able to change the Play Count. Can I do a similar thing with the Added date? :)

Re: Change The "Added" Date

Posted: Tue Jan 03, 2017 10:06 am
by dtsig
No. I have asked this before and there isn't

Re: Change The "Added" Date

Posted: Tue Jan 03, 2017 10:22 am
by MMFrLife
You can do that with RegExp Find & Replace with something like "assign specified string to <Into Field>" + INTO: Added".
There might be an even better preset (no time to look for one now), but this one works fine. Ask questions about it in that thread.

Re: Change The "Added" Date

Posted: Tue Jan 03, 2017 1:06 pm
by Lowlander
You can use Folder Monitoring while making the changes and MediaMonkey may keep track of the file and thus its stats.

Note that MediaMonkey has various tools to rename files build in and this will prevent stats loss as well.

Re: Change The "Added" Date

Posted: Tue Jan 03, 2017 8:44 pm
by Peke
I think that you can use regex script and there was a direct SQL script which will allow you to change added.

Re: Change The "Added" Date

Posted: Wed Jan 04, 2017 1:38 am
by dypsis
Thanks for your replies, guys.

I will look into RegExp.
@Peke | Are you saying that there is a particular script I can use with it?

Re: Change The "Added" Date

Posted: Wed Jan 04, 2017 2:05 am
by MMFrLife
Peke,
Are you referring to this SQL-Viewer?

Re: Change The "Added" Date

Posted: Wed Jan 04, 2017 8:05 pm
by Peke
Yes MMFrLife, that us the script.

Re: Change The "Added" Date

Posted: Thu Jan 05, 2017 12:53 am
by dypsis
MMFrLife wrote:Peke,
Are you referring to this SQL-Viewer?
I can't work out how to use it. :(

Re: Change The "Added" Date

Posted: Thu Jan 05, 2017 1:05 am
by dypsis
MMFrLife wrote:You can do that with RegExp Find & Replace with something like "assign specified string to <Into Field>" + INTO: Added".
There might be an even better preset (no time to look for one now), but this one works fine. Ask questions about it in that thread.
I might try this if I can work it out. :)

Re: Change The "Added" Date

Posted: Thu Jan 05, 2017 7:21 pm
by Peke
Have you tried with http://www.yunqa.de/delphi/products/sqlitespy/ as it supports MM.DB thru extensions?