How to Reset the Connection to the Source SharePoint Site from within the application

How to Reset the Connection to the Source SharePoint Site from within the application

Overview of Export Options

When you launch the List Bulk Export application initially, you connect to a SharePoint environment. Once you run an export, you may need to export additional data from another SharePoint environment. There is no need to close the application and re-launch it.

Follow these steps to connect to a different environment from within the application.

Step Action
1. reconnect to a server.png
Select File and then Re-Connect to SharePoint Server from the main menu.
2.

are you sure.pngYou will be asked to confirm that you want to cancel the current export process. When you click Yes, the Re-Connect dialog appears.

Otherwise, click No to close the confirmation dialog without disconnecting from the current SharePoint environment.

3.

reconnect dialog.pngEnter a new SharePoint Server Site address and choose to connect as the currently logged in user (Interactive User) or choose Custom Account and enter Username, Password, and Doman.

When ready, click Connect. The List Bulk Export Application window will appear.

Otherwise, click Close to close the application. You will see the same confirmation dialog that is shown in Step 2 above.

How to recreate the folder structure of the Document Library

How to recreate the folder structure of the Document Library

Overview of Export Options

You may have a SharePoint Document Library with folders (like the one shown below) and you need to export the files and the folders to your network file system.

folder structure in sp.png

To export the files and the folders using the List Bulk Export, follow these steps:

Step Action
1.

When configuring the export, be sure to check the Copy folder structure box.

copy folder structure.png
2.

When the export completes, all the files and folders will appear in the export area. Exporting the Shared Document library shown at the top of this page, the export will look like when it completes.

folder structure export output.png

If you chose to have an index file created during the export, it will reside at the top level of the exported file structure.

How to find the version of List Bulk Export

How to find the version of List Bulk Export

Step Action
1. On the computer running the List Bulk Export. Browse to %programfiles%Bamboo Solutions Corporation. This is typically in c:Program filesBamboo Solutions Corporation.
2. You may have multiple folders in the Bamboo Solutions Corporation folder depending how many Bamboo products you’ve installed. Open the Bamboo Bulk Export folder and locate the product EXE.
list bulk export exe.png
3. Right-click on the EXE and select Properties. Open the Details tab and locate File Version.
bulk export props detail tab.jpg
This is the version of the product currently installed.

How to Export Files from a SharePoint Document or Picture Library

How to Export Files from a SharePoint Document or Picture Library

Connect to a SharePoint Server

Step Action
1. Double-click the .exe file, or right click it and select Run, or select Programs from your Windows Start menu and then List Bulk Export. The connect dialog will appear.
hw33004.jpg
2. Enter the URL of the portal you need to export from.
3. Select if you will use the Interactive User or a Custom Account. If you want to use a Custom Account, enter the username, password, and domain for the selected user.
4. When ready, click Connect. The List Bulk ExportApplication window will appear.
5. To cancel, click Close.

Connect to a Different Server

Step Action
1. Select File and then Re-connect to SharePoint Server from the main menu. You will be asked to confirm that you want to cancel the current export process. When you click Yes, the Re-connect dialog appears.
2. Enter a new SharePoint Site address and new custom credentials if needed.
3. When ready, click Connect. The List Bulk Export Application window will appear.

Select the Data and Files to Export

Step Action
1. Select File and then Re-connect to SharePoint Server from the main menu. You will be asked to confirm that you want to cancel the current export process. When you click Yes, the Re-connect dialog appears.
2. Enter a new SharePoint Site address and new custom credentials if needed.
3. When ready, click Connect. The List Bulk Export Application window will appear.
4.

Select the SharePoint List (or Document Library, or Picture Library) to export the data and documents from.

hw33006.jpg

NOTE: 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.

5. Once a library is selected, the Views available in that library appear as selections in the List Views list. Select the appropriate view.
6. 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.
7.

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. If this option is not selected, the index file will include shorter, relative paths.

8.

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.

9. Click Next when ready.

The Column Export screen appears. hw33008.jpg

10. 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.
11. To add all columns, click the double right arrow button.
12. 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.

When you are satisfied with the contents of the Selected Columns list, click Next. hw33010.jpg
The Export Process screen will appear.
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.

13.

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.
Progress is also written to a log file stored in the Log folder in the same directory as the 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.

Export only data that has been modified since the last export

Export only data that has been modified since the last export

Overview of Export Options
Step Action
1.

On the Select the settings… page, select the Only process items added or modified since the last export (For scheduled exports only) option. This setting will prevent the application from needlessly re-exporting unchanged items.

Icon-WarningIMPORTANT: Although you can select this option for any export, it is only successful when running as a scheduled export.

only process things that have changed.png

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.

How to determine the version of the Bulk Export you have installed

How to determine the version of the Bulk Export you have installed

To determine the release number of the List Bulk Export you have installed, follow these steps:

Step Action
1. Run the application.
2. help about menu.pngSelect Help > About Bulk Export from the Main Menu.
3. HelpAbout.pngThe About dialog appears showing information about the version/release that you are using.

How to copy versions of Document Library items

How to copy versions of Document Library items

Overview of Export Options

You may have versioning enabled in your SharePoint document library and some files may have been modified. In the example here, the Version History dialog shows a file called blue.jpg as Version 0.1 and a change to the file is shown under Version 0.2.

export versions.png

To export all versions of files in a document library, follow these steps:

Step Action
1.

When configuring the export, be sure to check the Copy all versions box.

Icon-WarningIMPORTANT: Be sure that the user account that is running the export has access to the versions or your export will fail!

HW33 copy versions.png
2.

When the export completes, a file for each version will appear in the export area. The name of the version will be appended to the filename.

In the example below, the filename of the file in sub folder aa was blue.jpg and two versions existed (see screen shot at top of page), version number 0.1 and version number 0.2. Two files were exported, blue_v01.jpg and blue_v02.jpg

exported data - versions.png

The index file created during the export has meta data information for each version as well.

How to Connect to the Source Site Initially

How to Connect to the Source Site Initially

Overview of Export Options

When you launch the List Bulk Export application, you will be asked for information about the SharePoint environment you want to export from.

Step Action
1. Enter the URL for the site that contains the data to be exported.

enter URL.png
2.

Choose how to connect to the server. Choose Interactive User to use the user you are logged into the network with. Choose Custom Account to enter a different user and the appropriate credentials.

enter account credentials.png

NOTE: Once you are connected to the SharePoint environment, you can switch to a different one. Please see How to Reset the Connection to the Source SharePoint Site from within the application for more information.

Highlights of List Bulk Export

Highlights of List Bulk Export

ListBulkExport.pngList Bulk Export allows you to pull documents, pictures, and list data from SharePoint to your file system. Large volumes of files that need to be accessed offline can be exported quickly and easily. Libraries can be exported with or without versions, and the set of files to export can be filtered by view based criteria. List Bulk Export runs in the background on your client machine, so you can continue to work while it is processing. Better yet, you can schedule it to run at a time that is convenient for you, and a convenient schedule setting automatically extracts only the documents that have been modified since the last export.

Deactivating the license for a Bamboo Desktop application

Deactivating the license for a Bamboo Desktop application

Bamboo Desktop applications (i.e., List Bulk Import, List Bulk Export) are activated using the Bamboo License Manager. See Activating a Bamboo Desktop Product Using the License Manager for more information.

It is not possible to deactivate a license with the Bamboo License Manager. Because licenses can be activated on only one PC at a time, you will need to deactivate a license if you wish to use it on another PC. To deactivate a license for a Bamboo Desktop application, follow these steps:

If your SharePoint WFE server does not have Internet access, you will not be able to deactivate a Bamboo product license from Central Administration. Instead, you can access the My Bamboo area of the Bamboo Solutions web site to deactivate any Bamboo product license key.

Follow the steps below:

Step Action
1. Determine the license key you want to move or deactivate. Go to the PC where it is activated and run the Bamboo License Manager.

LM2.9activate1.jpg

2. Click the Browse button and browse for the *.exe file for the licensed application.

LM2.9activate2.jpg

3. The application will appear in the drop down selection.

LM2.9activate3.jpg
Leaving the Enter valid License key box blank, click Activate.

4. The License Status will be displayed.

LM2.9activate4.jpg
Click Deactivate to deactivate the license key. Once it is deactivated, you can use it on another PC.

Activating a Bamboo Desktop Product Using the License Manager

Activating a Bamboo Desktop Product Using the License Manager

Overview of Licensing and and Product Activation

Follow the steps below to activate your Bamboo Desktop product with the Bamboo License Manager.

NOTE: Please install the Bamboo License Manager before proceeding. See Installing the Bamboo License Manager 2.9 for more information.

Step Action
1. From the shortcut on the Desktop where you installed the application, start the Bamboo License Manager. The screen shown below will appear.

LM2.9activate1.jpg

Click the Browse button to browse for the product that you wish to activate.
2. If you installed the product in the default location, there should be a product folder in C:Program filesBamboo Solutions Corporation.

LM2.9activate2.jpg

Locate the *.exe file for the product. For example, the *.exe file for Bamboo List Bulk Import, is Bamboo.BulkImport.exe as shown in the screen shot above.
3. You are returned to the License Manager and the appropriate product name should appear in the drop down selection.

LM2.9activate3.jpg

Enter your License Key in the space provided and click Activate.
4. The License Status screen will appear letting you know that your product is Active. The License Key used to activate is shown as the Serial Number.
LM2.9activate4.jpg
5. You can always follow steps 1-4 above to learn the status of your Bamboo product license; particularly if you are wondering what License Key you used to activate this instance of the product. However, in Step 3, rather than entering a License Key, just click Activate while leaving the License key space blank. The License Status screen will appear displaying the current status of the license.