You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/04/04 14:12:23 UTC

[Issue 124597] New: MAILMERGE: Wrong record Number in Mailing

https://issues.apache.org/ooo/show_bug.cgi?id=124597

          Issue ID: 124597
        Issue Type: DEFECT
           Summary: MAILMERGE: Wrong record Number in Mailing
           Product: Writer
           Version: 4.0.1
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: major
          Priority: P3
         Component: printing
          Assignee: issues@openoffice.apache.org
          Reporter: cldc.site@wanadoo.fr

Created attachment 83083
  --> https://issues.apache.org/ooo/attachment.cgi?id=83083&action=edit
Contains 3 files mentionned in description

Same as LibreOffice Bug: 
https://bugs.freedesktop.org/show_bug.cgi?id=76995

Problem description: 
I don't have an English version installed, so menus name could be not exactly
the one expected

While printing type letters ( File --> print --> yes to question, "do you wish
to print type letters"
I wish to print the record number in the data base

Steps to reproduce:
1. Create a Mailing document for a xls or ods file as data base
2. Insert in the document the record number as explained in:
https://help.libreoffice.org/Writer/Database
Insert --> Fields --> Other --> Database --> type = record number

3. Print a type letter
File --> Print --> yes to the question :"do you wish to print a type letter"


Current behavior:
1) If I create a unic file containing all documents, all the documents have the
same number ( empty or a value)

2) If I create an ODT file for each document, each one has a correct number (
from 1 to the number of file in DB or result of filter on DB)

3) If I create an PDF file for each document, all the documents have the same
number ( empty or a value)

4) If I do the same tests with mailing assistant(Tools --> Mailing assistant)
Even the ODT files for each document ( as in step 2) are wrong

Expected behavior:
Each document, using any print mode, has a record number in the data base or in
the result of a filter in the data base.
I expect to print that one ( which is not a page number)

I have the same issue with LibreOffice Version: 4.1.5.3, 4.2.3.2 as well.
I have recently installed LibreOffice and last OpenOffice version. I was able
to use this option since 2006, with a previous OOO version, I don't remember
wich one, may be before it became Apache.
I use this option to print fiscal documents once a year.

I attach list_mvt.ods the database, on which a filter should be applied: 
Nom not empty 
and
Montant > 0

then "Lejeune" should have number 3 when printing

bulletin.odt is the document to print
change the database in order to link it to list_mvt.ods

etapes.odt contains step by step screen shots ( In French)

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

--- Comment #5 from Edwin Sharp <el...@apache.org> ---
Description case 3: Numéro dans la base: empty
File name has trailing zero, i.e. Dupont0.pdf instead Dupont.pdf

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
             Latest|---                         |4.1-dev
    Confirmation on|                            |
     Ever confirmed|0                           |1
                 OS|Windows 7                   |All
           Severity|major                       |normal

--- Comment #3 from Edwin Sharp <el...@apache.org> ---
1. File - Wizards - Address Data Source... - liste_mvt.ods is registered as
data source
2. File - Open... - bulletin.odt
3. View - Data Sources
4. Standard Filter for Nom not null & Montant > 0
5. File - Print... - Yes
6. (Description case 1) Output=File - Save merged document - Save as single
document - OK - Save

Resulting document has Numéro dans la base empty.

AOO410m15(Build:9761)  -  Rev. 1583666
2014-04-01 13:50 - Linux x86_64
Debian

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

vulcain <vu...@gmx.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |vulcain@gmx.com

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|OOo 3.3 or older            |4.0.1

--- Comment #10 from Edwin Sharp <el...@apache.org> ---
3.3 worked... sorry for misunderstanding.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

CdChar <cl...@wanadoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|P3                          |P2

--- Comment #15 from CdChar <cl...@wanadoo.fr> ---
May be "duplicate", but my tests and results according to the option choozen
are slightly different

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

--- Comment #7 from CdChar <cl...@wanadoo.fr> ---
Thanks.
Just a comment more, for me the value is not empty but "1"

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

oooforum <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oooforum@free.fr

--- Comment #1 from oooforum <oo...@free.fr> ---
Duplicate of #i122243#

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

--- Comment #14 from CdChar <cl...@wanadoo.fr> ---
Note that the 3 previous tests can be done after applying filter
for Nom not null & Montant > 0

then selecting in the displayed lines after the filter applyed, only one line,
the one with name = "Lejeune", according the option selected to create the
resulting file, you will get number=3 ( correct) or "1" ( could be also empty)

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |RESOLVED
         Resolution|---                         |DUPLICATE

--- Comment #6 from Edwin Sharp <el...@apache.org> ---
Core of problem is indeed same as issue 122243
Sorry and thank you

*** This issue has been marked as a duplicate of issue 122243 ***

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |elish@apache.org

--- Comment #2 from Edwin Sharp <el...@apache.org> ---
(In reply to oooforum from comment #1)
> Duplicate of #i122243#

IMHO related but not duplicate

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

--- Comment #8 from CdChar <cl...@wanadoo.fr> ---
The last feature version, working correctly, I used, is the one of OOo 3.3.0

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|4.0.1                       |OOo 3.3 or older

--- Comment #9 from Edwin Sharp <el...@apache.org> ---
updating version according comment 8

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

--- Comment #11 from CdChar <cl...@wanadoo.fr> ---
Created attachment 83112
  --> https://issues.apache.org/ooo/attachment.cgi?id=83112&action=edit
Correct result, after applying filter, one odt file per document

1. File - Open... - bulletin.odt ( see previous attachement 83083)
2. File - Print... - Yes
3. View - Data Sources if not already done, attach liste_mvt.ods as data source
4. Standard Filter for Nom not null & Montant > 0

6. Output=File - Save merged document - Save as one ODF file per document - OK 

The result for the file containing, Name="lejeune"  , record number= 3
This result is correct

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

--- Comment #4 from Edwin Sharp <el...@apache.org> ---
Description case 2: Numéro dans la base: empty
File name has trailing zero, i.e. Dupont0.odt instead Dupont.odt

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

--- Comment #12 from CdChar <cl...@wanadoo.fr> ---
Created attachment 83113
  --> https://issues.apache.org/ooo/attachment.cgi?id=83113&action=edit
Wrong result one PDF file per document

Wrong result, after applying filter, one PDF file per document

1. File - Open... - bulletin.odt ( see previous attachement 83083)
2. File - Print... - Yes
3. View - Data Sources if not already done, attach liste_mvt.ods as data source
4. Standard Filter for Nom not null & Montant > 0

5. Output=File - Save merged document - Save as one PDF file per document - OK 

The result for the file containing, Name="lejeune"  , record number= 1
This result is not correct

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

--- Comment #13 from CdChar <cl...@wanadoo.fr> ---
Created attachment 83114
  --> https://issues.apache.org/ooo/attachment.cgi?id=83114&action=edit
Wrong result a single ODF file for all documents

wrong result, after applying filter, a single odt file as output

1. File - Open... - bulletin.odt ( see previous attachement 83083)
2. File - Print... - Yes
3. View - Data Sources if not already done, attach liste_mvt.ods as data source
4. Standard Filter for Nom not null & Montant > 0

5. Output=File - Save merged document - Save as one ODF file per document - OK 

The result for the file containing, Name="lejeune"  , record number= 1
This result is wrong

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 124597] MAILMERGE: Wrong record Number in Mailing

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124597

CdChar <cl...@wanadoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           See Also|                            |https://bugs.freedesktop.or
                   |                            |g/show_bug.cgi?id=76995

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.