Daya Bay Reactor Neutrino Experiment
Sandbox > IssueExcelExportImport (1 vs. 2)
Daya Bay webs: Public | 中文 | Internal | Help   Log In or Register

Users | Groups | Changes | Index | Search | Go
 <<O>>  Difference Topic IssueExcelExportImport (2 - 2015-02-03 - MaQiumei)
Line: 1 to 1
 
META TOPICPARENT name="IssueTracking"

Excel Export and Import


 <<O>>  Difference Topic IssueExcelExportImport (1 - 2006-08-13 - ClausLanghans)
Line: 1 to 1
Added:
>
>
META TOPICPARENT name="IssueTracking"

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  
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 
<-- /editTable -->

Format of the exported Excel:

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       
<-- /editTable -->

META FILEATTACHMENT attr="" comment="" date="1155480798" name="IssueExcelExportImport.xls" path="h:\tmp\IssueExcelExportImport.xls" size="24064" user="ClausLanghans" version="1.1"

View | History: r2 < r1 | More

View | History: r2 < r1 | More
This site is powered by the TWiki collaboration platform Powered by Perl Powered by the TWiki collaboration platform Copyright © by the contributing authors, 2007-2026.
Ideas, requests, problems regarding Daya Bay? Send feedback