Re: [libreoffice-users] Re: Base - Phone book ?

2012-02-15 Thread Joep L. Blom
On 16-02-12 04:34, sharon kimble wrote: On Wednesday 15 February 2012 07:19:50 Joep L. Blom wrote: On 14-02-12 19:36, Andreas Säger wrote: That is easy. Open the Base document which connects the TB address database with this office suite. Go to the query section. Let the designer or wizard crea

Re: [libreoffice-users] Re: Base - Phone book ?

2012-02-15 Thread sharon kimble
On Wednesday 15 February 2012 07:19:50 Joep L. Blom wrote: > On 14-02-12 19:36, Andreas Säger wrote: > > That is easy. Open the Base document which connects the TB address > > database with this office suite. > > Go to the query section. > > Let the designer or wizard create a new query from the ta

[libreoffice-users] Re: Base - Phone book ?

2012-02-15 Thread Andreas Säger
Linux users who can not connect to TB can export csv files from TB and connect LibreOffice to this data source. Notice that you can export any virtual address list you have created in TB and that the exported csv is a snapshot of the current address data. You need to repeat the export procedure in

Re: [libreoffice-users] Re: Base - Phone book ?

2012-02-15 Thread Tom Davies
Hi :) It's always good to have choices.  So, i think James deserves thanks rather than criticism.  Regards from Tom :) --- On Wed, 15/2/12, Andreas Säger wrote: From: Andreas Säger Subject: [libreoffice-users] Re: Base - Phone book ? To: users@global.libreoffice.org Date: Wednesda

[libreoffice-users] Re: Base - Phone book ?

2012-02-15 Thread Andreas Säger
Joep L. Blom wrote > >> > All, > I would like to do the same however, as I wrote on 29-12-2012 in LO > 3.4.5 on Ubuntu 10.04 it is impossible to link with the TB address-book > although the choice is given (see the referenced mail). Or is this > feature finally implemented in 3.5. > Joep > Ju

[libreoffice-users] Re: Base - Phone book ?

2012-02-15 Thread Andreas Säger
James Knott wrote > > I thought the OP simply wanted to print his address book, after > selecting the columns he wanted to print. That is easy enough to do in > Calc. > The question was about printing specific columns only which is even more easy without any calculator software or using Calc

Re: [libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Joep L. Blom
On 14-02-12 19:36, Andreas Säger wrote: That is easy. Open the Base document which connects the TB address database with this office suite. Go to the query section. Let the designer or wizard create a new query from the table in question. Add only the columns you need. -- View this message in co

Re: [libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread James Knott
Andreas Säger wrote: You can export the address book in tab or comma delimited format. You can then import that file into Calc and do whatever you want with it. No, you can't do anything with database data in Calc. You can not query virtual tables nor can you generate reports nor serial letters

Re: [libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Dan Lewis
On Tue, 2012-02-14 at 15:57 -0800, IGraham wrote: > far be it for me to distract from a good developing 'discussion' ;) > > thanks for the input people > > the calc option, as much as i like a good spreadsheet i don't really think > its going to produce a booklet type phone number book without a

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread IGraham
far be it for me to distract from a good developing 'discussion' ;) thanks for the input people the calc option, as much as i like a good spreadsheet i don't really think its going to produce a booklet type phone number book without a good deal of tweaking and as has been pointed out calk wont c

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Andreas Säger
Compare this: Thunderbird > CSV export > Calc import > Base document > Report with this: Thunderbird > Base document > Report The Base document provides a direct link to the current TB data. You don't need to update any intermediate files. The availlable features and limitations are the same for

Re: [libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread jomali
Where do you get that idea? You can create a database using a calc document as your data source and create queries and forms and reports as you would with any other data source. Your only restriction is that you can't do data entry, so any changes have to be made in Calc. On Tue, Feb 14, 2012 at 5

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Andreas Säger
You can export the address book in tab or comma delimited format. You can then import that file into Calc and do whatever you want with it. No, you can't do anything with database data in Calc. You can not query virtual tables nor can you generate reports nor serial letters. The TB export to cs

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Andreas Säger
Andreas Säger wrote > > That is easy. Open the Base document which connects the TB address > database with this office suite. > Go to the query section. > Let the designer or wizard create a new query from the table in question. > Add only the columns you need. > Continued: Save the query Save t

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread Andreas Säger
That is easy. Open the Base document which connects the TB address database with this office suite. Go to the query section. Let the designer or wizard create a new query from the table in question. Add only the columns you need. -- View this message in context: http://nabble.documentfoundation.o