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
