Re: [WWdevel] maa webwork site? -- archived forum posts have bad dates.

[Michael G. <ga...@ma...>]

On Jun 15, 2007, at 12:07 AM, Sam Hathaway wrote:

> on 06/14/2007 09:19 AM Michael Gage said the following:
>
>> I agree.  There is some hope that we can recover this eventually
>> since I believe it is a one time
>> data loss caused by the move.  The posts in the archive forum still
>> have the date preserved on the internal
>> data.  The newer posts from the last 6 months don't have any dates.
>>
>> As I said I'm still saving all of the original forums -- it may be
>> that we'll need direct access to the mysql database
>> on the maa machine in order to transfer the posts over with data.
>> Except for the archived posts there are only a few hundred entries so
>> it could be done somewhat manually.
>>
>> Anyone have any suggestions?
>
Hi Sam,

> I'm wondering if it's possible to post each Frontier message as a
> separate message in Moodle, rather than having an entire discussion  
> end
> up as a single Moodle message.
>
We could do a little custom programming that would output the  
frontier database into xml.
(Frontier has automatic xml creation from it's internal structures so  
it wouldn't be too hard.)
Then you'd have to transform it into some kind of xml that moodle  
could read.
> The one snag I can think of is that each message needs to have a user
> associated with it, and we probably don't want to deal with the  
> headache
> of importing all the old users from the Frontier site.
>
> As far as the posting dates go, dates seem to be part of the exported
> XML file format -- the <POST> structure has <CREATED> and <MODIFIED>
> field, and the <DISCUSSION> structure has a <TIMEMODIFIED> field  
> (which
> should probably match the <MODIFIED> parameter of the most recently
> modified <POST> within it).
>
> So I guess I'm unclear on how the post times got lost in the first  
> place.

I think it's a bug in the archiving method of moodle -- or perhaps  
the unarchiving method.  If you look at the
xml from the backup files you find    timestart=0 and timeend=0 .  If  
I look in the database the time stamp is definitely 0.

It's kind of clear what data is missing.
The question is how to fix it without direct access to the MAA database.

While we're on the subject I'm having trouble handling "student  
enrollments" on the MAA moodle as well.  I created the AIM course
for this upcoming workshop and it seems to have automatically  
enrolled all the current members of the site -- and when I try to
unenroll them nothing happens.  ????  I haven't been able to track  
this one down.  I'll try to duplicate it on my local copy of moodle.

Take care,
Mike

> -sam
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> OpenWeBWorK-Devel mailing list
> Ope...@li...
> https://lists.sf.net/lists/listinfo/openwebwork-devel
>