<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">El 26/09/2012 7:09, spinaker escribió:<br>
</div>
<blockquote cite="mid:5062D473.8080603@adinet.com.uy" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">Dear Piet<br>
<br>
Thanks for your comments<br>
Concerning CISIS there are updates with only few modifications,
so the manual is up to date<br>
maybe it is necessary to add examples like this one, and tricks
to solve daily problems of administration even commands<br>
<br>
Take this one only for fun<br>
I use to do daily backups of my system, with .bat files with
using cisis<br>
therefore the first thing I'd need is to create 31 folders, one
for each day, for example <br>
c:\backup\01 .... \31<br>
so, instead of doing c:\> md 01 02 03 04, etc you can
do<br>
<br>
mx tmp "sys='md ',mfn(2) '" to=31 now<br>
<br>
Now the challenge<br>
How do you save your data every day in the corresponding folder
using MX ?<br>
<br>
<br>
Enjoy it<br>
Regards<br>
Ernesto Spinak<br>
<br>
<br>
<br>
El 25/09/2012 17:35, Piet De Keyser escribió:<br>
</div>
<blockquote
cite="mid:F1CB9633948E2C47B18E479DC5F737CE7252C96B@RIZZO.intranet.khleuven.be"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<style type="text/css" id="owaParaStyle"></style>
<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
color="#000000" face="Tahoma" size="2"><b>Van:</b> <a
moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:isis-users-bounces@iccisis.org">isis-users-bounces@iccisis.org</a>
[<a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:isis-users-bounces@iccisis.org">isis-users-bounces@iccisis.org</a>]
namens spinaker [<a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a>]<br>
<b>Verzonden:</b> dinsdag 25 september 2012 22:12<br>
<b>Aan:</b> Bridgette Heron<br>
<b>CC:</b> <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><br>
<b>Onderwerp:</b> Re: [Isis-users] Logically deleted
records<br>
</font><br>
</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 moz-do-not-send="true"
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>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<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>
</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>