[slinkelist] Database Conversion Problem

David Aue aue@nirvis.com
Wed, 27 Oct 1999 00:14:38 -0700


The old database didn't have an explicit lyrics field, just a notes field, 
so lyrics stored in the old notes field are transferred into the notes 
field of the new database format.

Back up you user.mdb database before doing this!!

Open the user.mdb file in Access then open up the 'Tracks' table and select 
the 'Notes' column by clicking on 'Notes' along the top of the window.  You 
will have to scroll horizontally to find the 'Notes' field.  Once the 
column is selected use 'Edit/Cut' to cut this info to the clipboard.  Now 
select the 'Lyrics' column the same way you selected the notes column and 
use 'Edit/Paste' to put the info into the lyrics fields.  If you have any 
Lyrics associated with whole albums you will need to do this same procedure 
in the 'Albums' table too.

David Aue
Nirvis Systems

At 10:35 PM 10/25/99 , you wrote:
>I just downloaded and installed the latest version of CDJ.  After doing so I
>decided to finally convert to the new Access database format.  After having
>done the conversion I noticed that none of the CD's appeared with lyrics.
>After a bit of investigation, it appears that all the lyrics data was put
>into the NOTES section of the tracks.  It would appear that there's a bug in
>the conversion routine.
>
>Is there any way that this can be easily fixed now that the database is
>already converted?  Although I have the Access software, I know nothing about
>it's capabilities.  Can this be used to help fix it?  Does it allow you to
>copy a "columns" worth of data from one to another as in Excel?
>
>Any advice would be appreciated.
>
>Rich Trimble
>
>
>_______________________________________________
>slinkelist maillist  -  slinkelist@nirvis.com
>http://www.nirvis.com/mailman/listinfo/slinkelist