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

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