Jump to content
Sign in to follow this  
digitaljunkie

Help Needed...

Recommended Posts

Hi,

I wonder if anyone can shed some light on something rather worrying...

I have some XSL's written so that we can import XML files from a data-supplier they work fine except for a few which came through last week.

Please see the attached image for the error, if I re-import previous and some new XMLs they still import fine but there is a batch that don't.

I had them resent and tried parsing them through Validator and TestXSLT and they seem to be valid!!

I can provide samples if required.

XMLERROR.png

Edited by Guest

Share this post


Link to post
Share on other sites

With Saxon 8.9 your example transformed fine.

Could be the encoding of the XML file (which is ISO-8859-15). Change it to UTF-8 and try to import again.

Which FileMaker version are you using? Could be that the Xalan XSLT processor used there is not the newest version.

Share this post


Link to post
Share on other sites

It worked as is for me. Except you are missing a field in you Metadata definitions. The "Type" field, which goes between "TypeID" and "Text". Without it the order is thrown off; you already have it in the Resultset selections.

Share this post


Link to post
Share on other sites

I noticed that deleting the content of the Text column from the xml allows for FileMaker to import the XML fine, does FileMaker have any restrictions on XML or length of a file?

Share this post


Link to post
Share on other sites

Yes, it worked for me fine. No, I don't think there's a length limitation, except the basic FileMaker text field limitation, which is HUGE (1 billion characters). It could be that there's some special character in the text that's making it choke. But, as I said, it imported fine for me, other than the field order being off.

The Text field has got quite a few little errors in it, extra characters, ^, #, %, extra spaces. It looks like it was hacked out of a web page or something.

Share this post


Link to post
Share on other sites

Hi Fenton, may I ask exactly what you did...

i.e a step-by-step idiots click guide as i have tried it on 2 different macs and the same error occurs one mac is intel one is PCC both in FMP and FMA 8.5 running 10.4.9.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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