<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<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">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 cite="mid:SNT136-ds78E1B168B54DF01921014899D0@phx.gbl"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19328">
<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 style="POSITION:
static; MARGIN: 0px; FLOAT: none" title="Smile emoticon"
tabindex="-1" alt="Smile emoticon"
src="cid:part1.02000400.05060304@adinet.com.uy"
msnnonuserimageoremoticon="true"> 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 moz-do-not-send="true"
title="spinaker@adinet.com.uy"
href="mailto:spinaker@adinet.com.uy">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 moz-do-not-send="true"
title="mailto:isis-users@iccisis.org
CTRL + Click to follow link"
href="mailto:isis-users@iccisis.org">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 moz-do-not-send="true" 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">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
cite="mid:SNT138-ds1877288E6BF408D2560A70BE940@phx.gbl"
type="cite">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19298">
<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"
moz-do-not-send="true">http://www.nlj.gov.jm</a></font></div>
</font></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
isis-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a>
To manage your own subscription options go to: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.iccisis.org/listinfo/isis-users">http://lists.iccisis.org/listinfo/isis-users</a>
Or contact Henk Rutten: <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:spinaker@adinet.com.uy">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">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">http://lists.iccisis.org/listinfo/isis-users</a><br>
Or contact Henk Rutten: <a class="moz-txt-link-abbreviated" href="mailto:hlrutten@xs4all.nl">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">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre>
</body>
</html>