Item_name = product.find('item_name').textįor child in product.findall('.//properties'): Kieslect Smart Tag Lite Pack (2 x Black and 1 x White) Black WhiteĬols = How to modify the code so that it can read the EAN as well? I would be grateful for a specific piece of code that I need to add. I would like to add that when I remove the EAN code, everything works without any problems. During conversion, he receives the error: 'AttributeError: 'NoneType' object has no attribute 'text''. Unfortunately, I have a problem with reading the EAN field. I won't provide any link here to comply with Peter Foti 's judicious remark - but if you key 'XML2CSV-Generic-Converter' in your favorite search engine you should find it easily.I'm using python code that converts my XML to a CSV file and reads specific fields like 'full_name', 'item_name', 'price', 'in_stock'. There might be other ones of course, and better ones certainly, but I couldn't pick any decent (free) one by myself.

So the answer to the last part of your question is: yes, there is at least one library which will help you achieve your goal, mine, which is named 'XML2CSV-Generic-Converter'. Public static void main(String args) throws Exception ). Here's a working example, data.xml has your data: import java.io.File

If I have a XML file of this format below and want to add the value of the InitgPty in the same row with MSgId (Pls note :InitgPty is in the next tag level, so it prints the value in the next row) The problem I have with that is I would need to specify specific elements in to code by name, but I want it to be able to parse it without doing that.Īre there any tools or libraries in java that would be able to help me achieve this. I was thinking of using a DOM parser to read the xml file. I need help understanding the steps involved in converting an XML file into a CSV file using java.Īnd here is the resulting CSV file.

Xml into csv