file->import records->xml data source...->http request=http://tsesc.com/xmlexport.aspx?type=dtod&date=13850715

error:

XML parsing error:

Unknown element 'pe'

Line Number: 2

help me please.

Edited October 8, 200619 yr by Guest

It doesn't work that way. FM can import XML but only if it is in it the FM XML grammar. So you need to write an XSLT to transform that tsesc XML grammar into the FM grammar. That's what the "use XSLT style sheet" option is about at the bottom of the import dialog.

Do a search in the FM help for "xml import" to learn the details. Post back if you need help writing the XSLT stylesheet.

Here's a quick partial xsl stylesheet, which works (I can't read the text fields, but it seems to all be there). I only did 3 fields, so you'll have to add the rest. But it's a simple xml file.

<?xml version="1.0" encoding="utf-8"?>



  

  

    

      0

      

      

      

        

        

        

        

      

      

        

          

            0

            

              

            

            

              

                

              

            

            

              

                

              

            

            

              

                

              

            

          

        

      

    

  

(P.S. The stylesheet should also be on a web page, accessed via http if you want to transform the source directly from its http location, without having to write it to a local file. Otherwise you get a cryptic "could not connect to socket" error. Actually I just tried it twice, and it worked the 2nd time, with a local file, but not the 1st time. Odd.)

Edited October 8, 200619 yr by Guest
http or local?

tanx

I have a sample db that allows you to set up the "field mappings" (between your database fields and your source XML). I haven't tweaked it with "features", but it works to create a simple XSLT for importing into FMP. Email me if interested.