Bug 486646
Summary: | MailMerge to HTML EMail Produces MSWord XML Garbage | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | [Fedora] Fedora | Reporter: | Eli Wapniarski <eli> | ||||||
Component: | openoffice.org | Assignee: | Caolan McNamara <caolanm> | ||||||
Status: | CLOSED INSUFFICIENT_DATA | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||||
Severity: | medium | Docs Contact: | |||||||
Priority: | low | ||||||||
Version: | 10 | CC: | caolanm, dtardon, jnavrati | ||||||
Target Milestone: | --- | ||||||||
Target Release: | --- | ||||||||
Hardware: | All | ||||||||
OS: | Linux | ||||||||
Whiteboard: | |||||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||||
Doc Text: | Story Points: | --- | |||||||
Clone Of: | Environment: | ||||||||
Last Closed: | 2009-02-28 14:48:33 UTC | Type: | --- | ||||||
Regression: | --- | Mount Type: | --- | ||||||
Documentation: | --- | CRM: | |||||||
Verified Versions: | Category: | --- | |||||||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||
Cloudforms Team: | --- | Target Upstream Version: | |||||||
Embargoed: | |||||||||
Attachments: |
|
Description
Eli Wapniarski
2009-02-20 20:26:48 UTC
What is exact version of your openoffice.org? What openoffice.org packages have you installed? (Run rpm -q openoffice.org-core yum list installed openoffice.org-\* in terminal to get the information.) Which data source are you using as the address list? datasource is a dbase database. rpm -qa | grep openoffice openoffice.org-writer-3.0.1-15.2.fc10.x86_64 openoffice.org-writer-core-3.0.1-15.2.fc10.x86_64 openoffice.org-javafilter-3.0.1-15.2.fc10.x86_64 openoffice.org-rhino-3.0.1-15.2.fc10.x86_64 openoffice.org-draw-core-3.0.1-15.2.fc10.x86_64 openoffice.org-ure-3.0.1-15.2.fc10.x86_64 openoffice.org-pyuno-3.0.1-15.2.fc10.x86_64 openoffice.org-calc-3.0.1-15.2.fc10.x86_64 openoffice.org-impress-3.0.1-15.2.fc10.x86_64 openoffice.org-devel-3.0.1-15.2.fc10.x86_64 openoffice.org-wiki-publisher-3.0.1-15.2.fc10.x86_64 openoffice.org-langpack-he_IL-3.0.1-15.2.fc10.x86_64 openoffice.org-bsh-3.0.1-15.2.fc10.x86_64 openoffice.org-report-builder-3.0.1-15.2.fc10.x86_64 openoffice.org-base-3.0.1-15.2.fc10.x86_64 openoffice.org-pdfimport-3.0.1-15.2.fc10.x86_64 openoffice.org-base-core-3.0.1-15.2.fc10.x86_64 openoffice.org-brand-3.0.1-15.2.fc10.x86_64 openoffice.org-sdk-doc-3.0.1-15.2.fc10.x86_64 openoffice.org-testtools-3.0.1-15.2.fc10.x86_64 openoffice.org-emailmerge-3.0.1-15.2.fc10.x86_64 openoffice.org-core-3.0.1-15.2.fc10.x86_64 openoffice.org-langpack-en-3.0.1-15.2.fc10.x86_64 openoffice.org-langpack-de-3.0.1-15.2.fc10.x86_64 openoffice.org-headless-3.0.1-15.2.fc10.x86_64 openoffice.org-presentation-minimizer-3.0.1-15.2.fc10.x86_64 openoffice.org-math-core-3.0.1-15.2.fc10.x86_64 openoffice.org-calc-core-3.0.1-15.2.fc10.x86_64 openoffice.org-presenter-screen-3.0.1-15.2.fc10.x86_64 openoffice.org-impress-core-3.0.1-15.2.fc10.x86_64 openoffice.org-sdk-3.0.1-15.2.fc10.x86_64 openoffice.org-xsltfilter-3.0.1-15.2.fc10.x86_64 openoffice.org-math-3.0.1-15.2.fc10.x86_64 openoffice.org-graphicfilter-3.0.1-15.2.fc10.x86_64 openoffice.org-draw-3.0.1-15.2.fc10.x86_64 That's a really weird chunk of text, i.e. <w:WordDocument> <w:MailMergeMainDocType>FormLetters</w:MailMergeMainDocType> <w:MailMergeLinkToQuery/> <w:MailMergeQueryString> etc look's more like Microsoft Office OOXML, or MSWord html export, and the file paths listed in it are window-esque. OOo itself surely didn't generate that content itself from scratch. If I create an HTML email mail merge and I get the garbage text. Then it really doesn't matter much who generates the text. I simply open up a file. Request the mailmerge wizard to create an html email. And this is what I get. I certainly can't strip out the junk from the original document. And if OpenOffice can't do it then I would call this a bug. No? Well, if the original document somehow happens to contain <w:WordDocument><w:MailMergeMainDocType> as actual *text* then there is no bug. But if the original document is a MSOffice document in ooxml format and the text has become inline text due to an import problem, then its not a mailmerge issue, but an import issue. Can you attach the original file that you "open up" and create the mailmerge from. Created attachment 332919 [details]
Origianal Document Producing Garbage on HTML mailmerge
Origianal Document Producing Garbage on HTML mailmerge
HTML email is exported and sent just fine. I looked around a little and found that XML code is XML export from Word 2003 (WordML, as they call it). AFAIK, there is no way you could get it from openoffice.org, so it's probably caused by an additional export filter. Have you got any extensions installed or any export filters configured? Does 'Save As...'->'HTML Document' work? Forgot to set needinfo.... It seems to. OK. This is weird. I just tried to copy / paste the orginal document to another to an empty document. And I seem to have gotten those records that I talked about. I'm going to try to clean that out and see if this helps. Firstly... I must of tried something, but I can't remember what it was. But it would seem that I have no MSWord XML extension listed in the Extension Manager. But, when I click on save as and go down the list. Whaddaya know? There is a MS Word 2003 XML export filter. Secondly. What I did was copy sections that I wanted to a new document. MailMerged and the mailmerge to HTML worked. Thirdly... I traded one problem for another. Even though my document is formatted from Left to Right. All of it being in English. The email that gets sent get formatted right to left (Arrgh) :) . But this certainly is progress. Fourth... Just did a new cut and paste, but first I formatted the page so that under Layout Settings Page layout, I've selected Only left. It seems to work OK now. But this, I guess. should also something that. Thank You, Thank You, Thank You. OK... I've got to step away from my computer for serious stuff. I will get back to this tomorrow if there is anything that I can do to help with this problem. OK.. I've had a little time to think on this and what I think happened is this. I the file to msword xml file. And the saved it again as an odt file. Now... I already have a database attached to the file. When I saved the file as an xml file it pulled in at least some of the database records and made the data hidden. When I saved the file as odt file it kept the msword xml tag in the files header and also kept the hidden database records. And this probably corrupted my efforts to create an html email mailmerge document. (In reply to comment #14) Hmm, looks like I knew wrong: openoffice.og _can_ export to WordML, through XSLT filter (openoffice.org-xsltfilter). > I the file to msword xml file. And the saved it again as an odt file. Now... I > already have a database attached to the file. When I saved the file as an xml > file it pulled in at least some of the database records and made the data > hidden. When I saved the file as odt file it kept the msword xml tag in the > files header and also kept the hidden database records. > No, the ODT source doesn't contain any anomalies. You can trust me I'd find them, were there any :) You can try one more thing: move ~/.openoffice.org away and try to create the mail again. If it works, we'd like to see the original .openoffice.org . Created attachment 333034 [details]
Original .openoffice.org
Eli Wapniarski's orignal .openoffice.org folder.
I see there's an entry for last used documents of an .xml with Filter "MS Word 2003 XML" in one entry, so that's probably the msxml document involved. But saving a doc as .xml with our filter shows a slightly different structure (e.g. <o:Editor dt:dt="string">OpenOffice.org/3.0$Linux OpenOffice.org_project/300m15$Build-9379</o:Editor>), and the above contained mailmerge info, which we don't implement in that filter, and we don't have an option to send as that format, so I suspect that the document in the original mail come from msoffice itself rather than us. If anyone can reproduce this from scratch, feel free to reopen with a step-by-step |