wissel.net

Usability - Productivity - Business - The web - Singapore & Twins

Excel to Notes or Quickr?


Question to the readers out there:
Has someone written a tool that allows to take a spreadsheet and turn it into a Quickr place or a Notes database. Of course that spreadsheet would contain a list. The tool would pick up the column headings turn them into field names and generate simple forms and views with the ability to do in-view-editing. I know a number of solutions that import/export spreadsheets but to my knowledge they all require existing forms and/or views. I admit I haven't done an intensive research on that yet.

Feedback very much apprechiated

Posted by on 25 June 2008 | Comments (5) | categories: IBM Notes Lotus Notes

Comments

  1. posted by Bruce Elgort on Thursday 26 June 2008 AD:
    Stephen,

    I don't have anything like this however I have written a Notes apps that converts your entire Notes database into a layer cake. If you want a copy I can send it over.
  2. posted by Edward Lee on Thursday 26 June 2008 AD:
    Hi Steven,

    I've got a modified version of some of Rocky Olivers work that uses DXL to create design elements on the fly if you are interested. If I needed to do what you were doing I would have an existing database that read the spreadsheet to get the field names from the headers, create a new database, then use dxl to transform the column headings into a form, create a standard view and maybe a nice outline etc. I am pretty sure it would work. You have my email so let me know if I can help.

    Ed
  3. posted by John Head on Thursday 26 June 2008 AD:
    I have done this .. nothing that I can just share, but let's chat about it
  4. posted by Carl Tyler on Thursday 26 June 2008 AD:
    I have an answer and even created a movie for you Emoticon smile.gif

    { Link }
  5. posted by Kevin Pettitt on Thursday 26 June 2008 AD:
    @Edward - I have drawn up plans for doing the DXL thing within the context of the SuperNTF framework.
    The nice part about that approach is that I can make the end form look nice out of the gate by slotting the new fields into a "standard" SuperNTF form. Putting labels and fields inside a basic table structure shouldn't be that hard either, nor should adding view columns or a "standard" view along with an outline link.

    I'd love to see what you've done and perhaps discuss working together on building out an integrated solution.