XML ignorant

[tomp]

I must have a mental block with XML/XSLT.

I need to do an XML import (I think). I've played with the FM supplied example and looked at several other resources but can't make the transition to my situation. Can someone help?

The spec I have is attached. The 'download' is what I need to 'import' into an FM file. Where do I start? What do I need to do?

I would be happy to have everything go into a single table.

Any direction/help would be appreciated.

XML_spec.pdf

[comment]

The attached stylesheet will import 4 fields I picked at random. Hopefully you'll be able to fill the rest.

reservations.xsl.zip

[tomp]

Thanks! I'll see if I can make it work.

[tomp]

I finally have some data to import using this data format.

For the 'import' script step, I'm using the 'http request' for 'Specify XML Data Source'. It is an 'https' reference. I also use the xsl file derived from the example in the previous reply.

When the script step executes, the following error occurs:

[color:red]XML parsing error:

unable to open primary document entity ''

Line Number: 0

Column Number: 0

If I copy the url in the 'http request' field and drop into a browser, the data are displayed so the url appears to be correct.

Where does the error come from and what is it telling me?

[comment]

I don't know for sure, but I think it means Filemaker is not receiving data in response to the request. I don't know this for sure either, but I doubt very much Filemaker can negotiate a HTTPS connection through the XML import request. Try using curl (via AppleScript) or even a web viewer instead.

[tomp]

I think I've gotten around the https issue (couldn't do an xml import via an https connection) by saving the data to an .asp file, renaming the extension to .xml and doing a file xml import.

However, while the import xml script step executes without an error, no data is imported.

>>Can someone take a look at the .xsl and .xml files (attached) to see why the data in the .xml file are ignored?

>>Also, could someone suggest a .cmd file (unfortunately need it for windows) to open a url, do a 'save as', and rename the saved file - all 'hidden'?

xml.zip

[comment]

Try:

instead of:

[tomp]

Bingo!

Thank you!

Now if I can just automate the procedure to download the data from the https url and rename the file.... Any help??

[comment]

I don't know about Windows, but I think this has come up before - try searching the forums for: +Windows +curl.