This is very simple.A call to WNetGetConnection API returns the UNC name for any drive letter, most drives typically are not mapped.

I've put together a loop that calls a DriveLetterToUNC function on each letter of the alphabet from C to Z,prepares an adequate buffer by creating a string that's MAX_PATH characters long, then passes this string with the buffer length and drive letter to WNetGetConnection.

Your code extracts the UNC name from the buffer by scanning for the first Null character and trimming just before it.

Just to close my question...

I found that when I updated the mapped path to a UNC path using the SQL-Viewer script + the instructions mentioned, the artwork is automatically updated to the UNC path. Thus, there is no extra step(s) required to get artwork to work.

(sidebar)

Ahhh.... I thought play counts and ratings were stored in MP3 files. Using the File Monitor feature in Options somehow bypasses resetting play counts, I presume.

What would be the field names needed to update the artwork path which are linked to the mapped drive?

[quote="davidbspalding"]

I might've missed something as to why you need to edit the database directly. Letting MM manage the tables seems a safer policy (unless you're experienced at SQL queries).[/quote]
Editing the database directly is better in the case where you have previously added tracks to a MM library and don't want to lose library-specific data (playcounts, playlists, etc.) which would be lost by rescanning the library, removing dead links, etc.

Edit the database? :o This seems like a lot of trouble. As per [url=http://www.mediamonkey.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=49]this FAQ on networked drive MM database[/url], I simply changed all entries in mm.ini from e.g. s:\mp3\src\ to \\192.168.1.11\share1\mp3\src\, restarted MM, used Add/Rescan to reinforce the mappings for all tracks (unnecessary from what I could see), then went about my business. I'm using MM 3.2 btw.

I might've missed something as to why you need to edit the database directly. Letting MM manage the tables seems a safer policy (unless you're experienced at SQL queries).

Thanks, I've got it sussed now!

[quote="danhackley"]
What does "add a duplicate test track from the new (UNC) location" mean?
[/quote]
It means to scan a single track from the new location.

This looks like what I need, but I don't understand some of the instructions from John.

John states:

"To find out the new location IDMedia (together with the current IDMedia locator), add a duplicate test track from the new (UNC) location. and run:

Code: Select all
select * from Songs where songtitle = "example song title""

What does "add a duplicate test track from the new (UNC) location" mean?

Would be grateful if someone could explain this in less tehnical language.
Thanks!

Moving things about on a server is a great benefit of a UNC share name. The client won't care if the server moved it from D:\Music to t:\Datashare\Auditory\Music

It only ever sees \\Server\Music.

never knows it moved, and never gives the monkey heartburn. If you have a mapped drive the only problem is sometimes the mapped drives in windows vanish for no apparent reason. Giving the poor monkey an anyerism.

I really hate to bump this thread, but I had some info that will help others in my situation.

For a UNC path, IDMedia is always 1. Hence, moving stuff around between various UNC paths is as simple as running the update statement above with the "replace()" function in there.

I seem to reorganize my stuff every year or so and I end up moving shares around on my server (a WHS) and I always have to dig this thread up because I forget the syntax for the replace command. :lol:

Hi,

I tried to use this instruction in order to use my music collection and MM database on my external HDD connected to a laptop as a copy of my music and database from home network, but got the same problem like moot.point. I can list all the songs by current IDMedia, but when trying to replace the songpath-part it does nothing. But I also tried the ":/" like moot.point suggest, which did not make a difference in my case.. :(

any ideas why this is not working in my situation?

[quote="johnieutah"]
2. Now we know the IDMedia, run the path change query:
[code]update Songs set SongPath = replace(SongPath, "<current location>", "<new location>") WHERE IDMedia = "<current IDMedia>"[/code]
e.g. [code]update Songs set SongPath = replace(SongPath, "M:\", "\\SERVER\Music\") WHERE IDMedia = "63"[/code]

3. Update the IDMedia to the new location for all songs:
[code]update Songs set IDMedia = "<new IDMedia>" WHERE IDMedia = "<old IDMedia>"[/code]

That's it, worked great for me, and obviously useful no matter which locations are changing, whether it's a mapped drive to UNC or vice-versa etc...

Regards, Matt.[/quote]

Hi Matt,

thanks for the detailed instructions! I had only one small issue with the "replace" Query: In the form above it did not alter the paths because MM did not save drive letters in my DB. This may be because the relevant drive was an external USB drive, but either way, MM usually works with the drive IDs not with the letters.

Anyway, it worked fine when I used the above query with <current location> in the form "[b]:\[/b]" rather than "[b]M:\[/b]" (assuming that M was the drive letter previously assigned).

SQLView is a brilliant tool!

Cheers,
Malte

 select * from Songs where songtitle = "example song title"

update Songs set SongPath = replace(SongPath, "<current location>", "<new location>") WHERE IDMedia = "<current IDMedia>"

update Songs set SongPath = replace(SongPath, "M:\", "\\SERVER\Music\") WHERE IDMedia = "63"

update Songs set IDMedia = "<new IDMedia>" WHERE IDMedia = "<old IDMedia>"

[quote="nohitter151"]I believe you can do it with this script: http://www.mediamonkey.com/forum/viewtopic.php?f=2&t=24841 and that there are instructions on how to do it somewhere in the thread.[/quote]

Cheers for that - worked a treat!

Here's the way to do it for anyone else interested. Go to the thread linked to above, download and install SQL Viewer. Back-up your MM DB first before running any of these queries as you don't want to trash your DB and having nothing to go back to!

1. Find out the IDMedia of both the current and new locations. To find out the new location IDMedia (together with the current IDMedia locator), add a duplicate test track from the new (UNC) location. and run:
[code] select * from Songs where songtitle = "example song title"[/code]

2. Now we know the IDMedia, run the path change query:
[code]update Songs set SongPath = replace(SongPath, "<current location>", "<new location>") WHERE IDMedia = "<current IDMedia>"[/code]
e.g. [code]update Songs set SongPath = replace(SongPath, "M:\", "\\SERVER\Music\") WHERE IDMedia = "63"[/code]

3. Update the IDMedia to the new location for all songs:
[code]update Songs set IDMedia = "<new IDMedia>" WHERE IDMedia = "<old IDMedia>"[/code]

That's it, worked great for me, and obviously useful no matter which locations are changing, whether it's a mapped drive to UNC or vice-versa etc...

Regards, Matt.

I believe you can do it with this script: http://www.mediamonkey.com/forum/viewtopic.php?f=2&t=24841 and that there are instructions on how to do it somewhere in the thread.