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 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.

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