My organisation has an old SharePoint2010 website. The employees have used this site to fill a form to subscribe to some courses. Now a new version of this form is created in a new SharePoint2010 website. I'm search for a script to import a csv file to sharePoint List. In My case The old form has been exported into a csv file now i need to import this CSV to the new list using a script. I am searching i don't find nothing yet! Thank you.
3
-
What's the data that you need specifically migrate is it a specific list ??Mohamed El-Qassas MVP– Mohamed El-Qassas MVP ♦2016-11-10 20:57:07 +00:00Commented Nov 10, 2016 at 20:57
-
data stored in the SharePoint List, is the List columns /structure same on source and destination farm.Waqas Sarwar MVP– Waqas Sarwar MVP ♦2016-11-10 21:34:01 +00:00Commented Nov 10, 2016 at 21:34
-
Hi Warqas , thank you for your answer. I have to import all the data that are saved in the old form. All fields on the old form must be imported to the new form.djgibbs– djgibbs2016-11-11 19:31:40 +00:00Commented Nov 11, 2016 at 19:31
Add a comment
|
2 Answers
There are a couple of ways you can do this, provided that you have the same content type in the old list as the new one. If you do, it's fairly straight forward to use PowerShell, to read each item in the old list, and add it to the new list. You would however lose the created by, created, changed by, changed and author column value if you do. But if that's not an issue, you can find numerous of scripts online doing just that.
One would think that this new list was created in the wrong way if you where to keep the old records in the old list. One could build a complementary NewForm.aspx to accommodate the new features. But reading between lines, this isn't the case, unfortunately.
-
1Hi Benny, Your answer makes sense. I will continue my search with your suggestionsdjgibbs– djgibbs2016-11-11 19:34:15 +00:00Commented Nov 11, 2016 at 19:34
-
Hi benny am still stuck with the import. Both Libraries have the same content type. Still can't find a script to do that. Do you have any link for me?djgibbs– djgibbs2016-12-06 15:41:08 +00:00Commented Dec 6, 2016 at 15:41
-
@djgibbs Sure! Check out sharepoint.stackexchange.com/a/76591/63822016-12-07 07:23:38 +00:00Commented Dec 7, 2016 at 7:23
-
Hi thanks for your answer. This option will create a new list. I want to import the items from the old list to an existing one in the new SP Site!djgibbs– djgibbs2016-12-07 14:38:22 +00:00Commented Dec 7, 2016 at 14:38
You can export the list from the old site as a template including the content and then bring it over to the new site. This way you will have your list settings as well as all the content as it was on the old site. I am not sure how this will tie in with the workflow but if the workflow is on the new site as well you should be able to associate it with the new list once you create it.
-
Hi thanks for your answer. This option will create a new list. I want to import the items from the old list to an existing one in the new SP Site!djgibbs– djgibbs2016-12-07 15:52:47 +00:00Commented Dec 7, 2016 at 15:52