1 Reply Latest reply on May 22, 2015 2:47 PM by disabled_menno

    XML Import error with URL characters

    bcarlson

      Summary

      XML Import error with URL characters

      Product

      FileMaker Pro

      Version

      14

      Operating system version

      Mac OS 10.10.3

      Description of the issue

      I downloaded the trial version of FMP 14 to test it with my existing v12 solutions & I've come across a bug during XML Import.   It appears that FMP 14 has an issue with certain characters in the URL string.   Specifically the "+" character.

      This basic URL works in 14 & 12:

      http:///mobi-solr/mobi-solr-collection/select?q=type_ssi%3Achannel&wt=xml&indent=true

      When I modify the URL by adding additional query parameters, the following URL imports successfully in FMP 12 but imports nothing in FMP 14.  This URL with one other query parameter doesn't work in 14 but does work in 12. 

      http:///mobi-solr/mobi-solr-collection/select?q=type_ssi%3Achannel+AND+media_id_ssi%3A46&wt=xml&indent=true



      The XML source data is valid, I'm importing into the same table with same XSLT.  The only differences are the FMP version & the addition of the "+AND+" element in the URL.

      FMP doesn't give any error.  It just shows zero records imported for v14 & 10 records imported for v12.   (FMPAdvanced isn't available for trial so I can't see any errors that are thrown)   (Screenshot attached)

      Steps to reproduce the problem

      Import XML data from a URL that contains a "+" in the URL.

      Expected result

      Data should be imported like it was in FMP 12

      Actual result

      0 records are imported & no error is shown

      Exact text of any error message(s) that appear

      no error

      Workaround

      I've tried to encode the "+" characters but that breaks the backend query so that's not a viable work around.

      v14-noImport.png

        • 1. Re: XML Import error with URL characters

          I notice that a part of your URL is encoded for example "%3A" = ":" .... so I think it should look like: 

          http://<host_hidden>/mobi-solr/mobi-solr-collection/select?q=type_ssi:channel+AND+media_id_ssi:46&wt=xml&indent=true 

          Does this URL work in a browser? Try that with Firefox and not with Safari. If you get an answer, it should work in Filemaker as well. You may have to encode some of teh parameters like: 

          "http://<host_hidden>/mobi-solr/mobi-solr-collection/select?" & GetAsURLEncoded ( "q=type_ssi:channel+AND+media_id_ssi:46&wt=xml&indent=true" ) so that the real URL looks like:

          http://<host_hidden>/mobi-solr/mobi-solr-collection/select?q%3Dtype_ssi:channel%2BAND%2Bmedia_id_ssi:46%26wt%3Dxml%26indent%3Dtrue

          However I am not sure this works, you may give it a try

          regards, Menno