Update Location of Files in Database 1.3 (2012-06-12) [MM2+]

Post a reply

Visual Confirmation

To prevent automated access and spam, you are required to confirm that you are human. Please place a check mark next to all images of monkeys or apes. If you cannot see any images, please contact the Board Administrator.

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: Update Location of Files in Database 1.3 (2012-06-12) [MM2+]

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by chrisjj » Sat Jul 19, 2014 2:24 pm

Ah, that could definitely explain it. Thanks.

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by ZvezdanD » Sat Jul 19, 2014 1:53 pm

chrisjj wrote:I didn't knowingly specify a folder and can't see how anything that would autoselect it.

Usage excerpt: "Select some missing file with the old drive/path in the main tracklist or select missing drive/folder in the Location or My Computer branch of the tree panel and choose "Update Location of Files in Database..." from the Tools | Scripts menu, then in the new dialog box select the new path. The old drive/path could be set in the mentioned dialog box as well."

In another words, the Old drive/path was auto-select to the same drive/path of the file that you have selected in the main filelist.

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by chrisjj » Sat Jul 19, 2014 1:37 pm

ZvezdanD wrote:In your first and second screenshots you have specified some folders and because of that you didn't get all files from that drive for update


Ah! Thanks for spotting that! I didn't knowingly specify a folder and can't see how anything that would autoselect it. Next time I take take to check the selection before Update. Thanks!

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by ZvezdanD » Sat Jul 19, 2014 12:17 am

chrisjj wrote:Hi Z. You might like to know the V1.4 script had trouble finding the ~22K source files. But running it again twice did eventually get them all.

Is it possible the scan is happening in the background, and not finished?

Yes, the scan for existing files is running in the background, so you could use the other controls from the dialog during scan (even the Update button). Here is the excerpt from the Usage section of the first post of this thread:
"If you want to update location only for files which exist at the new specified location you should turn on the Update paths in database only for files that exist at new location option. In that case you should wait for the add-on to finish with search for files before you click on the Update button. However, if you turn that option off, you could click on the Update button immediately after you specify the old and new paths."

However, it seems that you are missing another important behavior of this add-on which I explained somewhere in this thread. You could specify not only the root of some drive for update, but also some base folder. That means that you could update only files from the specified folder and all its sub-folders.

In your first and second screenshots you have specified some folders and because of that you didn't get all files from that drive for update, but only files from the specified folders and their sub-folders. In the third screenshot you have selected the root of drive and then you got all files from that drive accordingly.

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by chrisjj » Thu Jul 17, 2014 1:51 pm

Hi Z. You might like to know the V1.4 script had trouble finding the ~22K source files. But running it again twice did eventually get them all.

Is it possible the scan is happening in the background, and not finished?

Image

Image

Image

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by chrisjj » Sun Jul 06, 2014 9:47 am

ZvezdanD wrote:The list of tracks placed in Now Playing panel is not stored in the database


Thanks. Suggestion: make the docs tell the user what file references are and are not handled by this addon. Considering that neither the addon nor Mediamonkey itself tells the user what files are "stored in the database".

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by chrisjj » Sun Jul 06, 2014 9:00 am

nohitter151 wrote:
chrisjj wrote:Are you suggesting Now Playing tracks are not stored in the database?

Not always.


Ah, thanks.

nohitter151 wrote:Surely you know that you can play a track without it being in the database.


No. But I can believe it in the case of MM. Normally I'd expect a track in Now Playing would go into the database, but MediaMonkey scatters its storage all over the shop.

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by ZvezdanD » Sun Jul 06, 2014 8:47 am

chrisjj wrote:Are you suggesting Now Playing tracks are not stored in the database?

The list of tracks placed in Now Playing panel is not stored in the database, but in the mediamonkey.m3u file that is located in the same folder with the DB file.

Update of paths of files in that file could be done using Export/Create Playlists add-on with its "Export M3U Playlists in Child Nodes to Same Folders" command applied to the corresponding M3U node from the My Computer branch with previously adjusted "Replace - Paths in playlist files" option.

However, since that that file is located in system folder that is not visible in the Media Tree of MediaMonkey, it would be necessary to copy it first to some temporary folder using Windows Explorer or Total Commander with checked option to show content of system folders and after modification with the mentioned add-on it should be copied back to MediaMonkey DB folder (in MM4 and XP it is c:\Documents and Settings\user_name\Application Data\MediaMonkey\)

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by nohitter151 » Sun Jul 06, 2014 8:32 am

chrisjj wrote:
ZvezdanD wrote:. You know that the name of this add-on is "Update Location of Files in Database", right?


I do. Are you suggesting Now Playing tracks are not stored in the database?

Not always. Surely you know that you can play a track without it being in the database.

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by chrisjj » Sun Jul 06, 2014 7:11 am

ZvezdanD wrote:. You know that the name of this add-on is "Update Location of Files in Database", right?


I do. Are you suggesting Now Playing tracks are not stored in the database?

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by ZvezdanD » Sat Jul 05, 2014 7:49 am

chrisjj wrote:"files in Songs, Playlists or SynchLocation" is a target set Does it include files in Now Playing?

Location of files in Now Playing will be updated if they are already stored in the database into mentioned tables. You know that the name of this add-on is "Update Location of Files in Database", right?

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by chrisjj » Sat Jul 05, 2014 7:41 am

"files in Songs, Playlists or SynchLocation" is a target set Does it include files in Now Playing?

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by ZvezdanD » Sat Jul 05, 2014 7:38 am

chrisjj wrote:does that target set include Now Playing?

I don't understand what you want to ask.

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by chrisjj » Sat Jul 05, 2014 6:57 am

OK, thanks.

BTW, does that target set include Now Playing?

Re: Update Location of Files in Database 1.3 (2012-06-12) [M

Post by ZvezdanD » Sat Jul 05, 2014 1:47 am

chrisjj wrote:how come only two drives are shown?

Only drives that have files in Songs, Playlists or SynchLocation tables are shown:
Code: Select all
SELECT SerialNumber, CASE WHEN DriveLetter IS NOT NULL THEN SubStr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', DriveLetter + 1, 1) ELSE 'net/url' END AS DrvLetter,
(SELECT Count(*) FROM Songs WHERE Songs.IDMedia = Medias.IDMedia COLLATE NOCASE) +
(SELECT Count(*) FROM Playlists WHERE Playlists.srcMedia = Medias.IDMedia COLLATE NOCASE) +
(SELECT Count(*) FROM SynchLocation WHERE SynchLocation.IDMedia = Medias.IDMedia COLLATE NOCASE) AS NumberOfFiles
FROM Medias

Top

cron