Help on XML/XSLT Transform please

[Talboy]

I am getting nothing more than the 'XML/XSL information is not enough to proceed with import/export' error when importing the attached XML file with the XSLT file. The XML file is a cut down version of a data download I need to be able to import monthly. I would be very grateful of any help as to where I am going wrong. 

Thanks in advance.

 

 

 

clients-transform.xslt

CRM_Download-test.xml

[comment]

The XML file is a cut down version of a data download I need to be able to import monthly.

​How far cut down is it?

The reason for the error is that XML is case-sensitive and Filemaker expects the fields defined in the METADATA section to look like this:

<METADATA>
    <FIELD NAME="Id" TYPE="TEXT"/>
    <FIELD NAME="Type" TYPE="TEXT"/>
    ...
    <FIELD NAME="PhoneNumber2" TYPE="TEXT"/>
</METADATA>

instead of:

<METADATA>
    <Field NAME="Id" TYPE="TEXT"/>
    <Field NAME="Type" TYPE="TEXT"/>
    ...
    <Field NAME="PhoneNumber2" TYPE="TEXT"/>
</METADATA>

Once you fix that, you will be able to execute the import - but no data will be imported using the XML source you have attached, because the path in the instruction:

<xsl:for-each select="ABCLifeDataFeed/Advisers/Adviser/Clients/Client">

does not lead anywhere (there are no Advisers or Adviser nodes in the document).

[Talboy]

Thank You Comment, I had read somewhere that XML was case sensitive, but did not know that the likes of 'FIELD' was required to be in caps. Just a novice when it comes to XML stuff! Yes this was a cut down version of the original file and yes forgot to remove the Advisers/Adviser/.

Thanks again! I'm back on track.