<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body bgcolor="#FFFFFF" fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Dear Ernesto,
<div><br>
</div>
<div>You are a true magician with CISIS and you keep amazing me with your skills. I took the trouble of studying (most of) MX and had great benifit from it while maintaining my databases. I can recomend it to everyone who is acting as system manager of ISIS
based library applications.</div>
<div><br>
</div>
<div>Is there any change the kind of advanced applications and examples you showed here can find their way into maybe a new version of the CISIS manual?</div>
<div><br>
</div>
<div>Piet de Keyser</div>
<div>Belgium<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF107086" style="direction: ltr; "><font face="Tahoma" size="2" color="#000000"><b>Van:</b> isis-users-bounces@iccisis.org [isis-users-bounces@iccisis.org] namens spinaker [spinaker@adinet.com.uy]<br>
<b>Verzonden:</b> dinsdag 25 september 2012 22:12<br>
<b>Aan:</b> Bridgette Heron<br>
<b>CC:</b> isis-users@iccisis.org<br>
<b>Onderwerp:</b> Re: [Isis-users] Logically deleted records<br>
</font><br>
</div>
<div></div>
<div>
<div class="moz-cite-prefix"><big>Dear Bridgette<br>
<br>
OK, I guess your main problem was solved, which was to detect the deleted records, using the utility SWK<br>
Let`s go to the challenge<br>
<br>
To get the most out of CISIS utilities, it is important to know well the structure of the ISIS records<br>
A very interesting and simple manual as introduction is posted on the Download Site of Bireme.<br>
Basic Concepts of CDS/ISIS databases: Start using CISIS<br>
<a class="moz-txt-link-freetext" href="http://bvsmodelo.bvsalud.org/download/cisis/CISIS-ConceitosBasicos-en.pdf" target="_blank">http://bvsmodelo.bvsalud.org/download/cisis/CISIS-ConceitosBasicos-en.pdf</a><br>
<br>
The MST structure (the master file, or data records) has three parts:<br>
a) Leader<br>
b) directory<br>
c) data<br>
<br>
To run the following example, open a DOS window and we will use as an example the CDS database<br>
You must have access to the program MX.EXE<br>
as I explained in an earlier message, put the whole package in a directory, for example c:\cisis and make a path to that directory<br>
If not, you only have to do the following</big><br>
<br>
<big><font face="Courier New, Courier, monospace"><b>c:\> set path=%PATH%;c:\cisis</b></font></big><br>
<br>
<big>Go to the directory where you have CDS database<br>
To avoid damaging the original base, make a copy on which we will operate the example<br>
As you probably know, the master file, consists of two physical files with extensions. mst and. xrf</big><br>
<br>
<font face="Courier New, Courier, monospace"><big><b>c:\> copy cds.mst cdsnew.mst</b><b><br>
</b><b>c:\> copy cds.xrf cdsnew.xrf</b></big></font><br>
<big><br>
Then let's delete a few records on purpose, one of everty tenth</big><br>
<br>
<font face="Courier New, Courier, monospace"><b><big><small><font face="Courier New, Courier, monospace"><big><b>c:\>
</b></big></font></small>mx cdsnew copy=cdsnew proc='d.' loop=10 now -all tell=10,
</big></b></font><br>
<br>
<big>You can verify that records were deleted </big><br>
<br>
<font face="Courier New, Courier, monospace"><big><b>c:\>mx cdsnew </b><b><br>
</b><b>y verá mfn= 1 [DELETED]</b><b><br>
</b><b> 44 «Methodology of plant eco-physiology: proceedings of the Montpellier Sympoium»</b><b><br>
</b><b> 50 «Incl. bibl.»</b><b><br>
</b><b> 69 «plant physiology»</b><b><br>
</b><b>....</b><b><br>
</b><b>..</b><b><br>
</b><b>mfn= 2</b><b><br>
</b><b> 44 «Methodology of plant eco-physiology: proceedings of the Montpellier Sympos</b><b>ium»</b><b><br>
</b><b> 50 «Incl. bibl.»</b><b><br>
</b><b> 69 «plant evapotranspiration»</b></big></font><br>
<br>
<big>OK, now comes the trick (silence please, playing drums)<br>
<br>
Records have some structural components<br>
<br>
<font face="Courier New, Courier, monospace"><b>control | leader | xref | dir | fields</b></font><br>
<br>
The status of records are registered in the leader part<br>
status = 1 (borrado) | 0 (activo)<br>
<br>
<font face="Courier New, Courier, monospace"><b>c:\> mx cdsnew -all +leader count=12 now (shows the first 12 records)</b><b><br>
</b><b><br>
</b><b>mfn= 1|mfrl= 378|mfbwb= 0|mfbwp= 0|base= 84|nvf= 11|status= 1| 1</b><b><br>
</b><b>mfn= 2|mfrl= 318|mfbwb= 0|mfbwp= 0|base= 66|nvf= 8|status= 0| 0</b><b><br>
</b><b>mfn= 3|mfrl= 472|mfbwb= 0|mfbwp= 0|base= 96|nvf= 13|status= 0| 0</b><b><br>
</b><b>mfn= 4|mfrl= 374|mfbwb= 0|mfbwp= 0|base= 90|nvf= 12|status= 0| 0</b><b><br>
</b><b>mfn= 5|mfrl= 438|mfbwb= 0|mfbwp= 0|base= 96|nvf= 13|status= 0| 0</b><b><br>
</b><b>mfn= 6|mfrl= 360|mfbwb= 0|mfbwp= 0|base= 72|nvf= 9|status= 0| 0</b><b><br>
</b><b>mfn= 7|mfrl= 358|mfbwb= 0|mfbwp= 0|base= 90|nvf= 12|status= 0| 0</b><b><br>
</b><b>mfn= 8|mfrl= 340|mfbwb= 0|mfbwp= 0|base= 78|nvf= 10|status= 0| 0</b><b><br>
</b><b>mfn= 9|mfrl= 296|mfbwb= 0|mfbwp= 0|base= 66|nvf= 8|status= 0| 0</b><b><br>
</b><b>mfn= 10|mfrl= 426|mfbwb= 0|mfbwp= 0|base= 96|nvf= 13|status= 0| 0</b><b><br>
</b><b>mfn= 11|mfrl= 352|mfbwb= 0|mfbwp= 0|base= 102|nvf= 14|status= 1| 1</b><b><br>
</b><b>mfn= 12|mfrl= 372|mfbwb= 0|mfbwp= 0|base= 96|nvf= 13|status= 0| 0</b><b><br>
</b></font><br>
So, what I do is what I stated as a hint in my previous message<br>
that is, we dump all the leader of all records to a sequential .txt file<br>
<br>
<font face="Courier New, Courier, monospace"><b>c:\> mx cds -all +leader now > deleted.txt</b></font><br>
<br>
If we read tis file with seq= data is considered as fields separated by pipes<br>
<br>
<font face="Courier New, Courier, monospace"><b>c:\> mx seq=deleted.txt </b><b><br>
</b><b>mfn= 1</b><b><br>
</b><b> 1 «mfn= 1»</b><b><br>
</b><b> 2 «mfrl= 378»</b><b><br>
</b><b> 3 «mfbwb= 0»</b><b><br>
</b><b> 4 «mfbwp= 0»</b><b><br>
</b><b> 5 «base= 84»</b><b><br>
</b><b> 6 «nvf= 11»</b><b><br>
</b><b> 7 «status= 1»</b><b><br>
</b><b> 8 « 1 »</b></font><br>
<br>
So, to get the list of deleted mfns, we give the followin order <br>
<br>
<font face="Courier New, Courier, monospace"><b>c:\> mx seq=deleted.txt "pft=if v7:'1' then mfn,x2 fi " now</b><b><br>
</b><b>000001 000011 000021 000031 000041 000051 000061 000071 000081 000091</b><b><br>
</b><b>000101 000111 000121 000131 000141</b></font><br>
<br>
<i>Quod erat demonstrandum</i><br>
fanfare and cannon fire is heard<br>
the show is over<br>
thanks<br>
<br>
Regards<br>
Ernesto Spinak<br>
</big><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
El 25/09/2012 10:59, Bridgette Heron escribió:<br>
</div>
<blockquote type="cite">
<div><font face="Calibri">Dear Mr. Spinak,</font></div>
<div> </div>
<div><font face="Calibri">It would </font><font face="Calibri">seem that nobody took on your challenge
<img title="Smile emoticon" tabindex="-1" alt="Smile emoticon" src="cid:part1.02000400.05060304@adinet.com.uy" style="position:static; margin:0px; float:none"> I used the first option you suggested (SWK) but I was more interested in the MX approach. I did the
exercise and tried to decipher the contents of the deleted.txt file. I learned a little but not enough to go further. Can you do me the honours of explaining further.</font></div>
<div> </div>
<div><font face="Calibri">Thanks,<br>
Bridgette</font></div>
<div> </div>
<div><b>From:</b> <a title="spinaker@adinet.com.uy" href="mailto:spinaker@adinet.com.uy" target="_blank">
spinaker</a> </div>
<div style="font:10pt Tahoma">
<div style="background:#f5f5f5">
<div><b>Sent:</b> Wednesday, September 19, 2012 2:23 PM</div>
<div><b>To:</b> <a title="mailto:isis-users@iccisis.org
CTRL + Click to follow link" href="mailto:isis-users@iccisis.org" target="_blank">
isis-users@iccisis.org</a> </div>
<div><b>Subject:</b> Re: [Isis-users] Logically deleted records</div>
</div>
</div>
<div><br>
</div>
<div class="moz-cite-prefix">Dear Bridgette<br>
<br>
There are two ways to do this, <br>
the easiest one is to use the application Swiss Knife (SWK)<br>
you can download the package from Unesco <br>
<a class="moz-txt-link-freetext" href="http://portal.unesco.org/ci/en/ev.php-URL_ID=17110&URL_DO=DO_TOPIC&URL_SECTION=201.html" target="_blank">http://portal.unesco.org/ci/en/ev.php-URL_ID=17110&URL_DO=DO_TOPIC&URL_SECTION=201.html</a><br>
<br>
there you open SWK, load the database, to go the tab Miscellaneous and ask the procedure "Deleted"<br>
then you will get a fast list with MFNs<br>
<br>
The other way, to work with complex and very large databases is to use MX ( again?? yes!!!)<br>
<br>
Hi everybody!!!!<br>
<span class="hps">I'll</span> <span class="hps">give you a hint</span> <span class="hps">
and</span> <span class="hps">we'll leave</span> <span class="hps">24 hours to see</span>
<span class="hps">if</span> <span class="hps">a colleague</span> <span class="hps">
eager to take</span> <span class="hps">risks</span> <span class="hps">get</span> <span class="hps">
the complete solution</span><br>
<span class="hps">The winners</span> <span class="hps">will get from us th</span><span class="hps">e warmest congratulations</span><br>
<br>
Exercise: let's take CDS database and we'll prepare it deleting every tenth record<br>
<br>
mx cds copy=cds proc='d.' loop=10 now -all tell=10, <br>
<br>
now the hint<br>
<br>
<strong><font color="#ff0000">mx cds -all +leader now > deleted.txt<br>
<br>
</font></strong>Regards and enjoy the challenge<br>
<br>
Ernesto Spinak<br>
<br>
<br>
<br>
<br>
El 18/09/2012 19:15, Bridgette escribió:<br>
</div>
<blockquote type="cite">
<div><font face="Calibri">
<div><font face="Calibri">Hello everyone,</font></div>
<div> </div>
<div><font face="Calibri">Can the MX utility be used to identify/search for and print to a text file my logically deleted records; by MFN number and/or by titles? I am using Winisis, thanks.</font></div>
<div> </div>
<div><font face="Calibri">Bridgette Heron<br>
CDS/ISIS Field Programmer<br>
NATIONAL LIBRARY OF JAMAICA<br>
12 East Street<br>
Kingston<br>
<br>
Tel: (876) 967-2494, 967-2496<br>
Fax: (876) 922-5567<br>
Website: <a href="http://www.nlj.gov.jm" target="_blank">http://www.nlj.gov.jm</a></font></div>
</font></div>
<br>
<fieldset class="mimeAttachmentHeader" target="_blank"></fieldset> <br>
<pre>_______________________________________________
isis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a>
To manage your own subscription options go to: <a class="moz-txt-link-freetext" href="http://lists.iccisis.org/listinfo/isis-users" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a>
Or contact Henk Rutten: <a class="moz-txt-link-abbreviated" href="mailto:hlrutten@xs4all.nl" target="_blank">hlrutten@xs4all.nl</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a class="moz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy" target="_blank">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre>
<p></p>
<hr>
_______________________________________________<br>
isis-users mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a><br>
To manage your own subscription options go to: <a class="moz-txt-link-freetext" href="http://lists.iccisis.org/listinfo/isis-users" target="_blank">
http://lists.iccisis.org/listinfo/isis-users</a><br>
Or contact Henk Rutten: <a class="moz-txt-link-abbreviated" href="mailto:hlrutten@xs4all.nl" target="_blank">
hlrutten@xs4all.nl</a><br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a class="moz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy" target="_blank">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre>
</div>
</div>
</div>
</div>
</body>
</html>