SharePoint Web Parts
Our entire SharePoint web part listing.
Click on the Web Part to read a more detailed description
List Bulk Import - Release 1.5 - from Bamboo Solutions
List Bulk Import allows you to migrate data and documents into SharePoint from legacy databases, spreadsheets, SharePoint (SPS 2003/WSS V2) to SharePoint (MOSS 2007/WSS V3), or for any SharePoint document management application or organization with large volumes of data and or documents that need to be widely accessed. Retain valuable index information when importing to SharePoint, eliminating the need for data re-entry. The import program has the option of running in the background, allowing users to continue to work while the application uploads documents and data to SharePoint.
| List Bulk Import vs. SharePoint Out-of-the-Box Functionality |
SharePoint OOTB | Bulk Import | |
| Import both metadata properties and attached documents. |  |
||
| Allow users to map fields between source and destination lists. | |
||
| Provide value mapping for choice and lookup fields (i.e. source:Yes = destination:True). | |
||
| Import Excel, CSV or text delimited files. | * | |
|
| Can import data into existing lists that already has data. | |
||
| Check for duplicate existing records. Skip or update with new data. | |
||
| Works with many lists including document libraries. | |
||
| Automatically import sub folders and create same hierarchy in the target document library. - New! | |
||
| The ability to automatically rename files to avoid overwriting of existing files. | |
||
| Import parameters can be saved and re-use for subsequent import runs. | |||
| Can be run in the background with scheduled intervals. | |||
| Post-import log file provides summary of success and failure records. | |||
| Import one SharePoint list to another, even across sites, and from SharePoint V2 to SharePoint V3. | |||
| Import data from database table or view into a SharePoint list. | |||
| Import versions of Issues Lists and Document Libraries. - New! | |||
| Import files from network folders into SharePoint Document and Pictures Libraries. - New! | |||
 Includes partial support for this feature. Custom coding may be required. |
|||
How Does It Work?
The List Bulk Import Web Part can be run on a client machine (no server install required). Once installed, you must connect to a SharePoint server that you want to import data to, select a data source to import from (i.e. Excel, ODBC driver, or SharePoint List), map fields from the data source to the target SharePoint List, determine how you want to handle duplicate records, select to import all versions (if importing an Issues List or Document Library with versioning), if needed, and then import the data. You can also choose to save the import configuration to reload it again manually or to schedule regular imports of data to run unattended according to that configuration. There is a log file that can be viewed from the application as well to check on processing and to help resolve any import errors.
Why Did We Build It?
Many organizations today are realizing the benefit of using SharePoint as a collaboration and communication tool for their internal and external customers. Like many other enterprise-wide systems, it takes time for users to adapt to using this kind of tool on a daily basis. Allowing users to access their existing data from SharePoint soon after implementation allows end users to get up and running quickly and easily. List Bulk Import allows you to focus on designing the best way to use SharePoint for your business rather than worry about migrating your existing data.
