[SPT/CWIS] SPT-CWIS-Users Digest, Vol 35, Issue 2

[Alejandro Fernandez]

Hi Ed,

The reason we used the database to delete these results was that we were 
testing the format and procedure for bulk uploads of 1000+ records at a 
time and then checking to see if we'd perfected the upload format so 
that future bulk uploads work without too many errors.

I'll take the delete button functionality and apply that to a bulk 
upload deletion if we do much more of this.

Thanks for the fix!

Ale

------------------------------

Message: 2
Date: Thu, 26 Jul 2007 09:20:20 -0500
From: Edward Almasy <ealmasy at scout.wisc.edu>
Subject: Re: [SPT/CWIS] "Empty" Search results
To: SPT / CWIS Users Discussion List <spt-cwis-users at scout.wisc.edu>
Message-ID: <124D8707-CD12-488C-9A76-4E2D37F75AA9 at scout.wisc.edu>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed

On Jul 26, 2007, at 4:38 AM, Ale Fernandez wrote:
 > The way we remove duplicate or test resources is simply deleting them
 > from the resources table on the database. I think this is probably not
 > enough?

     No, that will leave orphaned values
     behind in other tables.  Why not just
     use the "Delete Resource" button?


 > The problem we have now is if you go to the advanced search and search
 > by keyword, a lot of now deleted items still come up, as empty
 > records,
 > but still taking up spaces in the search results.

     You can fix this by deleting the contents
     of the SearchWords and SearchWordCounts
     tables (via SQL) and rebuilding the search
     database (via the option available on the
     Administration page).

     Ed

-- 
Ale Fernandez | a.fernandez at bristol.ac.uk
Technical Researcher, ID group | t:+44 (0)117 928 7124
Institute for Learning and Research Technology