Jump to content

BUG? import script by matching names


Dali

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

Recommended Posts

Hi, I'm trying to import an excel sheet into a FM table without spawning the mapping window i.e. I don't want users to manually map the field names. I make sure that excel sheet column names match those of FM field names and when run locally it works great. The problem is that when trying to execute the script remotely (over FM server) the field names won't map. Even if I let the mapping window show up I still can not select Arrange by Matching Names, it is grayed out while if I run the script locally it is not. Is this a bug, and is there a way to have this work remotely? I really don't want users to manully map the fields names.

Any suggestions would be appreciated

Thanks

Link to comment
Share on other sites

ok...I was able to do it by using custom order in the import script. It works fine both locally and remotely. What I basically did was line up FM fields from top to bottom in the same order as colums in excel sheet (from left to right). At least now field names don't have match those of excel columns, but the downside is that the import order might get changed when poking around the database.

Link to comment
Share on other sites

This topic is 6342 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.