Search found 6 matches
- 21 Feb 2017, 16:15
- Forum: Support 6.x
- Topic: Automating Madsonic
- Replies: 3
- Views: 2239
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...
- 03 Jan 2017, 00:31
- Forum: Support 6.x
- Topic: Automating Madsonic
- Replies: 3
- Views: 2239
Re: Automating Madsonic
Thanks!
- 31 Dec 2016, 10:03
- Forum: Support 6.x
- Topic: Automating Madsonic
- Replies: 3
- Views: 2239
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...
- 22 Dec 2016, 13:58
- Forum: Support 6.x
- Topic: Database help
- Replies: 1
- Views: 1816
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:
No solution to #1 as yet (how to restore playlists into specific index number).
Code: Select all
Update media_file SET FIRST_SCANNED = CHANGED
- 21 Dec 2016, 19:53
- Forum: Support 6.x
- Topic: Database help
- Replies: 1
- Views: 1816
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...
- 18 Nov 2016, 17:46
- Forum: Info
- Topic: Madsonic server on a Raspberry Pi 3
- Replies: 1
- Views: 7090
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 ...