[Isis-users] Logically deleted records
Piet De Keyser
piet.dekeyser at khleuven.be
Tue Sep 25 22:35:44 CEST 2012
Dear Ernesto,
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.
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?
Piet de Keyser
Belgium
________________________________
Van: isis-users-bounces at iccisis.org [isis-users-bounces at iccisis.org] namens spinaker [spinaker at adinet.com.uy]
Verzonden: dinsdag 25 september 2012 22:12
Aan: Bridgette Heron
CC: isis-users at iccisis.org
Onderwerp: Re: [Isis-users] Logically deleted records
Dear Bridgette
OK, I guess your main problem was solved, which was to detect the deleted records, using the utility SWK
Let`s go to the challenge
To get the most out of CISIS utilities, it is important to know well the structure of the ISIS records
A very interesting and simple manual as introduction is posted on the Download Site of Bireme.
Basic Concepts of CDS/ISIS databases: Start using CISIS
http://bvsmodelo.bvsalud.org/download/cisis/CISIS-ConceitosBasicos-en.pdf
The MST structure (the master file, or data records) has three parts:
a) Leader
b) directory
c) data
To run the following example, open a DOS window and we will use as an example the CDS database
You must have access to the program MX.EXE
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
If not, you only have to do the following
c:\> set path=%PATH%;c:\cisis
Go to the directory where you have CDS database
To avoid damaging the original base, make a copy on which we will operate the example
As you probably know, the master file, consists of two physical files with extensions. mst and. xrf
c:\> copy cds.mst cdsnew.mst
c:\> copy cds.xrf cdsnew.xrf
Then let's delete a few records on purpose, one of everty tenth
c:\> mx cdsnew copy=cdsnew proc='d.' loop=10 now -all tell=10,
You can verify that records were deleted
c:\>mx cdsnew
y verá mfn= 1 [DELETED]
44 «Methodology of plant eco-physiology: proceedings of the Montpellier Sympoium»
50 «Incl. bibl.»
69 «plant physiology»
....
..
mfn= 2
44 «Methodology of plant eco-physiology: proceedings of the Montpellier Symposium»
50 «Incl. bibl.»
69 «plant evapotranspiration»
OK, now comes the trick (silence please, playing drums)
Records have some structural components
control | leader | xref | dir | fields
The status of records are registered in the leader part
status = 1 (borrado) | 0 (activo)
c:\> mx cdsnew -all +leader count=12 now (shows the first 12 records)
mfn= 1|mfrl= 378|mfbwb= 0|mfbwp= 0|base= 84|nvf= 11|status= 1| 1
mfn= 2|mfrl= 318|mfbwb= 0|mfbwp= 0|base= 66|nvf= 8|status= 0| 0
mfn= 3|mfrl= 472|mfbwb= 0|mfbwp= 0|base= 96|nvf= 13|status= 0| 0
mfn= 4|mfrl= 374|mfbwb= 0|mfbwp= 0|base= 90|nvf= 12|status= 0| 0
mfn= 5|mfrl= 438|mfbwb= 0|mfbwp= 0|base= 96|nvf= 13|status= 0| 0
mfn= 6|mfrl= 360|mfbwb= 0|mfbwp= 0|base= 72|nvf= 9|status= 0| 0
mfn= 7|mfrl= 358|mfbwb= 0|mfbwp= 0|base= 90|nvf= 12|status= 0| 0
mfn= 8|mfrl= 340|mfbwb= 0|mfbwp= 0|base= 78|nvf= 10|status= 0| 0
mfn= 9|mfrl= 296|mfbwb= 0|mfbwp= 0|base= 66|nvf= 8|status= 0| 0
mfn= 10|mfrl= 426|mfbwb= 0|mfbwp= 0|base= 96|nvf= 13|status= 0| 0
mfn= 11|mfrl= 352|mfbwb= 0|mfbwp= 0|base= 102|nvf= 14|status= 1| 1
mfn= 12|mfrl= 372|mfbwb= 0|mfbwp= 0|base= 96|nvf= 13|status= 0| 0
So, what I do is what I stated as a hint in my previous message
that is, we dump all the leader of all records to a sequential .txt file
c:\> mx cds -all +leader now > deleted.txt
If we read tis file with seq= data is considered as fields separated by pipes
c:\> mx seq=deleted.txt
mfn= 1
1 «mfn= 1»
2 «mfrl= 378»
3 «mfbwb= 0»
4 «mfbwp= 0»
5 «base= 84»
6 «nvf= 11»
7 «status= 1»
8 « 1 »
So, to get the list of deleted mfns, we give the followin order
c:\> mx seq=deleted.txt "pft=if v7:'1' then mfn,x2 fi " now
000001 000011 000021 000031 000041 000051 000061 000071 000081 000091
000101 000111 000121 000131 000141
Quod erat demonstrandum
fanfare and cannon fire is heard
the show is over
thanks
Regards
Ernesto Spinak
El 25/09/2012 10:59, Bridgette Heron escribió:
Dear Mr. Spinak,
It would seem that nobody took on your challenge [Smile emoticon] 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.
Thanks,
Bridgette
From: spinaker<mailto:spinaker at adinet.com.uy>
Sent: Wednesday, September 19, 2012 2:23 PM
To: isis-users at iccisis.org<mailto:isis-users at iccisis.org>
Subject: Re: [Isis-users] Logically deleted records
Dear Bridgette
There are two ways to do this,
the easiest one is to use the application Swiss Knife (SWK)
you can download the package from Unesco
http://portal.unesco.org/ci/en/ev.php-URL_ID=17110&URL_DO=DO_TOPIC&URL_SECTION=201.html
there you open SWK, load the database, to go the tab Miscellaneous and ask the procedure "Deleted"
then you will get a fast list with MFNs
The other way, to work with complex and very large databases is to use MX ( again?? yes!!!)
Hi everybody!!!!
I'll give you a hint and we'll leave 24 hours to see if a colleague eager to take risks get the complete solution
The winners will get from us the warmest congratulations
Exercise: let's take CDS database and we'll prepare it deleting every tenth record
mx cds copy=cds proc='d.' loop=10 now -all tell=10,
now the hint
mx cds -all +leader now > deleted.txt
Regards and enjoy the challenge
Ernesto Spinak
El 18/09/2012 19:15, Bridgette escribió:
Hello everyone,
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.
Bridgette Heron
CDS/ISIS Field Programmer
NATIONAL LIBRARY OF JAMAICA
12 East Street
Kingston
Tel: (876) 967-2494, 967-2496
Fax: (876) 922-5567
Website: http://www.nlj.gov.jm
_______________________________________________
isis-users mailing list
isis-users at iccisis.org<mailto:isis-users at iccisis.org>
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
Or contact Henk Rutten: hlrutten at xs4all.nl<mailto:hlrutten at xs4all.nl>
--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | spinaker at adinet.com.uy<mailto:spinaker at adinet.com.uy> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V
________________________________
_______________________________________________
isis-users mailing list
isis-users at iccisis.org<mailto:isis-users at iccisis.org>
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
Or contact Henk Rutten: hlrutten at xs4all.nl<mailto:hlrutten at xs4all.nl>
--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | spinaker at adinet.com.uy<mailto:spinaker at adinet.com.uy> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20120925/4bb0a164/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ATT00001.gif
Type: image/gif
Size: 257 bytes
Desc: ATT00001.gif
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20120925/4bb0a164/attachment.gif>
More information about the isis-users
mailing list