On Mittwoch, 9. September 2009, Karen L Schuchardt wrote:
> Thanks for the pointer. We have tried this but the data in the semantic
> media wiki extension table is is not deleted. Thus when we perform ask
> queries, we continue to get results for pages that have been deleted.
Interesting. SMW usually cleans its records when pages are deleted *in the
wiki*. Maybe more is needed to make sure that this also happens when using the
DeleteBatch extension to delete pages (or did you use the MW script?). In any
case, the deleted pages will continue to have IDs in SMW (and hence "exists"
in a sense), but they should not have any other properties.
> I will look at the extension you mention. Presumably it is true that I
> could delete all records in the SMW tables with matching subject-id
> fields to pages that are being deleted and that would constitute
> complete and proper cleanup?
That would not be the preferred method, since you need to know the internal
storage logic to do such clean-up properly (e.g. for n-ary datatypes, you need
to clean further tables and ids).
In general, you can always perform the steps for SMW data repair  to fix
SMW records. It is also possible now to call the script SMW_refreshData.php
with a specific page name to refresh, so this would be another option for
cleaning a deleted page's data.
> Yaron Koren wrote:
> > This list is intended only for SMW-related discussions, but the
> > easiest solution for you is probably this extension:
> > http://www.mediawiki.org/wiki/Extension:DeleteBatch
> > On Wed, Sep 2, 2009 at 8:10 PM, Schuchardt, Karen L
> > <Karen.Schuchardt@... <mailto:Karen.Schuchardt@...>> wrote:
> > Hi all,
> > We have a need to programmatically delete wiki pages in order to
> > clean up after ourselves as a result of both system and user
> > testing. The number of pages involved can easily run into the
> > hundreds or thousands so deleting interactively is not an option.
> > We can generate a list of page names targeted for deletion. Is
> > there an admin script that would do this for us. We have not been
> > able to find anything. If not, could somebody please provide
> > advise on all the steps that need to be taken.
> > Thanks in advance,
> > Karen
> > -------------------------------------------------------------------------
> >----- Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> > 30-Day
> > trial. Simplify your report design, integration and deployment -
> > and focus on
> > what you do best, core application coding. Discover what's new with
> > Crystal Reports now. http://p.sf.net/sfu/bobj-july
> > _______________________________________________
> > Semediawiki-devel mailing list
> > Semediawiki-devel@...
> > <mailto:Semediawiki-devel@...>
> > https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
Markus Krötzsch <markus@...>
* Personal page: http://korrekt.org
* Semantic MediaWiki: http://semantic-mediawiki.org
* Semantic Web textbook: http://semantic-web-book.org