[slinkelist] CDJ database updates, especially deletions

Bill Reid breid@cgocable.net
Mon, 18 Oct 1999 13:08:21 -0400


This is a multi-part message in MIME format.

------=_NextPart_000_009C_01BF1969.DA5EA740
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Good idea.  Or maybe there could be a setting to hide these entries so =
that you don't have to look at them in the interface (library list), but =
that if you got another disk player and the disk came back, you would =
not have to type in any corrections or customizations to the disc =
information again.  I hate losing information, but I agree with not =
having these entries clutter up the library list.  Just some more =
suggestions to clutter up the to do list :-)

Bill
  ----- Original Message -----=20
  From: Ron Tugender=20
  To: Slinke-List=20
  Sent: Monday, October 18, 1999 1:59 PM
  Subject: [slinkelist] CDJ database updates, especially deletions


  CDJ does something interesting when it notices that a cataloged CD is =
no longer found at its expected location.  It marks the player/disk data =
in the CD's database entry as missing (-1 in the player entry, "?" in =
the viewable display, dimmed line in the library display).  When the CD =
is reinserted into a player, CDJ is smart enough to update the CD's =
location information should the CD appear in a different location from =
previous.  It does this without another CDDB lookup so it preserves any =
database information that might have been added since the original =
lookup. This is all exactly right IMHO.

  =20

  The glitch is where a CD is permanently removed from the collection.  =
CDJ keeps the ghost entry around forever and offers no mechanism that I =
can find to remove the entry.  I've been forced to go directly into =
Access and manually remove the CD entry from the disk table and the =
track entries from the track table.  Is there a way to do this?  If not, =
couldn't CDJ have a command to remove a disk's database entries =
(including tracks) when that CD was no longer to be included in the =
database?  I could envision it as another entry in the disk's =
right-click menu or alternately as an option in the library menu.

  =20

  Cheers,

  Ron

  =20


------=_NextPart_000_009C_01BF1969.DA5EA740
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 5.00.2614.3401" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01BF1957.E5A35900" rel=3DFile-List><!--[if gte =
mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  =
<w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEve=
ry>
  =
<w:DisplayVerticalDrawingGridEvery>0</w:DisplayVerticalDrawingGridEvery>
  <w:UseMarginsForDrawingGridOrigin/>
  <w:Compatibility>
   <w:FootnoteLayoutLikeWW8/>
   <w:ShapeLayoutLikeWW8/>
   <w:AlignTablesRowByRow/>
   <w:ForgetLastTabAlignment/>
   <w:DoNotUseHTMLParagraphAutoSpacing/>
   <w:LayoutRawTableWidth/>
   <w:LayoutTableRowsApart/>
  </w:Compatibility>
 </w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
	font-family: Book Antiqua;
}
P.MsoNormal {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HE
}
LI.MsoNormal {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HE
}
DIV.MsoNormal {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-style-parent: ""; mso-pagination: =
widow-orphan; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HE
}
H1 {
	FONT-FAMILY: Arial; FONT-SIZE: 12pt; MARGIN: 12pt 0in 0pt; TEXT-ALIGN: =
center; mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan =
lines-together; mso-bidi-font-family: "Times New Roman"; =
mso-bidi-language: HE; mso-outline-level: 1; mso-font-kerning: 14.0pt; =
mso-bidi-font-weight: normal
}
H2 {
	FONT-FAMILY: Arial; FONT-SIZE: 11pt; MARGIN: 12pt 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan lines-together; =
mso-bidi-font-family: "Times New Roman"; mso-bidi-language: HE; =
mso-outline-level: 2; mso-bidi-font-weight: normal; mso-style-next: =
Normal
}
H3 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; FONT-WEIGHT: normal; =
MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-bidi-font-size: =
10.0pt; mso-pagination: widow-orphan lines-together; mso-bidi-language: =
HE; mso-outline-level: 3
}
H4 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 10pt; FONT-WEIGHT: normal; =
MARGIN: 0in 0in 0pt 0.75in; TEXT-INDENT: -0.25in; mso-style-parent: =
"Heading 3"; mso-pagination: widow-orphan lines-together; =
mso-bidi-language: HE; mso-outline-level: 4
}
H5 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 10pt; FONT-WEIGHT: normal; =
MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -0.25in; mso-style-parent: =
"Heading 4"; mso-pagination: widow-orphan lines-together; =
mso-bidi-language: HE; mso-outline-level: 5
}
H6 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 10pt; FONT-WEIGHT: normal; =
MARGIN: 0in 0in 0pt 1.25in; TEXT-INDENT: -0.25in; mso-style-parent: =
"Heading 5"; mso-pagination: widow-orphan lines-together; =
mso-bidi-language: HE; mso-outline-level: 6
}
P.MsoHeading7 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt =
1.5in; TEXT-INDENT: -0.25in; mso-style-parent: "Heading 6"; =
mso-pagination: widow-orphan lines-together; mso-fareast-font-family: =
"Times New Roman"; mso-bidi-font-family: "Times New Roman"; =
mso-bidi-language: HE; mso-outline-level: 7
}
LI.MsoHeading7 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt =
1.5in; TEXT-INDENT: -0.25in; mso-style-parent: "Heading 6"; =
mso-pagination: widow-orphan lines-together; mso-fareast-font-family: =
"Times New Roman"; mso-bidi-font-family: "Times New Roman"; =
mso-bidi-language: HE; mso-outline-level: 7
}
DIV.MsoHeading7 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt =
1.5in; TEXT-INDENT: -0.25in; mso-style-parent: "Heading 6"; =
mso-pagination: widow-orphan lines-together; mso-fareast-font-family: =
"Times New Roman"; mso-bidi-font-family: "Times New Roman"; =
mso-bidi-language: HE; mso-outline-level: 7
}
P.MsoHeading8 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt =
1.75in; TEXT-INDENT: -0.25in; mso-style-parent: "Heading 7"; =
mso-pagination: widow-orphan lines-together; mso-fareast-font-family: =
"Times New Roman"; mso-bidi-font-family: "Times New Roman"; =
mso-bidi-language: HE; mso-outline-level: 8
}
LI.MsoHeading8 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt =
1.75in; TEXT-INDENT: -0.25in; mso-style-parent: "Heading 7"; =
mso-pagination: widow-orphan lines-together; mso-fareast-font-family: =
"Times New Roman"; mso-bidi-font-family: "Times New Roman"; =
mso-bidi-language: HE; mso-outline-level: 8
}
DIV.MsoHeading8 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt =
1.75in; TEXT-INDENT: -0.25in; mso-style-parent: "Heading 7"; =
mso-pagination: widow-orphan lines-together; mso-fareast-font-family: =
"Times New Roman"; mso-bidi-font-family: "Times New Roman"; =
mso-bidi-language: HE; mso-outline-level: 8
}
P.MsoHeading9 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 9pt; FONT-STYLE: italic; =
MARGIN: 0in 0in 0pt 4.25in; TEXT-INDENT: -0.25in; mso-bidi-font-size: =
10.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times =
New Roman"; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: =
HE; mso-outline-level: 9; mso-list: l0 level1 lfo1; tab-stops: list =
.25in; mso-bidi-font-style: normal
}
LI.MsoHeading9 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 9pt; FONT-STYLE: italic; =
MARGIN: 0in 0in 0pt 4.25in; TEXT-INDENT: -0.25in; mso-bidi-font-size: =
10.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times =
New Roman"; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: =
HE; mso-outline-level: 9; mso-list: l0 level1 lfo1; tab-stops: list =
.25in; mso-bidi-font-style: normal
}
DIV.MsoHeading9 {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 9pt; FONT-STYLE: italic; =
MARGIN: 0in 0in 0pt 4.25in; TEXT-INDENT: -0.25in; mso-bidi-font-size: =
10.0pt; mso-pagination: widow-orphan; mso-fareast-font-family: "Times =
New Roman"; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: =
HE; mso-outline-level: 9; mso-list: l0 level1 lfo1; tab-stops: list =
.25in; mso-bidi-font-style: normal
}
P.MsoHeader {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times =
New Roman"; mso-bidi-language: HE; tab-stops: center 3.0in right 6.0in
}
LI.MsoHeader {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times =
New Roman"; mso-bidi-language: HE; tab-stops: center 3.0in right 6.0in
}
DIV.MsoHeader {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times =
New Roman"; mso-bidi-language: HE; tab-stops: center 3.0in right 6.0in
}
P.MsoFooter {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times =
New Roman"; mso-bidi-language: HE; tab-stops: center 3.0in right 6.0in
}
LI.MsoFooter {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times =
New Roman"; mso-bidi-language: HE; tab-stops: center 3.0in right 6.0in
}
DIV.MsoFooter {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times =
New Roman"; mso-bidi-language: HE; tab-stops: center 3.0in right 6.0in
}
P.MsoAutoSig {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times =
New Roman"; mso-bidi-language: HE
}
LI.MsoAutoSig {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times =
New Roman"; mso-bidi-language: HE
}
DIV.MsoAutoSig {
	FONT-FAMILY: "Book Antiqua"; FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; =
mso-bidi-font-size: 10.0pt; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-bidi-font-family: "Times =
New Roman"; mso-bidi-language: HE
}
SPAN.EmailStyle17 {
	COLOR: black; mso-fareast-font-family: "Times New Roman"; =
mso-bidi-font-family: Arial; mso-style-type: personal-compose; =
mso-ansi-font-size: 10.0pt; mso-ascii-font-family: Arial; =
mso-hansi-font-family: Arial
}
DIV.Section1 {
	page: Section1
}
OL {
	MARGIN-BOTTOM: 0in
}
UL {
	MARGIN-BOTTOM: 0in
}
</STYLE>
</HEAD>
<BODY bgColor=3D#ffffff lang=3DEN-US style=3D"tab-interval: .5in">
<DIV>Good idea.&nbsp; Or maybe there could be a setting to hide these =
entries so=20
that you don't have to look at them in the interface (library list), but =
that if=20
you got another disk player and the disk came back, you would not have =
to type=20
in any corrections or customizations to the disc information =
again.&nbsp; I hate=20
losing information, but I agree with not having these entries clutter up =
the=20
library list.&nbsp; Just some more suggestions to clutter up the to do =
list=20
:-)</DIV>
<DIV>&nbsp;</DIV>
<DIV>Bill</DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
  <A href=3D"mailto:tugender@pacbell.net" =
title=3Dtugender@pacbell.net>Ron=20
  Tugender</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
  href=3D"mailto:slinkelist@nirvis.com"=20
  title=3Dslinkelist@nirvis.com>Slinke-List</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, October 18, 1999 =
1:59=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [slinkelist] CDJ =
database=20
  updates, especially deletions</DIV>
  <DIV><BR></DIV>
  <DIV class=3DSection1>
  <P class=3DMsoNormal><SPAN class=3DEmailStyle17><FONT color=3Dblack =
face=3DArial=20
  size=3D2><SPAN style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt">CDJ does =
something=20
  interesting when it notices that a cataloged CD is no longer found at =
its=20
  expected location.<SPAN style=3D"mso-spacerun: yes">&nbsp; </SPAN>It =
marks the=20
  player/disk data in the CD&#8217;s database entry as missing (-1 in =
the player=20
  entry, &#8220;?&#8221; in the viewable display, dimmed line in the =
library display).<SPAN=20
  style=3D"mso-spacerun: yes">&nbsp; </SPAN>When the CD is reinserted =
into a=20
  player, CDJ is smart enough to update the CD&#8217;s location =
information should the=20
  CD appear in a different location from previous.<SPAN=20
  style=3D"mso-spacerun: yes">&nbsp; </SPAN>It does this without another =
CDDB=20
  lookup so it preserves any database information that might have been =
added=20
  since the original lookup. This is all exactly right=20
  IMHO.<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=3DMsoNormal><SPAN class=3DEmailStyle17><FONT color=3Dblack =
face=3DArial=20
  size=3D2><SPAN style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=3DMsoNormal><SPAN class=3DEmailStyle17><FONT color=3Dblack =
face=3DArial=20
  size=3D2><SPAN style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt">The =
glitch is where a=20
  CD is permanently removed from the collection.<SPAN=20
  style=3D"mso-spacerun: yes">&nbsp; </SPAN>CDJ keeps the ghost entry =
around=20
  forever and offers no mechanism that I can find to remove the =
entry.<SPAN=20
  style=3D"mso-spacerun: yes">&nbsp; </SPAN>I&#8217;ve been forced to go =
directly into=20
  Access and manually remove the CD entry from the disk table and the =
track=20
  entries from the track table.<SPAN style=3D"mso-spacerun: yes">&nbsp; =
</SPAN>Is=20
  there a way to do this?<SPAN style=3D"mso-spacerun: yes">&nbsp; =
</SPAN>If not,=20
  couldn&#8217;t CDJ have a command to remove a disk&#8217;s database =
entries (including=20
  tracks) when that CD was no longer to be included in the =
database?<SPAN=20
  style=3D"mso-spacerun: yes">&nbsp; </SPAN>I could envision it as =
another entry=20
  in the disk&#8217;s right-click menu or alternately as an option in =
the library=20
  menu.<o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=3DMsoNormal><SPAN class=3DEmailStyle17><FONT color=3Dblack =
face=3DArial=20
  size=3D2><SPAN style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=3DMsoNormal><FONT color=3Dblack face=3D"Book Antiqua" =
size=3D2><SPAN=20
  style=3D"COLOR: black; FONT-SIZE: 11pt"><SPAN=20
  style=3D"mso-bidi-font-size: 10.0pt">Cheers,</SPAN></SPAN></FONT><FONT =

  color=3Dblack><SPAN=20
  style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
  <P class=3DMsoNormal><FONT color=3Dblack face=3D"Book Antiqua" =
size=3D2><SPAN=20
  style=3D"COLOR: black; FONT-SIZE: 11pt"><SPAN=20
  style=3D"mso-bidi-font-size: 10.0pt">Ron</SPAN></SPAN></FONT><SPAN=20
  class=3DEmailStyle17><FONT color=3Dblack face=3DArial size=3D2><SPAN=20
  style=3D"FONT-FAMILY: Arial; FONT-SIZE: =
10pt"><o:p></o:p></SPAN></FONT></SPAN></P>
  <P class=3DMsoNormal><SPAN class=3DEmailStyle17><FONT color=3Dblack =
face=3DArial=20
  size=3D2><SPAN style=3D"FONT-FAMILY: Arial; FONT-SIZE: 10pt"><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></SPAN></FONT></SPAN></P><=
/DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_009C_01BF1969.DA5EA740--