January 11, 200124 yr So I've set a script to import records, and have checked "Update matching records in current found set," and "Add remaining records." The problem is, the import adds ALL the records, including ones which have matching records in the file. What gives?
January 11, 200124 yr Have you included 'Show All Records' before 'Import'? Any records not in the current set will not be matched or updated and the updated records simply addded to the current set. Hope this solves it.
January 11, 200124 yr I tried it using this script with just two fields in a file containing four records and it works just fine: Enter Browse Mode [] Show All Records Go to Layout ("Layout#1") Import Records [Restore, "danjocoby copy.fp5"] Layout#1 contains both fields. Is this how you are doing it?
January 12, 200124 yr Did you properly set the match fields in the import dialog? If filemaker doesn't know how to match up corresponding records, it will assume that all records are new and will create all new records. The match records are indicated with the double headed arrow, <=> in the import dialog.
January 13, 200124 yr Author Yes, I set a match field. Then, in testing, I imported some records. Next, I imported the EXACT SAME RECORDS, and ended up with duplicates for all of them -- it didn't "update" anything, even though all the info (including info in the "match field") was exactly the same.
January 14, 200124 yr I've done exactly what you describe using the file I set up with just two fields in it and it still works fine whether or not there are any records to start with. I am using version 5.0v3 on a PC. What version of FM are you using? Is it on a Mac or a PC?
January 15, 200124 yr I've jsut checked out the fix list for 5.0v3 and found: 5) Corrected several issues with the Import Update feature of FileMaker Pro 5. See: http://www.filemaker.com/support/uplist.html#fm5v3 Could this be your problem??
Create an account or sign in to comment