Jump to content

Importing / Changing field mappings


This topic is 7094 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7094 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.