[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