[Libreoffice-bugs] [Bug 140303] New: Adapt database query and report to generate csv files for e.g. addressbooks in vcard format

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140303

            Bug ID: 140303
           Summary: Adapt database query and report to generate csv files
                    for e.g. addressbooks in vcard format
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: saxofon at gmx.de

I'd like to have a better base query and report to create csv or spreadsheets
directly.
Example to get an addressbook from a relational database (consisting of a
company and a employee table) into thunderbird:
-Make a query that links both tables
-Copy the whole table manually in a calc spreadsheet
-Export it in csv format, adjust cell delimiters, utf8....
-Take an external csv to vcard converter program and convert it.
-Import the whole thing into the email client addressbook
-Repeat this with every address change

Way to complicated. What is missing:
-A calc spreadsheet cannot export to vcard (=csv in one column). The cell
delimiter should therefor be CR/LF, that cannot be configured in the exporter.

-A base query cannot be saved directly to csv or spreadsheet, although the
displayed output seems to be already in calc format.

-A base report can be done only in writer format, not in csv.

Best solution would be a report that directly produces csv (vcard), without any
manual conversions.

VCard Format:
BEGIN:VCARD
VERSION:2.1
N:Mustermann;Erika;;Dr.;
FN:Dr. Erika Mustermann
ORG:Wikimedia
ROLE:Kommunikation
TITLE:Redaktion & Gestaltung
PHOTO;JPEG:http://commons.wikimedia.org/wiki/File:Erika_Mustermann_2010.jpg
TEL;WORK;VOICE:(0221) 9999123
TEL;HOME;VOICE:(0221) 1234567
ADR;HOME:;;Heidestrasse 17;Koeln;;51147;Deutschland
EMAIL;PREF;INTERNET:erika at mustermann.de
REV:20140301T221110Z
END:VCARD

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210209/63c2067b/attachment.htm>