Tag Info

New answers tagged

0

With these size estimates you don't really have anything to worry about. Multiple lines of text fields are stored as NTEXT Sql type columns. This type of columns can store up to 2GB of data. Obviously, it's not advisable to store such a huge amount of data in a single field, but you are way below this limit.


0

I have used code like this successfully SPFolder fldr = web.Folders[strLibraryUrl]; SPFile file = fldr.Files[XMLFileUrl]; XmlDocument xmlDoc = new XmlDocument(); byte[] bites = file.OpenBinary(); Stream strm = new MemoryStream(bites); xmlDoc.Load(strm); // Now you can select nodes, loop, or whatever XmlNodeList nodes = xmlDoc.SelectNodes("Files/File"); ...


0

Try this snippet, from here: string site = "http://servername/sites/TestSite"; using(SPSite spsite = new SPSite(site)) { using(SPWeb spweb = spsite.OpenWeb()) { SPFile file = spweb.GetFile(strFileURL); StreamReader reader = new StreamReader(file.OpenBinaryStream()); XDocument xdoc = XDocument.Parse(reader.ReadToEnd()); ...


0

I found a solution and it's rather simple really... What I had to do: Create a custom view for my list Edit that view to show the Heading and Subheading (it was shown graphically before, but not as "data") Edit the view so it has a really large "limit results" number. I chose 10000 per page for now (otherwise the created xml file doesn't show all data ...


1

Regarding your first question: you can also use PowerShell to accomplish this. Powershell has built in cmdlets to open and process XML and the SharePoint cmdlets will allow you to easily insert this data into a list. This snippet shows how easy it can be: Use the [XML] type accelerator to convert results from Get-Content into an XML document, and then ...


0

There is not a way to do this out of the box. You will need to do this using the API or Web Services. Your code would parse the XML and then create a list with the required columns based off of the nodes in your file. OR you can open the excel file with your xml content,then you can import the same excel sheet to sharepoint list as well. Source



Top 50 recent answers are included