[slinkelist] Database Conversion Problem

[Tang, George]

Make sure you have the same number of rows in the new database and the new
database rows are all in the same sort order (in Access) as the old database
when you "Edit/Cut" the Notes column.  Otherwise, you'll end up with the
wrong lyrics for each track.

George Tang


-----Original Message-----
From: slinkelist-admin@nirvis.com [mailto:slinkelist-admin@nirvis.com]On
Behalf Of David Aue
Sent: Wednesday, October 27, 1999 12:15 AM
To: slinkelist@nirvis.com
Subject: Re: [slinkelist] Database Conversion Problem


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



_______________________________________________
slinkelist maillist  -  slinkelist@nirvis.com
http://www.nirvis.com/mailman/listinfo/slinkelist