Greetings,

My apologies for the long winded introduction.

I'm working on a asset management database using PHP and MYSQL. The
purchasing rep (in our department) currently enters a purchase order
into an Access 2.0 database written back in 1994. Access generates the
purchase order, prints it onto a standard 3 part form and dumps a copy
into a table. The form itself is sent off to the various departments
for approval and signatures then our Supply department processes the
order via Peoplesoft. I do not have access to the Peoplesoft
database.

At some point in the following weeks (or months) something shows up at
our door. The incoming packages are now logged on paper. In some
days we only receive a couple dozen packages and other days we
received a few hundred. This would not really be a problem if the
number of packages were limited but legibly documenting the 18 digit
tracking number, source and destination for a few hundred boxes can be
daunting.

Each of these should be matched to a purchase order. If someone
cannot "remember" where the package is suppose to go then we have to
sort through each and every purchase order for the past couple of
months until we figure out who it might belong too. This gets
complicated when you have multiple people ordering the same item and
some of our customers are not honest enough to tell us when they
already received something so they may get the same item twice while
others never receive their order.

I am coding a PHP front end using RHE, PHP5 and MySQL5 (all of which
is fairly new to me). I'm going to automate this process by using
barcode scanners to scan the incoming stock and automatically matching
the UPC code to the oldest purchase order. The barcode scanner will
be wireless and will dump the data into MySQL using ODBC without any
user involvement. The second part of the process is where I need your
.

1 - When the purchase orders are entered into the database I would
prefer the name is matched to someone in our Global Address Book
(Exchange) and the query returns the email address of the person. I
read a vague reference to a VB script somewhere but I did not think
VBScripts would execute on RHE?

2 - I would like to setup a trigger that automatically generates an
email (either via POP3 or Exchange) that alerts the owner of the
package when it arrives. The alert should be sent automatically.

The only constraint is that none of this can be client based. The
entire process has to be done from the server without any interaction
from an end user. I can make any adjustments I want to the server and
the PHP based front end (which has to be void of any Javascript). So
basically.. I can't depend on the person doing the scanning to send
the email.

I have learned how to install and configure a linux box, install PHP/
MySQL, build a MySQL database with several properly normalized tables,
install/configure Apache, secure the apps and build the front end.
The server is housed inside our corporate network.

I'm all for learning something new so i'm not expecting anyone to
complete this part of the project for me but I do need enough
direction that i'm not going to be lost at sea. I'm reading SQL for
MySQL Developers: A Comprehensive Tutorial and Reference by Rick F.
van der Lans which is quite good. If you have any suggestions for
books, web-based material or even a script of your own that I could
modify then that would be greatly appreciated.

Any other suggestions, thoughts would be ful.

Thank you for any in advance!

Best Regards,
Dave
Phoenix, AZ.

On 1 Oct, 07:19, "dogatemycompu...@gmail.com"
<dogatemycompu...@gmail.com> wrote:
> Greetings,
>
> My apologies for the long winded introduction.
>
> I'm working on a asset management database using PHP and MYSQL. The
> purchasing rep (in our department) currently enters a purchase order
> into an Access 2.0 database written back in 1994. Access generates the
> purchase order, prints it onto a standard 3 part form and dumps a copy
> into a table. The form itself is sent off to the various departments
> for approval and signatures then our Supply department processes the
> order via Peoplesoft. I do not have access to the Peoplesoft
> database.
>
> At some point in the following weeks (or months) something shows up at
> our door. The incoming packages are now logged on paper. In some
> days we only receive a couple dozen packages and other days we
> received a few hundred. This would not really be a problem if the
> number of packages were limited but legibly documenting the 18 digit
> tracking number, source and destination for a few hundred boxes can be
> daunting.
>
> Each of these should be matched to a purchase order. If someone
> cannot "remember" where the package is suppose to go then we have to
> sort through each and every purchase order for the past couple of
> months until we figure out who it might belong too. This gets
> complicated when you have multiple people ordering the same item and
> some of our customers are not honest enough to tell us when they
> already received something so they may get the same item twice while
> others never receive their order.
>
> I am coding a PHP front end using RHE, PHP5 and MySQL5 (all of which
> is fairly new to me). I'm going to automate this process by using
> barcode scanners to scan the incoming stock and automatically matching
> the UPC code to the oldest purchase order. The barcode scanner will
> be wireless and will dump the data into MySQL using ODBC without any
> user involvement. The second part of the process is where I need your
> .
>
> 1 - When the purchase orders are entered into the database I would
> prefer the name is matched to someone in our Global Address Book
> (Exchange) and the query returns the email address of the person. I
> read a vague reference to a VB script somewhere but I did not think
> VBScripts would execute on RHE?
>
> 2 - I would like to setup a trigger that automatically generates an
> email (either via POP3 or Exchange) that alerts the owner of the
> package when it arrives. The alert should be sent automatically.
>
> The only constraint is that none of this can be client based. The
> entire process has to be done from the server without any interaction
> from an end user. I can make any adjustments I want to the server and
> the PHP based front end (which has to be void of any Javascript). So
> basically.. I can't depend on the person doing the scanning to send
> the email.
>
> I have learned how to install and configure a linux box, install PHP/
> MySQL, build a MySQL database with several properly normalized tables,
> install/configure Apache, secure the apps and build the front end.
> The server is housed inside our corporate network.
>
> I'm all for learning something new so i'm not expecting anyone to
> complete this part of the project for me but I do need enough
> direction that i'm not going to be lost at sea. I'm reading SQL for
> MySQL Developers: A Comprehensive Tutorial and Reference by Rick F.
> van der Lans which is quite good. If you have any suggestions for
> books, web-based material or even a script of your own that I could
> modify then that would be greatly appreciated.
>
> Any other suggestions, thoughts would be ful.
>
> Thank you for any in advance!
>
> Best Regards,
> Dave
> Phoenix, AZ.

What is RHE?

Captain Paralytic says...

> > I am coding a PHP front end using RHE, PHP5 and MySQL5 (all of which
> > is fairly new to me).

> What is RHE?

Red Hat Enterprise O/S?

GM

On 1 Oct, 11:18, Geoff Muldoon <geoff.muld...@trap.gmail.com> wrote:
> Captain Paralytic says...
>
> > > I am coding a PHP front end using RHE, PHP5 and MySQL5 (all of which
> > > is fairly new to me).
> > What is RHE?
>
> Red Hat Enterprise O/S?
>
> GM

Thanks. I checked acronyms.com but that was not one of the choices.

On 1 Oct, 07:19, "dogatemycompu...@gmail.com"
<dogatemycompu...@gmail.com> wrote:
> 1 - When the purchase orders are entered into the database I would
> prefer the name is matched to someone in our Global Address Book
> (Exchange) and the query returns the email address of the person. I
> read a vague reference to a VB script somewhere but I did not think
> VBScripts would execute on RHE?

So convert the VB scripts to PHP scripts and run them instead