openlp-core team mailing list archive

[Daniel Borges <1689131@xxxxxxxxxxxxxxxxxx>]

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