使用Javascript的XML到CSV转换 [英] XML to CSV Conversion using Javascript
问题描述
我在寻找一些帮助,尝试转换从Amazon Product API检索的XML以将其转换为CSV(逗号分隔值)格式。
我发现了一个类似的主题这里: XML到CSV转换问题,但它使用PHP,我想使用javascript
以下是我所拥有的范例:
<?xml version =1.0encoding =UTF-8?>
< ItemLookupResponse xmlns =http://webservices.amazon.com/AWSECommerceService/2011-08-01>
< OperationRequest>
< RequestId> 1k75f474-85ff-464a-al93-659ol460caee< / RequestId>
< Arguments>
< Argument Name =OperationValue =ItemLookup/>
< Argument Name =ServiceValue =AWSECommerceService/>
< Argument Name =SignatureValue =lImNXr6R4c2t376ghMnMmjUPR4eY6755XzH41pXGH0P =/>
< Argument Name =AssociateTagValue =oiuig-20/>
< Argument Name =ItemIdValue =B007EHI1DK/>
< Argument Name =AWSAccessKeyIdValue =DIY7F4M00OF6I7TRD3VA/>
< Argument Name =TimestampValue =2013-01-04T05:23:20Z/>
< Argument Name =ResponseGroupValue =Large/>
< / Arguments>
< RequestProcessingTime> 0.0359500000000000< / RequestProcessingTime>
< / OperationRequest>
< Items>
< Request>
< IsValid> True< / IsValid>
< ItemLookupRequest>
< IdType> ASIN< / IdType>
< ItemId> B007EHI1DK< / ItemId>
< ResponseGroup> Large< / ResponseGroup>
< VariationPage>全部< / VariationPage>
< / ItemLookupRequest>
< / Request>
< Item>
< ASIN> B007EHI1DK< / ASIN>
< DetailPageURL> http://www.amazon.com/Panasonic-TY-ER3D4MU-Active-Shutter-Eyewear/dp/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp% 3D2025%26creative%3D165953%26creativeASIN%3DB007EHI1DK< / DetailPageURL>
< ItemLinks>
< ItemLink>
< Description>技术细节< / Description>
< URL> http://www.amazon.com/Panasonic-TY-ER3D4MU-Active-Shutter-Eyewear/dp/tech-data/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode% 3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK< / URL>
< / ItemLink>
< ItemLink>
<说明>添加到婴儿注册表< / Description>
< URL> http://www.amazon.com/gp/registry/baby/add-item.html%3Fasin.0%3DB007EHI1DK%26SubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2% 26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK< / URL>
< / ItemLink>
< ItemLink>
< Description>添加到婚礼登记处< / Description>
< URL> http://www.amazon.com/gp/registry/wedding/add-item.html%3Fasin.0%3DB007EHI1DK%26SubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2% 26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK< / URL>
< / ItemLink>
< ItemLink>
<描述>添加到收藏< / Description>
< URL> http://www.amazon.com/gp/registry/wishlist/add-item.html%3Fasin.0%3DB007EHI1DK%26SubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2% 26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK< / URL>
< / ItemLink>
< ItemLink>
< Description>告诉朋友< / Description>
< URL> http://www.amazon.com/gp/pdp/taf/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN% 3DB007EHI1DK< / URL>
< / ItemLink>
< ItemLink>
<描述>所有客户评论< / Description>
< URL> http://www.amazon.com/review/product/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK< / URL>
< / ItemLink>
< ItemLink>
<说明>所有优惠< / Description>
< URL> http://www.amazon.com/gp/offer-listing/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN% 3DB007EHI1DK< / URL>
< / itemLink>
< / ItemsLinks>
< SmallImage>
< URL> http://ecx.images-amazon.com/images/I/31pKDguukTL._SL75_.jpg< / URL>
< Height Units =pixels> 50< / Height>
< Width Units =pixels> 75< / Width>
< / SmallImage>
< MediumImage>
< URL> http://ecx.images-amazon.com/images/I/31pKDguukTL._SL160_.jpg< / URL>
< Height Units =pixels> 107< / Height>
< Width Units =pixels> 160< / Width>
< / MediumImage>
< LargeImage>
< URL> http://ecx.images-amazon.com/images/I/31pKDguukTL.jpg< / URL>
< Height Units =pixels> 333< / Height>
< Width Units =pixels> 500< / Width>
< / LargeImage>
< ImageSets>
< ImageSet Category =primary>
< SwatchImage>
< URL> http://ecx.images-amazon.com/images/I/31pKDguukTL._SL30_.jpg< / URL>
< Height Units =pixels> 20< / Height>
< Width Units =pixels> 30< / Width>
< / SwatchImage>
< SmallImage>
< URL> http://ecx.images-amazon.com/images/I/31pKDguukTL._SL75_.jpg< / URL>
< Height Units =pixels> 50< / Height>
< Width Units =pixels> 75< / Width>
< / SmallImage>
< ThumbnailImage>
< URL> http://ecx.images-amazon.com/images/I/31pKDguukTL._SL75_.jpg< / URL>
< Height Units =pixels> 50< / Height>
< Width Units =pixels> 75< / Width>
< / ThumbnailImage>
< TinyImage>
< URL> http://ecx.images-amazon.com/images/I/31pKDguukTL._SL110_.jpg< / URL>
< Height Units =pixels> 73< / Height>
< Width Units =pixels> 110< / Width>
< / TinyImage>
< MediumImage>
< URL> http://ecx.images-amazon.com/images/I/31pKDguukTL._SL160_.jpg< / URL>
< Height Units =pixels> 107< / Height>
< Width Units =pixels> 160< / Width>
< / MediumImage>
< LargeImage>
< URL> http://ecx.images-amazon.com/images/I/31pKDguukTL.jpg< / URL>
< Height Units =pixels> 333< / Height>
< Width Units =pixels> 500< / Width>
< / LargeImage>
< / ImageSet>
< ImageSet Category =variant>
< SwatchImage>
< URL> http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL30_.jpg< / URL>
< Height Units =pixels> 20< / Height>
< Width Units =pixels> 30< / Width>
< / SwatchImage>
< SmallImage>
< URL> http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL75_.jpg< / URL>
< Height Units =pixels> 50< / Height>
< Width Units =pixels> 75< / Width>
< / SmallImage>
< ThumbnailImage>
< URL> http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL75_.jpg< / URL>
< Height Units =pixels> 50< / Height>
< Width Units =pixels> 75< / Width>
< / ThumbnailImage>
< TinyImage>
< URL> http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL110_.jpg< / URL>
< Height Units =pixels> 73< / Height>
< Width Units =pixels> 110< / Width>
< / TinyImage>
< MediumImage>
< URL> http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL160_.jpg< / URL>
< Height Units =pixels> 107< / Height>
< Width Units =pixels> 160< / Width>
< / MediumImage>
< LargeImage>
< URL> http://ecx.images-amazon.com/images/I/31dSwH5PnjL.jpg< / URL>
< Height Units =pixels> 333< / Height>
< Width Units =pixels> 500< / Width>
< / LargeImage>
< / ImageSet>
< ImageSet Category =variant>
< SwatchImage>
< URL> http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL30_.jpg< / URL>
< Height Units =pixels> 20< / Height>
< Width Units =pixels> 30< / Width>
< / SwatchImage>
< SmallImage>
< URL> http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL75_.jpg< / URL>
< Height Units =pixels> 50< / Height>
< Width Units =pixels> 75< / Width>
< / SmallImage>
< ThumbnailImage>
< URL> http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL75_.jpg< / URL>
< Height Units =pixels> 50< / Height>
< Width Units =pixels> 75< / Width>
< / ThumbnailImage>
< TinyImage>
< URL> http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL110_.jpg< / URL>
< Height Units =pixels> 73< / Height>
< Width Units =pixels> 110< / Width>
< / TinyImage>
< MediumImage>
< URL> http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL160_.jpg< / URL>
< Height Units =pixels> 107< / Height>
< Width Units =pixels> 160< / Width>
< / MediumImage>
< LargeImage>
< URL> http://ecx.images-amazon.com/images/I/31irEbzxdgL.jpg< / URL>
< Height Units =pixels> 333< / Height>
< Width Units =pixels> 500< / Width>
< / LargeImage>
< / ImageSet>
< / ImageSets>
< ItemAttributes>
< Binding> Electronics< / Binding>
< Brand> Panasonic< / Brand>
< CatalogNumberList>
< CatalogNumberListElement> TYER3D4M< / CatalogNumberListElement>
< CatalogNumberListElement> TYER3D4MU< / CatalogNumberListElement>
< CatalogNumberListElement> TY-ER3D4MU< / CatalogNumberListElement>
< / CatalogNumberList>
< Color>一种颜色< / Color>
< Department> Electronics< / Department>
< EAN> 0885170075207< / EAN>
< EANList>
< EANListElement> 0885170075207< / EANListElement>
< / EANList>
< Feature>轻便活动快门3D眼镜< / Feature>
< Feature> USB充电器< / Feature>
< Feature> RF兼容< / Feature>
< IsAutographed> 0< / IsAutographed>
< IsMemorabilia> 0< / IsMemorabilia>
< ItemDimensions>
< Height Units =hundredths-inches> 170< / Height>
< Length Units =hundredths-inches> 340< / Length>
< Weight Units =hundredths-pounds> 10< / Weight>
< Width Units =hundredths-inches> 670< / Width>
< / ItemDimensions>
< Label> Panasonic< / Label>
< ListPrice>
< Amount> 7995< / Amount>
< CurrencyCode> USD< / CurrencyCode>
< FormattedPrice> $ 79.95< / FormattedPrice>
< / ListPrice>
< Manufacturer> Panasonic< / Manufacturer>
< Model> TY-ER3D4MU< / Model>
< MPN> TY-ER3D4MU< / MPN>
< NumberOfItems> 1< / NumberOfItems>
< PackageDimensions>
< Height Units =hundredths-inches> 240< / Height>
< Length Units =hundredths-inches> 690< / Length>
< Weight Units =hundredths-pounds> 30< / Weight>
< Width Units =hundredths-inches> 350< / Width>
< / PackageDimensions>
< PackageQuantity> 1< / PackageQuantity>
< PartNumber> TY-ER3D4MU< / PartNumber>
< ProductGroup> CE< / ProductGroup>
< ProductTypeName> CONSUMER_ELECTRONICS< / ProductTypeName>
< Publisher> Panasonic< / Publisher>
< Size>一个尺寸< / Size>
< SKU> 292782< / SKU>
< Studio> Panasonic< / Studio>
< Title> Panasonic VIERA TY-ER3D4MU主动快门3D眼镜< / Title>
< UPC> 885170075207< / UPC>
< UPCList>
< UPCListElement> 885170075207< / UPCListElement>
< / UPCList>
< / ItemAttributes>
< OfferSummary>
< LowestNewPrice>
< Amount> 5400< / Amount>
< CurrencyCode> USD< / CurrencyCode>
< FormattedPrice> $ 54.00< / FormattedPrice>
< / LowestNewPrice>
< LowestUsedPrice>
< Amount> 4294< / Amount>
< CurrencyCode> USD< / CurrencyCode>
< FormattedPrice> $ 42.94< / FormattedPrice>
< / LowestUsedPrice>
< TotalNew> 24< / TotalNew>
< TotalUsed> 18< / TotalUsed>
< TotalCollectible> 0< / TotalCollectible>
< TotalRefurbished> 0< / TotalRefurbished>
< / OfferSummary>
< Offers>
< TotalOffers> 1 < TotalOfferPages> 1< / TotalOfferPages>
< MoreOffersUrl> http://www.amazon.com/gp/offer-listing/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN% 3DB007EHI1DK< / MoreOffersUrl>
< Offer>
< OfferAttributes>
< Condition> New< / Condition>
< / OfferAttributes>
< OfferListing>
< OfferListingId> rkyW%2Bed7Qb8t28tJRRHkKizuk2CxNF4SI6W9XAnbXI8JX%2FJNpUY%2B8zqnnNRe3Vt2l%2B8rUMqypquQnAE66PYmf32dJeor6DifXvXKscwOqyrLwgFZORqmDg%3D%3D< / OfferListingId>
< Price>
< Amount> 5851< / Amount>
< CurrencyCode> USD< / CurrencyCode>
< FormattedPrice> $ 58.51< / FormattedPrice>
< / Price>
< AmountSaved>
< Amount> 2144< / Amount>
< CurrencyCode> USD< / CurrencyCode>
< FormattedPrice> $ 21.44< / FormattedPrice>
< / AmountSaved>
< PercentageSaved> 27< / PercentageSaved>
< Availability>通常于24小时内发货< / Availability>
< availabilityAttributes>
< AvailabilityType> now< / AvailabilityType>
< MinimumHours> 0< / MinimumHours>
< MaximumHours> 0< / MaximumHours>
< / AvailabilityAttributes>
< IsEligibleForSuperSaverShipping> 1< / IsEligibleForSuperSaverShipping>
< / OfferListing>
< / Offer>
< / Offers>
< CustomerReviews>
< IFrameURL> http://www.amazon.com/reviews/iframe?akid = AKIAIBT3ANF6TOEOKXVA& amp; alinkCode = xm2& amp; ampin asin = B007EHI1DK& amp; atag = aztag-20& amp; exp = 2013-01-05T05%3A23%3A21Z& amp; amp; v = 2& amp; sig = yz1U1nT8mWjFGauK3umnsOqp9BTzWwGOAAiLCyZ%2BEPM%3D< / IFrameURL>
< HasReviews> true< / HasReviews>
< / CustomerReferences>
< EditorialReviews>
< EditorialReview>
< Source>产品说明< / Source>
<内容>& lt; strong& gt; 3D播放类型:& lt; / strong& gt;活动快门3D方法< br /& gt;& lt; strong& gt;透射率法:& lt; / strong& RF(蓝牙)/全高清3D眼镜标准兼容& lt; br /& gt;& lt; strong& gt电池类型:& lt; / strong& gt;锂离子聚合物可充电电池& /& gt;& lt; strong& gt;电池持续时间:& lt; / strong& gt;对于30分钟的全电池充电(对于2分钟的电池充电大约3小时的操作)和大约30小时的电池充电操作大约30小时。 *电池持续时间将根据总使用时间随充电/放电周期数和< / em& gt;& lt; br /& gt;& lt; strong& & lt; / strong& gt; 1对眼镜& lt; br /& gt;注意:这些眼镜仅与2012年VIERA HDTV和< br />& lt; br / & lt;>< div style =text-align:left;& gt;& lt; strong& gt;< br /& gt;& lt; / strong& lt; / div& gt; & lt; img height =375src =http://g-ecx.images-amazon.com/images/G/01/electronics/Cat500/Panasonic/2012/accessory_compatibility_2._V138249826_.gifwidth = 650/& gt;& lt; br /& gt;& lt; br />< / Content>
< IsLinkSuppressed> 0< / IsLinkSuppressed>
< / EditorialReview>
< / EditorialReviews>
< SimilarProducts>
< SimilarProduct>
< ASIN> B007K9P7H0< / ASIN>
< Title> Samsung SSG-4100GB 3D主动眼镜2012款型号 - 黑色< / Title>
< / SimilarProduct>
< SimilarProduct>
< ASIN> B00752VKSC< / ASIN>
< /标题> Panasonic VIERA TC-P55ST50 55英寸1080p 600Hz全高清3D等离子电视< /标题>
< / SimilarProduct>
< SimilarProduct>
< ASIN> B00752R4PK< / ASIN>
< Title> Panasonic DMP-BDT220集成Wi-Fi 3D蓝光DVD播放器< / Title>
< / SimilarProduct>
< SimilarProduct>
< ASIN> B00752VKFA< / ASIN>
< /标题> Panasonic VIERA TC-P55GT50 55英寸1080p 600Hz全高清3D等离子电视< /标题>
< / SimilarProduct>
< SimilarProduct>
< ASIN> B00752VL8G< / ASIN>
< /标题> Panasonic VIERA TC-P60GT50 60英寸1080p 600Hz全高清3D等离子电视< /标题>
< / SimilarProduct>
< / SimilarProducts>
< BrowseNodes>
< BrowseNode>
< BrowseNodeId> 3224438011< / BrowseNodeId>
< Name> 3D眼镜< / Name>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 172532< / BrowseNodeId>
< Name> Audio& amp;视频附件< / Name>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 281407< / BrowseNodeId>
< Name>配件& amp;用品< / Name>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 493964< / BrowseNodeId>
< Name> Categories< / Name>
< IsCategoryRoot> 1< / IsCategoryRoot>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 172282< / BrowseNodeId>
< Name> Electronics< / Name>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< BrowseNode>
< BrowseNodeId> 1288264011< / BrowseNodeId>
< Name>所有产品< / Name>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 1267878011< / BrowseNodeId>
< Name>产品< / Name>
< IsCategoryRoot> 1< / IsCategoryRoot>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 1267877011< / BrowseNodeId>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< BrowseNode>
< BrowseNodeId> 3545110011< / BrowseNodeId>
< Name>家庭娱乐< / Name>
< Children>
< BrowseNode>
< BrowseNodeId> 3547652011< / BrowseNodeId>
< Name> Blu-Ray Players< / Name>
< / BrowseNode>
< BrowseNode>
< BrowseNodeId> 3547650011< / BrowseNodeId>
< Name> DVD播放器< / Name>
< / BrowseNode>
< BrowseNode>
< BrowseNodeId> 6183878011< / BrowseNodeId>
< Name>家庭影院投影仪< / Name>
< / BrowseNode>
< BrowseNode>
< BrowseNodeId> 1294446011< / BrowseNodeId>
< Name>电视< / Name>
< / BrowseNode>
< BrowseNode>
< BrowseNodeId> 6183893011< / BrowseNodeId>
< Name>电视调谐器和接收器< / Name>
< / BrowseNode>
< / Children>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 1294447011< / BrowseNodeId>
< Name> Electronics< / Name>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 1267878011< / BrowseNodeId>
< Name>产品< / Name>
< IsCategoryRoot> 1< / IsCategoryRoot>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 1267877011< / BrowseNodeId>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< BrowseNode>
< BrowseNodeId> 1293319011< / BrowseNodeId>
< Name> Electronics< / Name>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 1267879011< / BrowseNodeId>
< Name>特殊功能< / Name>
< Ancestors>
< BrowseNode>
< BrowseNodeId> 1267877011< / BrowseNodeId>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< / Ancestors>
< / BrowseNode>
< / BrowseNodes>
< / Item>
< / Items>
< / ItemLookupResponse>
我尝试使用Javascript将此数据格式化为CSV格式表。
有人可以帮忙吗?
提前感谢!
Praney
经过长时间的调查,我发现了一些可以帮助你的东西。
从重新发明轮子这样一个愚蠢和耗时的任务开始,我一直在寻找其他好的程序员已经在互联网上建立了。
很遗憾,我无法找到一个直接的转换器表单XML到CSV作为您在PHP中提供的示例。
在我的工作示例XML必须先从JSON传递,如下所示:
- xml2json => json2csv
我在这里和那里采取了一些部分,我将添加的参考,我实际上采取了所有的代码片段,我用于构建演示在这个答案的结尾。
这里有一个简单的演示:
function xmlTocsv(){var data = $(#xmlArea)。 var xml =; if(data!== null&& data.trim()。length!== 0){try {xml = $ .parseXML(data); } catch(e){throw e; } var x2js = new X2JS(); data = x2js.xml2json(xml); jsonTocsvbyjson(data); }} function jsonTocsvbyjson(data,returnFlag){arr = []; flag = true; var header =; var content =; var headFlag = true; try {var type1 = typeof data; if(type1!=object){data = processJSON($。parseJSON(data)); } else {data = processJSON(data); }} catch(e){if(returnFlag === undefined ||!returnFlag){console.error(Error in Convert to CSV); } else {console.error(Convert:Error in+ e); } return false; } $ .each(data,function(k,value){if(k%2 === 0){if(headFlag){if(value!=end){header + = value +,; else {//从字符串中删除最后一个冒号header = header.substring(0,header.length - 1); headFlag = false;}}} else {if(value!=end){var temp = data [ 1]; if(header.search(temp)!= -1){content + = value +,;}} else {//从字符串中删除最后一个冒号content = content.substring(0,content.length - 1 ); content + =\\\
;}}}); if(returnFlag === undefined ||!returnFlag){$(#csvArea)。val(header +\\\
+ content); } else {return(header +\\\
+ content); };}} function functionJSON(data){$ .each(data,function(k,data1){var type1 = typeof data1; if(type1 ==object){flag = false; processJSON(data1); arr.push end); arr.push(end);} else {arr.push(k,data1);}}); return arr;}
<!DOCTYPE html& html>< head>< script type ='text / javascript'src ='https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js'>< script>< script type ='text / javascript'src =https://cdn.rawgit.com/abdmob/x2js/master/xml2json.js>< / script>< script type =text / javascriptsrc =script.js>< / script>< / head>< body> < h1> XML2CSV Demo< / h1> < button id =convertToXmlBtnonclick =xmlTocsv()> XML => CSV< / button> < div> < h4> XML:< / h4> < textarea id =xmlAreacols =55rows =15>< / textarea> < / div> < div> < h4> CSV:< / h4> < textarea id =csvAreacols =55rows =15>< / textarea> < / div> < / body>< / html>
/ p>
实用工具:
I am looking for some help trying to convert XML retrieved from Amazon Product API to convert it into CSV(Comma Separated Value) format.
I found a similar topic here: XML to CSV conversion issue but it uses PHP, and I want to use javascript instead.
Here is a sample of what I have:
<?xml version="1.0" encoding="UTF-8"?>
<ItemLookupResponse xmlns="http://webservices.amazon.com/AWSECommerceService/2011-08-01">
<OperationRequest>
<RequestId>1k75f474-85ff-464a-al93-659ol460caee</RequestId>
<Arguments>
<Argument Name="Operation" Value="ItemLookup" />
<Argument Name="Service" Value="AWSECommerceService" />
<Argument Name="Signature" Value="lImNXr6R4c2t376ghMnMmjUPR4eY6755XzH41pXGH0P=" />
<Argument Name="AssociateTag" Value="oiuig-20" />
<Argument Name="ItemId" Value="B007EHI1DK" />
<Argument Name="AWSAccessKeyId" Value="DIY7F4M00OF6I7TRD3VA" />
<Argument Name="Timestamp" Value="2013-01-04T05:23:20Z" />
<Argument Name="ResponseGroup" Value="Large" />
</Arguments>
<RequestProcessingTime>0.0359500000000000</RequestProcessingTime>
</OperationRequest>
<Items>
<Request>
<IsValid>True</IsValid>
<ItemLookupRequest>
<IdType>ASIN</IdType>
<ItemId>B007EHI1DK</ItemId>
<ResponseGroup>Large</ResponseGroup>
<VariationPage>All</VariationPage>
</ItemLookupRequest>
</Request>
<Item>
<ASIN>B007EHI1DK</ASIN>
<DetailPageURL>http://www.amazon.com/Panasonic-TY-ER3D4MU-Active-Shutter-Eyewear/dp/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB007EHI1DK</DetailPageURL>
<ItemLinks>
<ItemLink>
<Description>Technical Details</Description>
<URL>http://www.amazon.com/Panasonic-TY-ER3D4MU-Active-Shutter-Eyewear/dp/tech-data/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK</URL>
</ItemLink>
<ItemLink>
<Description>Add To Baby Registry</Description>
<URL>http://www.amazon.com/gp/registry/baby/add-item.html%3Fasin.0%3DB007EHI1DK%26SubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK</URL>
</ItemLink>
<ItemLink>
<Description>Add To Wedding Registry</Description>
<URL>http://www.amazon.com/gp/registry/wedding/add-item.html%3Fasin.0%3DB007EHI1DK%26SubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK</URL>
</ItemLink>
<ItemLink>
<Description>Add To Wishlist</Description>
<URL>http://www.amazon.com/gp/registry/wishlist/add-item.html%3Fasin.0%3DB007EHI1DK%26SubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK</URL>
</ItemLink>
<ItemLink>
<Description>Tell A Friend</Description>
<URL>http://www.amazon.com/gp/pdp/taf/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK</URL>
</ItemLink>
<ItemLink>
<Description>All Customer Reviews</Description>
<URL>http://www.amazon.com/review/product/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK</URL>
</ItemLink>
<ItemLink>
<Description>All Offers</Description>
<URL>http://www.amazon.com/gp/offer-listing/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK</URL>
</ItemLink>
</ItemLinks>
<SmallImage>
<URL>http://ecx.images-amazon.com/images/I/31pKDguukTL._SL75_.jpg</URL>
<Height Units="pixels">50</Height>
<Width Units="pixels">75</Width>
</SmallImage>
<MediumImage>
<URL>http://ecx.images-amazon.com/images/I/31pKDguukTL._SL160_.jpg</URL>
<Height Units="pixels">107</Height>
<Width Units="pixels">160</Width>
</MediumImage>
<LargeImage>
<URL>http://ecx.images-amazon.com/images/I/31pKDguukTL.jpg</URL>
<Height Units="pixels">333</Height>
<Width Units="pixels">500</Width>
</LargeImage>
<ImageSets>
<ImageSet Category="primary">
<SwatchImage>
<URL>http://ecx.images-amazon.com/images/I/31pKDguukTL._SL30_.jpg</URL>
<Height Units="pixels">20</Height>
<Width Units="pixels">30</Width>
</SwatchImage>
<SmallImage>
<URL>http://ecx.images-amazon.com/images/I/31pKDguukTL._SL75_.jpg</URL>
<Height Units="pixels">50</Height>
<Width Units="pixels">75</Width>
</SmallImage>
<ThumbnailImage>
<URL>http://ecx.images-amazon.com/images/I/31pKDguukTL._SL75_.jpg</URL>
<Height Units="pixels">50</Height>
<Width Units="pixels">75</Width>
</ThumbnailImage>
<TinyImage>
<URL>http://ecx.images-amazon.com/images/I/31pKDguukTL._SL110_.jpg</URL>
<Height Units="pixels">73</Height>
<Width Units="pixels">110</Width>
</TinyImage>
<MediumImage>
<URL>http://ecx.images-amazon.com/images/I/31pKDguukTL._SL160_.jpg</URL>
<Height Units="pixels">107</Height>
<Width Units="pixels">160</Width>
</MediumImage>
<LargeImage>
<URL>http://ecx.images-amazon.com/images/I/31pKDguukTL.jpg</URL>
<Height Units="pixels">333</Height>
<Width Units="pixels">500</Width>
</LargeImage>
</ImageSet>
<ImageSet Category="variant">
<SwatchImage>
<URL>http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL30_.jpg</URL>
<Height Units="pixels">20</Height>
<Width Units="pixels">30</Width>
</SwatchImage>
<SmallImage>
<URL>http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL75_.jpg</URL>
<Height Units="pixels">50</Height>
<Width Units="pixels">75</Width>
</SmallImage>
<ThumbnailImage>
<URL>http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL75_.jpg</URL>
<Height Units="pixels">50</Height>
<Width Units="pixels">75</Width>
</ThumbnailImage>
<TinyImage>
<URL>http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL110_.jpg</URL>
<Height Units="pixels">73</Height>
<Width Units="pixels">110</Width>
</TinyImage>
<MediumImage>
<URL>http://ecx.images-amazon.com/images/I/31dSwH5PnjL._SL160_.jpg</URL>
<Height Units="pixels">107</Height>
<Width Units="pixels">160</Width>
</MediumImage>
<LargeImage>
<URL>http://ecx.images-amazon.com/images/I/31dSwH5PnjL.jpg</URL>
<Height Units="pixels">333</Height>
<Width Units="pixels">500</Width>
</LargeImage>
</ImageSet>
<ImageSet Category="variant">
<SwatchImage>
<URL>http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL30_.jpg</URL>
<Height Units="pixels">20</Height>
<Width Units="pixels">30</Width>
</SwatchImage>
<SmallImage>
<URL>http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL75_.jpg</URL>
<Height Units="pixels">50</Height>
<Width Units="pixels">75</Width>
</SmallImage>
<ThumbnailImage>
<URL>http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL75_.jpg</URL>
<Height Units="pixels">50</Height>
<Width Units="pixels">75</Width>
</ThumbnailImage>
<TinyImage>
<URL>http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL110_.jpg</URL>
<Height Units="pixels">73</Height>
<Width Units="pixels">110</Width>
</TinyImage>
<MediumImage>
<URL>http://ecx.images-amazon.com/images/I/31irEbzxdgL._SL160_.jpg</URL>
<Height Units="pixels">107</Height>
<Width Units="pixels">160</Width>
</MediumImage>
<LargeImage>
<URL>http://ecx.images-amazon.com/images/I/31irEbzxdgL.jpg</URL>
<Height Units="pixels">333</Height>
<Width Units="pixels">500</Width>
</LargeImage>
</ImageSet>
</ImageSets>
<ItemAttributes>
<Binding>Electronics</Binding>
<Brand>Panasonic</Brand>
<CatalogNumberList>
<CatalogNumberListElement>TYER3D4M</CatalogNumberListElement>
<CatalogNumberListElement>TYER3D4MU</CatalogNumberListElement>
<CatalogNumberListElement>TY-ER3D4MU</CatalogNumberListElement>
</CatalogNumberList>
<Color>One Color</Color>
<Department>Electronics</Department>
<EAN>0885170075207</EAN>
<EANList>
<EANListElement>0885170075207</EANListElement>
</EANList>
<Feature>Lightweight Active Shutter 3D Eyewear</Feature>
<Feature>USB Rechargeable</Feature>
<Feature>RF Compatible</Feature>
<IsAutographed>0</IsAutographed>
<IsMemorabilia>0</IsMemorabilia>
<ItemDimensions>
<Height Units="hundredths-inches">170</Height>
<Length Units="hundredths-inches">340</Length>
<Weight Units="hundredths-pounds">10</Weight>
<Width Units="hundredths-inches">670</Width>
</ItemDimensions>
<Label>Panasonic</Label>
<ListPrice>
<Amount>7995</Amount>
<CurrencyCode>USD</CurrencyCode>
<FormattedPrice>$79.95</FormattedPrice>
</ListPrice>
<Manufacturer>Panasonic</Manufacturer>
<Model>TY-ER3D4MU</Model>
<MPN>TY-ER3D4MU</MPN>
<NumberOfItems>1</NumberOfItems>
<PackageDimensions>
<Height Units="hundredths-inches">240</Height>
<Length Units="hundredths-inches">690</Length>
<Weight Units="hundredths-pounds">30</Weight>
<Width Units="hundredths-inches">350</Width>
</PackageDimensions>
<PackageQuantity>1</PackageQuantity>
<PartNumber>TY-ER3D4MU</PartNumber>
<ProductGroup>CE</ProductGroup>
<ProductTypeName>CONSUMER_ELECTRONICS</ProductTypeName>
<Publisher>Panasonic</Publisher>
<Size>One Size</Size>
<SKU>292782</SKU>
<Studio>Panasonic</Studio>
<Title>Panasonic VIERA TY-ER3D4MU Active Shutter 3D Eyewear</Title>
<UPC>885170075207</UPC>
<UPCList>
<UPCListElement>885170075207</UPCListElement>
</UPCList>
</ItemAttributes>
<OfferSummary>
<LowestNewPrice>
<Amount>5400</Amount>
<CurrencyCode>USD</CurrencyCode>
<FormattedPrice>$54.00</FormattedPrice>
</LowestNewPrice>
<LowestUsedPrice>
<Amount>4294</Amount>
<CurrencyCode>USD</CurrencyCode>
<FormattedPrice>$42.94</FormattedPrice>
</LowestUsedPrice>
<TotalNew>24</TotalNew>
<TotalUsed>18</TotalUsed>
<TotalCollectible>0</TotalCollectible>
<TotalRefurbished>0</TotalRefurbished>
</OfferSummary>
<Offers>
<TotalOffers>1</TotalOffers>
<TotalOfferPages>1</TotalOfferPages>
<MoreOffersUrl>http://www.amazon.com/gp/offer-listing/B007EHI1DK%3FSubscriptionId%3DIY7F4M00OF6I7TRD3VAS%26tag%3Daztag-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D386001%26creativeASIN%3DB007EHI1DK</MoreOffersUrl>
<Offer>
<OfferAttributes>
<Condition>New</Condition>
</OfferAttributes>
<OfferListing>
<OfferListingId>rkyW%2Bed7Qb8t28tJRRHkKizuk2CxNF4SI6W9XAnbXI8JX%2FJNpUY%2B8zqnnNRe3Vt2l%2B8rUMqypquQnAE66PYmf32dJeor6DifXvXKscwOqyrLwgFZORqmDg%3D%3D</OfferListingId>
<Price>
<Amount>5851</Amount>
<CurrencyCode>USD</CurrencyCode>
<FormattedPrice>$58.51</FormattedPrice>
</Price>
<AmountSaved>
<Amount>2144</Amount>
<CurrencyCode>USD</CurrencyCode>
<FormattedPrice>$21.44</FormattedPrice>
</AmountSaved>
<PercentageSaved>27</PercentageSaved>
<Availability>Usually ships in 24 hours</Availability>
<AvailabilityAttributes>
<AvailabilityType>now</AvailabilityType>
<MinimumHours>0</MinimumHours>
<MaximumHours>0</MaximumHours>
</AvailabilityAttributes>
<IsEligibleForSuperSaverShipping>1</IsEligibleForSuperSaverShipping>
</OfferListing>
</Offer>
</Offers>
<CustomerReviews>
<IFrameURL>http://www.amazon.com/reviews/iframe?akid=AKIAIBT3ANF6TOEOKXVA&alinkCode=xm2&asin=B007EHI1DK&atag=aztag-20&exp=2013-01-05T05%3A23%3A21Z&v=2&sig=yz1U1nT8mWjFGauK3umnsOqp9BTzWwGOAAiLCyZ%2BEPM%3D</IFrameURL>
<HasReviews>true</HasReviews>
</CustomerReviews>
<EditorialReviews>
<EditorialReview>
<Source>Product Description</Source>
<Content><strong>3D Playback Type:</strong> Active Shutter 3D Method<br /><strong>Transmittance Method:</strong> RF (Bluetooth)/ Full HD 3D Glasses Standard Compatible<br /><strong>Battery Type: </strong>Lithium-ion Polymer Rechargeable Battery<br /><strong>Battery Duration:</strong> Approximately 30 hours of operation for a 30-minute full battery charge (Approximately 3 hours of operation for a 2-minute battery charge)<em> *The battery duration will change as per the total usage time with the number of charge/discharge cycles </em><br /><strong>Package Included:</strong> 1 Pair of Eyewear <br />Note: These glasses are only compatible with 2012 VIERA HDTVs<br /><br /> <div style="text-align: left;"><strong>Accessory Compatibility Chart<br /></strong></div> <img height="375" src="http://g-ecx.images-amazon.com/images/G/01/electronics/Cat500/Panasonic/2012/accessory_compatibility_2._V138249826_.gif" width="650" /><br /><br /></Content>
<IsLinkSuppressed>0</IsLinkSuppressed>
</EditorialReview>
</EditorialReviews>
<SimilarProducts>
<SimilarProduct>
<ASIN>B007K9P7H0</ASIN>
<Title>Samsung SSG-4100GB 3D Active Glasses 2012 Models - Black</Title>
</SimilarProduct>
<SimilarProduct>
<ASIN>B00752VKSC</ASIN>
<Title>Panasonic VIERA TC-P55ST50 55-Inch 1080p 600Hz Full HD 3D Plasma TV</Title>
</SimilarProduct>
<SimilarProduct>
<ASIN>B00752R4PK</ASIN>
<Title>Panasonic DMP-BDT220 Integrated Wi-Fi 3D Blu-ray DVD Player</Title>
</SimilarProduct>
<SimilarProduct>
<ASIN>B00752VKFA</ASIN>
<Title>Panasonic VIERA TC-P55GT50 55-Inch 1080p 600Hz Full HD 3D Plasma TV</Title>
</SimilarProduct>
<SimilarProduct>
<ASIN>B00752VL8G</ASIN>
<Title>Panasonic VIERA TC-P60GT50 60-Inch 1080p 600Hz Full HD 3D Plasma TV</Title>
</SimilarProduct>
</SimilarProducts>
<BrowseNodes>
<BrowseNode>
<BrowseNodeId>3224438011</BrowseNodeId>
<Name>3D Glasses</Name>
<Ancestors>
<BrowseNode>
<BrowseNodeId>172532</BrowseNodeId>
<Name>Audio & Video Accessories</Name>
<Ancestors>
<BrowseNode>
<BrowseNodeId>281407</BrowseNodeId>
<Name>Accessories & Supplies</Name>
<Ancestors>
<BrowseNode>
<BrowseNodeId>493964</BrowseNodeId>
<Name>Categories</Name>
<IsCategoryRoot>1</IsCategoryRoot>
<Ancestors>
<BrowseNode>
<BrowseNodeId>172282</BrowseNodeId>
<Name>Electronics</Name>
</BrowseNode>
</Ancestors>
</BrowseNode>
</Ancestors>
</BrowseNode>
</Ancestors>
</BrowseNode>
</Ancestors>
</BrowseNode>
<BrowseNode>
<BrowseNodeId>1288264011</BrowseNodeId>
<Name>All product</Name>
<Ancestors>
<BrowseNode>
<BrowseNodeId>1267878011</BrowseNodeId>
<Name>Products</Name>
<IsCategoryRoot>1</IsCategoryRoot>
<Ancestors>
<BrowseNode>
<BrowseNodeId>1267877011</BrowseNodeId>
</BrowseNode>
</Ancestors>
</BrowseNode>
</Ancestors>
</BrowseNode>
<BrowseNode>
<BrowseNodeId>3545110011</BrowseNodeId>
<Name>Home Entertainment</Name>
<Children>
<BrowseNode>
<BrowseNodeId>3547652011</BrowseNodeId>
<Name>Blu-Ray Players</Name>
</BrowseNode>
<BrowseNode>
<BrowseNodeId>3547650011</BrowseNodeId>
<Name>DVD Players</Name>
</BrowseNode>
<BrowseNode>
<BrowseNodeId>6183878011</BrowseNodeId>
<Name>Home Theater Projectors</Name>
</BrowseNode>
<BrowseNode>
<BrowseNodeId>1294446011</BrowseNodeId>
<Name>Televisions</Name>
</BrowseNode>
<BrowseNode>
<BrowseNodeId>6183893011</BrowseNodeId>
<Name>Television Tuners and Receivers</Name>
</BrowseNode>
</Children>
<Ancestors>
<BrowseNode>
<BrowseNodeId>1294447011</BrowseNodeId>
<Name>Electronics</Name>
<Ancestors>
<BrowseNode>
<BrowseNodeId>1267878011</BrowseNodeId>
<Name>Products</Name>
<IsCategoryRoot>1</IsCategoryRoot>
<Ancestors>
<BrowseNode>
<BrowseNodeId>1267877011</BrowseNodeId>
</BrowseNode>
</Ancestors>
</BrowseNode>
</Ancestors>
</BrowseNode>
</Ancestors>
</BrowseNode>
<BrowseNode>
<BrowseNodeId>1293319011</BrowseNodeId>
<Name>Electronics</Name>
<Ancestors>
<BrowseNode>
<BrowseNodeId>1267879011</BrowseNodeId>
<Name>Special Features</Name>
<Ancestors>
<BrowseNode>
<BrowseNodeId>1267877011</BrowseNodeId>
</BrowseNode>
</Ancestors>
</BrowseNode>
</Ancestors>
</BrowseNode>
</BrowseNodes>
</Item>
</Items>
</ItemLookupResponse>
I am trying to format this data into a CSV formated table using Javascript.
Can someone please help?
Thanks in advance! Praney
After a long investigation i found out something that may help you.
Starting from the point that reinventing the wheel is such a stupid and time consuming task, i was looking for what other good programmers have already built out there on the internet.
Unfortunately I wasn't able to find out a direct converter form XML to CSV as the example you provide in PHP.
In my working example the XML have to pass from JSON first like this:
- xml2json => json2csv
I took some pieces here and there and i will add the references of where i actually took all the code snippet i use for build the demo at the end of this answer. In this way you will be able to get a nice and clean documentation that will help you to improve this tool.
Here a simple demo:
function xmlTocsv() {
var data = $("#xmlArea").val();
var xml = "";
if (data !== null && data.trim().length !== 0) {
try {
xml = $.parseXML(data);
} catch (e) {
throw e;
}
var x2js = new X2JS();
data = x2js.xml2json(xml);
jsonTocsvbyjson(data);
}
}
function jsonTocsvbyjson(data, returnFlag) {
arr = [];
flag = true;
var header = "";
var content = "";
var headFlag = true;
try {
var type1 = typeof data;
if (type1 != "object") {
data = processJSON($.parseJSON(data));
} else {
data = processJSON(data);
}
} catch (e) {
if (returnFlag === undefined || !returnFlag) {
console.error("Error in Convert to CSV");
} else {
console.error("Error in Convert :" + e);
}
return false;
}
$.each(data, function(k, value) {
if (k % 2 === 0) {
if (headFlag) {
if (value != "end") {
header += value + ",";
} else {
// remove last colon from string
header = header.substring(0, header.length - 1);
headFlag = false;
}
}
} else {
if (value != "end") {
var temp = data[k - 1];
if (header.search(temp) != -1) {
content += value + ",";
}
} else {
// remove last colon from string
content = content.substring(0, content.length - 1);
content += "\n";
}
}
});
if (returnFlag === undefined || !returnFlag) {
$("#csvArea").val(header + "\n" + content);
} else {
return (header + "\n" + content);
}
}
function processJSON(data) {
$.each(data, function(k, data1) {
var type1 = typeof data1;
if (type1 == "object") {
flag = false;
processJSON(data1);
arr.push("end");
arr.push("end");
} else {
arr.push(k, data1);
}
});
return arr;
}
<!DOCTYPE html>
<html>
<head>
<script type='text/javascript' src='https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js'></script>
<script type='text/javascript' src="https://cdn.rawgit.com/abdmob/x2js/master/xml2json.js"></script>
<script type="text/javascript" src="script.js"></script>
</head>
<body>
<h1>XML2CSV Demo</h1>
<button id="convertToXmlBtn" onclick="xmlTocsv()">XML => CSV</button>
<div>
<h4>XML:</h4>
<textarea id="xmlArea" cols="55" rows="15"></textarea>
</div>
<div>
<h4>CSV:</h4>
<textarea id="csvArea" cols="55" rows="15"></textarea>
</div>
</body>
</html>
References:
Utils:
这篇关于使用Javascript的XML到CSV转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!