AnsweredAssumed Answered

XML Import error with URL characters

Question asked by bcarlson on May 22, 2015
Latest reply on May 22, 2015 by disabled_menno

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

Outcomes