Jump to content

Problem with field orders


Aditya
 Share

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

Recommended Posts

Hi All,

I am facing a problem with the importing order. I created a FM file where I want to import the data from another excel file on a regular basis. The probelm started with as I missed one field to define in filemaker table matching with the excel file so i created new field and moved to the desired location in "define field" . Now whenever I try importing the data, the new field is always in last and I can not correct the problem using the "view by". I can not use the matching names as the excel table contains data only and no field.

any help will be appreciated.

Thanks

Aditya

Link to comment
Share on other sites

Import the excel data correctly: You can move the filemaker fields to the correct position on the right hand pane of the Import Field Mapping window. Just click on the field name and drag it up or down.

When the import is complete, create a script with the 'import records' step, and make sure 'Restore import order' is checked.

If the excel file always has the same name, select it from the 'pecify file...' button, and check the 'Perform without dialog' box.

Link to comment
Share on other sites

This topic is 7418 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
 Share

×
×
  • Create New...

Important Information

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