Jump to content

Help on XML/XSLT Transform please


Talboy

This topic is 3272 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 3272 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.