You are here

Local MDB database

8 posts / 0 new
Last post
myraspxbmc
Offline
Joined: 8 years
Last seen: 6 years
Local MDB database

Is possible to write a MDB ini file for local database storage?

The idea is to have a “xml” file with some data to be parse from some programs, or a lot, something like:

Local database storage:

LocalDatabase.ini

LocalDatabase.xml

For search we can use title match…

Then in local database some fields:

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

<tv generator-info-name="WebGrab+Plus/w MDB &amp; REX Postprocess -- version V1.56.28 -- Jan van Straaten" generator-info-url="http://www.webgrabplus.com">

   <programme>

 <title lang="xx"> </title>

  <credits>

      <director>blah</director>

      <actor>a</actor>

      <actor>b</actor>

    </credits>

 < category ></ category >

    <video>

      <aspect>16:9</aspect>

    </video>

    <rating system="MPAA">

      <value>PG</value>

      <icon src="http://www.webgrabplus.com/pg_symbol.png" />

    </rating>

    <star-rating>

      <value>3/3</value>

    </star-rating>

  </programme>

</tv>

Will be cool…

 

 

myraspxbmc
Offline
Joined: 8 years
Last seen: 6 years

Great !!!

I will do some example database from 1 channel query.

Stay tune.. :)

myraspxbmc
Offline
Joined: 8 years
Last seen: 6 years

If I understand you right you mean something like this:

Please correct if I’m wrong… :)

Quote:

telenovelas.pt.ini

"todo do"
telenovelas.pt.xml:

<channel update="f" site="fixed" site_id="14:45-16:00##title:Laços de Sangue####" xmltv_id="Laços de Sangue">Laços de Sangue</channel>
<channel update="f" site="fixed" site_id="19:15-19:57##title:Sassaricando####" xmltv_id="Sassaricando">Sassaricando</channel>
<channel update="f" site="fixed" site_id="21:45-22:30##title:Amor Maior####" xmltv_id="Amor Maior">Amor Maior</channel>

database.xml:

<xmltv_id="Laços de Sangue">
 <title lang="pt">Laços de Sangue</title>
  <credits>
      <director>Pedro Lopes</director>
      <actor>Diana Chaves</actor>
      <actor>Joana Santos</actor>
    </credits>
 <category>Telenovela</category>
    <video>
    <aspect>16:9</aspect>
    </video>
    <rating system="PT">
      <value>12AP</value>
      <icon src="http://746506.skal.fun/local/12ap.png" />
    </rating>
    <star-rating>
      <value></value>
    </star-rating>
<imdb_id>
      <value>tt1700448</value>
</imdb_id>
</xmltv_id>

<xmltv_id="Amor Maior">
    <title lang="pt">Amor Maior</title>
<credits>
      <director>Inês Gomes</director>
      <actor>Sara Matos</actor>
      <actor>Catarina Rebelo</actor>
      <actor>Inês Castel-Branco</actor>
</credits>
    category>Telenovela</category>
<video>
    <aspect>16:9</aspect>
</video>
    <rating system="PT">
<value>12AP</value>
<icon src="http://746506.skal.fun/local/12ap.png" />
    </rating>
<star-rating>
    <value></value>
</star-rating>
<imdb_id>
      <value>tt5845202</value>
</imdb_id>
</xmltv_id>

<xmltv_id="Sassaricando">
    <title lang="pt">Sassaricando</title>
<credits>
      <director>Teresa Lampreia</director>
      <actor>Tatá Werneck</actor>
      <actor>Mariana Ximenes</actor>
      <actor>Agatha Moreira</actor>
</credits>
    category>Telenovela</category>
<video>
    <aspect>16:9</aspect>
</video>
    <rating system="PT">
<value>12AP</value>
<icon src="http://746506.skal.fun/local/12ap.png" />
    </rating>
<star-rating>
    <value></value>
</star-rating>
<imdb_id>
      <value>tt2362064</value>
</imdb_id>
</xmltv_id>

</tv>

myraspxbmc
Offline
Joined: 8 years
Last seen: 6 years

Yes these programs are form same channel in this case “SIC” from Portuguese TV.

I miss the time setting: “full day” LOL

Must study this well then do some real try….

If I understood the database fields are the fields from xmltv output, correct?

myraspxbmc
Offline
Joined: 8 years
Last seen: 6 years

I again thanks for your great help…

I’m doing this manually, basic the idea is add some programs that last from long time, to add info that normally don’t exist, and are always the same…

I will use your info on the post and then try to “fix” a sample from one channel, if all goes well I can try another and another until all EPG info where there :)

I will report later how things work :)

 

myraspxbmc
Offline
Joined: 8 years
Last seen: 6 years

Looks like this is not what I’m looking for if I understand correct the input of this...

Is very possible that I made myself not understand…

I do the test and give me this error:

Quote:

[Critical]    message: 
[Error   ] error in channel list of the config file!!
[Error   ]      duplicate xmltv_id value --  -- !!
[Error   ]      in :
[Error   ] <channel update="f" site="vodafone.pt" site_id="390" xmltv_id="SIC HD">SIC HD</channel>
[Error   ] <channel update="f" site="telenovelas.pt" site_id="14:45-16:00##title:Laços de Sangue####19:15-19:57##title:Sassaricando####21:45-22:30##title:Amor Maior####" xmltv_id="SIC HD">SIC HD</channel>
[Error   ] duplicate xmltv-id entries will mess-up the xmltv output!
[Error   ] ---- correct the channel-list to have unique xmltv-id values ---
[Critical] For detailed info, see log file WebGrab++.log.txt
[Critical] Execution stopped

Then I understand that fix is to add a new channel, without scrub it with full information likes his:

Quote:

  <programme start="20161117144500 +0000" stop="20161117160000 +0000" channel="SIC HD">
    <title lang="pt">Laços de Sangue</title>
    <desc lang="pt">A história gira em torno de duas irmãs, que há 25 anos, viram os seus destinos separados pela correnteza de um rio, tendo o pai salvo apenas a mais velha, Inês e morrido ao tentar salvar a outra, cujo corpo nunca chega a aparecer... até que se passam 25 anos(n)</desc>
    <icon src="http://746506.skal.fun/SIC%20HD_22207341/16_9/325/244" />
    <episode-num system="onscreen">E28</episode-num>
  </programme>

 

And the output I whant is something like this:

Quote:

  <programme start="20161117144500 +0000" stop="20161117160000 +0000" channel="SIC HD">
    <title lang="pt">Laços de Sangue</title>
    <desc lang="pt">A história gira em torno de duas irmãs, que há 25 anos, viram os seus destinos separados pela correnteza de um rio, tendo o pai salvo apenas a mais velha, Inês e morrido ao tentar salvar a outra, cujo corpo nunca chega a aparecer... até que se passam 25 anos(n)</desc>
    <icon src="http://746506.skal.fun/SIC%20HD_22207341/16_9/325/244" />
    <episode-num system="onscreen">E28</episode-num>
  <credits>
      <director>Pedro Lopes</director>
      <actor>Diana Chaves</actor>
      <actor>Joana Santos</actor>
    </credits>
 <category>Telenovela</category>
    <video>
    <aspect>16:9</aspect>
    </video>
    <rating system="PT">
      <value>12AP</value>
      <icon src="http://746506.skal.fun/12AP.png" />
    </rating>
    <star-rating>
      <value></value>
    </star-rating>
<imdb_id>
      <value>tt1700448</value>
</imdb_id>
  </programme>

Then if I think this correct, we can do a search using a file on MDB, something like you made with the fix ini?

If so by adding the ini file you made with some changes can we add this information to the output file?

Sorry for all that mess… But I still study this program and I’m not a coder…

One more time let me tell you, 

Thanks’ for your great help…

:)

 

 

myraspxbmc
Offline
Joined: 8 years
Last seen: 6 years

I like this new approach, you mention, I didn’t think this is possible, will try it.

Thanks

 

myraspxbmc
Offline
Joined: 8 years
Last seen: 6 years
Quote:

  <programme start="20161117144500 +0000" stop="20161117160000 +0000" channel="SIC HD">
    <title lang="pt">Laços de Sangue</title>
    <desc lang="pt">A história gira em torno de duas irmãs, que há 25 anos, viram os seus destinos separados pela correnteza de um rio, tendo o pai salvo apenas a mais velha, Inês e morrido ao tentar salvar a outra, cujo corpo nunca chega a aparecer... até que se passam 25 anos(n)</desc>
    <credits>
      <director>Pedro Lopes</director>
      <actor>Diana Chaves</actor>
      <actor>Joana Santos</actor>
    </credits>
    <category lang="pt">Telenovela</category>
    <icon src="http://746506.skal.fun/SIC%20HD_22207341/16_9/325/244" />
    <episode-num system="onscreen">E28</episode-num>
    <video>
      <aspect>16:9</aspect>
    </video>
    <rating system="Pt">
      <value>12AP</value>
      <icon src="http://746506.skal.fun/CPT-12AP.png" />
    </rating>
    <star-rating>
      <value>6/10</value>
    </star-rating>
  </programme>

 

Just perfect... :) :)

Log in or register to post comments

Brought to you by Jan van Straaten

Program Development - Jan van Straaten ------- Web design - Francis De Paemeleere
Supported by: servercare.nl