Hello,

I want to create an XML file that would take this information from another XML file.

This is intended to keep only important information (remove unnecessary tags) and make the code more readable for a human (refactor of tag names)

The code in XML:

<?xml version="1.0"?>
<window name="INCO_VEHICAL_DETAIL" page="FIRST" page-id="001">
	<table name="_TEMPLATE3" style="SYSTEM">
		<tbody>
			<tr row="1">
				<tc cell="1">
					<text name="_TEXT11" style="SYSTEM" lang="EN">
					<p name="L">INCOTERM: <sym name="GV_INCOTERM">DAP/Dummy Location</sym></p>
					<p name="L">Vehicle Plate:<sym name="GV_VEHICAL_PLATE">TEST_VEHICLE</sym></p>
					<p name="L">Container ID :<sym name="GV_CONTAINER_ID">TEST_CONTAINER1</sym></p>
					<p name="L"/>
					</text>
				</tc>
				<tc cell="2">
					<text name="_TEXT12" style="SYSTEM" lang="EN">
					<p name="L">Seal No:<sym name="GV_SEAL_NO">TEST_SEAL_</sym></p>
					<p name="L">TARE Weight:<sym name="GV_TARE_WEIGHT">TES</sym></p>
					</text>
				</tc>
			</tr>
		</tbody>
	</table>
</window>

Et je voudrais obtenir ceci :

<?xml version="1.0"?>
<window name="INCO_VEHICAL_DETAIL" page="FIRST" page-id="001">
	<table name="_TEMPLATE3" style="SYSTEM">
		<text name="_TEXT11" style="SYSTEM" lang="EN">
		<sym name="GV_INCOTERM">DAP/Dummy Location</sym>
		<sym name="GV_VEHICAL_PLATE">TEST_VEHICLE</sym>
		<sym name="GV_CONTAINER_ID">TEST_CONTAINER1</sym>
		</text>
		<text name="_TEXT12" style="SYSTEM" lang="EN">
		<sym name="GV_SEAL_NO">TEST_SEAL_</sym>
		<sym name="GV_TARE_WEIGHT">TES</sym>
		</text>
	</table>
</window>

I started doing the python script below but I'm having a problem, if I want to delete an element (tag "p" for example) it will remove the child element (sym) that includes data. I think I would have to see the problem upside down and take my first xml file as the important data and not the entirety. I am a beginner in python and xml and I hang on for several days despite watching hours tutorials or forums ...

import lxml.etree as xmlParser
xmlDoc = xmlParser.parse('NewFile.xml')
rootElement = xmlDoc.getroot()


#refactor tag and delete attrib
for element in rootElement.iter('window'):
    element.tag = element.attrib['name']
    element.attrib.pop('name')
    element.attrib.pop('page')
    element.attrib.pop('page-id')
    
for element in rootElement.iter('table'):
    element.tag = element.attrib['name']
    element.attrib.pop('name')
    element.attrib.pop('style')    

for element in rootElement.iter('text'):
    element.tag = element.attrib['name']
    element.attrib.pop('name')
    element.attrib.pop('style')
    element.attrib.pop('lang')  
    
#for element in rootElement.iter('p'):
#    rootElement.remove(element)


for element in rootElement.iter('sym'):
    element.tag = element.attrib['name']
    element.attrib.pop('name')
    

xmlDoc.write('out.xml')

Which gives me as a result:

<INCO_VEHICAL_DETAIL>
	<_TEMPLATE3>
		<tbody>
			<tr row="1">
				<tc cell="1">
					<_TEXT11>
					<p name="L">INCOTERM: <GV_INCOTERM>DAP/Dummy Location</GV_INCOTERM></p>
					<p name="L">Vehicle Plate:<GV_VEHICAL_PLATE>TEST_VEHICLE</GV_VEHICAL_PLATE></p>
					<p name="L">Container ID :<GV_CONTAINER_ID>TEST_CONTAINER1</GV_CONTAINER_ID></p>
					<p name="L"/>
					</_TEXT11>
				</tc>
				<tc cell="2">
					<_TEXT12>
					<p name="L">Seal No:<GV_SEAL_NO>TEST_SEAL_</GV_SEAL_NO></p>
					<p name="L">TARE Weight:<GV_TARE_WEIGHT>TES</GV_TARE_WEIGHT></p>
					</_TEXT12>
				</tc>
			</tr>
		</tbody>
	</_TEMPLATE3>
</INCO_VEHICAL_DETAIL>

Do you have any ideas? Thanks in advance !!

-
Edité par Epyon9 19 juin 2019 à 15:07:53

Bonjour,

Mauvais forum

Le sujet est déplacé de la section Langage Python vers la section Let's talk!