Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Delete ALL records from SharePoint 2007 Production site

Posted on 2011-02-21
10
Medium Priority
?
244 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

670 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