2 Replies Latest reply on Jul 30, 2010 9:23 AM by TSGal

    Special characters breaks Copy pasting of CF, corrupt XML DDR

    Vincent_L

      Summary

      Special characters breaks Copy pasting of CF, corrupt XML DDR

      Product

      FileMaker Pro

      Version

      FMPa 11v2

      Operating system version

      Mac OS X 10.6.4

      Description of the issue

      Hi, My XML DDR export are not ok, you can't open them.

      I tracked Down the problem to a CF I wrote meant to get rid of invisible special characters (the one below ascii 30). In the CF those characters have ben cut and pasted.

      Fors instance
      LeTexte=Substitute ( LeTexte ; "     " ; " " );


      Now with FM 11v2 adv., When I create a XML DDR Export, the xml has problem. You can't parse it because those special characters were not converted to xml friendly characters.

      I think it will be also the case in calculation or elsewhere (but didn't proved it).

      Moreover this CF can't be copy pasted. Only the CF name gets copied, not it's content. That's because FMP internally use XML to copy paste and it seems its' XML engine forgets to converts some characters to their XML friendly code.

      I've created a file with that CF called "NettoieTexte", export it's DDR as an XML file and try to open the generated XML, or try to copy pasted the CF : all will fail.

      That's terrible because that means we can't use DDR analysis tools anymore (if in your code you deal with such characters).

      Steps to reproduce the problem

      Create a CF where there's characters whose ascii code is below 30
      generate DDR XML export
      Try to open that XML file with any XML reader

      Expected result

      Should open without problem

      Actual result

      XML malformed so no XML reader can read it

      Exact text of any error message(s) that appear

      None

      Configuration information

      Macbook pro i7

      Workaround

      None

      Capture_d%E2%80%99%C3%A9cran_2010-07-19_%C3%A0_15.53.36.png