[slinkelist] CDJ database updates, especially deletions

Ron Tugender tugender@pacbell.net
Mon, 18 Oct 1999 10:59:56 -0700


This is a multi-part message in MIME format.

--Boundary_(ID_wWsFKjSkHGr6M/BQ0tvrRg)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE

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=92s database entry as missing (-1 in the player entry, =93?=94 in =
the viewable
display, dimmed line in the library display).  When the CD is reinser=
ted
into a player, CDJ is smart enough to update the CD=92s location info=
rmation
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.

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 c=
an find
to remove the entry.  I=92ve been forced to go directly into Access a=
nd
manually remove the CD entry from the disk table and the track entrie=
s from
the track table.  Is there a way to do this?  If not, couldn=92t CDJ =
have a
command to remove a disk=92s 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=92s right-click menu or alternately as an o=
ption in
the library menu.

Cheers,
Ron



--Boundary_(ID_wWsFKjSkHGr6M/BQ0tvrRg)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=
=3D"urn:schemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org=
/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8=
859-1">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01BF1957.E5A35900">
<!--[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:DisplayHorizontalDrawingG=
ridEvery>
  <w:DisplayVerticalDrawingGridEvery>0</w:DisplayVerticalDrawingGridE=
very>
  <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 Definitions */
@font-face
=09{font-family:"Book Antiqua";
=09panose-1:2 4 6 2 5 3 5 3 3 4;
=09mso-font-charset:0;
=09mso-generic-font-family:roman;
=09mso-font-pitch:variable;
=09mso-font-signature:647 0 0 0 159 0;}
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{mso-style-parent:"";
=09margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:11.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-fareast-font-family:"Times New Roman";
=09mso-bidi-font-family:"Times New Roman";
=09mso-bidi-language:HE;}
h1
=09{margin-top:12.0pt;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:0in;
=09margin-bottom:.0001pt;
=09text-align:center;
=09mso-pagination:widow-orphan lines-together;
=09mso-outline-level:1;
=09font-size:12.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:Arial;
=09mso-bidi-font-family:"Times New Roman";
=09mso-font-kerning:14.0pt;
=09mso-bidi-language:HE;
=09mso-bidi-font-weight:normal;}
h2
=09{mso-style-next:Normal;
=09margin-top:12.0pt;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan lines-together;
=09page-break-after:avoid;
=09mso-outline-level:2;
=09font-size:11.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:Arial;
=09mso-bidi-font-family:"Times New Roman";
=09mso-bidi-language:HE;
=09mso-bidi-font-weight:normal;}
h3
=09{margin-top:0in;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:.5in;
=09margin-bottom:.0001pt;
=09text-indent:-.25in;
=09mso-pagination:widow-orphan lines-together;
=09mso-outline-level:3;
=09font-size:11.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-bidi-language:HE;
=09font-weight:normal;}
h4
=09{mso-style-parent:"Heading 3";
=09margin-top:0in;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:.75in;
=09margin-bottom:.0001pt;
=09text-indent:-.25in;
=09mso-pagination:widow-orphan lines-together;
=09mso-outline-level:4;
=09font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-bidi-language:HE;
=09font-weight:normal;}
h5
=09{mso-style-parent:"Heading 4";
=09margin-top:0in;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:1.0in;
=09margin-bottom:.0001pt;
=09text-indent:-.25in;
=09mso-pagination:widow-orphan lines-together;
=09mso-outline-level:5;
=09font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-bidi-language:HE;
=09font-weight:normal;}
h6
=09{mso-style-parent:"Heading 5";
=09margin-top:0in;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:1.25in;
=09margin-bottom:.0001pt;
=09text-indent:-.25in;
=09mso-pagination:widow-orphan lines-together;
=09mso-outline-level:6;
=09font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-bidi-language:HE;
=09font-weight:normal;}
p.MsoHeading7, li.MsoHeading7, div.MsoHeading7
=09{mso-style-parent:"Heading 6";
=09margin-top:0in;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:1.5in;
=09margin-bottom:.0001pt;
=09text-indent:-.25in;
=09mso-pagination:widow-orphan lines-together;
=09mso-outline-level:7;
=09font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-fareast-font-family:"Times New Roman";
=09mso-bidi-font-family:"Times New Roman";
=09mso-bidi-language:HE;}
p.MsoHeading8, li.MsoHeading8, div.MsoHeading8
=09{mso-style-parent:"Heading 7";
=09margin-top:0in;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:1.75in;
=09margin-bottom:.0001pt;
=09text-indent:-.25in;
=09mso-pagination:widow-orphan lines-together;
=09mso-outline-level:8;
=09font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-fareast-font-family:"Times New Roman";
=09mso-bidi-font-family:"Times New Roman";
=09mso-bidi-language:HE;}
p.MsoHeading9, li.MsoHeading9, div.MsoHeading9
=09{margin-top:0in;
=09margin-right:0in;
=09margin-bottom:0in;
=09margin-left:4.25in;
=09margin-bottom:.0001pt;
=09text-indent:-.25in;
=09mso-pagination:widow-orphan;
=09mso-outline-level:9;
=09mso-list:l0 level1 lfo1;
=09tab-stops:list .25in;
=09font-size:9.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-fareast-font-family:"Times New Roman";
=09mso-bidi-font-family:"Times New Roman";
=09mso-bidi-language:HE;
=09font-style:italic;
=09mso-bidi-font-style:normal;}
p.MsoHeader, li.MsoHeader, div.MsoHeader
=09{margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09tab-stops:center 3.0in right 6.0in;
=09font-size:11.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-fareast-font-family:"Times New Roman";
=09mso-bidi-font-family:"Times New Roman";
=09mso-bidi-language:HE;}
p.MsoFooter, li.MsoFooter, div.MsoFooter
=09{margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09tab-stops:center 3.0in right 6.0in;
=09font-size:11.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-fareast-font-family:"Times New Roman";
=09mso-bidi-font-family:"Times New Roman";
=09mso-bidi-language:HE;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
=09{margin:0in;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:11.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:"Book Antiqua";
=09mso-fareast-font-family:"Times New Roman";
=09mso-bidi-font-family:"Times New Roman";
=09mso-bidi-language:HE;}
span.EmailStyle17
=09{mso-style-type:personal-compose;
=09mso-ansi-font-size:10.0pt;
=09mso-ascii-font-family:Arial;
=09mso-fareast-font-family:"Times New Roman";
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:black;}
@page Section1
=09{size:8.5in 11.0in;
=09margin:1.0in 1.0in 1.0in 1.0in;
=09mso-header-margin:.5in;
=09mso-footer-margin:.5in;
=09mso-title-page:yes;
=09mso-paper-source:0;}
div.Section1
=09{page:Section1;}
 /* List Definitions */
@list l0
=09{mso-list-id:136537189;
=09mso-list-type:simple;
=09mso-list-template-ids:5559546;}
@list l0:level1
=09{mso-level-number-format:bullet;
=09mso-level-style-link:"Heading 9";
=09mso-level-text:\2013;
=09mso-level-tab-stop:.25in;
=09mso-level-number-position:left;
=09margin-left:.25in;
=09text-indent:-.25in;
=09font-family:"Times New Roman";}
ol
=09{margin-bottom:0in;}
ul
=09{margin-bottom:0in;}
-->
</style>
</head>

<body lang=3DEN-US style=3D'tab-interval:.5in'>

<div class=3DSection1>

<p class=3DMsoNormal><span class=3DEmailStyle17><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>CDJ d=
oes something
interesting when it notices that a cataloged CD is no longer found at=
 its
expected location.<span style=3D"mso-spacerun: yes">&nbsp; </span>It =
marks the
player/disk data in the CD&#8217;s database entry as missing (-1 in t=
he player entry,
&#8220;?&#8221; in the viewable display, dimmed line in the library d=
isplay).<span
style=3D"mso-spacerun: yes">&nbsp; </span>When the CD is reinserted i=
nto a player,
CDJ is smart enough to update the CD&#8217;s location information sho=
uld the CD appear
in a different location from previous.<span style=3D"mso-spacerun: ye=
s">&nbsp;
</span>It does this without another CDDB lookup so it preserves any d=
atabase
information that might have been added since the original lookup. Thi=
s is all exactly
right IMHO.<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle17><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'><![if=
 !supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span>=
</p>

<p class=3DMsoNormal><span class=3DEmailStyle17><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>The g=
litch is where
a CD is permanently removed from the collection.<span style=3D"mso-sp=
acerun:
yes">&nbsp; </span>CDJ keeps the ghost entry around forever and offer=
s no
mechanism that I can find to remove the entry.<span style=3D"mso-spac=
erun:
yes">&nbsp; </span>I&#8217;ve been forced to go directly into Access =
and manually
remove the CD entry from the disk table and the track entries from th=
e track
table.<span style=3D"mso-spacerun: yes">&nbsp; </span>Is there a way =
to do
this?<span style=3D"mso-spacerun: yes">&nbsp; </span>If not, couldn&#=
8217;t CDJ have a
command to remove a disk&#8217;s database entries (including tracks) =
when that CD was
no longer to be included in the database?<span style=3D"mso-spacerun:=
 yes">&nbsp;
</span>I could envision it as another entry in the disk&#8217;s right=
-click menu or
alternately as an option in the library menu.<o:p></o:p></span></font=
></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle17><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'><![if=
 !supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span>=
</p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Book Antiqu=
a"><span
style=3D'font-size:11.0pt;color:black'><span style=3D'mso-bidi-font-s=
ize:10.0pt'>Cheers,</span></span></font><font
color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o=
:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Book Antiqu=
a"><span
style=3D'font-size:11.0pt;color:black'><span style=3D'mso-bidi-font-s=
ize:10.0pt'>Ron</span></span></font><span
class=3DEmailStyle17><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle17><font size=3D2 color=
=3Dblack
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'><![if=
 !supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span>=
</p>

</div>

</body>

</html>


--Boundary_(ID_wWsFKjSkHGr6M/BQ0tvrRg)--