Is there a way to import Outlook "Public Folders" into Confluence as pages?

[Rhyne Armstrong]

We have over 1000 knowledgebase articles in Outlook public folders that I would like to import into Confluence as pages. I can export as CSV, RTF, etc, but can't figure out how to import those files into Confluence more than one at a time.

Thanks!

[Bob Swift (personal) · Accepted solution]

Confluence Command Line Interface should help :). Use --action addPage. It will not help with the formatting though.

[Rhyne Armstrong]

Thanks Bob. I am looking through the information for the Interface and having trouble figuring out how to specify the source directory for the addPage action.

[Bob Swift (personal)]

--file is the parameter you need to specify. You will need to script it to get all files in a directory for instance. Another option is: --action loadFiles which will work over a directory automatically.

[Rhyne Armstrong]

I must be doing something wrong. I was able to add the files as attachments using --action loadFiles, but not create pages from them. I will try converting to HTML first as this was with RTF files.

[Bob Swift (personal)]

mime type of text/html or text/plain will get get pages. Extensions like .txt for instance will be added as pages.

[Rhyne Armstrong]

It looks like the conversion tool is setting the mime type in a non-standard manner. It can be read by Firefox, but none of the content is added to the pages that are created. Is there an example of this syntax anywhere? I could just have something wrong.

[Rhyne Armstrong]

They are all .html I will try converting to .txt to see if it helps.

[Bob Swift (personal)]

What are the extensions on the files? It is likely you need to rename them to txt for instance.

[Bob Swift (personal)]

Create an issue at https://studio.plugins.atlassian.com/browse/CSOAP and attach a couple of example files (RTF and HTML).

[Bob Swift (personal)]

I thought I posted this comment earlier, but I don't see it now. Please create an issue and attach a couple of examples (HTML and text) and I will have a look. Normally you want text if possible as HTML gets wrapped in a HTML tag so it displays, but not good for edit.

[Rhyne Armstrong]

The command line is adding the files as <directory name> - <Title>.txt with nothing in the content. I am using:

confluence --space "Knowledgebase" --action loadFiles --file "d:\test"