Bigun Posted February 10, 2014 Share Posted February 10, 2014 I have two databases. One is production database that has live data in it (we'll call it Database A), and another database that is a test database that I'm developing new features on (we'll call it Database B ). I take a daily backup of Database A, and attempt to import the records (Using the File -> Import Records function in FileMaker Pro Advanced) from a table into Database B. Database A, in just one table, has 37,357 records, after import is finished, FileMaker says 59 records were skipped due to errors. No other details we're given. Not sure what is causing the errors with those 59 records, is there a way to get more detail? Or even an interactive way to import the data when errors are occuring? Link to comment Share on other sites More sharing options...
LaRetta Posted February 11, 2014 Share Posted February 11, 2014 Hi Bigun, Are you importing by matching on your primary key? If so, look at is your primary key in your table. Is it set to 'unique' and 'always'? Records will fail to import if that ID already exists. If not that then check your other fields for validations which might be failing. As for an interactive way to import the data when errors are occurring ... create a script and add script step of Set Error Capture [ On ] immediately before the import step. This will ignore any errors and you will need to trap what to do yourself. :-) 1 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3748 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now