Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We had a scenario where we are having huge data in the form of xml file which is external to sharepoint site so we need to bring that data in xml to sharepoint site and use it for search purpose.Can we create a list using that xml file so that we can do the crawling in our sharepoint site.Please suggest me few ways for this .Thanks in advnace

share|improve this question
1  
whathaveyoutried.com? A simple foreach loop would do the job. Explain what you tried, what you get, error you encountered, etc. –  Steve B Nov 20 '12 at 16:48
add comment

3 Answers

You can try making a BDC Entity for your XML file and make External List for that... You can then use SharePoint Forms as well to manipulate data for your XML

You can deploy the XML file into Layouts folder somewhere and access it from there...

Then you can use Search with your External List or Configure Search for External Content Type

Too much I guess :-), other way could be load the XML file to SQL Server Database and use BCS, External Content Types with SQL Server database... That will be more feasible, as you will get rid of your XML file.. Database is more easily handleable and other advantages like integrity and so on!

Custom BDC Model Example for SQL Server

I hope this helps

share|improve this answer
add comment

I like the BDC route, however if you just want to get the data into SharePoint, use PowerShell to read the XML file and load it into a list.

See http://www.windowsitpro.com/article/powershell-faqs/Q-Can-PowerShell-read-and-parse-XML-files for a quick help on how to read an XML file. Then you could mimic this script, but instead of a Excel/CSV, use your XML file and properties http://davidlozzi.com/2012/02/29/loading-sharepoint-lists-from-excel/

HTH

share|improve this answer
    
Thanks for the suggestions i will try with bcs and powershell scripting will et back if i have any issues..Thanks alot again. –  vik26 Nov 20 '12 at 18:51
add comment

Create a list instance with visual studio and deploy it.

List Instances in SharePoint

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.