How to export data from a SharePoint List

How to export data from a SharePoint List

Overview of Export Options
Step Action
1. Select the SharePoint List (or Document Library, or Picture Library) to export the data and documents from. The Libraries included on the list are those available on the SharePoint Server and Site entered on the Connect dialog and accessible by the interactive user or custom account specified. hw33006.jpg
2. Once a library is selected, the Views available in that library appear as selections in the List Views list. Select the appropriate view.
3. Select the Local or Network File Directory to export the files to. Click Browse… to browse to the location. Be sure the user entered previously has access to this location.
4.

Choose your Index File Options.

  • Select Create Index File to create a file containing a list of all exported files and any associated metadata.
  • Select Append Date and Time to file name to add the current date and time to the end of each exported file; the result will be a uniquely named file. This is useful for keeping track of multiple copies of the same file, if you choose to export these and still keep the originals.
  • Select Use absolute path in export if you want to include the full, absolute path location of each exported file in the index file.

    NOTE: If this option is not selected, the index file will include shorter, relative paths.

5.

Enter the appropriate Export Options:

  • Get documents from all sub folders: If you want to export files from all folders in the Document Library, be sure to click this box.
  • Overwrite existing file(s): Click this box if you want to overwrite files that may already be in the selected Network File System location.
  • Copy Folder structure: Click this box if you want the application to create folders in the Network File System location.
  • Copy all versions: Click this box if you want the application to export all versions of the files in the Document Library. If you want only the current version, leave the box un-checked. Filenames for exported versions include the version number.
  • Only process items added or modified since the last export (For scheduled exports only): Click this box to exclude any items that have not changed (or been added) since the last time an export occurred. If you are scheduling regular, automated exports, this option will eliminate unnecessary network activity and speed up the export process.
6. Click Next when ready. The Column Export screen appears.

hw33008.jpg

7. Specify the columns you want to include in your index file by selecting them from the Available Columns list, and clicking the right arrow button. To add all columns, click the double right arrow button.
8. To remove columns, select them from the Selected Columns list, and click the left arrow. To remove all columns, click the double left arrow. Any columns on this list will be included in the export.
9. When you are satisfied with the contents of the Selected Columns list, click Next. The Export Process screen will appear.

hw33010.jpg

10. To save the export configuration so the process can run unattended, click Save on this screen. A confirmation message will appear ensuring that the file was successfully saved.
11.

Before you export, select Show Failures, Show Successes, or Show Failures and Successes to determine what feedback to receive during export. Then, click Start to begin the export interactively. The process progress will appear on the screen, and depending on the chosen setting, the list will populate with successful conversions, failed conversions, or all conversions.

NOTE: Progress is also written to a log file stored in the Log folder in the same directory as the Bamboo List Bulk Export Application. Log files for interactive runs are named: Bamboo.Log.10222007_34508_PM, where 10222007_34508_PM denotes the date and time run. The Log file is in XML format and can be viewed with any text editor, or the Log File Viewer within the Export Application.
To view a log file, click File and then View Log Files from the main menu. The List Bulk Export Application Log File Viewer is able to filter the information so you can view information, failures, successes, or all items.