Item8113: Creating topic and dependent-topics during import.

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

Commenting is disabled while not logged in