Importing / Changing field mappings

[adamshore]

I have an existing application which exports data to excel. I then take the data from excel to Filemaker where I append it to a database. In my Filemaker Database, I have comments and reviewer comments. I used to have both fields in my excel sheet, but now only the comments are in it.

I am having a hard time making Filemaker NOT try and import these reviewer comments. It should be totally ignoring them so I can just enter them in my Filemaker app. I can get the import mapping screen to allow me to break these links and keep the links broken.

The end result should be that I import all data except my reviewer comments, then enter the reviewer comments in the FM app.

I am using the Field Names option as First Row option. I tell certain fields to "don't import" and next time through, the data has been overwritten or those changes to tell the fields not to import are lost and the data is overwritten.

Please advise... I'm a noob with FM.

[Oldfogey]

How do you take the data from Excel to FMP?

[adamshore]

I am using the FMP import function. Another developer wrote this app. It used to bring over the reviewer comments and comments. Now it just brings the comments and the FMP app seems to want to map those reviewer comment fields to the FMP reviewer comment fields. FMP is the only place I enter those FMP fields, so I need to know how to change the import to not map those reviewer comment fields AND save those settings for future imports... Kind of hard to explain...

[MoonShadow]

Manually perform your import. It will bring up it's last import map which may be the one in which you are referring. If so, just unclick (turn to o the reviewer comments map line) then perform the import. Then open your import script. Close it. When closing, it will ask if you want to Keep or Replace. Select Replace.