I work for a company called Odyssey Press (www.odysseypress.com)
however our online ordering is for our publisher customers so it is
not something that can be accessed by the general public. There is
some information about the systems on our website.
I have been on the phone much with filemaker since upgrading to 9. I
am having huge printing issues from PC's. The program crashes after
printing. Multiple printers, multiple computers. Not so with macs.
Good luck and let me know if you have any questions. The integration
was fairly easy in my opinion.
Tammy
On Jan 2, 2008, at 4:29 PM, Tom Bowman wrote:
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
