Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Download and get help for different MediaMonkey for Windows 4 Addons.

Moderators: Peke, Gurus

MoDementia
Posts: 1321
Joined: Thu Jun 15, 2006 3:26 pm
Location: Geelong, Victoria, Australia

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by MoDementia »

Importing does not change the path/filename but if the full export had the incorrect path/filename then, if auto organise was set to organise automatically, then updating a playcount would trigger the movement.

i.e. I don't believe the original FULL export for the laptop had the correct path/filename initially, the information was for the USB stick not the laptop :(

If you do not have auto organise to automatically organise tracks then it is something else (and I can't think what because it doesn't change path/filename (except for FULL export) or move tracks (new tracks are only copied on sync export)

Redo the *.txt info export (laptop) and load *.txt (main PC) before doing another FULL export to replace the laptop database (and fix this problem)

Try and play a few tracks and check the path/filenames on the laptop after this (with the USB stick unconnected) to make sure all is good before trying another import.
RobSpook
Posts: 28
Joined: Wed Oct 15, 2008 12:10 am

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by RobSpook »

I figured out why the tracks were being copied to my stick on the laptop (F:\My Music)...

Apparently, when I do a full database export on my PC, and then replace the MM.DB file on my laptop, the auto-organize rule gets changed on the laptop. I verified this today.

I checked the auto-organize rule on the laptop before replacing MM.DB and the directory was C:\DOCUMENT AND SETTINGS\...\MY MUSIC\...
After replacing the MM.DB file I started up MediaMonkey and checked the auto-organize options, and sure enough the directory was changed to F:\MY MUSIC\... which is the hard drive on my PC where files get auto-organized. F: also happens to be the drive letter for my memory stick when attached to the laptop.

The EXPORT settings in DEI sync on my PC are all correct. Do the EXPORT settings on my laptop need to be filled in for doing exportsync?

I really see the potential here, but am having trouble implementing it. I am going to try to use SYNCBACK to keep the laptop (C:\DOCUMENTS AND SETTINGS\ROB\MY DOCUMENTS\MY MUSIC) synced to the PC music folder (F:\MY MUSIC) every time the laptop connects to my home network.

BTW - I am using DEISYnc 2.2.
MoDementia
Posts: 1321
Joined: Thu Jun 15, 2006 3:26 pm
Location: Geelong, Victoria, Australia

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by MoDementia »

RobSpook wrote:I figured out why the tracks were being copied to my stick on the laptop (F:\My Music)...

Apparently, when I do a full database export on my PC, and then replace the MM.DB file on my laptop, the auto-organize rule gets changed on the laptop. I verified this today.

I checked the auto-organize rule on the laptop before replacing MM.DB and the directory was C:\DOCUMENT AND SETTINGS\...\MY MUSIC\...
After replacing the MM.DB file I started up MediaMonkey and checked the auto-organize options, and sure enough the directory was changed to F:\MY MUSIC\... which is the hard drive on my PC where files get auto-organized. F: also happens to be the drive letter for my memory stick when attached to the laptop.
Well that makes sense, I don't have auto-organise set to auto, for some of the reasons as exhibited here :(
I didn't realise some of the information is stored in the database, I would have assumed it would be in the mediamonkey.ini
I will check over the weekend and release a fix. Depending what the data looks like I may have to just remove it rather than converting it. will have to wait and see/
Very sorry about the trouble it has caused, this is the first time it has been reported :(
RobSpook wrote:The EXPORT settings in DEI sync on my PC are all correct. Do the EXPORT settings on my laptop need to be filled in for doing exportsync?
No, the export sync doesn't need to know path/filename locations to work.
But I think it might need the first directory to be selected?
RobSpook
Posts: 28
Joined: Wed Oct 15, 2008 12:10 am

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by RobSpook »

Hey Mo,

Thanks for the response! I downloaded and installed version 2.3.5. I think I like the network options much better. It really works well, except for one thing. Doing it the old way with exportsync and importsync, you coul dsee in the log file how it updated everything individually, playcount, playdate, etc... but in the networksync log screen, you only see the play date being changed.

I followed your advice, which was to run the script on the device that has the most changes. In my situation, when I get ready to leave town I will connect the laptop to the network and run a syncback to sync the music folders and then perform DEI networksync (on the laptop!). When I return from my trip, I will again connect the laptop to the network, but this time run DEI networksync on the PC.

In testing this concept, I got both DB's in sync, and then plugged in my ipod on my pc because I played over 60 songs today. I connected the laptop, ran syncback which deleted five or six files from the laptop, and then ran DEIsync networksync on the laptop. All the last played dates/times were updated, but not the play counter.

You've outdone yourself with this network sync... it's fantastic. You need to get a "Donate with Paypal" button!

Oh, BTW - I turned off auto-organize onthe laptop. There's no sense changing files on something that should only be a mirror of the PC. No more organizing or volume leveling on the laptop!
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by nynaevelan »

RobSpook wrote:
You need to get a "Donate with Paypal" button!
I AGREE!! :D 8)

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files
MoDementia
Posts: 1321
Joined: Thu Jun 15, 2006 3:26 pm
Location: Geelong, Victoria, Australia

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by MoDementia »

RobSpook wrote: In testing this concept, I got both DB's in sync, and then plugged in my ipod on my pc because I played over 60 songs today. I connected the laptop, ran syncback which deleted five or six files from the laptop, and then ran DEIsync networksync on the laptop. All the last played dates/times were updated, but not the play counter.
The play counter works from the played table which iPod syncing dosen't update :(

I am working with Bex and Nyn on Add/Remove PlayStat 1.1.1 (2008-10-09) [MM3] which should almost 1 button fix the ipod plays after a sync which will make my personal use of the network sync almost perfect :)
I will also be able to test it myself and bring it out of beta sooner rather than later.

So to sum up, if you get your played in sync with your playcounts, see the other script for how to do it (combined with tagging inconsistencies) the network sync will also update the playcounts.

Your other comments are most welcome, thanks. Paypal, Bah, if I didn't like doing it I wouldn't :P
MoDementia
Posts: 1321
Joined: Thu Jun 15, 2006 3:26 pm
Location: Geelong, Victoria, Australia

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by MoDementia »

nynaevelan wrote:
RobSpook wrote:
You need to get a "Donate with Paypal" button!
I AGREE!! :D 8)

Nyn
I think it would send Nyn bankrupt :P
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by nynaevelan »

MoDementia wrote:
I think it would send Nyn bankrupt :P
:lol: :lol: Or close to it, I do like to support my favorite programs....

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files
RobSpook
Posts: 28
Joined: Wed Oct 15, 2008 12:10 am

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by RobSpook »

MoDementia wrote:So to sum up, if you get your played in sync with your playcounts, see the other script for how to do it (combined with tagging inconsistencies) the network sync will also update the playcounts.
Hmm, interesting thoughts here. I did add add/remove play stats to fix some last played times with my kids recorded radio shows. Some of these episodes are multi-part ones, so I wanted the last played date/time to be in order so that when they come up in the playlist again they are in the proper order. Now you've given me another use for that script, but even after reading all four pages of the ARPS forum, I don't understand exactly HOW to get the "played" in sync with "playcounts", and I didn't read anything at all about tagging inconsistencies. Would it be difficult to explain this to me? Is it feasible to do this for a library of about 4000 tracks?

What i really don't understand quite yet is these terms. We've mentioned Played, Playcounts, and played tables. When using MM with my 1st gen iPod Nano, after every sync the playcount column increments appropriately along with the last played date/time. What is MM not getting correctly from the iPod? Is it the list of time/dates of all plays? I'm sorry if i'm being dense, but there is something I'm missing here!

Thanks again for the wonderful scripts!
MoDementia
Posts: 1321
Joined: Thu Jun 15, 2006 3:26 pm
Location: Geelong, Victoria, Australia

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by MoDementia »

Yes there is a seperate table that stores all last played dates per track, the playcount is supposed to be the sum of these individual entries
But as the iPod doesn't add to the table the history of plays is out of sync with the playcount you can see.

Played table
track1 30-10-2008 15:03
track1 30-10-2008 17:42
track1 30-10-2008 18:32
track2 27-10-2008 11:07
track2 28-10-2008 12:15
etc

Songs Table
Track 1 30-10-2008 18:32 count = 3
Track2 28-10-2008 12:15 count = 2

The ipod updates the songs table but not the Played table :(
I really haven't used the ARPS script much ( i just write a cheap and nasty script to fix mine :) )
But I'm sure Bex or someone (Nyn :wink: ) can give you a quick run down on how to use it in it's thread :lol:
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by nynaevelan »

RobSpook wrote:
MoDementia wrote:So to sum up, if you get your played in sync with your playcounts, see the other script for how to do it (combined with tagging inconsistencies) the network sync will also update the playcounts.
Hmm, interesting thoughts here. I did add add/remove play stats to fix some last played times with my kids recorded radio shows. Some of these episodes are multi-part ones, so I wanted the last played date/time to be in order so that when they come up in the playlist again they are in the proper order. Now you've given me another use for that script, but even after reading all four pages of the ARPS forum, I don't understand exactly HOW to get the "played" in sync with "playcounts", and I didn't read anything at all about tagging inconsistencies. Would it be difficult to explain this to me? Is it feasible to do this for a library of about 4000 tracks?

What i really don't understand quite yet is these terms. We've mentioned Played, Playcounts, and played tables. When using MM with my 1st gen iPod Nano, after every sync the playcount column increments appropriately along with the last played date/time. What is MM not getting correctly from the iPod? Is it the list of time/dates of all plays? I'm sorry if i'm being dense, but there is something I'm missing here!

Thanks again for the wonderful scripts!
Well since my name was mentioned I'll give you a rundown on how I use it. These are the steps which I take since my player does not update any dates. I use this on a daily basis so I can pretty much keep the dates how I want them:

1. Adjust playcounts/dates of tracks which I listened to since last sync, I listen by playlists so this step is really easy for me
2. Sync player to MM
3. Run the Tracks With node of the Tagging Inconsistencies script
4. Select the More Playcounts...node, expand it based on the number of playhistory discrepancies
5. Select all the tracks in the node and Use the Add One Play, Timestamp X section of the Add/Remove Playstats script
6. For any tracks which have more than 1 discrepancy, I use the Add Plays section of the ARPS script, this section I use the DateAdded to library for the start date and create the individual plays based on that info. This one is rare since I usually will jump the plays to what they should be with the script before I perform a sync of my player.

This script is also used to fix my playcounts/histories when I have a crash of MM. Hope this info helps...

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files
RobSpook
Posts: 28
Joined: Wed Oct 15, 2008 12:10 am

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by RobSpook »

nynaevelan wrote:1. Adjust playcounts/dates of tracks which I listened to since last sync, I listen by playlists so this step is really easy for me
2. Sync player to MM
3. Run the Tracks With node of the Tagging Inconsistencies script
4. Select the More Playcounts...node, expand it based on the number of playhistory discrepancies
5. Select all the tracks in the node and Use the Add One Play, Timestamp X section of the Add/Remove Playstats script
6. For any tracks which have more than 1 discrepancy, I use the Add Plays section of the ARPS script, this section I use the DateAdded to library for the start date and create the individual plays based on that info. This one is rare since I usually will jump the plays to what they should be with the script before I perform a sync of my player.

This script is also used to fix my playcounts/histories when I have a crash of MM. Hope this info helps...
All I can say is: Image

I was looking through Christophs' Fake Play script and was very excited until I read Moe's post's at the end of the topic about how it won't work correctly with iPods... darn.
I was then looking though the Christoph's MM-Helper topic until his very last past which said something like "I forgot to add this..." in regards to ipod counts... DARN!

Look's like I'm going to have to go with Tagging Inconsistencies and using those handy nodes. I don't think it'll take as much work as your setup there because my ipod does update the play counts and last played dates in at least one place, so hopefully ARPS can be my quick fix now... I should only have to do a quick fix-up after each sync of the iPod I guess... not too bad.

Thanks for all the help! And whoever comes up with the ultimate "Fix PlayCounts/HistoryPlays after iPod Sync" script is going to get my utmost gratitude forever and a big man-hug lol
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by nynaevelan »

RobSpook wrote:
I was looking through Christophs' Fake Play script and was very excited until I read Moe's post's at the end of the topic about how it won't work correctly with iPods... darn.
I was then looking though the Christoph's MM-Helper topic until his very last past which said something like "I forgot to add this..." in regards to ipod counts... DARN!
I used to use this one but there was no control of the dates which were used and it used the same dates/times for all the tracks in that particular group. Which led me to alot of tracks with the same lastplayed date. :x But Bex added a node to the TI script which helped me identify those tracks and I used ARPS to change them.
RobSpook wrote:Look's like I'm going to have to go with Tagging Inconsistencies and using those handy nodes. I don't think it'll take as much work as your setup there because my ipod does update the play counts and last played dates in at least one place, so hopefully ARPS can be my quick fix now... I should only have to do a quick fix-up after each sync of the iPod I guess... not too bad.
Once you fix them the first time, the process will be much smoother and quicker the next time. But that may depend on how often you fix the discrepancies. I usually run TI at the end of the week or after I've added alot of (more than 50) tracks to my library, so my adjustments are minimal. Have I mentioned I am ANAL about keeping my db in pristine shape, especially since there are so many great scripts to help me accomplish this?? :wink:
RobSpook wrote:Thanks for all the help! And whoever comes up with the ultimate "Fix PlayCounts/HistoryPlays after iPod Sync" script is going to get my utmost gratitude forever and a big man-hug lol
I too am looking forward to this one because if it can make the process one step closer, I will be eternally grateful.

And one day I will convince MoDementia, Bex and Onenonynous to create donation pages so I can show some monetary support. :wink: :D

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files
RobSpook
Posts: 28
Joined: Wed Oct 15, 2008 12:10 am

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by RobSpook »

nynaevelan wrote:I used to use this one but there was no control of the dates which were used and it used the same dates/times for all the tracks in that particular group. Which led me to alot of tracks with the same lastplayed date. :x But Bex added a node to the TI script which helped me identify those tracks and I used ARPS to change them.
Okay, off DEISync again, but it doesn't make sense to converse through thee topics when the ultimate goal here is make NetworkSync keep accurate playcounts (don't give a hoot about playhistory personally)...

Since you said you used that simple FakePlay script, and you had lots of tracks with the same last played date... That's because your device didn't update the "Last Played Date" right? So with my iPod which DOES update the last played date (but not in HistoryPlays apparently) then this script will essentially do what I want right? Here's another of my favorite icons which accurately depicts my situation now: Image

BTW your signature block is like a quick reference for scripts... :)
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: Database Export\Import\Sync(DEISync) v2.3.5 (09-10-08) [MM3]

Post by nynaevelan »

RobSpook wrote:
Okay, off DEISync again, but it doesn't make sense to converse through thee topics when the ultimate goal here is make NetworkSync keep accurate playcounts (don't give a hoot about playhistory personally)...
True but I've been toooo lazy to try out the NetworkSync in "live" situations. The exportsync/importsync options work well for me and I am comfortable with them.... :-?
RobSpook wrote:Since you said you used that simple FakePlay script, and you had lots of tracks with the same last played date... That's because your device didn't update the "Last Played Date" right? So with my iPod which DOES update the last played date (but not in HistoryPlays apparently) then this script will essentially do what I want right? Here's another of my favorite icons which accurately depicts my situation now: Image
Yes that's right and playhistory is important to me because I build playlists based on it. I also like to track the stats to see where my interests lie.... I love that pic, that is exactly how I feel at times. :D
RobSpook wrote:BTW your signature block is like a quick reference for scripts... :)
As you see I use a lot of scripts and I LOVE how they make my MM experience so much more enjoyable. My sigee is also an indication as MoD stated that I will be broke by the time I donate to all those scripters, luckily I use multiple scripts from the same scripter.... :wink:

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files
Post Reply