BulkTopicCreationFromTables

A mechanism for Foswiki that turns data in a table into a set of data-form-based topics

Is there a mechanism for Foswiki that will convert a table into a set of data form based topics?

I'm thinking I have a table with C columns, and R rows. This would create R topics where each topic uses a predefined form. The form would of course define C fields. The act of converting would take each row and create a corresponding topic using the form for structure and the row for field content. The benefit is that this would leverage the use of data forms.

This is actually a more general case of the mechanism I built for http://twiki.org/cgi-bin/view/Codev.RegisterCgiScriptRewrite - when the administrator BulkRegisters people they do exactly this: write data into a table and then create topics from that data.

-- MartinCleaver - 31 Mar 2009

[5:14pm] MartinCleaver: well, my use case is that I've an application that needs content in topics. It needs importing from a spreadsheet.
[5:14pm] MartinCleaver: so for each row in the spreadsheet I need a topic
[5:14pm] SvenDowideit__: so use excelimportexport?
[5:15pm] SvenDowideit__: like the rest of us do?
[5:15pm] MartinCleaver: Will that create separate topics, one per row?
[5:15pm] • SvenDowideit__ refers martin to the docco and dissapears in a puff of bits
[5:16pm] MartinCleaver: "It also provides scripts to generate a set of topics from an Excel spreadsheet, and vice versa"

-- MartinCleaver - 01 Apr 2009