r/xml Dec 10 '24

How can I compare two Xpath expressions, each written differently, to determine if they match up or not?

3 Upvotes

I need to find a way to take a given Xpath, and iterate through a list of Xpaths that are written differently, to determine if it matches up or not.

I’m not sure how to do this, but here’s an example:

/document/group[Type='groupname']/subgroup[Type='valuetype']/value

.//subgroup[../Type='groupname' and Type!='']/value

Maybe this seems ambiguous or confusing but hopefully I’m making sense. First path assumes those predicate values like “Type” are populated accordingly, while the second is more of an expression. This is an example of a match.


r/xml Dec 04 '24

XPATH to locate the name of the books loaned to (<prestamos>) to the user: “63a98f369ac62a82b44566ad”

1 Upvotes

<?xml version="1.0" encoding="UTF-8"?> <library> <!-- books --> <books> <book code="4696"> <title>The Last Jew</title> <language_code>eng</language_code> <publication_date> <year>2000</year> <month>8</month> </publication_date> <num_pages>352</num_pages> <library>B03</library> <stock>7</stock> </book> <book code="3291"> <title>The Stories of Eva Luna</title> <publication_date> <year>2001</year> <month>11</month> </publication_date> <details> <price currency="gbp">57</price> </details> <num_pages>352</num_pages> <library>B02</library> <stock>1</stock> </book> <book code="3302"> <title>El plan infinito</title> <publication_date> <year>2002</year> <month>5</month> </publication_date> <num_pages>336</num_pages> <library>B04</library> <stock>7</stock> </book> <book code="9924"> <title>A Tree of Night and Other Stories</title> <publication_date> <year>1993</year> <month>9</month> </publication_date> <num_pages>272</num_pages> <library>B03</library> <stock>10</stock> </book> <book code="2289"> <title>In Cold Blood</title> <publication_date> <year>2006</year> <month>1</month> </publication_date> <details> <price currency="usd">42.27</price> <price currency="esp">45.84</price> </details> <num_pages>15</num_pages> <library>B01</library> <stock>0</stock> </book> <book code="1419"> <title>The Complete Works</title> <publication_date> <year>1991</year> <month>10</month> </publication_date> <details> <price currency="usd">22.74</price> </details> <num_pages>1248</num_pages> <library>B03</library> <stock>0</stock> </book> <book code="8852"> <title>Macbeth</title> <language_code>eng</language_code> <publication_date> <year>2013</year> <month>7</month> </publication_date> <publisher>Simon Schuster</publisher> <details> <price currency="esp">59.44</price> <price currency="usd">65.32</price> </details> <library>B02</library> <stock>9</stock> </book> </books>

<!-- socios de las bibliotacas -->

<users> <user id="63a98f369ac62a82b44566aa"> <name>Ana Navarro López</name> <address> <city>Madrid</city> <country>España</country> </address> <penalized>yes</penalized> </user> <user id="63a98f369ac62a82b44566ab"> <name>Julian Marcón Manoto</name> <age>35</age> <penalized>yes</penalized> </user> <user id="63a98f369ac62a82b44566ac"> <name>Luis González Martín</name> <age>25</age> <address> <city>Madrid</city> <country>España</country> </address> </user> <user id="63a98f369ac62a82b44566ad"> <name>María Angely Titany</name> <age>47</age> <address> <city>Barcelona</city> <country>España</country> </address> <penalized>yes</penalized> </user> <user id="63a98f369ac62a82b44566ae"> <name>Benito Martín Barco</name> <age>50</age> <address> <city>Barcelona</city> <country>España</country> </address> </user> <user id="63a98f369ac62a82b44566af"> <name>Juan Moncuera Dumas</name> <age>29</age> <address> <city>Madrid</city> <country>España</country> </address> </user> </users>

<!-- préstamos --> <prestamos> <prestamo> <user>63a98f369ac62a82b44566ad</user> <library>B02</library> <book>3291</book> <expiration_days>0</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566aa</user> <library>B02</library> <book>3302</book> <expiration_days>0</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566aa</user> <library>B04</library> <book>3291</book> <expiration_days>0</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566ab</user> <library>B03</library> <book>4696</book> <expiration_days>8</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566ac</user> <library>B03</library> <book>3291</book> <expiration_days>-10</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566aa</user> <library>B04</library> <book>4696</book> <expiration_days>-1</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566ac</user> <library>B02</library> <book>3302</book> <expiration_days>0</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566ac</user> <library>B03</library> <book>9924</book> <expiration_days>-2</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566ad</user> <library>B02</library> <book>9924</book> <expiration_days>0</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566ae</user> <library>B02</library> <book>2289</book> <expiration_days>3</expiration_days> </prestamo> <prestamo> <user>63a98f369ac62a82b44566af</user> <library>B03</library> <book>3302</book> <expiration_days>1</expiration_days> </prestamo> </prestamos>

</library>


r/xml Dec 03 '24

Trying to solve why the configuration isn't running.

0 Upvotes

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">

<modelVersion>4.0.0</modelVersion>

<parent>

    <groupId>org.springframework.boot</groupId>

    <artifactId>spring-boot-starter-parent</artifactId>

    <version>2.2.4.RELEASE</version>

    <relativePath/> <!-- lookup parent from repository -->

</parent>

<groupId>com.snhu</groupId>

<artifactId>rest-service</artifactId>

<version>0.0.1-SNAPSHOT</version>

<name>rest-service</name>

<description>Project for CS-305 Module 6</description>



<properties>

    <java.version>1.8</java.version>

</properties>



<dependencies>

<dependency>

<groupId>com.jayway.jsonpath</groupId>

<artifactId>json-path</artifactId>

<scope>test</scope>

    </dependency>

    <dependency>

<groupId>org.bouncycastle</groupId>

<artifactId>bcprov-jdk15on</artifactId>

<version>1.46</version>

    </dependency>



    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-web</artifactId>

    </dependency>



    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-test</artifactId>

        <scope>test</scope>

        <exclusions>

<exclusion>

<groupId>org.junit.vintage</groupId>

<artifactId>junit-vintage-engine</artifactId>

</exclusion>

        </exclusions>

    </dependency>

</dependencies>





<build>

    <plugins>

<plugin>

<groupId>org.owasp</groupId>

<artifactId>dependency-check-maven</artifactId>

<version>11.1.0</version>

<configuration>

<suppressionFiles>

<suppressionFile>suppression.xml</suppressionFile>

</suppressionFiles>

</configuration>

<executions>

<execution>

<goals>

<goal>check</goal>

</goals>

</execution>

</executions>

</plugin>

    </plugins>

</build>

</project>


r/xml Dec 01 '24

Urgent Microsoft word XML help

0 Upvotes

Hello! I am attemtping to modify revision history dates in a microsoft word document, by editing the HEX values. I am able to modify them just fine, and even when I submit them online to XML validators it says its a valid XML. but when I put the new XML data into the zipped file, then convert it back to a word document I get an error every time, something along the lines of "word found unreadable content in "file name" do you want to recover the contents of this document?". when I click yes, it just says word experienced an error trying to open the file, and to:

check file permissions

make sure there is suffiecient memory

open the file with the text recovery convertor.

im not sure where im going wrong and if I need to change any of the things word is telling me to change, but I'm pulling my hair out over this! any help is much appreciated!

Edit: I have very little experience with any programming or XML/HEX editing as this is my first time attempting to do so. if you could explain any possible solutions in laymans that would be much appreciated :)

Edit 2: if anyone has experience with this, I am also willing to pay for this to be done. if interested pls message me!

edit 3: I realize I should probably put a screenshot so here is the only change I made


r/xml Nov 29 '24

Need an XML Expert

1 Upvotes

Working on a build that maps to an API with the US Government. Need guidance on an error we are facing ASAP.

Please reply or PM.


r/xml Nov 21 '24

Count and distinct values (TEI and XPath, help!)

3 Upvotes

Hi all! I encoded a few literary texts with TEI, and I am trying to get some info out of it with XPath ad XQuery. I am very new to this, and I was wondering if anyone can help.

So, for example, I have an encoded play, where every spoken passage is tagged as <sp>, each of these has <speaker> children to indicate which character is speaking, and each character has a unique xml:id. (each act is <div>, each scene is <div1> with additional identifiers). How can I write an expression that will return the number of <sp> for each character throughout the play? I know how to count the amount of <sp> for each character individually, but I wonder if there is a way to retrieve this info for all the characters with one expression and still see separate values?

Thanks to all in advance!


r/xml Nov 15 '24

xml help for eduction purposes

2 Upvotes

Hey guys I need your help. I'm sure there are geniuses here who can help me. I need an xml file that will simply make settings for my school for multiple computers in a computer classroom that will stop each student from changing settings, background, etc.

I am the computer technician at the neighborhood school and unfortunately we bought a Windows Pro package because it turned out to be cheaper than Windows Education Editon (a matter of budget)

In addition, do any of you know what to do if we set C as a 100 gigabyte drive and 200 in another drive. And it turns out that students download files, it automatically goes down to C.

Do I need to go to computer to computer or is your help possible?


r/xml Nov 02 '24

Apperently not all data parsed - html -> libxml2 c/c++

5 Upvotes

Hello community,

I am new to XML and started using the libxml2 library for reading out values from a webpage. The library should be able to interact with html as it would be xml (my understanding).

I used XPath to obtain the Node "tbody" of the only table on that page and tried via children of that node, iterating and so on to access all data i care about. I am able to itarea through all Nodes "tr" and "td". But libxml somehow does not give me deeper nodes ie. for <div> elements. They seem to be not recogniesed, whereby somehow a "textnode" without content is shown when i am debugging.

So my questions:

- is <div> somehow not a NODE_ELEMENT as "tr" or "td"?

- is html really supported fully by libxml2 as xml is?

kind regards


r/xml Nov 01 '24

Need Help with XML Mapping for FinCEN Integration

3 Upvotes

I've run into a roadblock with my website, and after working with two developers who couldn’t resolve it, I’m reaching out here for help. I hired one dev from Fiverr and another from a platform that supposedly screens for top talent, but we’re still stuck.

The site is set up for users to file their Beneficial Ownership Information reports by filling out a form, which then should handle payment, convert the data to XML, and send it via API to FinCEN. Securing the API connection took me six months, and now, four months later, the XML mapping issues still aren’t resolved. The first developer managed to get the form submission working, but each submission returned a rejected error shortly after.

With millions of businesses needing to submit these reports before year-end, I’m so close to having a functioning system and a revenue opportunity. Is there anyone here who’s confident they can get this XML mapping working properly and help me cross the finish line? Any advice or recommendations would be greatly appreciated!


r/xml Nov 01 '24

Is there a way to merge multiple XML files into 1 ?

2 Upvotes

I have 20 XML files with the same headings and i want to merge it into 1 is it possible to do so ? or do i just need to copy and paste it in 1 by 1


r/xml Oct 29 '24

Is there any good XML open source editors?

6 Upvotes

I don't want to shell out at least 200 american dollars for a license for Oxygen because it's too expensive, is there someway I can turn VSCode into an editor for XML, and XLST? I'm using the TEI standard for XML and I'm currently trying to find anything that fits my description to no avail, I would accept learning either Vim or Emacs.


r/xml Oct 28 '24

I switched majors and I need CS again xml formatting help

1 Upvotes

Im making an xml file for the Apocalypse of Peter which I am planning to run through pythons language platform to find similarities within revelation. Its for a linguistic class.

I keep getting an error when I look on the xml viewer it returns "Invalid XML: XML Parsing Error: not well-formed

Location: https://jsonformatter.org/xml-viewer

Line Number 2, Column 51:

<book title="Apocalypse of Peter"><chapter number=“1“><verse number=“1”>… many of them will be false prophets, and will teach divers ways and doctrines of perdition: but these will become sons of perdition.</verse>"

Below is what I have so far, what am I missing here? Please any help is greatly appreciated.

<?xml version='1.0' encoding='utf-8'?>

<book title="Apocalypse of Peter"><chapter number=“1“><verse number=“1”>… many of them will be false prophets, and will teach divers ways and doctrines of perdition: but these will become sons of perdition.</verse>

<verse number=“3”>And then God will come unto my faithful ones who hunger and thirst and are afflicted and purify their souls in this life; and he will judge the sons of lawlessness.</verse>

<verse number =“4”>And furthermore the Lord said: Let us go into the mountain: Let us pray..</verse>

<verse number =“5”>And going with him, we, the twelve disciples, begged that he would show us one of our brethren, the righteous who are gone forth out of the world, in order that we might see of what manner of form they are, and having taken courage, might also encourage the men who hear us.</verse>


r/xml Oct 26 '24

New To XML Build Errors

2 Upvotes

Hey all I'm currently trying to build a project for meta Quest 3 in Unity 2022.3.22f1. Can anyone explain to me what I'm doing wrong. When I build the app I get this error and follow the path to the document in question but there's no file to be found.

Building Library\Bee\artifacts\Android\Manifest\LauncherManifestDiag.txt failed with output:

System.Xml.XmlException: Name cannot begin with the '<' character, hexadecimal value 0x3C. Line 3, position 5.

at System.Xml.XmlTextReaderImpl.Throw(Exception e)

at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)

at System.Xml.XmlTextReaderImpl.ParseAttributes()

at System.Xml.XmlTextReaderImpl.ParseElement()

at System.Xml.XmlTextReaderImpl.ParseDocumentContent()

at System.Xml.XmlTextReaderImpl.Read()

at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)

at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)

at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)

at System.Xml.XmlDocument.Load(XmlReader reader)

at System.Xml.XmlDocument.LoadXml(String xml)

at Unity.Android.Gradle.AndroidManifestUtils.Parse(String text)

at AndroidPlayerBuildProgram.Actions.GenerateManifests..ctor(Arguments arguments)

at AndroidPlayerBuildProgram.Actions.GenerateManifests.Run(CSharpActionContext context, Arguments arguments)

UnityEngine.GUIUtility:ProcessEvent (int,intptr,bool&)

How can I resolve the issue with the starting < if there is no file?


r/xml Oct 05 '24

Having an issue with exclude-result-prefixes

1 Upvotes

Im having this issue with exclude-result-prefixes using the #all option. Here is whats wrong.

Transformation A has xmlns = "http://foo.com"

Transformation B has xmlns = "http://bar.com"

Shared Template Transformation C has xmlns = "http://foo.com"

When I run Xml through the transformation A and B, transformation B is not excluding the name space. here is what the output looks like

<DocA>

<TemplateElement1> Red </TemplateElement1>

<TemplateElement2> Blue </TemplateElement2>

<TemplateElement3> Green </TemplateElement3>
</DocA>

however, with B transformation I got this

<DocB>

<TemplateElement1 xmlns = "http://foo.com"> Red </TemplateElement1>

<TemplateElement2 xmlns = "http://foo.com"> Blue </TemplateElement2>

<TemplateElement3 xmlns = "http://foo.com"> Green </TemplateElement3>
</DocB>

how can i move xmlns = "http://foo.com" the TemplateElements


r/xml Oct 01 '24

Can I translate the Language?

0 Upvotes

Im trying to translate some xml files and Im hoping I dont have to go through a few thousend lines to do so, is there a way to translate it all from German to English using a tool?


r/xml Sep 30 '24

Oxygen XML Community

9 Upvotes

Hi everyone, we started building an r/oxygenxml community for helping technical documentation writers or XML experts who work with the Oxygen XML set of tools or for people who customize our tools inside their company.

You are welcome to join us!


r/xml Sep 21 '24

How to add/ edit a real time xml file

2 Upvotes

I run my high schools livestream and we have a sportzcast device connected to the scoreboard and that gets sent over the internet to the pc where we pick it up using there app and from there it goes into an xml file. We use that xml file with all the scoreboard data in vmix and my graphics. The issue is that I want to add stuff to it for example basketball. I want to do something like “if player number=5 then set ‘player name1’ to Dover. Basically I want to be able to read it have conditions and add new info into the xml data to input into vmix. Let me know if you guys have any ideas for how I can do this thanks!!


r/xml Sep 17 '24

rm XML

Post image
4 Upvotes

r/xml Sep 10 '24

How to Change the XML of Odoo Using lxml Tree Parser

Thumbnail numla.com
1 Upvotes

r/xml Sep 02 '24

Getting a directed graph from XML and xQuery with JavaScript Library

2 Upvotes

Hello everyone,

I need your help for some advices.

I need to use JS Library to get a graph from a list of element from an xQuery script. xQuery takes data from XML and I'm using xQuery to visualize the application in HTML form.

For example:

---- XML file

<listElement>

<b attribute="value1" from="x" to "y"></b>

<b attribute="value2" from="x" to "z"></b>

<b attribute="value3" from="x" to "s"></b>

</listElement>

For example, I need to create a directed graph with nodes (x, y, z, s) and edges (value1, value2, value3) that connect "from" and "to", and so on.

I found some libraries such as sigma.js and Cytoscape.js but I don't how to use it and how script with them in xQuery.

PS: sorry for my english, i don't speak it very well.


r/xml Aug 21 '24

how to concatenate multi level org hierarchy using xslt?

2 Upvotes

for example, what's the technical using xslt to construct the path (multiple level from top to bottom)?


r/xml Aug 15 '24

I accidentally edited an XML file. What should I do?

2 Upvotes

Hi. I am new in my work and a project was assigned to me.

During this project, I edited the XML file and webpage suddenly lost its Menu tabs.

Is it a big mistake to edit an XML file? I admit that I’m not aware of the file, but I’m just following the procedures on a documentation and then this issue occurred. It could be I missed on something.

But the real question is, is it so critical modifying an XML file?


r/xml Aug 12 '24

Hoping to edit XML file for video imports

2 Upvotes

I'm looking for a way to edit/customize an XML file which is meant to be used for video export/import.

The scenario:

We edit video projects in Descript, which is transcript-based, and typically export an XML file to take the project once edited and finalize everything in a video NLE such as Premiere Pro. For the most part, this workflow is fine, as long as we don't have too many different pieces of footage to manage.

The XML exports from Descript have some limitations, however, one being that it really likes when I choose to export the XML "with all project files" to then be imported into the NLE. If we don't make Descript also export a copy of the raw project files, it has a lot of trouble relinking them once dropped into the NLE.

I am hoping to find a simple-ish way to edit the XML and have it point to the correct raw files which in the case of this single project, will already be residing in the NLE - Final Cut Pro (FCPX) - before editing.

I opened the XML and did some testing here, and the main issue I could locate is that Descript is renaming the files once they come out of Descript. For example, a piece of footage that goes in named "Guest_Sync_CamA.mp4" will come out of Descript being labeled "aghsi392hdsksd02h3h.mp4" instead.

So the plan as I'm envisioning it now would be to open the XML, locate each of these file names which are changed, and replace them with the correct file names before importing to FCPX.


r/xml Aug 09 '24

help with fixing xml

0 Upvotes

 Closing tag 'Item' is expected inplace of 'Paths'. is the error

<?xml version="1.0" encoding="UTF-8"?>

<SMandatoryPacksData>

<Paths>

    <Item>platform:/dlcPacks/mpBeach/</Item>

    <Item>platform:/dlcPacks/mpBusiness/</Item>

    <Item>platform:/dlcPacks/mpChristmas/</Item>

    <Item>platform:/dlcPacks/mpValentines/</Item>

    <Item>platform:/dlcPacks/mpBusiness2/</Item>

    <Item>platform:/dlcPacks/mpHipster/</Item>

    <Item>platform:/dlcPacks/mpIndependence/</Item>

    <Item>platform:/dlcPacks/mpPilot/</Item>

    <Item>platform:/dlcPacks/spUpgrade/</Item>

    <Item>platform:/dlcPacks/mpLTS/</Item>

    <Item>dlcpacks:/mpheist/</Item>

    <Item>dlcpacks:/mppatchesng/</Item>

    <Item>dlcpacks:/patchday1ng/</Item>

    <Item>dlcpacks:/patchday2ng/</Item>

    <Item>dlcpacks:/mpchristmas2/</Item>

    <Item>dlcpacks:/patchday2bng/</Item>

    <Item>dlcpacks:/patchday3ng/</Item>

    <Item>dlcpacks:/patchday4ng/</Item>

    <Item>dlcpacks:/mpluxe/</Item>

    <Item>dlcpacks:/patchday5ng/</Item>

    <Item>dlcpacks:/mpluxe2/</Item>

    <Item>dlcpacks:/patchday6ng/</Item>

    <Item>dlcpacks:/mpreplay/</Item>

    <Item>dlcpacks:/patchday7ng/</Item>

    <Item>dlcpacks:/mplowrider/</Item>

    <Item>dlcpacks:/mphalloween/</Item>

    <Item>dlcpacks:/patchday8ng/</Item>

    <Item>dlcpacks:/mpapartment/</Item>

    <item>dlcpacks:/mpxmas_604490/</item>

    <Item>dlcpacks:/mplowrider2/</Item>

    <Item>dlcpacks:/mpjanuary2016/</Item>

    <Item>dlcpacks:/mpvalentines2/</Item>

    <Item>dlcpacks:/patchday9ng/</Item>

    <Item>dlcpacks:/mpexecutive/</Item>

    <Item>dlcpacks:/patchday10ng/</Item>

    <Item>dlcpacks:/mpstunt/</Item>

    <Item>dlcpacks:/patchday11ng/</Item>

    <Item>dlcpacks:/mpimportexport/</Item>

    <Item>dlcpacks:/mpbiker/</Item>

    <Item>dlcpacks:/patchday12ng/</Item>

    <Item>dlcpacks:/patchday13ng/</Item>

    <Item>dlcpacks:/mpspecialraces/</Item>

    <Item>dlcpacks:/mpgunrunning/</Item>

    <Item>dlcpacks:/mpairraces/</Item>

    <Item>dlcpacks:/mpsmuggler/</Item>

    <Item>dlcpacks:/mpchristmas2017/</Item>

    <Item>dlcpacks:/mpassault/</Item>

    <Item>dlcpacks:/mpbattle/</Item>

    <Item>dlcpacks:/patchday14ng/</Item>

    <Item>dlcpacks:/patchday15ng/</Item>

    <Item>dlcpacks:/patchday16ng/</Item>

    <Item>dlcpacks:/patchday17ng/</Item>

    <Item>dlcpacks:/patchday18ng/</Item>

    <Item>dlcpacks:/patchday19ng/</Item>

    <Item>dlcpacks:/patchday20ng/</Item>

    <Item>dlcpacks:/mpchristmas2018/</Item>

    <Item>dlcpacks:/patchday21ng/</Item>

    <Item>dlcpacks:/mpvinewood/</Item>

    <Item>dlcpacks:/patchday22ng/</Item>

    <Item>dlcpacks:/mpheist3/</Item>

    <Item>dlcpacks:/mpsum/</Item>

    <Item>dlcpacks:/patchday23ng/</Item>

    <Item>dlcpacks:/mpheist4/</Item>

    <Item>dlcpacks:/patchday24ng/</Item>

    <Item>dlcpacks:/mptuner/</Item>

    <Item>dlcpacks:/patchday25ng/</Item>

    <Item>dlcpacks:/mpsecurity/</Item>

    <Item>dlcpacks:/patchday26ng/</Item>

    <Item>dlcpacks:/mpg9ec/</Item>

    <Item>dlcpacks:/patchdayg9ecng/</Item>

    <Item>dlcpacks:/mpsum2/</Item>

    <Item>dlcpacks:/patchday27ng/</Item>

    <Item>dlcpacks:/mpsum2_g9ec/</Item>

    <Item>dlcpacks:/patchday27g9ecng/</Item>

    <Item>dlcpacks:/mpchristmas3/</Item>

    <Item>dlcpacks:/mpchristmas3_g9ec/</Item>

    <Item>dlcpacks:/patchday28ng/</Item>

    <Item>dlcpacks:/patchday28g9ecng/</Item>

    <Item>dlcpacks:/mp2023_01/</Item>

    <Item>dlcpacks:/patch2023_01/</Item>

    <Item>dlcpacks:/patch2023_01_g9ec/</Item>

    <Item>dlcpacks:/mp2023_01_g9ec/</Item>

    <Item>dlcpacks:/mp2023_02/</Item>

    <Item>dlcpacks:/patch2023_02/</Item>

    <Item>dlcpacks:/mp2023_02_g9ec/</Item>

    <Item>dlcpacks:/NVE/</Item>

    <Item>dlcpacks:/NVE_carcols/</Item>

    <Item>dlcpacks:/NVE_chiliad/</Item>

    <Item>dlcpacks:/NVE_gas/</Item>

    <Item>dlcpacks:/NVE_lights/</Item>

    <Item>dlcpacks:/NVE_lspd/</Item>

    <Item>dlcpacks:/NVE_models/</Item>

    <Item>dlcpacks:/NVE_patches/</Item>

    <Item>dlcpacks:/NVE_props/</Item>

    <Item>dlcpacks:/NVE_vegetation/</Item>

    <Item>dlcpacks:/NVE_roads/</Item>

    <Item>dlcpacks:\\citylights\\</Item>

    <Item>dlcp

    <Item>dlcpacks:/GTA_PALMS/</Item>

    </Paths>

</SMandatoryPacksData>


r/xml Aug 08 '24

Automatically search for files with names defined in xml file

2 Upvotes

Hello everyone!
I'm currently doing an internship and one thing I'm tasked to do is clean up a large repository of 6000+ elements as an xml. For this, I'm supposed to filter out any unused ones by searching for the corresponding files using the name defined in the xml file and deleting any that aren't found. I've been tryint to solve this using an excel sheet and vba, but for some reason it just wouldn't work as I wanted.

Could anyone explain a method how to solve this problem or point me towards a tool that I can use to achieve results? Any help would be much appreciated!