Re: [ilugd] Printing mysql data...
Raj Mathur [EMAIL PROTECTED] writes: Once you have managed to extract the data and make pages, have a look at a2ps: http://www.gnu.org/software/a2ps/ Raj's tip: a2ps looks good for if you want to really tune the page My tip: psnup (part of psutils package) is a little simpler but with less fine control. Andrew Lynn's tip: letting openoffice do the hard work sounds easiest of all. Bipin: The extracting bit : thought about how you're going to do that yet? PJ ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Next Event: http://freed.in - February 22-24, 2008 Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] Printing mysql data...
hello , ty pj for the link. 1) my organisational telephonic data (approx 6000 records) is stored in mysql DB 2) my goal is to print the directory in a booklet form 3) the printed directory will contain index pages, deptt wise phone nos along with designations, alphabetical list along with residential address,important phone nos and so forth. 4) i want to write a script which will extract the records in the above mentioned forma. 5) the printing should not one sided. i have to print multiple pages in one single sheet of paper along with proper formatting (precisely 4 nos on A-4 size) -- -- || || || || | 3 24 | | 23 4 | || || || || | 5 26 | | 25 5 | || || --- --- (front side) (reverse side) A4 page A4 page nos indicate page nos to be printed such type of printing is required so that the binder will directly cut along xxx and bind it. ty --- PJ [EMAIL PROTECTED] wrote: Raj Mathur [EMAIL PROTECTED] writes: On Friday 02 May 2008, bipin sartape wrote: hello friends my organisational telephone directory data is stored in mysql db.(approx 6000 records) i want to: 1)print the records(deptt wise, name wise ) In SQL: select * from address order by deptt, name; 2)the sequence of page printing should not be sequential(for binding purpose) Hmm, you want the pages printed out in random order? Regards, Definitely an LOL moment ;-) I think he meant one-sided printing - something like that anyway. Bipin, your spec is unclear. Also, you need to explain the details of how you're thinking of doing it before asking for help - that way we can at least figure out where in your thinking you may be going wrong. Your post is really too vague overall at present to get you a decent answer. Something to help you along (every budding geek should read this): http://www.catb.org/~esr/faqs/smart-questions.html PJ ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Next Event: http://freed.in - February 22-24, 2008 Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Next Event: http://freed.in - February 22-24, 2008 Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] Printing mysql data...
On Sunday 04 May 2008, bipin sartape wrote: [snip] 5) the printing should not one sided. i have to print multiple pages in one single sheet of paper along with proper formatting (precisely 4 nos on A-4 size) -- -- | 3 24 | | 23 4 | || || | | 5 26 | | 25 5 | --- --- (front side) (reverse side) A4 page A4 page nos indicate page nos to be printed Once you have managed to extract the data and make pages, have a look at a2ps: http://www.gnu.org/software/a2ps/ Regards, -- Raju -- Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F PsyTrance Chill: http://schizoid.in/ || It is the mind that moves ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Next Event: http://freed.in - February 22-24, 2008 Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
[ilugd] Printing mysql data...
hello friends my organisational telephone directory data is stored in mysql db.(approx 6000 records) i want to: 1)print the records(deptt wise, name wise ) 2)the sequence of page printing should not be sequential(for binding purpose) any script/ oss /web links help will be appreciated thanks --bipin Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Next Event: http://freed.in - February 22-24, 2008 Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] Printing mysql data...
On Friday 02 May 2008, bipin sartape wrote: hello friends my organisational telephone directory data is stored in mysql db.(approx 6000 records) i want to: 1)print the records(deptt wise, name wise ) In SQL: select * from address order by deptt, name; 2)the sequence of page printing should not be sequential(for binding purpose) Hmm, you want the pages printed out in random order? Regards, -- Raju -- Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F PsyTrance Chill: http://schizoid.in/ || It is the mind that moves ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Next Event: http://freed.in - February 22-24, 2008 Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] Printing mysql data...
Raj Mathur [EMAIL PROTECTED] writes: On Friday 02 May 2008, bipin sartape wrote: hello friends my organisational telephone directory data is stored in mysql db.(approx 6000 records) i want to: 1)print the records(deptt wise, name wise ) In SQL: select * from address order by deptt, name; 2)the sequence of page printing should not be sequential(for binding purpose) Hmm, you want the pages printed out in random order? Regards, Definitely an LOL moment ;-) I think he meant one-sided printing - something like that anyway. Bipin, your spec is unclear. Also, you need to explain the details of how you're thinking of doing it before asking for help - that way we can at least figure out where in your thinking you may be going wrong. Your post is really too vague overall at present to get you a decent answer. Something to help you along (every budding geek should read this): http://www.catb.org/~esr/faqs/smart-questions.html PJ ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Next Event: http://freed.in - February 22-24, 2008 Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
Re: [ilugd] Printing mysql data...
From: bipin sartape [EMAIL PROTECTED] 1)print the records(deptt wise, name wise ) 2)the sequence of page printing should not be sequential(for binding purpose) any script/ oss /web links help will be appreciated Hi, If you like web-based admin tools, use phpmyadmin. In a matter of 3 clicks, you should be able to print etc., though I am nonplussed by the phrase sequence should not be sequential. With Warm Regards, Shivkumar linux user no: 450769 blog: outbackwifi.blogspot.com profile: www.linkedin.com/in/shivjags Download prohibited? No problem. CHAT from any browser, without download. Go to http://in.messenger.yahoo.com/webmessengerpromo.php/ ___ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Next Event: http://freed.in - February 22-24, 2008 Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/