by brainier » Tue Dec 18, 2007 7:34 am
And SongPro is dreadful!
But I have finished:
When I exported my DBaseIII SOF4 database I called it SOF4.dbf and that was the second last problem I had. To convert to v2.5 format using DBConv.exe (part of ZW2.5) and the index file (.dbt file) must be called SONGS.DBF and SONGS.DBT. If the files are not called this then the program does not work and reports no error messages!
So after that, DBConv created a Data folder and I used the Database > Import menu within the application to merge the SOF4 database into my church's songs database.
As some songs have the same name they conflict, and so here is a list of conflicts I found (from SoF1, SoF2 and SoF3). The versions of the songs in books 1 to 3 would need renaming first, and for those the conflict in book four would need importing and renaming to allow the import to work again. In all you need to rename the following, and import three times to merge a Sof1-3 database with SoF4.
Conflicting Songs
1693 All Around Your Throne (conflict with 1154)
1698 ALL OF ME (conflict with 1160)
1725 BENEATH THE CROSS OF JESUS (Conflict with 39)
1792 GOD OF GRACE (Conflict with 138)
1793 GOD OF HEAVEN (Conflict with 734)
1802 GOD, YOU ARE MY GOD (Conflict with 1801)
1803 GOD, YOU ARE MY GOD (Conflict with 1801 and 1802)
1809 GREAT GOD (Conflict with 1808)
1812 GREAT IS YOUR FAITHFULNESS (Conflict with 1811)
1818 HEALING GRACE (Conflict with 157)
1839 HOLY CHILD (Conflict with 769)
1842 HOLY GOD (Conflict with 1841)
1908 I WANT TO KNOW (Conflict with 842)
1978 NOW THANK WE ALL OUR GOD (Conflict with 405)
2031 SON OF GOD (Conflict with 507)
2037 TAKE MY LIFE AND LET IT BE (Conflict with 519)
2077 THIS IS THE DAY (Conflict with 553)
2150 WITH ALL MY HEART (Conflict with 610)
2152 WONDERFUL LORD (Conflict with 2151)
2194 YOURS IS THE KINGDOM (Conflict with 1679)
2196 YOUR VOICE IS LIKE THUNDER (Conflict with 1148)