Converting the Clickbank Marketplace xml to csv
August 14th, 2007If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
Using the following xsl stylesheet and software like xmlpad, you can convert the Clickbank Marketplace xml into a tab delimited file. I choose tab delimited because the descriptions may have commas which would mess with an comma delimited choice.
 I finally came up with the stylesheet while trying to transform the xml file into an xml suitable for import into Filemaker. I came close, but think I am having issues with the elements that have cdata. But who knows Filemaker basically says your import is screwed and not much more information. And what you can find on the web is sparse.
But I imported the tab delimited file I created. That worked. Then I exported the table into the FMPXMLRESULT type xml file. My transforms looked the same except for the cdata. I will finally get it to work though.Tags: filemaker, xml, clickbank, xsl stylesheet, FMPXMLRESULT
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template match="/">
<xsl:for-each select="Catalog/Category">
<xsl:variable name="Cat" select="Name"/>
<xsl:for-each select="Site">
<xsl:value-of select="$Cat"/>
<xsl:text>	</xsl:text>
<xsl:copy-of select="Id"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="PopularityRank"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="Title"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="Description"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="Gravity"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="EarnedPerSale"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="PercentPerSale"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="TotalEarningsPerSale"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="TotalRebillAmt"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="Referred"/>
<xsl:text>	</xsl:text>
<xsl:value-of select="Commission"/>
<xsl:text>
</xsl:text>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
Category: 
| 
Me, Again,
Uh, wrote this too soon, in my excitement.
There’s only 10, 206 records.
It appears the stylesheet left out all the records with sub-categories, like Publishing and Industrial under Business to Business.
So it’s no good to me after all.
Found another program called xml2csv and it converts all30,000+ records, but does not put the category name on them.
Have you fixed this problem since you wrote this post?
Don
I figured out another way to work around this. But look at what I found yesterday at Clickbank:http://www.clickbank.com/affiliate_tools_cbads.html
There should at least be something in there to get started. I didn’t know Clickbank provided a example script that actually works.
[...] used to keep my head in the sand as an affiliate marketer. I did one thing. I promoted Clickbank products. Why? The high commission percentage. It’s a rush when a sale can get you anywhere [...]
[...] the result of your work. But once it hits the internet, it becomes data. What else is data? The Clickbank marketplace XML. Affiliate datafeeds. Your bookmarks. The list goes [...]
My friend on Orkut shared this link and I’m not dissapointed that I came to your blog.
Great stuff, could be very useful to analyze the Clickbank Marketplace.