List Info

Thread: mailing labels




mailing labels
user name
2006-12-21 08:27:45
What's the easiest way to print mailing (address) labels
from Kexi? Is 
there a work around?

Thanks,
Wayne Maeda
_______________________________________________
Kexi mailing list
Kexikde.org
https://ma
il.kde.org/mailman/listinfo/kexi
mailing labels
user name
2006-12-21 10:43:31
wayne said the following, On 2006-12-21 09:27:

 > What's the easiest way to print mailing (address)
labels from Kexi? Is
 > there a work around?

Hello,
There is one experimental method developed in march, not
directly supported by 
GUI, only by command line, so I do not know you're
interested. The screencast 
(in polish).

There are 3 steps (visible on the screencast):

  1. Creating the database;
    http://www.kexi.pl/media/raporty/tworzenie_szablonu.html


  2. Creating the template (using oo.org Writer for now
only, as I depend on 
document variables, sorry);
    http://www.kexi.pl/
media/raporty/

(the template is just a page that is multiplied for each
record; variables in 
it are replaced with values from the database fields)

  3. Generating the report.
    http://www.kexi.pl/media/raporty/generowanie_raportu.ht
ml


The result (pdf, odt): h
ttp://www.kexi.pl/media/raporty/korespondencja.pdf
h
ttp://www.kexi.pl/media/raporty/korespondencja.odt

The specifics of this approach is that there is one record
per page used - as 
you can see in the example, each page is a letter to a
customer. There can be 
more pages per record but not more records for now (unless
you really need 
this so I will add an option).

Moreover, the tool is not yet released. Let me know if
you're interested.
The good thing about the tool is that once you have a
template, you can run a 
script to recreate printouts using different data sets
(tables and queries are 
supported).

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice
.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi-project.o
rg, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
_______________________________________________
Kexi mailing list
Kexikde.org
https://ma
il.kde.org/mailman/listinfo/kexi
mailing labels
user name
2006-12-21 10:50:32
ah, the proper order (1<->2) is:

 >   1. Creating the database;

     http://www.kexi.pl/
media/raporty/

 >
 >   2. Creating the template (using oo.org Writer for
now only, as I depend on
 > document variables, sorry);

      http://www.kexi.pl/media/raporty/tworzenie_szablonu.html


-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice
.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi-project.o
rg, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
_______________________________________________
Kexi mailing list
Kexikde.org
https://ma
il.kde.org/mailman/listinfo/kexi
[1-3]

about | contact  Other archives ( Real Estate discussion Medical topics )