Import a XML Data and output them

[Required]

Hi

I can get for a lot of money XML Data from a Company. So far so good.

The problem the Sub Categories are worse and the Information are just funny.

That mean the Data are get refreshed every Day what the told me.

I want to categorise something manually. After Import the Data a Script must run truth what make change every day.

I have no clue what is necessary for. I got just a Test File who show how the file should look like.

The Output will be for my Page who have to parse them and show the results.

[JohnDongus]

Send me a example of the input and the output and I can write up something in python real quick

 

[Required]

thx but i dont have many its just a sample.

I would like to have something like an "excel" style. The Problem is when I edit something that edit must be make automatically until the event is gone.

I will group many events my own when a or many specific Keywort is there. For example if "taxi" in the Title the must be in the "Taxi" Category.

The same when an Austrian Artist make the Event the must get in the right category. For that I will create a list with it.

[vorticalbox]

You should create a dictionary. Example in javascript

 

const data = {

    categories:{

        taxi:[],

        artists:[]

    }

}

 

To get the array of taxi you would get with data.categories.taxi

 

That will give you a nice simple structure of data, though you can create categories on the file as you parse your input and make it highly dynamic.

 

This is the sort of thing I do at work all the time but without examples of xml there is no way anyone can really help.