Excel Export and Import

Description

1. topics2excel to convert a set of topic into an Excel sheet
2. excel2topics to convert an Excel sheet into topics

topics2excel

excel2topics

• 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

1. Export by clicking here
2. Edit the Excel file
3. Attach the Excel file to this topic with the name "IssueExcelExportImport.xls "
4. Import by clicking here
5. Check for the issues in the IssueTracker

Settings

Common Settings

• Set FORM = IssueTrackingForm
• Set DEBUG = 0
• Set TOPICTEXT = TEXT
• Set TOPICCOLUMN = TOPIC

Import Settings

• Set TOPICPARENT = IssueTracker
• Set UPLOADFILE = IssueExcelExportImport.xls
• Set NEWTOPICTEMPLATE = IssueTemplate

Export Settings

• Set VERTICALCOLWIDTH = 2.66
• Set PAGEWIDTH = 215
• Set DATETIMEFORMAT = yyyymmdd-hh:mm
• Set TEMPLATETOPIC = Template

Name	Short Name	Width	Orientation	Data Type
ACTION_OWNER	ACTION_OWNER		v		edit
DATE_LOGGED	DATE_LOGGED		v	date	edit
DURATION	DURATION		v		edit
FIX_PRIORITY	FIX_PRIORITY		v		edit
LOGGED_BY	LOGGED_BY		v		edit
NEXT_STEPS	NEXT_STEPS				edit
NEXT_UPDATE	NEXT_UPDATE		v	date	edit
NUM	NUM		v		edit
PROBLEM_DETAILS	PROBLEM_DETAILS				edit
REGION	REGION		v		edit
REGION_AFFECTED	REGION_AFFECTED		v		edit
REOC	REOC		v		edit
SERVICE	SERVICE		v		edit
SERVICE	SERVICE		v		edit
SEVERITY	SEVERITY		v		edit
SHORT_DESCRIPTION	SHORT_DESCRIPTION				edit
START	START		v		edit
STATUS	STATUS		v		edit
TEXT	TEXT				edit
TOPIC	TOPIC				edit
TopicClassification	TopicClassification				edit
USERS_AFFECTED	USERS_AFFECTED				edit