• US 1.877.226.2662   INTL +44 (0) 203.598.2917   
  • Home
  • Contact Us
 
 

List Bulk Import

  E-mail this item to a friend Go to: 
 
Quickly import and share large volumes of critical documents and data in SharePoint from legacy databases, spreadsheets, network file directories, or SharePoint Lists.

Many organizations are currently realizing the benefit of using SharePoint as a collaboration and communication tool for their internal and external customers. Like many enterprise-wide systems, it takes time for users to adapt to using this new platform for their day-to-day activities. In general, allowing users to access their legacy data from SharePoint soon after implementation provides for a faster acceptance and adoption from the user base at large.

List Bulk Import

List Bulk Import from Bamboo Solutions allows you to migrate data, documents, and pictures into SharePoint from legacy databases, spreadsheets, local/network file shares, and finally, Lists and Libraries from SharePoint 2007, SharePoint 2010, SharePoint 2013, or SharePoint Online (part of Microsoft's online hosting solution—Office 365—for all four current SharePoint platforms: 2007, 2010, 2013, and SharePoint Online).

List Bulk Import


List Bulk Import includes these features:

  • Data Sources
    • Microsoft Excel Files (.xls /.xlsx)
    • Delimited Text Files (CSV and .txt)
    • SQL Server 2005, 2008, or 2012 Tables and Views (ODBC Connection)
    • Local/Network File Shares
    • SharePoint 2007 (WSS and MOSS)
    • SharePoint 2010 (Foundation and Server)
    • SharePoint 2013 (Foundation and Server) (New!)
    • SharePoint Online, Microsoft Office 365
  • Target Location
    • SharePoint 2007 (WSS and MOSS)
    • SharePoint 2010 (Foundation and Server)
    • SharePoint 2013 (Foundation and Server) (New!)
    • SharePoint Online, Microsoft Office 365
  • Multiple Import Modules
    • Import Wizard for importing metadata to lists and libraries
      • Map source columns to one or more target columns
      • Map unique values from the source to values in the target for Choice, Lookup, and People and Group columns
      • Map historical columns (created by, modified by, created, and modified) to the target columns to maintain item history
      • Choose to skip or update duplicate records
    • Replication Wizard for replicating local/network file shares or existing SharePoint Libraries
      • Choose to retrieve files only from the root, or to include the sub folders
      • Choose to recreate the file structure by creating new folders automatically, or store all files in the root directory
  • Store import job configuration information to a template file for common imports and scheduled imports
  • Schedule routine imports to run in the background for overnight import jobs
  • Generate log information during processing that provides a summary of successful and failed records

SharePoint provides a foundation for corporations to begin modernizing their collaboration from archaic tools such as email, local file systems and, in many cases, hard copy documents to providing a means for users to interact in real time. With SharePoint, the days of duplicated work, lost files, and large storage rooms are long gone. SharePoint out-of the-box provides basic tools such as Document Libraries, Dashboards, Lists, and even Calendars. Although these are what most companies require to initially get their collaborative portals underway, they are just basic building blocks. List Bulk Import allows users to migrate data, documents, and pictures into SharePoint from legacy databases, spreadsheets, local/network file shares, and finally, Lists and Libraries from SharePoint 2007, SharePoint 2010, SharePoint 2013, or SharePoint Online (part of Microsoft's online hosting solution—Office 365—for all four current SharePoint platforms: 2007, 2010, 2013, and SharePoint Online). Here is the comparison chart to show SharePoint out-of the-box versus List Bulk Import:

SharePoint Out-of-the-Box vs. List Bulk Import Functionality Features SharePoint
2007 and 2010
SharePoint
2013
Bamboo List Bulk Import
Data source: Microsoft Excel Files (.xls /.xlsx)      
Data source: Delimited Text Files (CSV and .txt)      
Data source: SQL Server 2005, 2008, 2012 Tables and Views (ODBC Connection)      
Map source columns to one or more target columns      
Map unique values from the source to values in the target for Choice, Lookup, and People and Group columns      
Map historical columns (created by, modified by, created, and modified) to the target columns to maintain item history      
Choose to skip or update duplicate records      
Replicating local/network file shares or existing SharePoint Libraries: Choose to retrieve files only from the root, or to include the sub folders      
Replicating local/network file shares or existing SharePoint Libraries: Choose to recreate the file structure by creating new folders automatically, or store all files in the root directory      
Store import job configuration information to a template file for common imports and scheduled imports      
Schedule routine imports to run in the background for overnight import jobs      
Generate log information during processing that provides a summary of successful and failed records      
Import data into all versions of SharePoint      

List Bulk Import Web Part can be run on a client machine (no server install required, but it is recommended). Once installed, you must connect to a SharePoint server to which you want to import data, select a data source to import from (i.e., Excel, ODBC driver, or a 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 schedule regular imports of data to run unattended according to that configuration. To check on processing, and to help resolve any import errors, there is a log file that can be viewed from the application as well.

Product Description Price Order
SharePoint 2007 & SharePoint 2010 & SharePoint 2013
Client License Software, Release 3.0 for SharePoint 2007, 2010, 2013 and SharePoint Online (Office 365). Includes one year of basic technical support providing a 2-business-day response time and free access to all maintenance service pack releases. Valid for 1 year from the date of purchase. (HW18.R3.0.ML) $1,195.00
 
 Quantity:  
   
Premium Support Premium technical support for SharePoint 2007, 2010, 2013 and SharePoint Online (Office 356) provides 4-hour response time. Free maintenance, updates, minor and major releases. Valid for 1 year from the date of purchase. (HW18.R3.0.SP) $298.00
 
 Quantity:  
   
Trial Download 30-Day Free Trial Download for SharePoint 2007, SharePoint 2010, or SharePoint 2013. This trial is limited to 15 records for each import. (HW18.R3.0.TD) FREE
 
 Quantity:  
1

 
  SP 2007:

SP 2010:
SP 2013:
   
     
SharePoint 2007    
SharePoint 2010    
SharePoint 2013    
 
 
 
Calendar Plus Web Part Calendar Plus Web Part
Do you want to display your SharePoint list items in a calendar but are frustrated with the limitations of the default calendar view? You need the flexibility of the Calendar Plus Web Part.
Read more   
$1,295.00
List Rollup Web Part List Rollup Web Part
Do you want to consolidate various SharePoint list items from multiple areas and web sites into a single view with the ability to display, filter, and sort relevant information? You need the List Rollup Web Part.
Read more   
$995.00
List Search Web Part List Search Web Part
Do you simply need to search within a SharePoint list but find the default search capability impossible to use? Our List Simple and Advanced Search web parts can be configured to search any fields of any list, display results using a view, and allow for AND/OR operators (Advanced version).
Read more   
$495.00
 
 
 
Data-Viewer Web Part Data-Viewer Web Part
Easily customize the look and feel of SharePoint Lists, SQL, Bamboo List Rollup, or Business Data Catalog data in a grid style data view without using SharePoint Designer. Add flexible data grouping, sorting, and filtering as well as show nested list data in the same view.
Read more   
$995.00
List Bulk Export List Bulk Export
Do you need an easy to use application that allows you to export documents from a SharePoint Document Library to your file system? Need it to provide full process logging and have the capability to be scheduled on a regular basis? Our List Bulk Export is just what you need.
Read more   
$495.00