Conference makrel::msg_solutions

    Some issues I have been considering about this problem.
    
    Perhaps I should define a specific Notes View for this GALNAMES.NSF
    file.
    
    The View would have the fields LastName, FirstName and CompanyName as
    well as the other fields that I provide in an ADD transaction -
    FullName, MailSystem and MailAddress.
    
    Maybe this would help LNSYNC to have more consistent access to data and
    data recognition in the GALNAMES.NSF file.
    
    The other LNSYNC DELETE error that I receive sometimes is 
    'Record for delete not found - 'LastName' '
    
    The GALNAMES record for 'LastName' does exist in the file.
    
    This is different to the error in .0 - 'Error locating record to
    delete'.
    
    I can manually select and delete all the records that are failing the
    LNSYNC DELETE transaction.
    
    Other information on this environment is that this GALNAMES.NSF file is
    being replicated to other Notes servers. This file should always be
    pushed to the other servers. Would this impact LNSYNC's ability to
    uniquely recognize a record in the file.
    
    thanks, Liz

    Liz,
    
    I have sent you some email regarding this problem, but perhaps you have
    not received it.  I would like to know what platform are you running
    this one, NT or OS2 and what version of Notes are you using?  I want to
    replicate here.  
    
    thanks,
    Rebecca
    

    Becky,
    The platform and version information is  
     
    Windows NT V3.51 (SP4) 
    Lotus Notes Server Release 4.11a 
    LNSYNC version V1.0 - 1 
     
    The DEL and ADD transation files for LNSYNC are generetaed on an
    OpenVMS Alpha V6.2 system running XDSU V1.4. 
     
    Thanks, Liz 
    
    

    Hi Liz,
    I haven't used LNSYNC in a while but looking at my notes I noticed that
    I defined fields for Deletes as well as Add & Modify....
    
    ---Delete Fields
    People
    FullName
    LastName
    FirstName
    Company
    
    Could this possibly help? Have you been able to actually delete using
    LNSYNC? Reading your note I wasn't sure if you had actually used LNSYNC
    for deletes or had manually done all deletes.
    
    Just a thought.
    Kathy

    Kathy,
    The version of LNSYNC doc that I have does not have any reference to a
    Delete section.
    
    I have been able to do automated deletes with LNSYNC. Some deletes are
    failing. There seems to be some connection where a delete fails if I do
    not have a completely unique LastName,FirstName,CompanyName delete
    transaction. I mean that if I have two records with LastName 
    and CompanyName the same but a different FirstName, when I try to
    delete it is likely to fail.
    Anyway, I will update when/if I get to the bpottom of this.
    
    Thanks, Liz  

    Liz,
    You might want to add the delete section to your rdf just for grins.
    The documentation never did mention that you needed it...and if it is
    only failing on duplicate last names perhaps it needs to come down one
    more level...adding the FirstName field to the rdf. You never know :^)
    Kathy

    Hi,
    
    There is no delete section.  The delete fields are found under the
    match fields as documented.  Liz was sent the latest version (V1.0-4) 
    which I believe fixed some update problems.  
    
    If that doesn't work, Liz, could you send your parameter file, input file, 
    and what errors lnsync is outputting.
    
    Regards,
    Warren

    Warren,
    Yes I did receive the LNSYNC V1.0-4 and I mailed my results back.
    Perhaps these did not get through. I have included the general content 
    here with the latest updates as I have spoken to some Notes support
    people yesterday.The import parameter file is in Note 1 but I will 
    include again in Note +1.
    
    Thanks, Liz
       
    Becky,
    Thanks for the new EXE and your help with this problem. I have
    installed the new .EXE with some slightly different results.
    
    With old EXE I had 4 records that reported - Error locating record to 
    delete. With the new EXE these 4 records are still not deleted and 
    they now report the same error with more information - 
    Error locating record to delete 
           Scott
           George
           CFA
    Error locating record to delete 
           White
           Glenn
           CFA
    etc, where the info displayed is LastName, FirstName, CompanyName 
    as per the import transaction file.
    
    So this EXE does not seem to have made any difference to my situation.
    
    In my investigations I have noticed some similar situations where a
    record will not be deleted. Note that this is NOT 100% consistent but 
    seems to be the case 95% of the time and therefore worth noting.
    
    If I am trying to delete one record but there is another record with
    the same LastName and CompanyName, (even if the FirstName is different),
    the record will not be deleted.
    
    Or if I have two records where the LastName and FirstName are the same,
    but the CompanyName is different I may not be able to delete one of the 
    records.
    
    So I had thought that perhaps my Notes database is not configured to 
    have unique entries based on the value of these 3 fields, and 
    LNSYNC is also not able to find a unique match in the datafile.
    
    But the Notes support I spoke to said that Notes has a unique ID for
    every entry in the database and that they did not really have a concept
    of primary keys/unique keys like an indexed file.
    I do not know Notes very well so if there is some Notes configuration 
    issues that may be relevant in this case I will be happy to hear
    them.
                                               
    Another issue that I have noticed is that LNSYNC will ADD duplicate
    entries in the file.
    
    EG. The record for
    Jack
    Jones
    CFA 
    'fullname'
    'mailsystem'
    'mailaddress'
    exists in the Notes database but LNSYNC will add the record again. This
    has happened when I have rerun imports while investigating the DELETE
    problem.
      
    Regards, Liz

    d:\notes\data\galnames.nsf
    People
    Person
    \\chrome\mb$xfer\notes\data\LN_exp.txt
    NOTES
    \\chrome\mb$xfer\notes\data\exp_LN_add.txt
    100000
    \\chrome\mb$xfer\notes\data\exp_LN_del.txt
    100000
    \\chrome\mb$xfer\notes\data\exp_LN_mod.txt
    100000
    ---Match View and Fields
    People
    LastName
    FirstName
    CompanyName
    ---Exported Fields
    LastName
    FirstName
    CompanyName
    ---Add Fields
    LastName
    FirstName
    CompanyName
    FullName
    MailSystem
    MailAddress
    ---Modify Fields
    MailAddress
    ---Completed
    

    LNSYNC IMPORT data file..
    
    Scott
    George
    CFA
    White
    Glenn
    CFA
    Millen
    Michael
    CFA 
    
    The DELETE data file is created on an OPENVMS Alpha system by XDSU. 
    I then do a CONVERT/FDL to change the RECORD format of the file so 
    that LNSYNC will read successfully.
    
    ..Liz