Idea: export/import about libretime HOT 12 OPEN

I am just about to try exporting schedules to spreadsheets via the JSON API

from libretime.

Since all of this is in the database it shouldn't be too difficult. The trickier part would be building the most user-friendly interface and instructions for doing this. I can imagine it being useful to share smart block snippets between stations as well.

from libretime.

@Robbt > I can imagine it being useful to share smart block snippets between stations as well.

I could only dream of it)
I have many more ideas that need to be formulated correctly. I hope that some of them will be useful in the future.

from libretime.

The manual has instructions on how to import/export the Database directly at http://libretime.org/manual/backing-up-the-server/. At least for moving servers I believe this to be the proper way.

Import/export I see as interesting for multiple stations in a network that might want to share blocks and/or playlists. The code would need to take care of storing relations in the export and reloading them properly.

We should look if any library code exists that can help us get this done as I'd rather not implement the whole shebang. It does need a file format for the export and more to make sense.

If we want to implement something on the OR-mapper level we probably need to modernize that as well.

from libretime.

@HaJoHe This might also be of interest to you. If you go the backup route you want to back up the db, /etc/airtime, and /srv/airtime. In theory that should let you skip the initial setup on a restored machine. If not, you found a bug 😉

If you update to a new version it usually makes sense to run python utils/upgrade.py to get the db updated (though this should (i think) also happen automatically on certain requests)

from libretime.

ubuntu 14. (OpenVZ VPS)

python utils/upgrade.py 
Requesting upgrade...
No upgrade was performed. The current schema version is 3.0.0-alpha.<br>

after migrating db from main server got this in logs

2017-03-20T01:13:50+03:00 INFO (6): radio.mydomain.xx Checking autoplaylist poll
2017-03-20T01:13:50+03:00 INFO (6): radio.mydomain.xx Checking to run Auto Playlist
2017-03-20T01:13:50+03:00 INFO (6): radio.mydomain.xx Scheduling 2
2017-03-20T01:13:50+03:00 ERR (3): radio.mydomain.xx [Logging.php:166 - loggingShutdownCallback()] - Call to a member function canSchedule() on a non-object at /usr/share/airtime/php/airtime_mvc/application/models/Scheduler.php:142
array (
'type' => 1,
'message' => 'Call to a member function canSchedule() on a non-object',
'file' => '/usr/share/airtime/php/airtime_mvc/application/models/Scheduler.php',
'line' => 142,
)
2017-03-20T01:13:51+03:00 INFO (6): radio.mydomain.xx Registered Component: pypo@myIP
2017-03-20T01:13:54+03:00 INFO (6): radio.mydomain.xx Registered Component: show-recorder@myIP
2017-03-20T01:13:54+03:00 WARN (4): radio.mydomain.xx SQLSTATE[55P03]: Lock not available: 7 ERROR: could not obtain lock on row in relation "cc_pref"
2017-03-20T01:13:54+03:00 INFO (6): radio.mydomain.xx Notifying RabbitMQ to send message to pypo
2017-03-20T01:15:54+03:00 INFO (6): radio.mydomain.xx Checking autoplaylist poll
2017-03-20T01:15:54+03:00 INFO (6): radio.mydomain.xx Checking to run Auto Playlist
2017-03-20T01:15:54+03:00 INFO (6): radio.mydomain.xx Scheduling 2

from libretime.

I'm getting similar on a install onto ubuntu 14 on aws...

from libretime.

Is there any way to transfer only the list of smart blocks and programs? @hairmare

from libretime.

It's trying to call canSchedule() on a user object which for some reason is empty. When exactly does it fail with this error? I'd like to reproduce it but haven't been able to.

from libretime.

@korotkov13 not that I know of, there is only the full backup transfer strategy at this point.

from libretime.

I think the best way to add backup to settings as new option, and choosing what to backup.

And restore the same way

from libretime.

Perhaps we could use OPML for this. I do think that it would be a good idea to offer the ability to backup and restore or import/export shows etc.

Importing a calendar would need to deal with conflicts in terms of time etc or provide the option to overwrite whatever exists.

I also think that this could be useful as for both testing and development. In addition we could provide demo smartblock templates and even calendar that would help people get started with LibreTime.

from libretime.