Reply to thread

Message

<blockquote data-quote="FlipGer" data-source="post: 28407" data-attributes="member: 10293">Hi,ok a progress report and some questions for the way to go. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />I am at a point where I have to choose between flexibility or data consistence.What have I done so far?1) I made a XML called TVGenreMapping.xml.[code]&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;genres&gt;&nbsp; &lt;genre name=&quot;Movie/Film&quot;&gt;&nbsp; &nbsp; &lt;mapping&gt;movie&lt;/mapping&gt;&nbsp; &nbsp; &lt;mapping&gt;film&lt;/mapping&gt;&nbsp; &lt;/genre&gt;&nbsp; &lt;genre name=&quot;Series&quot;&gt;&nbsp; &nbsp; &lt;mapping&gt;serie&lt;/mapping&gt;&nbsp; &lt;/genre&gt;&nbsp; &lt;genre name=&quot;Daily Soap&quot;&gt;&nbsp; &nbsp; &lt;mapping&gt;soap&lt;/mapping&gt;&nbsp; &lt;/genre&gt;&nbsp; &lt;genre name=&quot;Report/Documentary&quot;&gt;&nbsp; &nbsp; &lt;mapping&gt;report&lt;/mapping&gt;&nbsp; &nbsp; &lt;mapping&gt;documentary&lt;/mapping&gt;&nbsp; &lt;/genre&gt;&lt;/genres&gt;[/code]With this XML I map the main genres &quot;name&quot; with keywords. Eg. contains &quot;Spielfilm&quot; the keyword &quot;film&quot; and will be mapped to the genre &quot;Movie/Film&quot;. This is done on import and therefore before adding the genre to the TVdatabase!Cons:- The user will loose information. I can allready hear some people complaining, that they loose there beloved genre infos.Pros:- The genre table will be kept simple. I did have nearly 1000 genre entries, now I have &quot;only&quot; 10, what made the TVGuide much faster2) I made a XML file for the color mapping in the skins directory.[code]&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;profile&gt;&nbsp; &lt;section name=&quot;GenreColors&quot;&gt;&nbsp; &nbsp; &lt;entry name=&quot;Series&quot;&gt;#FF0000&lt;/entry&gt;&nbsp; &nbsp; &lt;entry name=&quot;Movie/Film&quot;&gt;#00FF00&lt;/entry&gt;&nbsp; &nbsp; &lt;entry name=&quot;Report/Documentary&quot;&gt;#0000FF&lt;/entry&gt;&nbsp; &nbsp; &lt;entry name=&quot;Dail Soap&quot;&gt;#00FFFF&lt;/entry&gt;&nbsp; &lt;/section&gt;&lt;/profile&gt;[/code]3) ToDo- Translation, user interface for changing colors and keywordsSo, here are some questions:1) What do you think about keeping the original genre infos somehow (database, etc.)?2) I am thinking about to merge these two files into one, to prevent data inconsistence. This could be done in two ways:a) Having one XML file in the main directory.- Pro: Maximum data consistence- Con: The colors can not be changed for each skinb) Having separate XML files in each skin directory.- Pro: The colors can be changed for each skin- Con: Possible data inconsistenceFlip</blockquote>

[QUOTE="FlipGer, post: 28407, member: 10293"] Hi, ok a progress report and some questions for the way to go. :) I am at a point where I have to choose between flexibility or data consistence. What have I done so far? [b]1) I made a XML called TVGenreMapping.xml.[/b] [code]<?xml version="1.0" encoding="utf-8"?> <genres> <genre name="Movie/Film"> <mapping>movie</mapping> <mapping>film</mapping> </genre> <genre name="Series"> <mapping>serie</mapping> </genre> <genre name="Daily Soap"> <mapping>soap</mapping> </genre> <genre name="Report/Documentary"> <mapping>report</mapping> <mapping>documentary</mapping> </genre> </genres>[/code] With this XML I map the main genres "name" with keywords. Eg. contains "Spielfilm" the keyword "film" and will be mapped to the genre "Movie/Film". This is done on import and therefore before adding the genre to the TVdatabase! Cons: - The user will loose information. I can allready hear some people complaining, that they loose there beloved genre infos. Pros: - The genre table will be kept simple. I did have nearly 1000 genre entries, now I have "only" 10, what made the TVGuide much faster [b]2) I made a XML file for the color mapping in the skins directory.[/b] [code]<?xml version="1.0" encoding="utf-8"?> <profile> <section name="GenreColors"> <entry name="Series">#FF0000</entry> <entry name="Movie/Film">#00FF00</entry> <entry name="Report/Documentary">#0000FF</entry> <entry name="Dail Soap">#00FFFF</entry> </section> </profile>[/code] [b]3) ToDo[/b] - Translation, user interface for changing colors and keywords [u][b]So, here are some questions:[/b][/u] 1) What do you think about keeping the original genre infos somehow (database, etc.)? 2) I am thinking about to merge these two files into one, to prevent data inconsistence. This could be done in two ways: a) Having one XML file in the main directory. - Pro: Maximum data consistence - Con: The colors can not be changed for each skin b) Having separate XML files in each skin directory. - Pro: The colors can be changed for each skin - Con: Possible data inconsistence Flip [/QUOTE]

Verification