2 Replies Latest reply on Mar 22, 2012 7:19 PM by johnsondavid1

    Import Matching Data - Should Add New Records ignore empty match fields?

    johnsondavid1

      Hi All,

       

      Please be kind as this is my first post

       

      I am trying to import records on a Matching field. I would expect an EMPTY field in the imported file to not match and be added (as follows).

       

      Screen Shot 2012-03-22 at 4.27.02 PM.png Screen Shot 2012-03-22 at 4.27.11 PM.png

       

      Note Record (6) in LOCAL had an EMPTY id (number) field

       

      Importing into REMOTE from LOCAL

       

      Screen Shot 2012-03-22 at 4.27.42 PM.png

      NOTE:

       

      1) Update matching records in found set

      2) Add remaining data as new records

       

      Import with Auto Enter Data

       

      Screen Shot 2012-03-22 at 4.27.57 PM.png

       

      Results say 5 records imported/updated zero skipped (but there are six records?)

       

      Screen Shot 2012-03-22 at 4.28.04 PM.png

       

      PS: Yes I've done FIND ALLs on both tables before saving/importing databases.

       

       

      Sample databases enclosed FYI.

       

      Would you have thought this was not the expected behaviour for Update maching ADD not matching?

       

      Thanks