470,848 Members | 935 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,848 developers. It's quick & easy.

Creating .xls and .doc files with page breaks using PHP / MySQL


Our company currently processes a few hundred form submissions through
our site. Up till now, the contents of the form has been sent to our
customer support staff in real-time. Each submission goes to a general
e-mail box where it's printed through our mail client. A copy of the
form is also stored in a MySQL db, although it's not used that often.

I have been asked to figure out a way to stop delivering the form
submissions in real-time and migrate to the following:

Each morning, provide an Excel spreadsheet and word document (or PDF)
with a certain number of form submissions to each customer support
rep. For example, say 200 form submissions were processed the day
before. This morning, I should split those 200 among the 5 support
reps and provide each of them a certain amount (which can change
daily). Assuming each person gets 40 form submissions, each person
would need to be given an excel file and .doc document that contains
their 40 form submissions.

One of the most important things is that the .doc file needs to have
each form submission separated by a page break, so that when they
print the document each form submission is printed on a separate page.

Finally, not all of the fields from the form submission should be
given to the support rep. Maybe date and time is left off.

Any suggestions on where to begin looking? I'm a intermediate level
hack that programs in a few diff't languages, but I am not sure where
to start with this one using PHP & MySQL. Any guidance would be
GREATLY appreciated.

Thanks in advance,
Jul 17 '05 #1
0 1964

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Carlos Eduardo Peralta | last post: by
9 posts views Thread by monomaniac21 | last post: by
7 posts views Thread by freako9699 | last post: by
3 posts views Thread by =?Utf-8?B?UGhpbCBKb2huc29u?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.