Item8113: Creating topic and dependent-topics during import.

pencil
Priority: Enhancement
Current State: Closed
Released In: n/a
Target Release:
Applies To: Extension
Component: ExcelImportExportPlugin
Branches:
It looks like the Plugin will take data in the Excel sheet and put it into a single Foswiki table.

This is good. I'm interested in making it better.

I'd be interested in extending the plugin to drive multiple Foswiki tables from a single Excel cell range.

This would be used to create from a spreadsheet both topics and its dependent topics where the rows in the spreadsheet are not in normalised form.

This is useful to managers and analysts more used to working entirely with spreadsheets and give backward compatibility to import data from these users.

e.g.

Name Title Phone Type Phone Number
Martin Cleaver Principal Cellphone +1-416-555-5555
Martin Cleaver Principal Homephone +1-416-555-5556

This would drive the creation of one Name record, MartinCleaver, linked to two dependendent phone records, key = MartinCleaver,

MartinCleaver:
Name MartinCleaver
Title Principal

MartinCleaverCellphone
Name MartinCleaver
Phone Type Cellphone
Phone Number +1-416-555-5555

MartinCleaverHomephone
Name MartinCleaver
Phone Type Homephone
Phone Number +1-416-555-5556

Does the goal make sense to you?

-- MartinCleaver - 16 Apr 2009

Hmmmm..... It could have saved about a day's worth of one of my user's time just recently.

Yes, it does make sense.

-- PaulHarvey - 26 Aug 2009

I think this goal is rather unrelated to the ExcelImportExportPlugin. It sounds as if you are trying to turn an excel spreadsheet into a set of tables in normal form?

-- ThomasWeigert - 04 Sep 2010

I am closing this, as I don't think it has anything to do with this plugin and thus am not planning to do this work.

-- ThomasWeigert - 05 Feb 2011

 

ItemTemplate edit

Summary Creating topic and dependent-topics during import.
ReportedBy Foswiki:Main.MartinCleaver
Codebase
SVN Range Foswiki-1.0.0, Thu, 08 Jan 2009, build 1878
AppliesTo Extension
Component ExcelImportExportPlugin
Priority Enhancement
CurrentState Closed
WaitingFor Foswiki:Main.ThomasWeigert, Foswiki:Main.ClausLanghans
Checkins
ReleasedIn n/a
Topic revision: r8 - 05 Feb 2011, ThomasWeigert
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy