Home

User Manual SPListX for SharePoint

1. Total size processed in KB Shows the total size of files that were exported from SharePoint at any given instance including documents version history and file attachments Total items processed Shows the number of folders and items documents amp list items exported from SharePoint at any given time instance The count does not include version histories and file attachments Elapsed Time Shows the elapsed time from the instance the export task started or commenced Once the export task is complete a new entry will be added in Task History section where you can view the export activity performed when the task ran last 28 2 8 Run a Task from Command Line SPListX command line feature allows the user to instantiate a task from DOS command prompt any time after an export task has been created using SPListX s task wizard To run a SPListX export task from command line 1 Usage SPListX TaskRunner lt task name gt profile user name u user name p password noprompt Where SPListX TaskRunner Task name Profile u p noprompt Name of the SPListX Task Runner application Specify absolute path where the SPListX TaskRunner located For example C Program Files SPListX SPListX TaskRunner Name of the SPListX Task to run from DOS command prompt enclose the task name in double quotes For example Sample Task1 Denotes profile name stored in the current user cont
2. 2 Export Versions By default All versions option is selected Item version settings will be used for each of the list items exported from the list Select any one of the following version settings a All versions Export all list item versions available in the source list b Export version range Export only list item versions specified in the range from the source list e g versions 2 to 5 c Export version date range Export only list item versions by date specified in the range from the source list e g versions date 11 19 2010 15 19 2010 The source list date used for exporting is Modified date of a list item 222 d Export major versions only Export the major list item version from the source e Latest version only Export the latest list item version from the source 3 File Version Handling SPListX Task Wizard Sample Task Step Number Version Options Specify the list item versions to export By default all versions of the list item will be exported Export Versions All versions Export version range Export version date range 20 Feb 12 20 Feb 12 Export major versions only Latest version only Ale Version Handling Libraries only Export each file version to a version folder named as v lt VersionNumber gt Store latest version in root folder Store latest version in the respective version folder Export each file version as separate files named as lt FileN
3. Examples of Export Conditions SPListX exports folders amp files attachments along with metadata to the file system location based on export conditions defined in the export task Export conditions can be constructed using metadata columns and its values A few examples of list conditions are as follows Export Condition Description Exports list items that have server relative URL as Server Relative URL site name subsite name lists list site name subsite name lists list name name For example Server Relative URL vyapin sharepoint lists Product List i e Exports list item and attachments of lists List Name Cities j aa named as Cities E Exports documents from all document libraries List Type Document Library Sart L ype y in the entire web application Exports list items and attachments of all custom lists other than document libraries that are present in the entire web application Base Type lt gt Document Library A few examples of item and folder conditions are as follows Export Condition Description Assuming the date specified by the user is in MM DD YYYY format and with this Modified Date gt 09 09 2010 condition SPListX exports list items that have been modified after 9th September 2009 Exports list items that have been created by John Doe Created By John Doe Assuming the date specified by the user is in MM DD YYYY format
4. Schedule Daily Advar iced Schedule Task Daily Every 1 At 18 32 every day starting 08 05 2012 8 SPListX expects the user must ensure the persistent connectivity status using Web Single Sign on dashboard To check the status click Check session status in Web SSO Dashboard hyperlink 143 SPListX Task Wizard Using this dashboard you can check the connection persistence status of daims enabled SharePoint sites that use federated identity model Enter or select a daims enabled SharePoint site URL and click Connect button If there is no shared credential available for the site you will be prompted for user credentials on demand to make the persistent connection Refer Help document for more information URL Tees Mesure eel Site URL At 18 32 every day starting 08 05 2012 7 Click Finish button to create the task 144 4 Export SharePoint List contents using a batch descriptor file Create task Create Batch Descriptor File Export Option Batch Descriptor File List View Options Version Options Permission Options Export Condition Document Packaging Options Destination Folder Options File Settings Metadata File Settings Task Settings 145 4 1 Create Task Create a task to export folders files along with their list metadata from SharePoint Library to file system or network share based on the entries in the descriptor file SPListX will process the files in the order
5. Order ID Order Transaction ID reference License Type License that was purchased Please allow 12 to 24 hours from the time of purchase for our sales department to process your orders Activate SPListX for SharePoint License Type 30 day Evaluation Copy To activate the software copy and paste the license key in the textbox below License Key Image 1 Activate screen Perform the following steps to activate the software 1 Download evaluation trial copy of software from the respective product page available in our website at http www vyapin com 2 Install the software on the desired computer 3 You will receive a license key through e mail as soon as the purchase process is complete 4 Click Activate in Help gt About gt Activate menu to see the Activate dialog as shown in Image 1 5 Please Copy the license key sent to you through email and pastes it in the License Key textbox For help on how to copy the license key click Click here to see how to copy and paste the license key link in the Activate dialog as shown in Image 2 l Howto copy license key BEGIN LICENSE KEY COPY BELOW THIS LINE 4Select and then Copy the on selected text SGpAghikibs bn Bles5l29s Qg 0 Daz Coty Kiv MS A24g LF OU Yx rw5k UUs I Re Agbu C Howat piogsHGrbs Gy 22k S4U 1409153900 Pto HF Bimet Og Wd LEIS Pg Tub Ht Pus 204k DIALS Regis Let ES Fri STA keie Rotminin Sige WRAPS g0b
6. d Do you want to create the folder underneath when its contents are empty This option creates the folder in the destination location if the source folder contents are empty Select the appropriate option to create the folder by selecting the option Yes No e Do you want to create separate folder for storing file attachments This option creates separate folder for storing file attachments under the specified destination location by selecting the option yes No You can create separate folder for storing file attachments associated with list items The folder file naming option will be useful when list item attachments have the Same name You have the option to select an attachment folder or file naming convention to use when exporting list item attachments The attachment folder will be named based on the folder naming convention specified by the user To select attachment folder naming mask click the button placed next to the attachment folder tag name text box This dialog appears as shown below Attachment folder tag name Specdfy folder name mask for exporting attachments Macro Sample Value ItemID 1 ItemName Cities ListWame Shared Documents 4 Folder Name Attachment_ lt ItemID gt _ lt ItemName gt Cancel Construct attachment folder name with the available mask provided in the dialog Click OK to close the dialog The constructed folder name mask will be placed in attachment folder naming tag t
7. in Control Panel and Format string value available in the registry key HKEY_LOCAL_MACHINE SOFTWARE Microsoft Jet 4 Engines Text The following table shows the equivalent Format string for List Separator in the registry key List Separator Equivalent Format String Semi colon Delimited 3 The first column of all the rows should contain the source URL of the list or folder or file or folder or list item In other words the source path should be either a SharePoint List URL e g http vyapin Shared Documents or sub folder URL within SharePoint List e g http vyapin Shared Documents sample folder1 or file URL within the SharePoint List e g http vyapin shared documents sample folder1 SampleDocument doc or list item URL within the SharePoint List e g http vyapin lists cities 1_ 000 Use wildcard representations and in order to export the list items from the source SharePoint list Please see wildcard characters usage for this purpose Wildcard characters E http sharepoint lists Cities default http sharepoint shared documents http sharepoint lists tasks ER http sharepoint lists custom list Description Exports all items from the source SharePoint list Exports all items and folders from the source SharePoint list Exports list items available in the top level folders only Exports folder structure only NOTE For list items folder tr
8. 2 The About SPListX dialog appears as shown below About SPLIStt SPList for SharePoint Yersion 7 10 Computer Name ras Full Computer Name rd amp 5 voyager local SPList Program Folder C Program Files SPLists Application Data C Users Public Documents SPList Change Copyright 2008 2015 Vyapin Software Systems Private Limited All rights reserved Product Email supporti yyapin com Webs www vvapin com License Type 30 day Evaluation Copy License Description This software is meant solely For evaluation purposes only You can export up to a maximum of 0 5 GB data during the 30 day trial period whichever limit comes First Duration 30 You are on day 1 Remaining Days aq License Agreement Purchase Request license key 3 Click Request License Key button the Request license Key dialog will appear as shown below Request License Key Enter the details below to request a license key to register the product The license key will be delivered to the e mail address stated in this Form Contact Name Compariy Email Phone Count Code Area Code Phone MHo Order ID Full Computer Name dv voyager local License Type ptional e g Single License Site License Contact Name End user of the product Company End user Company Name Email Email address where the license key has to be sent Phone Phone number with country code and area code
9. 53 DocumentLibraryForSharePoint Plane a E D ts Site Assets minn TR 53 Master Page Gallery Site Pages j i Tasklist i MicroFeed Site Assets mMm we ar role Mi H I Gl G Export Location C Users Public Documents SPListX Export O Add to Favorites Documents List items to export Change Export Location Remove g7 Remove All Source Destnaton 4 Select items to export dialog contains a textbox top tree view top left and a list view top right which provides explorer like view to select site collection folder file list item to export The Folder textbox allows you to directly browse the specified folder location in the connected SharePoint list You must specify the folder s relative path and Click the arrow button to mount the specified folder as a root item in the explorer view This option will be very useful if the connected list contains large number of folders and sub folders The search textbox allows you to search for list items for the keyword specified in search textbox Advanced Search Link will be enabled for site that has office search service You will also see a textbox middle and browse button which enables selection of destination location to export folders items 85 Select items to export Select folders list items to export Use Ctrl key to select multiple items Select destination folder location and dick Export button to export ite
10. AN OOTEO 30F Grdbt QHpti sisket Rhy Rvp Pts Lem ke ve B Tes Gyk RAO Onl rsamtg Toon Ej Hbzns O01 Np189AluF PlO2w HVJ eqoomTg 8 G Tage SpMEdsC th dn OO Tan THs Ae fo hid H301 CuT Y R Mt Noky LOSs2bk Y2tP C Pgiy Amdo 1 Igvoqwe rsi Sul Loe JSbbGm O02 JP R9rvmLytlah Gus0pJdp Kgalt LEIS Pt Gs Ott U txbw F Kd P B P Fh U Jp Ex 4go Palo C Opg9 0149F eet Yuh Ron Od Hewhikm A ENO LICENSE KEY COPY ABOVE THIS LINE Image 2 How to copy license key screen 2 SPListX Features Task Manager Change Application Data folder location Create new task Edit an existing task Copy an existing task Delete an existing task Run a task Run a task from command line Create Windows Task Task status Task history Profile Manager Manage favorites Manage categories Active Directory Profile Manager Metadata Format Template File Share Manager Remove a task history item Cleanup history Proxy server settings Web single signon dashboard View activity log 2 1 Task Manager SPListX creates export tasks for export process setup to export documents list items and metadata from SharePoint to file system SPListX Task Manager in the main application window will help you manage SPListX export tasks and their corresponding task history SPListX Task Manager provides menu and tools to work with the tasks easily ee ee al Task View Tools Help a CO J J vag iJ a Li mata Taiere Unlimited New Task Edit Task Copy Task
11. E Contacts H E Cloud Gj Latest Versions C Blank The Show Categories field helps you view only the tasks available in the selected category Show Categories _ All Tasks X Task Name Description Created Modified Total Items Processed Total Data Transferred Settings Metadata export tasks Aerobics Qick here to enter description 6 9 2015 4 39 35 PM 6 9 2015 4 54 50 PM 1 Files 0 Folders 1 25 KB Documents Contents are moved to the Shared Documents 6 9 2015 4 42 08 PM 6 9 2015 4 42 08 PM 197 Files 0 Folders 60 04 MB o Everest 6 9 2015 4 46 42 PM 6 9 2015 4 54 42 PM 1 Files 0 Folders 827 00 B amp Master page gallery 6 9 2015 4 47 56 PM 6 9 2015 4 48 14 PM 3 Files 0 Folders 73 47 KB fo Page Library Images 6 9 2015 4 49 05 PM 6 9 2015 4 54 56 PM 83 Files 0 Folders 5 00B amp Task History Task History pane maintains every task run information as a list It displays the required information about task execution status It displays Task s Start Time End Time Elapsed Time and Remarks 15 Refresh Ey Open Log Folder ty View Activity Log x Remove 09 Jan 12 11 08 07 AM 09 Jan 12 11 08 44 AM 00 00 36 Completed successfully 09 Jan 12 11 06 42 AM 09 Jan 12 11 06 56 AM 00 00 14 Incomplete refer activity log 05 Jan 12 3 08 56 PM 05 Jan 12 3 09 54 PM 00 00 57 Completed successfully 16 2 2 Change Application Data Folder Location SPListX enables you to change Application Data folder location where SPListX
12. Operator Logica operator Value John Doe Property Author John Doe restrictions Search Tuner Trial Search 214 5 You can fine tune the search results by clicking Search Tuner button The Search Tuner dialog appears as shown below Search Tuner By default search will start from current site and its contents Select properties to indude in search query and specify what results to indude Search options Search across all content in the index Search across the current site and all of its subsites Properties Trim duplicate search results Indude stemming results Indude only relevance results Search results Process items only recommended C Process all results Perform keyword search if advanced search is not enabled a Search Options Search across all content in the index SPListX will search for list items content properties across all the content indexed at farm level Search across the current site and all of its sub site By default SPListX will search for list items contents and properties at current site and underneath Current site indicates that site URL specified b Properties Trim duplicate search results This option will remove the duplicate item Urls from search results Include stemming results This option will not include the stemming results If you enable stemming search results will bring back words related to search key
13. Website htto Awww vyapin com Sales Contact sales vyapin com Technical Support support vyapin com Table of Contents 1 SFP EISUX IALFOGUCHOM savcumaiiccsadeneucatiatianeisniiseotecbtamnidanisneisedasctacedavnsiendinasidaevectuanis 2 LLAD PUS XG ccrsacer mien aceuccasace eceuccseeusnacautcenamenmusuetengienawsutecsae ree cunveesnaceureanecu 3 hic OW COUP CNASC aE E EE E A E EA 5 1 4 System FEQUIFEMICNUS 1ceaccecnsandaeinatetetangecdieerntadateasen battectecaussiadatsoatatatantansicenad 7 1 5 How to Register the Software ccc eceeeeeeeeeeececcccccccccccccccccccccccscccccccssssssesegs 8 APE cto 0 ols eee ee ee E ee ee ee ee 12 2 1 TASK MAN AGC veccscsadaseuatesasansaesassasiavatantan antawsesasen aaa aaia 13 2 2 Change Application Data Folder Location cece cece cece eeeeeeeeeeeeeeeeeeeeeeeeeeneas 17 215 GCheace NOW TACK E EIE E E TE TEE EEE EE 19 2 4 Edit an existing task Edit TaSk s ssssssssssnssnsssensssonensonesnnnesnsnnnnsnsnnrnennenrnne 21 2 CODY alt O UN Vas aaan E A E EE AE vere 22 2 6 Delete an existing task ssssssssssssnssnsnsnnsnrnnsnrnnsnronsnrnnennnnesnsnsensnennsnrnnenrnne 24 Ar TO aS aE E E A E 26 250 RUN a Task from Command LINE siisecdvwctch ci steatenawaesheetwodss i akara ai aiae 29 L ree WINDOWS TASK aese e a e e eae a 33 ZIO TASK E S iE EEEE EE EEEE 35 24M Vas FAI COY aee a a a a a a a a a tees 37 212 Proe Manan eeoririerni nrinn EAEE EE 39 Llo E Radea PaVOMUCs a E s
14. a Export each version to a version folder named as This option will create a version folder for each file version based on the version folder name specified in the folder name mask textbox You have the option to export the latest file version to the root folder or export it to the respective version folder i Store latest version in root folder Export the latest file version to the root folder specified by the user To select Version folder name click the button placed next to the export version to as version folder name textbox Version folder name mask dialog appears as shown below Version folder name mask Specify a valid folder name to export latest file version Macro Sample Value ListWame Shared Documents Timestamp 20120220 114541 VersionNumber 1 Folder Name lt VersionNumber gt You can use the available macros to construct the new folder name in the Result textbox 11 Store latest version in the respective version folder This option will create a version folder name based on the current file version and export the file into the version folder b Export each file version as separate files named as Each file version will be exported using the file version name constructed in the file version name mask text box To select Version file name click the button placed next to the export version to a separate file name textbox Version file name mask dialog appears as shown below Version file name
15. sartane s 37 severed Schedule Task Daily Every 1 a day s At 18 32 every day starting 08 05 2012 8 SPListX expects the user must ensure the persistent connectivity status using Web Single Sign on dashboard To check the status click Check session status in Web SSO Dashboard hyperlink SPListX Task Wizard Using this dashboard you can check the connection persistence status of daims enabled SharePoint sites that use federated identity model Enter or select a daims enabled SharePoint site URL and click Connect button If there is no shared credential available for the site you will be prompted for user credentials on demand to make the persistent connection Refer Help document for more information URL Tees Mesure eel Site URL At 18 32 every day starting 08 05 2012 8 Click Finish button to create the task 5 Export SharePoint List contents using the search option Create Task Working with SharePoint Search Results SharePoint 2013 Search Results SharePoint 2010 Search Results SharePoint 2007 Search Results How to create Batch File using Search Results Create Search Batch Descriptor File SharePoint User Credentials Search URL Settings Search Conditions Column Settings Options Version Options Permission Options Export Conditions Document Packaging Options Destination Folder Options File Settings Metadata File Settings Task Settings 203 5 1 Create Task To cr
16. 14 days source list item s modified date value and exports the items that are changed in the last 14 days 248 5 1 9 Document Packaging Options Document Packaging helps in storing related documents contents together in a single file in compressed format SPListX has the provision to export document sets document file versions and file attachments as packaged contents grouped together Follow the steps outlined below to store multiple document versions document sets and file attachments grouped together in the file system file share 1 The Document Packaging Options step appears as shown below SPList Task Wizard Test Search Step Number Document Packaging Options Select packaging option below to compress documents files during the export process Packaging Settings Do not package documents or file attachments C Perform document packaging for ig 2 Select Packaging Settings from the options outlined below a Do not package documents or file attachments SPListX will not package the exported documents or file attachments b Perform document packaging for Document package will be created for each exported document set file version and file attachment based on the option selected below If the file already exists in the package File Settings options will be applied 249 SPList Task Wizard Test Search Step Number Document Packaging Options Select packaging option below to compre
17. 365 Cloud Identity Connects to a SharePoint Online site in Office 365 using the given cloud identity i e Office 365 Online User Credential e g johndoe vyapin onmicrosoft com c Federated Identity Connects to a SharePoint site On premise or SharePoint Online using the federated identity account configured using ADFS Select this option to connect to Office 365 SharePoint Online sites that are configured using federated identity provider 4 Select Add to Favorites checkbox to add the URL to SharePoint Favorites 5 To connect to Office 365 s SharePoint Online site that authenticates users using a trusted identity provider you can select the Federated Identity option and proceed with the login process as shown below Ea SPListX Task Wizard meam Step Number SharePoint URL and credentials Ga Specify a SharePoint URL of a site list folder location from which you wish to export folders files and list hg items to file system User account specified below will be used to connect to SharePoint when running the D export task URL https vyapin sharepoint com sites dev splistx Y Add to Favorites Authentication Federated Identity Aa seeececeeceececaeeeaeeee lt Back J _Next gt cance 5 Upon clicking Next button to proceed you will be prompted for login credentials username and password as shown below 82 K Office 365 Sign in with your organizational account someone example
18. Click Next to Proceed For Latest Version Only option in the Export Versions you have the option to export the latest file version to the root folder or export it to the respective version folder The File Version Handling settings appear as shown below SPListX Task Wizard Sample Task Step Number Version Options Specify the list item versions to export By default all versions of the list item will be exported Export Versions All versions Export version range Export version date range 20 Feb 12 30 Feb 12 Export major versions only Latest version only Ale Version Handling Libraries only Store latest version in root folder 0 Store latest version to a version folder named as v lt VersionNumber gt a Store latest version in root folder Export the latest version in the root folder itself b Store latest version in the respective version folder Creates a latest version folder and export the latest file version in the latest version folder 103 3 1 6 Permission Options SPListX can export SharePoint site list list item permission information to the metadata file This feature works only for SharePoint 2010 or later 1 The Permission options specification wizard step appears as shown below SPList Task Wizard Teso IRI Step 5 of 11 Permission Options SharePoint 2010 or later only Export site list item permission from SharePoint file to the metadata file Do not expo
19. Gallery 5 Browse the source folders and list items of connected SharePoint list and select the required folders and list items from either tree view top left pane or list view top right pane Select a destination location using browse option or enter the destination location path in the textbox and click Add button to export selected items All folders files list items including attachments lists of a site and its sub site can be exported by selecting Site collection node from tree view In SharePoint 2003 all folders files list items including attachments lists of an area and its sub area can be exported to file system 86 Select items to export Select folders list items to export Use Ctrl key to select multiple items Select destination folder location and dick Export button to export items Click Remove button to remove selected items from export Press F5 to refresh treeview Source http ven sp20135 8 vyapin harvester farmadmin Go Advanced Search E gi Vyapin 4 objects selected gt Home Up Add to Favorites 2 Refresh E List Views Y Filter ES Composed Looks ES CustomListVerification DocumentLibraryForSharePoint Documents gH Galaxy EE Master Page Gallery BB Composed Louk alent E CustomlistVerification 5 IEE DocumentLibraryForSharePoint ale ts Documents Ey Site Pages Master Page Gallery Ey Tasklist 53 MicroFeed El Site Assets Pra me Export Location C Users Publi
20. Note Double click on results to launch the URL in your browser ofi gt gt Next Click Save Results button to save the search results in CSV or Excel format 218 Click Close button to close the dialog Step Number Search Conditions This wizard helps you manage the export task settings All of these words Share Point Any of these words The Exact phrase None of these words Result Type Scope Narrow the search Property e maia a ed 0 a Author John Doe Trial Search 8 Click Next to proceed 219 5 1 5 Column Settings Options To selectively export metadata columns from the SharePoint list 1 The Column Settings Options step appears as shown below SPListX Task Wizard Step Number Column Settings Options Specify the SharePoint columns you wish to export By default all user defined SharePoint columns willl be exported Column Settings Do not export columns Export all columns 4 Export all user defined columns ry C Export selected columns lt Type column names here gt Examples Title Description Author 2 Select any one of the following metadata settings gt Do not export columns This option does not export columns gt Export all columns Exports all columns available in the source SharePoint list including SharePoint system columns such as Created Modified Approval Status etc gt Export all user defined columns Exports all colum
21. Number File Settings Use the option below to manage file duplicates in the Windows File System You can also propagate Created Date and Last Modified Date fields from SharePoint Library to the Windows File System If the file with the same name already exists in the destination location Do not overwrite the existing file Overwrite the existing file Rename the new file that is currently exported from SharePoint Alternate File Name Mask lt FileNName gt lt Index gt mm rT You can propagate original created date and last modified date for folders and files from SharePoint library to the NTFS file system In a FAT file system the last modified date alone will be retained from SharePoint library When document packaging option is selected the created date alone will be retained from the SharePoint library J Retain created date 7 Retain modified date Select File System Date Settings The date options given below will assign the respective data field values in the file system as in the original SharePoint list a Retain created date Carry forward propagate Created Date field from the source folders files and list item attachments to the Windows file system b Retain modified date Carry forward propagate Last Modified Date field from the source folders files and list item attachments to the Windows file system NOTE You can propagate original Created Date and Last Modified Date for folders and files to
22. SPListX exports list items created in the month of September 2010 Created Date gt 09 01 2010 AND Created Date lt 09 30 2010 122 Exports list items that have content type as Document Content Type Document Exports list items that have been LMOdIicd ey JONT DOE modified by John Doe The following section describes the data types supported by SharePoint and an example of how to state the export condition ifi _ TESEN Ne Monee SPListX exports list items that have the Document Verified value set to Yes j lt gt R h PERL Ene a SPListX exports only list items that do not have Research as value for Title field Date and Time Created Date gt os 09 01 2010 AND Assuming date specified by the user is in MM DD YYYY format Created Date lt SPListX exports list items created 09 30 2010 in the month of September 2010 P ID gt 1 R mame hice ma Sevier SPListX exports list items that 7 have Product ID value lies in between 10 to 100 Sencaey es a SPListX exports list items that have Product Cost value equal to 100 Choice City New York Text or Number values can be City given for this field The values can be single or multiple Multiple values should be separated by London Paris Singapore SPListX exports the list items that have City column value set as London Paris and Singapore Lo
23. an user profile Domain Name DC Name 3 In order to add user profile click Add button and provide user information in the New Active Directory Profile as shown below Enter domain name and domain controller s name to create edit a AD profile a Domain Name Specify the domain name associated with the SharePoint farm to retrieve the members b DC Name Specify DC Domain Controller Name to connect with the domain to retrieve the group members 52 c Specify a new user profile or select an existing user profile to connect with domain to export members for the domain groups referenced in SharePoint server 4 The newly added user profile will be shown in the Active Directory Profile Manager as below SPListX can store the user credentials to retrieve domain groups member information from Active Directory domain controllers Click Add button to create an user profile Domain Name DC Name User Name ADVENTURE RD49 Adventure Ad Henceforth the stored credential can be used to export Domain Group members from the SharePoint server 5 Click Close button to close the Active Directory Profile Manager dialog Additional References Behavior of stored user names and passwords http support microsoft com kb 281660 Stored User Name and Password Best practices http technet microsoft com en us library cc784749 WS 10 aspx 53 2 16 Metadata Format Template SPListX provides a template to
24. as comma semi colon etc The delimiter character used in the external metadata file Should be same as List Separator defined in locale settings in Regional and Language Options in Control Panel and Format string value available in the registry key HKEY_LOCAL_MACHINE SOFTWARE Microsoft Jet 4 Engines Text The following table shows the equivalent Format string for List Separator in the registry key List Separator Equivalent Format String semi colon Delimited asterisk Delimited 3 The first column of all the rows should contain the source URL of the list or folder or file or folder or list item In other words the source path should be either a SharePoint List URL e g http vyapin Shared Documents or sub folder URL within SharePoint List e g http vyapin Shared Documents sample folder1 or file URL within the SharePoint List e g http vyapin shared documents sample folder1 SampleDocument doc or list item URL within the SharePoint List e g http vyapin lists cities 1_ 000 4 The second column of all the rows should contain the destination folder location e g C My Projects or FileServer My Documents where the exported item is to be stored 206 5 Be consistent with the drive letters and UNC path when exporting folders files and list item attachments from a SharePoint list If you use local mapped drives to export files or list item attachments ensure
25. connect to SharePoint in the Microsoft Windows Stored User Names and Passwords Credential Manager applet for security reasons The stored user profile is tied to the user context currently logged on user account in which the profile is created Hence you will not be allowed to change the scheduled Run As user context for the export task Click Manage Profile button to create new user profile 263 6 As for Web Single Sign on credential based export task the task settings will be Shown as below SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Category C Blank Description Task Option Connect to SharePoint As C Run later This user yYAPINLAB kevin Run now Prompt me for user context at task run time The Web Single Sign on framework expects the user name and password to be given by user interactively in a browser based login dialog Hence the user profile list is not accessible for this type of connection 264 7 As far as scheduled run is concerned SPListX enables you to setup the export task using persistent connection and shared credential as shown below SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Sample Task Office 365 Category C Blank Description Task Option Connect to SharePoint As Run lat
26. credential to connect to SharePoint when running the export task r a Authentication Windows User name vsslab andrew v _ Gjohndoe contoso com contoso johndoe johndoe Password Seeeeseeeseseeeseee cones 2 Specify the Authentication mechanism and credentials to connect to SharePoint using one of the options described below a b c Windows or Forms SPListX will initiate Windows or Forms authentication using the user account information stored in the user profile or the one entered in the textbox Office 365 Cloud Identity Connects to a SharePoint Online site in Office 365 using the given cloud identity i e Office 365 Online User Credential e g johndoe vyapin onmicrosoft com Federated Identity Connects to a SharePoint site On premise or SharePoint Online using the federated identity account configured using ADFS Select this option to connect to Office 365 SharePoint Online sites that are configured using federated identity provider 208 Step Number SharePoint User Credentials Specify user credential to connect to SharePoint when running the export task Authentication Federated Identity v User name vsslab andrew v Pa Gohndoe contoso com contoso johndoe johndoe Password seecccccccccecess 3 Click Next to Proceed 209 5 1 3 Search URL Settings You can specify the URLs to search using a batch file or select the URL using the browse button The UR
27. customize the metadata format when exporting column values to the metadata file SPListX default formats can be customized using this template You are allowed to customize the format of the value from the set of available or possible values for each column type These customized formats will be used by the application when exporting SharePoint column metadata values to the metadata file All SPListX export tasks will use this template to export metadata values to the metadata file which can also be further in each export task 1 Select Metadata Format Template from Tools menu Profile Manager Active Directory Profile Manager File Share Manager Manage Favorites Manage Categories Web Single Sign on Dashboard Proxy Settings Ar Cleanup History iy View Activity Log X Remove Activity Log 54 2 The Metadata Format Template dialog will be shown as below Type Text Note Choice Number Currency Date and Time Lookup Yes No Person or Group Hyperlink or Image Task Outcome External Data Managed Metadata Related Items Geolocation Format Example SPListX Hello World Volley Ball 10 10 00 02 20 13 05 55 55 Document 1 0 10 ken http www vypain com Success Product Term Label http vyapin com documents file 1 doc POINT 40 30 Reset This option resets the selected column type s custom format in the template to the default format of the applic
28. each task 14 5 Task Settings Sample Taskl Ea a http rd21 8001 Prompt me for user context at task run time Export Options Export list contents and metadata Create full destination folder path from the Yes drive letter or lt machine nametshare name gt if it does not exist All items in the List View Allltems aspx Select Columns to export Column Settings Export all user defined columns Export version All versions Export each file version to a version folder 9 v lt VersionNumber gt m The selected tasks can be re categorized by right clicking on a task Show Categories _ All Tasks v Task Name _ Description Created Modified Total Items Processed Total Data Transferred Settings 5 Metadata export tasks Aerobics EE Metadata export tasks 6 9 2015 4 39 35 PM 6 9 2015 4 54 50 PM 1 Files 0 Folders 1 25KB Documents Library Documents to the Shared Documents 6 9 2015 4 42 08 PM 6 9 2015 4 42 08 PM 197 Files 0 Folders 60 04 MB Loi Everest EE View Export 6 9 2015 4 46 42 PM 6 9 2015 4 54 42 PM 1 Files 0 Folders 827 00 B Master page gallery WE All Versions 6 9 2015 4 47 56 PM 6 9 2015 4 48 14 PM 3 Files 0 Folders 73 47 KB Lo Page Library GE Lists 6 9 2015 4 49 05 PM 6 9 2015 4 54 56 PM 83 Files 0 Folders 5 00 B o Library Documents EE important Documents B View Export Wiki a W AllVersions E Contacts Ml lists HM Cloud E E Important Documents P Latest Versions a Wiki C Blank
29. export permissions for Site List List item to the metadata file depending on the user selection Check appropriate checkboxes in Export permission for options 3 Specify the Permission format to use when exporting the permission information for the Site List List item to the metadata file using the options given below a User Role format Exports permission details as User Role e g johndoe Full Control Limited Access johnsmith Read View Only etc b Role User format Exports permission details as Role User e g Full Control johndoe johnsmith Contributor janedoe etc 4 Inheritance status Export the inheritance status of the Site List List item as a separate column field in the metadata file This column field indicate if the permission is Inherited or Unique role assignment at the Site List List item level in SharePoint 5 Membership information This option exports AD informtion and role definition information to separate XML files These XML files are stored in the same location as the metadata files in the name _membershipinformation and _roledefinition The user account that connects to SharePoint must have System Account permission to retrieve respective membership information Similarly the user account specified in Active Directory Profile Manager for each domain must have Domain Admin permission to retrieve respective membership information SPListX will enumerate onl
30. export tasks Cleanup log files Cleanup Stored Profiles created by SPList Profile Manager Uninstall SPList for SharePoint application Click Next to proceed 2 Select required cleanup options as shown below 292 MSD ist for SharePoint Uninstall Were Step 1 of 2 Cleanup Options Cleaning up the information based on your selection f 5 Listx l Cleanup all export tasks and task history information maintained by SPListX induding folders such as Config Temp and Log 4 Cleanup scheduled tasks that are associated with the export tasks Remove all associated scheduled tasks available in Windows Control Panel that are configured to run the export tasks in scheduled manner Ceanup stored user profile s Remove all stored user profiles created using SPList Profile Manager in the current user context Remove all application files and uninstall SPList application from the machine Click Next to proceed 3 Confirm the cleanup and or uninstall process 293 SPList for SharePoint Uninstall Wizard lll s Step 2 of 2 Cleanup Process Cleaning up the information based on your selection SPListz Click Finish button to proceed with the deanup process or dick Cancel button to terminate the uninstall wizard Click Finish to run cleanup and or uninstall process Click Cancel to close the wizard 4 Once the file cleanup process is complete the uninstall wizard w
31. export tasks and related settings activity logs and error logs are stored at any time after installing SPListX software To change the Application Data folder location perform the following steps given below 1 Select About SPListX from Help menu Help About SPListx 2 The About SPListX dialog appears as shown below About SPLIstt SPList for SharePoint version 7 10 Computer Name rds d a Full Computer Name rd 5 voyager local SPList Program Folder C Program FilesSPLists Application Data CiUsers Publicl Documents SPList Copyright 2008 2015 Vyapin Software Systems Private Limited All rights reserved Product Email supportigyyapin com Webs waw vyapin com License Type 30 day Evaluation Copy License Description This software is meant solely For evaluation purposes only You can export up to a maximum of 0 5 GB data during the 30 day trial period whichever limit comes First Duration z0 You are on day 1 Remaining Days 29 License Agreement Purchase Request license key Register Change Close 17 3 Click Change button to change Application Data folder location of SPListX application The Browse for Folder location dialog will appear as shown below MB Desktop gt Sql Libraries a jE Computer D ol Local Disk C gt esq New Volume D gt Ch Network gt BA Control Panel 8 Recycle Bin renn Cao Genet 4 Select a desired folde
32. folder document 1 2 How to purchase You can purchase SPListX for SharePoint online from our website http www vyapin com Please contact our Sales department at sales vyapin com for sales and price related queries 1 3 Technical Support Please send all Technical Support questions to support vyapin com Please send us the following additional information if you are reporting a problem 1 2 3 4 5 6 Versions of SPListX that you are evaluating or you have registered with us Version information could be found in the About Screen and in Help Additional services or resource consuming processes applications like anti virus running in the background on SPListX installed machine as well as the source Microsoft SharePoint Server 2013 2010 Microsoft SharePoint Foundation 2013 2010 MOSS WSS and destination Hardware configuration of the machine where SPListX and Microsoft SharePoint Server 2013 2010 Microsoft SharePoint Foundation 2010 MOSS WSS is installed Service Pack version of Windows Server amp Microsoft SharePoint Server 2013 2010 Microsoft SharePoint Foundation 2013 2010 MOSS WSS running currently Send us the SPListXErrorLog txt available in the common application data path of SPListX e g lt Application Data Folder gt SPListX Log SPListXErrorLog txt SPListX error logs and activity log files ActivityLog txt ActivityErrors txt MetadataErrors txt and S
33. gt to define your query Complex queries can be constructed with the use of left right parenthesis and and logical operators AND and OR 115 site Export Condition Export site if the above condition is satisfied not satisfied SPListX will export the sites that satisfy the export condition or export the sites that do not satisfy the export condition depending on the option selected by the user Export sites if the above conditions are satisfied Sites that satisfy the condition will be marked for export Export sites if the above conditions are not satisfied Sites that do not satisfy the condition will be marked for export b List Level Filters Click List level filter to specify the filter conditions The List Level Filter dialog appears as below 116 Folder Exponm Conditior Specify rule that must be satisfied before exporting item from SharePoint For example you can export folder only when Created By john doe Geld Name es Gee Export list items if the above condition is satisfied not satisfied c You can specify the export conditions by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such lt gt to define your query Complex queries can be constructed with the use of left right parenthesis and and logical operators AND and OR 117 ist Export Conditio Specify rule that mus
34. in which they appear in the batch descriptor file 1 Select Export files and metadata using a batch descriptor file option in SPListX Task Options dialog as shown below and click OK Select a task type for creating a new task A wizard will guide you through steps to create a task based on the selected Task type Export SharePoint List contents using the browse option Create a task to export folders files and list items including attachments along with metadata to the file system by browsing the SharePoint list contents Export SharePoint List contents using a batch descriptor file Create a task to export folders files and list items including attachments along with metadata from SharePoint list to file system based on the entries in the descriptor file Export SharePoint List contents using the search option Create a task to export folders files and list items including attachments along with metadata from SharePoint list to file system based on SharePoint Search results 2 The SPListX Task Wizard appears ey TA SP List she Niza t Step Number Welcome to SPListX Task Wizard This wizard helps you manage the export of SharePoint list contents to the file system along with its associated metadata Export Option Export list contents and metadata Export SharePoint list contents folders files list item attachments and its associated metadata to the local file system or network share Export lis
35. location in the file system This option will export the metadata file in the selected file format into the respective list folder locations where the physical documents files are exported 257 3 4 NOTE Ensure that the user context used to run the SPListX export process has sufficient permissions to create edit and delete folders and files in the specified export path Specify the Metadata file options using the options below e Create a metadata file for each list library This option will export the metadata for the entire list library in a single file f Create metadata file for each list item file This option will export separate metadata file for each list item or file When you select Create a metadata file for each list library option SPListX creates the metadata file using the List name To create a unique metadata file name click the button placed next to the metadata file name textbox Metadata file name dialog appears as shown below Metadata file name Specify metadata file name Macro Sample Value Current Date 201512712 Current DateTime 20151212 1435605 File Index 1 GUID 2a lazbd827a64997b 1507686f55d List Name Shared Documents View Name All Documents File Name lt List Name gt _ lt View Name gt Construct metadata file name with the available built in macros provided in the dialog Click OK to close the dialog The file name will be created in the name format synt
36. of current timestamp in XLSX file 8 You can specify a new metadata custom format based on the column name when generating the metadata file The format specified here overrides the application 137 level template defined in Metadata Format Template tool Also you can specify new column names to use when generating the metadata file in the file system location To use this feature click the Edit button A Customize Metadata Format Dialog appears as shown below C ize M t ustomize etada a Format Enter column name its type and the format to use when exporting its value to the metadata file You can rename the SharePoint column name when exporting it to the metadata file by providing a new header name below Column Name Column Type Format New Header Name Column Name Column Type Format New Header Name Note The column s metadata format entered here will override the format specified in the Metadata Format Template 9 Specify SharePoint column name inthe Column Name i select its type from the available Column Type from combo box Click button to load the available macros Select format from the available macros If you want to rename the SharePoint column name when exporting to the metadata file provide a new name in the New Header Name text box For example a SharePoint column named Area in the source SharePoint list can be customized and renamed as Location when creating the metadata file during the exp
37. on Dashboard Proxy Settings Cleanup History View Activity Log Remove Activity Log Manager To add a user profile dick Add SPListX can store your logon information for SharePoint sites using Microsoft Windows Stored User Names and Passwords applet Credential a f 3 In order to add user profile click Add button and provide user information in the New User Profile as shown below 40 Create a new user profile and store it in Microsoft Windows Stored UserNames and Passwords applet Credential Manager to connect to SharePoint Click OK 4 The newly added user profile will be shown in the Profile Manager as below SPListX can store your logon information for SharePoint sites using Microsoft Windows Stored User Names and Passwords applet Credential Manager To add a user profile click Add Henceforth the stored user profile can be used as credential input in SPListX application in order to connect to the SharePoint environment 5 Click Close button to close the Profile Manager dialog 41 Additional References Behavior of stored user names and passwords http support microsoft com kb 281660 Stored User Name and Password Best practices http technet microsoft com en us library cc784749 WS 10 aspx 42 2 13 Manage Favorites Use this tool to add frequently used SharePoint URL and File System path as favorites Once added to favorites list SPListX will show the rele
38. ran last Examples of invoking an export task from the command prompt C Program Files SPListX gt SPListXTaskRunner mytask1 u voyager administrator p 2az noprompt C Program Files SPListX gt SPListXTaskRunner Sample Task1 u voyager adminuser p 2az amp noprompt C Program Files SPListX gt SPListXTaskRunner Sample Task2 profile voyager adminuser noprompt D gt C Program Files SPListX SPListXTaskRunner Sample Task3 u voyager adminuser p 2az amp noprompt D gt C Program Files SPListX SPListXTaskRunner Sample Task3 u voyager adminuser p 2az amp noprompt 5 For import tasks configured with SharePoint Online sites using Web Single Signon credential only task name has to be provided as input as shown below Other optional parameters except noprompt are ignored for this authentication type C Program Files SPListX gt SPListXTaskRunner Office 365 import noprompt 6 DOS batch file examples gt To execute SPListX task one by one from a batch file C Program Files SPListX SPListXTaskRunner Sample Task1 u johndoe contoso com p test noprompt ou gt C Program Files SPListX SPListXTaskRunner Sample Task2 u voyager adminuser p 2az amp noprompt C Program Files SPListX SPListXTaskRunner Sample Task3 u johndoe contoso com p test noprompt C Program Files SPListX SPListXTaskRunner Sample Task4 profile johnd
39. the folder by selecting the option Yes No e Do you want to create separate folder for storing file attachments This option creates separate folder for storing file attachments under the specified destination location by selecting the option yes No You can create separate folder for storing file attachments associated with list items The folder file naming option will be useful when list item attachments have the same name You have the option to select an attachment folder or file naming convention to use when exporting list item attachments The attachment folder will be named based on the folder naming convention specified by the user To select attachment folder naming mask click the button placed next to the attachment folder tag name text box This dialog appears as shown below Attachment folder tag name Spedfy folder name mask for exporting attachments Macro Sample Value temID 1 Item ame Cites Listame Shared Documents i Folder Name Attachment_ lt ItemID gt _ lt ItemName gt Construct attachment folder name with the available mask provided in the dialog Click OK to close the dialog The constructed folder name mask will be placed in attachment folder naming tag textbox as shown below Attachments will be exported to the resultant folder name mask value 130 SPList Task Wizard FolderHierarchy Step 8 of 11 Destination Folder Options Specify folders settings to use when creating fol
40. the user Task related operations such as Edit Task Copy Task Delete Task and Run Now can be performed based on the selected task in the Task List pane It provides information about task such as Description Created Date Modified Date Total Items Processed Total Data Transferred and Settings for each task The information about category will be displayed on Show Categories The default selection on category list is All Tasks which shows all the created tasks under corresponding category The default category is Blank Show Categories _ All Tasks X Task Name Description Created Modified Metadata export tasks Total Items Processed Total Data Transferred Settings Page Library Images Aerobics Documents Contents are moved to the Shared Documents Everest Master page gallery Library Documents E View Export Hj All Versions Hj Lists E Important Documents Wiki 3 E Contacts E Cloud P Latest Versions C Blank 6 9 2015 4 49 05 PM 6 9 2015 4 39 35 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 47 56 PM 6 9 2015 4 49 05 PM 6 9 2015 4 40 12 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 48 14 PM 83 Files 0 Folders 1Files 0 Folders 197 Files 0 Folders 1 Files 0 Folders 3 Files 0 Folders 5 00 B 1 25 KB 60 04 MB 827 00 B 73 47 KB 292 0 The Settings of the task has been displayed when click the settings image which is at the last column of
41. to been created To run a SPListX export task 1 Select a task from Task List pane instantiate a task anytime after the task has Show Categories All Tasks v 2 Bj Metadata export tasks Page Library Aerobics Documents Everest Master page gallery i Created Images 6 9 2015 4 49 05 PM 6 9 2015 4 39 35 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 47 56 PM Contents are moved to the Shared Documents feat 6 9 2015 4 49 05 PM 6 9 2015 4 40 12 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 48 14 PM Total Items Processed 83 Files 0 Folders 1 Files 0 Folders 197 Files 0 Folders 1 Files 0 Folders 3 Files 0 Folders Total Data Transferred i Settings 5 008 1 25 KB 60 04 MB 827 00 8 73 47 KB E Library Documents View Export E All Versions E Lists E Important Documents Wiki E Contacts E Cloud Hi Latest Versions C Blank amp 2 Click Run Now from SPListX main screen z Run Now Or Select Run Now from Task menu New Task Ctrl N i Edit Task Ctrl E Fy Copy Task Ctrl C fy Delete Task Del F Create Windows Task Run Now Ctrl R Ctrl Q Or Press Ctri R Key 26 Click Yes in Run Now confirmation message box as shown below This action will run the selected task Sample Task Do you wish to proceed 4 The Credential Dialog will appear as shown below The g
42. value and exports those items that are changed in last previous week SPListX checks the source list item s modified 125 Changed Since Last Export using SPListX Changed Last 7 days Changed Last 14 days modified in the last month Exports list items that are modified in the source folder since the last export using SPListX It is based on the last Import date and time value internally maintained for the list item in SPListx Exports list items that are created or Modified Date Changed Since Last Export using SPListX Modified Date Changed Last 7 modified in the last days 7 days Exports list items that are created or Modified Date Changed Last 14 modified in the last days 14 days date value and exports those items that are changed in last previous month SPListX compares the source list item s modified date value with list item s last import date and time maintained by the application and proceeds with the export accordingly SPListX checks the source list item s modified date value and exports the items that are changed in the last 7 days SPListX checks the source list item s modified date value and exports the items that are changed in the last 14 days 126 3 1 8 Document Packaging Options Document Packaging helps in storing related documents contents together in a single file in compressed format SPListX has the pro
43. vyapin Folder Lists TeamList Advanced Search a i vyapin Composed Looks CustomListVerification DocumentLibraryForSharePoint Documents gH Galaxy Master Page Gallery MicroFeed gH orbit gH Planet Site Assets Site Pages 5 objects selected Name Jal Vento launches with six gears P Bluestacks P Dusters Pi Kiwis P Stems M Microbiology P Blackcaps ii Caves Calnarians Mow fin my oo ND g j Created By System Account System Account System Account System Account System Account System Account System Account System Account System Account Created 5 6 2015 2 16 PM 5 6 2015 2 15 PM 5 6 2015 2 15 PM 5 6 2015 2 14PM 5 6 2015 2 14PM 5 6 2015 2 14PM Sh Home E Up qr Add to Favorites 2 Refresh List Views FF Filter e E TaskList TeamList 4 a E Add to Favorites Change Export Location gt X Remove lt Remove All Export Location C Users Public Documents SPList Export Documents List items to export a m Title http fvm sp20 13 8 vyapin Lists TeamList 3_ 000 C Users Public Documents SPListX Export Vento launches with six gears http vm sp2013 8 vyapin Lists TeamList 8_ 000 Users Public Documents SPListx Export Bluestacks http vm sp2013 8 vyapin Lists TeamList 7_ 000 C Users Public Documents SPListX Export Dusters http vm sp2013 8 vyapin Lists TeamList 6_ 000 C Users Public Documents SPListx Export Kiwis http vm sp2013 8 vyapin Lists Tea
44. 2015 448 14PM Total Items Processed 83 Files 0 Folders 1 Files 0 Folders 197 Files 0 Folders 1 Files 0 Folders 3Files 0 Folders Total Data Transferred Settings 3 006 1 25 KB 60 04 MB 827 006 ce te tr tr i 73 478 33 2 If SPListX has enough information about the required Windows Schedule Task the Create Windows Task option will be enabled Select Create Windows Task from Task menu Task E New Task Ctrl N Z Edit Task Ctri E E Copy Task Ctrl C G Delete Task Del Run Now Ctrl R Exit Ctri Q 3 In Create Windows Task dialog specify a Run As account and Password and Click OK to create a new schedule task with the same schedule settings that was previously saved by SPListX Export Task Wizard Create Windows Schedule Task in Windows Task Scheduler and associate it with the export task given below Task Name Sample Task Run As VOYAGER Administrator Password eeeeee x 34 2 10 Task Status To view and manage task status of a selected task 1 Click Task Status from SPListX main screen Or Select Task Status from Tools menu 2 The Task Status dialog appears as shown below View task status for specified number of days Show status for 7 15 Feb 12 5 34 24 PM 15 Feb 12 5 32 43 PM 15 Feb 12 5 30 37 PM 15 Feb 12 5 29 41 PM 15 Feb 12 4 59 09 PM 15 Feb 12 5 35 13 PM 15 Feb 12 5 33 33 PM 15 Feb 12 5 31 17 PM 15 Feb 12 5 30 00 PM 15 F
45. 7 days and Last 14 days By using Changed operator you can filter the list items based on the above mentioned values from SharePoint list For example if you need to migrate list items that are modified in SharePoint today you can specify a export condition as stated below 246 Modified Date Changed Today Operator amp Value Changed Today Changed Yesterday Changed This Week Changed This Month Changed Last Week Description Exports list items that are created or modified in the present day at the time of export in SharePoint Exports list items that are created or modified yesterday at the time of export in SharePoint Exports list items that are created or modified in the current week Exports list items that are created or modified in the current month Exports list items that are created or modified in the last week An Example Modified Date Changed Today Created Date Changed Yesterday Modified Date Changed This Week Modified Date Changed This Month Created Date Changed Last Week Result Remarks SPListX compares the source list item modified date value with the current day at the time of export and exports the list items which are modified on the current day SPListX compares the source list item created date value with yesterday day before at the time of export and migrates the matching list items SPLis
46. Delete Task Run Now Task Status Cleanup History Usage Period i Unlimited usage Stats Show Categories _ All Tasks X Task Name Metadata export tasks Aerobics Documents Everest Master page gallery Page Library Description Qick here to enter description Contents are moved to the Shared Documents Created 6 9 2015 4 39 35 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 47 56 PM 6 9 2015 4 49 05 PM 6 9 2015 4 54 50 PM 6 9 2015 4 42 08 PM 6 9 2015 4 54 42 PM 6 9 2015 4 48 14 PM 6 9 2015 4 54 56 PM Total Items Processed 1 Files 0 Folders 197 Files 0 Folders 1Files 0 Folders 3 Files 0 Folders 83 Files 0 Folders Total Data Transferred Settings 1 25 KB 60 04 MB 827 00 B 73 47 KB 5 00 B Library Documents View Export All Versions Lists Important Documents me Oe Task History Refresh Open Log Folder View Activity Log Remove Start Time Ready SPListX Task Manager contains a standard menu bar and toolbar along with two panes to manage SPListX export task effectively 1 Task List pane 2 Task History pane 13 Standard menu bar and toolbar Standard menu bar and toolbar contain all the commands or actions to work with a SPListX export task Task View Tools Help New Task Edit Task ol od Copy Task Delete Task Run Now Task Status Cleanup History Task List Task List pane contains all export tasks created by
47. GEMEY ASKEd OUCSHONS irera anar A EA EA 286 6 1 Error Messages and Resolution s ssssssssrensnrsrrnrsrrnrsrrnnsnrnnrnrerenrerrnnerrnnrrennr 287 6 2 TROUDISSMOOLING Sixcisensictasensanhosensachaswnd a a ana 290 6 3 HOW tO Uninstal SPLISEX ainiin E A O T veane 291 1 SPListX Introduction About SPListXx How to purchase Technical support System requirements How to Register the software 1 1 About SPListX SPListX for SharePoint SPListX is a powerful application to export document picture library contents and associated metadata and list items including associated file attachments to the Windows File System Export SharePoint libraries folders documents list items version histories metadata and permissions to the desired destination location in the Windows File System SPListX supports all versions of SharePoint 2013 2010 2007 2003 in a single product SPListX works with SharePoint Online in Office 365 Microsoft SharePoint Server 2013 Microsoft SharePoint Foundation 2013 Microsoft SharePoint Server 2010 Microsoft SharePoint Foundation 2010 Microsoft Office SharePoint Server 2007 Windows SharePoint Services 3 0 Microsoft SharePoint Portal Server 2003 and Windows SharePoint Services 2 0 environments gt Export sites lists and document libraries and reduce data losses that might occur from hardware failures power outages or other problems gt Export lists amp document libraries for offline co
48. ListX exports list items that have Product Cost value equal to 100 245 Choice People or Group City York City London Paris Singapore Product Code 100 Product Code 123ABC 154XYZ Document Reviewed by John Doe Document Reviewed by John Doe Jane Doe Incremental export in SPListX Text or Number values can be given for this field The values can be single or multiple Multiple values should be separated by SPListX exports the list items that have City column value set as London Paris and Singapore The values can be single or multiple Multiple values Should be separated by SPListX exports the list items that have 123ABC and 154XYZ as value for Product Code field User or group values can be given for this field The values can be single or multiple Multiple values Should be separated by SPListX exports the list items that have Document Reviewed by value set to John Doe and Jane Doe Apart from relational operators SPListX allows you to construct flexible export conditions by using the Changed operator for periodic import for the fields Created Date SharePoint and Modified Date SharePoint The following built in values can be used for this operator Today Yesterday This Week This Month Last Week Last Month Since Last Update in SharePoint Since Last Export in SPListX Last
49. Log Viewer oS View task statistics task results detailed file results and Errors Use up down arrow key buttons to view previous or next task activity history Task Name Sample Task Source User _ken vyapin onmicrosoft com Start Time 17 Dec 12 11 24 24 AM EndTime 17 Dec 12 11 25 19 AM Elapsed Time 00 00 54 Remarks Completed successfully Task Statistics Task Results Items Ignored Files Overwritten Errors All Results List Settings Task Settings Resolution Tips The table below summarizes the task export summary statistics and detailed statistics for each list Property Summary Statistics Source statistics Number of lists processed Number of folders processed Number of items processed Number of item versions processed Total size of files processed Total errors Export statistics Total folders created Total files exported induding attachments Total versions exported Total files overwritten Total items ignored nduding attachments Total exported size 4 The activity log of a task is classified into nine different categories seen under separate tabs a Task Statistics Summarizes the manage task summary statistics and detailed statistics for each SharePoint list b Task Results Summarizes detailed result of each task level check c Items Ignored Summarizes the items ignored during export process based on certain conditions d Files Overw
50. Ls to search narrow down the search results For each searched URL you can export to a different export location if necessary 1 The Search URL Settings step appears as shown below SPListX Task Wizard Step Number Search URL Settings Enter or select the URLs to search site list and specify the file system location to export the results URL to search Export Location Click the cell or press F2 to edit 2 Enter or browse the URLs to search in the Search Url textbox Click Search Url button to browse a SharePoint location Specify a valid SharePoint URL in the URL textbox and Click Go button SPListX will load the tree view of the source location as show below Select a Site or List Url from the tree view and click OK 210 Search Uri http rd90 8000 gil Flora E Announcements gH basic Eal Calendar 53 Content type publishing error log 53 Converted Forms 53 Customized Reports 53 Form Templates 5 Links 53 List Template Gallery 53 Master Page Gallery 53 Reporting Metadata 53 Reporting Templates 53 Shared Documents Site Assets 53 Site Pages Pr Calihan Mallaess 3 Specify a valid file system location to export the search results and then click ADD button to add the items to the search list Step Number Search URL Settings Enter or select the URLs to search site list and specify the file system location to export the results http rd90 8000 C Users
51. PlistXErrorLog txt stored in the Common application data path For example lt Application Data Folder gt SPListX TaskHistory lt taskname gt lt timestamp gt NOTE lt Application Data Folder gt is the common location where SPListX tasks and task history is stored in the computer running SPListX application The lt Application Data Folder gt can be found from the Help gt About screen The default path of lt Application Data Folder gt is as follows a Windows Server 2003 C Documents and Settings All Users Documents b Windows 8 7 Windows Server 2012 2008 C Users Public Documents 1 4 System requirements Hardware Intel Pentium processor 10 MB disk space to install SPListX Software Windows 8 7 or Windows Server 2012 2008 2003 with the latest service packs and NET Framework 4 5 or higher To work with SharePoint Online in Office 365 Windows 8 7 or Windows Server 2012 2008 R2 with the latest service packs and NET Framework 4 5 or higher is recommended 1 5 How to Register the Software Once you purchase the software online or through any one of our resellers you will receive a sale notification through e mail from our sales department We will send you an e mail with the necessary instructions to activate the software Alternately you can request the product license key by filling up the form shown in the steps given below 1 Select About SPListX from Help menu About SPLista
52. Public Documents SPListX Export Click the cell or press F2 to edit sed teers erst eganeet 4 Click Next to Proceed 211 5 1 4 Search Conditions SPListX will search for list items in SharePoint list based on search conditions The conditions can be created using SharePoint Managed properties 1 The Search Conditions step appears as shown below Step Number Search Conditions This wizard helps you manage the export task settings All of these words Any of these words The Exact phrase None of these words Resut Type Scope Narrow the search Property Value Erish 2 Define search keywords in appropriate textboxes to search for the content indexed at Farm level For example search for the keyword SharePoint in The Exact Phrase text box 212 Step Number Search Conditions This wizard helps you manage the export task settings All of these words SharePoint Any of these words Document The Exact phrase Welcome to SharePoint None of these words Sun Result Type Scope Narrow the search Property es J Operator Loo Logical operator And Or Add x A Girish Result Type Result Type will narrow down the search results By default SPListX will search for all list items of all list types For ex if you want to narrow down your search results only for documents select All Documents type in result type Scope Scopes w
53. SharePoint List to file system or network share The export task enables users to select the export options in order to specify his requirements A Export list contents and metadata Export SharePoint list contents folders files list item attachments and its associated metadata to the local file system or network share B Export list contents physical files only Export SharePoint list contents folders files list item attachments to the local file system or network share Metadata will not be exported C Export metadata only Export metadata for SharePoint list contents to the local file system or network share Physical files or attachment files will not be exported 1 The Export Options step appears as shown below Tie L tare 15 LC e Step Number Welcome to SPListX Task Wizard This wizard helps you manage the export of SharePoint list contents to the file system along with its associated metadata Export Option Export list contents and metadata Export SharePoint list contents folders files list item attachments and its associated metadata to the local file system or network share Export list contents physical files only Export SharePoint list contents folders files list item attachments to the local file system or network share Metadata will not be exported Export metadata only Export metadata for SharePoint list items to the local file system or network share Physical files o
54. Specify the column name in Name textbox and select the data type of the column in SharePoint from Type drop down Click Add button to add the columns to the fieldname dropdown list Click Remove button to remove the columns from the fieldname dropdown list You can specify the export conditions by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such lt gt to define your query Complex queries can be constructed with the use of left right parenthesis and and logical operators AND and OR 120 Folder Export Condition Specify rule that must be satisfied before exporting item from SharePoint For example you can export folder only when Created By john doe anne Ga A Y 01 Jan 12 Ev KD lella Created Date lt 01 Jan 12 Export list items if the above condition is satisfied C not satisfied h SPListX will export the folders that satisfy the export condition or export the folders that do not satisfy the export condition depending on the option selected by the user e Export list items if the above conditions are satisfied Folders that satisfy the condition will be marked for export e Export list items if the above conditions are not satisfied Folders that do not satisfy the condition will be marked for export i File or Item Level Filters Same as Folder Level Filters 3 Click Next to proceed 121
55. Store latest version in root folder Export the latest file version to the root folder specified by the user To select Version folder name click the button placed next to the export version to as version folder name textbox 101 Version folder name mask dialog appears as shown below Version folder name mask Specify a valid folder name to export latest file version Macro Sample Value ListName Shared Documents Timestam 20120220 114541 1 Folder Name lt VersionNumber gt You can use the available macros to construct the new folder name in the Result textbox i11 Store latest version in the respective version folder This option will create a version folder name based on the current file version and export the file into the version folder b Export each file version as separate files named as Each file version will be exported using the file version name constructed in the file version name mask text box To select Version file name click the button placed next to the export version to a separate file name textbox Version file name mask dialog appears as shown below Version file name mask Specify file name to export versions Macro Sample Value FileName TestDocument ListWame Shared Documents Timestamp 20120220 114607 VersionNumber 1 File Name lt FileName gt _v lt VersionNumber gt 102 You can use the available macros to construct the new file name in the Result textbox 4
56. The new metadata will be shown in the new sheet with the name of current timestamp in XLSX file 8 You can specify a new metadata custom format based on the column name when generating the metadata file The format specified here overrides the application level template defined in Metadata Format Template tool Also you can specify new column names to use when generating the metadata file in the file system location To use this feature click the Edit button A Customize Metadata Format Dialog appears as shown below i t Customize Metada a Format Enter column name its type and the format to use when exporting its value to the metadata file You can rename the SharePoint column name when exporting it to the metadata file by providing a new header name below Column Name Column Type Format New Header Name Column Name Column Type Format New Header Name Note The column s metadata format entered here will override the format specified in the Metadata Format Template 9 Specify SharePoint column name inthe Column Name i select its type from the available Column Type from combo box Click button to load the available macros Select format from the available macros If you want to rename the SharePoint column name when exporting to the metadata file provide a new name in the New Header Name text box For example a SharePoint column named Area in the source SharePoint list can be customized and renamed as Loca
57. User Manual SPListX for SharePoint SPList amp for SharePoint SPListx Copyright 2008 2015 Vyapin Software Systems Private Limited All rights reserved Email support vyapin com Web www vyapin com Last Updated December 2015 Copyright 2008 2015 Vyapin Software Systems Private Ltd All rights reserved This document is being furnished by Vyapin Software Systems Private Ltd for information purposes only to licensed users of the SPListX for SharePoint software product and is furnished on an AS IS basis that is without any warranties whatsoever express or implied SPListX for SharePoint is a trademark of Vyapin Software Systems Private Ltd Information in this document is subject to change without notice and does not represent any commitment on the part of Vyapin Software Systems Private Ltd The software described in this document is furnished under a license agreement The software may be used only in accordance with the terms of that license agreement It is against the law to copy or use the software except as specifically allowed in that license No part of this document may be reproduced or retransmitted in any form or by any means whether electronically or mechanically including but not limited to the way of photocopying recording or information recording and retrieval systems without the express written permission of Vyapin Software Systems Private Ltd jis CAVYAPIN Vyapin Software Systems Private Limited
58. Windows scheduled task SPListX will create a schedule task in the Windows Scheduled Tasks applet with the stated settings SPListX will perform the export based on the Run As user account specified in this export wizard step The Run As account should be a valid Windows domain account SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Sample Task Category C Blank Description Task Option Connect to SharePoint As Run later This user VYAPINLAB kevin Run now Use Run As user context given below Schedule Schedule Settings Run As VYAPINLAB Administrator Schedule Daily ss Start time 18 32 Schedule Task Daily Every 1 day s At 18 32 every day starting 08 05 2012 In scheduled export process SPListX allows the user to enter different user credentials to connect to SharePoint and to create a scheduled export task unattended mode By default SPListX will use the user account specified in the scheduled Run As user context to connect to SharePoint In case if you decide to use different user context to connect to SharePoint when running the scheduled task you can do so by storing the SharePoint user context for future use SPListX will store the user credential to connect to SharePoint in the Microsoft Windows Stored User Names and Passwords Credential Manager applet for security reason
59. Yes No Email ID Item Name Term set hierarchy Item Name Address The specified formats in the template will be used when exporting the metadata values in all the export tasks If the format is not specified for some reason or if the syntax is incorrect the default format will be used for exporting the metadata values to the metadata file as mentioned in the Format Example column 5 Click Close button to save the applied changes 57 2 17 File Share Manager Use this tool to create a file share user profile to retrieve the contents from File Shares which are added in the search content source These user credentials are used to access the file share source which are added in the search crawl index and to export the file share contents to the target location These user profiles are stored securely in Windows Stored User Names and Passwords Credential Manager SPListX stores the file share user profile in the local computer and will be accessible only by the user who creates the user profile If the user who creates the file share user profile has a Roaming user account in the enterprise the stored user profile can be accessed in any computer in the Windows enterprise The stored file share user profile can be used by SPListX application only The credential information is stored securely in 256 bit encrypted format in Windows Stored User Names and Passwords Credential Manager 1 Select File Share Manager from Tools m
60. a task to Export SharePoint List contents using a batch descriptor file 284 6 References Frequently Asked Questions Error Messages and Resolution Troubleshooting How to uninstall SPListX 285 6 1 Frequently Asked Questions For Frequently Asked Questions please click here 286 6 1 Error Messages and Resolution Resolution Tips You may notice one or more of the error messages given below when using SPListX to connect to SharePoint and perform an export This is not an exhaustive compilation of all error messages but an attempt to include as many Known error messages and how to resolve the errors Please refer Troubleshooting section for more information Error Message The remote server returned an error 407 Proxy Authentication Required Unable to establish existence of the account specified Source folder or file not found Unable to locate list with the specified URL Unable to locate destination folder with the specified path The file is checked out or locked for editing by user The Microsoft Jet database engine cannot open the file lt file name gt It is already opened exclusively by another user or you need permission to view its data Enable the Bypass proxy server for local addresses option available at LAN Settings of Internet Options of Internet Explorer Browser The user account specified in the scheduled task should be a trusted domain user account Ensure that the given S
61. ackaging Settings C Do not package documents or file attachments Perform document packaging for Document sets stores multiple documents in a single compressed file Libraries only O Documents and its versions stores documents and its versions based on version export option in a single compressed file Libraries only _ File attachments stores each list item s attachments in a single compressed file Lists only i Document sets This option will package all files stored in the document sets into a single compressed file The package is created in the same name as the document set ii Documents and its versions This option will package the documents and its associated versions into a single compressed file The package is created in the same name as original document or file The document s versions are exported into the created package based on the settings specified in Versions Settings wizard step iii File Attachments This option will package each list item s attachment s into a single compressed file The compressed package is created in the name of listitem ID 3 Click Next to Proceed to the Next Step 4 1 9 Destination Folder Options SPListX will create destination folders based on the following options given below 1 The Destination Folder options specification wizard step appears as shown below SPList Task Wizard FolderHierarchy Step 8 of 11 Destination Folder Options Specify fold
62. age Library Images 6 9 2015 4 49 05PM 6 6 20154 49 05PM 83 Fles 0 Folders 5 008 Aerobics 6 9 2015 4 39 35PM 6 9 2015 4 40 12PM 1Fles 0 Folders L254 Documents Contents are moved to the Shared Documents 6 9 2015 4 42 08 PM 6 9 20154 42 08PM 197 Files 0 Folders 60 04 MB Everest 6 9 2015 4 46 42PM 6 9 2015 4 46 42PM 1 Files 0 Folders 827 00 B Master page gallery 6 9 2015 4 47 56PM 6 9 2015 4 48 14PM Files 0 Folders 73 47 KB E C Library Documents a View Export a E AllVersions E lists E important Documents a Wk E Contacts a E Cloud Ei Latest Versions C Blank 2 Click Copy Task from SPListX main screen Copy Task Or Select Copy Task from Task menu New Task Ctrl N PI Edit Task Ctrl E Copy Task Ctrl C h Delete Task Del Create Windows Task G Run Now Ctrl R Exit Ctri Q 3 In Copy Task dialog enter a new task name in Save As text box specify a Run As account and Password if applicable and Click OK to create a new task with the same export settings specified in the selected task oor lacy wp oe ie l z Copy a task and its export settings Enter a unique name for the task Sample Task Sample Task Copy VOYAGER Administrator 23 2 6 Delete an existing task To delete a SPListX export task 1 Select a task from Task List pane Show Categories _ All Tasks v Task Name B a 6 M Me
63. ager to connect to the proxy server and request authorization to connect to the resource To add a new user profile click iain button 5 Click Close button to close the Proxy Server Settings dialog 67 2 21 Web Single Sign on Dashboard Web Single Sign on Dashboard helps you verify the connectivity status for a claimsenabled SharePoint site The persistent connection ensures that SPListX can execute the export task in unattended mode or scheduled mode using the already established connection for the SharePoint site SPListX uses Web Single Sign on framework to eliminate providing username and password to connect to SharePoint as long as the connection is already available for the site Shared Credential A Shared Credential is nothing but a credential that can be accessed by any claimaware applications such as Internet Explorer SPListX etc The shared credential is a combination of user name and password stored used in a secured manner within the current Windows user profile You can create the shared credential by selecting Keep me signed in option in the login dialog If the shared credential is already available in the current Windows user profile Web Single Sign on uses this credential to access the SharePoint site unless the cookie is deleted The Shared Credential will be very useful when you are trying to perform the following export tasks in scheduled manner using SPListx gt Exporting contents using Federated Aut
64. ame 136 Specify metadata file name Macro Sample Value File Extension ttt Current Date 20151212 Current DateTime 20151212 143333 SUID 2a lazbd827a64997b 1507686f55d Item ID 1 Item Name File Name List of features in SPList List Name Shared Documents Title SPList Feature List View Name All Documents Extension if applicable File Name lt Item Name File Name gt _ lt View Name gt Construct metadata file name with the available built in macros provided in the dialog Click OK to close the dialog The file name will be created in the name format syntax entered in the dialog Note ViewName macro is applicable only for View based export SPListX will substitute the name of the processed view wherever applicable In view based export For list library entries and for files folders within them it appends the view name For file folder entries provided for export it appends All Items instead of the view name e g List of features in SPListX_All Items xlsx 6 Specify the Metadata file format using the options below CSV XSLX XML XML with DTD a0 09 7 If the metadata file already exists in the destination location choose from any one of the following options a Overwrite This option will overwrite the existing metadata file b Append This option will append the new metadata to the existing metadata file The new metadata will be shown in the new sheet with the name
65. ame gt _v lt VersionNumber gt lt Back net gt Select any one of the following export options a Export each version to a version folder named as This option will create a version folder for each file version based on the version folder name specified in the folder name mask textbox You have the option to export the latest file version to the root folder or export it to the respective version folder I Store latest version in root folder Export the latest file version to the root folder specified by the user To select Version folder name click the button placed next to the export version to as version folder name textbox Version folder name mask dialog appears as shown below 223 Specify a valid folder name to export latest file version Sample Value Shared Documents 20120220 114541 You can use the available macros to construct the new folder name in the Result textbox il Store latest version in the respective version folder This option will create a version folder name based on the current file version and export the file into the version folder b Export each file version as separate files named as Each file version will be exported using the file version name constructed in the file version name mask text box To select Version file name click the button placed next to the export version to a separate file name textbox Version file name mask dialog appears as shown below Specify f
66. an use mathematical operators such as lt gt to define your query Complex queries can be constructed with the use of logical operators AND and OR Click to add multiple filters Click to remove the filter from the filter list Click Clear to remove all the filters specified 112 File or Item Level Filter OO i Specify condition to apply at the file or item level induding custom metadata For example you can export files or items when Company Name Contoso Field Type Operator SPListX will export the folders that satisfy the export condition depending on the option selected by the user 113 ADVANCED SPList Task Wizard Step 6 of 11 Export Conditions Specify export conditions for site list folders and or file to filter the contents You can specify export conditions at three levels Site Level Filter List Level Filter Folder Level Filter File or Item Level Filter a Site Level Filter Click Site level filter to specify the conditions The Site Export Conditions Dialog appears as shown below 114 Site Export Condition Specify rule that must be satisfied before exporting site from SharePoint Field Name Export site if the above condition is satisfied not satisfied You can specify the export conditions by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such lt
67. and list item attachments to the Windows file system NOTE You can propagate original Created Date and Last Modified Date for folders and files to the NTFS file system In a FAT file system the Last Modified Date alone will be retained as in source 3 Click Next to Proceed 256 5 1 12 Metadata File Settings SPListX will create metadata files based on the following options given below 1 The Metadata File Settings step appears as shown below Step 10 of 11 Metadata File Settings Specify destination path to store metadata file and export file format CSV XLSX XML Store metadata file s in this location C Users Public Documents SPList Export O Store metadata file s in the respective list library folder location in the file system Metadata file options Create a metadata file for each list ibrary Create metadata file for each list item file Metadata fle name lt ListName gt Fie Format If file already exists Overwrite metadata file Append metadata to current file Metadata Format Optional Column Name Column Type Format New Column Name Customize 2 Specify the Metadata filename amp location using the options below a Store metadata file s in this location Specify a folder path where the selected list items metadata are to be exported You can also Click browse button to launch folder browser dialog b Store metadata file s in the respective list library folder
68. archy This option creates a folder in the file system based on the column value of the column specified under New folder name textbox e g Title as shown in screenshot below The list items documents will be exported to the respective folders based on the column value of the column in New folder name textbox In case the column value is empty the list items documents will be exported to the folder named Blank Export Options Spedfy folders settings to use when reading the contents from source list folder and folder contents sub folders and items to export to file system Export all folders and documents list items Export documents list items at the top level Exdude sub folders Export folder hierarchy Excdude documents list items Export all documents list items Exclude folder structure Store cdassify items based on new folder hierarchy New folder name Tittel 0c genet 95 Use LJ button to edit the export options for sites that are to be exported to the file system Export Options dialog appears as shown below Specify site settings to use when exporting a site and its sub sites Export all sites and sub sites O Export top level site only O Export all subsites exclude top level site Select any one of the following options given below to specify the contents to be exported from the source site in SharePoint a Export all sites and its sub sites This option exports all t
69. as follows Export Condition Description 244 Modified Date gt Assuming the date specified by the user is in 09 09 2010 MM DD YYYY format and with this condition SPListX exports list items that have been modified after 9th September 2009 Created By John Doe Exports list items that have been created by John Doe Created Date gt 09 01 2010 AND Assuming the date specified by the user is in Created Date lt MM DD YYYY format SPListX exports list items 09 30 2010 created in the month of September 2010 Content Type Exports list items that have content type as Document Document Modified By John Doe Exports list items that have been modified by John Doe The following section describes the data types supported by SharePoint and an example of how to state the export condition ewe samen mtn Yes No Document Verified Yes SPListX exports list items that have the Document Verified value set to Yes Text Title lt gt Research SPListX exports only list items that do not have Research as value for Title field Date and Time Created Date Assuming date specified by 09 01 2010 by Created Date format SPListX exports list items created in the month o 09 30 2010 it ted iach th of September 2010 navies ais a ee SPListX exports list items 7 that have Product ID value lies in between 10 to 100 P 1 CUFTENGY TORCER we SP
70. at are created or SPListX compares the source list item s modified date value with the current day modified in the Modified Date at the time of Changed Today time of export in SharePoint present day at the Changed Today export and exports the list items which are modified on the current day 124 Changed Yesterday Changed This Week Changed This Month Changed Last Week Changed Last Month Exports list items that are created or modified yesterday at the time of export in SharePoint Exports list items that are created or modified in the current week Exports list items that are created or modified in the current month Exports list items that are created or modified in the last week Exports the list items that are created or Created Date Changed Yesterday Modified Date Changed This Week Modified Date Changed This Month Created Date Changed Last Week Modified Date Changed Last Month SPListX compares the source list item created date value with yesterday day before at the time of export and migrates the matching list items SPListX checks the source list item s modified date value and exports the items that are changed in the current week SPListX checks the source list item s modified date value and exports the items that are changed in the current month SPListX checks the source list item s created date
71. ata file b Append This option will append the new metadata to the existing metadata file The new metadata will be shown in the new sheet with the name of current timestamp in XLSX file 259 8 You can specify a new metadata custom format based on the column name when generating the metadata file The format specified here overrides the application level template defined in Metadata Format Template tool Also you can specify new column names to use when generating the metadata file in the file system location To use this feature click the Edit button A Customize Metadata Format Dialog appears as shown below Customize Metadat t ustomize Me da a Formai Enter column name its type and the format to use when exporting its value to the metadata file You can rename the SharePoint column name when exporting it to the metadata file by providing a new header name below Column Name Column Type Format New Header Name Column Name Column Type Format New Header Name Note The column s metadata format entered here will override the format specified in the Metadata Format Template 9 Specify SharePoint column name inthe Column Name i select its type from the available Column Type from combo box Click button to load the available macros Select format from the available macros If you want to rename the SharePoint column name when exporting to the metadata file provide a new name in the New Header Name text box F
72. ate list item URLs should be removed from search results How to view duplicate search results in SharePoint 2013 gt Go to the search page enter any query to return the search results page For example enter keyword sharepoint in any keywords text box Under Site Actions select Edit page Locate the Search Core Results web part usually in the bottom zone From the Edit button select Modify shared web part Yv V V WV In the task pane that appears on the right hand side under Settings check the box labelled Show view Duplicates links 270 5 2 2 SharePoint 2010 Search Results Disclaimer The information below can be specific to particular SharePoint environmental issues The workarounds may or may not be suitable for your environment Please consult your SharePoint Administrator before performing any changes to your SharePoint production environment Protocol handler that crawls the SharePoint content will not populate ows_created_x0020_By Text crawled property 1 How to map CreatedDate field to crawled field gt Open Central Administration in the Application Management section click Manage service applications gt Click the Search service application for which you are viewing managed and crawled properties gt On the Search Administration page in the Quick Launch under Queries and Results click Metadata Properties gt On the Metadata Property Mappings page click New Manag
73. ated tasks and file them together 1 In order to edit a SPListX categories select Manage Categories from Tools menu Profile Manager Metadata Format Template Active Directory Profile Manager File Share Manager Manage Favorites Manage Categories Web Single Sign on Dashboard Proxy Settings E Cleanup History iy View Activity Log X Remove Activity Log 2 The Categories List dialog will be shown as below Task Categones 48 3 In order to add a category click New button and provide the information about category in the New Category dialog as shown below Color Ml Black 7 Click OK 4 The newly added Category will be shown in the Categories List as below B Category1 49 5 In order to Change the color of the existing category Select the Category and Select the desired color in the Color Drop Down List for the selected category as shown below Categories List Task Categones Me Category1 CJ Yellow C White E Navy E Tea E Green E Maroon E Purple E Olive E Gray E Orange More Colors Click OK to enable the feature Henceforth the categories in the Categories List can be used to categorize the newly created tasks or to re categorize old tasks 50 2 15 Active Directory Profile Manager Use this tool to create an Active Directory user profile to retrieve the Domain Group members from SharePoint environment This user
74. ation Reset All This option resets all the column type s custom format in the template to the default format of the application 55 3 In order to edit the default format double click the column type that you wish to customize and select the macros in the Edit dialog as shown below Person or Group i Note Multiple values will be separated by a semicolon when exporting to the metadata file Double click to add macros to the Custom Format textbox You can type special characters to separate values between the built in macros Column values that contain multiple values in them will be separated by semicolon when exporting to the metadata file 56 shown below Metadata Format Template 4 The edited column type will be shown in the Metadata Format Template as Use this common template to customize metadata format when exporting library or list column values to the metadata file Type Text Note Choice Number Currency Date and Time Lookup Yes No Person or Group Hyperlink or Image Task Outcome External Data Managed Metadata Related Items Geolocation Format Example SPListX Hello World Volley Ball 10 10 00 02 20 13 05 55 55 Document 1 0 10 ken http faww vypain com Success Product Term Label http vyapin com documents file 1 doc POINT 40 30 Custom Format Export without html tags Item Name MMMM dd yyyy HH mm ss Item ID
75. aversal option is not applicable 5 Use wildcard representations and in order to export the list from the source SharePoint Please see wildcard characters usage for this purpose Wildcard characters E http sharepoint x default http sharepoint o http sharepoint Description Exports lists from all the subsites Exports lists from all the sites and sub sites from the source SharePoint Exports lists from the top level site 6 The second column of all the rows should contain the destination folder location e g C My Projects or FileServer My Documents where the exported item is to be stored 7 Be consistent with the drive letters and UNC path when exporting folders files and list item attachments from a SharePoint list If you use local mapped drives to export files or list item attachments ensure the Destination Path field has the corresponding local mapped drive path e g M My Documents If you use shares to export file or list item attachments ensure the Destination Path field has the corresponding UNC path e g Machine_ Name Share_ Name 8 For CSV and TXT formats all field names and their corresponding metadata values e g http vyapin Shared Documents sample folderi1 When using accent characters such as a in folder file names the CSV TXT metadata file must be in UNICODE encoded format N T Should be enclosed wit
76. ax entered in the dialog 5 When you select Create metadata file for each list item file option SPListX creates the metadata file using the Item name 258 6 7 Specify metadata file name Macro Sample Value File Extension tt Current Date 20151212 Current DateTime 20151212 145333 SUID 2a lazbd827a64997b 1507686f55d Item ID 1 Item Name File Name List of features in SPList List Name Shared Documents Title SPList Feature List View Name All Documents Extension if applicable File Name lt Item Name File Name gt _ lt View Name gt Construct metadata file name with the available built in macros provided in the dialog Click OK to close the dialog The file name will be created in the name format syntax entered in the dialog Note ViewName macro is applicable only for View based export SPListX will substitute the name of the processed view wherever applicable In view based export For list library entries and for files folders within them it appends the view name For file folder entries provided for export it appends All Items instead of the view name e g List of features in SPListX_All Items xlsx Specify the Metadata file format using the options below CSV XSLX XML XML with DTD a0 09 If the metadata file already exists in the destination location choose from any one of the following options a Overwrite This option will overwrite the existing metad
77. be used for each of the list items exported from the list Select any one of the following version settings a All versions Export all list item versions available in the source list b Export version range Export only list item versions specified in the range from the source list e g versions 2 to 5 c Export version date range Export only list item versions by date specified in the range from the source list e g versions date 11 19 2010 15 19 2010 The source list date used for exporting is Modified date of a list item d Export major versions only Export the major list item version from the source e Latest version only Export the latest list item version from the source 3 File Version Handling SPListX Task Wizard Sample Task Step Number Version Options Specify the list item versions to export By default all versions of the list item will be exported Export Versions All versions Export version range Export version date range Start 20 Feb i2 End 20 Feb 12 Export major versions only Latest version only Ale Version Handling Libraries only Export each file version to a version folder named as v lt VersionNumber gt Store latest version in root folder O Store latest version in the respective version folder Export each file version as separate files named as lt FileName gt _v lt VersionNumber gt Select any one of the following export options
78. by selecting the option yes d Do you want to create the folder underneath when its contents are empty This option creates the folder in the destination location if the source folder contents are empty Select the appropriate option to create the folder by selecting the option Yes No e Do you want to create separate folder for storing file attachments This option creates separate folder for storing file attachments under the specified destination location by selecting the option yes No You can create separate folder for storing file attachments associated with list items The folder file naming option will be useful when list item attachments have the Same name You have the option to select an attachment folder or file naming convention to use when exporting list item attachments The attachment folder will be named based on the folder naming convention specified by the user To select attachment folder naming mask click the button placed next to the attachment folder tag name text box This dialog appears as shown below Attachment folder tag name Specify folder name mask for exporting attachments Macro Sample Value ItemID 1 ItemName Cites ListWame Shared Documents Pi Folder Name Attachment_ lt ItemID gt _ lt ItemName gt Construct attachment folder name with the available mask provided in the dialog Click OK to close the dialog The constructed folder name mask will be placed in 252 atta
79. c Documents SPList Export Uy promt E Add to Favorites Change Export Location gt X Remove 2 Remove All HBHRAARA ee http vm sp2013 8 vyapin Orbit C Users Public Documents SPListx Export orbit http vm sp2013 8 vyapin Planet C Users Public Documents SPListx Export Planet http fvm sp2013 8 vyapin _catalogs design C Users Public Documents 5PListx Export Composed Looks http fvm sp2013 8 vyapin Lists CustomListVerification C Users Public Documents SPListX Export CustomListVerification 6 You can perform keyword search by entering search keyword in search keyword textbox and selecting the list items based on search results for exporting to the file system Note Exporting based on search results is not applicable for SharePoint 2003 87 Select items to export Select folders list items to export Use Ctrl key to select multiple items Select destination folder location and dick Export button to export items Click Remove button to remove selected items from export Press F5 to refresh treeview Source hittp ven sp20135 8 vyapin Folder Lists TeamList a i vyapin Composed Looks CustomListVerification DocumentLibraryForSharePoint Documents gH Galaxy Master Page Gallery MicroFeed gH orbit gH Planet Site Assets Site Pages TaskList TeamList E 4 objects selected Name 7 Vento launches with six gears Bluestacks 7 Dusters gt Kiwis Stems P Microbiology A B
80. cal files only Export SharePoint list contents folders files list item attachments to the local file system or network share Metadata will not be exported O Export metadata only Export metadata for SharePoint list items to the local file system or network share Physical files or attachment files will not be exported 277 Click Next button 3 Specify Search URL Settings 4 Specify Search Conditions Step Number Search Conditions This wizard helps you manage the export task settings All of these words Share Point Any of these words The Exact phrase None of these words Result Type Scope Narrow the search Property J Operator ic Logical operator and Or Value John Doe Property Author John Doe Trial Search 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 278 The Trial Search Dialog appears as shown below Trial search tool will help you perform a live search to verify the search results URL https vyapin sharepoint com z Signinas gore vyapin onmicrosoft com Note Double dick on results to launch the URL in your browser Save Results a Select URL from the URL drop down b The SharePoint Login Dialog to connect to SharePoint will appear as shown below Enter a valid user credential to connect t
81. ccount in which the profile is created Hence you will not be allowed to change the scheduled Run As user context for the export task Click Manage Profile button to create new user profile 141 6 As for Web Single Sign on credential based export task the task settings will be shown as below SPListX Task Wizard gt _ gt aoe oe Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Category C Blank Description Task Option Connect to SharePoint As l Run later This user Run now C Schedule Prompt me for user context at task run time The Web Single Sign on framework expects the user name and password to be given by user interactively in a browser based login dialog Hence the user profile list is not accessible for this type of connection 142 7 As far as scheduled run is concerned SPListX enables you to setup the export task using persistent connection and shared credential as shown below SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Sample Task Office 365 Category C Blank Description Task Option Connect to SharePoint As C Run later This user Run now Schedule Use persistent session of the target site Check session status in Web SSO Dashboard Schedule Settings Run As VYAPINLAB kevin Set Password
82. chment folder naming tag textbox as shown below Attachments will be exported to the resultant folder name mask value SPListX Task Wizard Step 9 of 12 Destination Folder Options Specify folders settings to use when creating folders in file system Do you want to create current timestamp folder under destination location Do you want to create destination folder path if it does not exist Do you want to create the folder underneath when its contents are empty Do you want to create separate folder for storing file attachments Attachment Folder Tag Attachment_ lt ItemID gt _ lt ItemName gt Search Folder Tag ContentType gt 4 Click Next to proceed 253 5 1 11 File Settings To construct Alternate File Mask and to propagate created Date and Modified Date from SharePoint Library to Windows File System use below options 1 Alternate File Name Mask If the file with the same name already exists in the destination location follow the steps outlined below SPListX Task Wizard Batch Step Number File Settings Use the option below to manage file duplicates in the Windows File System You can also propagate Created Date and Last Modified Date fields from SharePoint Library to the Windows File System If the file with the same name already exists in the destination location C Do not overwrite the existing file Overwrite the existing file Rename the new file that is currently exported from S
83. com Password Keep me signed in Can t access your account Don t have an account assigned by your organization Sign in with a Microsoft account Organizational accounts that work here can be used anywhere you f see this icon 2014 Microsoft Legal Privacy Feedback Provide User ID and Password in the respective textboxes and click Sign in button to proceed 83 3 1 3 Items to Export To add folders and items to export to the destination location in the file system 1 The Items to export step appears as shown below Select folders or items to export by clicking Add Edit button 2 Click Add Edit button to add and remove the folders and items for export 84 3 The Select items to export dialog appears as shown below Select items to export Select folders list items to export Use Ctrl key to select multiple items Select destination folder location and dick Export button to export items Click Remove button to remove selected items from export Press F5 to refresh treeview Source http vm sp2013 8 wyapin harvester farmadmin Go Folder Advanced Search Browse Search Results gil vyapin 1 objects selected Si Home Up gy Add to Favorites Refresh List Views Filter Composed Looks CustomListVerification Name DocumentLibraryForSharePoint gui Galaxy Documents fH orbit R Galaxy fi Planet Master Page Gallery Composed Looks feria CustomListVerification a 7 a
84. condition to apply at the SharePoint site level site Name ProductList Server Relative URL sites productist SPListX will export the sites that satisfy the export conditions depending on the option selected by the user b List Level Filters Click List level filter to specify the filter conditions The List Level Filter dialog appears as below List Level Filter Specify condition to apply at the SharePoint list level For example you can export lists when List Type Document Library OR List Type Picture Library Property Operator c You can specify the export filters by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed using logical 231 operators AND and OR cic to add multiple filters cick to remove the filter from the filter list Click Clear to remove all the filters specified Specify condition to apply at the SharePoint list level For example you can export lists when List Type Document Library OR List Type Picture Library Boomer tiey o ee List Name Documents SPListX will export the lists that satisfy the export conditions depending on the option selected by the user d Folder L
85. ctive m refiner for search results in the front end You must manually confiqure the refiner in the web Mappings to crawled properties The list shows all the crawled properties that Include content from all crawled properties are mapped to this managed property A Include content from the first crawled property that is not empty based on the specified order managed property can get its content from one or more crawled properties Move Up Mappings to crawled properties Move Down Add a Mapping Remove Mapping 269 2 3 How crawling will affect export process of search results For example if you performed search for the search query Author John Doe using Trial search Dialog search results contains 1205 records approximately and save the search results During export process search results count may increase to 1250 records approximately this is due to the incremental crawling of the content source How to avoid the System Services TimeoutException during export process of search results in SPListX During frequent usage of SharePoint SharePoint Search services cannot serve the search request within the stipulated time therefore SharePoint search server itself throws a System ServicepProcess TimeoutException To avoid this exception we strongly recommend you to perform search export process during off peak hours 4 What is meant by Trimming Duplicate Search Results 5 To specify whether duplic
86. d 1 The Export Options step appears as shown below Step Number Welcome to SPListX Task Wizard This wizard helps you manage the export of SharePoint list contents to the file system along with its associated metadata Export Option Export list contents and metadata Export SharePoint list contents folders files list item attachments and its associated metadata to the local file system or network share Export list contents physical files only Export SharePoint list contents folders files list item attachments to the local file system or network share Metadata will not be exported Export metadata only Export metadata for SharePoint list items to the local file system or network share Physical files or attachment files will not be exported Select the required export options The wizard guides you with the steps accordingly 4 1 3 Batch Descriptor File You can create a SPListX export task using a batch descriptor file that states the folders and list items to export from the SharePoint list along with the destination file system location to store the exported item SPListX will export the folders list items and associated metadata based on the sequential entries in the batch descriptor file 1 The Batch descriptor file specification step appears as shown below SPListX Task Wizard Step Number Batch descriptor file Specify batch descriptor file to use in order to export folders list i
87. d Date and Last Modified Date for folders and files to the NTFS file system In a FAT file system the Last Modified Date alone will be retained as in source 3 Click Next to Proceed 4 1 11 Metadata File Settings SPListX will create metadata files based on the following options given below 1 The Metadata File Settings step appears as shown below Step 10 of 11 Metadata File Settings Specify destination path to store metadata file and export file format CSV XLSX XML Metadata file Store metadata file s in this location C Users Public Documents SPListX Export location 0 Store metadata file s in the respective list library folder location in the file system Metadata file options Create a metadata file for each list library Create metadata file for each list item file Metadata fle name lt ListWName gt File Format XLSX If file already exists Overwrite metadata file Append metadata to current file Metadata Format Optional Column Name Column Type Format New Column Name 2 Specify the Metadata filename amp location using the options below a Store metadata file s in this location Specify a folder path where the selected list items metadata are to be exported You can also Click browse button to launch folder browser dialog b Store metadata file s in the respective list library folder location in the file system This option will export the metadata file i
88. d from SharePoint Alternate File Name Mask lt FileName gt lt Index gt rm a You can propagate original created date and last modified date for folders and files from SharePoint library to the NTFS file system In a FAT file system the last modified date alone will be retained from SharePoint library When document packaging option is selected the created date alone will be retained from the SharePoint library V Retain created date Retain modified date a Do not overwrite the existing file Skips the file without overwriting the existing file with the same name b Overwrite the existing file Deletes the file from the destination location and exports the current source file c Rename the new file that is currently exported from SharePoint Rename the file based on the file name mask specified in the Alternate File Name Mask text box To select alternate file naming mask click the alternate file name mask button placed next to the alternate file name mask textbox Alternate file name mask dia og appears as shown below Construct alternate file naming mask with the available macros provided in the dialog Click OK to close the dialog The new files will be exported in the name format syntax entered in the file naming mask 2 File System Date Settings TO propagate the system date fields Created Date and Last Modified Date to respective folders and files in the file system follow the steps outlined be
89. d using the list name and its corresponding GUID An XML file is created using the metadata filename specified by the user in the stated metadata file location When you click the XML file the text files in the folder are re grouped using the DTD file to form a single XML file 139 3 1 12 Task Settings To specify the task name category and schedule settings follow the instructions given below Please note that the task options will change depending on whether you are using Windows Forms authentication or Web Single Sign on credentials to connect to SharePoint 1 The Task Settings step appears as shown below SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings 2 3 4 5 Name Category C Blank Description Task Option Connect to SharePoint As Run later This user VYAPINLAB kevin Run now Schedule Prompt me for user context at task run time Enter a unique task name in Task Name textbox Select a Category from the Drop Down List in which the task should be categorized amp stored Enter a Description for the export task Select a Task Option from one of the following options a Run later to run the task later as and when desired b Run now to run the task immediately after clicking Finish button c Schedule to create a Windows scheduled task SPListX will create a schedule task in the Windows Scheduled Ta
90. d90 8000 Freigegebene Dokumente 2004 Annual doc C Users Public Documents SPListX Exp ort 20121213 121643 Freigegebene Destination Dokumente 2004 Annual doc Overall Progress le Number of items to process 1 Number of items processed 0 of 1 Total size processed in KB 28 Total items processed 0 folders 1 items Elapsed Time 00 00 00 15 30 Runtime Statistics a Number of items to process Shows the total number of line items to process in the current export task This represents the number of items selected by the user in the browse mode or number of line items to process in the batch file b Number of items processed Shows the number of line items that have been processed at any given instance c Total size processed in KB Shows the total size of files that were exported from SharePoint at any given instance including documents version history and file attachments d Total items processed Shows the number of folders and items documents amp list items exported from SharePoint at any given time instance The count does not include version histories and file attachments e Elapsed Time Shows the elapsed time from the instance the export task Started or commenced 4 Once the export task is complete click Refresh button available in Task History pane in SPListX main application A new entry will be added in Task History section where you can view the export activity performed when the task
91. date range Export only list item versions by date specified in the range from the source list e g versions date 11 19 2010 15 19 2010 The source list date used for exporting is Modified date of a list item d Export major versions only Export the major list item version from the source 100 e Latest version only Export the latest list item version from the source 3 File Version Handling SPList Task Wizard Sample Task Step Number Version Options Specify the list item versions to export By default all versions of the list item will be exported Export Versions All versions Export version range Export version date range 20 Feb 12 20 Feb 12 Export major versions only Latest version only Ale Version Handling Libraries only Export each file version to a version folder named as v lt VersionNumber gt Store latest version in root folder C Store latest version in the respective version folder Export each file version as separate files named as lt FileName gt _v lt VersionNumber gt lt Back net gt Select any one of the following export options a Export each version to a version folder named as This option will create a version folder for each file version based on the version folder name specified in the folder name mask textbox You have the option to export the latest file version to the root folder or export it to the respective version folder i
92. ders in file system Do you want to create current timestamp folder under destination location Yes Do you want to create the toptevel folders induded for export Yes Do you want to create destination folder path if it does not exist Yes Do you want to create the folder underneath when its contents are empty Yes Do you want to create separate folder for storing file attachments Yes Attachment Folder Tag Attachment_ lt ItemID gt _ lt ItemName gt 3 Click Next to proceed 131 3 1 10 File Settings To construct Alternate File Mask and to propagate created Date and Modified Date from SharePoint Library to Windows File System use below options 1 Alternate File Name Mask If the file with the same name already exists in the destination location follow the steps outlined below SPListX Task Wizard Batch Step Number File Settings Use the option below to manage file duplicates in the Windows File System You can also propagate Created Date and Last Modified Date fields from SharePoint Library to the Windows File System If the file with the same name already exists in the destination location Do not overwrite the existing file Overwrite the existing file Rename the new file that is currently exported from SharePoint Alternate File Name Mask lt FileName gt lt Index gt re a You can propagate original created date and last modified date for folders and files from SharePo
93. e Changed This Week Modified Date Changed This Month Created Date Changed Last Week Modified Date Changed Last Month Result Remarks SPListX compares the source list item modified date value with the current day at the time of export and exports the list items which are modified on the current day SPListX compares the source list item created date value with yesterday day before at the time of export and migrates the matching list items SPListX checks the source list item s modified date value and exports the items that are changed in the current week SPListX checks the source list item s modified date value and exports the items that are changed in the current month SPListX checks the source list item s created date value and exports those items that are changed in last previous week SPListX checks the source list item s modified date value and exports those items that are changed in last previous month Changed Last 7 days Changed Last 14 days Exports list items that are created or modified in the last 7 days Exports list items that are created or modified in the last 14 days Modified Date Changed Last 7 days Modified Date Changed Last 14 days SPListX checks the source list item s modified date value and exports the items that are changed in the last 7 days SPListX checks the source list item s modified date
94. e System Favorites Show favorites for SharePoint URL and File System path 45 4 In order to set Default favorite select a favorite and Click Set as default button to set the default favorite The Default favorite will be highlighted in Bold Add a SharePoint URL or File System path as a favorite SPListX will show the favorites whereever applicable Click the checkbox to display the favorites or SPListX will show windows options by default Name http TestMachine SharePoint Create in SharePoint Favorites Sly SharePoint Favorites i Bhttp TestMachine SharePoint lp File System Favorites Show favorites for SharePoint URL and File System path 46 5 To enable the favorites you have to check the Show favorites for SharePoint URL and File System path option and Click OK button to enable the feature Add a SharePoint URL or File System path as a favorite SPListX will show the favorites whereever applicable Click the checkbox to display the favorites or SPListX will show windows options by default http TestMachine SharePoint RemoveAll E J SharePoint Favorites a Sy File System Favorites Show favorites for SharePoint URL and File System path Henceforth Manage Favorites will show the favorites as a dropdown wherever applicable 47 2 14 Manage Categories Use this tool to Add Delete categories or change the Color of the categories The Categories will help you group the rel
95. e its export process 37 Remarks gt Brief remark about the status of export Completed Successfully Export process was completed successfully without any errors Incomplete refer activity log Export process encountered certain errors as described in the activity log Incomplete Eval limit reached Export process reached the maximum allowed number of files to export in evaluation trial version This message is applicable for evaluation trial version only Terminated Cancelled by User Export Process was cancelled by the User Terminated abnormally The Export Process was abnormally terminated or killed Failed the following error The export process could not be initiated as occurred while creating activity there were issues in creating the activity log files log and initiating the export process The following operations can be performed on Task history items View activity log Remove a task history item Manage task status Y V V WV Cleanup history 38 2 12 Profile Manager Use this tool to create a user profile in Windows Stored User Names and Passwords applet Credential Manager in order to specify the user context to run SPListX export tasks The stored user profile will be very useful when you are trying to perform the following export tasks in scheduled manner using SPListX gt Exporting contents between two different Windows Domain Forest gt Exporting contents from SharePoint residing in com
96. e the Content Type column name entered here exactly matches the display name of the SharePoint column Takes additional time to process SharePoint maintained read only columns Click Next to proceed 99 3 1 5 Version Options To selectively export list item versions to the destination file system location 1 The Version Options step appears as shown below SPList amp Task Wizard Sample Task Step Number Version Options Specify the list item versions to export By default all versions of the list item will be exported Export Versions All versions Export version range Export version date range 20 Feb 12 2 Feb 12 Export major versions only Latest version only Ale Version Handling Libraries only Export each file version to a version folder named as v lt VersionNumber gt Store latest version in root folder Store latest version in the respective version folder Export each file version as separate files named as lt FileName gt _v lt VersionNumber gt C 2 Export Versions By default All versions option is selected Item version settings will be used for each of the list item exported from the list Select any one of the following version settings a All versions Export all list item versions available in the source list b Export version range Export only list item versions specified in the range from the source list e g versions 2 to 5 c Export version
97. eate a task to export folders files list items including attachments along with their metadata from SharePoint List to file system or network share 1 Select Export SharePoint List contents using the search option in SPListX Task Options dialog as shown below and click OK Select a task type for creating a new task A wizard will quide you through steps to create a task based on the selected Task type Export SharePoint List contents using the browse option Create a task to export folders files and list items including attachments along with metadata to the file system by browsing the SharePoint list contents _ Export SharePoint List contents using a batch descriptor file Create a task to export folders files and list items including attachments along with metadata from SharePoint list to file system based on the entries in the descriptor file Export SharePoint List contents using the search option Create a task to export folders files and list items including attachments along with metadata from SharePoint list to file system based on SharePoint Search results Lok cae 2 The SPListX Task Wizard appears as shown below 204 eny mire l J f ist a5 izare Step Number Welcome to SPListX Task Wizard This wizard helps you manage the export of SharePoint list contents to the file system along with its associated metadata Export Option Export list contents and metadata Export SharePoint list con
98. eb 12 4 59 56 PM days EJ Go Refresh gil Open Log Folder gi View Activity Log X Remove Remove All sess tema 35 3 Show status for lt n gt days Upon clicking Go button displays task history entries of all tasks that were run within the specified number of days 4 Refresh Reloads the task history entries and updates the newly run tasks if any 5 View activity log Displays activity log of the currently selected task history item 6 Remove Removes the currently selected task history entry and its associated log folders and files 7 Remove all Removes all task history entries and their associated log folders and files that are currently displayed 8 Click Close button to close this window 36 2 11 Task History When an export task is run in SPListX the task export information is maintained in the TaskHistory folder The task history information can be seen at bottom of SPListX application s main window Task History 2 Refresh Gj Open Log Folder View Activity Log X lt Remove Elapsed Time 00 00 36 Start Time 09 Jan 12 11 08 07 AM End Time 09 Jan 12 11 08 44 AM Remarks Completed successfully Incomplete refer activity log Completed successfully 09 Jan 12 11 06 42 AM 09 Jan 12 11 06 56 AM 00 00 14 05 Jan 12 3 08 56 PM 05 Jan 12 3 09 54 PM 00 00 57 To view task history of a particular task 1 Select a task from Task List pane 2 The history of task will be display
99. ect URL from the URL drop down b The SharePoint Login Dialog to connect to SharePoint will appear as shown below Enter a valid user credential to connect to SharePoint 217 Provide user credentials to connect to SharePoint Connect to SharePoint using the specified user credentials SPListX will initiate Windows authentication or Forms authentication depending on configuration in the target SharePoint site URL https vyapin sharepoint com autrentcation VSSLAB farmadmin_sp 10 1 Gjohndoe contoso com contoso johndoe johndoe User Name Password c Click Search button to perform search Trial search tool will help you perform a live search to verify the search results URL https vyapin sharepoint com Sign in as 8 objects Title TestingFiledfaf A Team Site How To Use Get Started with Micros fodfgfdgfgh gt confusding task in SPListX_customer_feed ver 2 idsda gore vyapin onmicrosoft com Path https vyapin sharepoint https vyapin sharepoint https vyapin sharepoint https vyapin sharepoint https vyapin sharepoint https vyapin sharepoint https vyapin sharepoint https vyapin sharepoint dd Back 1 Modified Date 08 Feb 12 11 45 47 AM 08 Feb 12 11 38 51 AM 06 Oct 11 1 47 50 PM 06 Oct 11 1 47 50 PM 08 Feb 12 11 48 28 AM 06Feb 12 12 10 12 PM 29 Nov 11 8 43 22 AM 08 eb 12 11 40 20 AM
100. ed Property On the New Managed Property page in the Property name box in the Name and type section type the name of the new managed property gt Inthe Description box type a description of the property Under The type of information in this property select one of the following options for the property Under The type of information in this property Text type In the Mappings to crawled properties section select Include values from a single crawled property based on the order specified gt Click Ok 271 SharePoint 2010 Central Administration Search Service Application Edit Managed Property CreatedDate Use this page to view and change the settings of this property Name and type Type a name for this property and select the type of information you want to store in this property Property name CreatedDate Description Select the Has Multiple Values checkbox to enable storing multiple values for a given item with this property The type of information in this property Text 3 Integer gt Decimal Date and Time Yes No V Has Multiple Values Mappings to crawled properties Include values from all crawled properties mapped A list of crawled properties mapped to this managed Include values from a single crawled property based on the order specified property is shown To use a crawled property in the Crawled properties mapped to this managed property each PEDE plesk spd Bancio Denna Pe
101. ed at bottom of SPListX main window as shown Show Categories _ All Tasks _TaskName s Description Created _ Modified _ Total Items Processed _Total Data Transferred Settings _ S Metadata export tasks Page Library Aerobics Documents Everest Master page gallery E Library Documents E View Export Hi Allversions E Lists Hi Important Documents Wiki Hi Contacts 2 EE Cloud 3 E Latest Versions C Blank t below Task History Start Time Images Contents are moved to the Shared Documents End Time 6 9 2015 4 49 05 PM 6 9 2015 4 39 35 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 47 56 PM 6 9 2015 4 49 05 PM 6 9 2015 4 40 12 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 48 14 PM 83 Files 0 Folders 5 008 1 Files 0 Folders 1 25 KB 197 Files 0 Folders 1Files 0 Folders 3 Files 0 Folders 60 04 MB 827 00 B 73 47 KB 2 Refresh Open Log Folder View Activity Log X lt Remove Elapsed Time Remarks 09 Jan 12 11 08 07 AM 09 Jan 12 11 08 44 AM 00 00 36 Completed successfully Incomplete refer activity log Completed successfully 09 Jan 12 11 06 42 AM 09 Jan 12 11 06 56 AM 00 00 14 05 Jan 12 3 08 56 PM 05 Jan 12 3 09 54 PM 00 00 57 Where Start Time gt Date and Time a task was initiated End Time gt Date and Time a task completed its export process Elapsed Time gt Total time hh mm ss a task has taken to complet
102. ems documents including folders in the list view as it appears in Allitems aspx web page corresponding to the list You have the additional option to specify the SharePoint columns to export as per the options below I Export all columns Exports all columns available in the source SharePoint list including built in SharePoint columns such as Created Modified Approval Status etc il Export all user defined columns Exports all columns that are created by a SharePoint user 97 iii Export selected columns Exports columns that are specified in the textbox SPList Task Wizard FileEntries Step 3 of 11 List View Options Export list items documents based on SharePoint List Views View Settings All items in the List View Allltems aspx Select Columns to export O Default View All Views Specific Views Columns to export i Export all columns a Export all user defined columns 4 Export selected columns Title a Enter one column name per line Ensure the Content Type column name entered here ewactly matches the display name of the SharePoint column Takes additional time to process SharePoint maintained read only columns b Default View Exports all items including folders available in the Default view of the given SharePoint list The SharePoint columns defined in the default view will be exported to the metadata file c All Views Exports all Views in the SharePoint li
103. ending on the option selected by the user Export list items if the above conditions are satisfied Folders that satisfy the condition will be marked for export Export list items if the above conditions are not satisfied Folders that do not satisfy the condition will be marked for export h File or Item Level Filters Same as Folder Level Filters 3 Click Next to proceed 243 Examples of Export Conditions SPListX exports folders amp files attachments along with metadata to the file system location based on export conditions defined in the export task Export conditions can be constructed using metadata columns and its values A few examples of list conditions are as follows Export Condition Server Relative URL site name subsite name lists list name List Name Cities List Type Document Library Base Type lt gt Document Library Description Exports list items that have server relative URL as site name subsite name lists list name For example Server Relative URL vyapin sharepoint lists Product List Exports list item and attachments of lists named as Cities Exports documents from all document libraries in the entire web application Exports list items and attachments of all custom lists other than document libraries that are present in the entire web application A few examples of item and folder export conditions are
104. ents List items to export grid The export process order can be changed by the navigation buttons available in the right side of the grid 8 Items to export steps contains top level site sub sites document library folders and files added for export as shown below 93 Step Number Items to export Select folders or items to export by clicking Add Edit button http vm sp2013 8 vyapin http vm sp2013 8 vyapin Galaxy Export all sites and sub sites http vm sp2013 8 vyapin Orbit i Export all sites and sub sites http vm sp2013 8 vyapin SitePages Site Pages Export all folders and documents list items http vm sp2015 8 vyapin Lists TaskList TaskList Export all folders and documents list items http vm sp2013 8 vyapin _catalogs des Composed Looks Export all folders and documents list items 9 SPListX will export the folders documents list items and associated metadata based on Export Options useliatid button to edit the export options for lists and folders that are to be exported to the file system An Export Options dialog appears as shown below haat ot Baal Fo p Specify folders settings to use when reading the contents from source list folder and folder contents sub folders and items to export to file system Export all folders and documents list items C Export documents list items at the top level Exdude sub folders C Export folder hierarchy Excdude docume
105. enu Tools Profile Manager Metadata Format Template Active Directory Profile Manager Manage Favorites Manage Categories Web Single Sign on Dashboard Proxy Settings EA Cleanup History g View Activity Log XxX Remove Activity Log 58 2 The File Share Manager dialog will be shown as below SPListX stores your logon information for accessing file share contents which are added in the search crawl index These stored credentials are used to connect to the file share to export the files documents to the desired location To add a profile click Add button Fe Stas ane Pie Nave il 3 In order to add user profile click Add button and provide user information in the File Share Credential as shown below amp Diy 7 a a ila Q re C af tia 2 al n Ana pane Ueu f NTA Eg re Enter file share location and user credential to create a a File Share Name Specify the file share server name where the files are stored and the file share index is added in the search crawl index b Specify a new user profile or select an existing user profile to connect to file share to export file share contents which are added in the SharePoint search crawl index 59 4 The newly added user profile will be shown in the File Share Manager as below I SPListX stores your logon information for accessing file share contents which are added in the search crawl index These s
106. ep 6 of 11 Export Conditions Specify export conditions for site list folders and or file to filter the contents You can specify export conditions at three levels List Level Filter Folder Level Filter File or Item Level Filter Site Level Filters Click Site level filter to specify the conditions The Site Export Conditions Dialog appears as shown below site Export Condition Specify rule that must be satisfied before exporting site from SharePoint Field Name Operator Value Export site if the above condition is satisfied not satisfied Cancel You can specify the export conditions by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such lt gt to define your query Complex queries can be constructed with the use of left right parenthesis and and logical operators AND and OR site Export Condition Specify rule that must be satisfied before exporting site from SharePoint Field Name Operator Value Add to Filter Export site if the above condition is satisfied not satisfied SPListX will export the sites that satisfy the export condition or export the sites that do not satisfy the export condition depending on the option selected by the user Export sites if the above conditions are satisfied Sites that satisfy the condition will be marked for export Export sit
107. er Level Filters Click Folder level filter to specify the filters The Folder Level Filter dialog appears as below Field Type Operator d You can enter the SharePoint Column Name in the Property drop down Select the data type of the specified SharePoint Column in Field Type drop down Folder Level Filter ee Specify condition to apply at the folder level For example you can export folders when Created By John Doe Property Field Type Operator Value Connector Location choice e You can specify the export filters by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed with the use of logical operators AND and OR click to add multiple filters Clickltto remove the filter from the filter list Click Clear to remove all the filters specified Folder Level Filter Specify condition to apply at the folder level For example you can export folders when Created By John Doe Property Field Type Operator Value Connector Folder Name Project Details Or Modified By KenH Wang SPListX will export the folders that satisfy the export condition depending on the option selected by the user f File or Item Level Filters Same as Folder Level Filters g Click Next to Proceed ADVANCED St
108. er This user Run now Use persistent session of the target site Check session status in Web SSO Dashboard Schedule s Schedule Settings Anasi WAPINASYEVA Schedule Daily x start time 18 32 Advanced Schedule Task Daily Every 1 al day s At 18 32 every day starting 08 05 2012 8 SPListX expects the user must ensure the persistent connectivity status using Web Single Sign on dashboard To check the status click Check session status in Web SSO Dashboard hyperlink 265 SPListX Task Wizard Using this dashboard you can check the connection persistence status of daims enabled SharePoint sites that use federated identity model Enter or select a daims enabled SharePoint site URL and click Connect button If there is no shared credential available for the site you will be prompted for user credentials on demand to make the persistent connection Refer Help document for more information URG tips vyapin sharepoint com At 18 32 every day starting 08 05 2012 8 Click Finish button to create the task 266 5 2 Working With SharePoint Search Results e SharePoint 2013 Search Results e SharePoint 2010 Search Results e SharePoint 2007 Search Results 267 5 2 1 SharePoint 2013 Search Results Disclaimer The information below can be specific to particular SharePoint environmental issues The workarounds may or may not be suitable for your environment Please consult your SharePoi
109. erify the connectivity status of a site provide the site URL in the text box and click Connect button to commence the authentication process 69 Using this dashboard you can check the connection persistence status of daims enabled SharePoint sites that use federated identity model Enter or select a daims enabled SharePoint site URL and click Connect button If there is no shared credential available for the site you will be prompted for user credentials on demand to make the persistent connection Refer Help document for more information 70 4 If there is no shared credential available for the SharePoint site you will be prompted for user credentials automatically as shown below Ea Office 365 User ID Password Forgot your password Remember me Keep me signed in Don t have a user ID assigned by your organization Use a Hotmail account to sign in 2012 Microsoft Corporation Privacy Legal 71 5 Provide the user name and password in the respective text box Select keep me signed in option to create the shared credential and establish a persistent connection Click Sign in _httpsi login microsofto line Ba Office 365 kevin vyapin onmicrosoft com Password eeeee eee T Forgot your password V Remember me Sign in Don t have a user ID assigned by your organization Use a Hotmail account to sign in 2012 Microsoft Corporation Privacy Legal 72 6 Once the aut
110. ers settings to use when creating folders in file system Bo you want to create current timestamp folder under destination location Do you want to create the topdevel folder s induded for export Do you want to create destination folder path if it does not exist Do you want to create the folder underneath when its contents are empty Do you want to create separate folder for storing file attachments Attachment Folder Tag Attachment_ lt ItemID gt _ lt ItemName gt 2 Select from the following options a b Do you want to create current timestamp folder under destination location This option creates timestamp folder under the specified destination location This option may be useful when scheduling the export process or when repeated exporting contents to the same destination location Select the appropriate option to create the timestamp folder by selecting the option Yes No Do you want to create top level folder s included for export The top level folder is the folder added or specified for export by the user SPListX will commence the export process from this top level folder Select the appropriate option to create the top level folder by selecting the option Yes No 3 c Do you want to create destination folder path if it does not exist This option creates the full folder path in the destination location if the specified path is not available in the specified location by selecting the option yes
111. es if the above conditions are not satisfied Sites that do not satisfy the condition will be marked for export b List Level Filters Click List level filter to specify the conditions The List Export Conditions Dialog appears as shown below IST CEXDOM TLONnGIT Specify rule that must be satisfied before exporting item from SharePoint For example you can export list only when List Type Document Library Field Name Export list items if the above condition is satisfied not satisfied You can specify the export conditions by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such lt gt to define your query Complex queries can be constructed with the use of left right parenthesis and and logical operators AND and OR Specify rule that must be satisfied before exporting item from SharePoint For example you can export list only when List Type Document Library Field Name AND to Filter OR to Filter Conditions Base Type Document Library Export list items if the above condition is satisfied not satisfied SPListX will export the lists that satisfy the export condition or export the lists that do not satisfy the export condition depending on the option selected by the user Export list items if the above conditions are satisfied Lists that satisfy the cond
112. esearch as value for Title field Date and Time Created Date gt 09 01 2010 AND Assuming date specified by the Created Date lt user is in MM DD YYYY format 09 30 2010 SPListX exports list items created in the month of September 2010 nee o o ee SPListX exports list items that have Product ID value lies in between 10 to 100 evens RE a SPListX exports list items that have Product Cost value equal to 100 Choice City New York City London Paris Singapore Product Code 100 Product Code 123ABC 154XYZ People or Group Document Reviewed by John Doe Document Reviewed by John Doe Jane Doe Incremental Export in SPListX Text or Number values can be given for this field The values can be single or multiple Multiple values should be separated by SPListX exports the list items that have City column value set as London Paris and Singapore The values can be single or multiple Multiple values should be separated by SPListX exports the list items that have 123ABC and 154XYZ as value for Product Code field User or group values can be given for this field The values can be single or multiple Multiple values should be separated by SPListX exports the list items that have Document Reviewed by value set to John Doe and Jane Doe Apart from relational operators SPListX allows
113. esults Steps for creating batch file using search results 1 Select Export SharePoint List contents using the search option in SPListX Task Options dialog as shown below and click OK Select a task type for creating a new task A wizard will guide you through steps to create a task based on the selected Task type Export SharePoint List contents using the browse option Create a task to export folders files and list items induding attachments along with metadata to the file system by browsing the SharePoint list contents Export SharePoint List contents using a batch descriptor file Create a task to export folders files and list items induding attachments along with metadata from SharePoint list to file system based on the entries in the descriptor file Export SharePoint List contents using the search option Create a task to export folders files and list items induding attachments along with metadata from SharePoint list to file system based on SharePoint Search results 2 The SPListX Task Wizard appears as shown below Step Number Welcome to SPListX Task Wizard This wizard helps you manage the export of SharePoint list contents to the file system along with its assocdated metadata Export Option Export list contents and metadata Export SharePoint list contents folders files list item attachments and its associated metadata to the local file system or network share Export list contents physi
114. evel Filters Click Folder level filter to specify the filters The Folder Level Filter dialog appears as below Specify condition to apply at the folder level For example you can export folders when Created By John Doe Property Field Type Operator Value Connector d You can enter the SharePoint Column Name in the Property drop down Select the data type of the specified SharePoint Column in Field Type drop down 232 c pn i e f Specify condition to apply at the folder level For example you can export folders when Created By John Doe Property Field Type Operator Value Connector T ac e You can specify the export filters by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed with the use of logical operators AND and OR Click to add multiple filters Click to remove the filter from the filter list Click Clear to remove all the filters specified e si A Specify condition to apply at the folder level For example you can export folders when Created By John Doe Property Field Type Operator Value Connector 7 Project Detais Or i ModfedBy T KenWae o O 233 SPListX will export the folders that satisfy the export condition depending on the option selected by the user f File or Ite
115. ext to Proceed 228 5 1 8 Export Conditions SPListX can export folders files and list items including file attachments from a SharePoint list or library based on certain export conditions The conditions can be created by using SharePoint columns in the source list or library 1 The Export Conditions step appears as shown below SPListX Task Wizard Step 6 of 11 Export Conditions Specify export conditions for site list folders and or file to filter the contents BASIC List level 2 You can specify one of the following methods of exporting conditions BASIC ADVANCED 2 1 BASIC 229 You can specify export conditions at three levels Site Level Filter List Level Filter Folder Level Filter File or Item Level Filter Site Level Filter Click Site level filter to specify the filter conditions The Site Level Filter dialog appears as below Site Level Filter Specify condition to apply at the SharePoint site level Property Operator Connector You can specify the export filters by selecting the site name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed using logical operators AND and OR Click e to add multiple filters Click to remove the filter from the filter list Click Clear to remove all the filters specified 230 Site Level Filter Specify
116. ext using SPListX s Profile Manager in which SPListX task must be run Enclose the user name in double quotes For example profile voyager admin user profile Contoso johndoe profile johndoe contoso com profile johndoe Denotes user name context in which SPListX task must be run in the domain username format Enclose the user name in double quotes For example voyager administrator u Contoso johndoe u johndoe contoso com johndoe Denotes the password for the user name specified in u parameter Enclose the password in double quotes For example p 2ab45fb This optional flag suppresses SPListX s login dialog prompt to enter user credentials to connect to SharePoint 29 2 If noprompt flag is not used then the Credential Dialog will appear as shown below The given credential will be used to connect to SharePoint X Provide user credentials to connect to SharePoint Connect to SharePoint using the specified user credentials SPListX will initiate Windows authentication or Forms authentication depending on configuration in the target SharePoint site URL http rd21 8001 Authentication User Name VSSLAB aaron as Gjohndoe contoso com contoso johndoe johndoe Password PTT Titi iii x Jl cne 3 The export task will be reported in a new dialog as shown below E Sample AP SPUSXTask Status eal Thursday EET 13 2012 12 16 41 PM Exporting file http r
117. extbox as shown below Attachments will be exported to the resultant folder name mask value SPListX Task Wizard FolderHierarchy Step 6 of 11 Destination Folder Options Specify folders settings to use when creating folders in file system Bo you want to create current timestamp folder under destination location Do you want to create the topfevel folder s induded for export Do you want to create destination folder path if it does not exist Do you want to create the folder underneath when its contents are empty Do you want to create separate folder for storing file attachments Attachment Folder Tag Attachment_ lt ItemID gt _ lt ItemName gt 4 Click Next to Proceed 4 1 10 File Settings To construct Alternate File Mask and to propagate created Date and Modified Date from SharePoint Library to Windows File System use below options 1 Alternate File Name Mask If the file with the same name already exists in the destination location follow the steps outlined below SPListX Task Wizard Batch Step Number File Settings Use the option below to manage file duplicates in the Windows File System You can also propagate Created Date and Last Modified Date fields from SharePoint Library to the Windows File System If the file with the same name already exists in the destination location Do not overwrite the existing file 0 Overwrite the existing file Rename the new file that is currently exporte
118. f it does not exist Do you want to create the folder underneath when its contents are empty Do you want to create separate folder for storing file attachments Attachment Folder Tag Attachment_ lt ItemID gt _ lt ItemName gt lt Back net gt 2 Select from the following options a b Do you want to create current timestamp folder under destination location This option creates timestamp folder under the specified destination location This option may be useful when scheduling the export process or when repeated exporting contents to the same destination location Select the appropriate option to create the timestamp folder by selecting the option Yes No Do you want to create top level folder s included for export The top level folder is the folder added or specified for export by the user SPListX will commence the export process from this top level folder Select the appropriate option to create the top level folder by selecting the option Yes No 129 c Do you want to create destination folder path if it does not exist This option creates the full folder path in the destination location if the specified path is not available in the specified location by selecting the option yes d Do you want to create the folder underneath when its contents are empty This option creates the folder in the destination location if the source folder contents are empty Select the appropriate option to create
119. footprint when working with large XML files and improve metadata file throughput XML metadata files are split into multiple text files and stored in a folder location that is constructed using the list name and its corresponding GUID An XML file is created using the metadata filename specified by the user in the stated metadata file location When you click the XML file the text files in the folder are re grouped using the DTD file to form a single XML file 261 5 1 13 Task Settings To specify the task name and schedule settings follow the instructions given below Please note that the task options will change depending on whether you are using Windows Forms authentication or Web Single Sign on credentials to connect to SharePoint 1 The Task Settings step appears as shown below SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Category C Blank Description Task Option Connect to SharePoint As Run later D This user VYAPINLAB kevin X Manage Profile Run now Schedule Prompt me for user context at task run time Finish Cancel 2 Enter a unique task name in Task Name textbox 3 Select a Category from the Drop Down List in which the task should be categorized amp stored 4 Enter a Description for the export task 5 Select a Task Option from one of the following options a Run later to
120. hand side under Results Query Options check the box labelled Remove Duplicate Results 273 5 2 3 SharePoint 2007 Search Results Disclaimer The information below can be specific to particular SharePoint environmental issues The workarounds may or may not be suitable for your environment Please consult your SharePoint Administrator before performing any changes to your SharePoint production environment Protocol handler that crawls the SharePoint content will not populate ows_Modified_xO0020 By Text or the ows_ModifiedBy Text ows_created_x0020_By Text crawled property 1 How to map LastModifiedBy and CreatedBy field to crawled field gt Open Central administration gt Shared Services gt SharedServicesX X being the number of the shared services provider for the site you are creating a mapping gt search settings gt metadata property mappings Click ModifiedBy to edit the properties Make sure Include values from all crawled properties mapped is selected Click Add Mapping and select the Office category from the dropdown list Look for a property named OFFICE 8 click OK Vv Y V WV WV Click Add Mapping and select the ows_Last_x0020_Modified text from the ALL categories dropdown list Click OK gt Make sure the box is checked Allow this property to be used in scopes click OK Click CreatedBy to edit the properties gt Make sure Include values from a single cra
121. harePoint Alternate File Name Mask lt FileName gt lt Index gt a You can propagate original created date and last modified date for folders and files from SharePoint library to the NTFS file system In a FAT file system the last modified date alone will be retained from SharePoint library When document packaging option is selected the created date alone will be retained from the SharePoint library V Retain created date V Retain modified date a Do not overwrite the existing file Skips the file without overwriting the existing file with the same name b Overwrite the existing file Deletes the file from the destination location and exports the current source file c Rename the new file that is currently exported from SharePoint Rename the file based on the file name mask specified in the Alternate File Name Mask text box 254 To select alternate file naming mask click the alternate file name mask button placed next to the alternate file name mask textbox Alternate file name mask dialog appears as shown below a a ET er S Ee oe macros to be used as alternate file name mask Construct alternate file naming mask with the available macros provided in the dialog Click OK to close the dialog The new files will be exported in the name format syntax entered in the file naming mask 2 File System Date Settings TO propagate the system date fields Created Date and Last Modified Date to respecti
122. he sites and its sub sites specified under the given URL b Export top level site only This option exports only the top level site and excludes all the subsites in it c Export all subsites exclude top level site This option exports all the subsites specified under the given URL and it excludes the top level site 10 Click OK button to proceed or click Cancel to discard the changes 11 Click Next to proceed 96 3 1 4 List View Options You can export list items or documents based on SharePoint List views and thereby specify the SharePoint columns to export metadata To selectively export SharePoint Views from the list library follow the steps outlined below 1 The List View Options wizard step appears as shown below SPListX Task Wizard FileEntries Step 3 of 11 List View Options Export list items documents based on SharePoint List Views View Settings All items in the List View Allltems aspx Select Columns to export Default View All Views Specific Views Columns to export Export all columns a Export all user defined columns 7 Export selected columns lt Type column names here gt Examples Title Description Takes additional time to process SharePoint maintained read only columns lt Back Next gt 2 Select any one of the following View Settings given below a All items in the List View AllItems aspx Select Columns to export Export all it
123. hen you create SharePoint export tasks in SPListX the application creates Windows Scheduled Tasks to run the export tasks at the specified time interval where SPListX is installed Export task results for every task run instance is also maintained in the computer as application files When you uninstall SPListX through Control Panel Add Remove Programs applet Windows Installer program will remove only the application files from your machine But the application related files created by SPListX remain in the computer In order to remove SPListX worker files completely the uninstall wizard provides a set of cleanup options to perform the cleanup operation based your selection Use this wizard to cleanup the files that are created by SPListX for SharePoint application selectively and uninstall SPListX completely from the machine 1 Launch the uninstall wizard by clicking Start gt Programs gt SPListX for SharePoint gt SPListX Uninstall Wizard The SPListX Uninstall Wizard dialog will be shown as below 291 SPListX for SharePoint Uninstall Wizard Welcome to SPListX for SharePoint Uninstall Wizard This wizard helps you to deanup and uninstall SPList for SharePoint completely SPList This wizard will guide you through the steps to deanup the files that are created by SPList for SharePoint v 9 Using this wizard you can Cleanup export tasks and task history Cleanup scheduled tasks that are associated with
124. hentication Claims Authentication gt Exporting contents from Office365 SharePoint Online that uses federated identify configured through ADFS The shared credential persists for all subsequent logon sessions on the same computer where SPListX is installed unless the federation service treats it as expired or if the cookie is deleted from the computer The shared credential by nature is restricted to the Windows user profile context only The Shared credential is accessible only by the same user in the same computer The shared credential can be removed by deleting the cookies using Internet Explorer 68 1 Launch Web Single Sign on Dashboard tool using Tools menu Profile Manager Metadata Format Template Active Directory Profile Manager File Share Manager Manage Favorites Manage Categories rote ae oe ee aes Pe d D gt MM I a S b 0t a Jast board gi Sere ae ie ii ans R pics Ett i Proxy Settings Cleanup History View Activity Log Remove Activity Log Using this dashboard you can check the connection persistence status of daims enabled SharePoint sites that use federated identity model Enter or select a daims enabled SharePoint site URL and dick Connect button If there is no shared credential available for the site you will be prompted for user credentials on demand to make the persistent connection Refer Help document for more information 3 In order to v
125. hentication process is finished the connectivity status will be shown as below Using this dashboard you can check the connection persistence status of daims enabled SharePoint sites that use federated identity model Enter or select a daims enabled SharePoint site URL and click Connect button If there is no shared credential available for the site you will be prompted for user credentials on demand to make the persistent connection Refer Help document for more information Henceforth the shared credential can be used to connect to the federated SharePoint site by SPListX until the connectivity is closed or cookies are deleted 7 Click Close button to close Web Single Sign on Dashboard dialog 73 2 22 View Activity Log To View Activity Log associated with a task history item 1 Select an item from Task History pane Task History 2 Refresh Open Log Folder View Activity Log gt lt Remove Start Time End Time Remarks 09 Jan 12 11 08 07 AM 09 Jan 12 11 08 44 AM i Completed successfully 09 Jan 12 11 06 42 AM 09 Jan 12 11 06 56 AM Incomplete refer activity log 05 Jan 12 3 08 56 PM 05 Jan 12 3 09 54 PM Completed successfully 2 Click View Activity Log from SPListX main screen g View Activity Log Or Select View Activity Log from Tools menu IE Cleanup History ia View Activity Log Xx Remove Activity Log 3 The Activity Log Viewer dialog appears as shown below 74 Re Activity
126. hin double quotes 9 For Microsoft Excel file formats XLSX you do not have to enclose the field names and their corresponding values within double quotes Sample format of a CSV TEXT batch descriptor file NOTE Refer Point 2 for the separator to be used in the batch descriptor file Path Destination Path http vyapin shared documents Sample Brochure doc C My Documents http vyapin shared documents sample folder1 vyapinfs ExportDocs shared doc contents http vyapin lists C My Sales Lists Backup http Vyapin lists cities C My Cities Backup 4 1 2 Export Options You can create a task to export folders files list items including attachments along with their metadata from SharePoint List to file system or network share The export task enables users to select the export options in order to specify his requirements A Export list contents and metadata Export SharePoint list contents folders files list item attachments and its associated metadata to the local file system or network share B Export list contents physical files only Export SharePoint list contents folders files list item attachments to the local file system or network share Metadata will not be exported C Export metadata only Export metadata for SharePoint list contents to the local file system or network share Physical files or attachment files will not be exporte
127. his feature works only for SharePoint 2010 or later environment 1 The Permission options specification wizard step appears as shown below CDI cet Tack Wisard Camnle Tack LIStA ask Wiza d Se sli a5 Step Number Permission Options Works only for SharePoint 2010 or later Export site list item permission from SharePoint file to the metadata file Export Permissions Do not export permissions Export permissions Export Permissions a Do not export permissions This option will not export permissions to the metadata file b Export permissions This option will export permissions based on the user specified options The export permissions options appear as shown below SPListX Task Wizard Sample Task X Step Number Permission Options Works only for SharePoint 2010 or later Export site list item permission from SharePoint file to the metadata file e Export Permissions 2 3 4 5 6 Do not export permissions Export permissions Export pemissions for V Site W List W Listitem Permission format User Role format e johndoe Full Control a Role User format e g Full Control johndoe a inhentance status W Export inhertance status as separate column shows f the permission is Unique or Inherited a Membership information Export membership information and role definition to a separate XML file o You can export
128. i GOK documents gt Psx gt Epor r am p Organize v New folder Jr Favorites Documents library Arrange by Folder Export ge by Libraries i Computer No items match your search G Network gt Specify file name and Click OK button 281 gt While saving search results the Trial search dialog appears like this Fil Search z Trial search tool will help you perform a live search to verify the search results URL https vyapin sharepointcomn o O Signinas gore vyapin onmicrosoft com 8 objects d Back 1 ofi Next Title Path Modified Date t31 1 2fgg https vyapin sharepoint 08 Feb 12 11 45 47 AM TestingFiledfgf https vyapin sharepoint 08 Feb 12 11 38 51 AM b Team Site How To Use https vyapin sharepoint 06 Oct 11 1 47 50 PM Get Started with Micros https vyapin sharepoint 06 Oct 11 1 47 50 PM fadfgfdgfgh https vyapin sharepoint 08 Feb 12 11 48 28 AM A confusding task Saving search results A SPListX_customer A ver 2 idsdg Note Double click on results to launch the URL in your browser Save Results 282 Trial Search gt i o Trial search tool will help you perform a live search to verify the search results URL http rd41 sites devteam _layouts 15 start aspx v i Signinas voyager farmadmin_sp13 1 15 objects Title Path docbiz http rd41 sites devteam List Item Metada
129. ialog appears as below List Level Filter Specify condition to apply at the SharePoint list level For example you can export lists when List Type Document Library OR List Type Picture Library Property Operator Connector c You can specify the export filters by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed using logical operators AND and OR Click E3 to add multiple filters Click to remove the filter from the filter list Click Clear to remove all the filters specified 109 Specify condition to apply at the SharePoint list level For example EE IS ae List Type Document Library OR List Type Picture Library SPListX will export the lists that satisfy the export conditions depending on the option selected by the user d Folder Level Filters Click Folder level filter to specify the filters The Folder Level Filter dialog appears as below Specify condition to apply at the folder level For example you can export folders when Created By John Doe Property Field Type Operator Value Connector d You can enter the SharePoint Column Name in the Property drop down Select the data type of the specified SharePoint Column in Field Type drop down 110 ji al Specify condition to app
130. ile name to export versions Macro Sample Value FileName TestDocument ListName Shared Documents Timestamp 20120220 114607 VersionNumber 1 Result _ lt FileName gt _v lt VersionNumber gt 224 You can use the available macros to construct the new file name in the Result textbox 4 Click Next to proceed For Latest Version Only option in the Export Versions you have the option to export the latest file version to the root folder or export it to the respective version folder The File Version Handling settings appear as shown below CD 1 pct T ack z Wizar pol c z p p Tas E Step Number Version Options Specify the list item versions to export By default latest version of the list item will be exported Export Versions All versions Export version range C Export version date range tart 20 Feb 12 End 20 Feb 12 C Export major versions only Latest version only File Version Handling Store latest version in root folder C Store latest version to a version folder named as v lt VersionNumber gt a Store latest version in root folder Export the latest version in the root folder itself b Store latest version in the respective version folder Creates a latest version folder and export the latest file version in the latest version folder 225 5 1 7 Permission Options SPListX can export SharePoint site list list item permission information to the metadata file This featu
131. ill automatically run Windows Installer program to remove SPListX application from the machine if you have selected the cleanup option Uninstall SPListX application in the wizard 294
132. ill narrow down the search results returned to search query It can be either shared Farm level or locally defined Site level Scopes can be defined by specifying different rules using custom metadata on content source Note Enable Advanced Search in SharePoint to avail this feature 3 Click button to add the SharePoint managed properties in properties dropdown The Add Managed Properties Dialog as shown below 213 Specify the managed property name in Name textbox and select the data type of the column in SharePoint from Type drop down Before adding managed properties Please ensure the followings 1 Specified managed property exists in Shared Services Provider ii Data type matches exactly Click Add button to add the managed property to the property drop down Click Remove button to remove the columns from the property drop down You can specify the conditions by selecting the property name and by specifying a corresponding value with the necessary operator You can use mathematical operators such as gt gt etc to define your query Complex queries can be constructed by using logical operator AND or OR Dl t Taol Aea SPListX Task Wizard Step Number Search Conditions This wizard helps you manage the export task settings All of these words Share Point Any of these words The Exact phrase None of these words Result Type All Results Scope Narrow the search Property Author
133. int library to the NTFS file system In a FAT file system the last modified date alone will be retained from SharePoint library When document packaging option is selected the created date alone will be retained from the SharePoint library V Retain created date V Retain modified date Cet Gea a Do not overwrite the existing file Skips the file without overwriting the existing file with the same name b Overwrite the existing file Deletes the file from the destination location and exports the current source file c Rename the new file that is currently exported from SharePoint Rename the file based on the file name mask specified in the Alternate File Name Mask text box To select alternate file naming mask click the alternate file name mask button placed next to the alternate file name mask textbox 132 Alternate file name mask dialog appears as shown below Select macros to be used as alternate file name mask Result _ lt FileName gt lt Index gt Lx Construct alternate file naming mask with the available macros provided in the dialog Click OK to close the dialog The new files will be exported in the name format syntax entered in the file naming mask 133 2 File System Date Settings TO propagate the system date fields Created Date and Last Modified Date to respective folders and files in the file system follow the steps outlined below SPListX Task Wizard Batch Step
134. istory folder Activity log file e g lt Application Data Folder gt SPListX TaskHistory SPListX Task 20130123 183919 logs ActivityLog txt Error log file e g lt Application Data Folder gt SPListX TaskHistory SPListX Task 20130123 183919 logs ActivityErrors txt Metadata log file e g lt Application Data Folder gt SPListX TaskHistory SPListX Task 20130123 183919 logs MetadataErrors txt SPListX error log file e g lt Application Data Folder gt SPListX TaskHistory SPListX Task 20130123 183919 logs SPListXErrorLog txt Task settings file e g lt Application Data Folder gt SPListX TaskHistory SPListX Task 20130123 183919 settings Details xml Library settings file e g lt Application Data Folder gt SPListX TaskHistory SPListX Task 20130123 183919 settings LibrarySettings xml Process details file e g lt Application Data Folder gt SPListX TaskHistory SPListX Task 20130123 183919 settings ListItemProcessCount xml NOTE The lt Application Data Folder gt is the common area where SPListX tasks and task history will be stored in the machine running SPListX application The lt Application Data Folder gt can be found from the Help gt About screen The default path of lt Application Data Folder gt is as follows gt gt Windows Server 2003 C Documents and Settings All Users Documents Windows 8 7 Windows Server 2012 2008 C Users Public Documents 290 6 3 How to Uninstall SPListX W
135. item file option SPListX creates the metadata file using the Item name Specify metadata file name Macro Sample Value File Extension ttt Current Date 20151212 Current DateTime 20151212 143333 SUID 2a lazbd827a64997b 1507686f55d Item ID 1 Item Name File Name List of features in SPList List Name Shared Documents Title SPList Feature List View Name All Documents Extension if applicable File Name lt Item Name File Name gt _ lt View Name gt Construct metadata file name with the available built in macros provided in the dialog Click OK to close the dialog The file name will be created in the name format syntax entered in the dialog Note ViewName macro is applicable only for View based export SPListX will substitute the name of the processed view wherever applicable In view based export For list library entries and for files folders within them it appends the view name For file folder entries provided for export it appends All Items instead of the view name e g List of features in SPListX_All Items xlsx 6 Specify the Metadata file format using the options below CSV XSLX XML XML with DTD anov 7 If the metadata file already exists in the destination location choose from any one of the following options a Overwrite This option will overwrite the existing metadata file b Append This option will append the new metadata to the existing metadata file
136. ition will be marked for export Export list items if the above conditions are not satisfied Lists that do not satisfy the condition will be marked for export e Folder Level Conditions Click Folder level filter to specify the conditions The Folder Export Conditions Dialog appears as shown below n Specify rule that must be satisfied before exporting item from SharePoint For example you can export folder only when Created By john doe h esi YI el kI XIa Export list items if the above condition is satisfied C not satisfied f Click button to add the SharePoint columns in Field Name dropdown The Add Fields Dialog appears as shown below Add Fields Dialog rx Name Type Text Column Type Text Date of join DateTime Authorized by User Specify the column name in Name textbox and select the data type of the column in SharePoint from Type drop down Click Add button to add the columns to the fieldname dropdown list Click Remove button to remove the columns from the fieldname dropdown list You can specify the export conditions by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such lt gt to define your query Complex queries can be constructed with the use of left right parenthesis and and logical operators AND and OR Folder Export Condition Specify rule that must be satisfied before e
137. iven credential will be used to connect to the SharePoint site 4 y i on n as v a Whit task gt Nalter on 1 ee ee ee eee Provide user credentials to connect to SharePoint Connect to SharePoint using the specified user credentials SPListX will initiate Windows authentication or Forms authentication depending on configuration in the target SharePoint site URL http rd21 8001 User Name VSSLAB aaron kas Giohndoe contoso com contoso johndoe johndoe Password Seeeeeeeseeseeees a Gee 5 The current process of task will be reported in a new dialog as shown below Spl Ta Soest a Thursday December 13 2012 12 16 41 PM Exporting file http rd90 8000 Freigegebene Dokumente 2004 Annual doc a C Users Public Documents SPListX Export 20121213 121643 Freigegebene Destination Dokumente 2004 Annual doc Overall Progress Number of items to process 1 Number of items processed 0of1 Total size processed in KB 28 Total items processed 0 folders 1 items Elapsed Time 00 00 00 15 27 Runtime Statistics a b c d e Number of items to process Shows the total number of line items to process in the current export task This represents the number of items selected by the user in the browse mode or number of line items to process in the batch file Number of items processed Shows the number of line items that have been processed at any given instance
138. l 78 2 The SPListX Task Wizard appears as shown below 5 Wiz e Step Number Welcome to SPListX Task Wizard This wizard helps you manage the export of SharePoint list contents to the file system along with its associated metadata Export Option Export list contents and metadata Export SharePoint list contents folders files list item attachments and its associated metadata to the local file system or network share Export list contents physical files only Export SharePoint list contents folders files list item attachments to the local file system or network share Metadata will not be exported Export metadata only 3 4 5 6 7 8 9 Export metadata for SharePoint list items to the local file system or network share Physical files or attachment files will not be exported Click Next button Specify the SharePoint source location Add Folders and items to export Specify List View Options Specify Version Options Specify Permission Options Specify Export Conditions 10 Specify Document Packaging Options 11 Add Destination Folder Option 12 Specify File Settings 13 Specify Metadata File Settings 14 Specify Task Settings 15 Click Finish button to create the task or click Back button to change the task settings 79 3 1 1 Export Options You can create a task to export folders files list items including attachments along with their metadata from
139. lackcaps Export Location C Users Public Documents SPList Export Documents List items to export Source http vm sp2013 3 vyapin Lists TeamList 4_ 000 http vm sp2013 8 vyapin Lists TeamList 3_ 000 http vm sp2013 8 vyapin Lists TeamList _ 000 http fvm sp2013 8 vyapin Lists TeamList 1_ 000 z harvester farmadmin Go z Mw Bun my go D j Created By System Account System Account System Account System Account System Account System Account System Account System Account System Account 2 Advanced Search Created 5 6 2015 2 16 PM 5 6 2015 2 15 PM 5 6 2015 2 15 PM 5 6 2015 2 14PM 5 6 2015 2 14PM 5 6 2015 2 14PM Si Home PF Up yy Add to Favorites Refresh E List Views VF Filter 7 E Add to Favorites Change Export Location gt lt Remove a2 Remove All Title C Users Public Documents SPListX Export C Users Public Documents SPListx Export C Users Public Documents 5PListx Export C Users Public Documents SPListx Export Calnarians You can also enhance your keyword search by specifying Managed Property with value in keyword search textbox 88 Select items to export Select folders list items to export Use Ctrl key to select multiple items Select destination folder location and dick Export button to export items Click Remove button to remove selected items from export Press F5 to refresh treeview z harvester farmadmin Go Source http ven sp20135 8
140. les and stored in a folder location that is constructed using the list name and its corresponding GUID An XML file is created using the metadata filename specified by the user in the stated metadata file location When you click the XML file the text files in the folder are re grouped using the DTD file to form a single XML file 4 1 12 Task Settings To specify the task name and schedule settings follow the instructions given below Please note that the task options will change depending on whether you are using Windows Forms authentication or Web Single Sign on credentials to connect to SharePoint 1 The Task Settings step appears as shown below SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Category C Blank Description Task Option Connect to SharePoint As Run later D This user VYAPINLAB kevin Manage Profile Run now Schedule Prompt me for user context at task run time Finish Cancel 2 Enter a unique task name in Task Name textbox 3 Select a Category from the Drop Down List in which the task should be categorized amp stored 4 Enter a Description for the export task 5 Select a Task Option from one of the following options a Run later to run the task later as and when desired b Run now to run the task immediately after clicking Finish button c Schedule to create a
141. list items induding attachments along with metadata from SharePoint list to file system based on SharePoint Search results Lx a Create a task to Export SharePoint List contents using the browse option b Create a task to Export SharePoint List contents using a batch descriptor file c Create a task to Export SharePoint List contents using the search option 20 2 4 Edit an existing task Edit Task To edit an existing task 1 Select a task in the Task List pane 2 Click Edit Task from SPListX main screen Edit Task Or Select Edit Task from Task menu C New Task Ctrl N 7I Edit Task Ctrl E Copy Task Ctrl C fi Delete Task Del Create Windows Task G Run Now Ctrl R Exit Ctrl Q Or Press CtrI E 3 SPListX Task Wizard will load the selected task settings and appears as seen in Create New Task wizard However some of the options may be disabled when editing a task a Edit Export SharePoint List contents using the browse option b Edit Export SharePoint List contents using a batch descriptor file c Edit Export SharePoint List contents using the search option 21 2 5 Copy an existing task To copy or create a new task from an existing SPListX export task 1 Select a task from the Task List pane Show Categories AllTasks Task Name _ Description Created Modfed Total Items Processed Total Data Transferred Settings a P Metadata export tasks P
142. ll be used globally within SPListX application 1 Select Proxy Server Settings from Tools menu Profile Manager Metadata Format Template Active Directory Profile Manager File Share Manager Manage Favorites Manage Categories Web Single Sign on Dashboard Proxy Settings Cleanup History View Activity Log Remove Activity Log 2 The Proxy Server Settings dialog will be shown as below 64 SPList can store proxy settings and credential to access SharePoint sites Proxy Settings Do not use proxy server Use IE proxy settings Use manual proxy settings Proxy Server Exceptions Use semicolons to separate entries _ Bypass proxy server for local addresses Proxy Credential Use currently logged on user credential 6 Use specific credential Cw 65 3 Specify Proxy Server Settings to use a Do not use proxy server This option will not use the proxy settings to connect to the SharePoint server b Use IE proxy settings This option will use the Default Proxy Settings used by Internet Explorer IE c Use manual proxy settings The proxy server specified in this option will be used by SPListX to connect to the SharePoint server Enter the Address Port and Exceptions list as you do in Internet Explorer to specify the proxy settings d Bypass proxy server for local address This option controls whether requests for resources o
143. llaboration gt Archive list contents to comply with retention policies gt Archive old document versions amp their metadata for regulatory compliance gt Backup SharePoint contents regularly for disaster recovery amp restore procedures if required gt Migrate documents amp metadata to another DMS ECM application gt Perform in depth analysis of metadata in MS Excel gt Perform the export process based on the line entries in the batch descriptor file gt Export files list items and attachments based on SharePoint search results Key Advantages gt Simple solution to export folders documents along with their associated metadata from SharePoint document libraries gt Export list items along with their file attachments from SharePoint lists such as Tasks Calendar Contacts Survey Discussion Boards Announcements Links Issue Tracking and Custom Lists gt Export from multiple SharePoint lists to file server network shares local computer gt Maintain source folder structure and version history when exporting data from the SharePoint list document library gt Export list items documents pictures based on user defined data filters constructed based on SharePoint columns gt Automate export tasks through command line or Windows Task Scheduler interface gt Propagate original Created Date amp Last Modified Date in SharePoint to the Windows File System fields for each
144. low SPListX Task Wizard Batch Eo lt n Step Number File Settings Use the option below to manage file duplicates in the Windows File System You can also propagate Created Date and Last Modified Date fields from SharePoint Library to the Windows File System If the file with the same name already exists in the destination location C Do not overwrite the existing file C Overwrite the existing file Rename the new file that is currently exported from SharePoint Alternate File Name Mask lt FileName gt lt Index gt a You can propagate original created date and last modified date for folders and files from SharePoint library to the NTFS file system In a FAT file system the last modified date alone will be retained from SharePoint library When document packaging option is selected the created date alone will be retained from the SharePoint library Retain created date Retain modified date Select File System Date Settings The date options given below will assign the respective data field values in the file system as in the original SharePoint list a Retain created date Carry forward propagate Created Date field from the source folders files and list item attachments to the Windows file system b Retain modified date Carry forward propagate Last Modified Date field from the source folders files and list item attachments to the Windows file system NOTE You can propagate original Create
145. ly at the folder level For example you can export folders when Created By John Doe Property Field Type Operator Value Connector e You can specify the export filters by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed with the use of logical operators AND and OR Click E3 to add multiple filters Click to remove the filter from the filter list Click Clear to remove all the filters specified x eee i Specify condition to apply at the folder level For example you can export folders when Created By John Doe Property Field Type Operator Value Connector Fodername gt F PoectDetat Modified By a User KenH Wang 111 SPListX will export the folders that satisfy the export condition depending on the option selected by the user f File or Item Level Filters Click File or Item Level to specify the filters The File or Item Level Filter dialog appears as below File or Item Level Filter Specify condition to apply at the file or item level induding custom metadata For example you can export files or items when Company Name Contoso Property Field Type Operator Value Connector ac You can specify the export filters by selecting the field name and by specifying a value with necessary operator You c
146. m Level Filters Click File or Item Level to specify the filters The File or Item Level Filter dialog appears as below File or Item Level Filter Spedfy condition to apply at the file or item level induding custom metadata For example you can export files or items when Company Name Contoso Property Field Type Operator Value Connector ac You can specify the export filters by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed with the use of logical operators AND and OR Click to add multiple filters Click to remove the filter from the filter list Click Clear to remove all the filters specified 234 Specify condition to apply at the file or item level induding custom metadata For example you can export files or items wh Company Name Contoso SPListX will export the folders that satisfy the export condition depending on the option selected by the user ADVANCED Step 6 of 11 Export Conditions Specify export conditions for site list folders and or file to filter the contents F BASIC ADVANCED 235 You can specify export conditions at three levels Site Level Filter List Level Filter Folder Level Filter File or Item Level Filter a Site Level Conditions Click Site level filter to specify the conditions The Site Export Co
147. mList 5_ 000 C Users Public Documents SPListx Export Stems If advanced search is enabled in SharePoint site then you can perform advanced search by clicking Advanced search link 89 The Advanced Search dialog appears as shown below Click button to add the SharePoint managed properties in properties drop down The Add Managed Properties dialog appears as shown below 90 Specify the managed property name in Name textbox and select the data type of the column in SharePoint in the Type drop down Click Add button to add the managed property to the property drop down Click Remove button to remove the columns from the property drop down You can specify the conditions by selecting the property name and by specifying a corresponding value with the necessary operator You can use mathematical operators such as gt gt etc to define your query Complex queries can be constructed by using logical operator AND or OR Advanced Search Find documents with All of these words SharePoint Any of these words Welcome Exact phrase None of these words Result Type Scope Narrow search Properties Operator Value Property restrictions Author ken You can Tune search by clicking Search Tuner button 91 The Search Tuner dialog appears as shown below a b d Search Tuner By default search will start from current site and its content
148. mask Specify file name to export versions Macro Sample Value FileName TestDocument ListWame Shared Documents Timestamp 20120220 114607 VersionNumber 1 File Name lt FileName gt _v lt VersionNumber gt You can use the available macros to construct the new file name in the Result textbox 4 Click Next to proceed For Latest Version Only option in the Export Versions you have the option to export the latest file version to the root folder or export it to the respective version folder The File Version Handling settings appear as shown below SPList Task Wizard Sample Task Step Number Version Options Specify the list item versions to export By default all versions of the list item will be exported Export Versions All versions Export version range Export version date range art 20 Feb 12 id 20 Feb 12 Export major versions only Latest version only Ale Version Handling Libraries only Store latest version in root folder O Store latest version to a version folder named as v lt VersionNumber gt a Store latest version in root folder Export the latest version in the root folder itself b Store latest version in the respective version folder Creates a latest version folder and export the latest file version in the latest version folder 4 1 6 Permission Options SPListX can export SharePoint site list list item permission information to the metadata file T
149. me to process SharePoint maintained read only columns lt Back Next gt b Default View Exports all items including folders available in the Default view of the given SharePoint list The SharePoint columns defined in the default view will be exported to the metadata file c d All Views Exports all Views in the SharePoint list The SharePoint columns defined in the respective list views will be exported to the metadata file Specific Views Exports views that are specified in the textbox The SharePoint columns defined in the respective list views will be exported to the metadata file Note ViewName macro is applicable only for View based export SPListX will substitute the name of the processed view wherever applicable In view based export Content export For list library entries it creates a new folder with the view name under the list library name folder in the specified destination location For file folder entries provided for export it exports the content in the specified export location Metadata export For list library entries and for files folders within them it exports metadata for columns present in the view For file folder entries provided for export it exports metadata for all columns including SharePoint maintained read only columns instead of the view based columns SPList Task Wizard FileEntries Step 3 of 11 List View Options Export list i
150. mise or SharePoint Online using the federated identity account configured using ADFS Select this option to connect to Office 365 SharePoint Online sites that are configured using federated identity provider SPListX Task Wizard Step Number Batch descriptor file Specify batch descriptor file to use in order to export folders list items and its associated metadata to the local file system or network share Specify user credential to connect to SharePoint when running the export task File Name C Wsers Public Documents SPListX Batch File csv man Clear 29 row s Authentication Windows User Name vssiab andrew hd johndoe contoso com contoso johndoe johndoe 7 Click Next to Proceed 4 1 4 List View Options You can export list items or documents based on SharePoint List views and thereby specify the SharePoint columns to export metadata To selectively export SharePoint Views from the list library follow the steps outlined below 1 The List View Options wizard step appears as shown below SPList Task Wizard FileEntries Step 3 of 11 List View Options Export list items documents based on SharePoint List Views View Settings All items in the List View Allitems aspx Select Columns to export Default View All Views 9 Specific Views Columns to export Export all columns jj Export all user defined columns P Export
151. ms Click Remove button to remove selected items from export Press F5 to refresh treeview Source http vm sp2013 8 vyapin harvester farmadmin Go Folder Advanced Search ff vyapin 5 objects selected Home P Up g Add to Favorites 2 Refresh E List Views WY Filter E Composed Looks ES CustomListVerification Name DocumentLibraryForSharePoint gui Planet Documents 53 Composed Looks G Galaxy ES customListVerification as ey S DocumentlibraryForSharePoint MicroFeed Be Documents 5 D Master Page Gallery cogil k Mnre T Rit Ea Site Assets Site Pages h TaskList Ealsite TaskList Location 3 C User ocuments SPLIstx Export Export Users Public Documents SPListX Expor Ly pont E Add to Favorites BAe a E H amp E E I Documents List items to export Change Export Location gt lt Remove 2 Remove All Source Destination Title http vm sp2013 8 vyapin _catalogs design C Users Public Documents SPListX Export Composed Looks http vm sp2013 8 vyapin Lists CustomListVerification C Users Public Documents SPListX Export CustomListVerification http vm sp2013 8 vyapin DocumentLibraryForSharePoi C Users Public Documents SPList Export DocumentLibraryForSharePoint http vm sp2013 8 vyapin Shared Documents C Users Public Documents SPListX Export Documents http vm sp2013 8 vyapin _catalogs masterpage C Users Public Documents SPListx Export Master Page
152. n is satisfied not satisfied c You can specify the export conditions by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such lt gt to define your query Complex queries can be constructed with the use of left right parenthesis and and logical operators AND and OR 239 T reep eee er mx se SC EXDC i YITIC Specify rule that must be satisfied before exporting item from SharePoint For example you can export list only when List Type Document Library Feld Name operator Eoo value HER EMANAN Base Type Document Library Export list items if the above condition is satisfied not satisfied d SPListX will export the lists that satisfy the export condition or export the lists that do not satisfy the export condition depending on the option selected by the user Export list items if the above conditions are satisfied Lists that satisfy the condition will be marked for export Export list items if the above conditions are not satisfied Lists that do not satisfy the condition will be marked for export 240 d Folder Level Conditions Click Folder level filter to specify the conditions The Folder Export Conditions Dialog appears as shown below am Specify rule that must be satisfied before exporting item from SharePoint For example you can export folder only when Created By j
153. n the LAN are sent to the proxy server or sent directly to the host where the resource resides Proxy Server Settings SPListX can store proxy settings and credential to access SharePoint sites Proxy Settings Do not use proxy server Use IE proxy settings Use manual proxy settings Proxy Server Address 10 10 10 10 Port 8080 Exceptions google Use semicolons to separate entries Bypass proxy server for local addresses Proxy Credential Use currently logged on user credential Use specific credential 66 4 Select Proxy Credential to use when connecting to the proxy server and request authorization to connect to the SharePoint server mes SPListX can store proxy settings and credential to access SharePoint sites Proxy Settings Do not use proxy server Use IE proxy settings Use manual proxy settings Proxy Server Address 10 10 10 10 Port 8080 Exceptions google Use semicolons to separate entries Bypass proxy server for local addresses Proxy Credential C Use currently logged on user credential Use specific credential Profle Name es a Use currently logged on user credential This option will use the currently logged on user account to connect to the proxy server and request authorization to connect to the resource b Use specific credential You can specify a different user credential which is stored in Windows Credential Man
154. n the selected file format into the respective list folder locations where the physical documents files are exported 3 4 NOTE Ensure that the user context used to run the SPListX export process has sufficient permissions to create edit and delete folders and files in the specified export path Specify the Metadata file options using the options below c Create a metadata file for each list library This option will export the metadata for the entire list library in a single file d Create metadata file for each list item file This option will export separate metadata file for each list item or file When you select Create a metadata file for each list library option SPListX creates the metadata file using the List name To create a unique metadata file name click the button placed next to the metadata file name textbox Metadata file name dialog appears as shown below Metadata file name Specify metadata file name Macro Sample Value Current Date 20151212 Current Date Time 20151212 143605 File Index 1 SUID 2a lazbd827a64997b 1507686f55d List Name Shared Documents View Name All Documents File Name lt List Name gt _ lt View Name gt Construct metadata file name with the available built in macros provided in the dialog Click OK to close the dialog The file name will be created in the name format syntax entered in the dialog 5 When you select Create metadata file for each list
155. nal description for this Property name property Description Type Type of information that is stored in this The type of information in this property property m Text m Integer m Decimal Date and Time mM Yes No Double precision float M Binary Main characteristics Searchable Enables querying against the content of the Searchable managed property The content of this managed property is included in the full text index For example if the property is author a simple query for Smith returns items containing the word Smith and items whose author nronerty contains Smith Queryable Enables querying against the specific managed Queryable property The managed property field name must be included in the query either specified in the query itself or included in the query programmatically f the managed property is author the query must contain author Smith Retrievable Enables the content of this managed property Retrievable to be returned in search results Enable this setting for managed properties that are relevant to present in search results Allow multiple values r Allow multiple values of the same type in this Allow multiple values managed property For example if this is the author managed property and a document has multiple authors each author name will be stored as a separate value in this managed property Refinable Yes active Enables using the property as a Refinable Yes a
156. nd its versions based on version export option in a single compressed file Libraries only _ File attachments stores each list item s attachments in a single compressed file Lists only I Document sets This option will package all files stored in the document sets into a single compressed file The package is created in the same name as the document set il Documents and its versions This option will package the documents and its associated versions into a single compressed file The package is created in the Same name as original document or file The document s versions are exported into the created package based on the settings specified in Versions Settings wizard step iii File Attachments This option will package each list item s attachment s into a single compressed file The compressed package is created in the name of listitem ID 3 Click Next to Proceed 128 3 1 9 Destination Folder Options SPListX will create destination folders based on the following options given below 1 The Destination Folder options specification wizard step appears as shown below SPListX Task Wizard FolderHierarchy Step 8 of 11 Destination Folder Options Specify folders settings to use when creating folders in file system Do you want to create current timestamp folder under destination location Do you want to create the top4evel folder s induded for export Do you want to create destination folder path i
157. nditions Dialog appears as shown below 236 site Export Condition Export site if the above condition is satisfied not satisfied You can specify the export conditions by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such lt gt to define your query Complex queries can be constructed with the use of left right parenthesis and and logical operators AND and OR 237 _ Site Export Condition Specify rule that must be satisfied before exporting site from SharePoint Vyapin Add to Filter Export site if the above condition is satisfied not satisfied SPListX will export the sites that satisfy the export condition or export the sites that do not satisfy the export condition depending on the option selected by the user Export sites if the above conditions are satisfied Sites that satisfy the condition will be marked for export Export sites if the above conditions are not satisfied Sites that do not satisfy the condition will be marked for export b List Level Conditions Click List level filter to specify the conditions The List Export Conditions Dialog appears as shown below 238 LIST CXDONM TLONaIic Specify rule that must be satisfied before exporting item from SharePoint For example you can export list only when List Type Document Library pede Coo Export list items if the above conditio
158. ning page In addition to exact match it will bring back matches on pages paged and paging 5 How to enable stemming in MOSS 2007 gt Go to the search page enter any query to return the search results page For ex enter keyword sharepoint in anykeywords text box Under Site Actions select Edit page Locate the Search Core Results web part usually in the bottom zone From the Edit button select Modify shared web part Vv V V WV In the task pane that appears on the right hand side under Results Query Options select Enable Search Term Stemming checkbox NOTE If stemming is switched on it will increase your index size and potentially impact search performance 6 What is meant by Trimming Duplicate Search Results To specify whether duplicate list item URLs should be removed from search results 7 How to view duplicate search results in MOSS 2007 gt Go to the search page enter any query to return the search results page For example enter keyword sharepoint in any keywords text box Under Site Actions select Edit page Locate the Search Core Results web part usually in the bottom zone From the Edit button select Modify shared web part Vv V WV WV In the task pane that appears on the right hand side under Results Query Options check the box labelled Remove Duplicate Results 276 5 3 How to Create Batch File Using Search R
159. ns that are created by a SharePoint user gt Export selected columns Exports columns that are specified in the textbox 220 Step Number Column Settings Options Specify the SharePoint columns you wish to export By default all user defined SharePoint columns will be exported Do not export columns Export all columns ij Export all user defined columns ji Export selected columns Title Created By Approval Status bi Enter one column name per line Ensure the column name entered here exactly matches the display name of the SharePoint column Click Next to Proceed 221 5 1 6 Version Options To selectively export list item versions to the destination file system location 1 The Version Options step appears as shown below SPList amp Task Wizard Sample Task Step Number Version Options Specify the list item versions to export By default all versions of the list item will be exported Export Versions All versions Export version range Export version date range art 20 Feb 12 i 20 Feb 12 E Export major versions only Latest version only Ale Version Handling Libraries only Export each file version to a version folder named as v lt VersionNumber gt Store latest version in root folder 0 Store latest version in the respective version folder Export each file version as separate files named as lt FileName gt _wv lt VersionNumber gt
160. nt Administrator before performing any changes to your SharePoint production environment Protocol handler that crawls the SharePoint content will not populate ows_created_x0020 Date Text crawled property 1 How to map CreatedDate field to crawled field gt Open Central Administration in the Application Management section and click Manage service applications gt Click the Search service application for which you are viewing managed and crawled properties gt On the Search Administration page in the Quick Launch under Queries and Results click Search Schema On the Metadata Property Mappings page click New Managed Property On the New Managed Property page in the Property name box in the Name and type section type the name of the new managed property gt Inthe Description box type a description of the property Under The type of information in this property select one of the following options for the property gt Under The type of information in this property Text type gt Check Queryable Retrievable Refinable properties gt Inthe Mappings to crawled properties section select Include content from the first crawled property that is not empty based on the specified order gt Click Ok 268 Use this page to view create or modity the settings of this managed property Note that the settings that you can adjust depend on your current authorization level Name and description Name and optio
161. nts list items C Export all documents list items Exclude folder structure Store dassify items based on new folder hierarchy New folder name nf o Select any one of the following options given below to specify the contents to be exported from the source folders in SharePoint a Export all folders and documents list items This option exports folders and documents list items exactly as they are in source SharePoint 94 list library The source folder structure in the list library will be retained in the destination location b Export documents list items at the top level Exclude sub folders This option exports documents list items available in the top level folders only SPListX will not traverse the sub folders within the top level folders i e will not export list items documents located in the sub folders c Export folder hierarchy Exclude documents list items This option creates the sub folder structure alone in the destination location and ignores all documents list items that are available within the added top level folder and sub folders d Export all documents list items Exclude folder structure This option exports documents list items alone and ignores the folder structure in the source list library In case of duplicate file names files gets exported based on the settings specified in File Settings wizard step Store classify items based on new folder hier
162. o SharePoint ie Provide user credentials to connect to SharePoint Connect to SharePoint using the specified user credentials SPListX will initiate Windows authentication or Forms authentication depending on configuration in the target SharePoint site URL https vyapin sharepoint com Authentication User Name VSSLAB farmadmin_sp 10 1 amm Gjohndoe G contoso com contoso johndoe johndoe Password Seeeeeeereeeeeeeee c Click Search button to perform search 279 Trial search tool will help you perform a live search to verify the search results Signin as gore vyapin onmicrosoft com v 8 objects 44 Back 1 Title Path Modified Date t31 1 2fgg https vyapin sharepoint 08 Feb 12 11 45 47 AM TestingFiledfgf https vyapin sharepoint 08 Feb 12 11 38 51 AM 4 Team Site How To Use https vyapin sharepoint 06 Oct 11 1 47 50 PM Get Started with Micros https vyapin sharepoint 06 Oct 11 1 47 50 PM fadfafdafgh https vyapin sharepoint 08 Feb 12 11 48 28 AM confusding task https vyapin sharepoint 06 Feb 12 12 10 12 PM is SPListX_customer_feed https vyapin sharepoint 29 Nov 11 8 43 22 AM ver 2 idsdg https vyapin sharepoint 08 Feb 12 11 40 20 AM Note Double click on results to launch the URL in your browser Click Save Results button to save the search results 280 gt The Save As dialog appears as shown below lt lt lt A
163. oe contoso com noprompt To execute multiple SPListX tasks simultaneously Start cmd C Program Files SPListX SPListXTaskRunner Sample Task1 u voyager user1 p ctest1 noprompt Start cmd C Program Files SPListX SPListXTaskRunner Sample Task2 u voyager user2 p ctest2 noprompt 32 2 9 Create Windows Task Use this tool to create a Windows Task automatically run the export tasks at scheduled intervals in Windows Task Scheduler interface to This tool helps you to re create the Windows Schedule Task in the following two scenarios 1 To create Windows Schedule Task that was accidentally deleted and is required to be created again with the same schedule settings To create Windows Schedule Task when the SPListX export tasks are migrated from an old machine to a new machine Select a task from the Task List pane Show Categories All Tasks Task Name E Metadata export tasks Page Library Aerobics Documents Everest Master page galery a C Library Documents E E View Export E AllVersions a E Lists m E Important Documents a E Wiki a E Contacts a Qi oud m p Latest Versions Blank Description Images Contents are moved to the Shared Documents Created 6 9 2015 4 49 05 PM 6 9 2015 4 39 35 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 47 56 PM Modified 6 9 2015 4 49 05 PM 6 9 2015 4 40 12 PM 6 9 2015 4 47 08 PM 6 9 2015 4 46 42 PM 6 9
164. of 12 Destination Folder Options Specify folders settings to use when creating folders in file system Do you want to create current timestamp folder under destination location Do you want to create destination folder path if it does not exist Do you want to create the folder underneath when its contents are empty Do you want to create separate folder for storing file attachments Attachment Folder Tag Attachment_ lt ItemID gt _ lt ItemName gt Search Folder Tag lt ContentType gt 2 Select from the following options a b Do you want to create current timestamp folder under destination location This option creates timestamp folder under the specified destination location This option may be useful when scheduling the export process or when repeated exporting contents to the same destination location Select the appropriate option to create the timestamp folder by selecting the option Yes No Do you want to create top level folder s included for export The top level folder is the folder added or specified for export by the user SPListX will commence the export process from this top level folder Select the appropriate option to create the top level folder by selecting the option Yes No 251 3 c Do you want to create destination folder path if it does not exist This option creates the full folder path in the destination location if the specified path is not available in the specified location
165. ohn doe same CoO oe we E i Oelk xla Export list items if the above condition is satisfied not satisfied OK 241 e Click button to add the SharePoint columns in Field Name dropdown The Add Fields Dialog appears as shown below Add Fields Dialog Name Column Name Column Type Destination Text Date of join DateTime Authorized by Specify the column name in Name textbox and select the data type of the column in SharePoint from Type drop down Click Add button to add the columns to the fieldname dropdown list Click Remove button to remove the columns from the fieldname dropdown list f You can specify the export conditions by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such lt gt to define your query Complex queries can be constructed with the use of left right parenthesis and and logical operators AND and OR 242 Folder Export Condition Specify rule that must be satisfied before exporting item from SharePoint For example you can export folder only when Created By john doe pdnene ge A Operator lt Y Value 01 Jan 12 gr Created Date lt 01 Jan 12 Export list items if the above condition is satisfied not satisfied g SPListX will export the folders that satisfy the export condition or export the folders that do not satisfy the export condition dep
166. okup Product Code 100 l The values can be single or multiple Multiple values should 123 Product Code 123ABC 154XYZ People or Group Document Reviewed by John Doe Document Reviewed by John Doe Jane Doe Incremental Export in SPListX be separated by SPListX exports the list items that have 123ABC and 154XYZ as value for Product Code field User or group values can be given for this field The values can be single or multiple Multiple values should be separated by SPListX exports the list items that have Document Reviewed by value set to John Doe and Jane Doe Apart from relational operators SPListX allows you to construct flexible export conditions by using the Changed operator for periodic import for the fields Created Date SharePoint and Modified Date SharePoint The following built in values can be used for this operator Today Yesterday This Week This Month Last Week Last Month Since Last Update in SharePoint Since Last Export in SPListX Last 7 days and Last 14 days By using Changed operator you can filter the list items based on the above mentioned values from SharePoint list For example if you need to migrate list items that are modified in SharePoint today you can specify an export condition as stated below Modified Date Changed Today Operator amp Value Description An Example Result Remarks Exports list items th
167. on cccceeeeeee eee e eee eeeeeeees 203 SAC POOL e bask E tec Mead nenss mie neus Weaenens E TE E PET EO TE EE PEET ET 204 5 1 1 Create Search Batch Descriptor File Error Bookmark not defined 5 1 2 SharePoint User Credential cccceeeee eee eeeeeees Error Bookmark not defined Dlha SECM URE So CLUINGS rroia a aaa dee ted soy aa aa temas bedded an 210 Sede oea CA COMICON S aA A E E ntacesutncavanat nia 212 DL CHUMI Sertas 10 d 0 camer ener eee en A NEET EE 220 SLOVOM OPUN S saeara e de thats o a a eta ee ea nd oe ee 222 Diels A PENMISSIOD ODUONS sie tien ave dna anata ete dwa tan ete A a A tedden ete owed 226 orl oi 010 ge CONGOS eRe eR re Na pene een nn no en oe ne errr 229 5 1 9 Document Packaging Options ccc cece cece eee eeeeeeee eee e eee eeeeeeeeeeaaaaanee 249 SALLO Destination Folder ODUONS S riusci Cored tovenemeeaweraae tens 251 Sak EFIE SCENO Senia A A 254 5 a2 Metadata Fle SENOS erene A A E A 257 Bo helio TASK SCUINGS arii a AAE AA ANAE T AE a 262 5 2 Working With SharePoint Search ResultS sssssssssssnssssssnnssrnnssrnnesrsnesnsnene 267 5 23 SharePoint 2013 SeCarcn RESUINS erouani RE 268 5 2 2 SharePoint 2010 Search RESUS asrorini ini n E E AA A E 271 523 onarePoint 2007 Search RESUS caera naian sa a a a a a tials 274 5 3 How to Create Batch File Using Search Results sssossssssnnnsrrnnsnrsrrnrerrrrrrrne 277 ORETENCE Surenen e ana aena aa eena e 285 6 FREGU
168. ontrol Limited Access johnsmith Read View Only etc b Role User format Exports permission details as Role User e g Full Control johndoe johnsmith Contributor janedoe etc Inheritance status Export the inheritance status of the Site List List item as a separate column field in the metadata file This column field indicate if the permission is Inherited or Unique role assignment at the Site List List item level in SharePoint Membership information This option exports AD informtion and role definition information to separate XML files These XML files are stored in the same location as the metadata files in the name _membershipinformation and _ roledefinition The user account that connects to SharePoint must have System Account permission to retrieve respective membership information Similarly the user account specified in Active Directory Profile Manager for each domain must have Domain Admin permission to retrieve respective membership information SPListX will 105 enumerate only the globally declared domain groups and retrieve membership information 6 Click Next to Proceed 106 3 1 7 Export Conditions SPListX can export folders files and list items including file attachments from a SharePoint list or library based on certain export conditions The conditions can be created by using SharePoint columns in the source list or library 1 The Export Conditions step appears as shown belo
169. or example a SharePoint column named Area in the source SharePoint list can be customized and renamed as Location when creating the metadata file during the export operation 260 Customize Metadata Format eee Enter column name its type and the format to use when exporting its value to the metadata file You can rename the SharePoint column name when exporting it to the metadata file by providing a new header name below Column Name Area Column Type Geolocation v Format Address roe New Header Name Location Column Name Column Type Format New Header Name Area Geolocation Address Location Note The column s metadata format entered here will override the format specified in the Metadata Format Template Click Ea format list Click list to add the SharePoint column name and its format in the custom metadata to remove t he SharePoint column name from the custom metadata format 10 Click Next to Proceed Note XML File Format SPListX generates an XML file using the filename using the List name and List GUID in the format List Name List GUID to maintain a unique metadata file name in the stated metadata file location with the metadata information XML with DTD SPListX uses Document Type Definition DTD syntax to define the document structure of the XML metadata file This declaration has been introduced primarily to support large XML metadata files minimize memory
170. ort operation 138 Customize Metadata Format sti Enter column name its type and the format to use when exporting its value to the metadata file You can rename the SharePoint column name when exporting it to the metadata file by providing a new header name below Column Name Area Column Type Geolocation r Format Address ra New Header Name Location Column Name Column Type Format New Header Name Area Geolocation Address Location Note The column s metadata format entered here will override the format specified in the Metadata Format Template Click E3 to add the SharePoint column name and its format in the custom metadata format list Click to remove t he SharePoint column name from the custom metadata format list 10 Click Next to Proceed Note XML File Format SPListX generates an XML file using the filename using the List name and List GUID in the format List Name List GUID to maintain a unique metadata file name in the stated metadata file location with the metadata information XML with DTD SPListX uses Document Type Definition DTD syntax to define the document structure of the XML metadata file This declaration has been introduced primarily to support large XML metadata files minimize memory footprint when working with large XML files and improve metadata file throughput XML metadata files are split into multiple text files and stored in a folder location that is constructe
171. ource Path is valid and available Invalid or unavailable source paths will result in this error Ensure that the given source list URL is valid and exists Ensure that the given destination folder location is valid and exists This error may occur when reading a file in SharePoint if the given file is checked out and exclusively locked by another user Ensure that the specified file is not currently in use open by any other application or user Close the file and try again or close and re launch SPListX 287 apticatiion The Microsoft ACE OLEDB 12 0 provider is not registered on the local machine Export Condition failed Ignored Export Condition not satisfied Cannot export the column lt Column name gt values since the column could not be found in the SharePoint List Search Condition failed Cannot export the view lt View name gt values since the view could not be found in the SharePoint List Search Condition failed Unable to export membership information for the following SharePoint Group s lt group list gt Unable to export membership information for the following Domain Group s lt group list gt Ensure that the machine running SPListX has either Microsoft Office 2007 Suite or Office 2007 System Driver Data Connectivity Components installed Ensure that the specified column in export condition exists in the source SharePoint List The list folder list i
172. owse option Create task Export Options SharePoint Source Location Items to Export List View Options Version Options Permission Options Export Conditions Document Packaging Options Destination Folder Options File Settings Metadata File Settings Task Settings 7 3 1 Create Task To create a task to export folders files list items including attachments along with their metadata from SharePoint List to file system or network share 1 Select Export SharePoint List contents using the browse option in SPListX Task Options dialog as shown below and click OK jj m i I GJA i ion boki Select a task type for creating a new task A wizard will guide you through steps to create a task based on the selected Task type im Export SharePoint List contents using the browse option Create a task to export folders files and list items induding attachments along with metadata to the file system by browsing the SharePoint list contents _ Export SharePoint List contents using a batch descriptor file Create a task to export folders files and list items induding attachments along with metadata from SharePoint list to fle system based on the entries in the descriptor file Export SharePoint List contents using the search option Create a task to export folders files and list items including attachments along with metadata from SharePoint list to file system based on SharePoint Search results Lok __gance
173. permissions for Site List List item to the metadata file depending on the user selection Check appropriate checkboxes in Export permission for options Specify the Permission format to use when exporting the permission information for the Site List List item to the metadata file using the options given below a User Role format Exports permission details as User Role e g johndoe Full Control Limited Access johnsmith Read View Only etc b Role User format Exports permission details as Role User e g Full Control johndoe johnsmith Contributor janedoe etc Inheritance status Export the inheritance status of the Site List List item as a separate column field in the metadata file This column field indicate if the permission is Inherited or Unique role assignment at the Site List List item level in SharePoint Membership information This option exports membership and role definition information to separate XML files These XML files are stored in the same location as the metadata files in the name _membershipinformation and _ roledefinition The user account that connects to SharePoint must have System Account permission to retrieve respective membership information Similarly the user account specified in Active Directory Profile Manager for each domain must have Domain Admin permission to retrieve respective membership information Click Next to Proceed 4 1 6 Permission O
174. pletely disconnected untrusted Windows Domain gt Exporting contents using Laptop PC that is not part of the SharePoint domain gt Exporting contents using Forms Based Authentication FBA The stored user profile persists for all subsequent logon sessions on the same computer where SPListX is installed The stored user profiles are visible to other logon sessions on the same computer The stored user profile created by using SPListX Profile Manager is restricted to the Windows user profile context used to create the stored user profile If the Windows User Profile is maintained locally SPListX stored user profile is accessible only by the same user in the same computer If the user who creates SPListX stored user profile has a Roaming user account in the enterprise the SPListX stored user profile can be accessed by the Same user in any computer in the Windows enterprise The stored user profile is a generic credential of Windows Stored User Names and Passwords applet Credential Manager and can be used by SPListX application only The credential information is stored securely in a 256 bit encrypted format in Windows Stored User Names and Passwords applet Credential Manager 1 In order to create a SPListX stored user profile select Profile Manager from Tools menu 39 Metadata Format Template Active Directory Profile Manager File Share Manager Manage Favorites Manage Categories Web Single Sign
175. profile is stored in Windows Stored User Names and Passwords Credential Manager Specify a domain user credential to connect It is recommended to use Administrator Credential to retrieve the members list from the Domain Group SPListX stores the active directory user profile in the local computer and will be accessible only by the user who creates the user profile If the user who creates the active directory user profile has a Roaming user account in the enterprise the stored user profile can be accessed in any computer in the Windows enterprise The stored active directory user profile can be used by SPListX application only The credential information is stored securely in 256 bit encrypted format in Windows Stored User Names and Passwords Credential Manager For scheduled tasks SPListX will use this stored user credential to retrieve Domain Group members from Active Directory 1 Select Active Directory Profile Manager from Tools menu Tools Profile Manager Metadata Format Template File Share Manager Manage Favorites Manage Categories Web Single Sign on Dashboard Proxy Settings A Cleanup History jay View Activity Log X Remove Activity Log 51 2 The Active Directory Profile Manager dialog will be shown as below SPListX can store the user credentials to retrieve domain groups member information from Active Directory domain controllers Click Add button to create
176. ption SPListX can export SharePoint site list list item permission information to the metadata file This feature works only for SharePoint 2010 or later environment 1 The Permission options specification wizard step appears as shown below SPList Task Wizard TestRob1 Step 5 of 11 Permission Options SharePoint 2010 or later only Export site list item permission from SharePoint file to the metadata file t e g jonndee Full Control ao r Eill Or mtra ir m t i a F UH CO T a Ul li LIE 7 Export Permissions a Do not export permissions This option will not export permissions to the metadata file b Export permissions This option will export permissions based on the user specified options The export permission options appears as shown below SPListX Task Wizard Test Rob nnn Step 5 of 11 Permission Options SharePoint 2010 or later only Export site list item permission from SharePoint file to the metadata file Do not export permissions Export permissions Export permissions for Site W List W List item Pennission format User Role format e g johndoe Full Control ri Role User format e g Full Control johndoe ri Inheritance status Export inheritance status as separate column shows if the pemission is Unique or Inherited o Membership infomation V Export AD information and role definition to a separate XML file o lt Back 2 You can
177. r attachment files will not be exported Select the required export options The wizard guides you with the steps accordingly 80 3 1 2 SharePoint source location To specify a SharePoint URL of a site list folder location from which you wish to export folders files and list items including attachments to the file system perform the steps given below 1 The SharePoint source location step appears as shown below SPListX Task Wizard Step Number SharePoint URL and credentials Specify a SharePoint URL of a site list folder location from which you wish to export folders files and list items to file system User account specified below will be used to connect to SharePoint when running the export task URL Add to Favorites Authentication Windows User name vsslab andrew s johndoe contoso com contoso johndoe johndoe Password eeeeeeeeseceosece 2 Specify a valid SharePoint URL in the URL textbox You can specify a SharePoint site list or folder location in the URL textbox SPListX will load the tree view of the source location from the level specified in this textbox 3 Specify the Authentication mechanism and credentials to connect to SharePoint using one of the options described below a Windows or Forms SPListX will initiate Windows or Forms authentication using the user account information stored in the user profile or the one entered in the textbox 81 b Office
178. r location and Click OK The folder location can be local drives Or mapped network drives 5 SPListX provides an option to copy or move the existing SPListX application settings SPListX export task settings task histories activity logs error logs etc to the new location once you change the Application Data Folder Once you specify the new Application Data folder location SPListX will prompt you to copy or move existing SPListX application settings to the new location as shown below The application data folder has been changed to the new folder location successfully Do you want to Copy or Move all application settings and data from the old folder location to the new folder location Click the appropriate button below 6 Click the desired action Copy Move Close to proceed SPListX will use the new Application Data folder location henceforth 18 2 3 Create new Task You can create a task to export folders files list items including attachments along with their metadata from SharePoint list to file system or network share SPListX facilitates exporting files list item attachments and its associated metadata from SharePoint list using the following export methods or task types A Export SharePoint List contents using the browse option Export folders files and list items including attachments along with metadata to the file system by browsing the SharePoint list contents B Export SharePoint List content
179. rMilSSiOlm ODHONS dreia nee tae nate teaud atedeamtan tent ntedan mace teaud a oxads 104 Sp lw el p 018 CONGOS niria ro near heer tea RCs are en Rn oe re een re 107 3 1 8 Document Packaging OPtiOnsS c cece cece eeeeeeeeeeeeee seen eeeeeeeeeeeeaaaaaaaes 127 5 129 DEStination FOIGEmODUONS vougaieranerssstonsadetovenntetoversss Covena torent oererade ters 129 SoA O FIG SOLUINGS ejitacctacine cics chicane ieineeet suited aiubheand A AA 132 3 de bd Metadata File SENGS rieri enestntseus stars wanwtaestecytais enna A eniits 135 hI TASK SENOS ineatacetis ati satura A NE EE AEN AEI AE pees NA 140 4 Export SharePoint List contents using a batch descriptor file ccccceeeeee scene eens 145 A ACC ALC ASK aaea uuniemad E EEE O E T O E neues ence 146 Ai 1 Create Batch DEScriptor Riley aititari Naa aaa E A AA TOAN 148 4123 Batch DescriPOr Filesuriiira mn a sia wanes A A A A aA aaa 153 ATA ESE VALCW OPDUON S cimenter E a a a aa 155 Ado WEESIOM QDEONS nssrensenl a en aa a aen 158 As 6 Permission Pell sciences E eee TE T eee E 164 Ade 7 EXPO CONGILIONS aeniea taeesees tun Geran san mindet noses caaaiaunaananawadees 167 41 8 Document PACKAGING ODUONS x iiiiseniiiieinrsdchadeniaiaiarianiadenl ehaiepiinbaieadlantases 185 Ato Destination IFOIGer ODUONS noirir r a 187 A Mo Olle SENGS riai E E 190 A kT Metadata Fle Setting rai aiea AA a a a 193 AN 2 FaSk SENOS cirea rinii TAEA AEEA AEA 198 5 Export SharePoint List contents using the Search Opti
180. re works only for SharePoint 2010 or later environment 1 The Permission options specification wizard step appears as shown below SPList Task Wizard Testo O i Step 5 of 11 Permission Options SharePoint 2010 or later only Export site list item permission from SharePoint file to the metadata file Do not export permissions E Export permissions Export Permissions a Do not export permissions This option will not export permissions to the metadata file b Export permissions This option will export permissions based on the user specified options 226 The export permission options appear as shown below SPListX Task Wizard TestRob1 Step 5 of 11 Permission Options SharePoint 2010 or later only Export site list item permission from SharePoint file to the metadata file Export Permissions Do not export permissions Export permissions Export permissions for W Site W List W List item Pennission format User Role format e g johndoe Full Control o Role User format e g Full Control johndoe o Inheritance status Export inheritance status as separate column shows if the permission is Unique or Inherited ri Membership information Export AD information and role definition to a separate XML file a lt Back next gt Cancel 2 You can export permissions for Site List List item to the metadata file depending on
181. ritten Summarizes the files overwritten during export process e Errors Summarizes the errors that occurred during export f All Results Summarizes the detailed results of the export task g List Settings Summarizes the destination List Settings at the time of export h Task settings Summarizes the task settings at the time of export 1 Resolution Tips Summarizes the commonly encountered error messages and the ways to address them 5 Click Save Results button 75 The Activity Save dialog appears as shown below Activity Save Dialog Specify export path and select results to export in XLSX format Export Path sal eyes Belen aie eye anns Create folder path if does not exist Tabs Task Statistics Task Results Items Ignored Files Overwritten Errors All Results List Settings Task Settings Resolution Tips will be exported as a separate HTML file 6 Select reports to save task results in Microsoft Excel format XLSX Each report in ActivityLogViewer dialog is stored as a separate worksheet in MS Excel NOTE Task Settings and Resolution Tips will be exported as a separate HTML file 7 Click Open Log Folder buttons to open the folder that contains the activity log of the currently displayed task history item NOTE For all errors refer File Errors section of Activity Log to view a description of the actual error that occurred during export 76 3 Export SharePoint List contents using the br
182. roperties mapped Move Down Add Mapping Remove Mapping Use in scopes Allow this property to be used in scopes Indicates whether this property will be available For use in defining search scopes 2 3 4 How crawling will affect export process of search results For example if you performed search for the search query Author John Doe using Trial search Dialog search results contains 1205 records approximately and save the search results During export process search results count may increase to 1250 records approximately this is due to the incremental crawling of the content source How to avoid the System Services TimeoutException during export process of search results in SPListX During frequent usage of SharePoint SharePoint Search services cannot serve the search request within the stipulated time therefore SharePoint search server itself throws a System ServicepProcess TimeoutException To avoid this exception we strongly recommend you to perform search export process during off peak hours How stemming will help you to get related search results Stemming will bring back words closely related to the query terms i e inflectional variants for most languages but for some languages derivational variants as well 275 For example sample search queries with search results S No Search Keywords Search Results run In addition to exact match it will bring back matches on runs ran run
183. rt permissions E Export permissions Export Permissions a Do not export permissions This option will not export permissions to the metadata file b Export permissions This option will export permissions based on the user specified options 104 2 3 4 5 The Export Permissions options appear as shown below SPListX Task Wizard TestRob1 Step 5 of 11 Permission Options SharePoint 2010 or later only Export site list item permission from SharePoint file to the metadata file Epot Permissions Do not export permissions Export permissions Export permissions for W Site F List W List item Pennission format User Role format e g jahndoe Full Control a Role User format e g Full Control jahndoe a Inheritance status W Export inheritance status as separate column shows if the permission is Unique or Inherited a Membership information Export AD information and role definition to a separate XML file o lt Back Next gt You can export permissions for Site List List item to the metadata file depending on the user selection Check appropriate checkboxes in Export permissions for options Specify the Permission format to use when exporting the permission information for the Site List List item to the metadata file using the options given below a User Role format Exports permission details as User Role e g johndoe Full C
184. run in the application task history folder e g lt Application Data Folder gt SPListX TaskHistory lt task name gt lt timestamp gt Over a period of time the task history folder grows in size We recommend cleaning up the task history periodically to control the disk space usage To cleanup task history perform the following steps given below 1 Click Cleanup History from SPListX Task Manager Cleanup History Or Select Cleanup History from Tools menu i Cleanup History E View Activity Log X Remove Activity Log 2 The Cleanup History dialog appears as shown below lez nup istory This deanup utility will dear task history and related files Specify a relevant value to maintain task history W Retain task history for last 7 runs only V Retain task history for last 7 a Selecting Retain task history for last lt n gt runs only option will remove all history entries for each task that are older than lt n gt runs task instances 62 b Selecting Retain task history for last lt n gt days only option will remove all history entries for each task that are older than lt n gt days 63 2 20 Proxy Server Settings Use this tool to specify the Proxy Server settings to use if you wish to override Internet Explorer s proxy settings set as default You can specify a custom proxy and credential to create a connection with the SharePoint server The proxy server settings wi
185. run the task later as and when desired b Run now to run the task immediately after clicking Finish button c Schedule to create a Windows scheduled task SPListX will create a schedule task in the Windows Scheduled Tasks applet with the stated settings SPListX 262 will perform the export based on the Run As user account specified in this export wizard step The Run As account should be a valid Windows domain account SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Sample Task Category C Blank Description Task Option Connect to SharePoint As Run later This user VY APINLAB kevin Run now Use Run As user context given below Schedul E Schedule Settings Run As VYAPINLAB Administrator Schedule Daily v Start time 18 32 Schedule Task Daily Every 1 At 18 32 every day starting 08 05 2012 In scheduled export process SPListX allows the user to enter different user credentials to connect to SharePoint and to create a scheduled export task unattended mode By default SPListX will use the user account specified in the scheduled Run As user context to connect to SharePoint In case if you decide to use different user context to connect to SharePoint when running the scheduled task you can do so by storing the SharePoint user context for future use SPListX will store the user credential to
186. s Cities List Type Document Exports documents from all document libraries Library in the entire web application Base Type lt gt Document Library Exports list items and attachments of all custom lists other than document libraries that are present in the entire web application A few examples of item and folder export conditions are as follows Export Condition Description Modified Date gt 09 09 2010 Assuming the date specified by the user is in MM DD YYYY format and with this condition SPListX exports list items that have been modified after 9th September 2009 Created By John Doe a Exports list items that have been created by John Created Date gt Doe 09 01 2010 AND Created Date lt 09 30 2010 MM DD YYYY format SPListX exports list items created in the month of September 2010 Assuming the date specified by the user is in Exports list items that have content type as Content Type Document Document Exports list items that have been modified by John Modified By John Doe Doe The following section describes the data types supported by SharePoint and an example of how to state the export condition Yes N D ment Verified Yes Sanne ore ee SPListX exports list items that have the Document Verified value set to Yes Text Title lt gt Research ck ak i PUINE i SPListX exports only list items that do not have R
187. s Select properties to indude in search query and specify what results to indude Search options Search across all content in the index Search across the current site and all of its subsites Properties Trim duplicate search results Indude stemming results M Indude only relevance results Search results Process items only recommended Process all results V Perform keyword search if advanced search is not enabled ae Search Options Search across all content in the index By default SPListX will search for list items across all the indexed content Search across the current site and all of its sub site SPListX will search for list items at current site and all of its sub sites Properties Trim duplicate search results By default SPListX will remove the duplicate items from search results Include stemming results By default SPListX will not include the stemming results Include only relevance results By default SPListX will include only relevance results Search results Process only items recommended By default SPListX will search for list items only Process all results SPListX will include all list view URLs site URLs in search Perform keyword search if advanced search is not enabled To perform keyword search based on your keywords specified in All keywords textbox Any 92 Keywords textbox Exact Phrase textbox and it will ignore all the proper
188. s The stored user profile is tied to the user context currently logged on user account in which the profile is created Hence you will not be allowed to change the scheduled Run As user context for the export task Click Manage Profile button to create new user profile 6 As for Web Single Sign on credential based export task the task settings will be Shown as below SPListX Task Wizard ca Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Category C Blank Description Task Option Connect to SharePoint As Danae Thee Run now Prompt me for user context at task run time Schedule The Web Single Sign on framework expects the user name and password to be given by user interactively in a browser based login dialog Hence the user profile list is not accessible for this type of connection 7 As far as scheduled run is concerned SPListX enables you to setup the export task using persistent connection and shared credential as shown below SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Sample Task Office365 Category C Blank Description Task Option Connect to SharePoint As C Run later This user Run now Schedule Use persistent session of the target site Check session status in Web SSO Dashboard Schedule Settings minds APRA ew e shee
189. s e property based on the order specified using the Move ows_Created_x0020_Date Text Up and Move Down buttons or from all the crawled Move Down properties mapped Use in scopes Indicates Add Mapping Remove Mapping V Allow this property to be used in scopes whether this property will be available for use in defining search scopes 2 3 How crawling will affect export process of search results For example if you performed search for the search query Author John Doe using Trial search Dialog search results contains 1205 records approximately and save the search results During export process search results count may increase to 1250 records approximately this is due to the incremental crawling of the content source How to avoid the System Services TimeoutException during export process of search results in SPListX During frequent usage of SharePoint SharePoint Search services cannot serve the search request within the stipulated time therefore SharePoint search server itself throws a System ServicepProcess TimeoutException To avoid this exception we strongly recommend you to perform search export process during off peak hours 4 How stemming will help you to get related search results Stemming will bring back words closely related to the query terms i e inflectional variants for most languages but for some languages derivational variants as well 272 For example sample search queries wi
190. s using a batch descriptor file Export folders files and list items including attachments along with metadata from SharePoint list to file system based on the entries in the descriptor file C Export SharePoint List contents using the search option Export folders files and list items including attachments along with metadata from SharePoint list to file system based on SharePoint search results 1 Click New Task from SPListX main screen New Task Or Select New Task from Task menu Task C New Task Ctrl N Edit Task Ctri E TE Copy Task Ctrl C h Delete Task Del Create Windows Task 5J Run Now Ctrl R Exit Ctri Q Or Press Ctri N 19 2 Select a task type in New Task dialog and click OK TEA TN Select a task type for creating a new task A wizard will guide you through steps to create a task based on the selected Task type Export SharePoint List contents using the browse option Create a task to export folders files and list items including attachments along with metadata to the file system by browsing the SharePoint list contents Export SharePoint List contents using a batch descriptor file Create a task to export folders files and list items induding attachments along with metadata from SharePoint list to file system based on the entries in the descriptor file Export SharePoint List contents using the search option Create a task to export folders files and
191. sa puseaedessceneaasescaoeesenceecenccsescoesee ss 43 2 14 Manage Categories sicstucsncasucesnidatencsiesenessidstegsesassceeeatsdacnsiaseneosaiatecsaieseressees 48 2 15 Active Directory Profile Manager sssssssssssssssssnssssnsssnnsssnnssnsnssnsnennssennssenne 51 2 16 Metadata Format Template icurisieirrir inirsnrioni snenia a aa 54 2 17 File Share Manager ssssssssssssssssssssssnesnsnrssssesnsssnnessnnessnnesnsnesnsnesnsnenneneene 58 2 18 Remove a task history item sssssssssssnnssnsnnsnsssensensonssronesnnnesnsnennsnrensnennenrnne 61 2D ClreaiUp IAISEFOV ET E E A E E E aaasqsexeenrnan nares 62 2 20 Proxy Server SELON GS eccscceacscuesenesaqoscaiencesseuseseennoccossnuneanecenunscesenesasuseunaceson 64 2 21 Web Single Sign on Dashboard ssssssesssnesnansennunessnnaanunnosunnsannananannnennnneanun 68 2 22 VOW ACUIV IVY hOGiatar soescaarnayacdanaorngsaeuare causes saaanaaecdansausasestuernasencacscauauarncseoes 74 3 Export SharePoint List contents using the browse option cccceeeeee eee e eee e eee eeeeeees 77 Sd Graber aS asteininnad a A T O E T tia minedtemaianeedmordnectinaidentiet 78 Si ddl EXPO ODUONS omszasensssenideteoresanmennecedeanmseniacenwameneeamennseseunnnaniestandaees 80 52122 Sharer oint Source Tocata anei adv a a a tucked aN 81 Sided Ems AO EX DO raira E a E EA EE RA 84 Z WRASSE NW ODON Saira re a E TEE T a ent era 97 52125 WV CFSION ODUOMNS areis a aa e a a ta ead ie hos ed a en ede 100 E 6 PC
192. selected columns lt Type column names here gt a Examples Title Description Takes additional time to process SharePoint maintained read only columns lt Back Next gt 2 Select any one of the following View Settings given below a All items in the List View AllItems aspx Select Columns to export Export all items documents including folders in the list view as it appears in Allitems aspx web page corresponding to the list You have the additional option to specify the SharePoint columns to export as per the options below I Export all columns Exports all columns available in the source SharePoint list including built in SharePoint columns such as Created Modified Approval Status etc ii Export all user defined columns Exports all columns that are created by a SharePoint user Export selected columns Exports columns that are specified in the textbox SPList Task Wizard FileEntries Step 3 of 11 List View Options Export list items documents based on SharePoint List Views View Settings All items in the List View Allltems aspx Select Columns to export Default View E All Views Specific Views Columns to export Export all columns a Export all user defined columns o Export selected columns Title a Enter one column name per line Ensure the Content Type column name entered here exactly matches the display name of the SharePoint column Takes additional ti
193. sks applet with the stated settings SPListX will perform the export based on the Run As user account specified in this export wizard step The Run As account should be a valid Windows domain account 140 SPListX Task Wizard Step Number Task Settings Enter a unique name for the export task and specify schedule task settings Name Sample Task Category C Blank Description Task Option Connect to SharePoint As Run later This user VYAPINLAB kevin Run now Use Run As user context given below Schedule Schedule Settings Run As VYAPINLAB Administrator Schedule Daily ss Start time 18 32 Schedule Task Daily Every 1 day s At 18 32 every day starting 08 05 2012 In scheduled export process SPListX allows the user to enter different user credentials to connect to SharePoint and to create a scheduled export task unattended mode By default SPListX will use the user account specified in the scheduled Run As user context to connect to SharePoint In case if you decide to use different user context to connect to SharePoint when running the scheduled task you can do so by storing the SharePoint user context for future use SPListX will store the user credential to connect to SharePoint in the Microsoft Windows Stored User Names and Passwords Credential Manager Applet for security reasons The stored user profile is tied to the user context currently logged on user a
194. ss documents files during the export process Packaging Settings Do not package documents or file attachments Perform document packaging for Document sets stores multiple documents in a single compressed file Libraries only O Documents and its versions stores documents and its versions based on version export option in a single compressed file Libraries only File attachments stores each list item s attachments in a single compressed file Lists only i Document sets This option will package all files stored in the document sets into a single compressed file The package is created in the same name as the document set ii Documents and its versions This option will package the documents and its associated versions into a single compressed file The package is created in the same name as original document or file The document s versions are exported into the created package based on the settings specified in Versions Settings wizard step iii File Attachments This option will package each list item s attachment s into a single compressed file The compressed package is created in the name of listitem ID 3 Click Next to Proceed to the Next Step 250 5 1 10 Destination Folder Options SPListX will create destination folders based on the following options given below 1 The Destination Folder options specification wizard step appears as shown below SPList Task Wizard Step 9
195. st The SharePoint columns defined in the respective list views will be exported to the metadata file d Specific Views Exports views that are specified in the textbox The SharePoint columns defined in the respective list views will be exported to the metadata file Note ViewName macro is applicable only for View based export SPListX will substitute the name of the processed view wherever applicable In view based export Content export For list library entries it creates a new folder with the view name under the list library name folder in the specified destination location 98 For file folder entries provided for export it exports the content in the specified export location Metadata export For list library entries and for files folders within them it exports metadata for columns present in the view For file folder entries provided for export it exports metadata for all columns including SharePoint maintained read only columns instead of the view based columns SPListX Task Wizard FileEntries Step 3 of 11 List View Options Export list items documents based on SharePoint List Views View Settings All items in the List View Allltems aspx Select Columns to export Default View All Views Specific Views Columns to export Export all columns aj Export all user defined columns 4 Export selected columns Title a Enter one column name per line Ensur
196. t be satisfied before exporting item from SharePoint For example you can export list only when List Type Document Library Field Name Document Library z AND to Filter OR to Filter LCD Le Lax la Base Type Document Library Export list items if the above condition is satisfied notsatisfied d SPListX will export the lists that satisfy the export condition or export the lists that do not satisfy the export condition depending on the option selected by the user e Export list items if the above conditions are satisfied Lists that satisfy the condition will be marked for export e Export list items if the above conditions are not satisfied Lists that do not satisfy the condition will be marked for export 118 e Folder Level Conditions Click Folder level filter to specify the conditions The Folder Export Conditions Dialog appears as shown below ist Export Condition sexy cb Specify rule that must be satisfied before exporting item from SharePoint For example you can export list only when List Type Document Library Operator Value Conditions Export list items if the above condition is satisfied notsatisfied f Click button to add the SharePoint columns in Field Name dropdown The Add Fields Dialog appears as shown below 119 Column Name Column Type Date of join DateTime Authorized by Destination Text ser
197. t contents physical files only Export SharePoint list contents folders files list item attachments to the local file system or network share Metadata will not be exported Export metadata only Export metadata for SharePoint list items to the local file system or network share Physical files or attachment files will not be exported 3 Click Next button 4 Specify Batch Descriptor File 5 Specify List View Options 6 Specify Version Options 7 Specify Permission Options 8 Specify Export Conditions 9 Specify Document Packaging Options 10 Specify Destination Folder Option 11 Specify File Settings 12 Specify Metadata File Settings 13 Specify Task Settings 14 Click Finish button to create the Task or click Back button to change any task settings 4 1 1 Create Batch Descriptor File The following section gives you the guidelines to create an external batch descriptor file for Export SharePoint List contents using a batch descriptor file task type 1 The first row of the metadata file should contain the Field Names as headers 2 The first field should be named as Path and second field should be named as 4 Destination Path The other field names should be separated by a delimiter character such as comma semi colon etc The delimiter character used in the external metadata file Should be same as List Separator defined in locale settings in Regional and Language Options
198. tX checks the source list item s modified date value and exports the items that are changed in the current week SPListX checks the source list item s modified date value and exports the items that are changed in the current month SPListX checks the source list item s created date value and exports those items that are changed in last previous week 247 a Last PS the o ee o Spier checke the ont that arg crea ed or anged Las sourco ekitean s modified in the last Month modified date value month and exports those items that are changed in last previous month Changed Since Last Export using SPListX Exports list items Modified Date SPListX compares the that are modified in Changed Since source list item s the source folder Last Export using modified date value since the last export SPListX with list item s last using SPListX It is export date and time based on the last maintained by the Export date and application and time value internally proceeds with the maintained for the export accordingly Changed Last 7 Exports list items Modified Date SPListX checks the days that are created or Changed Last 7 modified in the last 7 days days source list item s modified date value and exports the items that are changed in the last 7 days Changed Last 14 Exports list items Modified Date SPListX checks the that are created or Changed Last modified in the last 14 days
199. ta http rd41 sites devteam i Exchange Server 2003 http rd41 sites devteam A Version History Modified Date 1 5 13 8 01 43 PM 1 7 13 7 46 07 PM 8 1 03 5 30 00 AM The result is stored in D Result xlsx successfully StatusReport a gt FW Insight inte FW Truth Hurts ATi A test Note Double dick on results to launch the URL in your browser Save Results Click yes to launch the file Click Close button to close the dialog 5 Sample Search Result format in CSV Title Path Modified Date Do you want to launch the file now Purchase https vyapin sharepoint com Purchase document purchase report xls 2 15 2009 Marketing https vyapin sharepoint com Purchase document marketing ppt 2 15 2009 283 Account Report https vyapin sharepoint com Purchase document Account Report xls 2 15 2009 6 Steps to modify the search results 1 Remove the Columns modified date title from the file i1 Add Destination Path Column and specify the file path Sample Batch file format for CSV Path Destination Path 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 7 Create
200. tadata export tasks Page Library Aerobics Documents Contents are moved to the Shared Documents Everest Master page gallery E Library Documents EE View Export By AllVersions E Lists E Important Documents Wiki E Contacts HB Cloud Hil Latest Versions C Blank amp amp amp 2 Delete Task Created 6 9 2015 4 49 05 PM 6 9 2015 4 39 35 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 47 56 PM Click Delete Task from SPListX main screen Or Select Delete Task from Task menu Task E New Task i Edit Task Ctrl N Ctrl E Ctrl C Del Copy Task Delete Task Create Windows Task GI Run Now Exit Ctrl R Ctrl Q Or Press Del key Click Yes in Delete Task message box shown below files 6 9 2015 4 49 05 PM 6 9 2015 4 40 12 PM 6 9 2015 4 42 08 PM 6 9 2015 4 46 42 PM 6 9 2015 4 48 14 PM Total Items Processed 83 Files 0 Folders 1 Files 0 Folders 197 Files 0 Folders 1 Files 0 Folders 3 Files 0 Folders 5 008 1 25KB 60 04 MB 827 00 5 73 47 KB ___TotalData Transferred Settings ioj 24 2 This action will remove task Sample Task and its associated task history Are you sure you want to delete the task ves No NOTE Deleting a task will permanently delete the selected task and its task history items 25 2 Run a task SPListX Run Now feature allows the user
201. te level Connector Site T ProductList Server Relative URL sites productlist SPListX will export the sites that satisfy the export conditions depending on the option selected by the user b List Level Filters Click List level filter to specify the filter conditions The List Level Filter dialog appears as below List Level Filter Specify condition to apply at the SharePoint list level For example you can export lists when List Type Document Library OR List Type Picture Library Property Operator c You can specify the export filters by selecting the field name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed using logical operators AND and OR Click E3 to add multiple filters Click to remove the filter from the filter list Click Clear to remove all the filters specified Specify condition to apply at the SharePoint list level For example you can export lists when List Type Document Library OR List Type Picture Library Property Operator List Type List Name SPListX will export the lists that satisfy the export conditions depending on the option selected by the user d Fold
202. tem do not satisfy the export condition specified in the task settings SPListX will log this message in the Activity log and the list folder list item will be skipped for export Ensure that the specified column in export metadata for specific columns exists in SharePoint List Ensure that the specified managed property in search condition exists in the source SharePoint service provider Ensure that the specified view exist in SharePoint List Ensure that the specified managed property in search condition exists in the source SharePoint Service Provider The user account specified to access membership information does not have sufficient permission to retrieve the members of the respective SharePoint Groups The user account specified in the Active Directory Profile Manager does not have sufficient permission to retrieve the members of the respective Domain Groups Specify a different user account if necessary 288 289 6 2 Troubleshooting If and when a problem arises please forward the following files to support vyapin com to revert back to you with a solution These files will be available where SPListX is installed 1 Error log file e g lt Application Data Folder gt SPListX Log SPListXErrorLog txt 2 For issues while running a task the Activity Log and Error Log files will be generated a b c d e f g in a date and time stamp folder within the task folder name under TaskH
203. tems documents based on SharePoint List Views View Settings All items in the List View Allltems aspx Select Columns to export O Default View 5 All Views Specific Views Columns to export Export all columns a Export all user defined columns a Export selected columns Title a Content Type Enter one column name per line Ensure the column name entered here ewactly matches the display name of the SharePoint column Takes additional time to process SharePoint maintained read only columns Click Next to proceed 4 1 5 Version Options To selectively export list item versions to the destination file system location 1 The Version Options step appears as shown below SPLista Task Wizard Sample Task Step Number Version Options Specify the list item versions to export By default all versions of the list item will be exported All versions Export version range Export version date range rt 20 Feb 12 20 Feb 12 Export major versions only Latest version only Ale Version Handling Libraries only Export each file version to a version folder named as v lt VersionNumber gt Store latest version in root folder 0 Store latest version in the respective version folder Export each file version as separate files named as lt FileName gt _v lt VersionNumber gt zea nee gt 2 Export Versions By default All versions option is selected Item version settings will
204. tems and its associated metadata to the local fle system or network share Specify user credential to connect to SharePoint when running the export task File Name Authentication Windows User Name vsslab andrew Y on Gjohndoe contoso com contoso johndoe johndoe Password Seeeseseseeeseese errs 2 Click button to select the batch descriptor file The descriptor file can be in any one of the following file formats Comma delimited CSV Microsoft Excel XLSX or Text file TXT 3 Click o to see a sample batch descriptor file such as Comma delimited CSV MS Excel XLSX 4 The batch descriptor file will automatically be extracted once the file name is specified If you are using Microsoft Excel based file format then select the sheet name to use from the drop down 5 Click to add a hidden sheet name from Excel file in drop down 6 Specify the Authentication mechanism and credentials to connect to SharePoint using one of the options described below a Windows or Forms SPListX will initiate Windows or Forms authentication using the user account information stored in the user profile or the one entered in the textbox b Office 365 Cloud Identity Connects to a SharePoint Online site in Office 365 using the given cloud identity i e Office 365 Online User Credential e g johndoe vyapin onmicrosoft com c Federated Identity Connects to a SharePoint site On pre
205. tents folders files list item attachments and its associated metadata to the local file system or network share Export list contents physical files only Export SharePoint list contents folders files list item attachments to the local file system or network share Metadata will not be exported Export metadata only Export metadata for SharePoint list items to the local file system or network share Physical files or attachment files will not be exported 3 Click Next button 4 Specify SharePoint User Credential 5 Specify SharePoint URL Settings 6 Specify Search Conditions 7 Specify Column Settings Options 8 Specify Version Options 9 Specify Permission Options 10 Specify Export Conditions 11 Specify Document Packing Options 12 Add Destination folder option 13 Specify File Settings 14 Specify Metadata File Settings 15 Specify Task Settings 16 Click Finish button to create the task or click Back button to change the task settings 205 5 1 1 Create Search Batch Descriptor File The following section gives you the guidelines to create an external batch descriptor file for Export SharePoint List contents using the search option task type 1 The first row of the metadata file should contain the Field Names as headers 2 The first field should be named as Path and second field should be named as Destination Path The other field names should be separated by a delimiter character such
206. th search results S No Search Keywords Search Results 1 Run In addition to exact match it will bring back matches on runs ran running Page In addition to exact match it will bring back matches on pages paged and paging 5 How to enable stemming in SharePoint 2010 gt v V Y WV Go to the search page enter any query to return the search results page For ex enter keyword sharepoint in anykeywords text box Under Site Actions select Edit page Locate the Search Core Results web part usually in the bottom zone From the Edit button select Modify shared web part In the task pane that appears on the right hand side under Results Query Options select Enable Search Term Stemming checkbox NOTE If stemming is switched on it will increase your index size and potentially impact search performance 6 What is meant by Trimming Duplicate Search Results To specify whether duplicate list item URLs should be removed from search results 7 How to view duplicate search results in SharePoint 2010 gt Vv V WV WV Go to the search page enter any query to return the search results page For example enter keyword sharepoint in any keywords text box Under Site Actions select Edit page Locate the Search Core Results web part usually in the bottom zone From the Edit button select Modify shared web part In the task pane that appears on the right
207. the Destination Path field has the corresponding local mapped drive path e g M My Documents If you use shares to export file or list item attachments ensure the Destination Path field has the corresponding UNC path e g Machine_Name Share_Name 6 For CSV and TXT formats all field names and their corresponding metadata values Should be enclosed within double quotes e g http vyapin Shared Documents sample folderi When using accent characters such as a in folder file names the CSV TXT metadata file must be in UNICODE encoded format 7 For Microsoft Excel file formats XLSX you do not have to enclose the field names and their corresponding values within double quotes Sample format of a CSV TEXT batch descriptor file NOTE Refer Point 2 for the separator to be used in the batch descriptor file Path Destination Path http vyapin shared documents Sample Brochure doc C My Documents http vyapin shared documents sample folder1 vyapinfs ExportDocs shared doc contents http vyapin lists C My Sales Lists Backup http vyapin lists cities C My Cities Backup 207 5 1 2 SharePoint User Credential Specify the user credential to connect to the SharePoint 1 The SharePoint User Credential step appears as shown below SPListX Task Wizard lt n Step Number SharePoint User Credentials Specify user
208. the NTFS file system In a FAT file system the Last Modified Date alone will be retained as in source 3 Click Next to Proceed 134 3 1 11 Metadata File Settings SPListX will create metadata files based on the following options given below 1 The Metadata File Settings step appears as shown below Step 10 of 11 Metadata File Settings Specify destination path to store metadata file and export file format CSV XLSX XML Metadata file Store metadata file s in this location C Users Public Documents SPList Export location Store metadata file s in the respective list library folder location in the file system Metadata file options Create a metadata file for each list ibrary Create metadata file for each list item file Metadata fle name lt ListWame gt If file already exists Overwrite metadata file Append metadata to current file Metadata Format Optional Column Name Column Type Format 2 Specify the Metadata filename amp location using the options below a Store metadata file s in this location Specify a folder path where the selected list items metadata are to be exported You can also click browse button to launch folder browser dialog b Store metadata file s in the respective list library folder location in the file system This option will export the metadata file in the selected file format into the respective list folder locations where
209. the physical documents files are exported 135 3 4 NOTE Ensure that the user context used to run the SPListX export process has sufficient permissions to create edit and delete folders and files in the specified export path Specify the Metadata file options using the options below a Create a metadata file for each list library This option will export the metadata for the entire list library in a single file b Create metadata file for each list item file This option will export separate metadata file for each list item or file When you select Create a metadata file for each list library option SPListX creates the metadata file using the List name To create a unique metadata file name click the button placed next to the metadata file name textbox Metadata file name dialog appears as shown below Metadata file name Specify metadata file name Macro Sample Value Current Date 201512712 Current DateTime 20151212 143605 File Index 1 GUID 2a lazbd827a64997b 1507686f55d List Name Shared Documents View Name All Documents File Name lt List Name gt _ lt View Name gt Construct metadata file name with the available built in macros provided in the dialog Click OK to close the dialog The file name will be created in the name format syntax entered in the dialog 5 When you select Create metadata file for each list item file option SPListX creates the metadata file using the Item n
210. the user selection Check appropriate checkboxes in Export permission for options 3 Specify the Permission format to use when exporting the permission information for the Site List List item to the metadata file using the options given below a User Role format Exports permission details as User Role e g johndoe Full Control Limited Access johnsmith Read View Only etc b Role User format Exports permission details as Role User e g Full Control johndoe johnsmith Contributor janedoe etc 4 Inheritance status Export the inheritance status of the Site List List item as a separate column field in the metadata file This column field indicate if the permission is Inherited or Unique role assignment at the Site List List item level in SharePoint 5 Membership information This option exports AD informtion and role definition information to separate XML files These XML files are stored in the same location as the metadata files in the name _membershipinformation and _roledefinition The user account that connects to SharePoint must have System Account permission to retrieve respective membership information Similarly the user account specified in Active Directory Profile Manager for each domain must have Domain Admin permission to retrieve respective membership information SPListX will enumerate only the globally declared domain groups and retrieve membership information 227 6 Click N
211. ties scopes and result types specified in search query Select items to export Select folders list items to export Use Ctrl key to select multiple items Select destination folder location and cick Export button to export items Click Remove button to remove selected items from export Press F5 to refresh treeview Source http vm sp20135 8 vyapin harvester farmadmin Go 5 ContentType Document Advanced Search Search Results 2 objects selected ofl Pe Next Title Path Modified Date iat webpart http vm sp2013 8 SiteP 10 10 2014 9 35 50 AM Team Site create http vm sp2013 8 SiteP 5 13 2014 10 39 11 AM aa Team Site How To Use http vm sp2013 8 siteP 1 7 2014 8 53 39 AM L tion C Wsers Public Documents SPListX E t Export Loca Users Public Documents SPListX Expor ee Add to Favorites Documents List items to export Change Export Location 3X Remove gt Remove All Source Destination Title http vm sp2010 2 5itePages webpart aspx C Users Public Documents 5PListx Export webpart http vm sp2010 2 SitePages How To Use This C Users Public Documents SPList Export Team Site How To Use This Library Library aspx 7 The selected top level site sub sites lists folders files and list items added for export will be displayed in the Documents List items to export grid SPListX processes the top level folders and list items added for export in the order in which it appears in the Docum
212. tion when creating the metadata file during the export operation C ize M t ustomize etada a Format Enter column name its type and the format to use when exporting its value to the metadata file You can rename the SharePoint column name when exporting it to the metadata file by providing a new header name below Column Name Area Column Type Geolocation r Format Address ra New Header Name Location A Column Name Column Type Format New Header Name Area Geolocation Address Location Note The column s metadata format entered here will override the format specified in the Metadata Format Template Click E3 to add the SharePoint column name and its format in the custom metadata format list Click to remove t he SharePoint column name from the custom metadata format list 10 Click Next to Proceed Note XML File Format SPListX generates an XML file using the filename using the List name and List GUID in the format List Name List GUID to maintain a unique metadata file name in the stated metadata file location with the metadata information XML with DTD SPListX uses Document Type Definition DTD syntax to define the document structure of the XML metadata file This declaration has been introduced primarily to support large XML metadata files minimize memory footprint when working with large XML files and improve metadata file throughput XML metadata files are split into multiple text fi
213. tored credentials are used to l To add a profile click Add button File Share Name Profile Name v2 hare foder Henceforth the stored credential can be used to export the file share contents which are added in the search crawl index in the SharePoint server 5 Click Close button to close the File Share Manager dialog Additional References Behavior of stored user names and passwords http support microsoft com kb 281660 Stored User Name and Password Best practices http technet microsoft com en us library cc784749 WS 10 aspx 60 2 18 Remove a task history item To remove a task history item 1 Select item from Task History pane Task History 2 Refresh GJ Open Log Folder 4 View Activity Log Y lt Remove Start Time End Time Remarks 09 Jan 12 11 08 07 AM 09 Jan 12 11 08 44 AM Completed successfully 09 Jan 12 11 06 42 AM 09 Jan 12 11 06 56 AM Incomplete refer activity log 05 Jan 12 3 08 56 PM 05 Jan 12 3 09 54 PM Completed successfully 2 Click Remove from SPListX main screen x Remove Or Select Remove Activity Log from Tools menu SB Cleanup History E View Activity Log gt lt Remove Activity Log This will remove the currently selected activity log entry and log folders amp files associated with the task history item To maintain task history items see Cleanup history and Task Status 61 2 19 Cleanup Histroy SPListX maintain the task history of each task
214. value and exports the items that are changed in the last 14 days 4 1 8 Document Packaging Options Document Packaging helps in storing related documents contents together in a single file in compressed format SPListX has the provision to export document sets document file versions and file attachments as packaged contents grouped together Follow the steps outlined below to store multiple document versions document sets and file attachments grouped together in the file system file share 1 The Document Packaging Options step appears as shown below SPList Task Wizard Test Search Step Number Document Packaging Options Select packaging option below to compress documents files during the export process Packaging Settings Do not package documents or file attachments Perform document packaging for ig Cae 2 Select Packaging Settings from the options outlined below a Do not package documents or file attachments SPListX will not package the exported documents or file attachments b Perform document packaging for Document package will be created for each exported document set file version and file attachment based on the option selected below If the file already exists in the package File Settings options will be applied SPList Task Wizard Test Search Step Number Document Packaging Options Select packaging option below to compress documents files during the export process P
215. vant entries in the favorites as a dropdown wherever applicable You can also set a particular URL and Path as a default favourite to select the entry by default in the appropriate steps 1 In order to create SPListX favorites select Manage Favorites from Tools menu Tools Profile Manager Metadata Format Template Active Directory Profile Manager File Share Manager Manage Categories Web Single Sign on Dashboard Proxy Settings Bh Cleanup History GH View Activity Log X Remove Activity Log 2 The Manage Favorites dialog will be shown as below 43 Add a SharePoint URL or File System path as a favorite SPListX will show the favorites whereever applicable Click the checkbox to display the favorites or SPListX will show windows options by default 7 SharePoint Favorites Gly File System Favorites E Show favorites for SharePoint URL and File System path s tes 44 3 In order to add a favourite select a favourite Type i e SharePoint Favourite or File System Favorite and click Add button to add the new favourite to the favourite list as shown below ee aca ate favorite SPListX will show the favorites whereever applicable Click the checkbox to display the favorites or SPListX will show windows options by default Name http TestMachine SharePoint Create Set as default RemoveAll X SharePoint Favorites l http TestMachine SharePoint Sy Fil
216. ve folders and files in the file system follow the steps outlined below SPListX Task Wizard Batch b n i O Step Number File Settings Use the option below to manage file duplicates in the Windows File System You can also propagate Created Date and Last Modified Date fields from SharePoint Library to the Windows File System If the file with the same name already exists in the destination location Do not overwrite the existing file Overwrite the existing file Rename the new file that is currently exported from SharePoint Alternate File Name Mask lt FileName gt lt Index gt You can propagate original created date and last modified date for folders and files from SharePoint library to the NTFS file system In a FAT file system the last modified date alone will be retained from SharePoint library When document packaging option is selected the created date alone will be retained from the SharePoint library Retain created date Retain modified date i 255 Select File System Date Settings The date options given below will assign the respective data field values in the file system as in the original SharePoint list a Retain created date Carry forward propagate Created Date field from the source folders files and list item attachments to the Windows file system b Retain modified date Carry forward propagate Last Modified Date field from the source folders files
217. vision to export document sets document file versions and file attachments as packaged contents grouped together Follow the steps outlined below to store multiple document versions document sets and file attachments grouped together in the file system file share 1 The Document Packaging Options step appears as shown below SPListX Task Wizard Test Search Step Number Document Packaging Options Select packaging option below to compress documents files during the export process Packaging Settings Do not package documents or file attachments C Perform document packaging for gf 2 Select Packaging Settings from the options outlined below a Do not package documents or file attachments SPListX will not package the exported documents or file attachments b Perform document packaging for Document package will be created for each exported document set file version and file attachment based on the option selected below If the file already exists in the package File Settings options will be applied 127 SPList Task Wizard Test Search Step Number Document Packaging Options Select packaging option below to compress documents files during the export process Packaging Settings C Do not package documents or file attachments Perform document packaging for Document sets stores multiple documents in a single compressed file Libraries only O Documents and its versions stores documents a
218. w SPList Task Wizard Step 6 of 11 Export Conditions Specify export conditions for site list folders and or file to filter the contents Site level 2 You can specify one of the following methods of exporting conditions BASIC ADVANCED 2 1 BASIC You can specify export conditions at three levels Site Level Filter List Level Filter Folder Level Filter File or Item Level Filter 107 a Site Level Filters Click Site level filter to specify the filter conditions The Site Level Filter dialog appears as below Site Level hies Specify condition to apply at the SharePoint site level Property Connector You can specify the export filters by selecting the site name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed using logical operators AND and OR Click E3 to add multiple filters Click to remove the filter from the filter list Click Clear to remove all the filters specified Sie Level Eee Specify condition to apply at the SharePoint site level Connector Site Name ProductList Server Relative URL sites productlist 108 SPListX will export the sites that satisfy the export conditions depending on the option selected by the user b List Level Filters Click List level filter to specify the filter conditions The List Level Filter d
219. wled property based on the order specified is selected gt Click Add Mapping and select the Office category from the dropdown list Look for a property named OFFICE 4 click OK gt Click Add Mapping and select the ows _Created_x0020_ By text from the ALL categories dropdown list Click OK gt Make sure the box is checked Allow this property to be used in scopes click OK 274 Use this page to view and change the settings of this property Name and type Type a name For this property and select the type of Property name information you want to store in this property CreatedBy l Description E The type of information in this property Text Content using this property Number of items found with this property more than 1000 This section displays the number of items Found with this property Mappings to crawled properties 4 list of crawled properties mapped to this managed property is shown To use a crawled property in the search Include values from all crawled properties mapped Include values from a single crawled property based on the order specified system map it to a managed property A managed property Crawled properties mapped to this managed property can get a value From a crawled property based on the order Office 4 Text Move Up specified using the Move Up and Move Down buttons or From ows Created x0020 By Text ape all the crawled p
220. words 215 6 For ex If you search for keyword run Search results will bring back words matches like runs running Include only relevance results This option will include only relevance results in search results Relevance will bring the search results closely related to the search query c Search results Process only items recommended This option will search for list items only Process all results This option will include all list view URLs site URLs in search results But export process engine will ignore the site URLs List view URLs for export d Perform keyword search if advanced search is not enabled In WSS 3 0 advanced search is not enabled If you want to perform search for the WSS 3 0 sites SPListX will ignore all the properties scopes and result types specified in search query Keyword search query is framed based on the keywords specified in All Keywords textbox Any Keywords textbox Exact Phrase textbox Click OK to proceed Click Trial Search button to invoke Trial Search tool The Trial Search tool will help you perform a live search against the keywords and help you verify the search results 216 The Trial Search Dialog appears as shown below Trial search tool will help you perform a live search to verify the search results gore vyapin onmicrosoft com dd Back Path Note Double dick on results to launch the URL in your browser Save Results a Sel
221. xporting item from SharePoint For example you can export folder only when Created By john doe Co ee lt F 01 Jan 12 Ev Created Date lt 01 Jan 12 Export list items if the above condition is satisfied not satisfied h SPListX will export the folders that satisfy the export condition or export the folders that do not satisfy the export condition depending on the option selected by the user Export list items if the above conditions are satisfied Folders that satisfy the condition will be marked for export Export list items if the above conditions are not satisfied Folders that do not satisfy the condition will be marked for export i File or Item Level Filters Same as Folder Level Filters 3 Click Next to proceed Examples of Export Conditions SPListX exports folders amp files attachments along with metadata to the file system location based on export conditions defined in the export task Export conditions can be constructed using metadata columns and its values A few examples of list conditions are as follows Export Condition Description Server Relative URL site Exports list items that have server relative URL name subsite name lists list _ site name subsite name lists list name ee For example Server Relative URL vyapin sharepoint lists Product List List Name Cities Exports list item and attachments of lists named a
222. y the globally declared domain groups and retrieve membership information 6 Click Next to proceed 4 1 7 Export Conditions SPListX can export folders files and list items including file attachments from a SharePoint list or library based on certain export conditions The conditions can be created by using SharePoint columns in the source list or library 1 The Export Conditions step appears as shown below SPList Task Wizard Step 6 of 11 Export Conditions Specify export conditions for site list folders and or file to filter the contents Site level List level Folder level 2 You can specify one of the following methods of exporting conditions BASIC ADVANCED 2 1 BASIC 167 a Site Level Filters Click Site level filter to specify the filter conditions The Site Level Filter dialog appears as below Site Level Filter Specify condition to apply at the SharePoint site level Property Operator Connector You can specify the export filters by selecting the site name and by specifying a value with necessary operator You can use mathematical operators such as lt gt to define your query Complex queries can be constructed using logical operators AND and OR Click to add multiple filters Click to remove the filter from the filter list Click Clear to remove all the filters specified Site Level Filter Specify condition to apply at the SharePoint si
223. you to construct flexible export conditions by using the Changed operator for periodic import for the fields Created Date SharePoint and Modified Date SharePoint The following built in values can be used for this operator Today Yesterday This Week This Month Last Week Last Month Since Last Update in SharePoint Since Last Export in SPListX Last 7 days and Last 14 days By using Changed operator you can filter the list items based on the above mentioned values from SharePoint list For example if you need to migrate list items that are modified in SharePoint today you can specify an export condition as stated below Modified Date Changed Today Operator amp Value Changed To day Changed Yesterday Changed This Week Changed This Month Changed Last Week Changed Last Month Description Exports list items that are created or modified in the present day at the time of export in SharePoint Exports list items that are created or modified yesterday at the time of export in SharePoint Exports list items that are created or modified in the current week Exports list items that are created or modified in the current month Exports list items that are created or modified in the last week Exports the list items that are created or modified in the last month An Example Modified Date Changed Today Created Date Changed Yesterday Modified Dat

User Manual SPListX for SharePoint

Contents

Download Pdf Manuals

Related Search

Related Contents