We need to be able to get out of our XML datas various statistic informations, analyse them, get results and create some graphics.
The data comes from the playlist of our TV channel. We have it in single XML files (one per day) and for monthly analysis we can maintain manually a folder with all daily XML files of a month.
We need to be able at any time, by analysing the data (single day or folder withj all files of the month) to know :
- how many events from a category or group of categories were played (column CATEGORY)
- inside this category or group of categories, how many events from the sub category (column DIRECTOR) were played, and how many events from each different directors
- how many times an artist (column CAST) or a title (column TITLE) or a producer (column PRODUCER) was played
+ simple display and graphics of the results obtained by those requests.
This can be made using already existing softwares properly set to our needs, or custom software or web based software...etc or with a small tool with GUI that will help us fire queries on the data, so we will be able to see results as data + graphics and cut & paste them.
Example of requests :
How many events were played from category MUSIC VIDEO HITS and category MUSIC VIDEO ESSENTIALS from each DIRECTOR
How many events were played from category MUSIC VIDEO HITS and category MUSIC VIDEO ESSENTIALS from DIRECTOR "SCPP CTV"
How many events were played from category MUSIC VIDEO HITS and category MUSIC VIDEO ESSENTIALS and CAST "DAVID VENDETTA"
you can find an example of XML file attached.
Décerné à :
7 freelance ont fait une offre moyenne de 181 $ pour ce travail
Hi, i can help you with this project. The solution will be desktop based application coded in C#. If interested please contact me, so i can start working on a demo. Thanks.