openlp-core team mailing list archive

[Phill <1689131@xxxxxxxxxxxxxxxxxx>]

** Changed in: openlp
       Status: New => Fix Committed

** Branch linked: lp:~phill-ridout/openlp/pathlib8

-- 
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:
  Fix Committed

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