Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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.

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

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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.