Hi how to import/export list from SharePoint 2013 to 2010 with powershell ?
It seems, above mentioned suggestion should works fine in your situation.
However, if you wish to accomplish this task automatically, you may also consider on LepideMigrator for Document tool that too exactly meets to your mentioned requirement and would be a nice alternative approach for you.
## Specify the site URL from where you need to get all the list items $webURL=“http://serverName:46563/sites/MMS”
## Specify the list name from where you need to get the list items
[string]$listName = “List”
## Specify the location where the output xml file GetListItems.xml file has to be generated $outputXmlFilePath=“D:\VijaiPOC\GetListItems.xml”
## $viewName is a string that contains the GUID of the view. If you give empty value it will take the values from default view
[string]$viewName = “”
## $rowLimit is a string that contains number of items to be retreived from the list
[string]$rowLimit = “50”
[String]$viewFieldsValue=“<FieldRef Name=’Title’ />”
[String]$queryValue=“<Where><Gt><FieldRef Name=’ID’/><Value Type=’Number’>3</Value></Gt></Where>”
[String]$queryOptionsValue=“”
#——— Get List Items Function ———-
Function GetListItems()
{
Write–Host –ForegroundColor Green “Please pass the credentials that have access to the site: “$webURL
$credential=Get–Credential
$uri=$webURL+“/_vti_bin/Lists.asmx?wsdl” $listsWebServiceReference = New–WebServiceProxy –Uri
$uri –Credential $credential [System.Xml.XmlDocument]$xmlDoc=New–Object –TypeName System.Xml.XmlDocument [System.Xml.XmlElement]
$query = $xmlDoc.CreateElement(“Query”) [System.Xml.XmlElement]$viewFields =$xmlDoc.CreateElement(“ViewFields”) [System.Xml.XmlElement]$queryOptions =$xmlDoc.CreateElement(“QueryOptions”) $viewFields.InnerXml = $viewFieldsValue $query.InnerXml = $queryValue $queryOptions.InnerXml = $queryOptionsValue [System.Xml.XmlNode]$nodeListItems =$listsWebServiceReference.GetListItems($listName, $viewName, $query, $viewFields, $rowLimit, $queryOptions, $null) $output = New–Object –TypeName System.IO.StreamWriter –ArgumentList $outputXmlFilePath, $false
$output.WriteLine($nodeListItems.Outerxml)
$output.WriteLine()
$output.Dispose()
Write–Host –ForegroundColor Green “Output file is generated in the path: “$outputXmlFilePath }
#——— Calling the Function ———–
GetListItems
