Hi there,
I am stuck with a problem.We are a screen printing company running an ERP application developed using PHP over PostgreSql.
One of the modules is Art Department. The Art department makes the art (we call it spec) and stores the art (jpeg images/spec) onto their server. The ERP application is on a Linux m/c while the Art server is a windows box. The Art department has to link the art (spec/image) to a particular job. The way it has been set up currently is that Art department first makes the art (images/specs) and saves it onto their server (Windows Box). They then import (copy) the art (image/spec) from the art server onto the Linux box and further link it to a particular job. This is a lengthy three step procedure and they have to spend a lot of time behind all this.
What i want to do is - eliminate the import option so that they can link the spec (which is residing on the Art Server) directly to the job (the information for this job is however on the Linux m/c). I have my database set up so that it can store the path. But how do i make these two machines to talk to each other ?
For eg: The erp application is under
/usr/local/erp/ folder on a linux box
The art dept is on a windows box
\FS1\SPECS folder on windows box
my document root in httpd.conf is pointing to /usr/local/erp. So by default it looks for everything - under the /usr/local/erp/.
hope this makes sense
i would really appreciate if you could solve my problem.
Let me know if you require any further clarifications.
Thank you
Viv