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
