4 Replies Latest reply on Nov 17, 2011 1:56 PM by nickorr

    XML Error

    EvanGoldstein

      Hi,

       

      I'm getting an error while exporting data from FM using the attached stylesheet to convert line endings.

      I get the error using FM11 client running on Leopard, but I do not get the error when it is run from a script on FMSA 10, also running Leopard.

      I also don't get the error when running FM10 client on Leopard, so I think it is an FM11 issue.

       

      The error is

      "XSLT error: Character data is not allowed at this position in the stylesheet. (Occurred in entity '/file path here /export_csv_with_CRLF.xslt', at line 76, column 76.)

       

      I'm not very familiar with XML, but can anyone tell me what should be changed?

       

      Does anyone know what can be safely removed, or does something need to be added for FM11.

       

      Thanks,

      Evan

        • 1. Re: XML Error
          nickorr

          Evan,

           

          I can see one glaring error in the file.  Line 74 has this text in it :

           

          !-- ******************** END VARIABLES ******************** -->

           

          An it's being treated as a command, not a comment, because the starting < is missing.  Change it like this :

           

          <!-- ******************** END VARIABLES ******************** -->

           

          and give it another try.

           

          Cheers,

          Nick

           

          Nicholas Orr

          Goya Pty Ltd

          BaseElements : www.baseelements.com

          RefreshFM : www.refreshfm.com

          • 2. Re: XML Error
            EvanGoldstein

            Great, thanks for your help.

            Is it safe to edit this using the Applescript, Script editor?

            • 3. Re: XML Error
              EvanGoldstein

              I was able to edit it with Textwrngler and it worked fine. Funny that FM10 didn't seem to care about the line.

               

              Thanks for your help.

              • 4. Re: XML Error
                nickorr

                Evan,

                 

                TextWrangler is a better option than the AppleScript editor.  And the reason FM10 didn't care is that the XML/XSLT engine changed version numbers in FileMaker 11.  It is newer, but also much more strict about a lot of things.

                 

                Cheers,

                Nick

                 

                Nicholas Orr

                Goya Pty Ltd

                BaseElements : www.baseelements.com

                RefreshFM : www.refreshfm.com