<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>