MySQL to Excel - repost

Mbyllur Postuar Jan 14, 2014 Paguhet në dorëzim
Mbyllur Paguhet në dorëzim

I have a MySQL database on the internet. The database contains daily work entries from our field technicians. They enter the information though a web page. I would like to find a way to create a report against the database that would be each technicians timecard but there is some data manipulation involved. Each day every technician entry is a separate line item in the database. I would like the report to be able to select one technician, for a specific time range, and add the hours together for each job as a sum total. For example, in a two week time period a single technician may have worked on three jobs, one with overtime. This may be as few as ten entries in the database but could be more depending on if he worked on two jobs in one day. I would like a report in excel that gives me three lines only (the three regular hour jobs with regular time total and the overtime job (same job number, just OT hours) with time total).

I can make a replicant of the current database available for development and an example of what the end report in Excel should look like is included below. All the information in the spreadsheet (minus the sum totals) is available in the database. I am open to suggestion on how to implement this (could be another web page). Some simple security would be needed as well. I can modify the database as need to suite functionality.

Identitet Korporatash Dizajn logosh

ID Projekti: #5321155

Rreth projektit

7 propozimet Projekti në distancë Aktiv Feb 20, 2014

7 profesionistë freelancer dërguan një ofertë mesatare prej $373 për këtë punë

mgliviu

Hi, I have worked in the past 8 years in management decision support systems and the development of business management tools. I have also offered support services for analysis and planning new IT projects. I think I'm Më shumë

$300 USD për 10 ditë
(7 Përshtypje)
3.9
shamdeshmukh

Hello, I would like to use my expertise and knowledge to accomplish your project with highest order of dedication. I can understand the requirement easily and have good knowledge to keep documentation of each wor Më shumë

$388 USD për 3 ditë
(0 Përshtypje)
0.0
silentdream2121

Hello Sir, Ready to Start, First Can You show me your Work Details then i can check and let You know How much time take to complete and also can let you know the price of this work done, Expect Your Positive Reply R Më shumë

$290 USD për 10 ditë
(0 Përshtypje)
0.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive Më shumë

$444 USD për 10 ditë
(0 Përshtypje)
0.0
vorticesoft

La propuesta todavía no ha sido proveída

$250 USD për 10 ditë
(0 Përshtypje)
0.0
elboukharimu

Hi, I'm very interested helping you creating the reports from your Mysql database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesit Më shumë

$609 USD për 10 ditë
(0 Përshtypje)
0.0
excelmacrosvba

Hi, Currently I'm employed by one of the major retailers in the UK working as site merchandising analyst. I'm developing VBA projects to support automated reporting. With my previous job I've developed a mysql to ex Më shumë

$333 USD për 3 ditë
(0 Përshtypje)
0.0