|Steps for creating batch file using search results
Select Export SharePoint List contents using the search option option in SPListX Task Options dialog as shown below and click OK.
The SPListX Task Wizard appears as shown below:
Click Next Button
Specify Search URL Settings
Specify Search Conditions
Click Trial Search button to invoke Trial Search tool. The Trial Search tool will help you perform a live search against the query and help you verify the search results.
The Trial Search Dialog appears as shown below:
Click Save Results button to save the search results.
Click Yes to launch the file.
Click Close button to close the dialog.
Sample Search Result format in CSV
"Title", "Path","Modified Date"
"Purchase","https://vyapin.sharepoint.com/Purchase document/purchase report.xls","2/15/2009"
"Account Report","https://vyapin.sharepoint.com/Purchase document/Account Report.xls","2/15/2009"
Steps to modify the search results.
i) Remove the Columns modified date, title from the file.
ii) Add Destination Path Column and specify the file path.
Sample Batch file format for CSV
“https://vyapin.sharepoint.com/Purchase document/purchase report.xls“,“C:\My Documents”
"https://vyapin.sharepoin.com/Purchase document/marketing.ppt“,“\\vyapinfs\ExportDocs\shared doc contents”
"https://vyapin.sharepoint.com/Purchase document/Account Report.xls“,“C:\My Sales\Lists Backup”
Create a task to Export SharePoint List contents using a batch descriptor file