Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About CMCollins

  • Rank
  1. It's working !!! (Jumping for Joy!!!) I now have a table with 1400+ records in it. I had to do a little cleanup. For example I had "item" in the xsd, but "Item" in the xml. I also had a couple of my fields in the xsd in a different order than they were in the xml. Once all that was fixed it worked. The only thing I wish I could do now is get more than one review to automatically be imported in Excel. I've been reading about "repeating elements", but am not sure if that applies to what I'm doing. For example the xml download I use has the following review data for one product.
  2. I sort of have good news. After correcting the schema ref element, the test files I have been using now go through the validator without error. At first I got this message: s4s-elt-must-match.1: The content of 'product' must match (annotation?, (simpleType | complexType)?, (unique | key | keyref)*)). A problem was found starting at: complextype. I was able to find info that I needed to change complextype to complexType and that fixed that error. Thanks to dsonesuk for sticking with me on this and getting me error free. Now my problem is that if I use an xml with more than one
  3. BTW: There doesn't seem to be any problem with the xml finding the xsd. That's working fine.
  4. I'm still getting this message in the xsd: The prefix "xsd" for element "xsd:element" is not bound. referring to the second line here: 1 <?xml version="1.0"?> 2 <xsd:element name="product"> What does "is not bound" mean? Thanks.
  5. Getting there.  Thanks dsonesuk for the two lines at the beginning of the xml.   This is the error I'm getting on the xml at the moment: Element type "xsd:noNamespaceSchemaLocation" must be followed by either attribute specifications, ">" or "/>".   Here is the current xml, and the xsd follows:   <?xml version="1.0" encoding="UTF-8" standalone="yes"?><xsd:noNamespaceSchemaLocation="file:C:UsersCherylMy Documentsxsd_090114.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance"><product>  <asin>B003Y3E55G</asin>  <brand>
  6. I found the other capitals in the tags and removed them, and get the same messages. I've been trying to use an internal dtd because I haven't found any good directions for how to create and use an external one. Which lines is it supposed to contain, and where is it stored, just in the same folder as the xml? What software do you use to create one?
  7. I have changed all the tags I created to lower case and I took out the 2nd Description tag.  I'm still getting these error messages:   XMLspy: Character 'p' following the text '<' does not fulfill production 'Misc'.   Excel: Only one top level element is allowed in an xml document   XMLValidation The markup in the document following the root element must be well-formed.   http://www.freeformatter.com/xml-validator-xsd.html The Markup In The Document Following The Root Element Must Be Well-formed.   The latest version is below:   <?xml version="1.0"?>
  8. I took out these two lines: <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xsd:include schemaLocation="amzn-base.xsd"/> and </xsd:schema> Now XMLValidation.com says: The prefix "xsd" for element "xsd:element" is not bound. XMLSpy still says: Character 'P' following the text '<' does not fulfill production 'Misc'. And when I try to open it in Excel I get: Strict Parse Error
  9. When I try to open it in excel I get XML document must have a top level element XMLSpy says Character 'P' following the text '<' does not fulfill production 'Misc'. http://www.xmlvalidation.com/ says 31: 2 The markup in the document following the root element must be well-formed.
  10. That doesn't seem to help. I've tried using Find/Replace to make them all upper case and all lower case, and no luck yet. I appreciate your efforts tho.
  11. I've been staring at this for hours and searching forums for an answer. I have also gotten this message from another validator: "Character 'P' following the text '<' does not fulfill production 'Misc', which highlights the first start tag of <Product>. Could anyone recommend a solution? As far as I can tell I only have one root element, but maybe I'm missing something. <?xml version="1.0"?> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <xsd:include schemaLocation="amzn-base.xsd"/> <xsd:element name="product"> <
  • Create New...