Reconciliation is done manually with the menu
- Dataset/Schedule/Reconcile.
- Scheduler : Reconcile
A window opens and allows you to choose a Specific Reconciliation Profile :
(Reconciliation_Netia_XML_V1_1.def).
Example of a reconciliation file :
[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")