AnsweredAssumed Answered

File import 'issues'

Question asked by Frostie on Jun 14, 2018
Latest reply on Jun 26, 2018 by PaulSeabright

I am trying to update a set of customer records in my FM solution from a MYOB exported csv file.


I have a small customer table that has about 1025 records.  If I import from the csv file, no matter which field I match on, I always get pretty much, a full set of duplicate records. (most of the records that I am importing should be in the customer table already).


If I do this the other way round, i.e. bring the csv data into an empty customer table, then import file from a recent backup of the Production Data customer table, I see a result that I would expect - matched records updated and remaining records added as new records.


I both cases I do a show all before the import.


What am I missing??