Problem solve Get help with specific problems with your technologies, process and projects.

Resources for exporting Lotus Notes data to Lotus 1-2-3

I need information or an example about exporting Lotus Notes data to Lotus 1-2-3. Thank you.
You didn't really say anything about the context in which you need to do this export, but I'm assuming that you want to do this in a program, as opposed to just using the menu command File/Export from a view.

The 1-2-3 Export functionality in Notes is not directly available from LotusScript, but in macro language you can use @Command([FileExport]; "1-2-3"; filename) to export information from the current view. The user will be prompted whether to export all documents or only selected documents and whether to include view titles.

If this is not good enough, you can use LotusScript to create an export file. There are two ways to do this (assuming you do not want to have to learn the 1-2-3 file format and write your own code to produce the binary file).

First, if your code is running on a platform that supports OLE automation and has 1-2-3 installed, you can use OLE automation to create a new spreadsheet, set values and formatting for its cells, and save the resulting 123 file. There are numerous examples in the LDD Notes/Domino 4 and 5 forum and the SmartSuite forum that do exactly that.

Alternately, if OLE automation is not an option, you can create a CSV file. This is just text, with any text values enclosed in double quotes (if there are double quotes in the text, change these to double-double quotes (e.g., the string Robert "Big Bob" Malloy becomes "Robert ""Big Bob"" Malloy" in the CSV file). Number and date values are not enclosed in quotes. 1-2-3 can perfectly well understand this file type, though it doesn't allow you to format the cells.

Dig Deeper on Lotus Notes Domino Deployment and Migration Advice

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...