Domino Upgrade

VersionSupport end
5.0
6.0
6.5
7.0
Upgrade to 8.5x now!
(see the full Lotus lifcyle) To make your upgrade a success use the Upgrade Cheat Sheet. Contemplating to replace Notes? You have to read this!

Search

Reference

1. Learn XPages online
2. Communicate with IBMers and Lotus Experts using Sametime

About Me

I am the "IBM Collaboration & Productivity Advisor" for IBM Asia Pacific. I'm based in Singapore.
Reach out to me via:
Follow notessensei on Twitter
(posts)
Skype
Sametime
IBM
Facebook
LinkedIn
XING
Amazon Store
Amazon Kindle

Mobile tag

Twitter

Languages

Other languages on request.

Visitors

Useful Tools

Get Firefox
Use OpenDNS
The support for Windows XP is coming to an end and has . Time to consider an alternative to move on. sounds like a lot of time, but, like an object in a mirror, it is closer than you think.

« Securing your CxO's mail file | Main| Who uses Lotus Notes and Domino »

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

Comments

Gravatar Image1 - 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.

Gravatar Image2 - @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.

Gravatar Image3 - I have an answer and even created a movie for you Emoticon

{ Link }

Gravatar Image4 - 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

Gravatar Image5 - I have done this .. nothing that I can just share, but let's chat about it

Post A Comment

Please note: Comments without a valid and working eMail address will be removed. This is my site, so I decide what stays here and what goes.

:-D:-o:-p:-x:-(:-):-\:angry::cool::cry::emb::grin::huh::laugh::rolleyes:;-)

Disclaimer

This site is in no way affiliated, endorsed, sanctioned, supported, nor enlightened by Lotus Software nor IBM Corporation. I may be an employee, but the opinions, theories, facts, etc. presented here are my own and are in now way given in any official capacity. In short, these are my words and this is my site, not IBM's - and don't even begin to think otherwise. (Disclaimer shamelessly plugged from Rocky Oliver)
© 2003 - 2012 Stephan H. Wissel - all rights reserved as listed here: Creative Commons License
Unless otherwise labeled by its originating author, the content found on this site is made available under the terms of an Attribution/NonCommercial/ShareAlike Creative Commons License, with the exception that no rights are granted -- since they are not mine to grant -- in any logo, graphic design, trademarks or trade names of any type.