• Create your Web database applications with DaDaBIK

    Dadabik is Free Software that you can use (writing little or no code by hand!) to create PHP-based Web applications that even users with little previous experience can use to manage several types of (already existing) relational databases. I’m happy to report that, after a quite long stop, development of DaDaBIK recently restarted. The result, which you can see in the screenshots in this page, is version 4.
  • How to automatically print or convert to PDF, MS Office or other formats OpenDocument files

    The script and tricks in the ODF scripting section of this website show how to create office-ready texts, presentations and spreadsheets automatically, in the OpenDocument format, which is a worldwide standards. This is all many people need to work today. Sometimes, however, it’s still necessary to either print those documents, or exchange them to somebody in other formats, like PDF or those of the older releases of Microsoft Office (newer releases of this program are already partially compatible with OpenDocument through free plugins, so if your partners have those versions they should really use those plugins, instead of bothering you with requests for drug-like, legacy file formats, but that’s another story).
  • How to transform (almost) plain ASCII text to Lulu-ready PDF files, part 2

    This page gives a general overview of a flow for transforming ASCII files in print-ready PDF books. The reasons for setting up such a flow in this way are explained in the first part of this tutorial. Basic workflow The basic usage of txt2tags is really simple. Once you’ve written something that you need to convert to PDF, text or HTML you can launch the graphic interface with the -gui option or run a command like this at the prompt:
  • How to transform (almost) plain ASCII text to Lulu-ready PDF files, part 3

    This is the core script I used to transform a set of plain ASCII files with the Txt2tags markup in one print-ready PDF file. Part 1 of this tutorial explain why I chose txt2tags as source format and Part 2 describes the complete flow.Book creation workflow Listing 1: make_book.sh 1 #! /bin/bash 2 3 CONFIG_DIR='/home/marco/.ebook_config' 4 PREPROC="%!Includeconf: $CONFIG_DIR/txt2tags_preproc" 5 6 CURDIR=`date +%Y%m%d_%H%M_book` 7 echo "Generating book in $CURDIR" 8 rm -rf $CURDIR 9 mkdir $CURDIR 10 cp $1 $CURDIR/chapter_list 11 cd $CURDIR 12 13 FILELIST=`cat chapter_list | tr "�12" " " | perl -n -e "s/.
  • How to transform (almost) plain ASCII text to Lulu-ready PDF files, part 1

    Many people write far more now that they are constantly online than in the pre-Internet age. Most of this activity is limited to Web or office-style publishing. People either write something that will only appear inside some Web browser or a traditional “document”, that is a single file, more or less nicely formatted for printing. Very often, however, they don’t do it in the most efficient way. The most common solution for the first scenario still is to write HTML or Wiki-formatted content in a text editor or, through a browser, directly in the authoring interface of CMS systems like Drupal or Wordpress.
  • Generate OpenDocument spreadsheets from DB2 (or any other) database

    DB2 pureXML is IBM software for management of XML data that eliminates much of the work typically involved in the management of XML data.The OpenDocument Format (ODF) is an open international standard for office texts, presentations and spreadsheets that is very simple to process or generate automatically. This page is a short synthesis of an article published in September 2010 by N. Subrahmanyam, Using DB2 pureXML and ODF Spreadsheets, to give an idea (see my comments at the end) of how flexible ODF scripting is.
  • Create OpenDocument invoices and other documents with Rexx

    After my talk about ODF scripting at OOoCon 2010 I got,by another OOoCon speaker, Rony G. Flatscher another script for automatic generation of OpenDocument invoices, or any other ODF text with a fixed structure. Roni’s script opens an OpenDocument text template as the one shown in the picture above and replaces all the MF_ placeholders strings with values loaded by a plain text file, creating the filled form shown here:
  • OpenOffice.org Conference 2010, preparing the next ten years

    The OpenOffice.org conference celebrating the tenth birthday of OpenOffice.org started in Budapest yesterday morning. Here are some first notes from the field. The opening session was a cool moment, both for the location (the Hungarian Parliament) and for the content. We started in the very hall of the Parliament. Incidentally, the first thing I noted there has nothing to do with OO.o but is a general problem of the FOSS and programming worlds: of about 150 people in the hall, no more than 10% were women, even if OO.

    What would you like to do with Free Software?

    Tell me and I may write about it Computers and software should make life easier and help us to save time (and money), not waste it. Many commercial programs are (or look) much more polished, complete and user friendly because they let you do the simplest things very quickly and easily, just clicking around in a graphical interface. The downside of all this simplicity is that it is can be very hard or time consuming to do anything above that first level of usage.

    How to support this website

    How to support Free Software tips and tricks at Zona-M (or any other website!) Keeping up and running a good website, regularly adding original, useful and easy to use content, is a difficult task that requires a lot of time and effort. As you can read on my online business card, over the years I have accumulated lots of experience and information about how Free Software works. With this website I intend to provide a useful service, for free, to all users of Free Software, by reformatting and publishing all those informations in a really usable way.