You are here: CLASSE Wiki>Sandbox Web>IssueTracking>IssueExcelExportImport (11 Jul 2014, admin-wms8)Edit Attach
Tags

Excel Export and Import

This is an alpha version of a potentially dangerous programs

Description

Two programs are provided:
  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

Export Settings

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

Field Meaning Default
Name
Name of the form field
 
edit
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
 
edit
Width
Width of the column
 
edit
Orientation
Vertical
h
edit
Data Type
empty (=text) or date
text
edit

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

Edit  | Attach | Print version | History: r3 < r2 < r1 | Backlinks | View wiki text | Edit wiki text | More topic actions
Topic revision: r3 - 11 Jul 2014, admin-wms8
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding CLASSE Wiki? Send feedback