Đã hoàn thành

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.

Kĩ năng: Python, XML, XSLT, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 2 nhận xét ) new hope, United States

ID dự án: #29438602

Được trao cho:

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 Thêm

$100 USD trong 1 ngày
(39 Đánh Giá)
6.6

12 freelancer chào giá trung bình$131 cho công việc này

(331 Nhận xét)
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 Thêm

$100 USD trong 1 ngày
(18 Nhận xét)
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 trong 1 ngày
(26 Nhận xét)
5.2
tutulsoft

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

$180 USD trong 4 ngày
(24 Nhận xét)
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 Thêm

$140 USD trong 7 ngày
(3 Nhận xét)
4.5
ganeshrasekar

I can do it

$140 USD trong 7 ngày
(7 Nhận xét)
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 trong 1 ngày
(12 Nhận xét)
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 Thêm

$130 USD trong 7 ngày
(11 Nhận xét)
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 Thêm

$111 USD trong 7 ngày
(2 Nhận xét)
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 trong 7 ngày
(7 Nhận xét)
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 Thêm

$100 USD trong 1 ngày
(0 Nhận xét)
0.7