Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Perl (http://www.go4expert.com/forums/perl/)
-   -   Using Perl on XML (http://www.go4expert.com/forums/using-perl-xml-t11928/)

tress 7Jul2008 15:43

Using Perl on XML
 
Hi,

Please excuse me if this post is a little sketchy first post here. I am trying to work my way through a folder containing many xml files, a lot of these files dont have correct opening and closing xml tags contained within. What I want to do is read each file and extract 4 tags from each (these tags are properly openeded and closed with <>) and if at all possible load them into 1 Excel Sheet for later importing so I will have 4 columns and 1 xml file per row, I have some script that will read 1 file and output it to the screen but will not do a lot else, while outputtin I would also like to fix the bad tags replacing &lt; with < and &gt with > if this is also possible.

My script so far, sorry there is not more

#!/usr/bin/perl
use XML::Simple;

my $xml = XMLin('280643TextCopy.txt');

print "InstitutionType=$xml->{InstitutionType}\n";
print "InstitutionName=$xml->{InstitutionName}\n";
print "InstitutionNumber=$xml->{InstitutionNumber}\n";
print "InspectionNumber=$xml->{InspectionNumber}\n";
print "TransformedXML=$xml->{InspectionReport}->{TransformedXml}\n";

I am running this on a Windows XP machine, if a sample of the XML is needed as well I can provide this.

Thanks T

naveen 9Jul2008 23:51

Re: Using Perl on XML
 
Hi,

To be able to directly create an excel sheet, you need to use a module such as Spreadsheet::WriteExcel , which requires a good knowledge of Perl and programming. An easier approach would be to simply create a comma separated file containing the values which you require, and then manually import the csv file into any spreadsheet software, which can then be saved as excel file.

For me to be able to comment on fixing the tags in your xml files, and suggest other possible ways of solving your problem, you need to upload/paste a sample xml file. I'll have a look at what can be done.

Regards
Naveen

tress 10Jul2008 02:35

Re: Using Perl on XML
 
Hi Naveen,

Thank you very much for the reply, I am afraid what I know about Perl could be written on a postage stamp though I am trying to learn though the time limit I have to do this is sounding a little stringent for what I am going to need to know.

I have had to include the sample file as part of the post as its too big to upload and I didn't want to start ripping parts out incase I made the xml invalid

Thanks again for the help!

Code:

<?xml version="1.0"?>
<Inspection xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <FileName>S:\Schools data\MEG\280643.XML</FileName>
  <InstitutionType>SC</InstitutionType>
  <InstitutionName>Name</InstitutionName>
  <InstitutionNumber>InsNumber</InstitutionNumber>
  <InspectionNumber>InspNumber</InspectionNumber>
  <Date>06/06/2007</Date>
  <IndependentSchool>false</IndependentSchool>
  <InspectionType>S5</InspectionType>
  <Inspectors>
    <OIN>33910</OIN>
    <Name>NAME</Name>
    <LeadInspector>true</LeadInspector>
    <AssistantInspector>false</AssistantInspector>
  </Inspectors>
  <Inspectors>
    <OIN>23393</OIN>
    <Name>NAME</Name>
    <LeadInspector>false</LeadInspector>
    <AssistantInspector>true</AssistantInspector>
  </Inspectors>
  <Inspectors>
    <OIN>8250</OIN>
    <Name>NAME</Name>
    <LeadInspector>false</LeadInspector>
    <AssistantInspector>true</AssistantInspector>
  </Inspectors>
  <Inspectors>
    <OIN>19452</OIN>
    <Name>NAME</Name>
    <LeadInspector>false</LeadInspector>
    <AssistantInspector>true</AssistantInspector>
  </Inspectors>
  <SchoolEfs>
    <InspectorOin>33910 - NAME</InspectorOin>
    <ObservationTime>25</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>10</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>SU</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>27</Present>
    <Nor>30</Nor>
    <SubjectCode1>SC</SubjectCode1>
    <SubjectCode2>BI</SubjectCode2>
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>0</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>0</OthAssistantCount>
    <InspInitialWithEf>RJ02</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>3</Overall>
    <Standards>0</Standards>
    <Progress>0</Progress>
    <PersonalDev>0</PersonalDev>
    <Teaching>3</Teaching>
    <Curriculum>0</Curriculum>
    <Care>0</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolEfs>
    <InspectorOin>33910 - NAME</InspectorOin>
    <ObservationTime>30</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>7</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>MC</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>18</Present>
    <Nor>23</Nor>
    <SubjectCode1>SC</SubjectCode1>
    <SubjectCode2 />
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>0</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>1</OthAssistantCount>
    <InspInitialWithEf>RJ04</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>3</Overall>
    <Standards>0</Standards>
    <Progress>0</Progress>
    <PersonalDev>0</PersonalDev>
    <Teaching>3</Teaching>
    <Curriculum>0</Curriculum>
    <Care>0</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolEfs>
    <InspectorOin>23393 - NAME</InspectorOin>
    <ObservationTime>30</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>9</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>MC</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>25</Present>
    <Nor>30</Nor>
    <SubjectCode1>MA</SubjectCode1>
    <SubjectCode2 />
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>2</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>0</OthAssistantCount>
    <InspInitialWithEf>BD03</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>3</Overall>
    <Standards>0</Standards>
    <Progress>3</Progress>
    <PersonalDev>3</PersonalDev>
    <Teaching>3</Teaching>
    <Curriculum>0</Curriculum>
    <Care>0</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolEfs>
    <InspectorOin>23393 - NAME</InspectorOin>
    <ObservationTime>30</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>9</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>SU</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>26</Present>
    <Nor>28</Nor>
    <SubjectCode1>EN</SubjectCode1>
    <SubjectCode2 />
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>0</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>0</OthAssistantCount>
    <InspInitialWithEf>BD07</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>2</Overall>
    <Standards>0</Standards>
    <Progress>2</Progress>
    <PersonalDev>2</PersonalDev>
    <Teaching>2</Teaching>
    <Curriculum>0</Curriculum>
    <Care>0</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolEfs>
    <InspectorOin>23393 - NAME</InspectorOin>
    <ObservationTime>30</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>7</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>MC</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>24</Present>
    <Nor>25</Nor>
    <SubjectCode1>SP</SubjectCode1>
    <SubjectCode2 />
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>0</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>0</OthAssistantCount>
    <InspInitialWithEf>BD08</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>3</Overall>
    <Standards>0</Standards>
    <Progress>3</Progress>
    <PersonalDev>3</PersonalDev>
    <Teaching>3</Teaching>
    <Curriculum>0</Curriculum>
    <Care>0</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolEfs>
    <InspectorOin>8250 - NAME</InspectorOin>
    <ObservationTime>30</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>10</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>SU</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>28</Present>
    <Nor>30</Nor>
    <SubjectCode1>MA</SubjectCode1>
    <SubjectCode2 />
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>0</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>0</OthAssistantCount>
    <InspInitialWithEf>MH01</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>2</Overall>
    <Standards>3</Standards>
    <Progress>2</Progress>
    <PersonalDev>2</PersonalDev>
    <Teaching>2</Teaching>
    <Curriculum>2</Curriculum>
    <Care>2</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolEfs>
    <InspectorOin>8250 - NAME</InspectorOin>
    <ObservationTime>30</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>10</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>SA</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>21</Present>
    <Nor>23</Nor>
    <SubjectCode1>MA</SubjectCode1>
    <SubjectCode2 />
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>0</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>0</OthAssistantCount>
    <InspInitialWithEf>MH03</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>2</Overall>
    <Standards>3</Standards>
    <Progress>2</Progress>
    <PersonalDev>2</PersonalDev>
    <Teaching>2</Teaching>
    <Curriculum>2</Curriculum>
    <Care>2</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolEfs>
    <InspectorOin>19452 - NAME</InspectorOin>
    <ObservationTime>30</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>8</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>SU</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>25</Present>
    <Nor>26</Nor>
    <SubjectCode1>HI</SubjectCode1>
    <SubjectCode2 />
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>0</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>0</OthAssistantCount>
    <InspInitialWithEf>AP05</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>3</Overall>
    <Standards>3</Standards>
    <Progress>3</Progress>
    <PersonalDev>0</PersonalDev>
    <Teaching>3</Teaching>
    <Curriculum>0</Curriculum>
    <Care>0</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolEfs>
    <InspectorOin>19452 - NAME</InspectorOin>
    <ObservationTime>25</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>9</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>SL</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>13</Present>
    <Nor>20</Nor>
    <SubjectCode1>GG</SubjectCode1>
    <SubjectCode2 />
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>0</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>0</OthAssistantCount>
    <InspInitialWithEf>AP06</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>3</Overall>
    <Standards>3</Standards>
    <Progress>3</Progress>
    <PersonalDev>3</PersonalDev>
    <Teaching>3</Teaching>
    <Curriculum>0</Curriculum>
    <Care>0</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolEfs>
    <InspectorOin>19452 - NAME</InspectorOin>
    <ObservationTime>30</ObservationTime>
    <EfType>L</EfType>
    <YearGroups>9</YearGroups>
    <YearGroups />
    <YearGroups />
    <YearGroups />
    <GroupingAbility>SU</GroupingAbility>
    <GroupingGender>MI</GroupingGender>
    <Present>26</Present>
    <Nor>29</Nor>
    <SubjectCode1>HI</SubjectCode1>
    <SubjectCode2 />
    <SenSupportCount>0</SenSupportCount>
    <SenAssistantCount>0</SenAssistantCount>
    <EalSupportCount>0</EalSupportCount>
    <EalAssistantCount>0</EalAssistantCount>
    <OthSupportCount>0</OthSupportCount>
    <OthAssistantCount>0</OthAssistantCount>
    <InspInitialWithEf>AP09</InspInitialWithEf>
    <Focus />
    <Context />
    <Evaluation />
    <Summary />
    <Overall>1</Overall>
    <Standards>2</Standards>
    <Progress>1</Progress>
    <PersonalDev>2</PersonalDev>
    <Teaching>1</Teaching>
    <Curriculum>0</Curriculum>
    <Care>2</Care>
    <Leadership>0</Leadership>
    <CsiEval />
  </SchoolEfs>
  <SchoolKsYg xsi:type="xsd:string">Key Stage 3</SchoolKsYg>
  <SchoolKsYg xsi:type="xsd:string">Key Stage 4</SchoolKsYg>
  <SchoolKsYg xsi:type="xsd:string">Year Group 7</SchoolKsYg>
  <SchoolKsYg xsi:type="xsd:string">Year Group 8</SchoolKsYg>
  <SchoolKsYg xsi:type="xsd:string">Year Group 9</SchoolKsYg>
  <SchoolKsYg xsi:type="xsd:string">Year Group 10</SchoolKsYg>
  <SchoolKsYg xsi:type="xsd:string">Year Group 11</SchoolKsYg>
  <InspectionReport>
    <TransformedXml>&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;InspectionReport xmlns="http://www." xmlns:apd="http://www." xmlns:core="http://www." xmlns:pdt="http://www."&gt;
  &lt;InspectionKeyData&gt;
    &lt;InspectionNumber&gt;280643&lt;/InspectionNumber&gt;
    &lt;InspectionBeginningDate&gt;2007-06-06&lt;/InspectionBeginningDate&gt;
    &lt;InspectionEndDate&gt;2007-06-07&lt;/InspectionEndDate&gt;
    &lt;ReportingInspector&gt;
      &lt;InspectorName&gt;NAME&lt;/InspectorName&gt;
      &lt;InspectorStatus&gt;HMI&lt;/InspectorStatus&gt;
    &lt;/ReportingInspector&gt;
    &lt;InspectionCategory&gt;s5&lt;/InspectionCategory&gt;
    &lt;DateOfPreviousInspectionSchool&gt;2000-02-01&lt;/DateOfPreviousInspectionSchool&gt;
    &lt;AmendedReport&gt;no&lt;/AmendedReport&gt;
  &lt;/InspectionKeyData&gt;
  &lt;InspectionSetting&gt;
    &lt;SettingName&gt;SCH&amp;amp; SC&lt;/SettingName&gt;
    &lt;SettingAddress&gt;&lt;apd:Line&gt;Street&lt;/apd:Line&gt;&lt;apd:Line&gt;Rish&lt;/apd:Line&gt;&lt;apd:Line&gt;TOWN&lt;/apd:Line&gt;&lt;apd:Line&gt;COUNTY&lt;/apd:Line&gt;&lt;apd:Line&gt;PCODE&lt;/apd:Line&gt;&lt;/SettingAddress&gt;
    &lt;TelephoneNumber&gt;01254&lt;/TelephoneNumber&gt;
    &lt;FaxNumber&gt;01254&lt;/FaxNumber&gt;
    &lt;School&gt;
      &lt;UniqueReferenceNumber&gt;119717&lt;/UniqueReferenceNumber&gt;
      &lt;LEAName&gt;Lancashire&lt;/LEAName&gt;
      &lt;TypeOfSchool&gt;secondary&lt;/TypeOfSchool&gt;
      &lt;SchoolCategory&gt;community&lt;/SchoolCategory&gt;
      &lt;PupilLowAge&gt;11&lt;/PupilLowAge&gt;
      &lt;PupilHighAge&gt;16&lt;/PupilHighAge&gt;
      &lt;PupilGender&gt;mixed&lt;/PupilGender&gt;
      &lt;NumberOnRollSchool&gt;699&lt;/NumberOnRollSchool&gt;
      &lt;AppropriateAuthority&gt;The governing body&lt;/AppropriateAuthority&gt;
      &lt;ChairOfGovernors&gt;Mr&lt;/ChairOfGovernors&gt;
      &lt;Headteacher&gt;Mr&lt;/Headteacher&gt;
      &lt;HowToReferToHeadteacher&gt;Headteacher&lt;/HowToReferToHeadteacher&gt;
    &lt;/School&gt;
  &lt;/InspectionSetting&gt;
  &lt;ReportBody&gt;
    &lt;Introduction&gt;
      &lt;Preamble&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
      &lt;/Preamble&gt;
      &lt;DescriptionOfSetting&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
      &lt;/DescriptionOfSetting&gt;
    &lt;/Introduction&gt;
    &lt;OverallEffectiveness&gt;
      &lt;FormalStatement&gt;&lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;&lt;Paragraph&gt;Specialist sports college status has enabled the school to build a new sports hall, and to develop a wider range of sporting opportunities and more community links. These are promoting enjoyment and healthy lifestyles and helping to develop students’ confidence and skills, for example through work with local primary school students.&lt;/Paragraph&gt;&lt;Paragraph&gt;Students’ personal development is good. Although a few parents have concerns about behaviour, inspectors found that students are well behaved in lessons and around school. Students make a positive contribution to the local community. In school they are involved in activities such as reception duties and they undertake various charitable activities. Attendance remains slightly below average despite the efforts of the school to improve it.&lt;/Paragraph&gt;&lt;Paragraph&gt;Although GCSE examination results are below national averages, most students achieve the standards they are capable of. The proportion of students gaining five or more GCSE A*–C grades including English and mathematics is close to the national average. Students make particularly good progress in mathematics.&lt;/Paragraph&gt;&lt;Paragraph&gt;Teaching is satisfactory, although some lessons are good and occasionally outstanding. The school is beginning to develop strategies to improve the quality of learning so that more lessons include more of the good features that already exist. Inconsistencies remain between departments in assessment, marking, and progress monitoring.&lt;/Paragraph&gt;&lt;Paragraph&gt;The range of subjects and courses is satisfactory. Sports opportunities are good. Although there is a reasonable range of GCSE subjects, there are too few vocational opportunities at Key Stage 4. Advice and guidance on Key Stage 4 and Post 16 choices are good. Students find teachers approachable and helpful. Across different departments the monitoring of individual progress and guidance on how to improve work are inconsistent.&lt;/Paragraph&gt;&lt;Paragraph&gt;Leadership and management are satisfactory. The leadership of the headteacher has provided a clear sense of direction and generated a much greater sense of urgency to bring about improvements. The new school development plan accurately identifies the key challenges for the school. Partnership arrangements are good. The impact of new initiatives is beginning to be seen, for example in the recent reduction in the number of exclusions. The school has satisfactory capacity to improve. Governance is satisfactory. Governors are aware of the strengths and weaknesses of the school and monitor performance effectively. They have managed recent staffing difficulties and the building of the new sports hall well.&lt;/Paragraph&gt;
      &lt;/FormalStatement&gt;
      &lt;MeetingNeeds&gt;
        &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
      &lt;/MeetingNeeds&gt;
      &lt;Judgements&gt;
        &lt;PartnershipWorking&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/PartnershipWorking&gt;
        &lt;QualityFoundation&gt;
          &lt;SchoolGrade&gt;9&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/QualityFoundation&gt;
        &lt;SelfEvaluation&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/SelfEvaluation&gt;
        &lt;ImprovementCapacity&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/ImprovementCapacity&gt;
        &lt;EffectiveSteps&gt;
          &lt;SchoolYesNo&gt;yes&lt;/SchoolYesNo&gt;
          &lt;SixthFormYesNo&gt;key stage not present&lt;/SixthFormYesNo&gt;
        &lt;/EffectiveSteps&gt;
      &lt;/Judgements&gt;
      &lt;ToImproveFurther&gt;
        &lt;List&gt;
          &lt;Item&gt;PARAGRAPH.&lt;/Item&gt;
          &lt;Item&gt;PARAGRAPH.&lt;/Item&gt;
          &lt;Item&gt;PARAGRAPH.&lt;/Item&gt;
        &lt;/List&gt;
        &lt;Paragraph&gt;PARAGRAPH. &lt;/Paragraph&gt;
      &lt;/ToImproveFurther&gt;
    &lt;/OverallEffectiveness&gt;
    &lt;AchievementAndStandards&gt;
      &lt;Paragraphs&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
      &lt;/Paragraphs&gt;
      &lt;Judgements&gt;
        &lt;LearnersAchieve&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/LearnersAchieve&gt;
        &lt;StandardsReached&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/StandardsReached&gt;
        &lt;ProgressMade&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/ProgressMade&gt;
        &lt;DifficultyDisability&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/DifficultyDisability&gt;
      &lt;/Judgements&gt;
    &lt;/AchievementAndStandards&gt;
    &lt;PersonalDevelopment&gt;
      &lt;Paragraphs&gt;
        &lt;Paragraph&gt;PARAGRAPH. &lt;/Paragraph&gt;
      &lt;/Paragraphs&gt;
      &lt;Judgements&gt;
        &lt;OverallPersonal&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/OverallPersonal&gt;
        &lt;SpiritualCultural&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/SpiritualCultural&gt;
        &lt;Behaviour&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/Behaviour&gt;
        &lt;Attendance&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/Attendance&gt;
        &lt;Enjoyment&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/Enjoyment&gt;
        &lt;SafePractice&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/SafePractice&gt;
        &lt;HealthyLifestyle&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/HealthyLifestyle&gt;
        &lt;PositiveContribution&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/PositiveContribution&gt;
        &lt;WorkplaceEconomic&gt;
          &lt;SchoolGrade&gt;2&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/WorkplaceEconomic&gt;
      &lt;/Judgements&gt;
    &lt;/PersonalDevelopment&gt;
    &lt;QualityOfProvision&gt;
      &lt;TeachingAndLearning&gt;
        &lt;Paragraph&gt;PARAGRAPH. &lt;/Paragraph&gt;
      &lt;/TeachingAndLearning&gt;
      &lt;CurriculumAndOtherActivities&gt;
        &lt;Paragraph&gt;PARAGRAPH. &lt;/Paragraph&gt;
      &lt;/CurriculumAndOtherActivities&gt;
      &lt;CareGuidanceAndSupport&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
        &lt;Paragraph&gt;PARAGRAPH. &lt;/Paragraph&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
      &lt;/CareGuidanceAndSupport&gt;
      &lt;Judgements&gt;
        &lt;EffectiveFullRange&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/EffectiveFullRange&gt;
        &lt;CurriculumNeedsInterests&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/CurriculumNeedsInterests&gt;
        &lt;CareGuidance&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/CareGuidance&gt;
      &lt;/Judgements&gt;
    &lt;/QualityOfProvision&gt;
    &lt;LeadershipAndManagement&gt;
      &lt;Paragraphs&gt;
        &lt;Paragraph&gt;PARAGRAPH.&lt;/Paragraph&gt;
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
      &lt;/Paragraphs&gt;
      &lt;Judgements&gt;
        &lt;RaisingSupporting&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/RaisingSupporting&gt;
        &lt;DirectionQuality&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/DirectionQuality&gt;
        &lt;MonitorReview&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/MonitorReview&gt;
        &lt;EqualityDiscrimination&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/EqualityDiscrimination&gt;
        &lt;EffectivenessEfficiency&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/EffectivenessEfficiency&gt;
        &lt;GovernorsSupervision&gt;
          &lt;SchoolGrade&gt;3&lt;/SchoolGrade&gt;
          &lt;SixthFormGrade&gt;9&lt;/SixthFormGrade&gt;
        &lt;/GovernorsSupervision&gt;
        &lt;AdequacySuitability&gt;
          &lt;SchoolYesNo&gt;yes&lt;/SchoolYesNo&gt;
          &lt;SixthFormYesNo&gt;key stage not present&lt;/SixthFormYesNo&gt;
        &lt;/AdequacySuitability&gt;
        &lt;SpecialMeasures&gt;
          &lt;SchoolYesNo&gt;no&lt;/SchoolYesNo&gt;
        &lt;/SpecialMeasures&gt;
        &lt;NoticeImprove&gt;
          &lt;SchoolYesNo&gt;no&lt;/SchoolYesNo&gt;
        &lt;/NoticeImprove&gt;
      &lt;/Judgements&gt;
    &lt;/LeadershipAndManagement&gt;
  &lt;/ReportBody&gt;
  &lt;LetterToPupils&gt;&lt;Paragraph&gt;8 June 2007&lt;/Paragraph&gt;&lt;Paragraph&gt;Dear Students,&lt;/Paragraph&gt;&lt;Paragraph&gt;JUNK&lt;/Paragraph&gt;&lt;Paragraph&gt;JUNK.&lt;/Paragraph&gt;&lt;Paragraph&gt;JUNK.&lt;/Paragraph&gt;&lt;Paragraph&gt;JUNK.&lt;/Paragraph&gt;&lt;Paragraph&gt;JUNK.&lt;/Paragraph&gt;&lt;Paragraph&gt;JUNK.&lt;/Paragraph&gt;&lt;Paragraph&gt;JUNK.&lt;/Paragraph&gt;&lt;Paragraph&gt;JUNK.&lt;/Paragraph&gt;&lt;Paragraph&gt;Yours sincerely&lt;/Paragraph&gt;&lt;Paragraph&gt;NAME&lt;/Paragraph&gt;&lt;Paragraph&gt;HMI&lt;/Paragraph&gt;
  &lt;/LetterToPupils&gt;
&lt;/InspectionReport&gt;</TransformedXml>
    <ImportedFileDetails>Filename:        S:\Schools data\Published Reports\JUNK - Report.doc
File date/time:        14 June 2007 15:29:15
Import date:        14 June 2007 16:05:49</ImportedFileDetails>
  </InspectionReport>
</Inspection>



All times are GMT +5.5. The time now is 17:16.