Well, one of our developers was tasked with converting a ton of Word
docs into Wiki pages, which he did with wvWare (probably combined with a
perl script to invoke and upload). However, we just converted the
documents to HTML and posted them using HTML Trac wiki processor as we
only cared to have the content for searching and historical display. He
attempted to make a wvWare script to convert directly to Trac, which I
have attached, but it was never used.
The developer's comments on the script:
"a partial, non-working attempt to make wvWare output Trac-Wiki-friendly
text, but there were some problems with lists and whitespace I could not
overcome (all bulleted lists would have to be manually corrected, and
vertical whitespace would need to be manually or automatically
corrected)."
For Excel, I noticed that when you copy/paste from or to Excel, that it
works with tab separated values. I wrote a Python macro (used as a wiki
processor) so you can paste an Excel doc or CSV file and it would format
it. There are CSV macros out there already but ours allows for Trac
formatting in the fields. The limitation is that the copy/paste only
works for things where you would expect a CSV to work, a rectangular
table. No Excel formatting nor things like graphs and charts are
preserved. What I mean when I say that it allows for Trac formatting is
that if you put "This is some cell content that has ''italics'' and
links to TracGuide", the italics and TracGuide will come out formatted.
Jason
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf Of AmanKow
Sent: Saturday, March 22, 2008 1:43 PM
To: Trac Users
Subject: [Trac] Re: .doc to wiki page ?
Well, that macro is a big win for me...
I think my needs are similar to that of most people... getting a bunch
of disparate legacy docs into trac wiki as a one time deal. Then I
can work on them with spending a lot of time dealing with the 99% of
the formatting that is commonly used in word docs.
Does anyone know of a similar macro for excel? I could really use
that!
Wayne
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
<main>
<charentity>
<begin>HTML</begin>
</charentity>
<document>
<begin>= <title/> =
</begin>
<end/>
</document>
<section>
<begin/>
<end>
</end>
</section>
<justification>
<left/>
<right/>
<center/>
<block/>
<asian/>
</justification>
<numbering>
<Arabic/>
<UpperRoman/>
<LowerRoman/>
<UpperCaseN/>
<LowerCaseN/>
</numbering>
<border>
<noned/>
<singled/>
<thickd/>
<doubled/>
<number4d/>
<hairlined/>
<dotd/>
<dashlargegapd/>
<dotdashd/>
<dotdotdashd/>
<tripled/>
<thin-thicksmallgapd/>
<thick-thinsmallgapd/>
<thin-thick-thinsmallgapd/>
<thin-thickmediumgapd/>
<thick-thinmediumgapd/>
<thin-thick-thinmediumgapd/>
<thin-thicklargegapd/>
<thick-thinlargegapd/>
<thin-thick-thinlargegapd/>
<waved/>
<doublewaved/>
<dashsmallgapd/>
<dashdotstrokedd/>
<emboss3Dd/>
<engrave3Dd/>
<defaultd/>
</border>
<olist>
<begin>(olist)</begin>
<end/>
</olist>
<ulist>
<begin>ulist</begin>
<end/>
</ulist>
<entry>
<begin> <start/>. </begin>
<end/>
</entry>
<!--
this tableoverride option can be used to turn off handling of
these tags in tables, which I find is necessary for at least netscape
-->
<tableoverrides>
<ParaBefore>0</ParaBefore>
<ParaRight>0</ParaRight>
<ParaAfter>0</ParaAfter>
<ParaLeft>0</ParaLeft>
<ParaLeft1>0</ParaLeft1>
<VertMergedCells>0</VertMergedCells>
</tableoverrides>
<table>
<begin/>
<end/>
</table>
<row>
<begin>||</begin>
<end/>
</row>
<cell>
<begin/>
<end>||</end>
</cell>
<paragraph>
<begin><table.end/>
<table.begin/>
<row.begin/><cell.begin/><olist.end/><olist.begin/><ulist.end/><ulist.begin/><entry.begin/><text.begin/></begin>
<end>
</end>
</paragraph>
<!-- these are all the character properties that can show up in word -->
<bold><begin>``'''</begin><end>``'''</end></bold>
<italic><begin>``''</begin><end>``''</end></italic>
<!--
text that has been deleted and will be displayed with strikethrough when
revision marked text is to be displayed
-->
<RMarkDel><begin>~~</begin><end>~~</end></RMarkDel>
<!-- Overwriting char props. like CaPs->CAPS SmallCaps->smallcaps -->
<outline><begin/><end/></outline>
<smallcaps><begin/><end/></smallcaps>
<caps><begin/><end/></caps>
<vanish><begin/><end/></vanish>
<!--
text that has been newly typed since the last time revision marks have been accepted
and will be displayed with underline when revision marked text is to be displayed
-->
<RMark><begin>__</begin><end>__</end></RMark>
<strike><begin>~~</begin><end>~~</end></strike>
<shadow><begin/><end/></shadow>
<lowercase><begin/><end/></lowercase>
<emboss><begin/><end/></emboss>
<imprint><begin/><end/></imprint>
<!--double strike-->
<dstrike><begin>~~</begin><end>~~</end></dstrike>
<super><begin>^</begin><end>^</end></super>
<sub><begin>,,</begin><end>,,</end></sub>
<singleu><begin>__</begin><end>__</end></singleu>
<wordu><begin>__</begin><end>__</end></wordu>
<doubleu><begin>__</begin><end>__</end></doubleu>
<dottedu><begin>__</begin><end>__</end></dottedu>
<hiddenu><begin>__</begin><end>__</end></hiddenu>
<thicku><begin>__</begin><end>__</end></thicku>
<dashu><begin>__</begin><end>__</end></dashu>
<dotu><begin>__</begin><end>__</end></dotu>
<dotdashu><begin>__</begin><end>__</end></dotdashu>
<dotdotdashu><begin>__</begin><end>__</end></dotdotdashu>
<waveu><begin>__</begin><end>__</end></waveu>
<!--
text whose properties have been changed since the last time revision marks have been accepted
and will be displayed with a note showing the change points.
-->
<PropRMark><begin/><end/></PropRMark>
<!--
<color>
-->
<Black><begin/><end/></Black>
<Blue><begin/><end/></Blue>
<Cyan><begin/><end/></Cyan>
<Green><begin/><end/></Green>
<Magenta><begin/><end/></Magenta>
<Red><begin/><end/></Red>
<Yellow><begin/><end/></Yellow>
<White><begin/><end/></White>
<DkBlue><begin/><end/></DkBlue>
<DkCyan><begin/><end/></DkCyan>
<DkGreen><begin/><end/></DkGreen>
<DkMagenta><begin/><end/></DkMagenta>
<DkRed><begin/><end/></DkRed>
<DkYellow><begin/><end/></DkYellow>
<DkGray><begin/><end/></DkGray>
<LtGray><begin/><end/></LtGray>
<!--
</color>
-->
<!--
<animation>
-->
<LasVegas><begin><blink></begin><end></blink></end></LasVegas>
<BackgroundBlink><begin><blink></begin><end></blink></end></BackgroundBlink>
<SparkleText><begin><blink></begin><end></blink></end></SparkleText>
<MarchingAnts><begin><blink></begin><end></blink></end></MarchingAnts>
<MarchingRedAnts><begin><blink></begin><end></blink></end></MarchingRedAnts>
<Shimmer><begin><blink></begin><end></blink></end></Shimmer>
<!--
</animation>
-->
<DispFldRMark><begin/><end/></DispFldRMark>
<animation>
<begin/>
<end/>
</animation>
<fontstr>
<begin>(font)</begin>
<end>(endfont)</end>
</fontstr>
<comment>
<begin>{{{
#!comment
</begin>
<end>}}}</end>
</comment>
<style name="Normal">
<character>
<begin><bold.begin/><italic.begin/><strike.begin/><outline.begin/><dstrike.begin/><super.begin/><sub.begin/><singleu.begin/><wordu.begin/><doubleu.begin/><dottedu.begin/><hiddenu.begin/><thicku.begin/><dashu.begin/><dotu.begin/><dotdashu.begin/><dotdotdashu.begin/><waveu.begin/></begin>
<end><waveu.end/><dotdotdashu.end/><dotdashu.end/><dotu.end/><dashu.end/><thicku.end/><hiddenu.end/><dottedu.end/><doubleu.end/><wordu.end/><singleu.end/><sub.end/><super.end/><dstrike.end/><outline.end/><strike.end/><italic.end/><bold.end/></end>
</character>
<pmargin><begin/></pmargin>
<pborder><begin/></pborder>
<text>
<begin/>
<end/>
</text>
<picture>
<begin>(a picture was here)</begin>
</picture>
</style>
</main>
