I have a special software that tracks users activity and inactivity computer time. Start time as the first activity or logon, end time as the last or logoff and counts activity and inactivity periods.
I already have a SQL request that retrieve necessary information. But it might require some tweaking.
I need a script that retrieves data from my SQL and produces an HTML report for DAILY or MONTLY attendance time and activity periods.
1. The scripts has to be on Python
2. It should constant in the code (at the beginning) definitions:
- authentication and connection string to the SQL
- output file location. The output files also include the date of the reports. If file exist at the output path, rewrite it.
- locations and names of people to include to the report. See a report example.
- other constants if necessary
3. The script should be well documented
4. If it runs with parameter "d" - produce a report for the current day; "m" - current month
5. Parameter "m" and "2017-02" generates monthly report for February 2017, etc.; Parameter "d" and "2017-05-01" daily report for May 1-st, 2017.
6. Examples of the reports will be provided.
7. I also need a Python script with a SQL query that incerts start and end times for a specific user
create simple script to parse data from reports and insert them to SQL database, provide documentation and explanations so it can be easily modified in future
Relevant Skills and Experience
Python, MySQL expertise, Scripting experience
Proposed Milestones
$30 CAD - After script is finished and delivered
Which database are we using for this project?
If you provide the report now ,i can finish it today.
$30 CAD w 1 dzień
5,0 (18 opinii)
3,9
3,9
5 freelancerzy składają oferty o średniej wysokości $35 CAD dla tej pracy
Check our many good reviews from our satisfied customers in software and websites development. We will make you happy
Relevant Skills and Experience
developer
Stay tuned, I'm still working on this proposal.
I believe I have the knowledge and skills in order to finish this project on time.
Relevant Skills and Experience
HTML (covering all doctypes including HTML5)
CSS
JavaScript
JQuery
MySQL
Node.js
Angular
React.js
Java
BootStrap (as well as some other frameworks such as YUI)
PHP (also ASP.Net)
Laravel Framework
Proposed Milestones
$50 CAD - Final Payment