Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Excel Services > Is Excel Services the correct direction to go for getting data from Lotus Notes to SharePoint?
Ask a questionAsk a question
Search Forums:
 

AnswerIs Excel Services the correct direction to go for getting data from Lotus Notes to SharePoint?

  • Friday, July 10, 2009 9:00 PMmentalmidget Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    This is the situation:
    We have a "database" in Lotus Notes that records information about contracts.  One of the fields is the path to the contract itself on a network drive.  What we want is a document library with the contract files and relevant fields.  I have a background with .Net but no experience with SharePoint or Notes.  I had the Notes guy export the fields into Excel and imported the file as a new list.  This left me with the data but not the actual files.  I have no idea how to tie the two together.  Then the create list from Excel started kicking out the "An unexpected error has occurred.  Your table cannot be published." message so I can't even do that.  The log files gave no additional info either.

    I then asked a SharePoint consultant the best way to go.  He said to create the document library and then run a Powershell script to read the file and insert the data and contract files into the document library.  So I studied the Powershell info and tried a simple test to see if I could connect.  It failed.  Seems that I have to run the Powershell script on the actual SharePoint Server, which I'm not allowed to do.

    I stumbled on the Excel Services forum.  Now I ask, is it worth researching Excel Services as a possible way to get the data from Excel into a document Library and putting the contract files there from the network too?

    Any knowledge, advice or suggestions related to this task are welcome.  Also, before you suggest it, I have no training budget.

    Thanks!
     

Answers

All Replies

  • Saturday, July 11, 2009 7:09 AMMike Walsh MVPMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    I doubt it.

    Have a quick look at what Excel Services is. It's basically (very basically!) a way for getting extra umph out of Excel spreadsheets especially very large ones. 
    WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
    • Marked As Answer bymentalmidget Thursday, July 16, 2009 8:48 PM
    •  
     
  • Monday, July 13, 2009 9:13 PMDavidLewis27 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    NO way. Excel services is not going to help you out in this manner.  I dont think you are going to be able to do anything with out being able to access the server.  Your best chance to get everything in would be to access central admin (if they allow you to do that off the server).  Create a bdc to tranfer the data over.
    • Marked As Answer bymentalmidget Thursday, July 16, 2009 8:48 PM
    •  
     
  • Tuesday, July 14, 2009 7:37 PMSerge Luca [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    to be honest, one of the best and most popular product for Lotes Migration to Sharepoint  is Tzunami ; this might be less expensive than hiring a consultant :-)
    Serge Luca; blog: http://www.redwood.be
     
  • Thursday, July 16, 2009 8:51 PMSerge Luca [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    the BDC doesn't do the transfer it is just a link. To Transfer you need Tzunami (or write code).

    Serge Luca; blog: http://www.redwood.be
     
  • Saturday, October 31, 2009 4:08 PMrhrempel Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I think that there are two choices.
    1. I would have had the Notes guy create a Notes agent that imports the file into the Notes document. Then migrate all the content (including the file attachment) into the list. Any content migration solution should be able to do this.
    2. Export the Notes content to an XML structure that SharePoint can import. You might need the Notes guy to write the agent to do this. Include an entry for the file path. Then import the XML. I'm thinking that there is a way to have the file imported doing this; but I have not tried it.