Closed

Import MySQL Data into Microsoft Word Template

This project involves creating a Microsoft Word template and adding the functionality to import data from a MySQL database to the template. The template will consist of text and a few images and some php coding and knowledge of MySQL databases will be necessary. Most of the text within the template will be fixed but some of the text will be need to be imported from a MySQL database that resides on our web server.

The way this would work is as follows-

Within our web app, the user will select the client for which the report is needed and then click the “Print Report” button. The report should then be generated in Word and populated with the appropriate data from the database.

The template will consist of 4 pages but 2 of the pages may be repeated several times within the report as indicated below.

1) The first page will be a cover page with 3 fixed images and one line of fixed text. There will be only 1 cover page per report.

2) The second page will be a form letter to the client and will consist of fixed text, text from the database and 3 fixed images. There will be approximately 20 fields that will need to be imported from the database. The length of the letter may cause this page to span 2 pages instead of 1. There will be only 1 letter per report.

3) The third page type will be a 2-column table with data from the database. The number of lines in the table and the information that will be contained in this table will be dependant on the number of items that meet certain criteria so some php code will be required to populate the table with the correct information. Since the number of rows in the table will vary, this page may actually span more than 1 page. Also, depending on the client, there may be more than 1 table per report. Again, php code would need to check certain conditions to determine how many tables will need to be printed.

4) The fourth page is a summary page that will combine standard text with data from the database. This page will only be one page long (it won’t spill over to a second page) but a separate summary page will need to be printed for each table (page 3) that was printed.

To better explain this, a client may have 3 items. The first item contains 20 parts, the second item contains 15 parts and the third item contains 40 parts. When the report is generated for this client, the following items will need to be included in the report: (a) 1 cover page, (b) 1 form letter, (c) 3 tables – the first table will have 20 rows, the second will have 15 rows and the third will have 40 rows, (d) 3 summary pages (1 for each table).

The user should be able to edit and save the Word file for the particular client.

If you have any questions or require additional information, please ask.

Skills: Javascript, MySQL, PHP, Visual Basic, Word

See more: php mysql word template, mysql word template, import mysql data word, php word template, mysql data word php, mysql data word, mysql import microsoft word, word template mysql database, php mysql data word, microsoft word php mysql, word template mysql fields, php import data template, import word file data, word template mysql data, import template mysql, mysql php word template, word import mysql, template cover letter, standard cover letter, project report cover page, mysql questions, microsoft project template, microsoft project import, microsoft number, type cover letter

About the Employer:
( 0 reviews ) New York, United States

Project ID: #1301903

7 freelancers are bidding on average $143 for this job

nrifriends

Please check your PM.

$200 USD in 7 days
(48 Reviews)
6.9
leomedina01

I am here to help you sir. Please check my profile for further details of my skills and expertises.

$250 USD in 7 days
(49 Reviews)
5.7
rfuentescruz

Hi. Please check your inbox for my message.

$100 USD in 5 days
(4 Reviews)
2.7
VictorGevondyan

We are a company which is specialize in web design and programming with 12 years of work experience. We always work effectively, creatively and in time. We like our work and do it with pleasure.

$100 USD in 4 days
(0 Reviews)
0.0
debhatrai

Hi, I've done the following projects: [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] I've good experience about the mysql data base More

$100 USD in 4 days
(0 Reviews)
0.0
mn5

I'm not a kid - the work is done proffesionaly.

$150 USD in 5 days
(0 Reviews)
0.0
Nazmulhudamasud

hello sir please check pmb

$100 USD in 3 days
(0 Reviews)
0.0