penfold_99

Hi Phil, have a look at this Development:Question type plugin how to - MoodleDocs it includes a template for a moodle quiz question it should be to hard to merge the example and the template.

SIMS.net Integration allow administration to offload the responsibility of have to create courses and manage there memberships. There are additional modules which sit on top of the basic SIMS.net integration. SIMS.net Timetable: This allows students and staff to see there timetables. The staff timetable also displays covers lessons. Parental Login (Soon to be release) This will allow parental access to moodle, a parent will be able to view The courses their child(ren) have without see other students in that course activity log. Parental Email. (Soon to be release) Staff will be able to send email to parents of students in a course or multiple courses, this email will then wait to be approved, once approved the mail will be sent overnight. Hope that give you an insight to what these module can do. If you let me know what you SMT require, i will be able to let you know if the module fulfil them.

sims.net enrolment plugin CyberNerd covered the others

@mpe do you really think people who aren't suppose to be here will fill out a census? The largest population that overstay there visa are from australia and new zealand, as they not pummelled by the meadia like other minorities. If a card had a single use are you going to carry 50+ cards? If a driving licence only had transport related use then why aren't cars fitted with a device which require your driving licence to be inserted and then check to see if your not banned and the car is insured?

This sound like the the for runner of the TIA (Total Information Access System) that was the mentioned in The Last Enemy that was on the bbc check out imdb. It's worrying when id cards are applied to services as you card could be cancelled centrally and you will be denied access and there wont be much you can do about it. i personally don't have a problem with id cards but why have them along with a driving licence, passport, national insurance card the list goes on. Why not just combine the driving licence and passport with an ID card in one card? One of the reasons behind the need for id card scheme is the government doesn't know how many people are in the country and who they are. it a fault of there own as they stopped counting people going out the country and counting them back in.

I will have a think about this. I'm look at a couple of different options as we will be having parental access via moodle.

Where you trying to attach a png image to this post as i cant view it as its giving your internal hostname for moodle.

Would it display the attendance for the course they are looking at or just a overall for all courses?

Can you expand on the context of how the data would be displayed?

Hi All, I have update SIMS.net Timetable Block for Moodle to version 1.2.2. CHANGELOG FIXED: Connection issues when using non standard port. FIXED: Now uses moodle DB layer instead of native php command for mssql. ADD: Ability to enable/disable link to moodle course. ADD: Error checking on SIMS.net connection. Links to the update version are Here

can you add the line var_dump(mssql_fetch_array($result)); on line 87 just before the while loop. if it doesn't return any results then there is a issue with freetds setup.

Hi All, I'm just after a show of hands, would people be interested in paid for support for the SIMS.net Moodle Modules? I was thinking of offering something like the following:- yearly/quarterly/monthly charge for support, pay per ticket priority upgrades (before released to the community) Install service (either on-site or remote) feature requests I have no idea what the charges would be but mainly wanted to see if there was a need?

Directly accessing the sql doesn't invalidate your licence but you need to be prepared to pay for capita to fix it it you break it, if you are the best thing to do is notify your LA and Capita you are. We have been reading data out of the sims database for over a year and not had any issues. As long as your not writing data back for sql and the data structure changes all that will happen is your queries will stop working. Yes you can, but you are limited but the reports you can generate in sims.net, you not able to do complex joins. The command reporter tool only runs on windows, so unless you do what dhicks has done a create a web service to read csv files created by sims you can't have your vle on linux without using sql to the sims database. Yes these is an api, good luck trying to get some usable documentation out of capita. It's very limited on examples of how to get data. The 5k for developers is to have a copy of sims. There is also a per school cost of £140 but this anti competitive against open source software. As for Write access there are mixed messages coming out of capita as the Business Objects documentation i have says they don't support it, but capita partners are able to offer it. Only if you where able to use it, without paying capita thousands in consultancy to help you. The data can written back to assessment marksheets as these would be unaffected but capita's upgrades. If you need extra fields just create extra aspects. This is how we link moodle and sims everything is linked by UPN. Data is best stored in one location, you could then use sims.net individual reports to pull the data from any aspect. these aspects could be filled in by your VLE or any other data collection process.

I am allowed to poke about with the DB directly as there is a caveat that if i break it i will pay for it to be fixed. So far, no breakages as all im doing is read only. If SIMS.net Business Objects Documentation was a little bit clearer and had a few more examples i would use it. I'm looking at parental access for moodle and this query is the data source. I'm trying to get a fully automated solution due to the sheer about of records and rolle assignments that need to take place. FreeTDS errors and moodle takes it as can't connect, i would like to surpress this error if possible, if the query can't be fixed i will have to do the heavy lifting in php.

what i am trying to to is turn multiple rows in to a single row. the data is the follow contact_id|forename|surname|student count|email|role|UPN 1|joe|bloggs|2|[email protected]|parent|1234ACBD 1|joe|bloggs|2|[email protected]|parent|5678ABCD needs to be converted to the following 1|joe|bloggs|2|[email protected]|parent|1234ACBD;5678ABCD

Hi All, I am getting the following error Msg 8153, Level 0, State 1, Server XXXX\XXXX, Line 2 Warning: Null value is eliminated by an aggregate or other SET operation. The query i'm running is SELECT contact_id, forename, surname, COUNT(contact_id) AS students, email_address AS email, 'Parent' AS role, UPNS = REPLACE ((SELECT unique_pupil_no AS [data()] FROM sims.stud_via_student_browse INNER JOIN sims.rpt_vix_StudentContact_705 ON sims.stud_via_student_browse.person_id = sims.rpt_vix_StudentContact_705.student_id WHERE sims.rpt_vix_StudentContact_705.contact_id = c.contact_id AND sims.rpt_vix_StudentContact_705.email_address IS NOT NULL AND sims.rpt_vix_StudentContact_705.forename IS NOT NULL AND unique_pupil_no IS NOT NULL ORDER BY sims.rpt_vix_StudentContact_705.contact_id FOR XML PATH('')), ' ', ';') FROM sims.rpt_vix_StudentContact_705 AS c WHERE (email_address IN (SELECT email_address FROM sims.rpt_vix_StudentContact_705 GROUP BY email_address HAVING (COUNT(contact_id) > 1))) AND (forename IS NOT NULL) AND (parent = 'T') AND (email_address IS NOT NULL) AND student_id IS NOT NULL GROUP BY email_address, surname, contact_id, forename I problem is the select within the replace as it works find without it (but doesn't include the data i need) I have tried check everything is not null but still no luck. Any one got an idea?

Hi, you might not be able to view to the page as iis might not be setup. you can connect via tsql so there no firewall issues. Add the views and it should work.

If you run these queries it will create the required views. CREATE VIEW mdl_student_timetable_v1_0 AS SELECT TOP (100) PERCENT sims.rpt_vix_timetable.period_name, sims.rpt_vix_timetable.class_name,sims.stud_via_student_browse.unique_pupil_no,sims.rpt_vix_timetable.staff_initials, sims.rpt_vix_timetable.room_name FROM sims.stud_via_group_members INNER JOIN sims.curr_class_period ON sims.stud_via_group_members.base_group_id = sims.curr_class_period.base_group_id INNER JOIN sims.stud_via_student_browse ON sims.stud_via_group_members.person_id = sims.stud_via_student_browse.person_id INNER JOIN sims.rpt_vix_timetable ON sims.curr_class_period.class_period_id = sims.rpt_vix_timetable.class_period_id WHERE (sims.curr_class_period.person_id IS NOT NULL) AND (sims.rpt_vix_timetable.end_date > GETDATE()) AND (sims.stud_via_group_members.start_date < GETDATE()) AND (sims.stud_via_group_members.end_date > GETDATE()) ORDER BY sims.rpt_vix_timetable.period_name CREATE VIEW mdl_staff_timetable_v1_0 AS SELECT TOP (100) PERCENT sims.rpt_vix_timetable.period_name, sims.rpt_vix_timetable.class_name, sims.rpt_vix_timetable.staff_initials, sims.rpt_vix_timetable.room_name FROM sims.curr_class_period INNER JOIN sims.rpt_vix_timetable ON sims.curr_class_period.class_period_id = sims.rpt_vix_timetable.class_period_id WHERE (sims.rpt_vix_timetable.end_date > GETDATE()) ORDER BY sims.rpt_vix_timetable.period_name

Is the tabletime blank or the page blank? Have you installed and configured the enrolment plugin? Have the views been created in ms sql server?

I looking into creating a web service that uses the SIMS.net Business Objects, i tried to create all the reports using the command report tool like dhicks, but some i needed to join to reports together and some i could even create. I'm currently in the process of getting my head round visual c# once i have cracked that and got the data out of SIMS.net the offical way then i will release it to the community.

Instead of having to wait, just click the link on the first post. It goes to the same place.

There is, It's probably going through the checking process again as i changed the title. Last time it took a day or so to appear for other users.

I have changed the SIMS.net Timetable Block to SIMS.net Integration on the plugins Moodle website. This now directs to the documentation which has the correct links.

I loved shadow warrior, which version did you have the import with ninja stars or the uk version with darts?

Personally i would like to see if you could do any better! Do you really think capita would the following. Send a Programmer to a School? Allow us to be charged for a day's consulting to create a web service when Phil Neal quoted £50,000 for capita to do the same thing. Actually Accredit the software knowing that if will be offered for free? I belive Capitas documentation is standard if it isn't then it is acting anti-competitively by with holding it.