Ok, cool. Not sure if we'd need to print too much out of FM -- at least
hopefully not until they fixed whatever the bugs are.
Thanks again!
Tammy Fleming wrote:
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
