ccTiddly Migration back to TiddlyWiki

[Eric Kofoid]

Years ago, I set up a TiddlyWiki for my lab. Some foreign colleagues expressed interest in it, so I converted it to ccTiddly to enable server-side sharing from our lab webpage.  The wiki has lain dormant for some time and I now wish to reanimate it. The University will no longer allow ccTiddly for security reasons. More to the point, ccTiddly won't even work when I migrate the wiki to our new server as it doesn't play well with the most recent version of PHP and, I suspect, with the server operating system itself.

I would like to convert the wiki back to TiddlyWiki in its newest version and use something like the WebServer plugin to publish. However, since all ccTiddly content is stored in a MySQL database, I've found myself laboriously copying a tiddler at a time to the new setup. Is there an easier, more mechanized way to do this?

I have also been experimenting with the WordPress YadaWiki plugin, which seems quite nice but not as simple or efficient to use as TiddlyWiki. Nevertheless, has anyone had any experience moving tiddler pages to it in a scriptable fashion?

Cheers,

Eric

[Mark S.]

I'm thinking that mySql has some tool for exporting to CSV format. If you can export, then you can import into Excel, and from their use the Excel importer edition to import into TiddlyWiki.

-- Mark

[TonyM]

Eric,

I am not very familiar with ccTiddly however does it not have an export mechanisium? 

Along with TiddlyWiki I use WordPress and I hope to develop a higher level of integration between the two. Somewhat opposite I would love to get a saver to save tiddlers into a MySQL DB, perhaps even one that WordPress could pull from.

However as Mark says PHPMyAdmin will let you export MySQL databases and the you can develop a way to import it into any tiddlywiki. I will look to see if there is a best way to do this. This method is however an "under the hood" solution, and an export of data from the "front end" (browser access to your wiki) would possibly be better and quicker if its possible.

Have you worked through the options for hosting your TiddlyWikis on the server? Feel free to raise that here for more advice from the community. I imaging node JS with authentication or the Bob plugin may be the best way to go. 

Regards

Tony

[Mat]

[Disclaimer: I know next to nothing about servers and db's so FWIW:]

First thing to note is that ccTiddly was back in the TW 2.x / classic days so if you want it to run then I would guess you can only realistically turn it into a TW Classic, not a TW5 because TW5 was a fundamental remake of the code.

However, since all ccTiddly content is stored in a MySQL database, I've found myself laboriously copying a tiddler at a time to the new setup. Is there an easier, more mechanized way to do this?

If your content is mostly text, as opposed to code, then you might succeed. You can import CSV and also JSON to TW5. I dabbled with a spreadsheet to JSON converter a few years ago and did manage get tiddlers from spreadsheets.

<:-)