[libreoffice-users] Re: Mailmerge from query broken in 3.4.6?

Le 28/09/12 14:43, Mark Stanton a écrit :

Hi Mark,

> My query couldn't use the query wizard (Andreas won't be surprised).  
> In coding the query I wrote the field names in camelcase (eg 
> "Address1", "PersonName"), the actual database fields are all in 
> lowercase.  Changing this made the mailmerge show data.
> However, the query worked prior to that, and in fact the hidden 
> paragraph conditions worked correctly, even though they were also in 
> camelcase.

I seem to recall reading that somewhere on the French user list a while ago.


> Interestingly, calculated fields given camelcase names with "AS" 
> work!  Uncalculated fields given names (eg `Address1` AS `Address1`) 
> don't.
>
> Interestingly, again, it seems that some conditional statements don't 
> work the way they used to, either.

Yes, from what I have seen on the French user list, I would concur, but
have not tried this myself. I gave up on the mailmerge wizard ages ago,
because it kept screwing up my results. There is also a bug where the
fields of the db get shifted towards the right in a Writer document, for
some as yet unexplained reason, which also screws up people's mailmerge
templates...

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

Duplicate mailmerge data entries :
https://bugs.freedesktop.org/show_bug.cgi?id=47951

Layout :
https://bugs.freedesktop.org/show_bug.cgi?id=54809
https://bugs.freedesktop.org/show_bug.cgi?id=52523

Blank lines :
https://bugs.freedesktop.org/show_bug.cgi?id=35798

Non-ascii characters (e-mail) :
https://bugs.freedesktop.org/show_bug.cgi?id=38713

Pictures in mailmerge labels :
https://bugs.freedesktop.org/show_bug.cgi?id=51303

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


and the list goes on...


Alex




-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted