Re: [wdvltalk] making pretty reports
Jon, Thanks for #4 below, but I have a stupid question: I have found all the packages I need for Excel, but I can't find PEAR.php anywhere. It is required in several places: require_once('PEAR.php'); Please excuse my simpleness, but any idea where to get this? steve On Mar 2, 2005, at 1:45 PM, Jon Haworth wrote: 4. Writing a PHP script to create an Excel spreadsheet directly: http://pear.php.net/package/Spreadsheet_Excel_Writer The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] making pretty reports
nevermind :) On Mar 3, 2005, at 9:25 AM, steve miller wrote: Jon, Thanks for #4 below, but I have a stupid question: I have found all the packages I need for Excel, but I can't find PEAR.php anywhere. It is required in several places: require_once('PEAR.php'); Please excuse my simpleness, but any idea where to get this? steve On Mar 2, 2005, at 1:45 PM, Jon Haworth wrote: 4. Writing a PHP script to create an Excel spreadsheet directly: http://pear.php.net/package/Spreadsheet_Excel_Writer The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: unknown lmsubst tag argument: '' To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] making pretty reports
1. The easy peasy way is to export the date as a csv (comma separated variable) file. Write some php to read data from mysql and create a file with a .csv file extension in this kind of format: Name,City,Age,Children Sara Brooks,Chicago,25,0 Pete Yates,Reading,27,2 ftp the file or have the script email to you or download it from a link, just get it onto your desktop. Now open Excel and at the File Open dialog, set file type to All files or Text files (.txt, .prn, .csv) When you open the file, Excel will fairly simply read it into a spreadsheet where you can analyse it, sort it or whatever you want . Just make sure strings in the data are enclosed in single or double quotes (and watch out quotes inside the string!) 2. I never got it to work cos I didn't try hard enough, but there's something called myAccess that runs on your desktop and manages your mySQL database on the Web site as a local Access database, and Access of course has excellent reporting facilities, see http://www.hiden.org/myaccess/ - Original Message - From: steve miller [EMAIL PROTECTED] To: wdvltalk@lists.wdvl.com Sent: Wednesday, March 02, 2005 4:30 PM Subject: [wdvltalk] making pretty reports Hi all. Looking for suggestions. We have lots of data in mysql on a BSD box. We are looking for a way to output the data, and insert it into some application where we have set up report templates to be able to view and print the reports. Right now, we manually enter all the data into Excel spreadsheets and use Excel to create the formatted reports. What we want to do is export the mysql data from the BSD box to the desktop, and somehow open the template and import the data into the correct fields. Is this possible? Are there other ways to do something like this? Any ideas to get me headed the right way are appreciated. steve . The WDVL Discussion List from WDVL.COM . To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
RE: [wdvltalk] making pretty reports
Hi Steve, What we want to do is export the mysql data from the BSD box to the desktop, and somehow open the template and import the data into the correct fields. There are lots of ways to do this, depending on exactly what you have and what you need. I'd suggest: 1. The native mysql export tools (can be scheduled via cron if needed): http://dev.mysql.com/doc/mysql/en/mysqldump.html 2. phpMyAdmin's export tools: http://sourceforge.net/projects/phpmyadmin/ 3. Installing MyODBC on the server and using the report wizards in MS Access: http://dev.mysql.com/doc/mysql/en/msaccess.html 4. Writing a PHP script to create an Excel spreadsheet directly: http://pear.php.net/package/Spreadsheet_Excel_Writer (2) and (4) would need you to be running Apache and PHP on the BSD box (is it a web server?) - I'm sure there are similar tools available in Perl, Python, or whatever languages you have available, though. Google is your friend :-) HTH Jon -- This message has been scanned for viruses and dangerous content by Swift Internet, and is believed to be clean. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] making pretty reports
Did you read on as fas as option 2 (myAccess)? (see below) - Original Message - From: steve miller Thanks BJ, but the issue is that csv type files like to just dump data serially as it receives it, creating new rows when it sees a line ending. This means that the users have to move the data around like you mentioned, and we were hoping to avoid that. ... 2. I never got it to work cos I didn't try hard enough, but there's something called myAccess that runs on your desktop and manages your mySQL database on the Web site as a local Access database, and Access of course has excellent reporting facilities, see http://www.hiden.org/myaccess/ The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] making pretty reports
Once upon a time I got paid to automate the creation of Word docs from data dumped into csv files. I actually did it twice for two different employers. The first had data that needed to be formatted into tables suitable for publication. The second job needed DOCs files created from plain text reports. For that one I created a Word app that I pointed at a directory of text files. The files had been roughly formatted. The Word app read them, one at time, into Word and did some formating for page breaks, created tables for data, and added stuff like repeating table headings on the next page when the table ran to more than one page. I'd start the program running, take a long coffee break and come back to 600 formatted Word Docs. It was actually kind of fun to watch the computer madly loading files, zipping through them, adding formatting and then saving them back to disk. Anyway the point is that you could automate Excel or Word and have it do all the file shuffling needed to create the reports. How are you Basic programming skills? Also, did you know that MySQL can dump data in XML format? That might be another avenue to explore. Sheila http://www.shefen.com/ The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] making pretty reports
BJ, Sorry I didn't respond. I have to create this so non-computer savvy people can use it. This is for insurance agents to compare plan info and create a simple proposal for a client. They just want to click a few buttons and see the data appear magically on their screen ready to print. I am not an Access guy, but I will pass this on to someone who is and maybe he can tell if it could do what we want. Thanks, steve On Mar 2, 2005, at 2:55 PM, Bj wrote: Did you read on as fas as option 2 (myAccess)? (see below) - Original Message - From: steve miller Thanks BJ, but the issue is that csv type files like to just dump data serially as it receives it, creating new rows when it sees a line ending. This means that the users have to move the data around like you mentioned, and we were hoping to avoid that. ... 2. I never got it to work cos I didn't try hard enough, but there's something called myAccess that runs on your desktop and manages your mySQL database on the Web site as a local Access database, and Access of course has excellent reporting facilities, see http://www.hiden.org/myaccess/ The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] making pretty reports
This is for insurance agents to compare plan info and create a simple proposal for a client. They just want to click a few buttons and see the data appear magically on their screen ready to print. Got any VB programmers? VB and Crystal Reports can do this kind of stuff (can access live mySQL databases off the Web) The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
Re: [wdvltalk] making pretty reports
Sheila, Sounds like you've done what I need to do. The data is for insurance plan comparisons, with the plan info organized in columns. I am not up to programming Excel to do this for me, and I doubt we have the budget to have this written. I may be able to create csv's with all the data in the right order, but I don't know how I will handle page breaks and new worksheets within a workbook. Spreadsheet_Excel_Writer that Jon mentioned might do what I need if I can figure out all the formatting. Thanks! Anyway the point is that you could automate Excel or Word and have it do all the file shuffling needed to create the reports. How are you Basic programming skills? Also, did you know that MySQL can dump data in XML format? That might be another avenue to explore. Sheila http://www.shefen.com/ The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.