Solved

Delete ALL records from SharePoint 2007 Production site

Posted on 2011-02-21
10
241 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

828 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