Hi, Something I just came across: If you sync multiple albums with the same name, only the last album art is retained. For example: I was syncing a random playlist and by chance it had albums with the name of Everest by three different artists: - Chris Barber, Lonnie Donegan - Cisco Houston - Everes...

Drakinite my friend are a godsend!

Your solution worked. You have saved me month's of work! TYVM....if we every have the opportunity to meet, there's a beer in your hand !

Each song potentially has a different composer.

I have a spreadsheet that I extracted from my MM4 database. From that spreadsheet, I can create the Update statement which I then copy into an MM5 addon which will in turn update the MM5 database.

I have 7000 records to update. If I can automate this...it'll take seconds....otherwise, it's a months worth of effort.

ping

Hi Ludek, Thanks for the suggestions. The code doesn't work: For example, I have the following function calls: UpdateAuthor('SELECT * FROM Songs WHERE SongPath = ":\\Music\\Music Collection\\Classical\\S\\String Quartet Tribute To Rush\\Exit...Stage Right\\01 - The Spirit Of Radio.mp3"',&q...

Hi, Before I move songs into my collection, I store them in a separate folder where I can massage the metadata. Once done, I press CTRL+R to open the Auto-organize screen, where I can review the new path. To see the full path I have resized the columns which extend beyond the screen size. I've notic...

When I have a file listing sorted by: 1) Album 2) Title And then decide that I want to change the sorting to: 1) Album 2) Track # If I click on Album, I expect it to maintain the current sort on the Album and just remove the Title sort so that I can select Track #. Instead it removes the Title sort ...

Ok, so this is my latest effort....still no results. I created a separate function and I'm passing it the SQL and the author. Sometimes they update with the correct author...sometimes they only update the author of the last value, sometimes only the last row is updated. I know the problem is with th...

Good news, to escape the apostrophe use a backslash in front of it.

Ok, so now just need to figure out how to wait for the commitasync to complete before processing the next command.

Progress....at a snails pace is slow and tiresome...but progress.

I have both good news and not so good news. The good news: escaping the backslashes works. The not so good news: 1) Escaping the apostrophe doesn't work 2) I have 7,000 records to update...running the script one after the other such as this only updates the last row. var trcklist; trcklist = app.db....

Hi Ludek, Thanks for the suggestion. I've been working with the code this morning and have determined that the app.db.getTracklist never returns a result set, yet, if I run the SQL in the editor it does return a row. this is my code: var trcklist; trcklist = app.db.getTracklist('SELECT * FROM Songs ...

Hi, I just realized that I did a major foopa with my Clear Fields add-on. I ran the script against my classical music and it removed the composer (author) values. Oops! Now, I have an old MM4 backup that I can use to repopulate the fields. I have extracted the values using SQL Lite and have created ...

Thanks guys. I was concerned with the spacing so I had copied/pasted the artists name. Currently I'm using 5.0.2.2531; I'll wait for the next official release as I have customized MM pretty heavily and it's a pain to reconfigure all the time.

Hi,
In my collection I have a number of songs by the artist: J.T. Brown.
When I use the search box with the criteria of: "J.T. Brown" in quotes, I receive no results. When I remove the quotes it works just fine.

Not sure if this is the expected behavior.