<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19328"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 bgColor=#ffffff text=#000000
CanvasTabStop="true" name="Compose message area">
<DIV><FONT face=Arial>I agree with your suggestion. It is necessary to add
examples like the one we did. It should also include daily operational tips
and tricks to solve issues relating to our CDS/ISIS databases.
</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Well, I'm not finished with the challenge, but I created 3
folders using the command. Super cool <IMG
style="POSITION: static; MARGIN: 0px; FLOAT: none" title="Smile emoticon"
tabIndex=-1 alt="Smile emoticon"
src="cid:A65BBD9608B64DFB85866D84BCC13389@bheronins"
MSNNonUserImageOrEmoticon="true"></FONT></DIV>
<DIV><BR></DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A
title="mailto:spinaker@adinet.com.uy
CTRL + Click to follow link"
href="mailto:spinaker@adinet.com.uy">spinaker</A> </DIV>
<DIV><B>Sent:</B> Wednesday, September 26, 2012 5:55 AM</DIV>
<DIV><B>To:</B> <A
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>El 26/09/2012 7:09, spinaker escribió:<BR></DIV>
<BLOCKQUOTE cite=mid:5062D473.8080603@adinet.com.uy type="cite">
<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">
<STYLE id=owaParaStyle type=text/css></STYLE>
<DIV
style="FONT-FAMILY: Tahoma; DIRECTION: ltr; 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 style="DIRECTION: ltr" id=divRpF107086><FONT color=#000000 size=2
face=Tahoma><B>Van:</B> <A class=moz-txt-link-abbreviated
href="mailto:isis-users-bounces@iccisis.org"
moz-do-not-send="true">isis-users-bounces@iccisis.org</A> [<A
class=moz-txt-link-abbreviated href="mailto:isis-users-bounces@iccisis.org"
moz-do-not-send="true">isis-users-bounces@iccisis.org</A>] namens spinaker
[<A class=moz-txt-link-abbreviated href="mailto:spinaker@adinet.com.uy"
moz-do-not-send="true">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 class=moz-txt-link-abbreviated href="mailto:isis-users@iccisis.org"
moz-do-not-send="true">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 class=moz-txt-link-freetext
href="http://bvsmodelo.bvsalud.org/download/cisis/CISIS-ConceitosBasicos-en.pdf"
target=_blank
moz-do-not-send="true">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 class=moz-txt-link-abbreviated href="mailto:spinaker@adinet.com.uy" moz-do-not-send="true">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>
<P>
<HR>
<P></P>_______________________________________________<BR>isis-users mailing
list<BR>isis-users@iccisis.org<BR>To manage your own subscription options go to:
http://lists.iccisis.org/listinfo/isis-users<BR>Or contact Henk Rutten:
hlrutten@xs4all.nl<BR></BODY></HTML>