Solved

Delete ALL records from SharePoint 2007 Production site

Posted on 2011-02-21
10
239 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

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.

Question has a verified solution.

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

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

816 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now