Migrate documents with some custom columns to SP Library

Hi Team,

I have a very weird requirement. I am new to programming and do not know of it.
Could you please help me?

My requirement is:-

I have a external system which has lot of documents. It also contains some details related to documents such as date when it was uploaded, ID, document name, etc.

This information is stored in MySQL.

Now my task is to migrate these documents along with its data to our SharePoint library. I am using SharePoint 2013.

Can you please let me know how to achieve this?

One way I think is, export details regarding document into excel and then copy excel info into library. But then how to migrate documents? and how to make sure that proper document is uploaded against proper details of document?

Do I need to do any custom coding? If yes, can you tell me how to do it, since I am not much aware of it.

Please suggest. Your help is highly appreciated.

Thanks & regards,

Manish

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Prasad Pathak11y ago
Hi Friend,

You can use PowerShell or c# console application to achieve this -
1. Write a PowerShell script or c# console application which will read data from MySql DB using the API's, you may need to refer the mySql .net connector DLL which is available.
2. You can add the data in to SharePoint using SharePoint server side API's, REST API from PowerShell or form console application.

Refer -
http://forum.codecall.net/topic/71422-connecting-to-a-mysql-database-in-c/
http://bhism.blogspot.fi/2015/02/c-console-application-to-upload-file-to.html
http://stackoverflow.com/questions/25679808/how-to-upload-a-file-in-sharepoint-2010-using-c-sharp-console
0