En cours

Web-based data entry application

Project: Data entry forms as web-pages

The project is a web-based Incident Recording Information System. Incidents are “events” involving people / machinery involved in the forestry industry. Typically an incident is an accident and can involve injury and lost time away from the job. A company’s health and safety performance is constantly monitored therefore the data entry screens need to be user-friendly and fast to load

The project consists of entering data, via web-based data entry forms and retrieving data via reports, charts etc. This part of the project focus’s on the data entry forms.

1. Primarily a user will log-on to the system and be verified as a valid user.

2. The user’s level will dictate which tables / forms the user is permitted to add / edit / delete records.

3. The user will also have to be validated by company and restricted to viewing Incident records for the company they are associated with. For example, a user for ABC Company can only add / edit records for ABC Company and no other companies.

4. The main form revolves around the Incident table. This table has a number of foreign key fields:

Field Foreign relationship

SubCompanyID [url removed, login to view]

OSHCategoryID [url removed, login to view]

ForestID [url removed, login to view]

OperationID [url removed, login to view]

TaskID [url removed, login to view]

EmpStatusID [url removed, login to view]

TaskQualID [url removed, login to view]

WindID [url removed, login to view]

TemperatureID [url removed, login to view]

TerrainID [url removed, login to view]

VehicleID [url removed, login to view]

IncidentCauseID [url removed, login to view]

StatusID Tbl_StatusID

5. Users should be able to filter the recordsets by status

6. There are also two sub-forms or child tables related to the Incident table. These tables are tbl_InjuryDetails and tbl_TreatmentRec

7. tbl_InjuryDetails shows the details of the injury or injuries received in the incident. For this form, the BodyPartClassID is filtered from the Body part, for example, if the user selects the Head as the Body Part, then the Body Part Class ID field, will show the parts of the head. This field is an international classification and used by Accident Compensation Corporation type places around the world.

8. tlb_TreatmentRec shows the details of the treatment or treatments received over a period of time and the number of lost hours. When this column is added together, it should show the total number of lost hours. In this table, a user could determine the number of lost hours as a result of injuries to specific parts of the body.

FORM LAYOUT

An attempt has already been made for the Incident form but I think it might be better split so that the first page a user arrives at is the datagrid showing the basic information for an incident. In this grid it would be good to allow the user to directly access the treatment records and injury details forms to either add records to or edit / delete records

Incident Main Page

IncidentID Description Status Treatment Injury Details

1 Fell off log Open Treatment Injury

When the user clicks on a record ID, then the IncidentID parameter is passed to the Record Form. If the user clicks on Treatment then the IncidentID is passed to the Treatment Records Page and if the user clicks on Injury then the IncidentID is passed to the Injury Details page. The Incident Record Form will be a tabular form whereas the Injury Details and Treatment Records pages will be editable grids.

When the user has finished entering the data for the record page, it would be good to show the record on the page and then give the user the option to add a new record, or edit / delete the displayed record. There should also be a button to return to the Previous main page.

For the editable grids, the user should be able to continue entering records with an option to return to the Main Incident page. This page is called “[url removed, login to view]” and is working in that it was loading the IncidentRecord page and passing the correct parameter however, I encountered a problem with this page and not sure how to fix it.

APPLICATION MAIN PAGE

1. Welcome screen with Login details. Name and Password. The page also needs to look up the user’s company and level. Only administrators can change / add / delete specific pages:

2. The user’s company needs to be stored as the incident records loaded into the datagrid on the Incident Main Page can only be for records relating to the user’s company. There are a number of companies involved and the data is confidential to each company.

3. A number of smaller forms have already been developed in Codecharge studio. There are a number of smaller forms which allow the users, with administration rights, to add data to the tables. These tables are listbox controls or combo boxes in the main forms.

Form Table

Activity Tbl_Activity

BodyPart Tlb_Bodypart

Company Tbl_company

CoyDescription Tbl_coyDescription

EmpStatus Tbl_empstatus

IncidentCause Tbl_incidentcause

incidentMain Tbl_incident

incidentRecord

incidentTreatment Tbl_treatmentrec

* Not built Tbl_injurydetails

incidentType Tbl_incidenttype

InjuryType Tbl_InjuryType

Level tbl_level

Operation Tbl_operation

OSHCategory Tbl_OSHCategory

Profile Tbl_profile

Region Tbl_region

Status Tbl_status

subCompany tbl_subcompany

Task tbl_task

taskQual

Tbl_taskQual

Terrain Tbl_terrain

Treatment Tbl_treatment

Users Tbl_users

Vehicle Tbl_vehicle

Weather tbl_weather

With the exception of the items marked with a *, all of these forms are built and working. I used Codecharge Studio builders to construct the Grid / Record forms. I think that for these types of tables, the style of the form is suitable but ideas are always welcomed.

These forms need to be limited so that Users can access the pages for IncidentMain, IncidentRecord, IncidentTreament and IncidentInjury but the user is only permitted to access records for their company. All other pages can only be accessed by System Administrators.

Security has not been attempted at all because I am not sure how.

These forms need to be tied together either with a menu or buttons. If possible, it would be good to show the pages as TAB buttons to create the illusion of TAB forms

4. The Main Form starts with IncidentMain. I have started this and created a grid which allows a user to edit an existing record or view / add / edit Treatment Records and Injury Records. As there could be multiple treatments and multiple injuries, I considered that it would be best to keep these in their own tables and treat them as child forms. Originally I had these displayed on the same form as the Incident Record but it looked rather messy so opted to keep them on separate pages. There is a word document accompanying this one, which has some screen shots of an existing access application. This will give an indication of what type of form the current users are using. I did create the form originally as a TAB layout and then modified the HTML to create a different layout, however, if a similar form to the access project could be created, it would be great.

5. When a user has entered a record and clicked the ADD / SUBMIT button, then I think that the user should be returned to IncidentMain where they can click Treatment or Injury to enter the details in these forms.

6. Treatment Records and Injury Details are related to the IncidentID of the Incident Form. I feel that these forms would suit an editable grid with dro-down list box controls for the foreign fields. The user should be able to enter multiple records before selecting the submit button i.e. submit multiple records

Treatment Records: Foreign fields are TreatmentID [url removed, login to view]; IncidentTypeID [url removed, login to view]

Injury Records: Foreign fields are: BodyPartClassID [url removed, login to view]; ProfileID [url removed, login to view]; InjuryCauseID [url removed, login to view]

For the body Part class ID, this is a list of international classifications for a Body part. Ideally, the user would select a Body Part, in one field, and then have the next field display the BodyPartClass items which are members of the Body Part

Basically the application should have the look and feel of a windows application, with the exception that it is delivered by web pages.

Forms need to load quickly – the client has indicated 15 seconds over a 56K modem.

It is a fairly straight-forward application and needs to flow and be easy to use.

List of Priorities:

1. Have Incident Form and associated child forms working and entering data into the correct tables

2. Make the application flow with menus / buttons

3. Add security and make screens so that users can only view their own company data

Compétences : .NET, ASP

Voir plus : data entry application, web based data entry, data entry web application, application data entry, web data entry application, web application data entry, data entry applications, data entry application ipaq, select grid fields codecharge, world best web pages, world best web page, world best web, working first data, working data entry, word data entry form, windows security administration, web page data entry, web illusion, web form data entry, web application companies, types data entry fields, total safety, think together, best data entry company, sure web

Concernant l'employeur :
( 51 commentaires ) Cambridge, New Zealand

N° du projet : #3251

Décerné à :

sunilkar

Hi. Please find my details as I mentioned in my previous bid. Thanks.

100 $ USD en 4 jours
(5 Commentaires)
4.1

20 freelance ont fait une offre moyenne de 91 $ pour ce travail

siddhartha1

Hi we have gone through ur dicription and we can do it within said time

95 $ USD en 20 jours
(11 Commentaires)
6.7
teckit

I would love to do this. I will meet you deadline for priorityes 1, and 2 lets get started for $200

100 $ USD en 5 jours
(13 Commentaires)
6.1
ocsinfoway

More than 10yrs of experience in IT from India, focussed on web based design & development We are available for support on MSN & yahoo messenger (3 am GMT to 3 PM GMT - Monday to Saturday). Please check ME Plus

100 $ USD en 6 jours
(1 Commentaire)
4.8
viaden

Hello! Thanks for reviewing our bid! Viaden Inc is a US based, webdesign and development company with a decade of experience in the field and over 600 successfully completed works which vary from simple Online shop Pag Plus

100 $ USD en 14 jours
(1 Commentaire)
3.8
nidle

Dear Sir. Thank you for posting your bid. We had carefully examined your requirements and are glad to tell you that ALL OF THE REQUIREMENTS CAN BE EASILY DONE by our team. Our company is well-known for EXPERIENCED AND Plus

100 $ USD en 14 jours
(1 Commentaire)
3.7
sevenapps

Our bid is for really very high quality work for your Web-based data entry application that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our bid inc Plus

100 $ USD en 1 jour
(1 Commentaire)
3.4
nateshdange

I will complete the project with in 30 days.

100 $ USD en 30 jours
(0 Commentaires)
0.0
telysium

How about paying more than a hundred bucks you cheap ass. Are you a developer who doesn't have the skills to complete this project so you come here to get it done by someone else? There are too many bad programmers o Plus

20 $ USD en 999 jours
(0 Commentaires)
0.0
calcalus

Hi, We are offshore development company in chennai, india. We have expertise in PHP, Designing, Server administration, Testing, and support operators exclusively for your projects please do see our works at: Plus

100 $ USD en 20 jours
(0 Commentaires)
0.0
braintechno

Hi, we have reviewed your requirements and we can provide you experts for completing your assignment in time. Please review the following references of dataentry work done by us: 1. data Entry od Boats for memb Plus

20 $ USD en 10 jours
(0 Commentaires)
0.0
tanuj97

please see pmb for details

100 $ USD en 40 jours
(0 Commentaires)
1.4
rajni

Hello We can do it for you regards

100 $ USD en 30 jours
(0 Commentaires)
0.0
sunnygarden

please visit wwwsourcingtech.com for complete information Thanking You Sunil Sr. Market Research Analyst Sourcing Tech

100 $ USD en 25 jours
(0 Commentaires)
0.0
Rajshree

Yes we can do it

100 $ USD en 30 jours
(0 Commentaires)
0.0
OliverTauth

I have experience in any type of .NET / SQL development for Windows. Mostly adapting/converting somebody else's sources - so I will be able to efficiently complete your Application. Priority 1 'til Friday is three!! da Plus

100 $ USD en 30 jours
(0 Commentaires)
0.0
sinhankb

Hi, I can develope accordingly you. Your Satisfaction will be my first step. Regards,

100 $ USD en 30 jours
(0 Commentaires)
0.0
Maestors

Sir,i have read your specifications in detail.We can do your work in specified time. Regards,Rashmi,Maestros Infomedia Inc.

80 $ USD en 40 jours
(0 Commentaires)
0.0
nitinkhachar

Hello, We are eager to take up your project. We already have a set of modules ready so we can complete your project very fast. We have the login module,menu module and add/edit/delete module ready to integrate a Plus

100 $ USD en 10 jours
(0 Commentaires)
0.0
Dassh

We can definetly do this within the mentioned timeline with great quality.

95 $ USD en 25 jours
(0 Commentaires)
0.0