[Libreoffice-bugs] [Bug 140303] 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

saxofon at gmx.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |WORKSFORME
             Status|NEW                         |RESOLVED

--- Comment #6 from saxofon at gmx.de ---
Thank you Alex, you are right, it seems to work even with a SQL query directly
from the database, without detour over calc. I found this:

Create Text Table "Report_txt" AS  (Select * FROM "Report") WITH NO DATA;

/* Link it to a text file "Report_txt.TXT" with \r\n newline delimiters and
without field labels: */
SET TABLE "Report_txt" SOURCE
"Report_txt.TXT;encoding=UTF-8;fs=\r\n;ignore_first=true";

INSERT INTO "Report_txt" (Select * From "Report" );

SET TABLE  "Report_txt" SOURCE OFF; /* disconnect from underlying data source
*/

DROP TABLE "Report_txt" IF EXISTS;  /* delete */


I try this and mark this bug as resolved. Regards

-- 
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/20210211/6305a60a/attachment-0001.htm>