Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

Delete ALL records from SharePoint 2007 Production site

I have just gone productional with a SharePoint 2007 site. Everything that I had created on my test SharePoint 2007 site was copied over to my productional site. This also included any test records that I created. They also got carried over. These test records reside directly on that SharePoint Production server. I am not using any external SQL database to store my records...So I don't know how to delete them as I do as if it were an external table.  Is there a way to delete all test records so that my customer can start with a 'clean slate' of actual production records? Thanks.
0
IDUTRI
Asked:
IDUTRI
  • 6
  • 4
1 Solution
 
KoenVostersCommented:
What do you want to do, delete document libraries, delete lists, delete list items, ... ?
0
 
IDUTRIAuthor Commented:
I'm gonna say list items...I attached a snapshot of the items that I have listed in my 'custom list'. Foregive me...But I've trying to self teach myself with 2007 SharePoint. I just took a weeks class with SharePoint 2010, and what a BIG difference to look and feel!
FireWatch-PROD.bmp
0
 
KoenVostersCommented:
If it is only one list you can just open it with datasheet view, select all and press the delete button.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
IDUTRIAuthor Commented:
Don't want  to be inept but not sure how to change it from a list view to a datasheet view so I can delete them.. I attached the list view. The one in question is called Active/Inactive Fire Protection
FW-List.bmp
0
 
KoenVostersCommented:
Click on the list.
In the list view, click on actions. View in Datasheet
0
 
IDUTRIAuthor Commented:
I did try that one. But attached show that that is not an option
FW-2.bmp
0
 
KoenVostersCommented:
Ok, let us go for the quick solution then.
Settings / Export list as template
When you export the list, make sure you do not check export list with data.
Create a new list with a different url and use the template you just used. Make sure everything is ok.
Delete that list. Delete the list with the data
Create a new list with the correct name and url.
0
 
IDUTRIAuthor Commented:
OK...I will give that a try using my development site as the 'guiney pig'. Will get back with you and let you know what happens. Thanks.
0
 
IDUTRIAuthor Commented:
I discovered that there was in fact a 'link' as to how to get to the datasheet view. If you refer back to the attachment I sent labeled FireWatch-PROD...There in fact is a link labeled 'Active Fire Watch Systems'. I didn't catch that because it wasn't underscored as to be a link...But when I hovered over it the 'finger' appeared and I clicked on that. Then I was able to proceed with deleting all of my records. Thanks for the help.
0
 
IDUTRIAuthor Commented:
I put together what was suggested from other inquiries and what was suggested from this site.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now