Search found 6 matches

by mwpmorris
21 Feb 2017, 16:15
Forum: Support 6.x
Topic: Automating Madsonic
Replies: 3
Views: 2241

Re: Automating Madsonic

If anyone is interested, I managed to automate the db queries by using cURL: curl --cookie /PATH/TO/YOUR/COOKIEFILE.txt -d query="SQL QUERY - URLENCODED" http://path.to.madsonic.server:port/db.view The authentication method mentioned above did not work for me, so I captured a cookie file u...
by mwpmorris
03 Jan 2017, 00:31
Forum: Support 6.x
Topic: Automating Madsonic
Replies: 3
Views: 2241

Re: Automating Madsonic

Thanks!
by mwpmorris
31 Dec 2016, 10:03
Forum: Support 6.x
Topic: Automating Madsonic
Replies: 3
Views: 2241

Automating Madsonic

Hello, In a development to my other thread: http://forum.madsonic.org/viewtopic.php?f=62&t=1986 I have a sequence of database query commands that update playlists based on date added, "starred" status etc. Unfortunately I have to manually enter these commands in the Madsonic web GUI. I...
by mwpmorris
22 Dec 2016, 13:58
Forum: Support 6.x
Topic: Database help
Replies: 1
Views: 1818

Re: Database help

If anyone is interested, I found a way of achieving #2 and have managed to copy the date info between columns by issuing variations on the following command:

Code: Select all

Update media_file SET FIRST_SCANNED = CHANGED
No solution to #1 as yet (how to restore playlists into specific index number).
by mwpmorris
21 Dec 2016, 19:53
Forum: Support 6.x
Topic: Database help
Replies: 1
Views: 1818

Database help

Hi, I'm pretty new to Madsonic and am hoping to get a little help with a couple of database commands. I'm emulating some iTunes "Smart Playlist" features by populating playlists with a sequence of commands based on below: DELETE FROM playlist_file WHERE PLAYLIST_ID = 0; INSERT INTO playlis...
by mwpmorris
18 Nov 2016, 17:46
Forum: Info
Topic: Madsonic server on a Raspberry Pi 3
Replies: 1
Views: 7102

Madsonic server on a Raspberry Pi 3

Hi, I've been experimenting with Madsonic over the past few days to see if it will suit my needs. It runs well on my MacBook Air, but now I've come to the point where I'll actually need to install a server permanently. I'm thinking of a Raspberry Pi 3 because of its low power consumption. All of my ...