- Dec 28, 2004
- 5,581
- 0
- 0
I am currently interning for a company that has a Lotus Notes 6.5 form database that needs to be transitioned to SharePoint. Lotus Notes support has been stopped a couple of years ago but many databases have still not been migrated. The general idea is that I will take the Lotus Notes form, put it into Infopath and then submit it to a document library in SharePoint.
Now, I've hit a couple of issues trying to do this. First, Lotus Notes is not a nice program for compatibility with Microsoft's Office suite. If I extract each form from Lotus Notes, it will be completely jumbled in RTF which is usable once formatting is all fixed but any other method barely reflects the original product. I estimate this will take about 15-30 minutes per form and there are >300 forms. However, HR and my IT administrator wants me to do it "creatively" and automate this process. I've since discovered that there are two methods to do this without buying the Notes Migration to SharePoint program: first using a Web service agent (WSDL) and second using an XML export that Infopath can easily query and use. Here's where the second problem presents itself: Both methods require LotusScript which neither my IT admin nor I know. I have sent an email to the original designer of the database but I don't believe she's with the company any more. What path do I take from here, AT? Is there hope for making this transition semi-automatic or should I just tell HR to either bite the bullet on an expensive program that may or may not work for the database or tell them the only way is the manual way?
Now, I've hit a couple of issues trying to do this. First, Lotus Notes is not a nice program for compatibility with Microsoft's Office suite. If I extract each form from Lotus Notes, it will be completely jumbled in RTF which is usable once formatting is all fixed but any other method barely reflects the original product. I estimate this will take about 15-30 minutes per form and there are >300 forms. However, HR and my IT administrator wants me to do it "creatively" and automate this process. I've since discovered that there are two methods to do this without buying the Notes Migration to SharePoint program: first using a Web service agent (WSDL) and second using an XML export that Infopath can easily query and use. Here's where the second problem presents itself: Both methods require LotusScript which neither my IT admin nor I know. I have sent an email to the original designer of the database but I don't believe she's with the company any more. What path do I take from here, AT? Is there hope for making this transition semi-automatic or should I just tell HR to either bite the bullet on an expensive program that may or may not work for the database or tell them the only way is the manual way?
Facebook
Twitter