New view export/import formats (*.XLS) 
Use this IdeaSpace to post ideas about the Notes Client.

: 221
: 223
: 2
: export, view
: Hynek Kobelka7940 02 Nov 2007
: / Email

Let us export and import to MS-Excel (*.xls) format.
(Many people don't know what a "Tabular-Text" or „Comma-Separated-File“ is.)
And while you are at it:  
  • Why not also to *.ODF and *.PDF and *.HTML ?
  • Automatically add the proper extension to the file. (The users don't know that WK4 is for Lotus 1-2-3)
  • And it would be nice if we could get access to this export-functions through LotusScript as well
Added on 9.11.2007
There is actually an other stupid bug in the export dialog:
After you open the export-dialog you can actually set the "Save as type"-field which has the default value "Structured text".  If you change this to "Calendar file (.ics)" and enter a file name, then it works fine and you are presented with the next dialog for iCal-Export. However if you select an existing iCal file from the file system,  then the "Save As Type"-field is automatically changed to "Calendar file (.ics)", but if you now continue you are presented with the "Structured text"-dialog. (Even that it looks like that the type has been changed, it is actually not the case and you are still exporting structured texts.)

1) Bill McCuistion56 (05 Nov 2007)
The Lotus Spreadsheet should open/save as a WK1 format. The other day I had some XLS data that I wanted to import into a NSF and was shocked to find that the spreadsheet inside the Notes client couldn't generate a file that could be imported.
2) Ninke Westra2116 (08 Nov 2007)
Either add the option to import odf/excel spreadsheets, or at least add the option to save spreadsheets in 1-2-3 format from the spreadsheet program that's integrated with R8.
3) Kevin Pettitt1036 (14 Nov 2007)
There are some good (and free) tools for importing excel files into Notes. I blogged about them recently: { Link }
4) Dwight Wilbanks121 (24 Nov 2007)
@kevin, I think you've missed the point, The native export for WKS is very fast and pretty good. Except... Lotus WKS format does not work in current business applications (since Excel started concidering it a security risk)

I've written one exporter after another, but, any agent based solution is going to be slower than a native feature. The custom stuff is great when you need formatting, or "pretty" is important, but, for quick and dirty the old way WAS great.
5) Kevin Pettitt1036 (24 Nov 2007)
@Dwight - I agree native is better. I just wanted folks to know about some of the *import* tools out there, which seem far less well-known than the myriad of *export* ones.
6) José Manuel Rodriguez Moreno2615 (30 Nov 2007)
*.xls is a propietary non-standard format. The documentation of this format is not publically available. No way it is worthy to spend a minute on this old and odd format.

Let's concentrate our efforts in an excellent compatibility with the standard ISO OpenDocument format (ISO/IEC 26300).
7) Tinus Riyanto2825 (07 Dec 2007)
I don't really care what the export format is as long as
1. It has a "tabular" format
2. Can handle categorized column and wrapped / truncated text
3. Can export data that is not "displayed" in the view

CSV can handle 2 but not 3, Tabular Text cannot handle 2 and 3, Structure Text failed on 1 so I am stumped.
8) Kerr Rainey4990 (07 Feb 2008)
@7, I think 1 & 3 in your list are mutually exclusive in the general case.
9) Scott Cochrane1847 (03 Sep 2008)
I think native xls and ods export / import support would be excellent. This of course gets political and I think the question of how worth the effort it is could be debated. CSV export is fast and works - if you really need good export capabilities though you ought to look at the tools - the pricing is pretty competitive. I'll vote it up though.
10) David Killingsworth4000 (05 Jan 2009)
I recently had this with a user who had alot of contacts in a spreadsheet and wanted them imported to his contacts view of his personal address book.

After a bit of research I was able to figure out how to do it, but explaining to the process to the user too quite a bit of time and patience. It would have been much easier if it would have worked with a simple excel file instead of the WK1 thing.

Incidentally, I hope everyone knows that they can select documents in a view and then select "Edit/Copy Selected as Table" and then paste that directly into an excel spreadsheet. It works really well and I use it all the time...not sure of any limits though.


Welcome to IdeaJam

You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>

Use more customization features in ND9 NotesMail

IdeaJam developed by

Elguji Software Logo