[Isis-users] MX utility
Lic. Luis M. Peña
yosoy1969 at yahoo.com
Wed Oct 14 15:07:11 CEST 2015
Now, finally, what I recommend is to export the records into an empty database. So, the real records will appear, then update.
All databases in ISIS and Access are like that, they desappear fisically, but not logically. When you see the counter in Win Isis or ISIS, they are there. __________________________Un nuevo cambio de mentalidad se avecina...nuestro mundo, pronto no será ya el mismo. Los viejos patrones serán cosas del pasado y poco a poco el Todo será en todos..._________________________________________________________________
Luis M. Peña Féliz- Bibliotecario de Procesos Técnicos Biblioteca Pedro Mir, UASD- Encargado Centro de Documentación y Divulgación, Servicio Geológico Nacional
El Martes, 13 de octubre, 2015 12:12:03, spinaker <spinaker at adinet.com.uy> escribió:
Dear Bridgette
The problem is a syntax error in your command
you should use mx secin bool=pioj proc='d.' copy=secin now -all tell=1000
and you missed the = (equal sign) in the command
Regards
Ernesto
El 13/10/2015 a las 12:00, Bridgette Heron escribió:
<!--#yiv6616769979 _filtered #yiv6616769979 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv6616769979 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv6616769979 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv6616769979 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv6616769979 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv6616769979 #yiv6616769979 p.yiv6616769979MsoNormal, #yiv6616769979 li.yiv6616769979MsoNormal, #yiv6616769979 div.yiv6616769979MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";color:black;}#yiv6616769979 a:link, #yiv6616769979 span.yiv6616769979MsoHyperlink {color:blue;text-decoration:underline;}#yiv6616769979 a:visited, #yiv6616769979 span.yiv6616769979MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv6616769979 pre {margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier New";color:black;}#yiv6616769979 p.yiv6616769979MsoAcetate, #yiv6616769979 li.yiv6616769979MsoAcetate, #yiv6616769979 div.yiv6616769979MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";color:black;}#yiv6616769979 span.yiv6616769979EmailStyle17 {font-family:"Tahoma", "sans-serif";color:black;}#yiv6616769979 span.yiv6616769979HTMLPreformattedChar {font-family:"Consolas", "serif";color:black;}#yiv6616769979 span.yiv6616769979EmailStyle20 {color:#1F497D;}#yiv6616769979 span.yiv6616769979BalloonTextChar {font-family:"Tahoma", "sans-serif";color:black;}#yiv6616769979 .yiv6616769979MsoChpDefault {font-size:10.0pt;} _filtered #yiv6616769979 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv6616769979 div.yiv6616769979WordSection1 {}--> Hi Ernesto, Thank you for responding J The National Library of Jamaica has been CDS/ISIS distributor since 1989. We have collected records from other libraries and made one composite database online (wxis) for them to search…hence the over 142000 records. I had done the search in Winisis before to verify and confirm the number of records that ‘bool’ would find. Anyway I did what you suggested (see snapshot) but the records are still not marked or deleted when I open the database in Winisis to verify if they have gone or are logically deleted. See PIOJ in the first field. This is after the mx operation. These PIOJ records are scattered in the db. From: isis-users [mailto:isis-users-bounces+nlj_bmheron=hotmail.com at iccisis.org] On Behalf Of spinaker
Sent: Monday, October 12, 2015 4:25 PM
To: isis-users at iccisis.org
Subject: Re: [Isis-users] MX utility Dear Bridgette
In first place I want to congratulate you because a database with more then 140 thousand records is really interesting
By the Way, what kind of library you manage and where is it located?
Ok, let's go to work
Out of curiosity, how do you get your hit of records, i.e. is the term 'pioj' indexed in any way?
do you extract that term using some sort of FST?
I suppose that your bool=pioj is correct, so the way to do this is:
mx dbase bool=pioj proc='d.' copy=dbase now -all tell=1000
The way to delete the record is copying the process onto the same database, otherwise the result is only to the console, but has no effect on the master file
let's note that you cannot export records wiht a proc='d.' because you cannot create deleted records !!!
then ... please ... backup yuour database before you begin with the killing !!!
good luck
Ernesto Spinak
El 12/10/2015 a las 18:05, Bridgette Heron escribió:
Hello all, I have a database of 142,747 records and I want to delete all records with the term ‘pioj’ . The search from Winisis yields 59775 records so its too many to delete. I tried the mx utility. Mx dbase bool=pioj proc=’d.’ Thought it would logically delete them so I could export/import to load back the records I want to keep. The command runs but no effect when in Winisis i.e. records with the term pioj are not flagged as logically deleted. Shed some light please. Thanks Bridgette
_______________________________________________ isis-users mailing list 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
-- .^. .^. ( ) ( ) === === =[=]================================[=]= | | Ernesto Spinak | | | | spinaker at adinet.com.uy | | | | Montevideo, Uruguay | | | | tel/fax (598) 2622-3352 | | | | celular (598) 99612238 | | =[=]================================[=]= === === ( ) ( ) V V
--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | 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
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
Or contact Henk Rutten: hlrutten at xs4all.nl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20151014/9d98143c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 30736 bytes
Desc: not available
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20151014/9d98143c/attachment.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 17644 bytes
Desc: not available
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20151014/9d98143c/attachment-0001.jpe>
More information about the isis-users
mailing list