AnsweredAssumed Answered

xml Import Problem

Question asked by jgraff on May 28, 2010
Latest reply on Jun 22, 2011 by bueller

Summary

xml Import Problem

Product

FileMaker Pro

Version

11.0v1

Operating system version

Windows XP Pro, Service Pack 3

Description of the issue

When importing from an XML file in a script  and the XML data source is base on a calculation, the file path ends up mangled when you run the script.
Exact steps to reproduce the issue:
1. Create a new script
2. Add an Import Records Script Step
3. Specify data source as XML Data... > specify XML data source as File with a value of: filewin:/C:/folder/file.xml > immediately change the specify XML data source to calculation with a value of "filewin://server/sharename/folder/" & table::field & ".xml".
4. Save the script
5. Run scriptExpected Result:Prompted to specify import order of fields to be imported

Actual Result:
Error message is produced

Exact text of any error message(s) that appeared:
XML parsing error:unable to open primary document entity'C:\folder\/filewin://server/share/folder/filename.xml'
Line Number: 0
Column Number: 0

Any additional configuration information/troubleshooting that is relevant to the issue:
When importing xml file based on calculation, the import path will include the last static file location you specified in filemaker and then the calculated location.  For example, if you specify the xml file location as a calculation and then specify > Use XSL Style Sheet and specify the File.  The resulting import location for the XML file will be: '\X:\DIRECTORY WHERE XSLT FILE IS LOCATED\/filewin://server/share/folder/filename.xml'.
Any workarounds that you have found:
Use FileMaker 10 -Jake

Outcomes