Preluare si modificare date din fisier xml

Salut, as vrea sa realizez un programel in care sa incarc un fisier xml, sa-mi arate valorile din cateva campuri iar in paralel sa am optiunea de a edita aceste campuri, apoi salvare fisier. Am incercat sa fac o schita. Precizez ca pot invata ceva mai simplu, gen vba, autohotkey. Catre ce limbaj ma sfatuiti sa ma indrept, eventual ceva detalii, sfaturi ?

Python
***
Pune aici un fisier demo

Edited by scub, 24 January 2024 - 06:37.

XMLul e mereu acelasi, are doar aceste campuri? (de regula, XML poate fi lung si sa contina multe date sau, in cazul tau, multe adrese)
Poti sa-l faci in orice aplicatie care stie sa foloseasca un fisier text, in functie de raspunsul tau si de cum e structurat fisierul (ca tot a cerut scub un exemplu), s-ar putea chiar si in Excel + Notepad.

Python & GPT  
Dar  merge  si  cu  notepad (Ctrl+H)

Edited by scub, 24 January 2024 - 09:40.

pare deja facut soft de genul asta : https://www.editix.c...s/xml_form.html

scub, on 24 ianuarie 2024 - 06:35, said:

Nu stiu daca e ok asa, nu ma lasa sa incarc fisierul...


<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<ie:FDF454C xmlns:ie="http://eee.eeeee.ee">
  <messageSender>eeee.RO</messageSender>
  <messageRecipient>eeee.RO</messageRecipient>
  <preparationDateAndTime>2024T23:30:22</preparationDateAndTime>
  <messageIdentification>1FEEF0FDR3RER2</messageIdentification>
  <messageType>FDF454C</messageType>
  <appVersion>FDFDDFDFDF</appVersion>
  <Operation>
    <ID>TEST1</ID>
    <Type>AO</Type>
    <additionalType>A</additionalType>
    <security>0</security>
  </Operation>
  <Location>
    <referenceNumber>ARAD02</referenceNumber>
  </Location>
  <Destination>
    <referenceNumber>SIBIU01</referenceNumber>
  </Destination>
  <Seller>
    <identificationNumber>6565665</identificationNumber>
  </Seller>
  <Transporter>
    <identificationNumber>545445</identificationNumber>
  </Transporter>
  <Representative>
    <identificationNumber>9883</identificationNumber>
    <status>2</status>
  </Representative>
  <GoodsShipment>
    <Transaction>1</Transaction>
    <countryOfOrigin>RO</countryOfOrigin>
    <countryOfSelling>ES</countryOfSelling>
    <DeliveryTerms>
  <incotermCode>CIP</incotermCode>
  <location>MADRID</location>
  <country>ES</country>
    </DeliveryTerms>
    <Consignment>
  <Indicator>0</Indicator>
  <ModeOfTransport>3</ModeOfTransport>
  <modeOfTransportAlternative>3</modeOfTransportAlternative>
  <grossMass>5600.000</grossMass>
  <Carrier>
    <identificationCode>656565665</identificationCode>
  </Carrier>
  <Consignee>
    <identificationNumber>22444554</identificationNumber>
  </Consignee>
  <ShipmentDetails>
    <sequenceNumber>1</sequenceNumber>
    <typeOfIdentification>01</typeOfIdentification>
    <identificationNumber>dsdasdasdasda</identificationNumber>
    <nationality>RO</nationality>
  </ShipmentDetails>
    </Consignment>
    <GoodsItem>
  <GoodsItemNumber>1</GoodsItemNumber>
  <finalValue>42017.20</finalValue>
  <Procedure>
    <requestedProcedure>10</requestedProcedure>
    <alternativeProcedure>99</alternativeProcedure>
  </Procedure>
  <Origin>
    <countryOfOrigin>RO</countryOfOrigin>
  </Origin>
  <GoodsType>
    <descriptionOfGoods>CUTII</descriptionOfGoods>
    <GoodsCode>
  <HeadingCode>123645</HeadingCode>
  <TypeCode>91</TypeCode>
    </GoodsCode>
    <GoodsMeasure>
  <grossMass>5600.000</grossMass>
  <netMass>5350.000</netMass>
  <supplementaryUnits>84</supplementaryUnits>
  <supplementaryCode>SDS</supplementaryCode>
    </GoodsMeasure>
  </GoodsType>
  <Packaging>
    <sequenceNumber>1</sequenceNumber>
    <typeOfPackages>BX</typeOfPackages>
    <numberOfPackages>84</numberOfPackages>
    <shippingMarks>SDDSA</shippingMarks>
  </Packaging>
  <EvaluationNoteItem>
    <finalValue>
  <currency>EUR</currency>
  <currencyrate>4.9432</currencyrate>
  <totalIn>1224</totalIn>
  <value>55455.0</value>
    </finalValue>
    <statValueCalc>42017.2</statValueCalc>
  </EvaluationNoteItem>
    </GoodsItem>
  </GoodsShipment>
</ie:FDF454C>

sorin147, on 24 ianuarie 2024 - 07:26, said:

Am pus mai sus continutul fisierului, un grup de date din el e posibil sa apara de mai multe ori, cu valori diferite.

Edited by geo741, 24 January 2024 - 11:40.

Ai incercat celelalte sugestii?

Nu am avut timp, trebuie sa ma documentez.

Vezi ca fisierul acela are mai multe probleme:
- preparationDateAndTime nu e format UTC
- nu toata nodurile au nume camelCase (unele incep cu litere mari)

Daca se poate le-as rezolva in locul tau.

radu103, on 24 ianuarie 2024 - 12:25, said:

Le-am mai modificat eu pentru a le afisa aici... Nu e nevoie, multumesc!

Cred ca rezolv cu ChatGPT, m-am cam imprietenit cu el si deja am scos o varianta in python, multumesc cui mi-a dat ideea !

Buna asta, merci !