Reformats eBay's Feedbacks XML into a CSV format

ebay-feedback-to-csv.py

#!/usr/local/bin/python

import sys
import xml.etree.ElementTree as ET
tree = ET.parse(sys.stdin)
root = tree.getroot()

ns = { 'ebay' : 'urn:ebay:apis:eBLBaseComponents'}

def get_tag_data(element, tag_name):
	tag = element.find('ebay:' + tag_name, ns)
	if tag == None:
		return ''
	else:
		return tag.text


for feedback in root.findall(".//ebay:FeedbackDetail", ns):
	user = get_tag_data(feedback, 'CommentingUser')
	time = get_tag_data(feedback, 'CommentTime')
	item_id = get_tag_data(feedback, 'ItemID')
	transaction_id = get_tag_data(feedback, 'TransactionID')
	text = get_tag_data(feedback, 'CommentText')
	print user + ',' + time + "," + item_id + "," + transaction_id + ',' + '"' + text.encode('utf-8') + '"'