Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Bamboo Solutions Bulk Import

  Asked By: Travon    Date: Mar 18    Category: Sharepoint    Views: 2287

We are uploading a bunch of contact information in our sharepoint contact list using Bamboo Solutions bulk import tool. The problem we are having though is that no matter what value we put in for the Status (ie. Pending, Approved, or rejected) it always comes back pending. Is there a way to change this so they all upload with an approved status? We have to use versioning to review what our users want to post before it goes live, so the solution of turning it off won’t work.



7 Answers Found

Answer #1    Answered By: Laura Walker     Answered On: Mar 18

I have heard of this issue with several bulk  import programs but have not heard of a solution  other than a script that runs afterwards to change  the status.

Answer #2    Answered By: Percy Beach     Answered On: Mar 18

Would anyone happen to have this script that they wouldn’t mind sharing with me?

Answer #3    Answered By: Christop Mcfadden     Answered On: Mar 18

Okay we got past the problem  describe below, but now we are running into a different problem.

We are in the middle of a bulk  import of 90,000 sponsor locations into a sharepoint  list. However it is only doing about 1 to 2 records per second which is extremely slow! If you calculate the speed based on 2 records per second you’re looking at about 12.5 hours (which is dumb)! What is even more dumb is that this import  has been going since 10:30am yesterday and as of this morning there were only about 6000 records that had been uploaded! Why on earth is this going so slow!?! Can anyone help us at all?

Answer #4    Answered By: Kundan Jambhale     Answered On: Mar 18

Sharepoint lists were not designed to house this many entries. As a personal best practice if I think that a list  is going to have more than a couple thousand entries I put  the information  in a SQL database. You can then write a web part to expose the data in the SQL database to be viewed and edited. If you are using MOSS 2007 you should be able to get away with having more list entries. However, still 900,000 list item entries would still be best served from a database exposed through sharepoint.

Microsoft says that "The interface for enumerating list items does not perform well beyond a few thousand items." You can view the document here www.microsoft.com/.../stsb07.mspx?mfr=true The new version allows for more items but 900,000 items is still WAY to much.

Answer #5    Answered By: Alyssa Butler     Answered On: Mar 18

Large list  support is one of the three remaining platform busters from
my original dozen. The other two are relational lists and OLEDB access
to lists (which is quasi accomplished using Access 2007).

Answer #6    Answered By: Katy Patton     Answered On: Mar 18

I’m glad I found out now before for I got all 900,000 into a list. So my next question then is do you know of any websites or good documentation on how I can connect sharepoint  to an SQL table and view it within sharepoint so that I can change  and modify records in the portal?

Answer #7    Answered By: Ana Payne     Answered On: Mar 18

You use a connection string just like you would in any other ASP.NET application. Are you a developer? If not you will probably need to get a sharepoint  developer in on how to assimilate this project.

Didn't find what you were looking for? Find more on Bamboo Solutions Bulk Import Or get search suggestion and latest updates.