importing an update to existing data

[tom g]

i am new at this, in fact my file maker pro 9 is a trial. using mac mini.

all csv files.

i am having inconsistant results when importing data to my existing master database file, that is an update to that master database.

i have a part number in field f1 and a price in field 2.

when importing the update i want to replace an exact find of the part number and update the price in field two (f2)to the new updated pricing for that part number. i am using in the screen 'import mapping' the update existing records in found set, and 'add remainging data as new records'. i never know when new part numbers are added, so i need that.

in a small test version of this it works great. but when i use the real live master database that has 177,000 records in it with the same update as in the test, i get duplicate records. that is i get the same exact part number with two different prices (one from master database, and one from update). what i want is the part number remains the same since it is an exact match, and the pricing is updated in column f2.

what am i doing wrong?

[aldipalo]

When you are setting the field mapping are you setting

Sourcefile::Partnumberfield = FM::PartnumberField.

NOT

Sourcefile::Partnumberfield ->FM::Partnumber Field .

Does your CSV file have a record number? If so, are you importing that number as well? Are there just the 2 fields?

Please explain your data structure in more detail.

[tom g]

i am not using "=", i am using arrow in field mapping...

partnumber=>partnumber

fields are f1 and f2, so

f1=>f1

i am not using record numbers.

[tom g]

i am sorry, i did not completely answer your questions...

csv file has two 'columns', f1 being the part number and f2 being the price..

"aa50-102","35.02"

"aa55-103","55.50"

when i update the master database, for example with only one change to the "aa50-102" with a new price of 99.02, then it would go from:

"aa50-102","35.02"

"aa55-103","55.50"

to:

"aa50-102","99.02"

"aa55-103","55.50"

[aldipalo]

When you are importing data in order to update the existing data you must map the partnumber field with an equal. Click the -> a second time. This way FM knows that when it comes across matching partnumbers it should update the other fields. See screen attached.

HTH