Solved

Amazon xml to csv

Posted on 2009-07-02
3
1,017 Views
Last Modified: 2012-05-07
Hi,

Is there a way i can either do a transfer from amazon api xml to csv?

Please Bare in mind that i don know anything about programming. But i'm willing to put any effort to put this together.

It can be either online (i ahve a host) or via a free software.



Thanks
0
Comment
Question by:rentown
  • 2
3 Comments
 
LVL 23

Expert Comment

by:Tiggerito
Comment Utility
Could you provide a sample of the XML that amazon provide.

You should be able to use a XSL file to convert the XML into CSV. If we have the source XML and know how you want the CSV formatted we could probably create an XSL file for you.

You can then run the transform using one of many tools available. You can even get your browser to do the transform.

I use Visual Studio to do it so I don't know of any good/cheep tools to use. Google came up with this lot...

http://www.netcrucible.com/xslt/xslt-tool.htm
http://www.microsoft.com/downloads/details.aspx?FamilyID=2fb55371-c94e-4373-b0e9-db4816552e41&DisplayLang=en
http://www.stylusstudio.com/xslt.html


0
 

Author Comment

by:rentown
Comment Utility
hi,

thank you for your reply

Here are some samples

http://www.ericgiguere.com/tools/amazon-product-viewer-xml.html

http://webservices.amazon.com/onca/xml?Service=AWSECommerceService&SubscriptionId=037J1T33KPWD08H3A182&Operation=ItemLookup&IdType=ASIN&ItemId=0553212788&MerchantId=All&ResponseGroup=Large

http://webservices.amazon.com/onca/xml?Service=AWSECommerceService&SubscriptionId=037J1T33KPWD08H3A182&Operation=ItemLookup&IdType=ASIN&ItemId=0553212788&MerchantId=All&ResponseGroup=Large


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

- <ItemLookupResponse xmlns="http://webservices.amazon.com/AWSECommerceService/2005-10-05">

- <Items>

- <Item>

  <ASIN>B00166BCNQ</ASIN> 

  <DetailPageURL>http://www.amazon.com/exec/obidos/B00166BCNQ/ref=ericgiguerecom</DetailPageURL> 

  <SalesRank>1176</SalesRank> 

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/21FJJpn9-NL._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/21FJJpn9-NL._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/21FJJpn9-NL.jpg</URL> 

  <Height Units="pixels">150</Height> 

  <Width Units="pixels">300</Width> 

  </LargeImage>

- <ImageSets>

- <ImageSet Category="primary">

- <SwatchImage>

  <URL>http://ecx.images-amazon.com/images/I/21FJJpn9-NL._SL30_.jpg</URL> 

  <Height Units="pixels">15</Height> 

  <Width Units="pixels">30</Width> 

  </SwatchImage>

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/21FJJpn9-NL._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/21FJJpn9-NL._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/21FJJpn9-NL.jpg</URL> 

  <Height Units="pixels">150</Height> 

  <Width Units="pixels">300</Width> 

  </LargeImage>

  </ImageSet>

- <ImageSet Category="variant">

- <SwatchImage>

  <URL>http://ecx.images-amazon.com/images/I/31FG%2Bj4glUL._SL30_.jpg</URL> 

  <Height Units="pixels">15</Height> 

  <Width Units="pixels">30</Width> 

  </SwatchImage>

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/31FG%2Bj4glUL._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/31FG%2Bj4glUL._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/31FG%2Bj4glUL.jpg</URL> 

  <Height Units="pixels">250</Height> 

  <Width Units="pixels">500</Width> 

  </LargeImage>

  </ImageSet>

- <ImageSet Category="variant">

- <SwatchImage>

  <URL>http://ecx.images-amazon.com/images/I/31NANL17YfL._SL30_.jpg</URL> 

  <Height Units="pixels">15</Height> 

  <Width Units="pixels">30</Width> 

  </SwatchImage>

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/31NANL17YfL._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/31NANL17YfL._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/31NANL17YfL.jpg</URL> 

  <Height Units="pixels">150</Height> 

  <Width Units="pixels">300</Width> 

  </LargeImage>

  </ImageSet>

- <ImageSet Category="variant">

- <SwatchImage>

  <URL>http://ecx.images-amazon.com/images/I/21Ted%2Bi5rrL._SL30_.jpg</URL> 

  <Height Units="pixels">15</Height> 

  <Width Units="pixels">30</Width> 

  </SwatchImage>

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/21Ted%2Bi5rrL._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/21Ted%2Bi5rrL._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/21Ted%2Bi5rrL.jpg</URL> 

  <Height Units="pixels">150</Height> 

  <Width Units="pixels">300</Width> 

  </LargeImage>

  </ImageSet>

- <ImageSet Category="variant">

- <SwatchImage>

  <URL>http://ecx.images-amazon.com/images/I/31iGOcQ%2BwSL._SL30_.jpg</URL> 

  <Height Units="pixels">15</Height> 

  <Width Units="pixels">30</Width> 

  </SwatchImage>

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/31iGOcQ%2BwSL._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/31iGOcQ%2BwSL._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/31iGOcQ%2BwSL.jpg</URL> 

  <Height Units="pixels">150</Height> 

  <Width Units="pixels">300</Width> 

  </LargeImage>

  </ImageSet>

- <ImageSet Category="variant">

- <SwatchImage>

  <URL>http://ecx.images-amazon.com/images/I/21Ou2k-g7YL._SL30_.jpg</URL> 

  <Height Units="pixels">15</Height> 

  <Width Units="pixels">30</Width> 

  </SwatchImage>

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/21Ou2k-g7YL._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/21Ou2k-g7YL._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/21Ou2k-g7YL.jpg</URL> 

  <Height Units="pixels">150</Height> 

  <Width Units="pixels">300</Width> 

  </LargeImage>

  </ImageSet>

- <ImageSet Category="variant">

- <SwatchImage>

  <URL>http://ecx.images-amazon.com/images/I/31CEII51zcL._SL30_.jpg</URL> 

  <Height Units="pixels">15</Height> 

  <Width Units="pixels">30</Width> 

  </SwatchImage>

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/31CEII51zcL._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/31CEII51zcL._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/31CEII51zcL.jpg</URL> 

  <Height Units="pixels">150</Height> 

  <Width Units="pixels">300</Width> 

  </LargeImage>

  </ImageSet>

- <ImageSet Category="variant">

- <SwatchImage>

  <URL>http://ecx.images-amazon.com/images/I/31fgXyYQRuL._SL30_.jpg</URL> 

  <Height Units="pixels">15</Height> 

  <Width Units="pixels">30</Width> 

  </SwatchImage>

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/31fgXyYQRuL._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/31fgXyYQRuL._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/31fgXyYQRuL.jpg</URL> 

  <Height Units="pixels">150</Height> 

  <Width Units="pixels">300</Width> 

  </LargeImage>

  </ImageSet>

- <ImageSet Category="variant">

- <SwatchImage>

  <URL>http://ecx.images-amazon.com/images/I/31cQf-KTR5L._SL30_.jpg</URL> 

  <Height Units="pixels">15</Height> 

  <Width Units="pixels">30</Width> 

  </SwatchImage>

- <SmallImage>

  <URL>http://ecx.images-amazon.com/images/I/31cQf-KTR5L._SL75_.jpg</URL> 

  <Height Units="pixels">38</Height> 

  <Width Units="pixels">75</Width> 

  </SmallImage>

- <MediumImage>

  <URL>http://ecx.images-amazon.com/images/I/31cQf-KTR5L._SL160_.jpg</URL> 

  <Height Units="pixels">80</Height> 

  <Width Units="pixels">160</Width> 

  </MediumImage>

- <LargeImage>

  <URL>http://ecx.images-amazon.com/images/I/31cQf-KTR5L.jpg</URL> 

  <Height Units="pixels">150</Height> 

  <Width Units="pixels">300</Width> 

  </LargeImage>

  </ImageSet>

  </ImageSets>

- <ItemAttributes>

  <Binding>Apparel</Binding> 

  <Brand>JiMarti</Brand> 

  <EAN>0782324000040</EAN> 

  <Feature>Lightweight Polycarbonate Shatterproof frame and lens</Feature> 

  <Feature>Full UV400 protection lens</Feature> 

  <Feature>Snug fit frame for Active Comfort. Adjustable rubber tips</Feature> 

  <Feature>30 day money-back guarantee</Feature> 

  <Feature>Lifetime Breakage Warranty</Feature> 

- <ItemDimensions>

  <Height Units="hundredths-inches">200</Height> 

  <Length Units="hundredths-inches">200</Length> 

  <Weight Units="hundredths-pounds">13</Weight> 

  <Width Units="hundredths-inches">550</Width> 

  </ItemDimensions>

- <ListPrice>

  <Amount>3995</Amount> 

  <CurrencyCode>USD</CurrencyCode> 

  <FormattedPrice>$39.95</FormattedPrice> 

  </ListPrice>

  <MPN>x1</MPN> 

- <PackageDimensions>

  <Height Units="hundredths-inches">200</Height> 

  <Length Units="hundredths-inches">550</Length> 

  <Weight Units="hundredths-pounds">13</Weight> 

  <Width Units="hundredths-inches">200</Width> 

  </PackageDimensions>

  <ProductGroup>Apparel</ProductGroup> 

  <Title>X Loop Sunglasses Wrap X1 Style UV400 Lens Unisex Frame for Cycling, Golf, Kayaking and All Active Sports. Some colors on Closeout.</Title> 

  <UPC>782324000040</UPC> 

  </ItemAttributes>

- <OfferSummary>

  <TotalNew>0</TotalNew> 

  <TotalUsed>0</TotalUsed> 

  <TotalCollectible>0</TotalCollectible> 

  <TotalRefurbished>0</TotalRefurbished> 

  </OfferSummary>

- <Offers>

  <TotalOffers>0</TotalOffers> 

  <TotalOfferPages>0</TotalOfferPages> 

  </Offers>

- <CustomerReviews>

  <AverageRating>3.0</AverageRating> 

  <TotalReviews>13</TotalReviews> 

  <TotalReviewPages>3</TotalReviewPages> 

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>2</Rating> 

  <HelpfulVotes>0</HelpfulVotes> 

  <CustomerId>A1H28YEA2Z4BR3</CustomerId> 

  <TotalVotes>0</TotalVotes> 

  <Date>2009-06-18</Date> 

  <Summary>Cheap!!</Summary> 

  <Content>If these ever really cost more than $6.95 I would not buy them. Within a month of use one of the ear guards fell off. The only thing that I found appealing about them was that the lenses are decent, they really block a lot of rays. However, would never purchase a pair again.</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>1</Rating> 

  <HelpfulVotes>0</HelpfulVotes> 

  <CustomerId>A2L3MSNCOK19DR</CustomerId> 

  <TotalVotes>1</TotalVotes> 

  <Date>2009-06-15</Date> 

  <Summary>break very easily. were awesome though when they werent broken. completely made of plastic. would never buy</Summary> 

  <Content>the glasses look like theyre made of metal but the whole thing is made of plastic</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>2</Rating> 

  <HelpfulVotes>1</HelpfulVotes> 

  <CustomerId>A30RWYZ3TV48N9</CustomerId> 

  <TotalVotes>1</TotalVotes> 

  <Date>2009-06-09</Date> 

  <Summary>they're OK</Summary> 

  <Content>Don't be fooled by the price tag. IMHO they're not worth the forty bucks they claim for the original price. They're OK if you pay the eight dollars for an eight dollar pair of sunglasses. Already looking for their replacement.</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>2</Rating> 

  <HelpfulVotes>1</HelpfulVotes> 

  <CustomerId>ASR6LESNXJFAN</CustomerId> 

  <TotalVotes>1</TotalVotes> 

  <Date>2009-05-27</Date> 

  <Summary>Buy Cheap ... Get Cheap</Summary> 

  <Content>Really cheap plastic. The quality of the glasses weren't much better than the quality of a Mardi Gras throw. Mardi Gras throw = No quality. I have bought $10-$15 glasses before that were decent. They were worn one day just to give them a shot, then thrown in the garbage. Just google crossfire sunglasses, they are the best deal out there.</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>2</Rating> 

  <HelpfulVotes>0</HelpfulVotes> 

  <CustomerId>A2PVVMK6M0GPB8</CustomerId> 

  <TotalVotes>0</TotalVotes> 

  <Date>2009-05-11</Date> 

  <Summary>X Loop wrap review</Summary> 

  <Content>I was disappointed with the fit and comfort of the glasses and have not worn them very much. The glasses are to stiff and do not set well on your face; they are to tight at the temple causing them to pivot across your nose and will not adjust.</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>4</Rating> 

  <HelpfulVotes>0</HelpfulVotes> 

  <CustomerId>AE3F63OACE5FF</CustomerId> 

  <TotalVotes>0</TotalVotes> 

  <Date>2009-04-02</Date> 

  <Summary>X loop Sunglasses...</Summary> 

  <Content>As some have said before, the lenses are a little on the small side, however, after using them several times on rides, the lens size seems right. The glasses are light and comfortable and stay on well. I use them for cycling. Shipped quickly too. For the price they are hard to beat. I would recommend these glasses for cycling as they do a terrific job.</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>1</Rating> 

  <HelpfulVotes>2</HelpfulVotes> 

  <CustomerId>A2G066515NVLMI</CustomerId> 

  <TotalVotes>3</TotalVotes> 

  <Date>2009-03-23</Date> 

  <Summary>Nah. Spend your money elsewhere</Summary> 

  <Content>Somebody's gotta be joking to give this 5 stars. Somebody else gotta be joking saying the original price was $39. <br /> <br />It's one of the cheapest made glass I ever seen. Mine lasted less than a month before breaking. <br /> <br />This product should be removed from Amazon.</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>5</Rating> 

  <HelpfulVotes>0</HelpfulVotes> 

  <CustomerId>AFUKC2RG7NWTN</CustomerId> 

  <TotalVotes>0</TotalVotes> 

  <Date>2009-03-20</Date> 

  <Summary>Very Nice</Summary> 

  <Content>I ordered two pair of these, and got them two days later with regular shipping... VERY FAST SHIPPING! They look good and fit well too... You cant compare them to Oakley or SPY Optics, but for $6 to $12 you can complain. verses $100 to $350 for Oakley or SPY Optics... I give it 5 stars, really great product for the price.</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>5</Rating> 

  <HelpfulVotes>1</HelpfulVotes> 

  <CustomerId>A2LM4FOAXRPTE8</CustomerId> 

  <TotalVotes>1</TotalVotes> 

  <Date>2008-09-07</Date> 

  <Summary>Great Follow-up</Summary> 

  <Content>They had actually sent me a defective pair. The left bridge was broken. <br /> <br />I sent them an email and they sent me a replacement no questions asked. What was better was that I live in Singapore and they still sent me a replacement with no cost. Now thats great service. <br /> <br />I love the design of this pair and the service by Jimarti. Great job guys.</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>3</Rating> 

  <HelpfulVotes>1</HelpfulVotes> 

  <CustomerId>A1HG4XYKB9P69P</CustomerId> 

  <TotalVotes>1</TotalVotes> 

  <Date>2008-08-26</Date> 

  <Summary>X-Loop Sunglasses</Summary> 

  <Content>Lower quality of plastic than expected. Shipping was very fast though and image matches product. Good seller!!</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>4</Rating> 

  <HelpfulVotes>1</HelpfulVotes> 

  <CustomerId>A1O6CS7SXLGUWZ</CustomerId> 

  <TotalVotes>1</TotalVotes> 

  <Date>2008-08-25</Date> 

  <Summary>Very nice</Summary> 

  <Content>These sunglasses may look a little odd, to me at least, but they fit well and certainly appear to be fairly rugged. <br /> <br />They have some flex in them so one doesn't have to worry about them snapping when you take them off. <br /> <br />The lenses are a little small for my taste but I am able to comfortably wear these sunglasses for long periods of time. I can recommend them to other buyers.</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>4</Rating> 

  <HelpfulVotes>0</HelpfulVotes> 

  <CustomerId>AY1ED27O50MQ7</CustomerId> 

  <TotalVotes>0</TotalVotes> 

  <Date>2008-07-09</Date> 

  <Summary>Nice looking shades</Summary> 

  <Content>These are nice looking sunglasses, and a great price. It's tough to purchase this type of item online, my first pair that were delivered were a little warped, However a replacement pair was sent the day I inquired. Also, the description of "unbreakable" is a little off, My replacement pair broke with a soccer ball header, again, a replacement pair was sent the day free of charge (great customer service!)</Content> 

  </Review>

- <Review>

  <ASIN>B00166BCNQ</ASIN> 

  <Rating>4</Rating> 

  <HelpfulVotes>0</HelpfulVotes> 

  <CustomerId>A5HU6YQ2QGQYK</CustomerId> 

  <TotalVotes>0</TotalVotes> 

  <Date>2008-06-20</Date> 

  <Summary>They fit nice.</Summary> 

  <Content>I bought these sunglasses for my husband. They fit nice, but they look a little different. They have this bumpy design on the front of the glasses I didn't notice when I saw the picture. Look closely and you'll see. This is the only thing I don't like about the sunglasses. My husband has no complaints, so I think they're good. I just don't like the bumpy design. I think it looks a little wierd.</Content> 

  </Review>

  </CustomerReviews>

- <EditorialReviews>

- <EditorialReview>

  <Source>Product Description</Source> 

  <Content>JiMarti Sunglasses combine two functions: 1) Protect the eyes from the harmful UV spectrum of sunlight, and 2) Make a fashion statement. Sunglasses are a fashion accessory which must look stylish and elegant. Sunglass products offered by JiMarti will take good care of your vision, protecting your eyes from harmful sun rays. These sunglasses feature UV400 Lens Technology, absorbing over 99% of harmful UVA and UVB spectrums. Sunglasses comply with ANSI Z80.3 (USA UV Protection standard) and comply with 89/686/EEC and CE (European directives). Some of our products come with Polarized lenses which remove glare, thus promoting safe driving, boating, and also allowing you to see into the water while fishing. Our shades are an ultimate fashion statement at affordable prices! Comfortable, and appropriate for any occasion or activity, these new sunglasses from JiMarti are guaranteed to make heads turn. The Styles we offer are designed for both women and men. We carry a broad selection of sports and casual eyewear at our Storefront Location, so you search JiMarti and go right to us. We inventory multiple styles, colors, and price ranges for Immediate Delivery thus insuring that everyone will find a pair they like at Value Pricing.</Content> 

  </EditorialReview>

  </EditorialReviews>

- <SimilarProducts>

- <SimilarProduct>

  <ASIN>B0016JN506</ASIN> 

  <Title>X Loop X44 Sunglasses Wrap Style UV400 Lens for Baseball, Softball, Cycling, Golf, Kayaking and All Active Sports. CLOSEOUT on some colors</Title> 

  </SimilarProduct>

- <SimilarProduct>

  <ASIN>B00164YFXW</ASIN> 

  <Title>X Loop P5 Polarized Active Sports Frame Sunglasses. Some colors on CLOSEOUT</Title> 

  </SimilarProduct>

- <SimilarProduct>

  <ASIN>B00162KS5S</ASIN> 

  <Title>XS15 Sunglasses uv400 Unbreakable Protection Some Colors on CLOSEOUT</Title> 

  </SimilarProduct>

- <SimilarProduct>

  <ASIN>B00165OH3O</ASIN> 

  <Title>X18 Sunglasses Uv400 Lens Unisex Active Frame.</Title> 

  </SimilarProduct>

- <SimilarProduct>

  <ASIN>B0016CCJDW</ASIN> 

  <Title>POLARIZED Sunglasses P79 Super Light Sport Frame for Active Lifestyle (Select colors on Closeout)</Title> 

  </SimilarProduct>

  </SimilarProducts>

- <BrowseNodes>

- <BrowseNode>

  <BrowseNodeId>1046310</BrowseNodeId> 

  <Name>Sunglasses</Name> 

- <Ancestors>

- <BrowseNode>

  <BrowseNodeId>15743621</BrowseNodeId> 

  <Name>Eyewear & Accessories</Name> 

- <Ancestors>

- <BrowseNode>

  <BrowseNodeId>1036700</BrowseNodeId> 

  <Name>Accessories</Name> 

- <Ancestors>

- <BrowseNode>

  <BrowseNodeId>1036682</BrowseNodeId> 

  <Name>Departments</Name> 

- <Ancestors>

- <BrowseNode>

  <BrowseNodeId>1036592</BrowseNodeId> 

  <Name>Apparel</Name> 

  </BrowseNode>

  </Ancestors>

  </BrowseNode>

  </Ancestors>

  </BrowseNode>

  </Ancestors>

  </BrowseNode>

  </Ancestors>

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>251277011</BrowseNodeId> 

  <Name>Custom Stores</Name> 

- <Children>

- <BrowseNode>

  <BrowseNodeId>13952391</BrowseNodeId> 

  <Name>Designer Specialty Store</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>689281011</BrowseNodeId> 

  <Name>Work Apparel & Uniforms</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>689282011</BrowseNodeId> 

  <Name>Wedding</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>689283011</BrowseNodeId> 

  <Name>School Uniforms</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>1232947011</BrowseNodeId> 

  <Name>Cold Weather Apparel</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>1258977011</BrowseNodeId> 

  <Name>Maternity</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>1263416011</BrowseNodeId> 

  <Name>Plus Size</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>1260917011</BrowseNodeId> 

  <Name>Test Platinum & Gold Generalization</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>1297113011</BrowseNodeId> 

  <Name>Outerwear</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>1297150011</BrowseNodeId> 

  <Name>Outdoor & Camping</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>2055486011</BrowseNodeId> 

  <Name>What to Wear</Name> 

  </BrowseNode>

  </Children>

- <Ancestors>

- <BrowseNode>

  <BrowseNodeId>1036684</BrowseNodeId> 

  <Name>Specialty Stores</Name> 

- <Ancestors>

- <BrowseNode>

  <BrowseNodeId>1036592</BrowseNodeId> 

  <Name>Apparel</Name> 

  </BrowseNode>

  </Ancestors>

  </BrowseNode>

  </Ancestors>

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>3375301</BrowseNodeId> 

  <Name>Categories</Name> 

- <Children>

- <BrowseNode>

  <BrowseNodeId>3394801</BrowseNodeId> 

  <Name>Accessories</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>3386071</BrowseNodeId> 

  <Name>Fan Gear</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>3375311</BrowseNodeId> 

  <Name>Apparel</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>3392741</BrowseNodeId> 

  <Name>Shoes</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>706812011</BrowseNodeId> 

  <Name>Action Sports</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>3421331</BrowseNodeId> 

  <Name>Boating & Water Sports</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>3403201</BrowseNodeId> 

  <Name>Cycling & Wheel Sports</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>3407731</BrowseNodeId> 

  <Name>Exercise & Fitness</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>3410851</BrowseNodeId> 

  <Name>Golf</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>706813011</BrowseNodeId> 

  <Name>Hunting & Fishing</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>706808011</BrowseNodeId> 

  <Name>Leisure Sports & Games</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>706814011</BrowseNodeId> 

  <Name>Outdoor Recreation</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>706815011</BrowseNodeId> 

  <Name>Paintball & Airsoft</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>706816011</BrowseNodeId> 

  <Name>Racquet Sports</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>706809011</BrowseNodeId> 

  <Name>Team Sports</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>706810011</BrowseNodeId> 

  <Name>Other Sports</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>3422351</BrowseNodeId> 

  <Name>Sports Medicine</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>219367011</BrowseNodeId> 

  <Name>Sports Electronics & Gadgets</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>378526011</BrowseNodeId> 

  <Name>Sport Watches</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>491437011</BrowseNodeId> 

  <Name>Car Sports Racks</Name> 

  </BrowseNode>

- <BrowseNode>

  <BrowseNodeId>706811011</BrowseNodeId> 

  <Name>Exercise and Fitness</Name> 

  </BrowseNode>

  </Children>

- <Ancestors>

- <BrowseNode>

  <BrowseNodeId>3375251</BrowseNodeId> 

  <Name>Sports & Outdoors</Name> 

  </BrowseNode>

  </Ancestors>

  </BrowseNode>

  </BrowseNodes>

  </Item>

  </Items>

  </ItemLookupResponse>

Open in new window

0
 
LVL 23

Accepted Solution

by:
Tiggerito earned 500 total points
Comment Utility
Amazon provide a lot of information!

I presume you want a CSV file that lists the Items in the data. I have created a sample transform that works with your second XML source and provides a few columns from the Item in it.

To preview it you can do the following:
  • Save my XSL file as Amazon.xsl
  • Save your source XML file in the same folder (say as Amazon.xml)
  • Edit the Amazon.xml file so it starts like this.
<?xml version="1.0" ?>
<?xml-stylesheet type="text/xsl" href="Amazon.xsl"?>
<ItemLookupResponse ...

This tells the XML file to use my XSL file to format itself.

View the Amazon.xml file in your browser. You should see a CSV formatted result.

Note: the way you copied your XML into the code snippet makes the XML invalid. I presume you just selected and copied it from a browser. You need to "view source" and copy that, as the browser does some re-formatting of the XML to display it.

Another helpful link about xsl, which includes a online tool for transforming the XML
http://www.w3schools.com/xsl/default.asp

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

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:amazon="http://webservices.amazon.com/AWSECommerceService/2005-10-05">

	<xsl:output method="text"/>
 

	<!-- the main routine-->

	<xsl:template match="/">

		

		<!-- create heading row-->

		<xsl:text>ASIN, SalesRank, Author

</xsl:text>
 

		<!-- find all items hand have them processed -->

		<xsl:apply-templates select="amazon:ItemLookupResponse/amazon:Items/amazon:Item"/>

	</xsl:template>
 

	<!-- handles each Item/row -->

	<xsl:template match="amazon:Item">

		<!-- add each fields value-->

		<xsl:apply-templates select="amazon:ASIN"/>

		<xsl:text>, </xsl:text>

		<xsl:apply-templates select="amazon:SalesRank"/>

		<xsl:text>, </xsl:text>

		<xsl:apply-templates select="amazon:ItemAttributes/amazon:Author"/>

		

		<!-- Simple way to add a new line-->

		<xsl:text>

</xsl:text>

	</xsl:template>
 

</xsl:stylesheet>

Open in new window

0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
XSL Grouping 7 36
router and equipment 3 74
Load XML file into a SQL Server Table using SSIS 2012 9 47
Create XML 5 30
The Problem How to write an Xquery that works like a SQL outer join, providing placeholders for absent data on the outer side?  I give a bit more background at the end. The situation expressed as relational data Let’s work through this.  I’ve …
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now