[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

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

QA Administrators  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |INVALID

--- Comment #20 from QA Administrators  ---
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INVALID due to inactivity and a lack of
information which is needed in order to accurately reproduce and confirm the
problem. We encourage you to retest your bug against the latest release. If the
issue is still present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating system and the
latest version of LibreOffice that you have confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED and we will
attempt to reproduce the issue. 
Please do not:
a) respond via email 
b) update the version field in the bug or any of the other details on the top
section of FDO
Message generated on: 2015-09-03

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

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

--- Comment #19 from QA Administrators qa-ad...@libreoffice.org ---
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months.
Please provide the requested information as soon as possible and mark the bug
as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in
NEEDINFO status with no change in 30 days the QA team will close the bug as
INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located
here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as
UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team

This NEEDINFO message was generated on: 2015-07-18

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #18 from Alex Thurgood ipla...@yahoo.co.uk ---
Adding self to CC if not already on

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #16 from Thomas Krumbein t...@mic-consulting.de ---
I´ll just jump in because I got a similar question today. 

Customer uses MAC OS (I don´t know the exact version) and LibreOffice since 3
years. 
Now he has updated to LibO Version 4.2.6.2 and now all is Mail-merge documents
doesn´t work any more.

Reason: in former version LibO uses german translated field names - and all
mail-merge fields are now fixed to these names. 
the actual version now uses englisch field-names - so merging is not possible.

I added an aktual sceenshot witch may explain the differenz.

So the question is: What was changed?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #17 from Thomas Krumbein t...@mic-consulting.de ---
Created attachment 107571
  -- https://bugs.freedesktop.org/attachment.cgi?id=107571action=edit
Sceenshot 4.2.6.2 - Fieldnames in English - former in German

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

Alex Thurgood ipla...@yahoo.co.uk changed:

   What|Removed |Added

Summary|Field aliases from MySQL|Field aliases from MySQL
   |query not correctly applied |query not correctly applied
   ||in mailmerge

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #9 from Alex Thurgood ipla...@yahoo.co.uk ---
Hi,

I imagine that your query has been saved in the corresponding ODB file ?
When you execute that query there, i.e. within the ODB file, does the UI
display the aliases correctly ?


Alex

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #10 from cpohle cpo...@gmail.com ---
 I imagine that your query has been saved in the corresponding ODB file ?
 When you execute that query there, i.e. within the ODB file, does the UI
 display the aliases correctly ?

Yes, Base displays correct column headers.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #11 from Alex Thurgood ipla...@yahoo.co.uk ---
Well at least that narrows it down to the mailmerge/Wrtier component

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #12 from Alex Thurgood ipla...@yahoo.co.uk ---
Have you declared the datasource as your address book database under Tools 
Exchange Addressbok ?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #13 from cpohle cpo...@gmail.com ---
 Have you declared the datasource as your address book database under Tools 
 Exchange Addressbok ?

No, I've registered it via the preferences dialogue.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #14 from Alex Thurgood ipla...@yahoo.co.uk ---
At the moment, I don't have any non-capitalized field names that I could use as
an address source. If there is a problem, then it is in the matching of lower
case equivalent field names with those provided by the mailmerge field code.


Additionally, how are you carrying out your mailmerge ? (you never said)

(a) Are you using the Mailmerge menu entry ?

or

(b) Are you inserting fields via dragndrop into your Writer document, and then
printing a form letter ?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 80810] Field aliases from MySQL query not correctly applied in mailmerge

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=80810

--- Comment #15 from Alex Thurgood ipla...@yahoo.co.uk ---
Please give precise steps, otherwise we will spend too much time trying to nail
this down.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs