Public bug reported:
The path stored on table "media_files", in songs.sqlite is the full
path. Is there a way to change this to save the relative path
independent of OS (unix vs Windows), based on data path?
All my database is on Windows (with a lot of linked audios), I installed
OpenLP in a linux machine and just copy & paste the songs and themes
folders. But the linked audios don't play (because of the 'old' path).
So, I had to update the instances of "media_files" with SQL commands,
like these:
UPDATE media_files SET file_name = REPLACE(file_name, '\', '/');
UPDATE media_files SET file_name = REPLACE(file_name,
'C:/Users/Alberto/AppData/Roaming/openlp/data/songs/audio',
'/home/alberto/.local/openlp/songs/audio');
Old OpenLP machine: Windows 7
New OpenLP machine: Ubuntu 16.04
OpenLP version: 2.4.6 (both)
** Affects: openlp
Importance: Wishlist
Status: New
--
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/1689131
Title:
Store media_file with relative path
Status in OpenLP:
New
Bug description:
The path stored on table "media_files", in songs.sqlite is the full
path. Is there a way to change this to save the relative path
independent of OS (unix vs Windows), based on data path?
All my database is on Windows (with a lot of linked audios), I
installed OpenLP in a linux machine and just copy & paste the songs
and themes folders. But the linked audios don't play (because of the
'old' path). So, I had to update the instances of "media_files" with
SQL commands, like these:
UPDATE media_files SET file_name = REPLACE(file_name, '\', '/');
UPDATE media_files SET file_name = REPLACE(file_name,
'C:/Users/Alberto/AppData/Roaming/openlp/data/songs/audio',
'/home/alberto/.local/openlp/songs/audio');
Old OpenLP machine: Windows 7
New OpenLP machine: Ubuntu 16.04
OpenLP version: 2.4.6 (both)
To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/1689131/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~openlp-core
Post to : openlp-core@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openlp-core
More help : https://help.launchpad.net/ListHelp
