Josh: I used the "save to XML" trick to create a component that will take any grid and create a MS Excel 2003 compliant XML structure. It worked pretty good.
However I would still need to convert the ratty HTML built by the RichTextEditor component to XML. I have a partial mule (half a**ed) solution using Axel Jensen's ACJEditor script to clean up the html, do a little additional cleanup, prepend the crap that MS puts on the beginning of their word- html docs and I get something close to reasonable. I would really like to do better. I am currently trying to figure out if I can store actual word docs with mail merge tags built into the DB, and then query them up, send the doc, and then the merge data to word via the middleware (.net). Paul --- In [email protected], "Josh McDonald" <[EMAIL PROTECTED]> wrote: > > Try doing the "save to XML" from Word and you might be able to use that as a > template to generate a word-friendly "XML" document (I use the term > loosely). It's ugly, but I've done this with XSLT a couple of years ago in > order to programatically create excel files... > > -Josh > > On Mon, Aug 25, 2008 at 2:40 AM, Don Kerr <[EMAIL PROTECTED]> wrote: > > > No prob. No matter what middleware you use, unfortunately, you do need > > to replace some of the RTE htmlText to convert it to html the > > browser,email,or Word, etc. can use. That was my main point about > > fixing your font issue. > > > > Hope it helps. > > Don > > > > > > --- In [email protected], "aceoohay" <pauls@> wrote: > > > > > > Don: > > > > > > Thanks for taking the time to post about the CF solution, I will give > > > it a try, converting either to AS3, or VB.NET on the backend. > > > > > > CF is not an option, for these apps. I do have an associate on staff > > > that does CF, but the approach I'm taking is using minimalist > > > middleware pieces in VB.NET. I'm trying to do as much in the DB > > > (Oracle) and the presentation layer (Flex) as possible, writing a few > > > minimal routines using fluorine and .net. > > > > > > Paul > > > > > > --- In [email protected], "Don Kerr" <fusionpage@> wrote: > > > > > > > > Paul, > > > > On my http://www.spacecityaug.com Flex blog app, I have a Print/PDF > > > > button that takes the Flex RichText and produces the downloaded > > > > reports. I used Adobe ColdFusion to dyamically produce the reports > > > in > > > > Word, Excel, and PDF. Flex and CF tag team. The same ColdFusion > > > > components on the server feed the Flex app and the downloads. > > > > > > > > If ColdFusion is not an option for you, I've yet to see anyone offer > > > > components for printing/reporting directly from the Flex client > > > > without using a server-side technology. AlivePDF looks interesting > > > for > > > > going straight to PDF from Flex client. > > > > Check it out at http://alivepdf.bytearray.org/ . > > > > > > > > ColdFusion makes it very easy to do downloadable reports using > > > various > > > > out-of-the-box tags like cfdocument,cfpdf,cfpresentation and even > > > > comes with a report builder to generate the kind of reports you > > > need. > > > > Flex/ColdFusion are working extremely well together to meet all the > > > > various needs of my NASA customers. > > > > > > > > So, how do you solve the font issue with Flex RTE?? > > > > > > > > To solve the font problem you need to strip out the "non- standard" > > > > HTML parts of the Flex htmlText and set your desired font in the > > > > style. Here is the portion of my ColdFusion code that does it > > > > (textarea1 is the flex rte content that is stored in the database > > > when > > > > the users posts a blog entry). in this case I use CFDOCUMENT tag > > > > > > > > <cfdocument format="PDF" backgroundvisible="true" fontembed="true" > > > > orientation="portrait"> > > > > <cfloop query="Results"> > > > > <cfoutput> > > > > <cfset EntryParatext=#Replace(#Results.textarea1#, Chr > > > (13),"<p>","All")#> > > > > <cfset EntryParatext=#Replace (#EntryParatext#,'SIZE="9"'," ","All") > > > #> > > > > <cfset EntryParatext=#Replace (#EntryParatext#,'SIZE="10"'," ","All") > > > #> > > > > <cfset EntryParatext=#Replace (#EntryParatext#,'SIZE="11"'," ","All") > > > #> > > > > <cfset EntryParatext=#Replace (#EntryParatext#,'SIZE="12"'," ","All") > > > #> > > > > <cfset EntryParatext=#Replace (#EntryParatext#,'SIZE="14"'," ","All") > > > #> > > > > <cfset EntryParatext=#Replace (#EntryParatext#,'SIZE="16"'," ","All") > > > #> > > > > <cfset EntryParatext=#Replace (#EntryParatext#,'SIZE="18"'," ","All") > > > #> > > > > </cfoutput> > > > > <html> > > > > <head> > > > > <style type="text/css"> > > > > > > > > BODY { > > > > font-family:Verdana, Arial, Helvetica, sans-serif; > > > > font-size:11px; > > > > } > > > > </style> > > > > </head> > > > > > > > > > > > > This fixes the "BIG FONT" issue in when RTE htmlText is sent out > > > > inside an HTML email to the users or when it is fed to Word, PDF, > > > > excel, etc. > > > > > > > > I suggest you look into ColdFusion 8! > > > > > > > > Don Kerr > > > > Manager, Space City Adobe User Group > > > > > > > > > > > > > > > > --- In [email protected], "aceoohay" <pauls@> wrote: > > > > > > > > > > I need to do Mail Merge from a flex application. > > > > > > > > > > Creating the database piece is easy. I have also been able to > > > create > > > > > the merge with htmlText from a RichTextEditor component. > > > > > > > > > > The problem of course is printing. I tried flexReport, and > > > everything > > > > > is ducky except that I can't find anyway to force pagebreaks > > > > > programmatically within flexReport. If I understood the component > > > > > pieces that do the HTML rendering within flexReport I would try > > > to > > > > > force it to honor the <p style="pageBreakAfter:always"> tag. I > > > posted > > > > > to the flexReport Google Code bug list over a week ago with no > > > response > > > > > as of yet. > > > > > > > > > > At any rate I still need to do MailMerge. I am not opposed to > > > most any > > > > > solution. If there is a component that would convert flex created > > > HTML > > > > > to RTF, or a MS DOC file, that would be OK as well. > > > > > > > > > > I tried taking the HTML generated by the flex RichTextEditor, and > > > > > importing it into MS Word, and the fonts are massive, and > > > changing the > > > > > font within the RichTextEditor component had no affect on what MS > > > Word > > > > > produced. > > > > > > > > > > Does anyone have any ideas? > > > > > > > > > > Paul > > > > > > > > > > > > > > > > > > > > ------------------------------------ > > > > -- > > Flexcoders Mailing List > > FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt > > Search Archives: > > http://www.mail-archive.com/flexcoders%40yahoogroups.comYahoo! Groups > > Links > > > > > > > > > > > -- > "Therefore, send not to know For whom the bell tolls. It tolls for thee." > > :: Josh 'G-Funk' McDonald > :: 0437 221 380 :: [EMAIL PROTECTED] >
