AnsweredAssumed Answered

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

Question asked by johnsondavid1 on Mar 22, 2012
Latest reply on Mar 22, 2012 by 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



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?