Completed

XSL Transform template - Convert asymmetric and nested XML files to CSV using Python3

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.

Skills: Python, XML, XSLT, SQL

See more: convert html files xml files without losing data, convert xml files tables, convert xml files, convert common delimited files xml files, read xml files attributes using vbnet, convert xml files rtf files, convert psd files xml files, convert xml files webpage, transform xml files tables, java code convert csv xml files, convert rss files xml files, parsing xml files mysql using php, convert xml files rss, create xml files schema using vbnet 2003, merge xml files csv, convert xml files csv file, python nested xml to csv, java code to convert xml to csv using xsd, convert delimited text file to csv using python

About the Employer:
( 2 reviews ) new hope, United States

Project ID: #29438602

Awarded to:

ZhangDa

Nice to meet you on freelancer. I don't have experience with XSLT, but I did the project with XPath. Please see an example below: * [login to view URL]!AiiBtT-1najcg75xLQWj6QlJZFFzgQ?e=ZynnbN - From the screen you can More

$100 USD in 1 day
(39 Reviews)
6.6

12 freelancers are bidding on average $131 for this job

(331 Reviews)
7.4
CrazyProger

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

$100 USD in 1 day
(18 Reviews)
5.5
ashikmohann

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

$150 USD in 1 day
(26 Reviews)
5.2
tutulsoft

XML-XSL expert for any transformation , filtering , data insert to DB , i am interested your task to complete perfectly

$180 USD in 4 days
(24 Reviews)
5.1
AcaIl

***** Data processing Expert ***** Hello. Thanks for your job posting. I read your description carefully and understand your requirements sufficiently. I have developed lots of projects related to Data processing for c More

$140 USD in 7 days
(3 Reviews)
4.5
ganeshrasekar

I can do it

$140 USD in 7 days
(7 Reviews)
4.3
pguru2000

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.

$100 USD in 1 day
(12 Reviews)
4.3
borutflis

Hello there, I have dealt with several problems similar to this one. I am expert in parsing and in pandas, the library used to create and manipulate .csv file among other things. In the case the parsing libraries fai More

$130 USD in 7 days
(11 Reviews)
4.1
alokkeshri

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

$111 USD in 7 days
(2 Reviews)
3.5
Irfan0Farrel

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!

$200 USD in 7 days
(7 Reviews)
3.3
Wanngming

==== Able to start work right away ==== Hi, there I have read your job specification very carefully. I have over 6-years experiences in data processing in python. As a talented and skillful software developer, I am 10 More

$100 USD in 1 day
(0 Reviews)
0.7