Overlay Log Import

You have a question or need an advice about how to do something? Ask it here!
Post Reply
Inzane8305
Posts: 53
Joined: 06 Jun 2018 08:06
Overlay Log Import

Post by Inzane8305 »

Hi Bernd.
Maybe this has been a topic before (And I may be blind as to find it ;-) )

"Building" Proppfrexx scipts, advert, news and more.

Problem is that Advert Logs come from 2 places: 1 local: file = ddMM.asc and 1 National: file= YYMMdd.asc
Local gets imported within a script. Creating 1 entry at xx.15 and 1 at xx.30. (All is fine)
National I try to import via Automatic overlay import. But this creates a lot of entries (see photo att.)

I use "DkBureau" as import-file-option (for both logs).

Here is few lines from Local log:
08:30:00 Suzuki Junges Automobiler R959-2 22
08:30:00 Image Åbyhøj Låseservice R965-1 36
08:30:00 Transport Jan Andersen Transport R958-1 14
08:30:00 Image Tandplejer Camilla Friis R956-1 30
09:15:00 Udsalg m/weekend rettet Djurs Møbler R877-16 25
09:30:00 Image 2018 Berlinmægleren R939-1 15
09:30:00 Tectrol Viby Undervognscenter R963-1 25
09:30:00 Image Hørning Produkt R954-1 28
09:30:00 2018 Samsø Festival R962-1 30
09:30:00 Hyundai Junges Automobiler R959-1 22
09:30:00 Image Randrup Pejse R957-1 27

And here is a few lines from National log:
06:52:00 SBS51 VKSurpriseDage_V2 Vordingborg Køkkenet uge 12-16 19-04-17 SBS51960 00:10
06:52:10 SBS51 SPAR - Kamp 3 SPAR - påske uge 13-16 19-04-17 SBS51698 00:15
06:52:25 SBS51 Jem & Fix uge 16 A Jem & Fix uge 16 19-04-17 SBS51704 00:20
06:52:45 SBS52 Kan5VoiceJrPremLØR Discovery Networks uge 16 19-04-17 SBS52068 00:20
06:53:05 SBS52 4.b Unibet Commuting Unibet April 19-04-17 SBS52615 00:20
06:53:25 SBS52 INGO uge 14-17 INGO uge 14-17 19-04-17 SBS52462 00:20
06:53:45 SBS52 Aldi HU30 Aldi uge 14-17 19-04-17 SBS52224 00:15
06:54:00 SBS52 Flugger_Lordag_01 Flügger 19-04-17 SBS52493 00:20
06:54:20 SBS51 BURGER KING uge 10-12 BURGER KING uge 16-18 + 20 19-04-17 SBS51736 00:15
06:54:35 SBS52 Coop Påske Burst 1 Coop DB Påske uge 15-16 19-04-17 SBS52183 00:20
06:54:55 SBS52 BauhaU166017-19/4 Bauhaus uge 16 19-04-17 SBS52303 00:20
06:55:15 SBS52 Waoo Fiber U15-16 Waoo uge 15-17 19-04-17 SBS52298 00:15
06:55:30 SBS52 Vikinglotto uge 16 Danske Spil Vikinglotto uge 16 19-04-17 SBS52351 00:15
06:55:45 SBS52 CircleK Food1Morgen Circle K uge 14-17 19-04-17 SBS52405 00:15
06:56:00 SBS51 REMA 1000 uge 16 v3 REMA 1000 uge 13-16 19-04-17 SBS51462 00:10
06:56:10 SBS52 A Børne & Herresko Magasin uge 16-17 19-04-17 SBS52413 00:20
06:56:30 SBS52 Lidl uge 16 spot 1 Lidl uge 15-16 - Taktisk 1 19-04-17 SBS52196 00:15
06:56:45 SBS52 SocDem_Sundhed_5 Socialdemokratiet uge 12-15 + 19-04-17 SBS52207 00:15
07:52:00 SBS52 Jem & Fix uge 16 B Jem & Fix uge 16 19-04-17 SBS52507 00:20
07:52:20 SBS51 SPAR - Kamp 3 SPAR - påske uge 13-16 19-04-17 SBS51698 00:15
07:52:35 SBS52 INGO uge 14-17 INGO uge 14-17 19-04-17 SBS52462 00:20
07:52:55 SBS51 BURGER KING uge 10-12 BURGER KING uge 16-18 + 20 19-04-17 SBS51736 00:15

Is the logs the problem (wrong format for DkBureau?)

Kind Regards Kjeld B, Samso Radio (And Oest FM)
Attachments
Snip.PNG
User avatar
radio42
Site Admin
Posts: 8295
Joined: 05 Apr 2012 16:26
Location: Hamburg, Germany
Contact:
Re: Overlay Log Import

Post by radio42 »

Yes, the national log file seems to be wrong.
The first column should denote the target time of the adverts and all adverts belonging to the same group should use the same target time.
In your case does the first column always use a different time and thus each entry is recognized as an individual group.

As you can see in your Local log (where all is correct), here the first column correct groups the adverts by target time.
Actually should both formats be the same?
Inzane8305
Posts: 53
Joined: 06 Jun 2018 08:06
Re: Overlay Log Import

Post by Inzane8305 »

Found a solution to "National" log:
Install software "Genius Replace" (commandline driven)

Run software, open file, delete 3 chars each line from char 6, replace 5th char with "0", save file. (All done automatic)

That should do the trick.

Kind regards Kjeld

PS: Can this be done from within PF? In a script? Or as "control command"?
User avatar
radio42
Site Admin
Posts: 8295
Joined: 05 Apr 2012 16:26
Location: Hamburg, Germany
Contact:
Re: Overlay Log Import

Post by radio42 »

In your described solution you are basically chopping off the seconds. This could theoretically also be configured with a new .importformats entry, which only considers the hours and
Minutes of the timeframe.
But this not a really good solution, as I guess, that the adverts from 06:52:xx to 06:56:xx should all be considered to be one single block.

From where do you get the National block?
As so far for all other danish customers the format was the same for Local and National both used the DKBureau format.
Inzane8305
Posts: 53
Joined: 06 Jun 2018 08:06
Re: Overlay Log Import

Post by Inzane8305 »

Hi again Bernd.
You´re right. Bad solution. As the rest of each line is bad also.

The National log is from Bauer Media. (still don´t know what software they use to make the log.)

With Genius Replace I can almost manually remove the unwanted parts: 6 chars from char 8, then 1 char from char 38, then 30 from char 70 and 15 from 79. And then replace the x:xx of the first timecode with 2:00, leaving each line to look like the local log. This works then with Overlay Import.
But making GeniusReplace do this automatic does NOT work. (They say it should :-( )

Making a new "filter"/importoption would be a great thing if possible. As said: the log is from Bauer Media. If you need a full and fresh log I can provide one.
The filter should "only" in our case consider the hours (as the overlay should be always put at xx.52.)

I must once again turn to you for professional help.

/Kjeld

Post Reply