wir sind vor ca. 2 Jahren von Lyricue auf Songbeamer umgestiegen. Da beide Programme mit offenen Formaten arbeiten, war es recht einfach, die Daten von Lyricue zu Songbeamer zu konvertieren. Ich hab das Script gerade wieder gefunden und poste es einmal hier - vielleicht kann es ja jemand brauchen.
Damit es funktioniert, muss Ruby installiert sein. Bei Fragen postet einfach.
Viel Spaß damit!
LG
Corbin
Code: Alles auswählen
#!/usr/local/bin/ruby -w
require "mysql"
require "iconv"
dbname = "lyricDb"
encode_from = "iso-8859-1"
encode_to = "utf-8"
path = "./"
host = "localhost"
user = "XXX"
password = "YYY"
db = Mysql.new(host, user, password)
db.select_db("lyricDb")
result = db.query("SELECT title, id, artist, copyright FROM lyricMain ORDER BY title")
result.each do |array|
title = array[0].gsub(/[\t\r\n]/, "")
title = title.gsub("?", "")
title = title.gsub("\n", "")
title = title.gsub("/", " -- ")
title = Iconv.new(encode_to, encode_from).iconv(title)
if title != ""
id = array[1]
artist = array[2]
artist = Iconv.new(encode_to, encode_from).iconv(artist)
copyright = array[3]
copyright = Iconv.new(encode_to, encode_from).iconv(copyright)
if File.exists?(path + title)
puts "Error! File " + title + ".sng already exists."
else
file = File.open(path + title + ".sng", "w+")
# write Header Info
file.puts "#LangCount=1"
file.puts "#Title=" + title
file.puts "#Author=" + artist
file.puts "#(c)=Lyricue Import"
file.puts "#Rights=" + copyright
file.puts "#Editor=SongBeamer 2.24j"
file.puts "#Version=3"
file.puts "#Format=F/K//"
file.puts "#TitleFormat=U"
# write Verses
text = db.query("select lyrics from page where songid = " + id + " order by pagenum")
text.each do |array_text|
vers = array_text[0]
vers = Iconv.new(encode_to, encode_from).iconv(vers)
file.puts "---"
file.puts vers
end
file.close
end
end
end
db.close