Tammy,
Thanks so much for the info, and the link! I haven't looked at it yet
(because I've been on the phone with FM! lol), but will check it out
soon. Looks like this could be exactly what we need.
Is there anything that I could see online that your company uses, ie.
customers' ordering site, etc.?
Tom
Tammy Fleming wrote:
That is very good news. Now you just need the correct permissions
from the administrator of the mySQL database to the table that holds
your order data. Then you will want to look at this webinar by
filemaker
(http://www.filemaker.com/support/webinars/seminars.html#au10). There
is plenty of documentation on integrating mySQL with Filemaker.
By the way, I do work for a printing company and I have over 70
filemaker databases hosted on our server. We use filemaker for
everything.
Tammy
On Jan 2, 2008, at 2:22 PM, Tom Bowman wrote:
I found out that our system does utilize mySQL -- I belive that is
good news?
Tammy Fleming wrote:
We use Filemaker to connect directly to the database (mySQL on the
web server) that holds actual order. Do you know where that web
order data is stored? Filemaker can connect to several types of
data sources. Can you ask your web developers how the info is stored?
Tammy
On Dec 31, 2007, at 3:58 PM, Tom Bowman wrote:
>Where is the data from the web ordering system stored?<
Thanks for the reply Tammy. That's very encouraging to hear. I am
not sure if you are referring to the data of the actual web system,
as it's ordered, or to the data that we pull off it, and then store
locally. Does it make a difference in how FM interacts with the
ordering system?
Tammy Fleming wrote:
We just integrated our internal Filemaker order processing system
with the mySQL database that holds the web orders. Where is the
data from the web ordering system stored? You will need Filemaker
9 to use the ESS functionality. Good Luck and Happy New Year!
Tammy
On Dec 31, 2007, at 3:21 PM, Tom Bowman wrote:
Hi All:
New to the list. I owned my own printing company for a quite some
time, and used FM for all our database needs. I loved what it
could do.
I now am directing a department for a transcription company. They
have an online order placing system, whereby clients can go in
and place orders, and a confirmation email order form will be
sent out to us. However, from there, all this data is being
re-entered (manually, piece by piece) back into a spreadsheet
which resides on our network -- extremely tedious!
I would think that FM has some sort of solution that would allow
us to interface from our local network, with a similar web-based
ordering system, and be able to enter locally a piece of data,
say the confirmation number, from the online system, and have all
the rest of the data flow into related fields back into the local
database(s). Can anyone confirm that this is possible?
Thanks -- and Happy New Year!!
Tom
