I have an Excel file with 29 columns of 220 rows of data. The schema I am supposed to use is from http://www.fsa.gov.uk/mer/drg/PSD007/v1-3/PSD007-Schema.xsd which is a UK government data schema for mortgage reporting by banks. The schema is also available for download at https://www.fca.org.uk/firms/systems-reporting/gabriel/system-information/data-reference-guides/psd/psd007
When I add this to the XML Sources in Excel (from the URL above) for my data I get no errors.
But when I try to map the elements to my columns, although I get no errors, the entire column is not selected and only the headings row or the first row is exported to XML.
Can anyone look at the Schema below tell me what I am doing wrong?
Here below is the schema in case you need to look at it without going onto the website:
<?xml version="1.0" encoding="UTF-8"?> <!-- ******************************************************************* * * Schema for: Data Item PSD007-Mortgage Performance Sales Data * * Version: 1.3 * Date: 20/08/2014 * * Dependencies: Version 7 CommonTypes-Schema.xsd * History: Version issued following changes to the following: * - RepaymentMethod * - The elements "LoanPurchase", "OrigLoanSize", "OrigLoanTerm" and "OrigProviderFRN" moved into "CoreItems" * - The enumerations for'TypeIntRate' updated * - "AcctOpenedDate", "DateLitigationStarted" and "OrigLoanTerm" updated to minOccurs="0" * ******************************************************************* --> -<xs:schema xmlns="urn:fsa-gov-uk:MER:PSD007:1" version="1.3" id="MER-PSD007" xmlns:mer-meta="urn:fsa-gov-uk:MER:Meta-Data:1" targetNamespace="urn:fsa-gov-uk:MER:PSD007:1" attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> -<xs:annotation> -<xs:documentation> <mer-meta:DataItemReference>PSD007</mer-meta:DataItemReference> <mer-meta:DataItemName>Mortgage Performance Sales Data</mer-meta:DataItemName> </xs:documentation> </xs:annotation> <xs:include schemaLocation="../../CommonTypes/v7/CommonTypes-Schema.xsd"/> -<xs:element name="PSD007-MortgagePerformanceSalesData"> -<xs:complexType> -<xs:sequence> -<xs:element name="PSDFeedHeader" minOccurs="1"> -<xs:complexType> -<xs:sequence> -<xs:element name="Submitter" minOccurs="1"> -<xs:complexType> -<xs:sequence> <xs:element name="SubmittingFirm" minOccurs="1" type="FRNType"/> </xs:sequence> </xs:complexType> </xs:element> -<xs:element name="ReportDetails" minOccurs="1"> -<xs:complexType> -<xs:sequence>
<xs:element name="ReportCreationDate" minOccurs="1" type="xs:date"/> <xs:element name="ReportIdentifier" minOccurs="1" type="String100Type"/> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> -<xs:element name="PSD007FeedMsg" maxOccurs="unbounded"> -<xs:annotation> <xs:documentation>Defines the individual transactions to be reported</xs:documentation> </xs:annotation> -<xs:complexType> -<xs:sequence> -<xs:element name="CoreItems" minOccurs="1"> -<xs:complexType> -<xs:sequence> <xs:element name="AdminFRN" minOccurs="0" type="FRNType"/> <xs:element name="Postcode" minOccurs="1" type="PostCodeType"/> <xs:element name="MainDOB" minOccurs="1" type="xs:date"/> <xs:element name="AcctOpenedDate" minOccurs="0" type="xs:date"/> <xs:element name="TransRef" minOccurs="1" type="String100Type"/> <xs:element name="DateofBalance" minOccurs="1" type="xs:date"/> <xs:element name="LoanPurchase" minOccurs="1" type="YNType"/> <xs:element name="OrigLoanSize" minOccurs="0" type="NonNegativeMonetaryType"/> <xs:element name="OrigLoanTerm" minOccurs="0" type="NonNegativeIntegerType"/> <xs:element name="OrigProviderFRN" minOccurs="0" type="FRNType"/> <xs:element name="Cancellation" minOccurs="0" type="xs:boolean"/> </xs:sequence> </xs:complexType> </xs:element> -<xs:element name="PerformanceSalesData" minOccurs="1"> -<xs:complexType> -<xs:sequence> <xs:element name="OutstandingBalance" minOccurs="1" type="MonetaryType"/> <xs:element name="MonthlyPayment" minOccurs="1" type="NonNegativeMonetaryType"/> <xs:element name="ValueLinkedAccounts" minOccurs="1" type="MonetaryType"/> <xs:element name="GrossInterestCharged" minOccurs="1" type="PercentDP2Type"/> -<xs:element name="TypeIntRate" minOccurs="1"> -<xs:simpleType> -<xs:restriction base="xs:string"> <xs:enumeration value="01"/> <xs:enumeration value="02"/> <xs:enumeration value="04"/> <xs:enumeration value="05"/> <xs:enumeration value="06"/> <xs:enumeration value="07"/> <xs:enumeration value="08"/> <xs:enumeration value="99"/> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="IncentivisedRate" minOccurs="1" type="YNType"/> <xs:element name="DateIncentiveEnds" minOccurs="0" type="xs:date"/> <xs:element name="RemainingTerm" minOccurs="1" type="NonNegativeIntegerType"/> <xs:element name="MonthsPastMaturity" minOccurs="1" type="NonNegativeIntegerType"/> -<xs:element name="RepaymentMethod" minOccurs="1"> -<xs:simpleType> -<xs:restriction base="xs:string"> <xs:enumeration value="C"/> <xs:enumeration value="I"/> <xs:enumeration value="M"/> </xs:restriction> </xs:simpleType> </xs:element> -<xs:element name="ReasonForClosure" minOccurs="0"> -<xs:simpleType> -<xs:restriction base="xs:string"> <xs:enumeration value="R"/> <xs:enumeration value="M"/> <xs:enumeration value="P"/> <xs:enumeration value="A"/> <xs:enumeration value="V"/> <xs:enumeration value="O"/> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="CurrentPaymentShortfall" minOccurs="1" type="NonNegativeMonetaryType"/> <xs:element name="ArrearsStartDate" minOccurs="0" type="xs:date"/> <xs:element name="PaymentShortfallArrangement" minOccurs="1" type="YNType"/> <xs:element name="DateFormalArrangement" minOccurs="0" type="xs:date"/> <xs:element name="PaymentShortfallCapitalisation" minOccurs="1" type="YNType"/> <xs:element name="CapitalisationDate" minOccurs="0" type="xs:date"/> <xs:element name="SwitchInterestOnly" minOccurs="1" type="YNType"/> <xs:element name="InterestOnlyDate" minOccurs="0" type="xs:date"/> <xs:element name="PaymentsSuspended" minOccurs="1" type="YNType"/> <xs:element name="DatesPaymentsSuspended" minOccurs="0" type="xs:date"/> <xs:element name="ReducedPayments" minOccurs="1" type="YNType"/> <xs:element name="DateReducedPayments" minOccurs="0" type="xs:date"/> <xs:element name="TermExtension" minOccurs="1" type="YNType"/> <xs:element name="DateTermExtension" minOccurs="0" type="xs:date"/> <xs:element name="OtherForbearance" minOccurs="1" type="YNType"/> <xs:element name="DateOtherForbearance" minOccurs="0" type="xs:date"/> <xs:element name="DateLitigationStarted" minOccurs="0" type="xs:date"/> <xs:element name="PossessionOrder" minOccurs="1" type="YNType"/> <xs:element name="DatePossession" minOccurs="0" type="xs:date"/> <xs:element name="RepossessionSaleValueAchieved" minOccurs="0" type="MonetaryType"/> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="currency" use="required" fixed="GBP"/> </xs:complexType> </xs:element> </xs:schema>
- Edited by Our Man In Bananas 16 hours 22 minutes ago added info