La réconciliation se fait manuellement avec le menu :
Base de données/Planifier/Réconcilier.
-Planificateur -> Réconcilier
-
Une fenêtre s’ouvre et permet de choisir un Profil de Réconciliation Spécifique
(Reconciliation_Netia_XML_V1_1.def).
Exemple de fichier de définition de réconciliation :
[Description]
Name=Reconciliation RNT Netia v.1.1
Type=Reconcile
[Import]
SourceType=XML
SourcePath=M:\AsRun
SourceSpec=@y1-@m1-@d1_RNT.XML
[ImportProperties]
BasePath=//DbEntity/DbTuple
[ImportFields]
Fld1=AIR_DURATION|AIR_DURATION
Fld2=BROADCAST_TIME|BROADCAST_TIME
Fld3=CHANNEL_NAME|CHANNEL_NAME
Fld4=SongID|NUM_SELECTOR
Fld5=STRING_2|STRING_2
[ImportValidation]
[Reconcile]
SongID=1
[ReconcileProperties]
DeleteMissingHours=0
LockElements=1
SaveReconAirtimes=1
SaveReconRuntimes=1
;DupeCheck=01:00
;BypassNonMx=1
;MinLength=00:15
;UpdatePrevHour=0
[ReconcileData]
RunHour=mid(InFld("AIR_DURATION"),1,2)
RunMin=mid(InFld("AIR_DURATION"),4,2)
RunSec=mid(InFld("AIR_DURATION"),7,2)
AirYear=mid(InFld("BROADCAST_TIME"),1,4)
AirMonth=mid(InFld("BROADCAST_TIME"),6,2)
AirDay=mid(InFld("BROADCAST_TIME"),9,2)
AirHour=mid(InFld("BROADCAST_TIME"),12,2)
AirMin=mid(InFld("BROADCAST_TIME"),15,2)
AirSec=mid(InFld("BROADCAST_TIME"),18,2)
CutID=Trim(InFld("SongID"))
CutTitle=InFld("STRING_2")