Ipad Data Collection App

This project is for the creation of a custom data entry program so employees can enter data into an iPad when visiting customers, transmit data to a web server and generate reports. It will have 3 main components:

1. iPad app with several electronic forms and a navigation menu.

2. Data transfer program to transfer the collected data to a database on a web server.

3. A web application to conduct simple calculations on the data within the database, print a preformatted report and allow for simple online queries.

The hardware that we will use is as follows:

- Data Collection would be done on iPads.

- Currently we use Linux-based shared web hosting. If we would need a different type of hosting or OS please indicate what is needed in a PM.

Below are details of how the program should work -

iPad App:

(1) When the app is opened it should show a main navigation screen with options: (a) start work (b) end work (c) view incomplete work (d) find customer (e) find record.

(2) When the user visits a customer he selects “start work” which directs him to an electronic form (“Customer Form”) and he enters common information for the customer and the number of Main Forms to be completed at that customer. He then completes as many Main Forms as needed and then clicks “end work” when done. All Main Forms entered between “start work” and “end work” should be associated with that specific customer. Date, start and end time should be recorded.

(3) When “end work” is selected, the screen should show the target number of Main Forms, the actual number completed and the number that remain. He should then have the option to select one of the following options: (a) work complete–end work, (b) work incomplete, schedule another visit, (c) work incomplete–no further visit needed.

(4) Please see the attached file for more detailed information about iPad app.

Data Transfer

(1) Data should be transferred through the internet to the main database on the web server when an internet connection is available. This can be automatic or manual. Data should be encrypted.

Web App:

(1) Data from the iPads will be consolidated and stored in a main database on our web server.

(2) There is 1 pre-defined print reports that should be generated by this app. The user should be prompted to enter the customer name and a few other data items (address, contact name, etc.) that will be used to generate the report.

(3) The calculations for the report are simple addition / subtraction from the collected data and from some defined variables (about 15 variables). There should be a way for the user/admin to periodically adjust the values of the variables if needed.

(4) Parts of the print reports are fixed, but the text should be editable before printing so that the user can change, add or deleted words or sentences.

(5) See the attached file for more info about the report and calculations.

(6) There will be 4 basic on-screen reports: (a) list of customers visited during a selected time period, (b) list of customers visited by employee (c) list of incomplete visits (d) customer overview

(7) There should be a way to export data to Excel.

(8) There should be a simple way to backup the main database.

The app should be simple to use. If your approach requires specific hardware or software, please indicate in a PM. If you need more detailed information, diagrams, flow chart, sample screens or sample reports please let us know.

If you have any questions, please ask before bidding.

1. For the Web App, there would need to be password protected access to the app and a method for an admin to set up users and passwords.

iPad MySQL Objective C PHP

Projekt-ID: #979204

Über das Projekt