Excel Export and Import
This is an alpha version of a potentially dangerous programs
Two programs are provided:
- topics2excel to convert a set of topic into an Excel sheet
- excel2topics to convert an Excel sheet into topics
- WARNING: The
excel2topics script is a very powerful tool. It can overwrite every topic in your web with a new version. Be careful what you are doing with this program.
- You can use this tool to import topics that do not have a form attached to them at all. Just create a Excel sheet with a TEXT and a TOPIC column. The TEXT column contains the raw text of the topic while the TOPIC column contains the topic name.
How it works
- Export by clicking here
- Edit the Excel file
- Attach the Excel file to this topic with the name "IssueExcelExportImport.xls "
- Import by clicking here
- Check for the issues in the IssueTracker
- Set FORM = IssueTrackingForm
- Set DEBUG = 0
- Set TOPICTEXT = TEXT
- Set TOPICCOLUMN = TOPIC
- Set VERTICALCOLWIDTH = 2.66
- Set PAGEWIDTH = 215
- Set DATETIMEFORMAT = yyyymmdd-hh:mm
- Set TEMPLATETOPIC = Template
Format of the exported Excel: