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?
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;
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
EDC integrates them into SharePoint Lists and Document Libraries.
The product can integrate data into
I am affiliated with Vyapin Software