RE: [Webct-admin] Purge scripts?

[Laura G. <lge...@nd...>]

Hey Jeff, I'm sure you meant me, Laura. I received errors on person imports
even though I did the next import of identical persons over a week later!

WebCT did send me a script which compared two tables, finding those tables
populated with identical people, over 10,000 of them to be precise, WebCT
sent me a script to remove the discrepancies. Incidentally, there were never
more than 2200 people in our database at any given time.

The learning context re-imports were also done within hours of one another,
and across weeks.

Now that we've put the database on the same side of the firewall with the
app servers, we don't seem to have quite as big of a problem.

Laura

Laura Gekeler, WebCT Vista Applications Admin
Educational Technologies & Services, OIT
University of Notre Dame
P: 574-631-8795
E: lge...@nd...
W: http://www.nd.edu/~training

-----Original Message-----
From: web...@li...
[mailto:web...@li...] On Behalf Of Jeff Longland
Sent: Friday, February 11, 2005 12:17 PM
To: 'WebCT Administrator's List'
Subject: Re: [Webct-admin] Purge scripts?

Hi Tricia,

I'm curious - how long did you wait after deleting the learning contexts 
in the GUI before importing the new data?

Cheers,
Jeff

---
Jeff Longland
Web and Instructional Support
Information Technology Services
The University of Western Ontario
London, Ontario N6A 5B7
Phone: (519) 661-2111 ext. 85327
Fax: (519) 661-3486
E-mail: jlo...@uw...

Laura Gekeler wrote:
> No, Tricia. I've received no response from the list; My support ticket 
> to WebCT generated a phone conference in which WebCT told me there is no 
> reason not to use the GUI to delete data. They do not have purge scripts 
> built and available for clients.
> 
>  
> 
> My most recent GUI delete of data went much better than previous ones 
> (now that my test server's database is running on the app server) but 
> still left the database in an inconsistent state so that my next import 
> created exceptions when it tried to rewrite previously deleted data that 
> is still in some middle state, neither really deleted nor really 
> there..  In one case, two versions of a group were created, the 2^nd one 
> with a space and the digit "1" after it.
> 
>  
> 
> Laura
> 
>  
> 
> Laura Gekeler, WebCT Vista Applications Admin
> 
> Educational Technologies & Services, OIT
> 
> University of Notre Dame
> 
> P: 574-631-8795
> 
> E: lge...@nd... <mailto:lge...@nd...>
> 
> W: http://www.nd.edu/~training
> 
> ------------------------------------------------------------------------
> 
> *From:* Tricia McKellar [mailto:tri...@nc...]
> *Sent:* Monday, January 24, 2005 11:24 AM
> *To:* Laura Gekeler
> *Cc:* 'WebCT Administrator's List'
> *Subject:* Re: [Webct-admin] Purge scripts?
> 
>  
> 
> Laura Gekeler wrote:
> 
> Has anyone developed purge scripts for use removing the learning context 
> while doing testing in order to remove all user data?
> If not, how do you do it other than a complete database restore?
> 
> 
> Hi Laura,
> Did you get any feedback on this? We will have a need to clean our 
> development db shortly.
> Thanks,
> Tricia
> 


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 2/10/2005



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Webct-admin mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/webct-admin