Re: [slim] SiriusXM Support Through ickStream

2015-11-04 Thread Ikabob

PRGeno wrote: 
> You could always just cancel in November and wait awhile if your only
> use for SiriusXM is through your Squeezeboxes.  You will get inundated
> with special offers from SiriusXM to come back at next to nothing for
> 5-6 months which you can take advantage of if/when this issue gets
> resolved.

This is exactly what I did today. Effective November 14, no more Sirius
XM for me. I explained the circumstances of the cancellation and the
representative was sympathetic to my plight. She did indicate that if
there were a change in the status, perhaps I would be hearing from
them.
To me, SiriusXM was worth the subscription fee and I'll miss many of the
stations. I'm hoping the issue will be fixed soon.
Thank you.



Ikabob


Squeezebox Touch w/LMS V7.7.3; Benchmark DAC1 USB;Marantz Pre-amp; SAE
Amplifier;ESS Heil Speakers(main listening speakers plus various
additional speakers). 
Multiple players: SqueezeBooms,SqueezeRadios; SB3;
Services:Rhapsody;Slacker;RadioTunes;Spotify (+Triode's Plugin)
Sirius.com;CalmRadio
Ipeng remote controller.

Ikabob's Profile: http://forums.slimdevices.com/member.php?userid=32088
View this thread: http://forums.slimdevices.com/showthread.php?t=104395

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread Scott Crawford

Thanks pkfox, I've been wanting something like this for a long time.
Worked great! :-)



Scott Crawford's Profile: http://forums.slimdevices.com/member.php?userid=63436
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread ModelCitizen

pkfox wrote: 
> Hi and thanks for your help in developing my application, what are you
> running your server on ? is it Linux or Windows ? Also could you send me
> your library.db file

It's the same machine...

I am running 32 bit Windows 7, Service Pack

Look again at my first post.



Somewhere, something incredible is waiting to be known
Last.fm/user/ModelCitizen

ModelCitizen's Profile: http://forums.slimdevices.com/member.php?userid=446
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread Pascal Hibon

pkfox wrote: 
> Hi there, my app is not meant to compete with a data management tool it
> is purely a cataloguer which produces a portable document.

I know that and it is certainly not my intention to "compete". I was
just showing what I'm currently using. 
Your post got my intention because I initially thought it could simplify
a part of the process of getting my library data into a CSV file. I
currently have a few "manual" steps in my process that could be
automated by a custom application.



'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) ->
'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be'
(http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html)
1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless
2 x Wandboard Dual, 1 x Wandboard Quad 
ReadyNAS NVX running LMS 7.9.0.
iPeng on iPhone, SqueezePad & iPeng on iPad.
http://www.last.fm/user/phibon

Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread pkfox

ModelCitizen wrote: 
> It's the same machine...
> 
> I am running 32 bit Windows 7, Service Pack (see my first post for
> clarification).
> 
> How should I send you my library file?

Easiest way is to put it on a share in Dropbox, the basic account is
free.



When the going gets weird - the weird turn pro. Hunter S Thompson

CD's -> EAC/Grip -> ReadyNas NV -> CAT5 -> Sonicwall -> TP -> Meridian
551 -> Monitor Audio Gold -> Me :-)

pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread Pascal Hibon

pkfox wrote: 
> Hi there, if you let me know what format you would like the CSV file in
> I could add it to the application. By format I mean what fields do you
> need
> .

This is what my CSV file looks like that I feed to HanDBase:

19138


I don't know if LMS even stores the values of Key and BPM in their
library but these values are stored in the metadata of my music files. I
need to clarify that I also used this HanDBase list when I was still
DJing. Those values were important to me at that time; today they are
not mandatory anymore. 
Hot List is a column that I manually add. It serves a purpose in my
HanDBase db: I have created a view called Hot List and that view lists
all tracks who have the Hot List checkbox checked. I used my iPad during
DJing and used the Hot List checkbox as a memory aid: during the coarse
of the night I would check this checkbox for tracks I might play later
in the evening.


+---+
|Filename: itunes.png   |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=19138|
+---+


'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) ->
'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be'
(http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html)
1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless
2 x Wandboard Dual, 1 x Wandboard Quad 
ReadyNAS NVX running LMS 7.9.0.
iPeng on iPhone, SqueezePad & iPeng on iPad.
http://www.last.fm/user/phibon

Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread pkfox

Pascal Hibon wrote: 
> I know that and it is certainly not my intention to "compete". I was
> just showing what I'm currently using. 
> Your post got my intention because I initially thought it could simplify
> a part of the process of getting my library data into a CSV file. I
> currently have a few "manual" steps in my process that could be
> automated by a custom application.

Hi there, if you let me know what format you would like the CSV file in
I could add it to the application. By format I mean what fields do you
need
.



We can't stop here this is bat country. RIP Hunter S Thompson.

pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread ModelCitizen

Hello Mr Fox.

Thanks very much for sharing this. It would be useful to me so I tried
it on my 32 bit Windows 7 Pro machine (my combined desktop and
Squeezebox server).

It errored and did not create the document (even though I hit
'continue').

Here is the error:

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

** Exception Text **
System.BadImageFormatException: An attempt was made to load a program
with an incorrect format. (Exception from HRESULT: 0x8007000B)
at
System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(SQLiteConfigOpsEnum
op)
at System.Data.SQLite.SQLite3.StaticIsInitialized()
at System.Data.SQLite.SQLiteLog.Initialize()
at System.Data.SQLite.SQLiteConnection..ctor(String connectionString,
Boolean parseViaFramework)
at System.Data.SQLite.SQLiteConnection..ctor()
at LMS.MusicReader..ctor(String ConnString)
at LMSToPDF.Form1.btnGeneratePDF_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)


** Loaded Assemblies **
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
CodeBase:
file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

LMSToPDF
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase:
file:///C:/Program%20Files/Squeezebox-library/LMSToPDF.exe

System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34251 built by: FX452RTMGDR
CodeBase:
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34270 built by: FX452RTMGDR
CodeBase:
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34238 built by: FX452RTMGDR
CodeBase:
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

PJK_FormsLib
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase:
file:///C:/Program%20Files/Squeezebox-library/PJK_FormsLib.DLL

CMSInterfaces
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase:
file:///C:/Program%20Files/Squeezebox-library/CMSInterfaces.DLL

System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
CodeBase:
file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
CodeBase:
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
CodeBase:
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
CodeBase:
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll

PJKBaseControls
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase:
file:///C:/Program%20Files/Squeezebox-library/PJKBaseControls.DLL

System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
CodeBase:
file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.Data.SQLite
Assembly Version: 1.0.98.0
Win32 Version: 1.0.98.0
CodeBase:
file:///C:/Program%20Files/Squeezebox-library/System.Data.SQLite.DLL

System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
CodeBase:

Re: [slim] Document your collection

2015-11-04 Thread steve-g

Thanks - I'll try it out



steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread steve-g

You can download my library.db from here:
https://dl.dropboxusercontent.com/u/16875599/library.db 

I probably have quite a few occurences where the the artist name is
slightly different for different albums - It's one of the things I need
to tidy up.

Thanks for your help

Steve



steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread pkfox

steve-g wrote: 
> Thanks - I'll try it out
> 
> Edit - It doesn't work - I copied the files into a folder and ran it
> from there - is this right?
> 
> Comes up with a dialogue box - 'An item with the same key has already
> been added' - saying OK then a dialog box with the library statistics -
> 236 artists, 547 albums and 8040 tracks - this looks about right.
> 
> Generates a pdf which is 9kb
> 
> Acrobat Reader reports: 'There was an error opening this document. The
> file is damaged and could not be repaired. 
> 
> Any ideas?

Yes I had that once it turned out there was mutiple artists with the
same name e.g I had The Rolling Stones and The rolling Stones in my
database - the way the programme builds a TOC in the first pass is it
assigns a key for the artist in a table which is used for the hyperlinks
in the document and obviously it can't add a second unique key to the
collection - I'll add some code to report any duplicate keys to the user
- if you don't mind sending me your library.db I will investigate it
here - thanks for feedback.



When the going gets weird - the weird turn pro. Hunter S Thompson

CD's -> EAC/Grip -> ReadyNas NV -> CAT5 -> Sonicwall -> TP -> Meridian
551 -> Monitor Audio Gold -> Me :-)

pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread pkfox

steve-g wrote: 
> You can download my library.db from here:
> https://dl.dropboxusercontent.com/u/16875599/library.db 
> 
> I probably have quite a few occurences where the the artist name is
> slightly different for different albums - It's one of the things I need
> to tidy up.
> 
> Thanks for your help
> 
> Steve

I've put a modified version on Dropbox now which has a checkbox you can
tick to show you a message of the offending article - thanks for being
my tester ?



When the going gets weird - the weird turn pro. Hunter S Thompson

CD's -> EAC/Grip -> ReadyNas NV -> CAT5 -> Sonicwall -> TP -> Meridian
551 -> Monitor Audio Gold -> Me :-)

pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread pkfox

ModelCitizen wrote: 
> Hello Mr Fox.
> 
> Thanks very much for sharing this. It would be useful to me so I tried
> it on my 32 bit Windows 7 Pro machine (my combined desktop and
> Squeezebox server).
> 
> It errored and did not create the document (even though I hit
> 'continue').
> 
> Here is the error:
> 
> See the end of this message for details on invoking 
> just-in-time (JIT) debugging instead of this dialog box.
> 
> ** Exception Text **
> System.BadImageFormatException: An attempt was made to load a program
> with an incorrect format. (Exception from HRESULT: 0x8007000B)
> at
> System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(SQLiteConfigOpsEnum
> op)
> at System.Data.SQLite.SQLite3.StaticIsInitialized()
> at System.Data.SQLite.SQLiteLog.Initialize()
> at System.Data.SQLite.SQLiteConnection..ctor(String connectionString,
> Boolean parseViaFramework)
> at System.Data.SQLite.SQLiteConnection..ctor()
> at LMS.MusicReader..ctor(String ConnString)
> at LMSToPDF.Form1.btnGeneratePDF_Click(Object sender, EventArgs e)
> at System.Windows.Forms.Control.OnClick(EventArgs e)
> at System.Windows.Forms.Button.OnClick(EventArgs e)
> at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
> at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
> button, Int32 clicks)
> at System.Windows.Forms.Control.WndProc(Message& m)
> at System.Windows.Forms.ButtonBase.WndProc(Message& m)
> at System.Windows.Forms.Button.WndProc(Message& m)
> at
> System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
> m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
> 
> 
> ** Loaded Assemblies **
> mscorlib
> Assembly Version: 4.0.0.0
> Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
> CodeBase:
> file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
> 
> LMSToPDF
> Assembly Version: 1.0.0.0
> Win32 Version: 1.0.0.0
> CodeBase:
> file:///C:/Program%20Files/Squeezebox-library/LMSToPDF.exe
> 
> System.Windows.Forms
> Assembly Version: 4.0.0.0
> Win32 Version: 4.0.30319.34251 built by: FX452RTMGDR
> CodeBase:
> file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> 
> System.Drawing
> Assembly Version: 4.0.0.0
> Win32 Version: 4.0.30319.34270 built by: FX452RTMGDR
> CodeBase:
> file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> 
> System
> Assembly Version: 4.0.0.0
> Win32 Version: 4.0.30319.34238 built by: FX452RTMGDR
> CodeBase:
> file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
> 
> PJK_FormsLib
> Assembly Version: 1.0.0.0
> Win32 Version: 1.0.0.0
> CodeBase:
> file:///C:/Program%20Files/Squeezebox-library/PJK_FormsLib.DLL
> 
> CMSInterfaces
> Assembly Version: 1.0.0.0
> Win32 Version: 1.0.0.0
> CodeBase:
> file:///C:/Program%20Files/Squeezebox-library/CMSInterfaces.DLL
> 
> System.Data
> Assembly Version: 4.0.0.0
> Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
> CodeBase:
> file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
> 
> System.Core
> Assembly Version: 4.0.0.0
> Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
> CodeBase:
> file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
> 
> System.Xml
> Assembly Version: 4.0.0.0
> Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
> CodeBase:
> file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
> 
> System.Numerics
> Assembly Version: 4.0.0.0
> Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
> CodeBase:
> file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
> 
> PJKBaseControls
> Assembly Version: 1.0.0.0
> Win32 Version: 1.0.0.0
> CodeBase:
> file:///C:/Program%20Files/Squeezebox-library/PJKBaseControls.DLL
> 
> System.Configuration
> Assembly Version: 4.0.0.0
> Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
> CodeBase:
> file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
> 
> System.Data.SQLite
> Assembly Version: 

Re: [slim] Document your collection

2015-11-04 Thread pkfox

steve-g wrote: 
> OK i've got SQLiteBrowser - looking at the database shows that LMS has
> now tagged 'Lungs' as 'Various Artists' - even though it shows up
> correctly in the squeezeplayer!
> 
> And indeed Lungs is in the Various Artists section in the PDF file.
> 
> I'll do a clear library and rescan and try again and report back -
> probably tomorrow - I've run out of time today.
> 
> Edit: Yes thats fixed it

This is exctly why I wrote this program in the first place - I'm now
very close to having a clean well tagged library - thanks for your help



When the going gets weird - the weird turn pro. Hunter S Thompson

CD's -> EAC/Grip -> ReadyNas NV -> CAT5 -> Sonicwall -> TP -> Meridian
551 -> Monitor Audio Gold -> Me :-)

pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Announcing iPeng 9 - Support for iPad Multitasking, iPad Pro and more

2015-11-04 Thread pippin

Thank you :)



---
learn more about iPeng, the iPhone and iPad remote for the Squeezebox
and
Logitech UE Smart Radio as well as iPeng Party, the free Party-App, 
at penguinlovesmusic.com
*New: iPeng 9, the Universal App for iPhone, iPad and Apple Watch*

pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777
View this thread: http://forums.slimdevices.com/showthread.php?t=104537

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread Pascal Hibon

d6jg wrote: 
> There is a suitable tool !!!
> 
> SQL Lite Manager Firefox Add-on
> 
> The basic SQL syntax to produce a basic listing is
> 
> select albums.title, contributors.name,  albums.year from albums left
> join contributors where albums.contributor = contributors.id

I don't want to hijack pkfox's thread but I just wanted to share some
screenshots how HanDBase looks on an iPhone:

Default view, listing all tracks:

19135


Search "florence":

19137



Detail view of a record (track Papillon):

19136


Of course it is possible to re size the columns, to create different
views on the database, use filters, etc. There are other columns who
aren't currently visible on the screen but you can easily scroll to the
left and right. I currently have 14525 records in the database and the
app is still very fast on my iPhone 5. Recommended !


+---+
|Filename: IMG_0239.JPG |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=19137|
+---+


'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) ->
'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be'
(http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html)
1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless
2 x Wandboard Dual, 1 x Wandboard Quad 
ReadyNAS NVX running LMS 7.9.0.
iPeng on iPhone, SqueezePad & iPeng on iPad.
http://www.last.fm/user/phibon

Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread steve-g

pkfox wrote: 
> I've put a modified version on Dropbox now which has a checkbox you can
> tick to show you a message of the offending article - thanks for being
> my tester ?
> 
> Edit
> 
> I ran the app against your data and only got one error Florence The
> Machine so if you look at that and let me know what you can see it will
> help me.
> 
> Edit2
> if you open your database using SQLiteBrowser and run this query you
> will see one of the names is in a different case.
> 

I'm suprised theres only one! I've edited the tags on the second album
(Lungs) and re-scanned. It now shows up correctly on squeezeplayer.

The error was 'Florence + The Machine' & 'Florence + the Machine' - A
pdf was still produced correctly even with the error.

I'm now officially confused - your library statistics now show 1 less
artist but the same number of albums and tracks (what I'd expect) BUT
the pdf file only shows 1 album for florence - the one I've editted
(Lungs) is not listed. Also what happened to the '+'?

I've updated the dropbox library.db if you want to take a look.

I don't have the SQLiteBrowser so can't look at the db - I'll see about
getting a copy.



steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread steve-g

OK i've got SQLiteBrowser - looking at the database shows that LMS has
now tagged 'Lungs' as 'Various Artists' - even though it shows up
correctly in the squeezeplayer!

And indeed Lungs is in the Various Artists section in the PDF file.

I'll do a clear library and rescan and try again and report back -
probably tomorrow - I've run out of time today.



steve-g's Profile: http://forums.slimdevices.com/member.php?userid=52057
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread pkfox

https://www.dropbox.com/sh/vwlwh2z2016za3h/AAAyITybJkvdDUyUeS2yOr6_a?dl=0



When the going gets weird - the weird turn pro. Hunter S Thompson

CD's -> EAC/Grip -> ReadyNas NV -> CAT5 -> Sonicwall -> TP -> Meridian
551 -> Monitor Audio Gold -> Me :-)

pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread pkfox

Hi there, my app is not meant to compete with a data management tool it
is purely a cataloguer which produces a portable document.



When the going gets weird - the weird turn pro. Hunter S Thompson

CD's -> EAC/Grip -> ReadyNas NV -> CAT5 -> Sonicwall -> TP -> Meridian
551 -> Monitor Audio Gold -> Me :-)

pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread ModelCitizen

pkfox wrote: 
> Hi there and thanks for your feedback - did you copy the library.db to a
> local drive ? - also what version / platform are you running the LMS
> server on ?

Thanks for the software!

I copied library.db to my desktop.
I created C:\Program Files\Squeezebox-library and unzipped your file
into it. I made a shortcut to the exe and added it to my Windows start
Bar/Programs. I used it to run the app on the library file saved to my
desktop.

I am running 32 bit Windows 7, Service Pack 1 and LMS version  7.7.5 -
1416570306.
There's nothing non-standard about my set up.

I hope that's enough info.



Somewhere, something incredible is waiting to be known
Last.fm/user/ModelCitizen

ModelCitizen's Profile: http://forums.slimdevices.com/member.php?userid=446
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss


Re: [slim] Document your collection

2015-11-04 Thread pkfox

ModelCitizen wrote: 
> Thanks for the software!
> 
> I copied library.db to my desktop.
> I created C:\Program Files\Squeezebox-library and unzipped your file
> into it. I made a shortcut to the exe and added it to my Windows start
> Bar/Programs. I used it to run the app on the library file saved to my
> desktop.
> 
> I am running 32 bit Windows 7, Service Pack 1 and LMS version  7.7.5 -
> 1416570306.
> There's nothing non-standard about my set up.
> 
> I hope that's enough info.

Hi and thanks for your help in developing my application, what are you
running your server on ? is it Linux or Windows ? Also could you send me
your library.db file



When the going gets weird - the weird turn pro. Hunter S Thompson

CD's -> EAC/Grip -> ReadyNas NV -> CAT5 -> Sonicwall -> TP -> Meridian
551 -> Monitor Audio Gold -> Me :-)

pkfox's Profile: http://forums.slimdevices.com/member.php?userid=5346
View this thread: http://forums.slimdevices.com/showthread.php?t=104566

___
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/discuss