Question

I've installed Twiki successfully on my system. However, I'm not quite sure if it can do what I was hoping.

I'd like to use Twiki to create and maintain a database of country profiles. For example, I'd like the Twiki to contain one page per country. Each page would have on it the exact same table containing rows set as either a 1 or 0 (e.g. "Does the country have copyright laws? 1", "Does the country impose a fine for a violation of that law? 0"). I'd like this table to be saved into a template, so if I wanted to add a new country, I can just select the template and add it to the new country page.

Also, and most importantly, I'd want to be able to extract all the table data into CSV format so I could dump it into Excel. For example, run a search query that would return multiple rows, each one in the format like, "Ireland,0,1,1,1,0,0,1".

Is this possible with Twiki? I looked into TwikiTemplateForms, but those don't seem to work cross-page. Also, I'm not sure how to do a search like the one I mentioned above. Any help would be greatly appreciated!

Thanks.

Environment

-- AchalOza - 14 Jun 2007

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

You can design a TWikiForms based TWikiApplication, and create FormattedSearch reports using VarSEARCH. See sample applications ItemToDo, ChangeRequest, TWikiInstallation.

You can copy a repart in table format into the clipboard and paste it into Excel, or you can use one of the Extensions:export tools.

-- PeterThoeny - 14 Jun 2007