Hello,

I have tried Google searches but very little is coming up.
If anyone can help... Great, and thanks!

Here's my set up:
1. Bunch of websites with different webforms collecting data sending
it into mysql on server. (Typical data might be a staff registration
form - name, dob, address, experience etc.)
2. I previously bought Navicat as a front end to the mysql (but
haven't started to use or even know what its full features are)
3. I had the free trial of FM
- Created the database structure and imported a copy of the
database (after exporting the csv from navicat)
- This looked pretty nice, easy to search through staff, easy to
read their experience in a larger text area box. So I liked it.

Problems, the changes I made to the FM database of course didn't
affect the mysql on the server so I would then have to export it back
to the server after making the changes. Although I could do other
things - there doesn't seem to be an easy way to have my cake and eat
it with this set up.

I would love something that can edit whats on the server (mysql) oor
something that can make the changes locally and then click a button to
export to server (but then if i have new people registering in the
meanwhile, when I export back to the server, these new entries online
might be wiped over, because the local file I'm now exporting to the
server doesn't reflect these.

So my question is:
1. Does anyone have a similar set up and know of a solution?
2. Does anyone use both Navicat and FM? Know of any tools in either
that can make my job easier?
3. I'm a small business and $300 is a bit pricy for something that
only does half the job I need it to. Do you know of any other software
that could help accomplish this or more?

Thanks for your help.

The rumored FileMaker 9 should do what you need. Just wait a couple months.

<matt (AT) londonstudent (DOT) co.uk> wrote

On May 3, 8:56 am, m... (AT) londonstudent (DOT) co.uk wrote:
The real question is why are you using two databases?

FM supports, via "Instant Web Publishing" a very slick 'cheap and
dirty' way to get layouts published to the web, literally instantly,
but outside of toy websites for 5 people to look at you'll need
servers. Play around with instant web publishing in the free trial, if
you can.

But to deploy it on a larger scale you WILL need servers. And that
will cost considerably more. However, if it does what you need, it
still might be worth it. Its one of the simplest ways to get basic
webforms and databases published onto the internet. The cost of the
software may cover itself in time saved.

Filemaker can also serve as the backend to aribrary websites outside
of IWP via xml queries, and odbc, but those also require servers, and
would only be advisable if you actually needed arbitrary websites to
connect to filemaker. Filemaker doesn't provide any real benefit over
MySQL as a pure odbc website backend, and in fact would be a terrible
choice unless there was an -additional- reason to use filemaker.

But if you prefer or are constrained to use MySQL as the database for
the websites, then really there is no real reason to use FM too.

If the results of Instant Web Publishing (IWP) meet your needs then:
FM Pro 8.5 (or better still FM Advanced 8.5)
plus FM Server 8.5 Advanced.

Otherwise, if you are on a tight budget, and MySQL is *already*
processing all the forms, sticking with MySQL is probably the right
thing to do, and I suggest a mysql centric solution.

-cheers,
Dave

On May 4, 7:58 pm, d-42 <db.pors... (AT) gmail (DOT) com> wrote:
Thanks for your help guys.

Because I already have PHP collecting the data on the server it's hard
for me to let it go and yet I love how FM gives me an easy screen to
search through and view photos next to people's names and stuff.

When I get a chance I'll take a look at the instant web publishing
stuff.

Thanks for the tips.

Matt

On 3 May 2007 08:56:29 -0700, matt (AT) londonstudent (DOT) co.uk wrote:

I'm having similar issues with an FMP database that I need to update
mySQL with. There's no push-button way to do it bit there are a
couple of tools that do help. I tried Navicat, didn't like it. The
best mySQL front-end I've found can be found here:

http://www.heidisql.com/

Have you looked into phpmyadmin? That's at:

www.phpmyadmin.net

Does anyone have a clue when FMP 9 is due out?

--
FW