Import glitch

[danjacoby]

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?

[john.daly]

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.

[danjacoby]

Yup, I started the script with a "Show All Records" step -- no good.

[john.daly]

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?

[BobWeaver]

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.

[danjacoby]

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.

[john.daly]

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?

[john.daly]

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??