Find Jobs
Hire Freelancers

SITE ON AND OFF RECORDING with TESTING Data and storage via SQL Software package

$250-750 AUD

Lukket
Slået op næsten 7 år siden

$250-750 AUD

Betales ved levering
Part 1 - Database SQL 2012 A- Store 1 - "Site ON" Receives and stores a data stream from Ethernet port 10001, this stream is in the format %DATA (5 characters), PERSON ID (3 to 6 characters), SITE ID (8 characters), Date dd/mm/yy, Time hr:min:sec example - %0.002,401123,0000 0358, 26/05/17,10 :10:51 or %STOPD,401123,0000 0358, 26/05/17,10 :10:51 This data will be stored for later use. Also to pull datafile sync from another database that has list of PERSON ID numbers and has the persons name and Department listed. Need to import this data regularly to allow the card PERSON ID swipes to be stored as a name. This sync should occur every 30 minutes Recorded data will be DATE, TIME, PERSON ID, NAME, DEPARTMENT, DATA B- Store 2 - "SITE OFF" Receives data from a USB keyboard emulator card reader. This will just stream the PERSON ID and a carriage return. This needs to be stored in a second store with date and time received. Also to pull datafile sync from another database that has list of PERSON ID numbers and has the persons name and Department listed. Need to import this data regularly to allow the card PERSON ID swipes to be stored as a name. This sync should occur every 30 minutes DATE, TIME, PERSON ID, NAME, DEPARTMENT C- Store 3 - Comparison of store 1 to store 2 DATE, TIME, PERSON ID, NAME, DEPARTMENT, DATA, DRUG TEST DATE, ONSITE (YES/NO), ONSITE DATE AND TIME, OFFSITE DATE AND TIME A third store generated from the first 2 that will show a list of PERSON ID numbers and DATA VALUE from stream part A. So this will show a list of active onsite ID numbers and test results. Process if read in part A occurs ID and DATA is shown in this active store. A value of YES needs to be set in a field to shown the person is onsite. If a read in part B occurs the PERSON ID is compared to the active list and the last active PERSON ID that matches is found and the date and time of this second USB read is recorded and the Active field value is set to NO This will therefore create an active list that shows a person is onsite or the time they went offsite a field will change fro, YES for onsite to NO for offsite. PART 2 - This option provides a visual display on the WHOLE PC SCREEN, This will have a login area by username and password. Login will allow configuration of Less than or equal to value for %DATA - Value will show on screen with GREEN background for 5 seconds Greater than or equal to value for %DATA - Value will show onscreen for 10 seconds with RED background and display text "REPORT TO SUPERVISOR OR PARAMEDIC FOR FURTHER TESTING, DO NOT START WORK" and a warning tone will play on the speakers of the PC. Another option to either turn on or turn of random selection and have a percentage value to base around the number of samples you wish to take. Example RANDOM TEST On/Off TEST BASIS % User input For this part when a data stream is received on the Ethernet port that matches the Part A format it is put through a random selection process based on the TEST BASIS % to select the read for further testing. If the read is selected by the random selection process the screen will have a YELLOW Text box overlay appear above the result. This Text box will say " YOU HAVE BEEN RANDOMLY SELECTED FOR A DRUG TEST, PLEASE REPORT TO THE PARAMEDIC OR CALL SUPERVISOR" This will be recorded in the database Store 1 against the PERSON ID value as to the recorded drug test. The random selection should work on prioritising PERSON ID with a date since last tested greater than 2 months.
Projekt-ID: 14220556

Om projektet

13 forslag
Projekt på afstand
Aktiv 7 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
13 freelancere byder i gennemsnit $544 AUD på dette job
Brug Avatar.
`we have expertise in SQL,MySQL,php, DBA, Data processing. Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience software architecture,SQL,MySQL,php, DBA, Data processing Proposed Milestones $300 AUD - whole
$300 AUD på 5 dage
4,9 (19 anmeldelser)
4,8
4,8
Brug Avatar.
I am expert on SQL, C#, MySql, I can complete your project 100% perfectly. Relevant Skills and Experience I have good knowledge on C#, SQL, TCP/IP, Socket, so I think I can complete your project perfectly.. I just need your help, Then I can complete it 100% perfectly.. Proposed Milestones $390 AUD - You will pay me after complete project.. If you have questions please ask me..
$390 AUD på 12 dage
5,0 (9 anmeldelser)
4,3
4,3
Brug Avatar.
I need to understand if you want only database or you want software (C++, #) to read, write and show information (using hw) Relevant Skills and Experience database, eHealth software, integration eHealth data, c#, c++ Proposed Milestones $100 AUD - Database definition $500 AUD - Beta version $511 AUD - Deploy Additional Services Offered $1 AUD - Web developments please respond my question (point 1)
$1.111 AUD på 50 dage
5,0 (15 anmeldelser)
4,4
4,4
Brug Avatar.
record data stream from ethernet and process Relevant Skills and Experience software development Proposed Milestones $863 AUD - first
$863 AUD på 10 dage
4,9 (15 anmeldelser)
3,7
3,7

Om klienten

Flag for AUSTRALIA
Cranbrook, Australia
5,0
4
Betalingsmetode verificeret
Medlem siden apr. 25, 2016

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.