Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Delete ALL records from SharePoint 2007 Production site

Posted on 2011-02-21
10
Medium Priority
?
247 Views
Last Modified: 2012-06-21
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
Comment
Question by:IDUTRI
  • 6
  • 4
10 Comments
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34943342
What do you want to do, delete document libraries, delete lists, delete list items, ... ?
0
 

Author Comment

by:IDUTRI
ID: 34943452
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
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34943499
If it is only one list you can just open it with datasheet view, select all and press the delete button.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:IDUTRI
ID: 34943746
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
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34943759
Click on the list.
In the list view, click on actions. View in Datasheet
0
 

Author Comment

by:IDUTRI
ID: 34943804
I did try that one. But attached show that that is not an option
FW-2.bmp
0
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34943838
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
 

Author Comment

by:IDUTRI
ID: 34943896
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
 

Accepted Solution

by:
IDUTRI earned 0 total points
ID: 34947216
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
 

Author Closing Comment

by:IDUTRI
ID: 34986562
I put together what was suggested from other inquiries and what was suggested from this site.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question