Jump to content

Importing Problem


Andrew Q
 Share

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

Recommended Posts

I'm trying to import an excel file(contains product info) into my FM database.

I've got 2 tables. Product and Customer. I have already setup the customer table with username_old and username_new fields.

So when I'm importing the product info from excel into the product table, I have an auto-enter calc field which will calc the new username based on the old username from the excel file.

My problem comes when the calc is not working. Is FM not able to do an auto-calc the same time it is importing the data? I don't know what I'm doing wrong. :o

I have attached a sample file in case my explanation is confusing.

import.zip

Link to comment
Share on other sites

It seems as though you are trying to use the customer table to do a translation of the old username from the imported excel file to the new user name when the import is done in the products table.

The relationship should be keyed by the username_old fields. Then in your auto enter calculation, all you need to do is reference the related 'contact::username_new' field. So then when an import is done into the products table with data that contains the old user name, it will populate the product::username_new field with the matching value from the contacts table.

Link to comment
Share on other sites

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