I am in the process of moving a number of tables of data from a
access databases into a single backend mysql database. In doing so
some of the tables and relationships have been reconfigured in the
mysql db.
In one particular case the companyid of a contact that once was
maintained directly on a contact table record would now be maintained
in a many-to-many intermediate table of company_contacts. As I
perfrom the import of the company and contact records into mysql is
there a way to build the intermediate table of company_contacts as
the companys and contacts table are being converted or must this be
done after both tables have been rebuilt?
I'm having the same issue with maintaining contact email addresses in
a separate table. I would like to be able to build a temporary
lookup list of all emails, providing it with an id, currently in the
contacts table and then assign the proper id for the given email in
the newly built mysql table. I guess I would have to build the temp
list first in the workbench which would mean looking through the
entire source table first before processing each record in the table
afterward for the remaining conversion tasks. I'm not sure how you do
that?
Maybe someone could give me a hint or two on how you might be able to
achieve this sort of task? I've tried doing some searches for this
but haven't gotten anywhere. I'm trying to use the SQL Executor but
am having trouble looking up the email and creating a corresponding
id to set on my contact record.
Join us at the FME Worldwide User Conference Sept. 21-22, 2006 Vancouver BC
Canada. For more information, visit www.safe.com/2006uc.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
