信息技術系實踐報告三（英語版）
Information Technology
Author: X. Zhong Page 6
Project: RG Truck Management
Description
The RG Truck Management tool is a brand new application to help user manage
RG truck group in the Dailylog, a web sy
stem that used by engineers at NACCO. It
allows user to view all RG truck groups, and let RG engineers edit group data and
add new groups. This application also collapses previous method of custom page for
each truck group to one generic page that takes the truck group name as an
argument.
Solution
Before this tool, when the RG engineers want to collect information about a truck
group, they have to give a list of the trucks they want to be in the group to the IT
staff. The IT staff then hard code those truck into an asp file that pulls all the data the
engineers needs from the database and lists in a table. They give the URL of this
asp file to the engineers to import into Excel to gather and graph their data.
Obviously, this process is quiet cumbersome. It takes a lot of time and work for the
IT staff, since for each new truck group the engineers request, they need to create a
new separate asp file. It is also a hassle for the engineers as well, because for every
new groups they need, they have to contact IT, and wait for that special URL, not
counting the huge amount of work spent on maintaining, storing and keeping tracks
all the files and URLs on both ends.
The new web tool makes the RG truck group management process much easier. It
consists of two parts: interfaces and a dynamic asp data collecting file. Instead of
requesting through IT staff each time, the engineers can go to the display page of
the web tool to see all the existing truck groups and the trucks in those groups. With
the right administrative rights, user can also add a new truck group or edit an
existing truck group simply by
clicking on the appropriate links that only show up for
this group of users. Once a truck group is in the system, the tool will auto generate a
URL for the users to import into Excel to get their data. Behind this URL, there is just
one asp file that takes a dynamic argument, the truck group name, and pull all the
data associate with this group from the database accordingly. This is dramatically
better than having to create and maintain multiple files. Now, everyone who needs
the data can just get it themselves online without waiting on multiple parties that are
involved in the process.
Conclusion
The new application simplifies the maintenance drastically. It gives users more
control without constant needs for IT intervention. Since the tool recognizes each
user’s credential, it secures the viewing
and editing of the data. Overall it improves
productivity and speeds up the process. When I presented this tool to the engineers
and leadership teams at NACOO, it was very well received.
Technologies used (new skills in bold):ASP, HTML, SQL Sever 2005
【信息技術系實踐報告三（英語版）】相關文章：