AnsweredAssumed Answered

Troubleshooting importing of records

Question asked by db-brad on Mar 15, 2018
Latest reply on Mar 16, 2018 by techt

Hello, I'm using FMPro Advanced to import records to a standalone FM database on my desktop.  I'm adding historical records that may be duplicated over the past decade.  I've been importing using "update matching records in found set" along with add remaining data as new rows.  So far so good.  Except one file has 234 import errors (records).  I don't see any issues with the XLS source file and haven't been successful with getting FMP Advanced to create an import.log file.  How might I go about further troubleshooting what the problem might be?  As an aside, the only validation I have is that the customer ID can't be duplicated -- so we're either adding new customers or updating contact info on historical customer data.  Thank you in advance.

Outcomes