Excel Export and Import

This is an alpha version of a potentially dangerous programs

Description

Two programs are provided:

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.

Field	Meaning	Default
Name	Name of the form field
Short Name	Column header. The Short Name and Name need to be the same if you want to be able to import the exported files without changing the column headers
Width	Width of the column
Orientation	Vertical	h
Data Type	empty (=text) or date	text

Format of the exported Excel:

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

I	Attachment	Action	Size	Date	Who	Comment
xls	IssueExcelExportImport.xls	manage	23.5 K	2006-08-13 - 22:53	UnknownUser

Revision: r1 - 2006-08-13 - 22:55:19 - ClausLanghans
Parents: IssueTracking

	Sandbox > IssueTracking > IssueExcelExportImport	Daya Bay webs: Public \| 中文 \| Internal \| *Help*
			Log In or Register