IssueExcelExportImport < Sandbox

---+!! Excel Export and Import
%TOC%
*%RED% This is an alpha version of a potentially dangerous programs%ENDCOLOR%*
---++ Description

Two programs are provided:
   1 topics2excel to convert a set of topic into an Excel sheet
   1 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 [[%SCRIPTURL{"topics2excel"}%/%WEB%/%TOPIC%][here]]
   1 Edit the Excel file
   1 Attach the Excel file to this topic with the name "<nop>%UPLOADFILE%"
   1 Import by clicking [[%SCRIPTURL{"excel2topics"}%/%WEB%/%TOPIC%][here]]
   1 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

%EDITTABLE{}%
| *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:
<noautolink>
%EDITTABLE{}%
| *Name* | *Short Name* | *Width* | *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 |  |  |  |
</noautolink>

► Attachments

▼ Attachments

Topic attachments
I	Attachment	Action	Size	Date	Who	Comment
xls	IssueExcelExportImport.xls	manage	114.5 K	2009-03-12 - 17:00	AdminUser	Saved by install script

This topic: Sandbox > IssueTracking? > IssueExcelExportImport
Topic revision: r2 - 2010-02-20 - 15:44:34 - AdminUser

Copyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding STALklubben? Send feedback