Question

We have created a form template to match the structure of a data table. We'd like to populate the forms by importing the data from the tables. What is the simplest method of automating this? (The data table is a large excel converted to whatever format you recommend: tab-delimited, csv, etc.)

By the by, we launch a new corporate intranet built with twiki on Thursday. We hope to post a success story in April.

Environment

-- JaredFreeman - 15 Mar 2006

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

Currently, there is no easy way to accomplish this and it's a long overdue feature so I have created a FeatureRequest for ImportingExternalDataToTWiki. Feel free to add additional comments there regarding your specific needs.

You might also take a look at DatabasePlugin which offer the ability for TWiki interact with an external database.

-- LynnwoodBrown - 15 Mar 2006

There are several options to import office content into TWiki, see Extensions:import

-- PeterThoeny - 15 Mar 2006

twiki_page_generator.pl (attached, but lose the .txt extension) is a quasi-generalized script that reads in a table with form field names as headers and generates pages in the form format, number consecutively. Tested successfully on a 640-record->page dataset. Read the comments at the front of the script for appalling limitations and customization requirements.

Best of luck to those aiming to create a solution integrated into the twiki architecture. It's beyond me, alas.

Jared

-- JaredFreeman - 17 Mar 2006