This session was predominantly on integrating various Office suites at the software (VBA/scripting level) - how to get information out of Notes and into other applications in various ways. Pushing data from a Notes app out to an application (controlled via COM) was covered, as was pulling data from VBscript or OpenOfiice UNO scripting.
One of the examples shown was how to do a mail merge in Word, but using data from Notes contacts address list as the data source.
At the server side, the general technique was to use a Notes Agent running as a web service either providing SOAP access or presenting data as XML.
XML was the most flexible - once it is available via a URL returning XML, data can be imported or connected into Excel, Word, an ASP web page or presented in Sharepoint.
As an interesting side note, if the data is rendered as a pseudo RSS feed in XML, it can also be brought into Google Docs spreadsheeting tool as well.
Most of the details were fairly low level, so I won't blog about each option in detail but if this is functionality you might need, let me know and I can talk you through it.
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment