|
Question:
How do I setup a web page for users to enter maintenance requests.
Answer: ExpressRequest
is a simple program for users to enter maintenance requests via the
network. Request are written directly into the ExpressMaintenance
database for processing into work orders. In addition, maintenance
requests can be entered via a web page interface directly into the Requests table
of the ExpressMaintenance SQL database.
We provide you with sample .asp files which you simply adjust to connect
to your server and to fit your organization needs.
Using a website development
tool such as FrontPage, you can easily edit the sample website pages to
work in your environment. You must have your the computer which
contains the SQL Server or MSDE on the network or the internet in order
to use this feature. Your web page must include a connection to
the ExpressMaintenance SQL database and the Requests table. To
make this connection please follow the steps below.
Setting
Up Web Requesting
1. Begin by
setting up your website and web pages as desired
2. Include
the three sample web pages we provide which are eRequest.asp,
eRequestOk.asp and eRequestErr.asp.
Download the .asp Files in Zip Format.
3. Using
FrontPage, open the website and locate the eRequest.asp page
4. Right
click on the requesting form and left click on Form Properties
5. Click on
Send To Database radio button
6. Click on
Options button and the dialog will appear as shown below
7. Click the
Add Connection button and a new dialog will appear
8. Click the
Add button to add a connection to the list and the following dialog will
appear
9. Enter the
database name of ExpressMaintenance
10. Click on
the "Network Connection to database server" radio button
11. Click the
Browse button to select the SQL Server as shown below
12. Select
SQL Server, Enter your Server Name that contains your ExpressMaintenance
SQL database. When you run ExpressMaintenance, the server name
appears in the bottom left for reference.
13. Enter
ExpressMaintenance for the database name
14. Click the
OK button and then click Advanced button to enter authorization info
15. Enter the
Username such a "sa" or "etuser" and the corresponding password.
We recommend using "etuser" and "etrik22" as the password.
16. Click the
Ok button to return and then click the Ok button again for the Site
Setting dialog as shown below.
17. Click the
Verify button to test the connection
18. Once the
connection is verified, click the Ok button to see the main form
database options as shown below
19. Select
the new connection of ExpressMaintenance
20. Click on
the table list and select the Requests table
21. After
selecting the Requests table enter the URL for the confirmation page and
the error page. We recommend using the supplied asp files
eRequestOk.asp and eRequestErr.asp.
22. Click Ok
to save the settings and Ok again to save Form Properties
23. Publish
and test your web page
You may with
to make various adjustments in the forms and pages by adding
instructions and other fields. Because the data is written
directly to the ExpressMaintenance SQL database, you have much
flexibility. There are other advanced features that can be added
by experienced asp developers. |
