How do I setup Sharepoint to display Lotus data

5 pts.
Tags:
Lotus Notes
SharePoint 2007
How do I setup Sharepoint to connect and display Lotus data (non-email).

Are there any tools, apps, or training to accomplish this?

I was thinking of utilizing xml but not sure.

Current Lotus skill level is low.

 



Software/Hardware used:
LotusNotes V7. Sharepoint V2007

Answer Wiki

Thanks. We'll let you know when a new response is added.

This should do it: “CREATING A SHAREPOINT LIST, WITH DATA, BASED ON A LOTUS NOTES “VIEW” IN LESS THAN 10 MINUTES” By Gary Devendorf

<a href=”http://www.lotususergroup.org/Submissions.nsf/ContentSpotlight/4E73B79BFEEB2A78862576B1000F7C7B/?OpenDocument”>http://www.lotususergroup.org/Submissions.nsf/ContentSpotlight/4E73B79BFEEB2A78862576B1000F7C7B/?OpenDocument</a>

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Aamir2day
    Step by step demonstration of automated creation of a SharePoint List based on the scheme and data of a Domino web View. The built-in URL commands found in Domino makes it extremely easy. spending a few minutes learning these methods will greatly increase your ability to use Notes/Domino data in a heterogeneous environment. This article shows Notes data copied to SharePoint and migrated back into Notes. In the subsequent articles we will surface, not copy, Domino data in a SharePoint site and link it to non-Notes data. Many Lotus Notes/Domino users suffer from the misperception that it is closed and proprietary just because much of its functionality pre-dated standards. In reality, Lotus Notes' embrace of standards like XML and web services makes it an integrator's dream and the following demonstration proves it. The URLs shown are to a public Domino server so you can try it yourself. However, I recommend you to try it on your Notes databases. At the end of this article I will discuss the advantages and limitations of this method. First let's look at our Notes database in a web browser. Here is a "Web View" of a basic Notes database (Orders.nsf) http://www.msdomino.net/orders.nsf/customer%20orders?openview This URL is actually a "URL command" for the Domino server. Notice the Server name, Database name and View name in the URL. After the "?" the command "openview" is used. (Note: this is a built-in function of a Domino Server with the HTTP task running.) http://www.lotususergroup.org/glug.nsf/201002DevendorgFig1.gif?openImageResource Now we change the "openview" command to the "ReadViewEntries" URL Command to retrieve an XML version of the View. Note The "&count=-1" parameter requests all documents in the View. However, this is still limited to 1000 by a default server setting. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig2.gif?openImageResource This gives us an XML version the data found in the View. For more information on Domino URL commands, look in Lotus Notes help documentation. The default format of ReadViewEntries XML is not easy to work with. We will address this soon. The ReadViewEntries URL gives us a window to our database data as defined by a View. Next we will use this window to pull a snapshot of the data using Access 2007. We start Access 2007 and create an empty database. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig3b.gif?openImageResource Next, in your new blank Access database, on the ribbon under the "External Data" tab, in the "Import" section, select "XML File". http://www.lotususergroup.org/glug.nsf/201002DevendorgFig4.gif?openImageResource A dialog appears asking for the source of the XML. Here we enter the URL for our URL command "ReadViewEntries" and click OK. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig5.gif?openImageResource The wizard imports the data and shows a tree view of the schema which does not contain the data we want. We will need to apply a Transform. Click "Transform..." http://www.lotususergroup.org/glug.nsf/201002DevendorgFig6.jpg?openImageResource The wizard will ask you for the location of an XSLT file. You can download mine here. Put it on your file system then click the "Add..." button and navigate to the XSLT file. Once the file is added, you can select it and click "OK". http://www.lotususergroup.org/glug.nsf/201002DevendorgFig7.jpg?openImageResource This is what my XSLT looks like (I took a transform that created HTML and changed it to create nice XML) http://www.lotususergroup.org/glug.nsf/201002DevendorgFig8.gif?openImageResource Now we have our XML data in a format Access 2007 likes. Click OK. (note: I have used this transform with many technologies not just Access) http://www.lotususergroup.org/glug.nsf/201002DevendorgFig9.jpg?openImageResource You are then prompted to save these import steps http://www.lotususergroup.org/glug.nsf/201002DevendorgFig10.gif?openImageResource Here, just click Close. Now we have an Access 2007 relational database table called "viewentry" with our Notes Data in it. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig11.gif?openImageResource Here you have the opportunity to go into the Database Design and set the Field data types. (i.e. Number, Date, Time, String). This way you can easily cast the data into the desired format. This is not required but is a good way to find bad data. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig12b.gif?openImageResource Finally, with our "viewentry" table selected, we pick "SharePoint List" from the "Export" section of the "External Data" ribbon tab. You are asked for the address of a SharePoint Site to create the new list in. (I like to use my "MySite" URL.) Enter the URL of a SharePoint site and click OK. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig13b.gif?openImageResource By default, the wizard opens the new SharePoint list in a Datasheet View. In the Datasheet View, we can edit, sort, and filter data. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig14b.gif?openImageResource Using the "Actions" menu, pick "show in standard view" to see a standard list view. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig15b.gif?openImageResource Standard View: http://www.lotususergroup.org/glug.nsf/201002DevendorgFig16.gif?openImageResource Here is the list seen in a standard view after configuring the view to show the "Modified By" and "Created By" fields. They are SharePoint built-in fields and the values are set to whoever ran the process. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig17.gif?openImageResource Also a default web form has been automatically created for the orders. http://www.lotususergroup.org/glug.nsf/201002DevendorgFig18.gif?openImageResource To bring this data back to a Notes database, we can save the view as an Excel spreadsheet. Use the "Actions" menu to "Export to Spreadsheet". http://www.lotususergroup.org/glug.nsf/201002DevendorgFig19.gif?openImageResource The result is an Excel spreadsheet: http://www.lotususergroup.org/glug.nsf/201002DevendorgFig20.gif?openImageResource In Excel you can "Save a copy of the document" in "Other Formats". http://www.lotususergroup.org/glug.nsf/201002DevendorgFig21.gif?openImageResource http://www.lotususergroup.org/glug.nsf/201002DevendorgFig22.gif?openImageResource "Text (Tab delimited)(*.txt)" and "CSV (Comma delimited)(*.csv)" formats both should work according to the Lotus Notes help documentation on importing. Let's talk about the value and limitations of this process. It's a great demo to show the openness of Lotus Notes/Domino without doing anything special to the server especially when admins won't let you put any code on their servers. It's a jumpstart in using SharePoint by creating a populated list you can use to try SharePoint reporting, workflow, web UI, linking data, and other services provided by SharePoint. The moved data can be exposed to enterprise wide search, life cycle management, check-in/check-out, sorting/filtering/grouping and more. In any case, it good to know you can do this. However, we are limited by what you can put in a Notes View. Data validation, code logic, audit trail information and form UI are not moved. If you need these things, there are tools available to help you move or recreate them in a SharePoint environment
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following