IDUTRI
asked on
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.
What do you want to do, delete document libraries, delete lists, delete list items, ... ?
ASKER
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
FireWatch-PROD.bmp
If it is only one list you can just open it with datasheet view, select all and press the delete button.
ASKER
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
FW-List.bmp
Click on the list.
In the list view, click on actions. View in Datasheet
In the list view, click on actions. View in Datasheet
ASKER
I did try that one. But attached show that that is not an option
FW-2.bmp
FW-2.bmp
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.
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.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I put together what was suggested from other inquiries and what was suggested from this site.