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

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


      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



      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?