penfold_99

Hi, I will be exporting the data as enrolment and timetable changes happen at semi frequently, so once an hour should be fine. Course enrolment is done at login not as a cron job.

@ssiruuk2 I have completely re written the SIMS.net Moodle Integration. The new version uses the command reporter tool. It also removes the technical issues with direct access to the SIMS.net database. I'm looking at offering this new version of SIMS.net Moodle Integration under a co-operative subscription. Everyone pays a annual flat fee and get access to all moodle modules of the same grade i have created and any updates to them in that time. would this be of something that might interest you?

the code is as per your previous email. One way to test testing put your code in a subfolder and not on the web root. make sure there isn't an x.gif on the root and it shoule be able to replicate. I think i will just include a note, if they need support for IE6 they need to copy the file to the webroot.

hi chris, Option 2a works but option 2b doesn't. The problem for 2b is it finds the shim for the border if i stipulate a url to it but. then reverts back to the local servers www root to look for the shim for the little graphics in the widget. I would prefer having all the files in one place. Having x.gif in the root of moodle it might be delete at a later date as it looks like it should belong there.

Have you got any links to the website for the "real deal BO engine"?

Just get them to release plain English documentation with an example on how to get data when using there business object, that would be great!! but this is even less likely than the above option

Hi Chris, Please ignore my previous message i have traced down the x.gif file. The problem i have now it i get a picture place holder over the pictures in the widget.

We're trying to migrate all users over to firefox but some exam boards require the use of IE6. I have tried this but it require a transparent file called x.gif, i don't know what in needs to be. Could you ask you HTML guru? I tried example b first but could get it to update the fields properly so when for the widgets.

hi geoff, The simple answer is no. If you were able to use SIMS.net business objects to writeback SIMS.net then it's possible. The easiest way is to ask for the parental email as part of your data collection process in september then your admin staff can update all the records in the same process. On a side note where are you parental emails currently stored? We are currently testing a email parent system i have created in moodle that also allows parental access.

Hi Chris, Im currently unable to get the above code to work, if i include it it stops the widgets from being displayed.

Hi Chris, Thanks for the additional fixes. Were just about to purchase papercut any chance of a discount in return for releasing this module?

thats slow compared to some of the blocks i have written. from concept to working live it was less than 30 minutes. I created a zimbra single sign on block while doing a sims.net upgrade.

I will add in tomorrow and test it, if i dont get a chance is monday ok?

i have tested with both IE and firefox, ie has issues with png files so there is a small border around the image that isn't there in firefox. Do people need to be able to see there print credits out side the school? it wont be hard to add in a if statement to check the clients ip to see it is in the same subnet as the server.

I'm a pragmatist, if it work then its good. Your script is nearly like for like with mine but mine is in a block. the only modification i need to do is allow the paper cut server url to be configured for the block management in moodle. is there any other blocks you might need?

Hi Just to let you know i have created a block that uses papercut's web widgets. i just need to make it more flexible then i will release it.

This is something that i can knock together for you if your happy for me to have the copyright but release it under gpl?

yep still walking, he got discharged from hospital 3 days later

We create our accounts via a moodle block, this pulls information from sims compares it to AD if the user is missing then the account is created. As for parents is similar but as a moodle enrolment plugin, this is current under testing. The parental account is only a moodle account not AD, as we don't envisage the need to give parents access to services outside moodle.

@matt40k well if if capita could understand the business model of open source it would be a help. They wont supply the business object documentation unless your a technical partner, to become one you need to have signed a nda. the nda is anti competitive against open souce. If i were to become a technical partner myself i would need to fork out £5000 for the privilege, that is a non starter. I could cope with the £140 a site as that is a fee i think school would have a problem with.

hi thanks for your ideas. it wont be possible to normalise the database as im pulling most of the data from anthor database which i dont have control and trying to make the best of a crap database. i thought about a case statement but would be hard to keep upto date. I think i will have to do it via vba.

thanks but there will be upto 20 subjects and i would like only one query.

Hi All, I am in need of some sql magic, i have a table with the follow columns teacher , subject ,english, maths, science mr smith, science ,27 , 28 , 30 i would like to return the following mr smith, science,30 is this possible with sql in access? i would prefer doing this in sql and not vba.

The components will be release open source, i just want to be sure there are not data protection issues. my system with use the parent email address as the username. do you have a full complement of parental emails?

@reggiep: Parental access with moodle is something i'm currently working on. I have a proof of concept working on our test server along with a email parents module. I am currently testing the moodle permissions and what configuration is required so parents don't have access to the wrong area's.