This should be simple
I am looking for a module that will pay employees within an employee database
on a set schedule from the server with no human interaction. Database is written
in access and already exists. System needs to automatically submit forms (that
are generated by the database) to a remote web site/payment gateway and set
an entry in the database indicating that the employee has been paid for each
record. The current gateway system we are going with for this project is standard
Current database setup:
Users: Emp_id: text
The emp_id field is based on the employee&'s ip number. It is the unique identifier
for every user of the system. There is another table called employees, which
will contain the employee&'s user number, name, and standard reserve number.
The application will need to look up the corresponding information for every
user and submit payment to standard reserve from a central company account.
Here is the general type of interface code
That needs to be generated and submitted on the server side:
<form action=https://standardreserve.com/acct/confirm.asp method=”post”>
<input type=”hidden” name=”ACCOUNTID” value=”12345”>
<input type=”hidden” name=”PASSPHRASE” value=”something”>
<input type=”hidden” name=”PAYEE_ACCOUNT” value=”54321”>
<input type=”hidden” name=”AMOUNT” value=”100”>
<input type=”hidden” name=”PAY_IN” value=”1”>
<input type=”hidden” name=”MEMO” value=”Pay $100 to Lori”>
<input type=”hidden” name=”PAYMENT_ID” value=”24242”>
The real trick is setting it up in such a way that it is triggered by the system
clock at timed intervals. This project is ideal for anyone with an in-depth
knowledge of remote scripting and triggers using ansi sql.
working ASP page on server
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.