Skip to content

Thanks to this task, I have honed a multitude of skills, including Python programming, Data processing, XML handling, Error management, Library utilization, Problem-solving, and Testing.

Notifications You must be signed in to change notification settings

FuadRahimli/Optimizing-CSV-to-XML-Conversion-Script-in-Python-for-Oxygen-XML-Editor-Extracting-and-Transforming

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

I have developed a Python script based on the requirements specified by the product owner. The script is designed to process a CSV file containing a substantial dataset with more than 3000 rows. The goal is to convert all the data into a single XML file, presenting the information from each row in a specific style with designated tags.

It is imperative that the resulting XML file adheres to a common beginning, maintaining the prescribed format. Additionally, the order of columns in the CSV file must be rearranged in the XML file. To ensure compatibility with Oxygen XML Editor, the script has been developed with Oxygen's working principles in mind.

Addressing potential issues with error symbols present in the CSV file, I have implemented a systematic replacement approach to mitigate problems during XML file creation and operation in Oxygen. Specifically, the "xml.dom.minidom" library is utilized for XML file generation, and for enhanced performance in handling large XML documents, the script employs the "xml.etree.ElementTree" alternative library.

The script has been thoroughly tested and is executable in Visual Studio, demonstrating proper functionality in both Visual Studio and Oxygen XML Editor environments.

Achievements: Thanks to this task, I have honed a multitude of skills, including Python programming, Data processing, XML handling, Error management, Library utilization, Problem-solving, Automation, and Testing.

About

Thanks to this task, I have honed a multitude of skills, including Python programming, Data processing, XML handling, Error management, Library utilization, Problem-solving, and Testing.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages