[campsite-dev] Article Import: Open Office Template
  • This is a multi-part message in MIME format.
    --------------010903060106050409070200
    Content-Type: text/plain; charset=ISO-8859-2; format=flowed
    Content-Transfer-Encoding: 7bit

    After much discussion with Sava and Mugur, here is the proposal for the
    "article import" function. This covers scenario #1 where an article is
    written in an Editor and then uploaded to the server. This scenario has
    been made more specific: the article is written in Open Office. Support
    for other apps can be added later.

    Open Office files (.sxw) are ZIP files in disguise. Inside, there are a
    bunch of XML files. One nice thing about the fact that it is a ZIP file
    is that everything is in one file - including any pictures that you
    include.

    Open Office also supports templates. A sample template is attached
    (Note: not the final version, just a test). See the instructions below
    on how to use it. A template has the ability to mimic the article
    creation screens in Campsite. You can see how this works when you give
    it a try.

    Campsite Article Import will simply accept .sxw files. The XML content
    in the OO file must follow a certain format which is laid out by the
    template (certain XML tags). The template can be changed, but the names
    of the fields must be the same. The pictures will be added to the
    database and their links changed so that they work properly.

    So a user who want to upload an article just creates the article from
    the template (including any pictures) and uploads the resulting file.
    It seems to be the easiest way.

    If you have an suggestions or comments, let me know!

    - Paul

    ------------------------
    How to use the template:
    ------------------------
    Save it to your home directory. Load OpenOffice and go to
    New->"Templates And Documents". Find the file, select it, and click
    "open". (If you cant find the file, move the file to one of the
    directories that Open Office is looking for).

    When you load up the document, it will ask you a series of questions -
    the same ones that are in the application when you add an article. You
    can skip these and answer them later if you want. There was one system
    I tested it on (Windows with open office 1.1 - not 1.1.2) where things
    didnt show up correctly, but they definitely do with OO 1.1.2 on
    windows. I developed it on OO 1.1 on Linux.

    If you click on the dark fields, they will popup dialog boxes where you
    can select an option.




    --------------010903060106050409070200
    Content-type: message/external-body; access-type=URL; URL=http://sympa.mdlf.org/sympa-bin/wwsympa.fcgi/attach/campsite-dev/40F7F090.7060207@paulbaranowski.org/TemplateTest_stw; name="TemplateTest_stw"; size="6087"

    Content-type: application/vnd.sun.xml.writer.template;
    name="TemplateTest.stw"
    Content-Transfer-Encoding: base64

    --------------010903060106050409070200--

    ------------------------------------------
    Posted to Phorum via PhorumMail
  • 3 Comments sorted by
  • I think that this feature has already been implemented in Typo3. Might
    be possibly to lift it from there. It's probably just a bit of XLST
    anyway...

    JP

    ------------------------------------------
    Posted to Phorum via PhorumMail
  • I searched through the typo3 stuff and couldnt find it. I'll try using
    some XSLT this week...

    John Pye wrote:

    > I think that this feature has already been implemented in Typo3. Might
    > be possibly to lift it from there. It's probably just a bit of XLST
    > anyway...
    >
    > JP
    >

    ------------------------------------------
    Posted to Phorum via PhorumMail
  • Hey Paul

    These links might help perhaps. Turns out they are importing to DocBook
    first via XSLTs that are available on the OpenOffice.org website, then
    going from there.

    http://www.zzoss.com/projects/oowdbk/docbook/html-all.html
    http://xml.openoffice.org/source/browse/xml/xmerge/java/org/openoffice/xmerge/converter/xml/xslt/docbook/sofftodocbook.xsl?only_with_tag=HEAD
    http://typo3.org/doc.0.html?&tx_extrepmgm_pi1[extUid]=291&cHash=26debf4caa
    http://typo3.org/documentation/document-library/doc_typo3org/Rules_for_writing_SX/

    JP

    Paul Baranowski wrote:

    > I searched through the typo3 stuff and couldnt find it. I'll try
    > using some XSLT this week...
    >
    > John Pye wrote:
    >
    >> I think that this feature has already been implemented in Typo3.
    >> Might be possibly to lift it from there. It's probably just a bit of
    >> XLST anyway...
    >>
    >> JP
    >>
    >

    ------------------------------------------
    Posted to Phorum via PhorumMail