Item8113: Creating topic and dependent-topics during import.
Priority: Enhancement
Current State: Closed
Released In: n/a
Target Release:
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:
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