XSL Transform template - Convert asymmetric and nested XML files to CSV using Python3
$30-250 USD
Paid on delivery
I would like 3 XSLT layouts generated, for use in Python.
These xsl files will be used to parse w/ ElementTree as follow: [login to view URL]([login to view URL]('[login to view URL]')) against my XML files and write out either a CSV file output or CSV List object and will be used for INSERT INTO database w pyodbc.
I have several sample XML files, with staggered and nested elements, and repeating elements.
The values needing to be extracted is the Text between the Field tags, set by the XML Attribute
For example:
<records>
<Field property="txtField1">output1</Field>
<Field property="txtField2">output2</Field>
<Field property="txtField3">output3</Field>
</records>
<records>
<Field property="txtField1">output1</Field>
<Field property="txtField2">output2</Field>
<Field property="txtField3">output3</Field>
<Field property="txtField4">output4</Field>
<Field property="txtField5">output5</Field>
</records>
I have tried using for-loops in Python, arrays, and lxml etree but I'm not getting a consistent output between 3 files and I have some more to process.
Please create 3 separate XSL files to capture layout to transform DataForm1, DataForm2 and DataForm3,
1- Include ID (at beginning of every file //FileBegin/FileData/ID)
2- Allow output to return blank ("") if there is a missing attribute in repeating
3a- 1st XSL file to capture layout of ID and FormData1 attributes
3b- 2nd XSL file to capture layout of ID and FormData2 attributes
3c- 3rd XSL file to capture layout of ID and FormData3 attributes
4- Write Output to List, for preparing INSERT INTO database (MS SQL or AccessDB)
5- XSL file must contain very good code comments, so that I can generalize it for any similar files.
Project ID: #29438602
About the project
11 freelancers are bidding on average $134 for this job
Hope you stay safe. As a Python developer, I am very interested in your project. As a senior Python developer, I am very familiar with Python and I mastered XSLT skills. You will be fully satisfied with my work. Ki More
hi i am a python developer and a machine learning engineer. i can do the transformation and satisfy all the requirements specified. contact me and we can discuss
XML-XSL expert for any transformation , filtering , data insert to DB , i am interested your task to complete perfectly
Hi, there. Sure, I am a python dev, and I ensure I can convert that. Please give me your chance. I look forward to hearing from you. Regards!
Dear client. I am very well experienced in xml/csv processing with python. Please ping me to discuss more, I am sure I will provide the perfect result today. Regards.
Hi, i am done work on XML parsing and your works look similar. What is understood from your description the XML for your XML file are uneven which is causing yiu the problem. i can help you build the code. ping me to More
