Attendance Registration

Cancelado Publicado Jan 25, 2012 Pagado a la entrega
Cancelado Pagado a la entrega

The application is going to be used to check and record attendance of children at the daycare of a school. It will be a stand alone application with must be used by employees with very little skills.

The set-up will be a laptop with a barcode reader attached to it. Every day, an export file is created that records the attendance of the childeren in order to invoice the parents and to notify parents that a child is not present, where it should be.

The export file is exchanged with an back-office using dropbox functionality. The back-office will take care of the preparation of the invoice.

## Deliverables

Functional design "Attendance Registration" Version: 2012-01-25_23:22 (CET) Author: Jeroen Gruppen Software development by: [url removed, login to view] Version Remarks/ changes 2012-01-25_23:22 Initial version Table of Contents ? Table of Contents Summary Technical requirements Functional requirements Import function Attendance registration Export function Deliverables ? Summary The application is going to be used to check and record attendance of children at the daycare of a school. It will be a stand alone application with must be used by employees with very little skills. The set-up will be a laptop with a barcode reader attached to it. Every day, an export file is created that records the attendance of the childeren in order to invoice the parents and to notify parents that a child is not present, where it should be. The export file is exchanged with an back-office using dropbox functionality. The back-office will take care of the preparation of the invoice. Technical requirements The application must be able to run on a Windows7 computer (Centrino processor or up, 2 GB RAM, 60 GB hard disk drive) with no additional software requirements. In case this is not possible or desirable, the requirements (e.g. .NET framework, Java run time, etc) must be explicitly be specified upon acceptance of the project by the developer. The minimum screen resolution of the computer is 1024x768, but the application must also run on a higher resolution without any problems. Text displayed in the application (including warning messages or confirmations), must be retrieved from a text file (XML file) which can be altered by the user without the use of other software not part of Windows7. It is not allowed to hard code text in the application code itself, that is presented to the user on the screen. Instead a term code is used that can be maintained in a XML file. Example: This is an string When the user moves the mouse over a text, the term code must be displayed, so the user can determine which term code is used in a specific part of the application. All settings used in the application, must be retrieved from an text file (XML file) which can be altered by the user without the use of any software. It is not allowed to hard code a setting in the application code itself. Example: D:\data\edelsteen\import_directory The attendance application must allow manual keyboard input as well as bar code input (Symbol LS2208SR USB) without the need to specify which input method is used. The application must be able to store up to a maximum of 10.000 transactions. Functional requirements Import function When starting the application, the import directory must be scanned for a new Excel import file. The directory is retrieved from a setting value "import_directory" in the setting XML file. This directory must be scanned for a XLS file. If multiple XLS files exists, then the newest file must be used. Any other file must then be moved to a sub directory called "archive". The XLS file must be made unique by adding a timestamp (yyyy_mm_dd_hhmm) to the current file name. E.g. a file called [url removed, login to view] must be move to archive\[url removed, login to view] After the import is succeeded, the file must be moved to the archive directory, where the file name is made unique by adding a time stamp (yyyy_mm_dd_hhmm) to the current file name. E.g. a file called [url removed, login to view] must be move to archive\[url removed, login to view] The setting must support a directory path setting of up to 200 characters. If the import has failed, then the import file must be moved to an sub directory called "error" where the name must be made unique by adding a time stamp (yyyy_mm_dd_hhmm) to the current file name. The excel file must be imported and is used to check the attendance. The file has only one worksheet "Sheet1", and consists of the following data; Column Field Description A code code (20AN) (ID field) B naam name (50AN) C telefoon telephone (25AN) D mobiel1 mobile1 (25AN) E mobiel2 mobile2 (25AN) F groep group code (5AN) G contractcode contract code (1AN) H contractomschrijving contract description (80AN) I ma monday (Boolean 0=FALSE, 1=TRUE) J di tuesday (Boolean 0=FALSE, 1=TRUE) K do thursday (Boolean 0=FALSE, 1=TRUE) L vr friday (Boolean 0=FALSE, 1=TRUE) An example file is also available. The import must replace the existing records that was imported previously. Replace means that existing records must be deleted first, before the excel file is imported. If there is no file to import, the existing records must of course remain and are not to be deleted. The number of records to import will not exceed 250. Attendance registration From the main menu, the user can select the menu option "Registratie aanwezigheid overblijf". On the first screen, the current date is presented which can be altered by the user, using a calendar date-pick function. To accept the current pre-filled date, the user has to press the key. Then a grid is presented where the user can enter the code of the registrar. This can be done by the bar code reader, or by entering the code using the keyboard. When the or key is pressed, the following options are possible; A) the code can be matched with the code imported with the excel sheet (code of column A) and the value of the day of the week (monday, tuesday, thursday, friday) matches the value "1" (value of column I, J, K, L depending of the day of the week). Result: 1) record the registration together with the date recorded in the opening screen, accompanied with the actual date and time stamp of the moment of recording (format yyyymmdd hh:mm:ss, e.g. "20120125 14:04:59") and a new date column "exported". 2) display the values in a new window for the number of seconds set in the setting value "display_seconds". The following values must be displayed in a very large font size (size 48 or 72); - [code] name - group code, contract code, contract descripion e.g. [490] Samantha van Reijsen Groep 4, Vast [1] B) the code can be matched with the code imported with the excel sheet (code of column A) but the value of the day of the week (monday, tuesday, thursday, friday) matches the value "0" (value of column I, J, K, L depending of the day of the week) and the contractcode has the value "1". Result: 1) record the registration together with the date recorded in the opening screen, accompanied with the actual date and time stamp of the moment of recording (format yyyymmdd hh:mm:ss, e.g. "20120125 14:04:59") and a new date column "exported". 2) display the values in a new window for the number of seconds set in the setting value "display_seconds". The following values must be displayed in a very large font size (size 48 or 72); - [code] name - group code, contract code, contract descripion - fixed text "GEEN VASTE CONTRACTDAG" e.g. [143] Chris Deen Groep 5, Vast [1] GEEN VASTE CONTRACTDAG C) the code can be matched with the code imported with the excel sheet (code of column A) but the value of the day of the week (monday, tuesday, thursday, friday) matches the value "0" (value of column I, J, K, L depending of the day of the week) and the contractcode has the value "2" or "3". 1) record the registration together with the date recorded in the opening screen, accompanied with the actual date and time stamp of the moment of recording (format yyyymmdd hh:mm:ss, e.g. "20120125 14:04:59") and a new date column "exported". 2) display the values in a new window for the number of seconds set in the setting value "display_seconds". The following values must be displayed in a very large font size (size 48 or 72); - [code] name - group code, contract code, contract descripion e.g. [196] Sem Billiet Groep 6, incidenteel [3] D) the code can not be matched with the code imported with the excel sheet (code of column A) Display the text "Leerling [code] niet gevonden" Leerling [050] niet gevonden Return to the grid view and list the recorded values in the grid: code naam groep verwijderen 490 Samantha van Reijsen 4 * 196 Sem Billiet 6 * 143 Chris Deen 5 * Pressing the red cross will show a pop-up window with the text "Weet u zeker dat u deze registratie wilt verwijderen?"with a YES/NO button. Selecting "NO", will return to the grid, selecting "YES"will delete the record and then return to the grid. At the bottom of the screen a option "afsluiten registratie" is listed. Pressing this function will exit the entry screen. When exiting the entry screen, a new information screen is presented as a grid view based on those registrars which have a contract code value "1", and the value of the day of the week (monday, tuesday, thursday, friday) matches the value "1" (value of column I, J, K, L depending of the day of the week), but was not recorded in the entry screen. The grid lists the following information of the registrars; code naam groep telefoon mobiel [1] mobiel [2] 186 Annette van Heessch 6 079 3427724 06 51458553 489 Priscilla van Reijsen 2 06 28487993 06 49769171 203 Bowien Gruppen 7 079 3620882 06 54628042 06 13240968 At the bottom of the screen, there is an option "afsluiten", which will close the screen and return to the home screen of the application. Export function The export function will generate a XLS excel file in the directory that is specified in the [url removed, login to view] file at the value export_directory. The XLS Excel file must export the follwing values; Column Field Description A code code (20AN) (ID field) B naam name from registrar import file C datum_registratie date registration (yyyymmdd_hh:mm:ss) D datum_export date export (yyyymmdd_hh:mm:ss) E export_bestand file name XLS excel file (100AN) The export will only export the records where the column "exported" is not filled yet. After the export, the column "exported" must be filled with the date/time stamp of the moment the export file is created. It must also be possible to create an export for transactions that were exported already. This is an new function "export historische transacties" where the user can enter a date. All transactions before this date are exported where the column "exported" is changed to the current date/time stamp. Finally, a function "verwijderen historische transacties" will allow the user to enter a date. All transactions with a date before this entered date, will be deleted. Before the records are deleted, a final confirmation box will be presented with the text "Als je doorgaat, worden alle records die in het selectietraject vallen, verwijderd. Doorgaan?". If the user selects "no", then nothing happens. If the user selects "yes", then the records will be deleted. Deliverables 1) Settings in the [url removed, login to view]: - import_directory (200AN) - archive_directory (200AN) - error_directory (200AN) - export_directory (200AN) - display_seconds (2N) 2) Terms in the [url removed, login to view] 3) Import of registrars XLS file 4) Registration of attendance, display the found registrar and store the transaction record. 5) Display information screen after exiting grid entry screen 6) Export of current transaction XLS file 7) Export historical transactions 8) Delete historical transactions

Ingeniería Arquitectura de software Verificación de software

Nº del proyecto: #2704725

Sobre el proyecto

7 propuestas Proyecto remoto Activo Feb 16, 2012

7 freelancers están ofertando un promedio de $338 por este trabajo

mmsolutionz

See private message.

$424.15 USD en 14 días
(40 comentarios)
5.3
ivan85

See private message.

$500.65 USD en 14 días
(15 comentarios)
5.1
amolgolegaonkar

See private message.

$153 USD en 14 días
(4 comentarios)
3.9
rabhijeet

See private message.

$300 USD en 14 días
(0 comentarios)
0.0
CodingStyleDr

See private message.

$299.2 USD en 14 días
(1 comentario)
0.0
sardharapiyush

See private message.

$500.65 USD en 14 días
(0 comentarios)
0.0
bobgsofttware

See private message.

$191.25 USD en 14 días
(0 comentarios)
0.0