OpenWiki Importer

Very cool, Kevin. Thanks for contributing this!

Hi,

I've tried to compile this program, but it is looking for Web References\ConfluenceSOAPAPI\Reference.cs . I haven't been able to find this file anywhere. Any ideas?

you'll need to add a web reference to the confluence soap api

What version of confluence did this work with? I am using 2.2.7.

I had to update it to access OW on our network to use authentication credentials. XMLDocument.Load does not use the current default ones so I was getting a 401 error. I modified it to use HTTPWebRequest and streams which work fine.

Now my problem is in storing the page. I get the following error: "You're not allowed to view that space, or it does not exist."

I have double checked my confluence permissions, used a new account and my admin account. Since it's a test install, I have opened up all the permissions for individual, group and global. The exception happens in LoadPage() at the following point:

ConfluenceSOAPAPI.RemotePage NewPage = ConServ.storePage(Token, Pg);

There is a valid Pg at that point with content, etc. Any tips?

Hello all,

I have now tried this importer successfully with our Openwiki instance. I just had an issue with non-qualifying URI with the attachment links. I changed it (in LoadAttachments function) to work by adding the OWSite before the attachment link, like this:

// Add the OWSite to make a fully qualifying URI out of the attachment link
HttpWebRequest HRequest = (HttpWebRequest)WebRequest.Create(string.Format(@"{0}/{1}", OWSite, ndTable.ChildNodes[i].ChildNodes[1].ChildNodes[0].Attributes["href"].Value));
// Changed from the below line
//HttpWebRequest HRequest = (HttpWebRequest)WebRequest.Create(ndTable.ChildNodes[i].ChildNodes[1].ChildNodes[0].Attributes["href"].Value);

I also added two new replaces to the TranslateOpenWikiPage function to

• fix the JIRA:DUAL-1234 shortcuts to Confluence format of DUAL-1234@jira.
• to change <TableOfContents> Openwiki macro to Confluence {TOC} macro

// Fix Jira links
sConPageData = Regex.Replace(sConPageData, "JIRA:([A-Z]*-[0-9]*)", Regex.Unescape("\\[$1@jira\\]"));

// Use TOC macro
sConPageData = sConPageData.Replace("<TableOfContents>", "{TOC}");

With these changes this importer seems to work very nicely.

br,

Lauri

For the record, I did sort out my issue with OW. Our site is using authentication for each page. So I hacked up my own OW connect function instead of the GetOpenWikiPage function. It could be modified to to read these values from the command line, but this worked for our conversion and that's all I needed.

        public static string RequestPage(Uri resource)
        {
            //'---User's credential---
            string username = "username";
            string password = "password";

            // Create a new HttpWebRequest object for the specified resource.
            WebRequest request=(WebRequest) WebRequest.Create(resource);

            // Supply client credentials.
            ICredentials cred = new NetworkCredential(username, password);
            request.Credentials = cred;
            HttpWebResponse response = (HttpWebResponse) request.GetResponse();
            // Determine whether mutual authentication was used.
            Console.WriteLine("Is mutually authenticated? {0}", response.IsMutuallyAuthenticated);
            // Read and display the response.
            Stream streamResponse = response.GetResponseStream();
            StreamReader streamRead = new StreamReader(streamResponse);
            string responseString = streamRead.ReadToEnd();
           Console.WriteLine(responseString);
            // Close the stream objects.
            streamResponse.Close();
            streamRead.Close();
            // Release the HttpWebResponse.
            response.Close();
            return responseString;
        }

I get the same error: "You're not allowed to view that space, or it does not exist." How did you resolve this?

I tried this solution using this openwikiconverter and some of the pages migrated to Confluence successfully. It some of the pages failed.

I found that pages that are failed are defined in the indentation. For example:

Test Page1 and Page2

• Page 3
• Page 4

It has successfully migrated Page1 and Page2 links to Confluence but failed to migrate Page3 and Page4. It looks like some issue with hyperlinks defined in the indentation. I am using the following statement to retreive pages in the openwikiexporter program (Program.cs)XmlNodeList lstOWPages = XMLOWIndex.SelectNodes("xhtml:html/xhtml:body/xhtml:a", nsmOWIndex);It looke like I have to add something else to add above mentioned pages to migrate all the pages successfully.

Can someone comment on this please.

Thanks

In additon to my previous problem, I noticed that after migration (open wiki to confluence) its not showing any hyperlinks which are internal to Wiki. It only only hyperlinks which are external to Wiki.

 In above example, it only shows hyperlinks if they are external.

 Any suggestions?

The attachement seems to be corrupt. Can someone please upload the attachment that works?

Has anyone got this to work with any of the more recent Confluence Releases? I have 2.7 and even after applying the patch for conf-10235, Confluence Soap API is broken, I'm still getting a series of errors telling me

The type or namespace name 'confluenceservice' does not exist in the namespace 'OpenWikiExport.ConfluenceSOAPAPI'(are you missing an assembly reference?)

Any help or information will be much appreciated.

- Anthony Wakeman 

Anthony, I believe you are trying to open the .cs file directly. Try opening the project which is supplied in the unzipped files. 'OpenWikiExport.csproj'

Now. On to my error. I am also getting some files which are missing when I try to build this in Visual Studio 2008. I open the project and then click build but when I do this it throws these 3 errors:
"Error    1    Source file '...\OpenWikiExport.csproj\Web References\ConfluenceSOAPAPI\Reference.cs' could not be opened ('Unspecified error ')    OpenWikiExport"
"Error    2    Source file '...\OpenWikiExport.csproj\Properties\AssemblyInfo.cs' could not be opened ('Unspecified error ')    OpenWikiExport"
"Error    3    Source file '...\OpenWikiExport.csproj\Properties\Settings.Designer.cs' could not be opened ('Unspecified error ')    OpenWikiExport"
These files are missing. I don't have alot of experience with Microsoft projects and how to debug why this file is not being downloaded or created but I would really appreciate any help. Thanks.

Confluence Version: Version: 2.5.8 Build:#814 Oct 02, 2007
Open Wiki Version: 0.91