G
gjm
Guest
Bonjour ,
Le fichier "RadiodataBase4.db3" se trouve dans : C:\Program Files\Team MediaPortal\MediaPortal\database .
1) Faire une copie de sauvegarde "RadiodataBase4.db3.ori" .
2) La structure des futures infos , à importer est du style :
---
BEGIN TRANSACTION;
CREATE TABLE station ( idChannel integer primary key, strName text, iChannelNr integer, frequency text, URL text, genre text, bitrate integer, scrambled integer);
INSERT INTO station VALUES(1,'radio yy',0,0,'unknown','xxxx',0,0);
CREATE TABLE tblATSCMapping ( idChannel integer, strChannel text, strProvider text, frequency text, symbolrate integer, innerFec integer, modulation integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer, channelNumber integer, minorChannel integer, majorChannel integer);
CREATE TABLE tblChannelCard( idChannelCard integer primary key, idChannel integer, card integer);
CREATE TABLE tblDVBCMapping ( idChannel integer, strChannel text, strProvider text, frequency text, symbolrate integer, innerFec integer, modulation integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer);
CREATE TABLE tblDVBSMapping ( idChannel integer,sPCRPid integer,sTSID integer,sFreq integer,sSymbrate integer,sFEC integer,sLNBKhz integer,sDiseqc integer,sProgramNumber integer,sServiceType integer,sProviderName text,sChannelName text,sEitSched integer,sEitPreFol integer,sAudioPid integer,sVideoPid integer,sAC3Pid integer,sAudio1Pid integer,sAudio2Pid integer,sAudio3Pid integer,sTeletextPid integer,sScrambled integer,sPol integer,sLNBFreq integer,sNetworkID integer,sAudioLang text,sAudioLang1 text,sAudioLang2 text,sAudioLang3 text,sECMPid integer,sPMTPid integer);
CREATE TABLE tblDVBTMapping ( idChannel integer, strChannel text, strProvider text, frequency text, bandwidth integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer);
CREATE INDEX idxStation ON station(idChannel);
COMMIT;
---
Les données pour chaque radio seront mises sur une ligne séparée ; exemple :
INSERT INTO station VALUES(1,'radio yy',0,0,'Url 1','ce qu'il vous plait',0,0);
INSERT INTO station VALUES(2,'radio zz',1,0,'Url 2','ce qu'il vous plait',0,0);
Elles doivent correspondre aux éléments ci-après :
(idChannel integer primary key, strName text, iChannelNr integer, frequency text, URL text, genre text, bitrate integer, scrambled integer)
= = = =
NB1 : J'ai stocké tous mes fichiers .asx dans le répertoire :
C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb
NB2 : Dans les noms , ne pas utiliser : é,è,à,ç,etc . Sinon vous aurez des PBs .
= = = =
3) Ci-dessous le détail d'un fichier que nous appellerons "DataListe.sql"
à placer dans : C:\Program Files\Team MediaPortal\MediaPortal\database .
A FINALISER au niveau de 5 stations (a voir) et BeurFM .
Il n'y a (presque) que des flux français , d'autres (étrangers) seront à venir .
--------- Début ---------
BEGIN TRANSACTION;
CREATE TABLE station ( idChannel integer primary key, strName text, iChannelNr integer, frequency text, URL text, genre text, bitrate integer, scrambled integer);
INSERT INTO station VALUES(1,'Alouette',0,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Alouette.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(2,'Alpes1G',1,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Alpes1G.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(3,'Arl',2,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Arl.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(4,'Basqueradio',3,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Basqueradio.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(5,'BeurFM',4,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\BeurFM.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(6,'BFM',5,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\BFM.asx','Mono-22Khz',18,0);
INSERT INTO station VALUES(7,'BlackBox',6,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\BlackBox.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(8,'CatalogneNord',7,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\CatalogneNord.asx','Mono-32Khz',22,0);
INSERT INTO station VALUES(9,'CentPourCent',8,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\CentPourCent.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(10,'ChérieFM',9,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\ChérieFM.asx','Stéréo-44Khz',130,0);
INSERT INTO station VALUES(11,'CocktailFM',10,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\CocktailFM.asx','Stéréo-44Khz',48,0);
INSERT INTO station VALUES(12,'CollinesFM',11,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\CollinesFM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(13,'ECN',12,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\ECN.asx','Mono-44Khz',32,0);
INSERT INTO station VALUES(14,'EspaceFM',13,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\EspaceFM.asx','Stéréo-32Khz',32,0);
INSERT INTO station VALUES(15,'Europe1',14,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Europe1.asx','Stéréo-32Khz',34,0);
INSERT INTO station VALUES(16,'Europe2',15,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Europe2.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(17,'EvasionFM',16,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\EvasionFM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(18,'FCradio',17,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FCradio.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(19,'FIP',18,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FIP.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(20,'FMPlus',19,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FMPlus.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(21,'Forum',20,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Forum.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(22,'FranceBleu',21,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FranceBleu.asx','Mono-32Khz',22,0);
INSERT INTO station VALUES(23,'FranceInfo',22,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FranceInfo.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(24,'FranceInter',23,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FranceInter.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(25,'FranceMusiques',24,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FranceMusiques.asx','Stéréo-44Khz',64,0);
INSERT INTO station VALUES(26,'FrequenceHorizon',25,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FrequenceHorizon.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(27,'FrequencePlus',26,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FrequencePlus.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(28,'FunRadio',27,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FunRadio.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(29,'Generation',28,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Generations.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(30,'Hit & Sport',29,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Hit & Sport.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(31,'Hot Radio',30,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Hot Radio.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(32,'Impact Fm',31,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Impact Fm.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(33,'Jerico',32,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Jerico.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(34,'Jordanne FM',33,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Jordanne FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(35,'LaGrosseRadio',34,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\LaGrosseRadio.asx','Stéréo-44Khz',192,0);
INSERT INTO station VALUES(36,'LeMouv',35,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\LeMouv.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(37,'LittoralFM',36,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\LittoralFM.asx','Stéréo-44Khz',64,0);
INSERT INTO station VALUES(38,'LorFM',37,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\LorFM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(39,'Lyon1ère',38,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Lyon1ère.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(40,'MagicRadio',39,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\MagicRadio.asx','Stéréo-44Khz',192,0);
INSERT INTO station VALUES(41,'MagnumLaRadio',40,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\MagnumLaRadio.asx','Stéréo-44Khz',64,0);
INSERT INTO station VALUES(42,'MCOne',41,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\MCOne.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(43,'MistralFM',42,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\MistralFM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(44,'Mix24',43,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Mix24.asx','Mono-22Khz',24,0);
INSERT INTO station VALUES(45,'Montagne FM',44,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Montagne FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(46,'Music plus Movie',45,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Music plus Movie.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(47,'Normandie FM',46,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Normandie FM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(48,'Nostalgie',47,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Nostalgie.asx','Stéréo-44Khz',130,0);
INSERT INTO station VALUES(49,'NRJ',48,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\NRJ.asx','Stéréo-44Khz',130,0);
INSERT INTO station VALUES(50,'Océane FM',49,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Océane FM.asx','Stéréo-32Khz',32,0);
INSERT INTO station VALUES(51,'ODS Radio',50,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\ODS Radio.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(52,'PULS radio',51,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\PULS radio.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(53,'Radio 6',52,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio 6.asx','Mono-44Khz',32,0);
INSERT INTO station VALUES(54,'Radio 8',53,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio 8.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(55,'Radio ABF',54,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio ABF.asx','à voir',0,0);
INSERT INTO station VALUES(56,'Radio Caroline',55,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Caroline.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(57,'Radio Classique',56,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Classique.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(58,'Radio Courtoisie',57,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Courtoisie.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(59,'Radio Cote d_Amour',58,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Cote d_Amour.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(60,'Radio Espace',59,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Espace.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(61,'Radio Espoir',60,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Espoir.asx','Stéréo-32Khz',40,0);
INSERT INTO station VALUES(62,'Radio Kol Hachalom',61,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Kol Hachalom.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(63,'Radio Maria',62,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Maria.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(64,'Radio Maritima',63,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Maritima.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(65,'Radio Mega',64,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Mega.asx','à voir',0,0);
INSERT INTO station VALUES(66,'Radio Mon Pais',65,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Mon Pais.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(67,'Radio Mont-Blanc',66,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Mont-Blanc.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(68,'Radio Montluçon Bourbonnais',67,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Montluçon Bourbonnais.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(69,'Radio Narbonne Méditerranée',68,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Narbonne Méditerranée.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(70,'Radio Nohain',69,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Nohain.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(71,'Radio Océan',70,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Océan.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(72,'Radio Orient',71,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Orient.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(73,'Radio Scoop',72,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Scoop.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(74,'Radio Soleil Paris',73,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Soleil Paris.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(75,'Radio Star Marseille',74,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Star Marseille.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(76,'Radio Teentaal',75,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Teentaal.asx','à voir',0,0);
INSERT INTO station VALUES(77,'Radio Totem',76,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Totem.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(78,'Radio Vie Meilleure',77,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Vie Meilleure.asx','Mono-16Khz',20,0);
INSERT INTO station VALUES(79,'RDL',78,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RDL.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(80,'RFI',79,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RFI.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(81,'RFM',80,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RFM.asx','à voir',0,0);
INSERT INTO station VALUES(82,'Rire et Chansons',81,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Rire et Chansons.asx','Stéréo-44Khz',130,0);
INSERT INTO station VALUES(83,'RMC Moyen Orient',82,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RMC Moyen Orient.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(84,'RMC',83,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RMC.asx','Mono-22Khz',18,0);
INSERT INTO station VALUES(85,'RTL',84,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RTL.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(86,'RTL2',85,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RTL2.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(87,'RTS FM',86,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RTL2.m3u,'Mono-22Khz',20,0);
INSERT INTO station VALUES(88,'RVA',87,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RTS FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(89,'RVM',88,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RVA.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(90,'Résonance',89,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RVM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(91,'Skyrock Live',90,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Résonance.asx','Stéréo-32Khz',34,0);
INSERT INTO station VALUES(92,'Skyrock',91,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Skyrock Live.asx','Stéréo-32Khz',34,0);
INSERT INTO station VALUES(93,'Sud-Radio',92,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Skyrock.asx','Stéréo-32Khz',32,0);
INSERT INTO station VALUES(94,'Sun FM',93,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Sud-Radio.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(95,'Tempo FM',94,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Sun FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(96,'TFM',95,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Tempo FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(97,'Thollon la Radio Plus',96,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\TFM.asx','Mono-Khz',20,0);
INSERT INTO station VALUES(98,'Top Music',97,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Thollon la Radio Plus.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(99,'Trafic FM',98,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Top Music.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(100,'Tregor FM',99,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Trafic FM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(101,'Vibration',100,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\UnderGround FG.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(102,'Vitamine',101,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Vibration.asx','a voir',0,0);
INSERT INTO station VALUES(103,'Voltage',102,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Vitamine.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(104,'Wit FM',103,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Voltage.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(105,'3WK',104,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Wit FM.asx','Stéréo-44Khz',97,0);
CREATE TABLE tblATSCMapping ( idChannel integer, strChannel text, strProvider text, frequency text, symbolrate integer, innerFec integer, modulation integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer, channelNumber integer, minorChannel integer, majorChannel integer);
CREATE TABLE tblChannelCard( idChannelCard integer primary key, idChannel integer, card integer);
CREATE TABLE tblDVBCMapping ( idChannel integer, strChannel text, strProvider text, frequency text, symbolrate integer, innerFec integer, modulation integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer);
CREATE TABLE tblDVBSMapping ( idChannel integer,sPCRPid integer,sTSID integer,sFreq integer,sSymbrate integer,sFEC integer,sLNBKhz integer,sDiseqc integer,sProgramNumber integer,sServiceType integer,sProviderName text,sChannelName text,sEitSched integer,sEitPreFol integer,sAudioPid integer,sVideoPid integer,sAC3Pid integer,sAudio1Pid integer,sAudio2Pid integer,sAudio3Pid integer,sTeletextPid integer,sScrambled integer,sPol integer,sLNBFreq integer,sNetworkID integer,sAudioLang text,sAudioLang1 text,sAudioLang2 text,sAudioLang3 text,sECMPid integer,sPMTPid integer);
CREATE TABLE tblDVBTMapping ( idChannel integer, strChannel text, strProvider text, frequency text, bandwidth integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer);
CREATE INDEX idxStation ON station(idChannel);
COMMIT;
--------- Fin ---------
4) Exécuter le fichier " SQLite Database Browser.exe " se trouvant dans :
C:\Program Files\Team MediaPortal\MediaPortal\Docs .
_ A l'ouverture : File -> New Database
_ Sélectionner C:\Program Files\Team MediaPortal\MediaPortal\Database
_ Indiquer un nom de fichier ( ex. azerty.db3 ) , puis valider
_ Une boite de dialogue s'affiche -> " Cancel "
_ File -> Import -> "Database from SQL file"
_ Sélectionner C:\Program Files\Team MediaPortal\MediaPortal\Database
_ Indiquer le fichier "DataListe.sql" (créé au $3) , puis valider
_ Une boite de dialogue s'affiche -> " No "
=> attendre jusqu'à l'indication "Import complete" , clic sur "Ok" .
5) Cliquer sur l'onglet "Database Structure" puis sur "station" .
Vous devez voir les 8 champs composants la base station .
6) Cliquer sur l'onglet "Browse Data"
Vous devez voir les données : 105 lignes sur 7 colonnes .
7) Si cela vous semble correct (???) .
_ File -> "Compact Database"
_ File -> "Exit"
8) Renommer le fichier "azerty.db3" ($4) en "RadiodataBase4.db3" (se trouvant dans :
C:\Program Files\Team MediaPortal\MediaPortal\database) .
9) Lancer Mediaportal , constater les résultats .
NB 3 : les fichiers images (.gif) des stations doivent être dans :
C:\Program Files\Team MediaPortal\MediaPortal\thumbs\Radio
=== HELP , help , help ===
Je voudrais mettre dans un fichier .zip , exemple "notice database.ziiip" ,
tous les fichiers .asx , .gif , ainsi que le fichier RadioDatabase4.db3 .
Mais je ne sais pas , où le stocker .
Quelqu'un peut-il l'héberger ?
Si oui , peut-on m'indiquer la procédure à appliquer ?
===========================
Espérant que ceci pourra en aider quelques uns , à comprendre le processus
d'intégration des flux audio .
Salutations .
? ? ? ? ? ?
A l'attention de Scubefr :
Lorsqu'on utilise le fichier "configuration.exe" pour effectuer des modifs ,
après avoir quitté , celui-ci est toujours actif (???) .
=> <Alt+Ctrl+Suppr> "Gestionnaire des tâches" ,
il faut cliquer "configuration.exe" puis sur Terminer le processus .
Peut-on corriger cette anomalie ?
Merci .
? ? ? ? ? ?
Le fichier "RadiodataBase4.db3" se trouve dans : C:\Program Files\Team MediaPortal\MediaPortal\database .
1) Faire une copie de sauvegarde "RadiodataBase4.db3.ori" .
2) La structure des futures infos , à importer est du style :
---
BEGIN TRANSACTION;
CREATE TABLE station ( idChannel integer primary key, strName text, iChannelNr integer, frequency text, URL text, genre text, bitrate integer, scrambled integer);
INSERT INTO station VALUES(1,'radio yy',0,0,'unknown','xxxx',0,0);
CREATE TABLE tblATSCMapping ( idChannel integer, strChannel text, strProvider text, frequency text, symbolrate integer, innerFec integer, modulation integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer, channelNumber integer, minorChannel integer, majorChannel integer);
CREATE TABLE tblChannelCard( idChannelCard integer primary key, idChannel integer, card integer);
CREATE TABLE tblDVBCMapping ( idChannel integer, strChannel text, strProvider text, frequency text, symbolrate integer, innerFec integer, modulation integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer);
CREATE TABLE tblDVBSMapping ( idChannel integer,sPCRPid integer,sTSID integer,sFreq integer,sSymbrate integer,sFEC integer,sLNBKhz integer,sDiseqc integer,sProgramNumber integer,sServiceType integer,sProviderName text,sChannelName text,sEitSched integer,sEitPreFol integer,sAudioPid integer,sVideoPid integer,sAC3Pid integer,sAudio1Pid integer,sAudio2Pid integer,sAudio3Pid integer,sTeletextPid integer,sScrambled integer,sPol integer,sLNBFreq integer,sNetworkID integer,sAudioLang text,sAudioLang1 text,sAudioLang2 text,sAudioLang3 text,sECMPid integer,sPMTPid integer);
CREATE TABLE tblDVBTMapping ( idChannel integer, strChannel text, strProvider text, frequency text, bandwidth integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer);
CREATE INDEX idxStation ON station(idChannel);
COMMIT;
---
Les données pour chaque radio seront mises sur une ligne séparée ; exemple :
INSERT INTO station VALUES(1,'radio yy',0,0,'Url 1','ce qu'il vous plait',0,0);
INSERT INTO station VALUES(2,'radio zz',1,0,'Url 2','ce qu'il vous plait',0,0);
Elles doivent correspondre aux éléments ci-après :
(idChannel integer primary key, strName text, iChannelNr integer, frequency text, URL text, genre text, bitrate integer, scrambled integer)
= = = =
NB1 : J'ai stocké tous mes fichiers .asx dans le répertoire :
C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb
NB2 : Dans les noms , ne pas utiliser : é,è,à,ç,etc . Sinon vous aurez des PBs .
= = = =
3) Ci-dessous le détail d'un fichier que nous appellerons "DataListe.sql"
à placer dans : C:\Program Files\Team MediaPortal\MediaPortal\database .
A FINALISER au niveau de 5 stations (a voir) et BeurFM .
Il n'y a (presque) que des flux français , d'autres (étrangers) seront à venir .
--------- Début ---------
BEGIN TRANSACTION;
CREATE TABLE station ( idChannel integer primary key, strName text, iChannelNr integer, frequency text, URL text, genre text, bitrate integer, scrambled integer);
INSERT INTO station VALUES(1,'Alouette',0,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Alouette.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(2,'Alpes1G',1,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Alpes1G.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(3,'Arl',2,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Arl.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(4,'Basqueradio',3,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Basqueradio.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(5,'BeurFM',4,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\BeurFM.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(6,'BFM',5,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\BFM.asx','Mono-22Khz',18,0);
INSERT INTO station VALUES(7,'BlackBox',6,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\BlackBox.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(8,'CatalogneNord',7,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\CatalogneNord.asx','Mono-32Khz',22,0);
INSERT INTO station VALUES(9,'CentPourCent',8,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\CentPourCent.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(10,'ChérieFM',9,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\ChérieFM.asx','Stéréo-44Khz',130,0);
INSERT INTO station VALUES(11,'CocktailFM',10,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\CocktailFM.asx','Stéréo-44Khz',48,0);
INSERT INTO station VALUES(12,'CollinesFM',11,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\CollinesFM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(13,'ECN',12,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\ECN.asx','Mono-44Khz',32,0);
INSERT INTO station VALUES(14,'EspaceFM',13,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\EspaceFM.asx','Stéréo-32Khz',32,0);
INSERT INTO station VALUES(15,'Europe1',14,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Europe1.asx','Stéréo-32Khz',34,0);
INSERT INTO station VALUES(16,'Europe2',15,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Europe2.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(17,'EvasionFM',16,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\EvasionFM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(18,'FCradio',17,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FCradio.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(19,'FIP',18,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FIP.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(20,'FMPlus',19,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FMPlus.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(21,'Forum',20,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Forum.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(22,'FranceBleu',21,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FranceBleu.asx','Mono-32Khz',22,0);
INSERT INTO station VALUES(23,'FranceInfo',22,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FranceInfo.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(24,'FranceInter',23,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FranceInter.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(25,'FranceMusiques',24,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FranceMusiques.asx','Stéréo-44Khz',64,0);
INSERT INTO station VALUES(26,'FrequenceHorizon',25,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FrequenceHorizon.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(27,'FrequencePlus',26,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FrequencePlus.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(28,'FunRadio',27,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\FunRadio.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(29,'Generation',28,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Generations.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(30,'Hit & Sport',29,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Hit & Sport.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(31,'Hot Radio',30,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Hot Radio.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(32,'Impact Fm',31,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Impact Fm.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(33,'Jerico',32,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Jerico.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(34,'Jordanne FM',33,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Jordanne FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(35,'LaGrosseRadio',34,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\LaGrosseRadio.asx','Stéréo-44Khz',192,0);
INSERT INTO station VALUES(36,'LeMouv',35,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\LeMouv.asx','Stéréo-44Khz',66,0);
INSERT INTO station VALUES(37,'LittoralFM',36,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\LittoralFM.asx','Stéréo-44Khz',64,0);
INSERT INTO station VALUES(38,'LorFM',37,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\LorFM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(39,'Lyon1ère',38,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Lyon1ère.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(40,'MagicRadio',39,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\MagicRadio.asx','Stéréo-44Khz',192,0);
INSERT INTO station VALUES(41,'MagnumLaRadio',40,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\MagnumLaRadio.asx','Stéréo-44Khz',64,0);
INSERT INTO station VALUES(42,'MCOne',41,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\MCOne.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(43,'MistralFM',42,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\MistralFM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(44,'Mix24',43,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Mix24.asx','Mono-22Khz',24,0);
INSERT INTO station VALUES(45,'Montagne FM',44,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Montagne FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(46,'Music plus Movie',45,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Music plus Movie.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(47,'Normandie FM',46,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Normandie FM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(48,'Nostalgie',47,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Nostalgie.asx','Stéréo-44Khz',130,0);
INSERT INTO station VALUES(49,'NRJ',48,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\NRJ.asx','Stéréo-44Khz',130,0);
INSERT INTO station VALUES(50,'Océane FM',49,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Océane FM.asx','Stéréo-32Khz',32,0);
INSERT INTO station VALUES(51,'ODS Radio',50,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\ODS Radio.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(52,'PULS radio',51,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\PULS radio.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(53,'Radio 6',52,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio 6.asx','Mono-44Khz',32,0);
INSERT INTO station VALUES(54,'Radio 8',53,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio 8.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(55,'Radio ABF',54,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio ABF.asx','à voir',0,0);
INSERT INTO station VALUES(56,'Radio Caroline',55,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Caroline.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(57,'Radio Classique',56,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Classique.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(58,'Radio Courtoisie',57,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Courtoisie.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(59,'Radio Cote d_Amour',58,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Cote d_Amour.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(60,'Radio Espace',59,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Espace.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(61,'Radio Espoir',60,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Espoir.asx','Stéréo-32Khz',40,0);
INSERT INTO station VALUES(62,'Radio Kol Hachalom',61,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Kol Hachalom.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(63,'Radio Maria',62,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Maria.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(64,'Radio Maritima',63,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Maritima.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(65,'Radio Mega',64,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Mega.asx','à voir',0,0);
INSERT INTO station VALUES(66,'Radio Mon Pais',65,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Mon Pais.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(67,'Radio Mont-Blanc',66,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Mont-Blanc.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(68,'Radio Montluçon Bourbonnais',67,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Montluçon Bourbonnais.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(69,'Radio Narbonne Méditerranée',68,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Narbonne Méditerranée.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(70,'Radio Nohain',69,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Nohain.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(71,'Radio Océan',70,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Océan.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(72,'Radio Orient',71,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Orient.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(73,'Radio Scoop',72,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Scoop.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(74,'Radio Soleil Paris',73,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Soleil Paris.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(75,'Radio Star Marseille',74,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Star Marseille.asx','Stéréo-44Khz',128,0);
INSERT INTO station VALUES(76,'Radio Teentaal',75,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Teentaal.asx','à voir',0,0);
INSERT INTO station VALUES(77,'Radio Totem',76,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Totem.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(78,'Radio Vie Meilleure',77,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Radio Vie Meilleure.asx','Mono-16Khz',20,0);
INSERT INTO station VALUES(79,'RDL',78,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RDL.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(80,'RFI',79,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RFI.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(81,'RFM',80,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RFM.asx','à voir',0,0);
INSERT INTO station VALUES(82,'Rire et Chansons',81,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Rire et Chansons.asx','Stéréo-44Khz',130,0);
INSERT INTO station VALUES(83,'RMC Moyen Orient',82,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RMC Moyen Orient.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(84,'RMC',83,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RMC.asx','Mono-22Khz',18,0);
INSERT INTO station VALUES(85,'RTL',84,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RTL.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(86,'RTL2',85,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RTL2.asx','Stéréo-44Khz',96,0);
INSERT INTO station VALUES(87,'RTS FM',86,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RTL2.m3u,'Mono-22Khz',20,0);
INSERT INTO station VALUES(88,'RVA',87,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RTS FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(89,'RVM',88,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RVA.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(90,'Résonance',89,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\RVM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(91,'Skyrock Live',90,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Résonance.asx','Stéréo-32Khz',34,0);
INSERT INTO station VALUES(92,'Skyrock',91,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Skyrock Live.asx','Stéréo-32Khz',34,0);
INSERT INTO station VALUES(93,'Sud-Radio',92,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Skyrock.asx','Stéréo-32Khz',32,0);
INSERT INTO station VALUES(94,'Sun FM',93,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Sud-Radio.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(95,'Tempo FM',94,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Sun FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(96,'TFM',95,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Tempo FM.asx','Mono-32Khz',20,0);
INSERT INTO station VALUES(97,'Thollon la Radio Plus',96,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\TFM.asx','Mono-Khz',20,0);
INSERT INTO station VALUES(98,'Top Music',97,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Thollon la Radio Plus.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(99,'Trafic FM',98,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Top Music.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(100,'Tregor FM',99,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Trafic FM.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(101,'Vibration',100,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\UnderGround FG.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(102,'Vitamine',101,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Vibration.asx','a voir',0,0);
INSERT INTO station VALUES(103,'Voltage',102,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Vitamine.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(104,'Wit FM',103,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Voltage.asx','Mono-22Khz',20,0);
INSERT INTO station VALUES(105,'3WK',104,0,'C:\Program Files\Team MediaPortal\MediaPortal\ListeRadiosWeb\Wit FM.asx','Stéréo-44Khz',97,0);
CREATE TABLE tblATSCMapping ( idChannel integer, strChannel text, strProvider text, frequency text, symbolrate integer, innerFec integer, modulation integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer, channelNumber integer, minorChannel integer, majorChannel integer);
CREATE TABLE tblChannelCard( idChannelCard integer primary key, idChannel integer, card integer);
CREATE TABLE tblDVBCMapping ( idChannel integer, strChannel text, strProvider text, frequency text, symbolrate integer, innerFec integer, modulation integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer);
CREATE TABLE tblDVBSMapping ( idChannel integer,sPCRPid integer,sTSID integer,sFreq integer,sSymbrate integer,sFEC integer,sLNBKhz integer,sDiseqc integer,sProgramNumber integer,sServiceType integer,sProviderName text,sChannelName text,sEitSched integer,sEitPreFol integer,sAudioPid integer,sVideoPid integer,sAC3Pid integer,sAudio1Pid integer,sAudio2Pid integer,sAudio3Pid integer,sTeletextPid integer,sScrambled integer,sPol integer,sLNBFreq integer,sNetworkID integer,sAudioLang text,sAudioLang1 text,sAudioLang2 text,sAudioLang3 text,sECMPid integer,sPMTPid integer);
CREATE TABLE tblDVBTMapping ( idChannel integer, strChannel text, strProvider text, frequency text, bandwidth integer, ONID integer, TSID integer, SID integer, Visible integer, audioPid integer, pmtPid integer);
CREATE INDEX idxStation ON station(idChannel);
COMMIT;
--------- Fin ---------
4) Exécuter le fichier " SQLite Database Browser.exe " se trouvant dans :
C:\Program Files\Team MediaPortal\MediaPortal\Docs .
_ A l'ouverture : File -> New Database
_ Sélectionner C:\Program Files\Team MediaPortal\MediaPortal\Database
_ Indiquer un nom de fichier ( ex. azerty.db3 ) , puis valider
_ Une boite de dialogue s'affiche -> " Cancel "
_ File -> Import -> "Database from SQL file"
_ Sélectionner C:\Program Files\Team MediaPortal\MediaPortal\Database
_ Indiquer le fichier "DataListe.sql" (créé au $3) , puis valider
_ Une boite de dialogue s'affiche -> " No "
=> attendre jusqu'à l'indication "Import complete" , clic sur "Ok" .
5) Cliquer sur l'onglet "Database Structure" puis sur "station" .
Vous devez voir les 8 champs composants la base station .
6) Cliquer sur l'onglet "Browse Data"
Vous devez voir les données : 105 lignes sur 7 colonnes .
7) Si cela vous semble correct (???) .
_ File -> "Compact Database"
_ File -> "Exit"
8) Renommer le fichier "azerty.db3" ($4) en "RadiodataBase4.db3" (se trouvant dans :
C:\Program Files\Team MediaPortal\MediaPortal\database) .
9) Lancer Mediaportal , constater les résultats .
NB 3 : les fichiers images (.gif) des stations doivent être dans :
C:\Program Files\Team MediaPortal\MediaPortal\thumbs\Radio
=== HELP , help , help ===
Je voudrais mettre dans un fichier .zip , exemple "notice database.ziiip" ,
tous les fichiers .asx , .gif , ainsi que le fichier RadioDatabase4.db3 .
Mais je ne sais pas , où le stocker .
Quelqu'un peut-il l'héberger ?
Si oui , peut-on m'indiquer la procédure à appliquer ?
===========================
Espérant que ceci pourra en aider quelques uns , à comprendre le processus
d'intégration des flux audio .
Salutations .
? ? ? ? ? ?
A l'attention de Scubefr :
Lorsqu'on utilise le fichier "configuration.exe" pour effectuer des modifs ,
après avoir quitté , celui-ci est toujours actif (???) .
=> <Alt+Ctrl+Suppr> "Gestionnaire des tâches" ,
il faut cliquer "configuration.exe" puis sur Terminer le processus .
Peut-on corriger cette anomalie ?
Merci .
? ? ? ? ? ?