Bug 95293 - Mailmerge serial print fails
Summary: Mailmerge serial print fails
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: x86-64 (AMD64) macOS (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2015-10-24 10:40 UTC by juergen schmuker
Modified: 2016-05-12 04:04 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshots (635.04 KB, image/png)
2015-10-26 11:18 UTC, juergen schmuker
Details
Self-contained, obfuscated example provoking the bug (186.81 KB, application/zip)
2015-12-07 09:34 UTC, Wolfgang Glas
Details

Note You need to log in before you can comment on or make changes to this bug.
Description juergen schmuker 2015-10-24 10:40:16 UTC
does not print out serial letter:
Connecting databse ok
choosing records all/selected ok
after pressing print biutton, nothing happens
no difference when choosing direct print or print file

with version 4 I could print out 

Mac OS X El Capitan, MacBookPro,2,6 Intel Core i5
Comment 1 juergen schmuker 2015-10-24 10:43:53 UTC
changing Language Pack from German to English does not change anything
Comment 2 Alex Thurgood 2015-10-26 08:45:52 UTC
@juergen : please provide more details on :

- the database connection
- the manner in which you start the mailmerge
Comment 3 Alex Thurgood 2015-10-26 08:48:04 UTC
Ideally, you should provide us with a small sample data source or database and a corresponding Writer document from which to test the mailmerge/serial letter print functionality
Comment 4 Alex Thurgood 2015-10-26 09:09:19 UTC
I have just tried this on OSX 10.11 with LibreOffice 5022 from TDF download.

I used a Writer document that contains field references pointing to a query defined in an ODB file that connects to a mysql database.

I was able to both print out a series of letters using data from the query result, and create a series of individual files saved to disk containing that data, so mailmerge works for me under those conditions.
Comment 5 Alex Thurgood 2015-10-26 09:10:09 UTC
Please also indicate whether you are using AppStore version or TDF version of LibreOffice on Mac
Comment 6 juergen schmuker 2015-10-26 10:59:02 UTC
I use downloaded version, not app store.


I attach a screenshots: I connected my (Mac)Adressbook to libre office
I started a new Text document
I connected fields of Adressbook to this document 
I press print - confirmation comes up 
I confirm - the database view opens 
I press ok (print) - the database view closes and I see my doc ; but no print happens

It does not matter which DB connection I use ( I tried native Mysql, Spreadsheet, csv and - for new test - Mac Adressbook. 
It just does not react on my printing command. (when I do the same in Neo Office it works, that’s at the moment my turn around)
Comment 7 Alex Thurgood 2015-10-26 11:11:04 UTC
(In reply to juergen schmuker from comment #6)
> I use downloaded version, not app store.
> 
> 
> I attach a screenshots: I connected my (Mac)Adressbook to libre office

No screenshots ?
Comment 8 Alex Thurgood 2015-10-26 11:14:49 UTC
I can't connect to a Mac address book with LO5022 on OSX 10.11, every time I try to open a table LO crashes and starts the file recovery function.

Will open separate report. 

I can print out serial letter using Thunderbird addressbook though.
Comment 9 juergen schmuker 2015-10-26 11:18:35 UTC
Created attachment 119964 [details]
screenshots

sorry I forgot:

screen3 database view
Comment 10 Alex Thurgood 2015-10-26 11:26:17 UTC
Just tried creating a new MacAb.odb to connect to. Authorised access to the Mac address book, and I could see the data when I double click on Tables in the corresponding ODB file.

Next, I created a Writer document, pressed Fn+F4 to display the data source browser, chose the name of my registered database (MacAb.odb), chose the table, dragged and dropped fields into my Writer document. Then CMD-P, selected to export to single file - a corresponding ODT document was created containing the data from the fields I'd dragged into the mailmerge template.

So, this is still WFM. I've now tested this on two different OSX 10.11 machines.
Comment 11 juergen schmuker 2015-10-26 13:57:19 UTC
I did the same, simple database in libreoffice spreadsheet as first step after open LibreOffice 5.0.2.2. It worked. I tried the Mysql connection, it worked as well I can print out.
When I turn my system off, turn it on, start Libre Office again and try to malmerge Doc and Mysql it does not work.
When I turn my system off, turn it on, start Libre Office again and try to malmerge simple spreadsheet database it works. When I do the mailmerge with Mysql after this step it works as well.
I know its hard to believe. I installed older versions 4.3.0 - 4.4.3 to find a working one. And in doing so I found this strange behaviour.
Comment 12 Alex Thurgood 2015-11-03 09:37:15 UTC
(In reply to juergen schmuker from comment #11)


> When I turn my system off, turn it on, start Libre Office again and try to
> malmerge Doc and Mysql it does not work.

When you mention DOC, do you mean a Microsoft Office doc formatted document or a Writer ODT document ?
Comment 13 Wolfgang Glas 2015-12-06 21:23:22 UTC
We are also affected by this problem after upgrading from libo-4.3 to libo-5.0

OS: MacOSX 10.10
Libreoffice: 5.0.3 and 5.0.4.1 tested.
Database: ODS-Document
Consuming document: ODT file.
Comment 14 Wolfgang Glas 2015-12-07 09:34:24 UTC
Created attachment 121094 [details]
Self-contained, obfuscated example provoking the bug

This example provokes bug 95293 at my premises. In the ODB file you might need change the path of the liked ODS file, for sure.
Comment 15 Wolfgang Glas 2015-12-07 15:14:20 UTC
Additional information, I've tried the following versions:

libo-4.3.3.2 debian/Linux, the serial printing was OK
libo-4.4.6 MacOSX-10.10.5, serial printing did not work.

From previous years (yes, it's our christmas card mass-mail...) I know, that it works with libo-4.3.x under MacOSX.

I've no clue, whether the regression is on MacOSX only or whether Linux installations are also affected...
Comment 16 Alex Thurgood 2015-12-09 09:34:14 UTC
Confirmed with Wolfgang's test file suite, and LibreOffice
Version: 5.0.3.2
Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Locale : fr-FR (fr.UTF-8)
Comment 17 Alex Thurgood 2015-12-09 09:37:22 UTC
Caolan : not sure whether you're still active on the mailmerge wizard ?
Comment 18 Wolfgang Glas 2015-12-09 18:25:34 UTC
Hi Alex,

  thanks for retesting this case ;-)

  Hopefully we get a fix for this nasty issue within one of the next releases,

    Wolfgang
Comment 19 Robinson Tryon (qubit) 2016-05-12 04:04:53 UTC
TESTING with
LO 5.2.0.0.alpha1+
OS Version: Mac OS X 10.10.5
Build: 2016-05-11_01:01:27

(In reply to Wolfgang Glas from comment #14)
> Created attachment 121094 [details]
> Self-contained, obfuscated example provoking the bug
> 
> This example provokes bug 95293 at my premises. In the ODB file you might
> need change the path of the liked ODS file, for sure.

Repro Steps:

- Open FODT file

(In reply to juergen schmuker from comment #6)
> I press print - confirmation comes up 

- (Click Print Button)
- Dialog pops-up '...Do you want to print a form letter?'
- Click (Yes)

> I confirm - the database view opens 

- Dialog showing data (from Adressen_TDF_95293 file; Tabelle1)

> I press ok (print) - the database view closes and I see my doc ; but no
> print happens

- Keep default choice of 'Print'; click (OK)
- Select 'PDF' drop-down to save PDF file as file 'Output_95293'

RESULT: PDF is generated as expected, so
NO REPRO from me.

Juergen: is there anything else I should do to reproduce this bug?

I'm tentatively marking this as RESOLVED WORKSFORME. If you find that the bug is still present with a modern 5.2 build, please leave a comment and change the status back to NEW. Thanks!