MySQL to Excel

Closed

Description

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.

Skills: MySQL, PHP, Software Architecture

See more: excel mysql, work on line jobs, two week jobs, technicians needed, technicians jobs, technician jobs in, technician jobs, simple timecard, security technician jobs, ot technician jobs, ot jobs, one hour jobs, job technician, jobs technician, jobs in security, jobs available on line, job for a c technician, internet security jobs, i need a technician, how would one find a data entry job, how to find technicians, how to find jobs, how to find data entry jobs, how to find data entry job, how to find a job

Project ID: #5320657

Awarded to:

AphroECS

Hello, We have expertise in reporting and MySQL related tasks. If you can send me two formats: 1) existing report (in html) 2) desired report format (in Excel) I am sure to work around it to deliver it as you l More

$515 USD in 10 days
(77 Reviews)
7.5

61 freelancers are bidding on average $457 for this job

rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$927 USD in 4 days
(481 Reviews)
7.4
sritechnocrat

Hello Sri Technocrat will provide fully interactive application/website for your project. As per the detail, Sri Technocrat will provide three template functional schemes and sample pages to make your choice for lay More

$684 USD in 30 days
(51 Reviews)
7.3
meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub More

$773 USD in 15 days
(70 Reviews)
7.2
zeke

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s More

$515 USD in 10 days
(165 Reviews)
7.0
eperfections

10+ years experience. 600+ projects completed successfully. Very interested in this project. There is no file attached. Please send me complete details. Ready to start ASAP.

$515 USD in 5 days
(208 Reviews)
6.9
shikhamehta

Hey, I read through your requirement and as you also mentioned, there are two ways to accomplish what you are looking for. First is to import data in excel, do some manipulations and present the results. Other is to cr More

$611 USD in 10 days
(199 Reviews)
6.8
ajaxdevman

Hi, Ready to take on this project and guarantee top grade results. I have long experience with creating reports from MySql data. Regards, Nader Moussa.

$555 USD in 10 days
(39 Reviews)
6.8
AcuityInfotech

Hi,    We’ve had a good look at your project description and we’re very interested in providing a solution. Please PM us so that we can discuss further.     We are a professional development company headquartered i More

$368 USD in 5 days
(28 Reviews)
6.7
petermyvw

You can have me produce a web app which enables you to get the excel data from the MySQL database. It will of course include the business logic you described for grouping the total hours worked. As you indicated in More

$368 USD in 14 days
(174 Reviews)
6.7
babysoftS

Hi, I am experienced PHP developer and I understand your requirement to generate the reports for the different search queries on the data of technicians data store in MySQL. I can write a small script that will gen More

$250 USD in 3 days
(38 Reviews)
6.6
tzo

A proposal has not yet been provided

$265 USD in 10 days
(272 Reviews)
6.5
rajawi9999

I'm expert in web development for more than 12 years, I'm highly skilled in php , ajax, jquery, SEO, SOAP & XML...I'm ready to start I can start right away. Thanks.

$260 USD in 3 days
(143 Reviews)
6.4
hrarcon

Ready to work on your project.We can do your project as per your requirement. We have good and experienced developers,Testers,Linux Admin,DB Admin,Asterisk PBX,opensips and UI Designers Our team from Chennai,India( More

$789 USD in 25 days
(14 Reviews)
6.0
urmate

HI Contact me for an efficient, well documented and perfect solution and development of your project. I ensure quality work with always on time delivery of project and dedicated support and follow up. Thanks More

$250 USD in 3 days
(83 Reviews)
5.9
pablotorres

I am working on software development since 1992. I am expert on database migration. I can migrate any kind of relational databases with just few SQL sentences. I can solve problems about replacing or combining data More

$250 USD in 15 days
(94 Reviews)
5.7
mohanchauhan

Hi Sir, I am a lead programmer as i have 10 years of working experience in php,mysql,ajax, jquery, javascript, css, html, Graphics Design. I am a lead developer with a team of developers and designers. I have expe More

$309 USD in 5 days
(17 Reviews)
5.7
irenicus

Dear Sir or Madam, I am developer with big experience in database related work and I worked on many projects involving Excel spreadsheet data import and/or export. I can start working on this immediately and I can f More

$300 USD in 2 days
(37 Reviews)
5.7
silky1284

I have done many jobs like this before and know exactly what you need. If you send me a copy of the datebase I can even send you a mockup based on your request. I will do this before you choose me so you know exactly w More

$300 USD in 10 days
(26 Reviews)
5.5
caneadysl

Hi Requirement clear Will you send me the sample database to analyze first I am a master of php more than 11 years now ,I can deliver what you need as it is Waiting for a reply

$383 USD in 5 days
(43 Reviews)
5.4
fattahaabdul

I will make a way to create a report against the database. I did these type of work in fast so i am best person for you. i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so t More

$1030 USD in 10 days
(13 Reviews)
5.4