Dali Posted November 17, 2006 Posted November 17, 2006 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
Dali Posted November 17, 2006 Author Posted November 17, 2006 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.
Recommended Posts
This topic is 6581 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 accountSign in
Already have an account? Sign in here.
Sign In Now