SiteMap
 The Plain Vanilla Player

editor

the Editor

You need an Editor to be able to:
  1. - display your pvM arrays, taking in account the various properties defined in their M1M data structure
  2. - edit/update the pvM data if necessary (very high priority)
  3. - edit/change the various properties defined in the M1M data structure (editing properties can be later priority)
Unlike John Gregg, and more like you, I believe that this part is not only not trivial, but probably quite difficult to tackle well. But I have ideas.

I can see several approaches for writing this Editor:

  1. a. either, use a grid like the APL+Win grid to display the data and edit them, and design a complete set of Windows forms to allow defining/updating the various M1M properties
  2. b. or, use the best tabular Editor ever written, i.e. Excel to display the data, edit them and indeed simply make the array look like it should look
I think the b. case is interesting: here is how I think it could work:
  1. A. user tells he want to display/edit an M1M
  2. B. M1M is fetched from the data store
  3. C. an object pertaining to the set of objects attached to the Editor, would (1) display the pvM array and (2) use the various properties defined in the M1M to automatically format it, according to these properties (I think I can write such an object)
  4. D. user edits the pvM data if necessary and more importantly, make formatting changes, like grouping headings, or grouping rows and adding subtotals to each section, etc. All this is easy to do in Excel: it is basic Excel formatting tasks in a worksheet
  5. E. user requests to save his changes
  6. F. another object pertaining to the set of objects attached to the Editor,

    would read the Excel sheet content, analyze it and convert the changes (whether made to the actual data or to the formatting) into properties values to be stored in the M1M data structure (this is a bit tricky, but again I think I can write such an object, because I have some ideas on how to do it)

So, if I had to write the Editor, I would select the b. approach. (Carl strongly agrees)

Of course that would mean documenting precisely the various formatting actions allowed to be done by the user in an Excel worksheet and how they relate to each particular M1M property.

horizontal line
What's New Page to home page e-mail