Jump to content
Larry Ullman's Book Forums

Recommended Posts

I have a database(Using Filemaker) of contact info .ie name, email address ect...I want to import the data into a mysql table...my question... can mysl create a hash(and insert it into a column say called hash) to be associated with each contact?

Share this post


Link to post
Share on other sites

You can kind of do this, but the data won't be very useful in MySQL if stored that way. I would either export it from Filemaker as a CSV and then import it into MySQL as discrete fields, or go to MongoDB with the data stored as documents.

Share this post


Link to post
Share on other sites

Hey Thanks Larry for the tips.... After sleeping on this  I thought about first creating a hash field in FM and then exporting to MySQL..I believe a hash  can be created with some FM scripting...Thanks for you idea on exporting as CSV...

 

Regards

David

Share this post


Link to post
Share on other sites

I think I was asking question wrong..I want to create a unique id  ie. $active =md5(uniqid(rand(), true)); as used to activate a user...I want each contact to have its own random id say anywhere from 10 plus  characters long.  Sorry for the confusion...I think my best bet is to create this in FM. I just was not sure if MySQLI had a way of creating it as opposed to creating with it with PHP and then inserting into MySQL....I am just not very familiar yet with MySQL. Thank you David

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...