Ed Brill

Post a Comment

1. 1  Volker Weber http://vowe.net | 4/9/2010 9:10:38 AM

   Are you working on any meaningful way to import/export DATA from Notes databases from and into spreadsheets?

1. 2  Ed Brill http://www.edbrill.com | 4/9/2010 9:12:37 AM
   
   

   You've been able to do that since version 8. In a view, Edit | Copy As | Table and then paste into your spreadsheet. Very cool.

1. 3  Albert Buendía  | 4/9/2010 9:15:52 AM

   Please, hurry up with Symphony 3 gold version and updating the embedded Symphony release in Notes 8.5.1.

   Thanks,

1. 4  Stephen Bailey http://www.converteam.com | 4/9/2010 9:45:31 AM

   Ed - "copy as table" was introduced in 6 I think. It's certainly available in my 7 client. I use it all the time.

1. 5  Carl Tyler http://www.epilio.com | 4/9/2010 9:51:20 AM

   Would be cool to able to do a file import of a CSV, spreadsheet etc. and select field mappings etc. for the import. Kind of like Approach and Organize.

   I find myself often falling back to approach to import data into Notes.

1. 6  Joel M. Phelan http://mikeyblueeyes.blogspot.com/ | 4/9/2010 10:32:51 AM

   Carl,

   I know it's not a simple built-in approach, but you can do this with LotusScript and provide a solution for your clients. There may be other solutions available out there, but check the Sandbox for a basic import csv script you can build on top of.

1. 7  John de Giorgio http://www.integra4notes.com | 4/9/2010 10:42:01 AM

   You guys forgetting Integra or what. We are already exporting Notes docs to Symphony spreadsheets and Symphony mail merges which goes way beyond what the Copy asTable functionality because it does not rely on the data being on the view or even in the same database.

   We have been working very closely with the Symphony Team to make this stuff available. Innvoation Lotus Award etc. :-)

1. 8  Volker Weber http://vowe.net | 4/9/2010 10:57:07 AM

   Ed, I have used copy as table about 10 years ago. It wasn't introduced with 8. Let me just repeat the question:

   Are you working on any meaningful way to import/export DATA from Notes databases from and into spreadsheets?

1. 9  Carl Tyler http://www.epilio.com | 4/9/2010 11:14:51 AM

   @6 Oh I realize that Joel. I was thinking more of an end user that wants to bring their list of contacts into a database, how Notes could do it more easily for the end user.

1. 10  Erik Brooks  | 4/9/2010 11:39:12 AM

   First of all - cool.

   Secondly - Copy Selected As Table was one of the Killer Features in ND6. Usually it rocks.

   However you're limited to how much can be copied at one time, and in very large views it can run *horribly* slow. Try this:

   Open a simple categorized view that has 500,000 docs. If you CSAT the first doc, lightning quick. If you do it with the last doc in the view you'll watch your server CPU peg for a minute or two until you get your one row. I opened a PMR for this awhile back but there was no way for IBM to optimize it better. I *think* they could optimize it now since there are a couple of new internal row-awareness pieces they had to add in 8.5 for XPages, but who knows.

1. 11  Eric Otchet  | 4/9/2010 2:44:20 PM

   Our friend Fabrizio from Frameweb has written a set of Symphony plugin-ins for Notes 8.5.1 and the ability to import/export data is one of the functions .. You can read more about these plugins from Frameweb { Link }

1. 12  Craig Wiseman http://www.Wiseman.La/cpw | 4/9/2010 4:19:22 PM

   @5/@8 Some features are driven by customer demand, some are driven by internal marketing requirements.

   I'm pretty sure there wasn't a group of villagers with torches outside IBM's gates begging for this one.

   But, like webservices in R7 (WS was going to be very useful in getting Domino data into Portal & Workplace), this may be useful in the long run.

1. 13  Darren http://www.dadams.co.uk | 4/9/2010 5:11:36 PM

   @8 - composite applications... live transfer of Notes data into a Symphony spreadsheet, using individual records or multiple selections. See here... { Link }

1. 14  Doug Finner  | 4/9/2010 5:57:39 PM

   The copy as table was introduced in 6.something. It works great unless you need a real data set...I've never figured out the exact limit of data it'll handle but for anything other than a quick look at a small data set, it's not much use.

   Your backups are the Sandbox exports which work great or a third party tool like Intega (which is about as close to awesome as you can get).

   With the advent of something like Office 2003 SP2 or 3, the ability to import wk* files into Excel was killed (some kind of virus security thing...ohhhh scary wk* files). You can restore it with a registry hack but what a pain.

   @8 - I'm with you. Some kind of native report writer/chart generator would be very _very_ nice.

1. 15  Oliver Schulze http://tinymailto.com/oliversl | 4/9/2010 7:04:25 PM

   Nice to se to you use a Mac! Maybe that means we can get a Quickr Connector to that platform, I guess. Notes works great on Mac and the new Symphony beta UI looks good.

   @1 Maybe there is an App for that, err, I mean, an ntf in openntf.org ;)

1. 16  Erik Brooks  | 4/9/2010 7:24:57 PM

   @14 - If only IBM had bought a cool report authoring tool company a few years ago.

   In case you didnt sense the sarcasm, they did - Cognos. Some native integration there could go quite a ways.

1. 17  Ed Brill http://www.edbrill.com | 4/9/2010 8:48:27 PM
   
   

   @16 there are enough open interfaces between Notes/Domino and a reporting tool like Cognos to make things happen. But @14, have you looked at BIRT in the Notes 8.x / Eclipse environment? Bob Balfe ({ Link } ) has blogged plenty about BIRT, as have others.

1. 18  Arne S Nielsen http://www.mynotesblog.com | 4/10/2010 4:17:12 AM

   How did you get Lotus Symphony 3 beta 2 as an integrated app in Lotus 8.5.1 for Mac..?

1. 19  Anthony Holmes http://www.workingcollaboration.com | 4/11/2010 10:03:04 PM

   @18: I didn't bother to install Symphony Beta 2 as an integrated App (I figured it was simpler to keep the beta as a standalone installation). Even though I've installed it separately, I still got the Import options in Notes that Ed mentioned above. So it isn't necessary to do an integrated installation (although there might be other reasons why you would like an integrated install).

1. 20  Alan Lepofsky http://www.alanlepofsky.net | 4/12/2010 9:33:08 PM

   @6 Carl, can't you do that with a .COL file? { Link } It's not exactly "UI-level" field mapping, which would be cool, but you can define the fields and types and then import the data.

1. 21  Alan Lepofsky http://www.alanlepofsky.net | 4/12/2010 9:33:08 PM

   @6 Carl, can't you do that with a .COL file? { Link } It's not exactly "UI-level" field mapping, which would be cool, but you can define the fields and types and then import the data.

1. 22  Bruno Grange http://www.grange.com.br/ | 4/13/2010 2:10:24 PM

   So good to hear! The more we play, more we get from MS, the best.

1. 23  Janko Stefancic http://www.genis.si/janko | 4/14/2010 5:41:54 AM

   Great feature and works perfectly for me. The only issue I have with Symphony 3 beta 2 is dropped support for SmartSuite file types, as a lot of documents in our organization are still in WordPro format... and it won't be in the GA version either:

   Symphony 1.3 features disabled in any Symphony 3 releases

   "Ability to import SmartSuite® files."

1. 24  JP Liggett  | 4/22/2010 3:17:34 PM

   @23 I agree, I have a client that still keeps his smartsuite 97 install disk handy. He's been getting used to symphony, but he MUST be able to open his wordpro files.

   Import/Export tools are very valued items, and can be show-stoppers if not available.

   On the notes side, I've used third party tools, tools from OpenNTF and the sandbox. While some are better than others, there are several tools that work well. The data moving animal from openntf worked well for one of my clients. { Link }