From owner-freebsd-questions@FreeBSD.ORG Fri Jan 1 18:19:05 2010 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 98A65106566C for ; Fri, 1 Jan 2010 18:19:05 +0000 (UTC) (envelope-from freebsd@edvax.de) Received: from mx02.qsc.de (mx02.qsc.de [213.148.130.14]) by mx1.freebsd.org (Postfix) with ESMTP id 5869F8FC12 for ; Fri, 1 Jan 2010 18:19:05 +0000 (UTC) Received: from r55.edvax.de (port-92-195-206-49.dynamic.qsc.de [92.195.206.49]) by mx02.qsc.de (Postfix) with ESMTP id 9F58A1E1CF; Fri, 1 Jan 2010 19:19:03 +0100 (CET) Received: from r55.edvax.de (localhost [127.0.0.1]) by r55.edvax.de (8.14.2/8.14.2) with SMTP id o01IJ2ig002269; Fri, 1 Jan 2010 19:19:02 +0100 (CET) (envelope-from freebsd@edvax.de) Date: Fri, 1 Jan 2010 19:19:02 +0100 From: Polytropon To: Doug Poland Message-Id: <20100101191902.395d2287.freebsd@edvax.de> In-Reply-To: <4B3E3AB9.40306@polands.org> References: <4B3E3121.6060106@polands.org> <20100101184219.6cd84f19.freebsd@edvax.de> <4B3E3AB9.40306@polands.org> Organization: EDVAX X-Mailer: Sylpheed 2.4.7 (GTK+ 2.12.1; i386-portbld-freebsd7.0) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: questions@freebsd.org Subject: Re: Advanced printing/layout tools X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Polytropon List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 01 Jan 2010 18:19:05 -0000 On Fri, 01 Jan 2010 12:11:05 -0600, Doug Poland wrote: > On 2010-01-01 11:42, Polytropon wrote: > > On Fri, 01 Jan 2010 11:30:09 -0600, Doug Poland wrote: > >> Hello, > >> > >> I've been tasked to print a phonebook style directory for an > >> organization. The data will be coming out of a MySQL database and can > >> be easily saved as comma-delimited, or whatever text format I need. > >> > >> My specific question is, what open source tools would one use to tackle > >> a project like this? I'm very comfortable in a CLI and do not > >> require/desire a GUI. > > > > I'd suggest to use awk + LaTeX. I've been very happy with this > > combination for a various number of tasks - just as you mentioned: > > Data coming from some kind of database (MySQL, CSV or whatever) > > and should then be layouted. > > > > > > Thanks for the info. I had a feeling I'd be introduced to LaTeX sooner > or later. Should be plenty of web resources for such a venerable tool. In fact, there are. I had been learning LaTeX in the age of the absence of the all-knowing Internet. :-) But honestly, it's not that hard, as it seems that you'll be creating lists primarily. A simple preamble should be sufficient, with no extraordinary "bells & whistles". A bit understanding of awk is useful here, too, because it allows you to manipulate both the data and the tex output with the same tools. You end up with a fine readable (and maintainable) program. I've been using this combination for automatically creating reports, datasheets, applications, dataset lists, medication lists and forms, calendars, and many other kinds of documents. LaTeX is your guarantee that it looks appealing to the reader. I'm not aware of a tool that can do the same, with the same minimal interaction time. Best of all: Everything is plain text. -- Polytropon Magdeburg, Germany Happy FreeBSD user since 4.0 Andra moi ennepe, Mousa, ...