I'm having a problem importing xml data in FileMaker 11. This problem does not exist in FileMaker 10.
Here's the scenario.
I have a table of 2000 records. Each record has a corresponding xml file that is stored on a network share. I have a script that iterates through each record in the table. The script imports data from the records corresponding xml file and continues on to the next record. I am specifying the the file name and location based on a calculation. For example: "filewin://server/sharename/folder/" & table::field & ".xml". In FileMaker 10, this works just fine. In FileMaker 11, the path to the xml file gets mangled. It's adding the last static location you specified for a files location from an import dialogue box.
For example:
In FM 11. If you create a new script, add an Import Records Script Step, Specify data source as XML Data..., specify XML data source as File with a value of: filewin:/C:/folder/file.xml and then immediately change the specify XML data source to calculation with a value of "filewin://server/sharename/folder/" & table::field & ".xml". You then save the script and run it, you receive the following:
XML parsing error:
unable to open primary document entity
'C:folder/filewin://server/share/folder/filename.xml'
Line Number: 0
Column Number: 0
Even if you don't first specify XML data source as file and immediately specify it as a calculation, FileMaker still appends the last folder location you went to.
I've been able to reproduce this on several systems running XP Pro with Service pack 3 and FileMaker 11 Pro Advanced. Again, this problem doesn't happen in FM 10.
Is anyone else having the same problem?
Thanks for you help in advance,
-Jake
