FileMaker 11 xml Import Problem

[jgraff]

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

[beebee]

Hi, I know you posted your question a while ago, but I just encountered the same issue with importing XML and getting this error:

"XML parsing error:

unable to open primary document entity"

Did you ever figure out what the issue was?

Thanks in advance...