venus light wrote:
This looks like an awesome tool. What would be a good resource to
discover how to write different SQL queries on this database?
I'm not super versed on SQL, but am pretty computer-savvy, so I think I
could figure it out if someone pointed me in the right direction.
This looks like an awesome tool. What would be a good resource to
discover how to write different SQL queries on this database?
I'm not super versed on SQL, but am pretty computer-savvy, so I think I
could figure it out if someone pointed me in the right direction.
The pre-sets are great, but
I can confirm that should work on a QNAP
QNAP TS419P 4TB LMS7.7.2
*Living Room* - SB3 - Onkyo TS606 connected Digitally - Celestion
Ditton F20s - and connected Analogue for Zone 2 - Sony TA FE 320 -
Sennheiser RS 130
*Office* - SB3 - Sony TA FE320 - Wharfedale Modus Cubes
*Dining Room* - SB
treefern wrote:
I would like to try your program but I have a problem in that I migrated
my LMS database from WHS 2011 to Linux on QNAP NAS and I cannot get
under the bonnet to get to
/opt/ssods4/var/home/SqueezeboxServer/Cache/library.db.
I guess best option is to copy database to
I would like to try your program but I have a problem in that I migrated
my LMS database from WHS 2011 to Linux on QNAP NAS and I cannot get
under the bonnet to get to
/opt/ssods4/var/home/SqueezeboxServer/Cache/library.db.
I guess best option is to copy database to windows and run the program.
stereoptic wrote:
Is there a flag that indicates which contributor is the album artist?
I don't have the schema in front of me, but I think there is a role
field in the contributor_album table. Try adding another filter on the
WHERE clause: AND co.role = 1.
Here are the contributor roles:
1 Artist
2 Composer
3 Conductor
4 Band
5 Album Artist
6 Track Artist
They may be a little difficult to use in a single query, however, unless
you've tagged every album with an explicit album artist. Otherwise, the
defacto album artist for an album will have a
Thanks guys. I'll give that a try when I get home.
stereoptic's Profile: http://forums.slimdevices.com/member.php?userid=53162
View this thread: http://forums.slimdevices.com/showthread.php?t=101600
Dogberry2 wrote:
I think something kinda like this should get you started:...
Thanks for taking the time for that! I'll give it a try!
stereoptic's Profile: http://forums.slimdevices.com/member.php?userid=53162
View
I need to brush up on my SQL.
What would be an example of listing the albumname, the sort album name ,
album artist and sort album artist from the albums (?) table?
I would be using the database query function in LMS, I don't have any
other SQL loaded on this PC right now.
Thanks!
stereoptic wrote:
I need to brush up on my SQL.
What would be an example of listing the albumname, the sort album name ,
album artist and sort album artist from the albums (?) table?
I would be using the database query function in LMS, I don't have any
other SQL loaded on this PC right
Dogberry2 wrote:
I don't know about MP3Tag's Export configurations, so I can't answer
that. It seems that to sort and filter the data, MP3Tag would first have
to read all the track files and build its own internal database from the
tags. Since LMS has already scanned the track tags and built
For a while I've been periodically extracting the LMS db tables (to CSV
format) using sqlite3.exe before importing them into Access (which I am
more familiar with). However, before I do that I always clear the cache
and do a complete rescan to ensure that all the data in the db is live
and
JohnB wrote:
For a while I've been periodically extracting the LMS db tables using
sqlite3.exe before importing them into Access (which I am more familiar
with). However, before I do that I always clear the cache and do a
complete rescan to ensure that all the data in the db is live and
JJZolx wrote:
Does this do anything that Mp3tag's Export configurations can't do?
I don't know about MP3Tag's Export configurations, so I can't answer
that. It seems that to sort and filter the data, MP3Tag would first have
to read all the track files and build its own internal database from
get.amped wrote:
I thought it might be useful to know the table structures. Here's some
screen shots from SQLite Expert:
Nice of you to post those shots. There used to be some basic table
structure info in the Wiki, but that was from back in the MySQL days,
and I'm sure nothing has been
amey01 wrote:
Frikin' awesome. Works perfectly. Thank you!
You're welcome! I'm glad to hear it's of some use to other people.
I hope anyone who has a cool query will share it, maybe by posting it in
this thread, so others can make use of it. Everybody has their own
ideas/needs/approaches to
I thought it might be useful to know the table structures. Here's some
screen shots from SQLite Expert:
15973
15974
15975
15976
15977
More in next post (5 image/post limit)
+---+
|Filename: contributors.jpg
15978
15979
15980
15981
15982
continued in next post...
+---+
|Filename: metainformation.jpg |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=15982|
15983
15984
15985
15986
15987
continued and completed in next post...
+---+
|Filename: scanned_files.jpg|
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=15987|
15988
15989
15990
15991
That's all folks!
Of course, there are other database files. Not sure how much more value
there is in querying them.
+---+
|Filename: years.jpg|
Does this do anything that Mp3tag's Export configurations can't do?
One thing about working directly with LMS' data is that you have to work
around the shortcomings of the LMS database and LMS quirky scanning
logic. If you've witnessed the struggles they've had over the years
doing (what you
JJZolx wrote:
Does this do anything that Mp3tag's Export configurations can't do?
One thing about working directly with LMS' data is that you have to work
around the shortcomings of the LMS database and LMS quirky scanning
logic. If you've witnessed the struggles they've had over the years
get.amped wrote:
I wonder if/when mp3tag chokes on the number of entries? I'm not sure it
how it will handle 300K+ tracks...
Dont know but I've had 225,000 tracks selected in mp3tag...
*Location 1:* VortexBox 4TB (2.2) LMS 7.8 Transporter, Touch, Boom,
Radio w/Battery (all ethernet
Frikin' awesome. Works perfectly. Thank you!
amey01's Profile: http://forums.slimdevices.com/member.php?userid=11274
View this thread: http://forums.slimdevices.com/showthread.php?t=101600
Audiotic wrote:
OK, I'll run it in Parallels :-)
Great initiative!
Thanks. Hope it runs OK for you in Parallels.
Dogberry2's Profile: http://forums.slimdevices.com/member.php?userid=18883
View this thread:
I've installed and tried your extractor - simple and speedy.
I know nothing about SQL so I used your built-in queries.
However to be of use to me, I would have to either have you change a
couple of basic things in the queries, have you tell me how to do it
myself or I need to learn SQL.
usbethjim wrote:
_Here's_the_thing_-_Every_album_I_have_has_an_\ARTIST_SORT\_tag:_
Bob Dylan's is Dylan, Bob - he show's up in the D's not the B's as
Bob Dylan in LMS listings.
Led Zeppelin's is Led Zeppelin - they show up in the L's as Led
Zeppelin in LMS listings.
So any SQL query
Thank you for this. It works well and makes the whole SQL query thing a
lot less intimidating.
Apesbrain's Profile: http://forums.slimdevices.com/member.php?userid=738
View this thread:
Sometime a little nudge is what we need :)
I had been meaning to install and get familiar with SQLite Expert but
have found any number of reasons not to. But when I decided to try LMS
Extractor it was immediately obvious that I would need something to
reveal the table structures if I wanted to
stupid question. How do I create a new SQL extract. I wanted to try the
one above, but when I copy it I can't seem to paste it into one of the
SQL extract windows in the program. I can paste it into a text document,
not into the LMS extractor appropriate window.
*Location 1:* VortexBox 4TB
garym wrote:
stupid question. How do I create a new SQL extract. I wanted to try the
one above, but when I copy it I can't seem to paste it into one of the
SQL extract windows in the program. I can paste it into a text document,
not into the LMS extractor appropriate window (i.e., the window
garym wrote:
stupid question. How do I create a new SQL extract. I wanted to try the
one above, but when I copy it I can't seem to paste it into one of the
SQL extract windows in the program. I can paste it into a text document,
not into the LMS extractor appropriate window (i.e., the window
get.amped wrote:
Sometime a little nudge is what we need :)
I had been meaning to install and get familiar with SQLite Expert but
have found any number of reasons not to. But when I decided to try LMS
Extractor it was immediately obvious that I would need something to
reveal the table
I said it was stupid. ;-)
I forgot to try Ctrl-V (which worked perfectly).
(I was simply trying to right click my mouse to get the popup menu
containing paste.
get.amped's extract works nicely (I too like to see the genre and file
type). Only odd thing I noticed in running this extract was
garym wrote:
I said it was stupid. ;-)
I forgot to try Ctrl-V (which worked perfectly).
(I was simply trying to right click my mouse to get the popup menu
containing paste.
get.amped's extract works nicely (I too like to see the genre and file
type). Only odd thing I noticed in
garym wrote:
I said it was stupid. ;-)
I forgot to try Ctrl-V (which worked perfectly).
(I was simply trying to right click my mouse to get the popup menu
containing paste.
get.amped's extract works nicely (I too like to see the genre and file
type). Only odd thing I noticed in
Replace the last line with:
ORDER BY UPPER(Artist), UPPER(Album Title)
Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS
7.7.3 - Logitech Squeezebox Classic V.3 - Cambridge Audio DacMagic -
NAD C160 - 2 x NAD C272 - Quad 22L2
get.amped wrote:
Replace the last line with:
ORDER BY UPPER(Artist), UPPER(Album Title)
works perfectly thanks. Now I'm trying to understand why it shows more
than one listing per album (other than the fact that there are multiple
disks, which I understand). For example, on a Bob Dylan
garym wrote:
works perfectly thanks. Now I'm trying to understand why it shows more
than one listing per album (other than the fact that there are multiple
disks, which I understand). For example, on a Bob Dylan tribute
compilation (4 CDs), it shows a listing of 8 albums. For the other
get.amped wrote:
Probably has something to do with my cheat of pulling the genre, codec
and bitrate from the the first track of the album. I was reasonably sure
that wouldn't be an issue in my database because I don't use any disc
numbering tags. For example, AC/DC - Live (Collector's
garym wrote:
I've narrowed it down a bit. This only seems to happen on a compilation
where it is multidisk and there is an ALBUM ARTIST entered. And it
exactly doubles the number of albums listed. Most of my compilations
have ALBUM ARTIST blank. Note that the Genre, ALBUM ARTIST, codec,
Nice. But in what language is it written, i.e. can it be made to run on
a Mac as well?
MacMini CoreDuo, 600 GB of mostly ALAC lossless music (iTunes ripped) -
Black Transporter (analog digital out), and Marantz DV8400 vM mod for
SACD + DVD-A, via Siltech Paris to Harman Kardon AVR 8500 HK
Audiotic wrote:
Nice. But in what language is it written, i.e. can it be made to run on
a Mac as well?
Well, as I said up front, the way it stands for now it's gonna have to
be strictly a Windows program. I threw it together using the compiler I
had available at the company I work for, during
get.amped wrote:
So for those compilations, what is displayed in the Artist column?
ALBUM ARTIST is displayed in artist column (in this case Bob Dylan). And
in this case Bob Dylan is also the composer but is not track artist.
(and I've NOT ticked composer or conductor or band/orchestra to
OK, I'll run it in Parallels :-)
Great initiative!
MacMini CoreDuo, 600 GB of mostly ALAC lossless music (iTunes ripped) -
Black Transporter (analog digital out), and Marantz DV8400 vM mod for
SACD + DVD-A, via Siltech Paris to Harman Kardon AVR 8500 HK PA2200
Signature - 6 x Mission 780SE
garym wrote:
ALBUM ARTIST is displayed in artist column (in this case Bob Dylan). And
in this case Bob Dylan is also the composer but is not track artist.
(and I've NOT ticked composer or conductor or band/orchestra to show up
in artists in my LMS Settings.
I can't say I'm surprised that
Dogberry2 wrote:
Let me know if you have problems installing or using it (or even if you
don't have problems).
Hi,
qtintf70.dll is missing:confused:
Gruss
Jan
DJanGo's Profile:
DJanGo wrote:
Hi,
:confused:My apologies. Please re-download the .zip file and try again.
Should be
OK now.
Dogberry2's Profile: http://forums.slimdevices.com/member.php?userid=18883
View this thread:
I decided to put together a little program to extract data from the LMS
database and put it out in some useful formats. Specifically, it can
create HTML pages, Excel spreadsheets and comma-separated-value (CSV)
files suitable for loading into other spreadsheet or database-type
software.
This
Here are a couple of sample HTML pages created by LMS Extractor. These
are just simple examples; you can extract any data you want to see.
http://thecosyns.com/lms/albums.html
http://thecosyns.com/lms/playlistnames.html
Very nice. Looking forward to taking it for a test drive.
Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS
7.7.3 - Logitech Squeezebox Classic V.3 - Cambridge Audio DacMagic -
NAD C160 - 2 x NAD C272 - Quad 22L2
52 matches
Mail list logo
