问题描述:

I have an issue with a new sharepoint install that we've recently deployed to replace an ageing content management system that I implemented a few years ago.

What I'd really like is to save my colleagues as much effort as possible by transferring the content from my CMS into sharepoint.

I'm not very good with sharepoint yet, and my development platform of choice is PHP MySQL, so basically I'm wondering if sharepoint has any facility to import sites, I can easily built filters to reformat the content in my CMS into whatever (please let it be XML) format sharepoint will accept but I have no idea if sharepoint will even let me do this.

I have limited access to the sharepoint server, although in this case I can probably negotiate more if that's the only way.

Mostly I just need some pointers - does sharepoint have any facility to do this, and where do I start doing it?

Thanks

网友答案:

SharePoint has the ability to import data from an Excel spreadsheet (Site Actions > Create > Import Spreadsheet).

The only problem you may run into with this method is that you don't necessarily have full control over what column types the importer uses for your data--if that's important, then it will take some trial and error.

If you're familiar with .NET and you can get access to run a program on the server, you can write a program to import data into existing lists using the SharePoint object model.

网友答案:

the fastest way to bulk import data into SharePoint is through the batchdata method http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spweb.processbatchdata.aspx

it is aimed ad importing list data, but it seems there are some workarounds to make it work with publishing pages http://social.msdn.microsoft.com/Forums/sharepoint/en-US/f8fe190d-c1ed-4e15-bda2-7792211973cc/bulk-publishing-page-creation-using-processbatchdata?forum=sharepointdevelopmentlegacy

网友答案:

An old question but posting an answer to help others.

I faced the same challenge migrating legacy systems.

There is a Codeplex project to address this problem;

difs.codeplex.com

According to project description It is a File / Document / Document Set / List Item / Folder / Wiki Page / Publishing Page / CSV / OleDB / Database / Access / Bulk Import For SharePoint / Office 365 / SharePoint Online / 2010 / 2013 / 2016 / Server / Foundation ) Quickly import large volumes of documents, folders, items into SharePoint document libraries and lists with meta data.

It can use an Excel spreadsheet as import source.

It can use MySQL via ODBC It can be automated / scheduled with Powershell.

网友答案:

For importing bulk data into SharePoint, I would suggest you to try Vyapin's External Data Connector for SharePoint - http://www.vyapin.com/products/sharepoint-integration/external-data-connector

EDC for SharePoint imports any volume of data from various external data sources as given below

  • SharePoint
  • CSV
  • Excel files
  • Mails from Exchange Server / Exchange Online

EDC integrates them into SharePoint Lists and Document Libraries.

Supporting databases

  • SQL Server
  • MS Access
  • Oracle
  • any ODBC compliant database

The product can integrate data into

  • SharePoint 2013
  • SharePoint 2010
  • SharePoint online in Office 365.

I am affiliated with Vyapin Software

相关阅读:
Top