Jump to content

MySQL - ODBC Two Way

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

Recommended Posts

  • Newbies

Okay, seemingly simple problem, yet no aparent solution to me after hours of searching on the topic, so any help is greatly appreciated :)

I have a FileMaker 6 database that consists of all computers in the school district I work for, done by one of our assistant principals, along with fields for problems and tickets. Working in the Technology department, I wrote a PHP application to be used for web problem ticketing... teachers and faculty can report problems, it creates a ticket, and then allows for administrators and IT personnel to update the status of that ticket, and even view history per computer by their unique town asset tag.

I can import these tickets into my Filemaker database just using ODBC and the vanilla MySQL driver available from their website, and it works great... can now view history per tag inside of filemaker, and all the fields match up perfectly after a little bit of doctoring. So, I have my ticket program that makes tickets and Filemaker which can manually get those tickets from my MySQL database.

I realize this action can be scripted.. i'd really like to do that at some point.. I have yet to find the time to do so. But that is besides the point.. my true question lies with getting the data out of Filemaker and into MySQL. I would like to be able to update these tickets and computer history, and possibly be able to add additional computers, inside Filemaker, and then export these (preferably over ODBC) to my MySQL database. Nowhere have I found any real useful information on how to do so, and I am almost positive it can be accomplished (possibly using the Execute SQL script step I was reading about?)

Personally having about 3 days of experience with Filemaker (I had nothing to do with the building of the computer database, and I didn't even know about it when writing the PHP app), I'd love for there to be a more simple way to update these tickets with a two way system rather than one. If anybody is aware of something, I would greatly appreciate any input on how to do so. Thanks for your time.

Link to comment
Share on other sites

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