Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Message during import


This topic is 6862 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (edited)

I'm researching XML importing using XSL from file and FM bring to me message:

XML parsing error: Element 'xsl:for-each' is not valid for content model:'(ROW)*'

What should I do?

XSL looks:


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



  

  

    

    0

    

    

    

      

      

      

      

      

      

      

      

    

    

      

        

          

            

              

            

          

          

            

              

            

          

          

            

              

            

          

          

            

              

            

          

          

            

              

            

          

          

            

              

            

          

          

            

              

            

          

          

            

              

                

                

                  , 

                

              

            

          

        

      

    

  





            





TIA

Veselko

Edited by Guest
Posted

Is this an Amazon import? If so, the problem may be that the newer xml returned by Amazon now includes and Amazon namespace. FileMaker also has its own namespace, which it declares here:

:)-] Also, aren't there more elements returned before ? You need your template to match from the root element. What is the request you're submitting? (you can remove your Amazon developer's ID from the request; I just want the general form). Here's a short example of an xsl for Amazon (probably not quite like yours, different request).






That means that the Amazon elements beneath that level need to be prefixed (during xml exports you often need to do the opposite, prefix FileMaker elements, with "fmp" or "fm"). The prefix is up to you, but must be declared with the namespace. I use "aws".



You then want to remove the Amazon prefix. The whole stylesheet declaration looks like:





  xmlns:aws="http://webservices.amazon.com/AWSECommerceService/2005-10-05" exclude-result-prefixes="aws">




And that's about all I know about it 
<?xml version="1.0" encoding="UTF-8"?>



  xmlns:aws="http://webservices.amazon.com/AWSECommerceService/2005-10-05" exclude-result-prefixes="aws">



	

		

			0

			

			

			

				

				

				

				

				

			

			

				

					

						

						

							

							

						

						

						

					

				

			

		

	

Posted

Is this an Amazon import?

First, thank You for your answer.

Actually, this is an import from book "Using FileMaker" by Steve Lane, Bob Bowers, Scott Love and Chris Moyer.

I'm totally fresh in importing XML from web in FM, and I was start from book example. Error message I wrote in original post looks like to me something like a syntax error in xsl.

Also, aren't there more elements returned before ? You need your template to match from the root element.

Can you please, closely your last sentence?

What is the request you're submitting? (you can remove your Amazon developer's ID from the request; I just want the general form).

Request is also from book example.

Here:

http://xml.amazon.com/onca/xml3?t=xxx&dev-t=D1AT17BPIA1PX7&PowerSearch=title:Genet&mode=books&type=lite&page=1&f=xml

TIA

Veselko

This topic is 6862 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.