Devam Ediyor

WEB Service to Update a Configuration Database

Craft a simple WEB service and associated front end to update an application's configuration database.

Purpose:

We have a VB Fleet Management Server that stores all it's configuration parameters (vehicles, vehicle groups, passwords, status, etc...) in a database. Supported DBs include: MS SQL Server, MS Access, Oracle(9 & 10), MySQL. The application has it's own UI to allow users to administer the system. All this works very well except it is not easy to do remotely. Users must physically interact with the application which means they need console access to the server running it. We have a plan to craft a web service that will effectively "back door" the application by updating its configuration database directly.

High Level Requirements:

1. WEB Service must be a stand alone CGI script (Python preferred). No application server should be necessary. Basically, we want to copy this to the target machine, then type a URL to reach it:

http://someserver/cgi-bin/[url removed, login to view]

The WEB server will be either IIS or a small stand alone web server such as Mongoose.

2. Must provide a WEB front end to allow all necessary administration updates. We can provide numerous screen shots of the current VB application and a bunch of SQL statements that it uses to do it's thing. Plain HTML and/or JavaScript should be used to faciliate the front end. We're ok with using something like EXT or jQuery to build the WEB UI as long as it's not too "over the top". We want to keep things simple and easily maintainable.

3. Must provide user logon capabilities.

4. Must provide a log table of the changes it makes to the DB - keep this simple. This is the table that the Fleet management app will periodically scan to know that changes have been made.

5. We would expect a lot of questions about the schema and specifics of the database. In practice, it's fairly straightforward. The application MUST be absolutely perfect when updating, dropping, or creating tables as if it does anything wrong, the Server application may crash. Still, we can provide examples and samples of what needs to happen.

6. We can provide a sandbox environment for testing or you could run the server application pointed at a local database for development purposes. We also have most (if not all) of the SQL statements needed to do everything.

7. We use ODBC to connect to the database. This application should use the same. There are a few differences in creating tables with the various databases (MS SQL, Oracle, MySQL, Access). The WEB application should parse some sort of configuration file with all the necessary run time parameters it needs.

Example Workflow:

1. An admin hits the CGI web service with a browser. Something like: http://configuration/thescript.py

2. Admin is presented with a Log on screen.

3. Upon successful logon, the script connects to DB, fetches the current configuration values and builds a dynamic HTML (Javascript) document that returns to the browser.

4. Admin is then presented with a WEB UI showing those values.

5. Admin can change, update, and edit those values.

6. Admin posts those changes back to the script.

7. Script updates the database accordingly.

8. Script returns the HTML/JavaScript with those changes shown.

9. Admin continues to make more changes or logs off.

10. A good way to visualize how we envision this service is your home network router - you go to the URL http://your_router:8080 and are presented with several tabs of information that can be edited and reviewed. Each time you change something, the entire WEB page is refreshed with those changes. This is the "CGI" model of WEB services.

Additional Clarification:

1. The information included in the "configuration tables" contain items such as:

a. Vehicles and Device Serial Numbers

b. Which vehicles belong in which group (e.g. fire trucks, taxis, busses, snow plows, etc...)

c. Information about how a mapping client should render them (e.g. blue police cars, red fire trucks, yellow taxis)

d. Information about user passwords to control access to the fleet (e.g. PW:"fire" only allows the user to see fire trucks. PW:"taxi" only allows the user to see taxis cabs. PW:"all" allows the user to see all vehicle groups

e. Information about the specifics of the vehicles (e.g. does it have lights, sirens, plows, doors, etc...)

2. There is only ONE database. It may be a MSSQL, Oracle, or MySQL DB, but there is only one. WEB service does NOT have to connect to multiple DBs. Regardless of the DB, the schema for the tables is the same.

3. The administration web site will NOT be high traffic. For the most part, an admin will logon, setup the fleet, then change very little. Periodically, he will logon again to add/remove vehicles or change their properties.

Beceriler: AJAX, Javascript, Python, Web Sitesi Tasarımı

Daha fazlasını görün: web service update database javascript, web configuration database table, what is system ui, what is a web script, what does purpose means, what are databases and what are they used for, web server script, web server in javascript, web server development, web development works, web development using html 5, web development system requirements, web development made easy, web back end development, web app examples, web anything, ui status, top in oracle sql, top 1 sql oracle, sql top oracle, sql oracle top, simple web application examples, service database access, service 5, schema update

İşveren Hakkında:
( 0 değerlendirme ) Centennial, United States

Proje NO: #755967

13 freelancer bu iş için ortalamada 1269$ teklif veriyor

USAGraphicPR0

********************************************.. YOUR SEARCH ENDS HERE .. ********************************************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and get Daha fazlası

in 10 gün içinde1500$ USD
(125 Değerlendirme)
8.1
becomeexpert

Quality is a great issue. Please have a look at our profile, reviews and portfolio ( [url removed, login to view] ) before selecting the winning bidder. Thanks, Tonmay

in 30 gün içinde1500$ USD
(51 Değerlendirme)
7.2
agstech123

Hi, please check PMB to know more about our technical expertise and capabilities. Regards, Ricku Lohar

in 25 gün içinde1500$ USD
(8 Değerlendirme)
6.1
jarcinfotech

We are a professionally managed IS0 9001:2008 certified web development company. Our team has extensive experience and we have provided services to reputed companies in US, UK, CANADA & Europe. Currently we have around Daha fazlası

in 32 gün içinde2200$ USD
(5 Değerlendirme)
5.7
swwiz

Please see PM

in 30 gün içinde1250$ USD
(4 Değerlendirme)
5.4
bdimuch

Hello, check PMB please.

in 10 gün içinde800$ USD
(29 Değerlendirme)
5.4
Toshka

We can implement this task using Django or Pylons. Generally, we can write simple CGI Python scripts, but first way is more flexible.

in 30 gün içinde1200$ USD
(11 Değerlendirme)
4.9
ultimatesystem

I am exactly the candidate you require. Check PMB for more details.

in 5 gün içinde1000$ USD
(19 Değerlendirme)
4.9
pydenz

Hello. Can use django to implement your solution. Skilled in python and javascript.

in 30 gün içinde1500$ USD
(0 Değerlendirme)
0.0
al4n

Hi, last 3 year ago, I've to solve almost similar case, not for fleet but for Asset & Maintenance system in onshore/ofshore area, where almost all users have poor connection, below 1200Bps. There are 3 options or combi Daha fazlası

in 12 gün içinde1500$ USD
(0 Değerlendirme)
0.0
arunprasathstyre

Hi, I have a team of 7 People 5 for web designing 1 for logo designing 1 for video editing All these are experts in their respective fields. We have a created a website within 3 hours for a [url removed, login to view] you wan Daha fazlası

in 10 gün içinde750$ USD
(0 Değerlendirme)
0.0
sciweb

I am qualified for this. Please check PM for my work portfolio

in 3 gün içinde800$ USD
(0 Değerlendirme)
0.0
freelances

Great collaboration webbase application. Please consider me to build this unique project.

in 14 gün içinde1000$ USD
(0 Değerlendirme)
0.0