Re: [libreoffice-users] Re: how to create mailmerge with libre base only without using libre calc.

Hi :)
Should someone put those links on the documentation page?
http://wiki.documentfoundation.org/Documentation/Publications

It would be really nice if people would just update that page so that everyone can see the content 
improving.  I can tidy up formatting if required so don't worry about making a mess.  What i can't 
do is find good content.  There is so much junk out there that's its difficult to spot the jems 
that are worth linking to.
Regards from
Tom :)


--- On Thu, 2/2/12, Alex Thurgood <alex.thurgood@gmail.com> wrote:

From: Alex Thurgood <alex.thurgood@gmail.com>
Subject: [libreoffice-users] Re: how to create mailmerge with libre base only without using libre 
calc.
To: users@global.libreoffice.org
Date: Thursday, 2 February, 2012, 7:32

Le 02/02/2012 02:04, sonic a écrit :

Hi Sonic,

> Dear BRO, SIR,SIS,
> May I know is there any other alternative ways to create mail merge with
> libre base and generate report from libre base without opening other program
> like libre writer or libre calc to do it..
> which mean that , want to using 1 program only to do all the job that's
> libre base .

Short answer : for mailmerge, no. You must use Base in combination with Writer

If you want a report, you can :
(1) use the Oracle Report Builder, which is a built-in extension, accessible, for example, via a 
Base (ODB) file ;
(2) use a Calc file and design your own report using data ranges;
(3) use a Writer file, and insert your data fields from the table or query of your choice ;
(4) write an external program using python, javascript, beanshell, perl, php, etc to manipulate ODF 
compliant XML and interface that with your datasource.

> If there any tutorial or suggestion pls do let me know tQ your's help are
> much appreciated...


Information and tutorials for manipulating ODF XML :

http://stackoverflow.com/questions/3477597/how-to-generate-odf-charts-with-perl

http://search.cpan.org/~jmgdoc/OpenOffice-OODoc-2.125/OODoc/Intro.pod

http://cpanforum.com/threads/3039

http://www.opendocsociety.org/tools/odf-tools/

http://letscript.wordpress.com/2011/09/30/from-mysql-to-opendocument-format-with-perl/


Information about using Calc or the Report Builder to make reports :

http://wiki.services.openoffice.org/wiki/SUN_Report_Builder/Documentation

http://user.services.openoffice.org/en/forum/viewtopic.php?f=75&t=18511

http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=23727


Alex


-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted