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
DATE_LOGGED	DATE_LOGGED		v	date
DURATION	DURATION		v
FIX_PRIORITY	FIX_PRIORITY		v
LOGGED_BY	LOGGED_BY		v
NEXT_STEPS	NEXT_STEPS
NEXT_UPDATE	NEXT_UPDATE		v	date
NUM	NUM		v
PROBLEM_DETAILS	PROBLEM_DETAILS
REGION	REGION		v
REGION_AFFECTED	REGION_AFFECTED		v
REOC	REOC		v
SERVICE	SERVICE		v
SERVICE	SERVICE		v
SEVERITY	SEVERITY		v
SHORT_DESCRIPTION	SHORT_DESCRIPTION
START	START		v
STATUS	STATUS		v
TEXT	TEXT
TOPIC	TOPIC
TopicClassification	TopicClassification
USERS_AFFECTED	USERS_AFFECTED