Base - Phone book ?

Base
its been quite a few years since I've perplexed myself with a database, but needs must

i want to print my Thunderbird address book, (the phone numbers mainly)  i can do this from within Thunderbird but i cant choose the fields or set up the display so the output is hardly user friendly
using Base i can connect to the Thunderbird MAB file choose the fields and out put a print, but again not particularly user friendly output
What i want is someone to point me towards a tutorial/resource that will show me how to do the design bit or/and give me advice or even a template.

All help gratefully revived

Hi :)
Hopefully the guides on this page might help?
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide

If you scroll up the page from that link you find the Base chapter in the "Getting Started" guide might be quite useful too.
Good luck and regards from
Tom :)



--- On Tue, 14/2/12, IGraham <[hidden email]> wrote:

From: IGraham <[hidden email]>
Subject: [libreoffice-users] Base - Phone book ?
To: [hidden email]
Date: Tuesday, 14 February, 2012, 16:22

Base
its been quite a few years since I've perplexed myself with a database, but
needs must

i want to print my Thunderbird address book, (the phone numbers mainly)  i
can do this from within Thunderbird but i cant choose the fields or set up
the display so the output is hardly user friendly
using Base i can connect to the Thunderbird MAB file choose the fields and
out put a print, but again not particularly user friendly output
What i want is someone to point me towards a tutorial/resource that will
show me how to do the design bit or/and give me advice or even a template.

All help gratefully revived

--
View this message in context: http://nabble.documentfoundation.org/Base-Phone-book-tp3744152p3744152.html
Sent from the Users mailing list archive at Nabble.com.

--
For unsubscribe instructions e-mail to: [hidden email]
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: [hidden email]
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

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.

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 the database
Use the query just like you would use a table.

IGraham 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.


--
For unsubscribe instructions e-mail to: [hidden email]
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

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 csv is completely pointless.
Once you connected a Base document to the address book you have the all the contained tables plus the groups defined in TB plus database queries in Writer and in Calc for multiple purposes without further export/import procedures.

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:49 PM, Andreas Säger <[hidden email]> wrote:

--
For unsubscribe instructions e-mail to: [hidden email]
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

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 all file based data sources (spreadsheet, csv, address books etc).

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 connect directly to the thunderbird database
thanks for the suggestion though

base, I've already connected to the database and got a output of the fields i want, what i want now is to know how to go into design view and build an output that would look and print off something like a purchased phone book

Tom, havent had a chance to have a proper look at the links yet - thanks

and if anyone does have a suitable  template

On Tue, 2012-02-14 at 15:57 -0800, IGraham wrote:
 Search for    Base Tutorial by Mariano Casanova. Perhaps this will
help.

--Dan




--
For unsubscribe instructions e-mail to: [hidden email]
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

Andreas Säger 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.

--
For unsubscribe instructions e-mail to: [hidden email]
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

On 14-02-12 19:36, Andreas Säger 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


--
For unsubscribe instructions e-mail to: [hidden email]
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

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 as report medium.
TB addresses > Base > Calc report or embedded Writer report

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

Just do not use your distributor's LO. The downloaded version from http://libreoffice.org( includes the TB address book driver in all versions of LibreOffice.org. Same with OpenOffice.org. For some reason I never understood, the Linux distributors used to cut off the TB support from OOo Base. I used to use the TB address book driver since OOo version 1.

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 <[hidden email]> wrote:

From: Andreas Säger <[hidden email]>
Subject: [libreoffice-users] Re: Base - Phone book ?
To: [hidden email]
Date: Wednesday, 15 February, 2012, 10:00


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 as report medium.
TB addresses > Base > Calc report or embedded Writer report


--
View this message in context: http://nabble.documentfoundation.org/Base-Phone-book-tp3744152p3746401.html
Sent from the Users mailing list archive at Nabble.com.

--
For unsubscribe instructions e-mail to: [hidden email]
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: [hidden email]
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

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 order to get the latest address data into your csv files.
TB address book tables > CSV directory > Base > Calc/Writer reports

Create a dedicated directory to take any csv list exported from TB .
Export all the lists you need (including any virtual lists) into that direcory.
In OOo call File>New>Database...
[X] Connect to existing db
Type: Text
Specify the csv folder and the usual csv import delimiters.
[X] Register the new database
Save the new database document.
You may want to add some simple queries to query only certain rows and columns in a certain order of rows and columns.
Close the database document and forget about it.
Now you can hit F4 in Writer and Calc and read any of the exported csv files plus the additional Base queries without any further configuration. Just drag some icon from the left pane into your document. For mailing list labels you may drag column headers from the right pane into a Writer document.

On Wednesday 15 February 2012 07:19:50 Joep L. Blom wrote:
Wow, time travel! Soon be 2013 for you then! Here in the UK its just
16-02-2012.

Sharon.
--
A taste of linux = http://www.sharons.org.uk/taste/index.html
efever = http://www.efever.blogspot.com/
efever = http://sharon04.livejournal.com/
Debian 6,0.4, Gnome 1:2.30+7, LibreOffice 3.5.0
Registered Linux user 334501

--
For unsubscribe instructions e-mail to: [hidden email]
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

On 16-02-12 04:34, sharon kimble wrote: Sorry,
Slippery fingers!
Joep


--
For unsubscribe instructions e-mail to: [hidden email]
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