From ae8026c165bff4e5056f1a8ae02520f30369c945 Mon Sep 17 00:00:00 2001
From: =?utf8?q?V=C3=A1s=C3=A1ry=20D=C3=A1niel?= <vasary@elgekko.net>
Date: Wed, 10 Jan 2024 16:40:36 +0100
Subject: [PATCH] v0.0.3

---
 mc-vod-sync/QUESTIONS.md                      |   3 +
 mc-vod-sync/mc-vod-sync-app/pom.xml           |   2 +-
 .../src/main/resources/application-dev.yaml   |  16 +-
 .../src/main/resources/application.yaml       |  73 +++----
 .../src/main/resources/logback-prod.xml       |  33 ++++
 .../src/main/resources/logback-spring.xml     |  15 +-
 .../java/hu/user/mcvodsync/AssetExportIT.java |  74 +++++++
 .../user/mcvodsync/AssetImportExportBase.java |  81 ++++++--
 ...ImportExportIT.java => AssetImportIT.java} |  57 ++++--
 .../java/hu/user/mcvodsync/AssetMapperIT.java |   7 +-
 .../hu/user/mcvodsync/BrightCoveClientIT.java |  38 +++-
 ...rviceTest.java => EmailSendServiceIT.java} |  19 +-
 .../hu/user/mcvodsync/ExecutionLockIT.java    |   6 +-
 .../java/hu/user/mcvodsync/RepositoryIT.java  |  13 +-
 .../resources/testdata-duplicate-video.xlsx   | Bin 0 -> 16773 bytes
 .../mcvodsync/brightcove/ApiProperties.java   |   2 +
 .../brightcove/BrightCoveClient.java          | 108 +++++++++--
 .../mc-vod-sync-db/migrations/bootstrap.sql   |   6 +-
 .../scripts/003_create_business_tables.sql    |  23 ++-
 .../main/java/hu/user/mcvodsync/db/Asset.java |  34 +++-
 .../java/hu/user/mcvodsync/db/AssetSync.java  |   4 +-
 .../java/hu/user/mcvodsync/db/Associate.java  |  10 +-
 .../hu/user/mcvodsync/db/PlaylistSync.java    |   4 +-
 .../java/hu/user/mcvodsync/db/UploadFile.java |  10 +-
 .../db/converter/StringListConverter.java     |  19 +-
 .../db/repository/AssetRepository.java        |  24 ++-
 .../db/repository/AssetSyncRepository.java    |   2 +
 .../db/repository/PlaylistSyncRepository.java |   2 +
 .../mcvodsync/service/ServiceProperties.java  |  13 +-
 .../service/config/ScheduledTasks.java        |  71 ++++++-
 .../service/data/CompositeSummary.java        |  56 ++++++
 .../user/mcvodsync/service/data/Summary.java  |  53 +++++
 .../service/event/ExportCompletedEvent.java   |   6 +-
 .../service/event/ExportStartedEvent.java     |  15 ++
 .../service/event/ImportCompletedEvent.java   |   6 +-
 .../service/in/AssetImportService.java        |  78 ++++----
 .../mcvodsync/service/in/AssetMapper.java     |   7 +
 .../mcvodsync/service/in/ImportSummary.java   |  81 --------
 .../mcvodsync/service/in/VodXlsProcessor.java |  27 +--
 .../service/mail/EmailSendService.java        |  31 ++-
 ...ortService.java => SyncExportService.java} | 138 +++++++------
 .../mcvodsync/service/out/SyncProcessor.java  |  83 ++++++++
 .../mcvodsync/service/out/VideoMapper.java    |  65 +++++--
 .../service/schedule/ScheduledExport.java     |  16 +-
 .../service/schedule/ScheduledImport.java     |   6 +-
 ...acker.java => ScheduledSunsetChacker.java} |   2 +-
 .../mcvodsync/service/time/TimeUtils.java     |  14 ++
 .../mcvodsync/ui/ApplicationProperties.java   |   1 +
 .../java/hu/user/mcvodsync/ui/Constants.java  |   3 +-
 .../ui/config/ResourceConfigurer.java         |   2 +-
 .../ui/config/WebSecurityConfig.java          |   2 +-
 .../ui/data/BrightCovePlaylistDataModel.java  |   6 +-
 .../ui/data/BrightCoveVideoDataModel.java     |  47 ++++-
 .../ui/view/ExportDataViewModel.java          |  45 -----
 .../mcvodsync/ui/view/ImportEventHandler.java |   2 -
 .../mcvodsync/ui/view/IndexViewModel.java     |  18 +-
 ...tFileViewModel.java => MainViewModel.java} |  11 +-
 .../src/main/resources/metainfo/zk/zk.xml     |  12 +-
 .../src/main/resources/web/associates.zul     |  38 ++--
 .../src/main/resources/web/browse-remote.zul  |  45 ++++-
 .../main/resources/web/form/export-stats.zul  | 181 ++++++++++++++++++
 .../main/resources/web/form/import-stats.zul  | 180 +++++++++++++++++
 .../src/main/resources/web/form/test.zul      |   3 +
 .../src/main/resources/web/import-file.zul    | 131 -------------
 .../src/main/resources/web/index.zul          |  37 ++--
 .../src/main/resources/web/main.zul           |  62 ++++++
 66 files changed, 1630 insertions(+), 649 deletions(-)
 create mode 100644 mc-vod-sync/mc-vod-sync-app/src/main/resources/logback-prod.xml
 create mode 100644 mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetExportIT.java
 rename mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/{AssetImportExportIT.java => AssetImportIT.java} (55%)
 rename mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/{EmailSendServiceTest.java => EmailSendServiceIT.java} (53%)
 create mode 100644 mc-vod-sync/mc-vod-sync-app/src/test/resources/testdata-duplicate-video.xlsx
 create mode 100644 mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/data/CompositeSummary.java
 create mode 100644 mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/data/Summary.java
 create mode 100644 mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ExportStartedEvent.java
 delete mode 100644 mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/ImportSummary.java
 rename mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/{AssetExportService.java => SyncExportService.java} (62%)
 create mode 100644 mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/SyncProcessor.java
 rename mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/{ScheduledSunriseChacker.java => ScheduledSunsetChacker.java} (91%)
 create mode 100644 mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/time/TimeUtils.java
 delete mode 100644 mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ExportDataViewModel.java
 rename mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/{ImportFileViewModel.java => MainViewModel.java} (91%)
 create mode 100644 mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/export-stats.zul
 create mode 100644 mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/import-stats.zul
 create mode 100644 mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/test.zul
 delete mode 100644 mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/import-file.zul
 create mode 100644 mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/main.zul

diff --git a/mc-vod-sync/QUESTIONS.md b/mc-vod-sync/QUESTIONS.md
index d1c780a2..c8db0b0f 100644
--- a/mc-vod-sync/QUESTIONS.md
+++ b/mc-vod-sync/QUESTIONS.md
@@ -1,3 +1,6 @@
+- Az extra notes hogyan értelmezendő?
+- Egy video lehet e többször hozzáadva gyan ahhoz a listához? Ha nem ,kéne csekkolni betöltésnél...
+
 actors_talent, Actors/Talent, , string, null required: false
 director, Director, , string, null required: false
 episode, Episode, ,
diff --git a/mc-vod-sync/mc-vod-sync-app/pom.xml b/mc-vod-sync/mc-vod-sync-app/pom.xml
index 7bf9f2ce..b73d56eb 100644
--- a/mc-vod-sync/mc-vod-sync-app/pom.xml
+++ b/mc-vod-sync/mc-vod-sync-app/pom.xml
@@ -3,7 +3,7 @@
          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
     <modelVersion>4.0.0</modelVersion>
     <artifactId>mc-vod-sync-app</artifactId>
-    <version>0.0.1-SNAPSHOT</version>
+    <version>0.0.3</version>
     <parent>
         <groupId>hu.user</groupId>
         <artifactId>mc-vod-sync</artifactId>
diff --git a/mc-vod-sync/mc-vod-sync-app/src/main/resources/application-dev.yaml b/mc-vod-sync/mc-vod-sync-app/src/main/resources/application-dev.yaml
index e5fc5a9c..f2b12d1b 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/main/resources/application-dev.yaml
+++ b/mc-vod-sync/mc-vod-sync-app/src/main/resources/application-dev.yaml
@@ -25,13 +25,14 @@ spring:
     username: db2admin
     password: password
   mail:
-    host: mx.in.useribm.hu
+#    host: mx.in.useribm.hu
 #    port: 587
 #  spring.mail.username=<login user to smtp server>
 #  spring.mail.password=<login password to smtp server>
 #  spring.mail.properties.mail.smtp.auth=true
 #  spring.mail.properties.mail.smtp.starttls.enable=true
 logging:
+  config:
   level:
     org.hibernate.engine.jdbc.spi.SqlExceptionHelper: ERROR
 #    org.springframework.web.client.RestTemplate: DEBUG
@@ -39,19 +40,24 @@ logging:
 #    httpclient.wire: DEBUG
 mc-vod-sync:
   service:
-    target-video-insert-enabled: true
-    target-playlist-insert-enabled: true
+    target-video-insert-enabled: false
+    target-playlist-insert-enabled: false
     scheduler:
       import-enabled: false
       export-enabled: false
-      sunrise-checker-enabled: false
+      sunset-checker-enabled: false
       import-cron: 0 0 4 1/1 * ? *
       export-cron: 0 0 4 1/1 * ? *
-      sunrise-checker-cron: 0 0 4 1/1 * ? *
+      sunset-checker-cron: 0 0 4 1/1 * ? *
+    report:
+      recipient: vasary@elgekko.net
+      sender: noreply@mc-vod-sync
   application:
     user-name: user
     password: password
+    admin: true
   api:
+    base-url: https://cms.api.brightcove.com
     token-request-url: https://oauth.brightcove.com/v4/access_token
     client-id: 0337034f-bde3-44d4-81ba-6a4566ca8ba0
     client-secret: 03Az2W6BSj4sTPSU7SVnRcJ6NDmeaFmB7EPbmuZFnt5slaC2bbscBOMvKR03CGVMxaVXUo9ao6e_gLvxUCjtgg
diff --git a/mc-vod-sync/mc-vod-sync-app/src/main/resources/application.yaml b/mc-vod-sync/mc-vod-sync-app/src/main/resources/application.yaml
index 39be7218..00b7dec1 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/main/resources/application.yaml
+++ b/mc-vod-sync/mc-vod-sync-app/src/main/resources/application.yaml
@@ -1,5 +1,5 @@
 server:
-  port: 8080
+  port: 80
   servlet:
     context-path: /
 zk:
@@ -7,9 +7,7 @@ zk:
   zul-view-resolver-enabled: true
 spring:
   jpa:
-    #    hibernate:
-    #      use-new-id-generator-mappings: true
-    show-sql: true
+    show-sql: false
     properties:
       hibernate:
         format_sql: true
@@ -20,37 +18,40 @@ spring:
       enabled: always
   datasource:
     type: com.zaxxer.hikari.HikariDataSource
-    url: jdbc:db2://dvdev.in.useribm.hu:50000/vodsync
+    url: jdbc:db2://localhost:25000/vodsync
+    retrieveMessagesFromServerOnGetMessage: true
     username: db2admin
-    password: password
-camunda.bpm:
-  generic-properties.properties:
-    telemetry-reporter-activate: false
-  job-executor-acquire-by-priority: true
-  job-execution:
-    core-pool-size: 10
-    #lock-time-in-millis: 600000
-  database:
-    type: db2
-    schema-update: false
-    table-prefix: CAMUNDA.
-    schema-name: CAMUNDA
-  webapp:
-    enabled: true
-    index-redirect-enabled: false
-  admin-user:
-    id: kermit
-    password: password
-    firstName: Kermit
-  filter:
-    create: All tasks
-  job-execution.enabled: true
+    password: Password01
+  mail:
+    host: mx.in.useribm.hu
+#   port: 587
+#   username=<login user to smtp server>
+#   password=<login password to smtp server>
+#   properties.mail.smtp.auth=true
+#   properties.mail.smtp.starttls.enable=true
 logging:
-  #  config: classpath:log4j2.xml
-  level:
-    org.hibernate.engine.jdbc.spi.SqlExceptionHelper: ERROR
-#    org.springframework.security: DEBUG
-#    org.springframework.security.web: INFO
-#  pattern:
-#    console: "%d %-5level %logger : %msg%n"
-#    file: "%d %-5level [%thread] %logger : %msg%n"
\ No newline at end of file
+  config: logback-prod.xml
+mc-vod-sync:
+  service:
+    target-video-insert-enabled: false
+    target-playlist-insert-enabled: false
+    scheduler:
+      import-enabled: false
+      export-enabled: false
+      sunset-checker-enabled: false
+      import-cron: 0 0 4 1/1 * ? *
+      export-cron: 0 0 4 1/1 * ? *
+      sunset-checker-cron: 0 0 4 1/1 * ? *
+    report:
+      recipient: vasary@elgekko.net
+      sender: noreply@mc-vod-sync
+  application:
+    user-name: user
+    password: password
+    admin: true
+  api:
+    base-url: https://cms.api.brightcove.com
+    token-request-url: https://oauth.brightcove.com/v4/access_token
+    client-id: 0337034f-bde3-44d4-81ba-6a4566ca8ba0
+    client-secret: 03Az2W6BSj4sTPSU7SVnRcJ6NDmeaFmB7EPbmuZFnt5slaC2bbscBOMvKR03CGVMxaVXUo9ao6e_gLvxUCjtgg
+    account-id: 6302605131001
diff --git a/mc-vod-sync/mc-vod-sync-app/src/main/resources/logback-prod.xml b/mc-vod-sync/mc-vod-sync-app/src/main/resources/logback-prod.xml
new file mode 100644
index 00000000..049a51f7
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-app/src/main/resources/logback-prod.xml
@@ -0,0 +1,33 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<configuration>
+    <property name="LOGNAME" value="mc-vod-sync"/>
+    <property name="LOGS" value="./logs"/>
+
+    <appender name="Console" class="ch.qos.logback.core.ConsoleAppender">
+        <layout class="ch.qos.logback.classic.PatternLayout">
+            <Pattern>
+                %black(%d{ISO8601}) %highlight(%-5level) [%blue(%t)] %yellow(%C{1.}): %msg%n%throwable
+            </Pattern>
+        </layout>
+    </appender>
+
+    <appender name="RollingFile" class="ch.qos.logback.core.rolling.RollingFileAppender">
+        <file>${LOGS}/${LOGNAME}.log</file>
+        <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
+            <Pattern>%d %p %C{1.} [%t] %m%n</Pattern>
+        </encoder>
+        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
+            <fileNamePattern>${LOGS}/archived/${LOGNAME}-%d{yyyy-MM-dd}.log.zip</fileNamePattern>
+        </rollingPolicy>
+    </appender>
+
+    <springProfile name="prod">
+        <root level="INFO">
+            <appender-ref ref="Console"/>
+        </root>
+        <root level="INFO">
+            <appender-ref ref="RollingFile"/>
+        </root>
+    </springProfile>
+
+</configuration>
\ No newline at end of file
diff --git a/mc-vod-sync/mc-vod-sync-app/src/main/resources/logback-spring.xml b/mc-vod-sync/mc-vod-sync-app/src/main/resources/logback-spring.xml
index 153ccc4f..d20bc1c5 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/main/resources/logback-spring.xml
+++ b/mc-vod-sync/mc-vod-sync-app/src/main/resources/logback-spring.xml
@@ -1,12 +1,12 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <configuration>
-    <include resource="org/springframework/boot/logging/logback/base.xml"/>
+    <!--    <include resource="org/springframework/boot/logging/logback/base.xml"/>-->
     <!--    <property name="LOGS" value="./logs"/>-->
 
     <appender name="Console" class="ch.qos.logback.core.ConsoleAppender">
         <layout class="ch.qos.logback.classic.PatternLayout">
             <Pattern>
-                %black(%d{ISO8601}) %highlight(%-5level) [%blue(%t)] %yellow(%C{1.}): %msg%n%throwable
+                %black(%d{ISO8601}) %highlight(%-5level) [%blue(%t)] %yellow(%C{1.}): [%F:%L] %msg%n %throwable
             </Pattern>
         </layout>
     </appender>
@@ -22,11 +22,14 @@
     <!--    </appender>-->
 
     <springProfile name="dev">
-        <logger name="org.springframework" level="INFO" additivity="false">
-            <appender-ref ref="CONSOLE"/>
-        </logger>
+        <!--        <logger name="hu.user.mcvodsync" level="INFO" additivity="false">-->
+        <!--            <appender-ref ref="Console"/>-->
+        <!--        </logger>-->
+        <!--        <logger name="org.springframework" level="INFO" additivity="false">-->
+        <!--            <appender-ref ref="Console"/>-->
+        <!--        </logger>-->
         <root level="INFO">
-            <appender-ref ref="CONSOLE"/>
+            <appender-ref ref="Console"/>
         </root>
     </springProfile>
 
diff --git a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetExportIT.java b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetExportIT.java
new file mode 100644
index 00000000..b89cec87
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetExportIT.java
@@ -0,0 +1,74 @@
+/*
+ * Copyright (c) $today.year-$today.month-24.
+ * By elGekko
+ */
+
+package hu.user.mcvodsync;
+
+import lombok.extern.log4j.Log4j2;
+import org.junit.Test;
+import org.junit.runner.RunWith;
+import org.springframework.boot.test.context.SpringBootTest;
+import org.springframework.test.context.ActiveProfiles;
+import org.springframework.test.context.TestPropertySource;
+import org.springframework.test.context.junit4.SpringRunner;
+
+
+@Log4j2
+@RunWith(SpringRunner.class)
+@SpringBootTest
+@ActiveProfiles("dev")
+@TestPropertySource("classpath:application-dev.yaml")
+public class AssetExportIT extends AssetImportExportBase {
+
+    @Test
+    public void initialLoadTest() throws Exception {
+        cleanupLocal();
+        importFile("src/test/resources/testdata.xlsx");
+        cleanupRemote();
+        exportData();
+        assertSynchronized();
+    }
+
+    @Test
+    public void changeVideoTest() throws Exception {
+        cleanupLocal();
+        importFile("src/test/resources/testdata.xlsx");
+        importFile("src/test/resources/testdata-change-video.xlsx");
+        cleanupRemote();
+        exportData();
+        assertSynchronized();
+    }
+
+    @Test
+    public void deleteVideoTest() throws Exception {
+        cleanupLocal();
+        importFile("src/test/resources/testdata.xlsx");
+        importFile("src/test/resources/testdata-delete-video.xlsx");
+        cleanupRemote();
+        exportData();
+        assertSynchronized();
+    }
+
+    @Test
+    public void changePlaylistOrderTest() throws Exception {
+        cleanupLocal();
+        importFile("src/test/resources/testdata.xlsx");
+        importFile("src/test/resources/testdata-change-playlist-order.xlsx");
+        cleanupRemote();
+        exportData();
+        assertSynchronized();
+    }
+
+    @Test
+    public void duplicateVideoTest() throws Exception {
+        cleanupLocal();
+        importFile("src/test/resources/testdata.xlsx");
+        importFile("src/test/resources/testdata-duplicate-video.xlsx");
+        cleanupRemote();
+        exportData();
+        assertSynchronized();
+    }
+
+
+}
diff --git a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportExportBase.java b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportExportBase.java
index 050b363e..43e93735 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportExportBase.java
+++ b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportExportBase.java
@@ -15,10 +15,11 @@ import hu.user.mcvodsync.db.SyncType;
 import hu.user.mcvodsync.db.repository.AssetRepository;
 import hu.user.mcvodsync.db.repository.AssetSyncRepository;
 import hu.user.mcvodsync.db.repository.PlaylistSyncRepository;
+import hu.user.mcvodsync.service.data.CompositeSummary;
+import hu.user.mcvodsync.service.data.Summary;
 import hu.user.mcvodsync.service.in.AssetImportService;
-import hu.user.mcvodsync.service.in.ImportSummary;
 import hu.user.mcvodsync.service.in.VodXlsProcessor;
-import hu.user.mcvodsync.service.out.AssetExportService;
+import hu.user.mcvodsync.service.out.SyncProcessor;
 import hu.user.mcvodsync.service.out.VideoMapper;
 import lombok.extern.log4j.Log4j2;
 import org.apache.commons.lang3.StringUtils;
@@ -55,7 +56,7 @@ public class AssetImportExportBase {
     private AssetImportService assetImportService;
 
     @Autowired
-    private AssetExportService assetExportService;
+    private SyncProcessor syncProcessor;
 
     @Autowired
     private BrightCoveClient brightCoveClient;
@@ -66,22 +67,41 @@ public class AssetImportExportBase {
     protected String getPlaylistSyncIds(String name) {
         List<PlaylistSync> playlists = playlistSyncRepository.findAllByName(name);
         assertEquals(1, playlists.size());
-        return StringUtils.join(playlists.get(0).getIds(), ",");
+        List<String> catalogIds = playlists.get(0).getIds().stream().map(assetRepository::findCatalogIdById).collect(Collectors.toList());
+        return StringUtils.join(catalogIds, ",");
     }
 
-    protected void cleanup() {
+    protected void cleanup() throws Exception {
         cleanupLocal();
         cleanupRemote();
         assetRepository.deleteAllInBatch();
     }
 
-    protected void cleanupRemote() {
+    protected void cleanupRemote() throws InterruptedException {
         log.info("cleanupRemote");
         cleanupRemotePlaylists();
+        waitForPlaylistCleanupCompleted();
+        Thread.sleep(3000);
         cleanupRemoteVideos();
+        waitForVideoCleanupCompleted();
         log.info("cleanupRemote OK");
     }
 
+    private void waitForVideoCleanupCompleted() {
+        while (true) {
+            int count = 0;
+            PagedSearch<Video> page = PagedSearch.<Video>builder()
+                    .query("tags:mc-vod-sync")
+                    .build();
+            while (brightCoveClient.getVideosPaged(page)) {
+                count += page.getData().size();
+            }
+            if (count == 0) {
+                break;
+            }
+        }
+    }
+
     private void cleanupRemoteVideos() {
         PagedSearch<Video> page = PagedSearch.<Video>builder()
                 .query("tags:mc-vod-sync")
@@ -101,6 +121,22 @@ public class AssetImportExportBase {
         }
     }
 
+    private void waitForPlaylistCleanupCompleted() {
+        while (true) {
+            int count = 0;
+            PagedSearch<Playlist> page = PagedSearch.<Playlist>builder()
+                    .query("description:mc-vod-sync")
+                    .sort("name")
+                    .build();
+            while (brightCoveClient.getPlaylistsPaged(page)) {
+                count += page.getData().size();
+            }
+            if (count == 0) {
+                break;
+            }
+        }
+    }
+
     private void cleanupRemotePlaylists() {
         PagedSearch<Playlist> page = PagedSearch.<Playlist>builder()
                 .query("description:mc-vod-sync")
@@ -121,13 +157,20 @@ public class AssetImportExportBase {
 
     protected void cleanupLocal() {
         log.info("cleanupLocal");
+        assetRepository.deleteAllInBatch();
+        cleanupLocalSync();
+        log.info("cleanupLocal OK");
+    }
+
+    protected void cleanupLocalSync() {
+        log.info("cleanupLocalSync");
         playlistSyncRepository.deleteAllInBatch();
         assetSyncRepository.deleteAllInBatch();
-        log.info("cleanupLocal OK");
+        log.info("cleanupLocalSync OK");
     }
 
-    protected ImportSummary importFile(String xlsFile) {
-        ImportSummary summary;
+    protected CompositeSummary importFile(String xlsFile) {
+        CompositeSummary summary;
         try {
             Path input = Paths.get(xlsFile);
             summary = vodXlsProcessor.process(input.getFileName().toString(), Files.readAllBytes(input));
@@ -139,14 +182,14 @@ public class AssetImportExportBase {
     }
 
     protected void exportData() {
-        assetExportService.export();
+        syncProcessor.export();
     }
 
 
     protected void assertSynchronized() {
         List<Asset> assets = assetRepository.findAll();
         assets.forEach(this::assertVideoSynchronized);
-        Map<String, List<String>> playLists = assetImportService.getPlayLists();
+        Map<String, List<Long>> playLists = assetImportService.getPlayLists();
         playLists.forEach(this::assertPlaylistSynchronized);
     }
 
@@ -165,7 +208,7 @@ public class AssetImportExportBase {
         assertEquals(asset.getProductionYear(), remoteAsset.getProductionYear());
     }
 
-    protected void assertPlaylistSynchronized(String playlistName, List<String> ids) {
+    protected void assertPlaylistSynchronized(String playlistName, List<Long> ids) {
         Playlist playlist = null;
         try {
             playlist = brightCoveClient.getPlaylistsByName(playlistName);
@@ -173,16 +216,18 @@ public class AssetImportExportBase {
         }
         assertNotNull(playlist);
         assertNotNull(playlist.getVideoIds());
-        List<String> remoteIds = playlist.getVideoIds().stream().map(assetRepository::findCatalogIdByReferenceId).collect(Collectors.toList());
-        assertEquals(ids, remoteIds);
+        List<String> remoteIds = playlist.getVideoIds().stream().map(id -> assetRepository.findIdByReferenceId(id, playlistName)).collect(Collectors.toList());
+        String actual = StringUtils.join(remoteIds, ",");
+        String expected = StringUtils.join(ids.stream().map(String::valueOf).collect(Collectors.toList()), ",");
+        assertEquals(expected, actual);
     }
 
-    protected void checkSummary(ImportSummary summary, long expectedAll, long expectedInsert, long expectedUpdate, long expectedDelete) {
+    protected void checkSummary(Summary summary, long expectedAll, long expectedInsert, long expectedUpdate, long expectedDelete) {
         assertEquals(expectedAll, summary.getAll());
         assertEquals(expectedAll, summary.getSuccess());
-        assertEquals(expectedInsert, summary.getInserted());
-        assertEquals(expectedUpdate, summary.getUpdated());
-        assertEquals(expectedDelete, summary.getDeleted());
+        assertEquals(expectedInsert, summary.getInsert());
+        assertEquals(expectedUpdate, summary.getUpdate());
+        assertEquals(expectedDelete, summary.getDelete());
     }
 
     protected void checkAsset(long expected, SyncType syncType, long expectedAllCount) {
diff --git a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportExportIT.java b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportIT.java
similarity index 55%
rename from mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportExportIT.java
rename to mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportIT.java
index cda0ee67..a7a5911c 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportExportIT.java
+++ b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetImportIT.java
@@ -6,7 +6,7 @@
 package hu.user.mcvodsync;
 
 import hu.user.mcvodsync.db.SyncType;
-import hu.user.mcvodsync.service.in.ImportSummary;
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import lombok.extern.log4j.Log4j2;
 import org.junit.AfterClass;
 import org.junit.BeforeClass;
@@ -28,7 +28,7 @@ import static org.junit.Assert.assertEquals;
 @SpringBootTest
 @ActiveProfiles("dev")
 @TestPropertySource("classpath:application-dev.yaml")
-public class AssetImportExportIT extends AssetImportExportBase {
+public class AssetImportIT extends AssetImportExportBase {
 
     @BeforeClass
     public static void beforeClass() {
@@ -42,30 +42,41 @@ public class AssetImportExportIT extends AssetImportExportBase {
     public void init() {
     }
 
+    //    @Test
+    public void initialBigLoadTest() throws IOException {
+        log.info("initialBigLoadTest");
+        cleanupLocal();
+        CompositeSummary summary = importFile("src/test/resources/testdata-big.xlsx");
+//        checkSummary(summary.getVideo(), 9, 9, 0, 0);
+//        checkAsset(9, SyncType.INSERT, 9);
+//        checkPlaylist(3, SyncType.INSERT, 3);
+//        assertEquals("CCEM110180,CCEM110183,CCEM110068", getPlaylistSyncIds("Playlist1"));
+//        assertEquals("CCEM128963,CCEM128965,CCEM128967", getPlaylistSyncIds("Playlist2"));
+//        assertEquals("CCEF008678,CCEM001148,CCEM072086", getPlaylistSyncIds("Playlist3"));
+    }
+
     @Test
     public void initialLoadTest() throws IOException {
 //        Path xlsFile = Paths.get("src/test/resources/testdata-big.xlsx");
         log.info("initialLoadTest");
-        cleanup();
-        ImportSummary summary = importFile("src/test/resources/testdata.xlsx");
-        checkSummary(summary, 9, 9, 0, 0);
+        cleanupLocal();
+        CompositeSummary summary = importFile("src/test/resources/testdata.xlsx");
+        checkSummary(summary.getVideo(), 9, 9, 0, 0);
         checkAsset(9, SyncType.INSERT, 9);
         checkPlaylist(3, SyncType.INSERT, 3);
         assertEquals("CCEM110180,CCEM110183,CCEM110068", getPlaylistSyncIds("Playlist1"));
         assertEquals("CCEM128963,CCEM128965,CCEM128967", getPlaylistSyncIds("Playlist2"));
         assertEquals("CCEF008678,CCEM001148,CCEM072086", getPlaylistSyncIds("Playlist3"));
-
-        exportData();
-        assertSynchronized();
     }
 
     @Test
     public void changeVideoTest() throws IOException {
         log.info("changeVideoTest");
-        ImportSummary summary = importFile("src/test/resources/testdata.xlsx");
         cleanupLocal();
+        CompositeSummary summary = importFile("src/test/resources/testdata.xlsx");
+        cleanupLocalSync();
         summary = importFile("src/test/resources/testdata-change-video.xlsx");
-        checkSummary(summary, 9, 0, 1, 0);
+        checkSummary(summary.getVideo(), 9, 0, 1, 0);
         checkAsset(1, SyncType.UPDATE, 1);
         checkPlaylist(0, null, 0);
     }
@@ -73,12 +84,12 @@ public class AssetImportExportIT extends AssetImportExportBase {
     @Test
     public void deleteVideoTest() {
         log.info("deleteVideoTest");
-        ImportSummary summary = importFile("src/test/resources/testdata.xlsx");
         cleanupLocal();
+        CompositeSummary summary = importFile("src/test/resources/testdata.xlsx");
+        cleanupLocalSync();
         summary = importFile("src/test/resources/testdata-delete-video.xlsx");
-        checkSummary(summary, 9, 0, 1, 1);
-        checkAsset(1, SyncType.UPDATE, 2);
-        checkAsset(1, SyncType.DELETE, 2);
+        checkSummary(summary.getVideo(), 9, 0, 0, 1);
+        checkAsset(1, SyncType.DELETE, 1);
         checkPlaylist(1, SyncType.UPDATE, 1);
         assertEquals("CCEM110180,CCEM110183", getPlaylistSyncIds("Playlist1"));
     }
@@ -86,14 +97,28 @@ public class AssetImportExportIT extends AssetImportExportBase {
     @Test
     public void changePlaylistOrderTest() {
         log.info("changePlaylistOrderTest");
-        ImportSummary summary = importFile("src/test/resources/testdata.xlsx");
         cleanupLocal();
+        CompositeSummary summary = importFile("src/test/resources/testdata.xlsx");
+        cleanupLocalSync();
         summary = importFile("src/test/resources/testdata-change-playlist-order.xlsx");
-        checkSummary(summary, 8, 0, 1, 0);
+        checkSummary(summary.getVideo(), 8, 0, 1, 0);
         checkAsset(1, SyncType.UPDATE, 1);
         checkPlaylist(1, SyncType.UPDATE, 1);
         assertEquals("CCEM001148,CCEM072086,CCEF008678", getPlaylistSyncIds("Playlist3"));
     }
 
 
+    @Test
+    public void duplicateVideoTest() throws IOException {
+        log.info("changeVideoTest");
+        cleanupLocal();
+        CompositeSummary summary = importFile("src/test/resources/testdata.xlsx");
+        cleanupLocalSync();
+        summary = importFile("src/test/resources/testdata-duplicate-video.xlsx");
+        checkSummary(summary.getVideo(), 10, 1, 0, 0);
+        checkAsset(1, SyncType.INSERT, 1);
+        checkPlaylist(1, SyncType.INSERT, 1);
+        assertEquals("CCEF008678", getPlaylistSyncIds("Playlist4"));
+    }
+
 }
diff --git a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetMapperIT.java b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetMapperIT.java
index b11b2f71..3205f06f 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetMapperIT.java
+++ b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/AssetMapperIT.java
@@ -40,7 +40,7 @@ public class AssetMapperIT {
 
         assertEquals(asset.getCatalogId(), video.getReferenceId());
         assertEquals(asset.getProgLocalTitle(), video.getName());
-        assertEquals(asset.getHubInfo(), video.getCustomFields().get(VideoMapper.NOTES));
+        assertEquals(asset.getHubInfo(), video.getCustomFields().get(VideoMapper.CUSTOM_NOTES));
     }
 
     @Test
@@ -48,11 +48,12 @@ public class AssetMapperIT {
         Video video = new Video();
         video.setReferenceId("setReferenceId");
         video.setName("name");
-        video.putCustomFieldsItem(VideoMapper.NOTES, "notes");
+        video.putCustomFieldsItem(VideoMapper.CUSTOM_NOTES, "notes");
         Asset asset = videoMapper.toAsset(video);
 
         assertEquals(video.getReferenceId(), asset.getCatalogId());
         assertEquals(video.getName(), asset.getProgLocalTitle());
-        assertEquals(video.getCustomFields().get(VideoMapper.NOTES), asset.getHubInfo());
+        assertEquals(video.getCustomFields().get(VideoMapper.CUSTOM_NOTES), asset.getHubInfo());
     }
+
 }
diff --git a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/BrightCoveClientIT.java b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/BrightCoveClientIT.java
index 1f20e9b1..7f8b9668 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/BrightCoveClientIT.java
+++ b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/BrightCoveClientIT.java
@@ -36,6 +36,12 @@ public class BrightCoveClientIT {
     @Autowired
     private BrightCoveClient bcClient;
 
+    @Test
+    public void testGetPlaylistById() {
+        Playlist playList = bcClient.getPlaylistsById("1760978144285528866");
+        logPlaylist(playList);
+    }
+
 
     private List<String> getVideos() {
         List<String> ids = new ArrayList<>();
@@ -125,7 +131,7 @@ public class BrightCoveClientIT {
     @Test
     public void testGetPlayListsByName() {
         PagedSearch<Playlist> page = PagedSearch.<Playlist>builder()
-                .query("name:Playlist 0000")
+                .query("name:Playlist1")
                 .sort("name")
                 .build();
 
@@ -165,7 +171,8 @@ public class BrightCoveClientIT {
         Video video = new Video();
         video.setName("TEST video 00001");
         video.setReferenceId("MCVODSYNC10001");
-        video.setTags(Collections.singletonList("mc-vod-sync"));
+        video.addTagsItem("tag1");
+        video.addTagsItem("mc-vod-sync");
         video.setCustomFields(ImmutableMap.of("Notes", "notes"));
         Video createdVideo = bcClient.createVideo(video);
         logVideo(createdVideo);
@@ -201,6 +208,33 @@ public class BrightCoveClientIT {
         logVideo(createdVideo);
     }
 
+    @Test
+    public void testCreateAndUpdateVideo() {
+        String refId = "MCVODSYNC00012";
+        Video video = bcClient.getVideoByReferenceId(refId);
+        if (Objects.isNull(video)) {
+            video.setName("TEST video 0000 for update");
+            video.setReferenceId(refId);
+            video.setTags(Collections.singletonList("mc-vod-sync"));
+            video = bcClient.createVideo(video);
+        }
+        video.setName("TEST video 0000 for update " + System.currentTimeMillis());
+        video = bcClient.updateVideo(video.getId(), video);
+        logVideo(video);
+    }
+
+    @Test
+    public void testCheckVideos() {
+        Video video = bcClient.getVideoByReferenceId("CCEM110068");
+        logVideo(video);
+        video = bcClient.getVideoByReferenceId("CCEM110180");
+        logVideo(video);
+        video = bcClient.getVideoByReferenceId("CCEM110183");
+        logVideo(video);
+        video = bcClient.getVideoByReferenceId("CCEM110185");
+        logVideo(video);
+    }
+
     @Test
     public void testGetCustomFields() {
         VideoFields videoFields = bcClient.getVideoCustomFields();
diff --git a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/EmailSendServiceTest.java b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/EmailSendServiceIT.java
similarity index 53%
rename from mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/EmailSendServiceTest.java
rename to mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/EmailSendServiceIT.java
index 5976c911..8805d105 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/EmailSendServiceTest.java
+++ b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/EmailSendServiceIT.java
@@ -5,21 +5,29 @@
 
 package hu.user.mcvodsync;
 
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import hu.user.mcvodsync.service.mail.EmailSendService;
-import org.junit.jupiter.api.Test;
+import lombok.extern.log4j.Log4j2;
+import org.junit.Test;
 import org.junit.runner.RunWith;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.boot.test.context.SpringBootTest;
+import org.springframework.context.annotation.ComponentScan;
 import org.springframework.test.context.ActiveProfiles;
 import org.springframework.test.context.TestPropertySource;
 import org.springframework.test.context.junit4.SpringRunner;
 
+import java.time.Duration;
+import java.time.Instant;
 
+
+@Log4j2
 @RunWith(SpringRunner.class)
+@ComponentScan("hu.user.mcvodsync")
 @SpringBootTest
 @ActiveProfiles("dev")
 @TestPropertySource("classpath:application-dev.yaml")
-public class EmailSendServiceTest {
+public class EmailSendServiceIT {
 
     @Autowired
     EmailSendService emailSendService;
@@ -27,7 +35,12 @@ public class EmailSendServiceTest {
 
     @Test
     public void sendEmail() {
-        emailSendService.sendSimpleMessage();
+        CompositeSummary summary = CompositeSummary.builder().build();
+        summary.setStarted(Instant.now());
+        summary.setFinished(Instant.now().plus(Duration.ofHours(1)));
+        emailSendService.sendSimpleMessage("BrightCove export report", summary);
+        log.info("Test email sent");
     }
 
+
 }
diff --git a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/ExecutionLockIT.java b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/ExecutionLockIT.java
index 26f991a9..9e8f0974 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/ExecutionLockIT.java
+++ b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/ExecutionLockIT.java
@@ -5,7 +5,7 @@
 
 package hu.user.mcvodsync;
 
-import hu.user.mcvodsync.service.schedule.ScheduledSunriseChacker;
+import hu.user.mcvodsync.service.schedule.ScheduledSunsetChacker;
 import lombok.extern.log4j.Log4j2;
 import org.junit.Test;
 import org.junit.runner.RunWith;
@@ -30,14 +30,14 @@ public class ExecutionLockIT {
     private TaskScheduler taskScheduler;
 
     @Autowired
-    private ScheduledSunriseChacker scheduledSunriseChacker;
+    private ScheduledSunsetChacker scheduledSunsetChacker;
 
     @Test
     public void testSemaphore() throws InterruptedException {
         log.info("Test start");
         Thread.sleep(1000);
 
-        taskScheduler.schedule(scheduledSunriseChacker, Instant.now());
+        taskScheduler.schedule(scheduledSunsetChacker, Instant.now());
         Thread.sleep(5000);
         log.info("Test finish");
     }
diff --git a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/RepositoryIT.java b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/RepositoryIT.java
index fce3b775..8a694040 100644
--- a/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/RepositoryIT.java
+++ b/mc-vod-sync/mc-vod-sync-app/src/test/java/hu/user/mcvodsync/RepositoryIT.java
@@ -6,14 +6,15 @@
 package hu.user.mcvodsync;
 
 import com.google.common.collect.Lists;
+import hu.user.mcvodsync.db.Asset;
 import hu.user.mcvodsync.db.AssetSync;
 import hu.user.mcvodsync.db.PlaylistSync;
 import hu.user.mcvodsync.db.SyncType;
 import hu.user.mcvodsync.db.repository.AssetRepository;
 import hu.user.mcvodsync.db.repository.AssetSyncRepository;
 import hu.user.mcvodsync.db.repository.PlaylistSyncRepository;
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import hu.user.mcvodsync.service.in.AssetImportService;
-import hu.user.mcvodsync.service.in.ImportSummary;
 import lombok.extern.log4j.Log4j2;
 import org.junit.Test;
 import org.junit.runner.RunWith;
@@ -57,19 +58,19 @@ public class RepositoryIT {
         List<String> playlists = assetRepository.queryDistinctPlaylists();
         assertNotNull(playlists);
 
-        List<String> assets = assetRepository.queryPlaylistsAssets(playlists.get(0));
+        List<Long> assets = assetRepository.queryPlaylistsAssets(playlists.get(0));
         assertNotNull(assets);
     }
 
     @Test
     public void queryExpired() {
         LocalDate currentDate = LocalDate.parse("2000-01-02", DateTimeFormatter.ISO_LOCAL_DATE);
-        List<String> ids = assetRepository.queryExpired(Date.valueOf(currentDate));
+        List<Asset> ids = assetRepository.queryExpired(Date.valueOf(currentDate));
         assertNotNull(ids);
         assertEquals(1, ids.size());
 
-        ImportSummary summary = ImportSummary.builder().build();
-        assetImportService.removeExpired(currentDate);
+        CompositeSummary summary = CompositeSummary.builder().build();
+        assetImportService.removeExpired(currentDate, summary);
 
         ids = assetRepository.queryExpired(Date.valueOf(currentDate));
         assertNotNull(ids);
@@ -82,7 +83,7 @@ public class RepositoryIT {
         PlaylistSync sync = PlaylistSync.builder()
                 .name("Playlist1")
                 .syncType(SyncType.INSERT)
-                .ids(Arrays.asList("AAA", "BBB", "CCC"))
+                .ids(Arrays.asList(1L, 2L, 3L))
                 .build();
         playlistSyncRepository.saveAndFlush(sync);
         playlistSyncRepository.deleteById(sync.getId());
diff --git a/mc-vod-sync/mc-vod-sync-app/src/test/resources/testdata-duplicate-video.xlsx b/mc-vod-sync/mc-vod-sync-app/src/test/resources/testdata-duplicate-video.xlsx
new file mode 100644
index 0000000000000000000000000000000000000000..5fd759d64d379bfe24471b6bf4026513d139f753
GIT binary patch
literal 16773
zcmeIZV{mQlvNk+p+qP}nw(YFgwr$(Vik%hPww<il#!9|=_BrR>`#fjAf4;x(xvJ(E
zHSe0;b<e8qtH-#zFGU#;P*eao01^NI5CM#@b1n6O0DuHg000F539KVxZ|7oW=VGAh
z>0supNAF>4Ls$d~Oj!T`2K+DnpGI}cr2HTwqS%Y%r^peV^j4!FB->TcC^EGYf8S8@
zNTrER-j5&Od66H8!i8v791X~`Ti(of)0T~Pwyi-CBb~~y(Sc)qYWg@F48x<BWW5+z
zNlw~YHwCCTf=pNj2C?SZfDFgBL1k9aeIe;;Y)dqB{(!^WjZt-^-H~?KO6>}+vCaNH
zdG#G6&WWFkh==niOIAOqy!9Ur>7+oTiM_Yb-SkTpi8NKHjFsD+-qU4zoGE{?EE}2t
z?=XfXbi;4Y?1FdpaNx_aVmJPbdaTqQNwB8r_0je5>ZOc}epGz#U`Mkwpwr0{3?vF#
zSOX|pM>nI_Fx$=g4hf(Y%TC@75N>~v?W5oh?c$hr<i#hL%3~7S((aXx=7}nBaZm^O
zm5+`8;_OqnGQst+E1QQn0u_7xMtw#)>v-rBMjY=WBJ~Zw+8aCL@xGip)(O78OFQ#t
z{sIR8zP~{LivKMwThtgy9svM=EHD571AqiJa5A%TW}yG;`oHP;zxWH)NpcE<jId!h
zlAqyYFU#8rh{7`NLXw?Cs(t}dTL>+&#iTgfy%e~Js@TCG68_zOpA(zgys_tFM9&AT
z)zQePJS45|HDT%Rj;;{Y<W6bgj@A1^NN&qd%g>n-(w>xV-SN~_zbXo4#&=1?7w<$H
z5NGK%u%S>&al_F0G6S_o<g|8-Uu%Jug;lO<!s^>N3eJ;fv;9}o%Ff^fBDiEP7c$Yt
zoQ*BkYkkISh@RfC)l@9Ge$*T1IdKzv8kpMjJ&0!aqWtlplg}AbCT2x`WuBE7B`bLH
z*KTILo6Pkb;(!{g8oM12iYBPo0s41I;uo^V6$=6YTtfl?2mk=U!-m1#-pSh7-roAJ
zx>c=aYhTQX_~p0o2V%$_LpFf4;tU%2l)9ygdb-71xnzP#z5$xkBAZ;T<@?VFX~~tj
z>x3%<u^%430Lw!R*LPzL%|)ivuoz3jU8c28bz#xo^x@E#b6#<xEtOnWkZO?;%10>G
z$K>!$Z?1iak2dt3DUe_>x!cbtZYNwZ8Fds_@|Ehq+|&fNdB)WEIBgkmXf@`ti-|j3
z4i~Ed9Pe<%aTUfPt6?e`Fk9=DQ@jXMw0S{;RG%8J=Bzwm4V1T~S|qe5Y{ImzgZEO9
zmYOW_^!V5WQ?0;F9b8QvC<RFWOX0&OivE>(CAM;9%7z6Cz}2NB!CSl@#32IF8vf`W
zE9q|HWo9-mzUKICa`ga+`YU+Ywt@H{VU0Wu66j5`Wq)9{g+Wf8$MCh=Ld%%fpVTFC
zl~h|b(X;BkEHo5vNR<X70(8?(d2RjvT8ucpT{n7or=CRhe)W=?N8FIDK@qbMLo7@g
zL~-38<Typ^s;t;9zg{jh*j9}cWPqUC%r9@!WWYng-hmAY$ykYHTt!@dv@~X|Em|5y
zIm}a&W3bV17G5RMSw-cE1un^m?8YOBS{9P(Sw;*4Cy3EdsYJUolaI1J5QNB9M8<*a
zueaCZd}C7Iii&q@+BY{F`ef=04cLvdlpu&IUsin}-v>h=z@;MjdB6?Ab_N5A6Z7B4
z6d1*&GKMIhw{Z^%NBbQf@p2N4M8STzwrhk1=B@FM?O9%A*?iz#iqkRdSax-M5HSBi
zkn4Tf=Crx)<C$SUmlH9!vc2(CiI6*)mk}7*VXUu_Yjd83(HnRJ`33dSB7o^n8%Pfi
z&W|Zvh^dY8!6uu;I17y7X@Wr_fagt#ALoP`ZgdTQFsIO6P<+^RxTx3CS9MWSMiZ~&
z{Kxp$qTH_7TC1t)OhP)?HS=1pxRh8SuIwsST*F0dEZF8bO=%~7%2*)&^R~xnobQo&
zFyM`(fCG4R4%Ne~pHZd>^z`ZYTR=BMPe}9+$5=gW<dU=0DT+_KxlJk}nAHXssLyV)
zT#(WMd_YnDA?};UC2>S;d=M)Es7Q`{6QMte^_GF}eFrwz_GZi}I`oXHBS*Y!_KgNY
zbk+6%zXAa?LslvI^+((H^euW<-CE?x+jeBwV%_S)1&VE5<J+LGU!|i@Zpq!*^PLU)
zH`{E_lLV&#T*V^UR&%awu0A=&H{jo8ZXkb3`U3y}=l}))umO-j9ySdBQQ`hIfB&o6
z0Z|qJfc{_S{Ay)6nIT5RZkVrdM)zztG^BMG2I5P#3k1mVW~xncA{M{LT^#BTJ<Syv
z1`zu&&ztE{w-+|}0}zy_ewvCXWKb^@n;RZ5`{{>i5J=;z8vGy$Fcjp=^NXr082Bt_
zly?54G1@#-&fl+;WLV+FWyGS7?F(V7Rx^yQ%vR2GcoTA3JCn^v0q-Fymo-7nZEb{E
zROZLu?IN4c;Q2wG1oIDAP*S{bo`Ct&B_f*Fez9lB`>s!OInNpE{^EDoW85kk{7N=H
zpD-7~@G%Jjf2t(s<D$$?wVQnx;g1Qb-pza3$;TV>qw&$@-G3W0#xq3(7;pf<jw}Fx
z`A@QUwlp(yac20(jp;Ae&q>*g+h9ZtyP<i)Bi>CO;z|JRuVt4}(l{4eeyDN8t!Iz?
zX^XD7?0&;3(Mp)62ZafeXV3faJ@e>hfWCr~92IR9R)0ktt)^<)r9D0OVjry(Lt849
znkcMl69z9^xS9QOQ^rF?u$;wY3sk7g(!Aou;)pA@T1`5Ej-%c$(4Igxf2&rD+maY#
z>Z+{8nRgMFn{*4!782PNMs%N}!j9ph(<se>I1XL3|7kVNQCXb&h^;Gibm+!XRI~*!
z9*3z#U_;d+%jK=6CK_)H=y~BJT-uQF@VtHQWPZA#NR^f^RU}?zPssf}RenVwe}K4=
zEdS999SkDTNMQ$xtGKfn7c!W449EB#TknX#a+s7%H*0>XkRW;pkT|21=HrFFR<=*s
z@|To&7*n_jCe1B(e8t$7Wr2szuB9En$LbhN?liz8IWgDfIfby`acyp8)$%g~E6x%^
zi=m}s&)2NI(NYp*Z#Kd0L_L@{<?qACh^pWoL?u#vpjf%o-vibC?yR+5QCvKW#;@xH
zp|wi)Pg5UpYNUI_X!sa=wW`@CC3>`*Vi|{bE~ET~F1@L5S)qy=5TH<X^!q*VVyq{Q
zC-3YDmW&;Ki^(QT#)FYRX0w?bsG|}^)?E%b?uyaL_mg(GNT*cnt!eun7HDA!G6Ij-
zi;UP32~j5mqWP;Yy;8)))ipw|(pq9o?(_85iA;oJbif)B@n*CLE`R<enfMYjp_|C<
zWgkrOYp)P}<^qhJsaU$l?OgR{(Axdyp6a*^D5IfV0OuHTxDjJqT^?*$xaVQH&=v-4
zC=cCq5e;r0-Y}Q~)+|RTgkEw}mM)jVR^%m|y#JY%%Lu#vWlZ3eM%>)R?|lU29>ukr
z5|-#M?0lA^)M<$B7!v_}Q!anla=(&KkiV$$AHm+7GwF0Fjx6S1Dnek01p4Y!!BaGr
zM#(Q0g-YdEo`CjDdzokX<YE5h7XY51=6X{aFg%9CgIvxGGd|UYh~MM&arpE!x_Uw|
zYf#(c|M60Olh2S8tziG{^L0V@U1#8(8?E5~`RX%&^_k={;O}&LY+x_Y^T+e!J$@I4
znB$XTJkP-I&sDF1!LGjk_k?Y(K}UBqg9byWhQ_ZyKJ&e=DFhyqHU9o*x_V!Kj?eE)
ziAQ8fnV5`<a8L|nj1fhpOb)UlY02#}PKSq5BK>5yn3*CXu}}sxGFX_RBEe9gNL{HA
z$Ihh*6INOT3G3W}1BdKDfit(EL6yB35XY|M2@|%u1qnM5VqAziAp!;6;(-G%`Jq7@
zKS&YBuB8YQ^fcIv*6{Tt>#8;wjR|{et%f23L3!q*^v3E@rZa@2axF(uoi0U1$`VW|
zw3$O`dFE57O4cJ=WtnD+m{g{kPNz^GXth~}d82p!TH<1vYC4^PeW2Z78RU)rnqr(S
z68dXt4)%don{|*k8h@H`wn*x)rG=@JH)ae4mAUItO3Qur^aH_7FUmr)q|cO9S{x%I
z`GLb=JAY8AZ)#ydINepr!ab?-U4=zc&htJ7XA~u=mB}QfHl7d%6(snHGj&2mIhH`d
zf_6c}QJ6qMDmpOW)Ml&a#yDjZn0LLL*4Mo<-i)wb0n{_~kZ>)BSxJIQ%hi}mFyPSp
zxfonf;NI^BEYIr1$#da*C^!mMPKh)otxEIpE4Sf|Q6X~dviRUBZt~mU;Hmdgeh7<h
zBXn!9Ce7pQVd!mI^;L5uv#rs>AFjGCo^8nmh?+>*8Z>%Ms!!O*2oQCYYy8ZW#)%C{
zEvJ>jjwL#g8`M>jO%=eRo^Ujb$U$8i0tX5|2d++{FZqZl6CZ>T@im0|h`<@iYORN0
zgxb=J4z@&>6o^jC*8%50sAnKU1ur4Hra*!9e**{R>9dkdnwu`iR2MG=Acl<I&Q{!O
zGQ7S)1lWkVU~;_x2U68ri$4Pg?)X^lObQXsRY?R2;_$CToB^=qEgj-$O&Vo6SuX+%
zB_TjXxCQ5H*t*~mO+s&612Ac<>p;5liN2H!&2-NIGkR4<bs(soBs1AA0qR=5Sr#-B
z0*Av`1<G1)Z&(TqqK<HPvsv{WMOgXq`|%lfp_^gRe~`HZ4hIjdMw}yvc4(^-Uo3n?
zb93(wVjM=I@q{p@L4oC1EldMgda$(ENvh0E@k+tXeLP^XjaBd`X_jmG!Wnbhh`DDx
z5^1~CR$?y22y^bHy}2MkExH69Mph%HJy>(*_HeaEOfwxU^X`HQu^2G3?ofTD({vg&
z_dl={rh;gTqC7`dt7fJ>?!6?^D)o1JSIX61OxF{|RCg21d21T29#-!@CvRgAK1Esh
zdsp5gund01)*Xh=As_zN=A#kklvml1XI`%%%ckW-$+UX&OMh4ZoDC=T#T}#^X%M^O
zFd+3uVgA}yfnNHwzWTKOijtM#NciY2xBjn@Q6k{}zdl&Ie??pA>s(j5NbHiHJF2xq
z(P38kZ%zu`LtSS=jVEO{BNn59DvxuRu(BRQ%k#y&8m-S%J|>pNsqsd_=nCt+_oqs$
z^FuBzwGSHas3xQnIgMw!j1TmwxT5H+tHWF@8g2h41wYZm-?JTu{BH66jgr{+5E}$U
zaG{&8_xUA-qBAlg9=cK>;gZ}QO}*wjt6>q`RdBfR%|f<N<lnMPjPEDJsFlHjig;Pw
z)mh!u#YX|$A)|)1_Dh}zw)jZ+$3pFa>&@2vmtvHt5x=)_t%g8_tAzsl*c7H6<$sN|
z{}!~9ts?J=0uyE=MGPVeEI3tZ+)5hW=>OIdoC>0q*+GC2oz6jly!VnoR~mBh_NQ?Y
zi3eyist<oXCuoWR3wf7eyGlHhfD${PLWzDQ4M{+X?zisSha+<_AnrSoA>tDI@4(or
zEKhv^BPm&c1sx^|R?rDGOrZwXsYfbOA_5BqT0S@amGwy=z)1MP&TAD9A@@5`x0Hwj
za6O`}|39`41Ih%`Nb4y;i^%3IPdIjgrzMKiBp9)kAlPhJ9n~!up+<_>Y*DG?ZYm&5
z2rQ8(2rD2?2;J5oNcxKDugiRbM$B7_Dm)x;@pO>|g-VR$cIR6dF@a{B@EjJ5^qS?w
zs|?vf=3^wu^g5DYe49!%yvHLF)t?@w{i-Da1)K^QzaI>GjI)ca4BNxLG%#BW)>N0-
z0Y#t<DzH~Xf{j0a8xn?sokJqCjIfVKyn{FE-aqGq0Xyx!5x?BoD<V1-L+ji~JJyJ*
zHJYBiT^Uvh6pz!I_1G3cITuE&lL(D{LWfz!E-<q!HQxlhfvA?=bPt`^Q<z_WP~^z}
zp5dtfE7l(Jj*}tt;gFZNcBDOGe%Mi;rT-$on_nMiOH}nv^cTyys{~_sId1$&`v!8H
z^Y9+025j5|`cxxWlU09pF=#(0Li|2U@V(}%E@wZ-Ya2Dc%Ubt6NMpTq|K)`y`;5+C
zf2CMEMC0w(=})l|6nZE5>LLaBk!G8LNzK1#sbJvHvf;X6+&uRnG@zA}WHN^qrm-TZ
zOo5`hNQUTikF8Oy2?H3q8EL)H0*o%B(rMRsL08RgRp6|F8;+d2Xa7OayG+=%Ncrr?
zqsbnHav14%#<fUKHO(ix-uXAIzE7FPXW02-0Hor%BG4O)lQ#ufKZ9j09JD<o+3VM|
zTnyQ`VFqb2Xs=G@M8cd(8*<P(e=?$O)$FE+wj?CAClygfT@`!Yies4|)eg_E#Opio
z#Gu>70&l4Pr42R3ubioL2tVBB^gO{?0#eZ4cOl{1DgrXl-glF1KE9Uq#h=r8_x87<
zoeLT=CQ|!-IgnAVQbMG%%=kTwHy<l9$#jn!L*%>uU+kzVJ#8^bxu`zwYJNJGIzQi4
zz$`lLiwn5#E~wl`b?)^{bv7zhpA?6D7uN<l#DaPm%tRg~Gd&D?zNWkD+*sZ=X5<>s
z(F~%)3_LONy-$j?{g!+mu0HZ-k0rLh>*{(Z>r|Y7JT4YO#0tnuQwnT05u+g~mx>aq
z|HQUZ{0YfZr%X-yGbKo}6jhXZd0??f+APKXv&)5wNSO)^9(;a-_m3=PrD}@!YlYl(
zpsMs`pqjK$iLx5d@wb;kSqe=O6<DGyRfMUu5UC2?^J7V4q`^uaX$XgVPRT7#Lx)*0
zck!$>#Xx!j6~E9|n*4Q?S*07=7;2{7bh;7?`}F!zHcbN6)5YGdR8@uC{p`7BSqKi1
ziVHo?&arx_^cd>fMnhfq<1n*W5B%lDSlQ^D>cmp%_jl4K!vA?1Y^0KuRd|x4m7blV
zQ6H0%qiIlMo@3Earks$S4QP<Lhv_RSlZKXhBO`ljXVe$BGM2VNim<3INl42#06sk3
zTt7`e!7#(HC@D)@`|HK|e;zOQV<7g(LjV9HgnxB?{&8~VVrgb;_8-@OyhmMXO-JK!
zp!Q<C3&1+Nf3h9MlkM!y+9Yq2n&zh9wzOU<sk1OAb>W}@lW{#MQ<jvb3)}OhEC_<Y
zbw9>Kkv5+Z%u`ISk<=WMX4^<>yTL_Ee07(XzvTIOJ-FO0bZ2-;WWWq0r5W@n-t*<e
ztYwfcrukcQQnLCeNT$RfnL*jT!O(unZ07qpA=!>Yj;?{ciP{vV5lC@uQlk$;h9&;$
zGv^H4C65`E93aU@AH~HB-pN3xDOIk)BuRSJ4>DHt_GKm_xr9rV_V@nTrLfPGC=3@v
zxvNpxKvvjrIM^s05qhe8jYqU`Z<NQxgMZ+?@Ir}<>}UB#_U8nnjRAdLom})7Tua2R
z;G4N!*3d_D-ueEl-)eynGFaQY)BvPHcl7Dvk9KeCLOGBnYfx%g>l*h(s$GH+oZ|a(
zVW-B8+9dkUoPl0bJ6>gc=xTwge|;DMY{#A$Oq~!FzwTgou6en|#cBbnfzIHn%$2@k
z+oQFjsFc&MF#6CIEBE#dG}D38IFudOV4?0Ls#&E3xT;HK6<JMUj$`eZYi52x0I)Kt
z)WP^Ltil{*<F9B+uDzj6vPDQ_`!Hm3!(XaYaMEh8b^L)}Wh7CpjLapedWMmjILgl+
z#zW(>t)Dan%N&FZd3@eqw`ULGy?p+Ur*DG>jqNSeGIkJTDk|5@@dn?2{$T7F^nTr*
z-*KERQQQp-^?trhruTl|aX-}`Y@spq_}<^2C1dRRKAkAU<85r>;$_?tMK;{l?wj0@
zM;isgf7}5H<PI?k4<!jAow`+APmTfW>kys~xYl0{Y~pH;fOYZqTCaBy+_jU&W!8x|
zfNhz?xM8|;?^R|^-rhRo$!;e<v`2PE&Lvu3(@R$aUQSpFG!B&4W9!X+!$l!SmT~qk
zsPs07#NbtRibNc*@-ZLC)<-^GBi02+ERu;h8Imc}H;WiYOb(b4hHTtV@7UH2R#-3d
z`IwRz=@6bX`bGRa9+|YHSGrW@5@lk;>xni!Vs`THmmsfYAQknBqI!5Yp$(Dw%^m)P
zEz}DQdkFu5uQ$Y=B;$0t&>oG+lE~+_7OTkXydj%3HsnVRPb8M;9xR376Ti+Q$|r)W
z*vPci2Gu(7$DH^V*pXFM3Pr@b*$iGoS4?I%0ftLZeYDvIZ|hpibR-K8_ruTBjZRDz
zmzWVu?>2sC%{e2M$&>bZ4PwJoyi4h7nz0$RryN5dv!qJv6)LB6NE)-3yA<1c3wy^P
z4|K{%q}`G?Y|(9LJ<j7CRj=GQc)2|`;A4WL=tZhkuv5mQ&R(gDSV%34bT9O4A3X;e
zKl`RpLxUZ@s~%7+A1f@v=eFl*L?!DWUZXHbXjqKxpa`@tUD4bsZJX<q?6qum1Q1kl
z^=_2pquAlu$VQ4!_X&J=AZKu}c%8eC6z*(FvlG$4Ca4zzT5B)MysbWmq-y6CPc>)#
z<=5|zO7lg1{yMW6>&yr3k*DV;A*;+TpTG(7oBPu|g|3EU7NV5vNwDEgVRv89uK5@U
z#)?g)4vKawpc&%VEVc~VtrQZvLq~D}3g(UYIaqBGv+cf|DA^}f4;JzQlag>(8npbm
znh*I0kNDU{d5iYyj;x<BU`cNtRJySu>C$DV+I%-VHA@$Mr>gE+>EM*>i<m~T<~T~O
zm`Vol!l?QdA^Pi?n)5E2^NQ!`h1%kd$Iy(nXlNeC&wFCs$KgU7LSg2(DJLdq<;|I0
zF}2V$nc`l_EI%`W6pa~J2;*H;);k<Mtz3Upc8itJk;J$(#WF5124U>e@=T|FXpMAa
zhA%NIv>UhMII*0^A|P3d5mWpMBqvvy8{)BhYq5fCqb6asenUCM99;DPZzoyO!6;Js
z<%T7dXZPxEl!k@T7%rN^t(z=A0nU_|;hi!>XF%tl3dcH+TVzY45rD|AeV8RkLy+x=
z=)yDR!Q4;sBWxQ}DNmjta9^d?;j40Z7q6Oh9e1FcAU3`mg!_a8sYFwgfd(QjG9WtG
z>3o_gFuNWt@%YXCz;MEHwJU0YD<zJEJ6h4LD8n>wfGx6iYF>ec08?Q-tH1Dqo;RZs
z<hfg6n}c9^!WsO>Z;P^F>hmR+<g;*|Be<%2k)=lJQoBF$bWXL_^zHD-%bwC*`%Avj
zApMMV`BThtT3zykQB6%so6Rh=kgy6%?60=2;+%YUwG;wlxl`J%g0vUXxv%dNTV2cM
z5blAzUJm}8<;tgu!uIJTl<x~TV=3&0(Obz{v5>o6ToiQQepEIP+tO=vDcDB6h^oQL
zg-EScp>CM!lYi=U&t0hz_6!r1bm12--hp(D=EU57)QzsvUmqURO@|^yN6Q*aVYKYO
zAN1(1`#9bp5$1lhOcZF@x><#qxA0MdcFPyfU9ND4>euMpz<F)g&*Spmc9X!tZ!Fs>
zUT{FSIJN0OT9KLg6>C*Mq)PKtwBh_I_(MozVt7pDYuW>NvFdF7{<n>*;WxGRH4p&c
z1pxqn`;YSL?BZ!-=KR+I=9Y$D{01kgufdORk)sz`eo5v4NHr{S<x)GfA7#o0at8rw
z{-SZ2VR~2oH!UcV;<>=3I<3?ULmV8dqbK_L*0cI-Ia~^&%c@bRU>y8T5o2aT!`xy7
z_$=-*Ioc*lhU8#U^Knb3%b&9X<}Eu+_w_`gJcz<eR2!Cha(s0&93hAA;_9M(*~-*$
zY_Q84RWxD_O4;$855l_&ym3DTZ9}MLXQ2if-kWQ-bnl_9JBnh?b7Mns^AvWgLsdP7
z0ahrYobFkKN`;FRe@Iu}mw9u3ORqF8aUiZHn@Ks}vu#Ck+&Sz>1dXMOK^xB^<kxg7
zVTecZise;E5oFCuQ@LCnInlU82?MMsGyIV6o5rSS#vD%A@|XR26fy$I1b2MWWXMyC
ziCp_~S|F#SE*!(L^r)=1q^GDhTYk@B+O+Zr$On3xJi^AIPy4ho>kIhO^O(UoE04g#
zlA1RdX3Q3-vMLb=2QKmnTvKaS22|P+>GY!PSckd`Vdj4e(P7cSMm=pO819N{y0TM4
zFC-9)NtuEm)MHc6_Pfro4sLk~xWgkN$;m-=e90loktaL4;Jmdd;gT2D)O;KJwdj{p
zHVJ%pzBM-sw^x@?3x2-SHE~Q^#H3(1mYjN-e6>`|&XlYWB0gvd-DyKl$+ol!<@rMu
zLA_@XcLVuu+B0-5H*V_XLG6kOoLMtzLQ?1f{l-6*+I3@Ms4LY$RZKw{!JjhbPlL#d
ziDE4!Y2`h9hfAS1-MW1HL$YM^vgWi1534a~X?tn3HZSIwTgEGU3#*3M4G9y{5RMig
z?Uv8;t8(pnJFPBa!e*0s+^R;L>wSJ8O-{gX`c&J&Sb9eh#A_X1&SIIBgBd2Wp|g`}
zwg^6fp#K%8$dR8$moI5V*^>HLwkVF`VMA08XxbeK?ARJRVjZ8Np#QqtsRf}vHcsQ?
zsR4_RC%(=86j=2Z3mEHLq4N`Gzyo)tjwnW>;8K~Y19qc_MwkGXb<?8ed5#s&nNne%
zXEA53z_F$^r9bi_lpTgCy3Bs-xu9hF&sgi@Ag$sJ7}Z_c+34UT>eH-$Vvrq|q~ys{
z9>0{WNJ)jipY@EiknuY%<l81TJm>9=4Vv7%z)SSz_&q<&c0(^_=X}J_HK{)BHfM(p
zZTk8U!k<omh_+^eU&ZS(WHx<-Su3!1PL(<~5MPCDrIw7A`<wJ|_2Fw2MhCrdAiLAz
zetY6j_??HQsGVB4A(N!qTccXMefS0*=?~q6miD3GKD^5*DB{EX8XvH5H3_7c_*x-t
zvmvXyYbOT(_6Z!(grW5h3IK4<3;>}1Ck0p<IhmQNxH$c=v-l4t$d<Fm9nBoQ0lLSN
z=Dp;G6iaM0@kY}ci6EvLIZD`zw!I3iIIBIQl6PM%F$l}zI?F1q_lBzX-ZKNjcVPrQ
zHGEx}!<eU7-&NUWDJctYOlV283E*TZue><^dGaRkePWOrZXlpw%*L)|r}w@*F|zR<
z#r$JWI9uGHCMVBk_m7j<aj3iqUgwfe3p3N(#A>|XM|QZUK4p*GL!COf7?YR7jXplC
zY|#T72Qw9&Z#r4W-YjiLdOUOSppT(!;?T==U7f!l!#um5QXtLZK~<^(2fMmz=7vDJ
zdDEBKAwqr)uUE#V1VXe#xOc9FcjqXD#rDkC%AogfarjF~p&c*%;?!?(zWGqCg|uwr
zAB*NEB~9-2&aEFMPxI<0uLa)Eh42!cI-?dm5)kF#1gFoBk9X^K?jMGZpMxZ2e4HEG
zTs-T1>(*DJ95;A2ZqI3L1gn#sz5!)}5aFCw>feP*b~g7X>5F{Z{#~xkzm{tTw-19U
zbS$>jqj!(*ny&lz@2>CGpU-x7*45oDe*WCKd3tRA*w-IbK!}s~^Q-UJOq$1j_;b0D
z_WTiXXQ#J&5I~^0A6xtu;kvWoeP)&Z^wpPTf74^?;@GxLpVz&5cAewqrajZ^Imfqt
zo|lu$%hT0z^}6?H*|a=iXd#iCyiF$G?CjR{<U9Gp%}#G<e`dX{6T(|(`<a#%FQ1>E
z|7^~!%XI9jMt*bIeI~B;dF@qb(wPH6zLP>?b_TwckMNS-`HG@Eo5IKI*=BrB!7aX(
zT>)NO#SeiNFTXkPYQ*Tu#x=fmhTZOL@%4Z%*XP#HBLExsg8xOpJW0JACwYs#Z(54~
zPll9suAS_HUGx)atLJ><{O{i@UnAgLmy^R>-_4!h<ug5AUL9-o7E%7w%S2Rlnl>Bk
zp89`M;BRQzeNMJm*(;O7&gbHmysYu$!q1};uTIlu$F~G_D_zW&B-JH03{*DRN!mFE
zEyx+&Y@AA^Ryq`G4PJEBetPOx7#l9lmHdoMomShImK3a*K-xCZL2cmj?&<0II=XD@
zO-!BRN&PnF_WHm|4fK_zKi^e$9q{<zZVcR**Rot-TMi_WRW&-`%&+;mj%t0jIP(hw
zL>--*&9QXiNwoCZxbSB6Jab$l6~BE=Oud!FS~Arn>5_eu<DvRpZ%3m6C)=Y){MeFJ
z>G#{1DSEA`YOk!u8&AD4KN-P#2wh1>pM!L`Niw?GNDf9TCMDjev1qj+%W^u=fX~%n
z`ODWE?eq2%x$mr1m8NLSR?hyEe(!14O$B@k<9%y;-)|esBI9C~v_n<U8{`Sh8frIw
z=D@bt`F=qzM}R%KBYtw6?e7Ip95#`Nd0KS1y_goU<xm-}GCwSqEVBrh^x?wuP0o?^
zE;Sqx_{#`{$*GPl^kg-(4c@(_#>jko(%uawI=bNR?wGZpn&9GK|C{FekNT;gz!@Fb
zw(07;4A%K|2gfb>C<XL{&*89I^j+NzzS^s<wUxcyk@O3?x?{lzUOXT&!U)_OcPHhm
z*Git>D#?$s{5AB49*)(%>EOXY;kFpsCFdRq@h*aF!di*hHa6<`o?99IMIp}@c{DI=
zbIm6^@ygDHt*+v%oB?`1Y7SQ@TI4NqwQ(@Hi0dGD)Zq9!8o%#M;|u}^H-mt~FNR@D
zhEF0JRed$=$>)jsYv~<+OOkQo)u01zHcx<Im?x$5&B++E;--hpDlHBU+^x?EyP0HI
zFv(U)HTdvg!Ad^cGMTK;nRt?Vjd{TEftp7PE|+*-;yyPkqg*5RU&YRf5^gTk#w1qB
zyTQ!_4}591Guv8{G+oCd3Z*M$2HelX3~SZ@oKu%lqUut_hAw9teLj~$JH-?gmnpCU
z#e|txge_-Rzf-B>MgYa2@C?C{&y;I_Nj=?KFB=&yH>sq{s~Yz!^Qpat%M?L9JXfx!
zRB_kpBlPEI(@lt?Xg8iaWsP<?v||HSWSJcrNJ&ukZM*YgQW*ymnz_uVeqz=Bw6Emw
z5U!B-(O#$=mDkEJRd-B>3f9}Kz3qK5Efd}xum`z>cEV6kZ?E*DotZQ$<7%sqSx?#p
z`<=*F_w$^AD^lf2&SnOtj8$->ufb*gw^{@SJIvI!LxoAqdzcu78Mi678Hv5E)>CE7
zB#^8cC}#&}4gIF$Glzs23;|E5v@I*;dr}YSG`NSRT}%Xs7Qgd?k0yvMX*)qe`p&^8
zaQ{TGz#XiUbwyAKj6l|miHW$il?Jo8tOu!PVSf9Nx0fXP-tMiR7X<F)Q9N$>(JJ5}
z#@L}i%I)Cb4GbA1P5rBhds4<w*b361UW)sP8F+V8RuP?Jut@&VkBc<1OAvhiXMLD?
zdjZ-Uv?lAicWcxIs=;F76e+OHdMxg540au~y<mwB;0(eqNplhKp}Ydb@~G6eMf$>!
zZ&>eFf6QjO33zhQnv{09oZ)2eO}1idvL!5-F1GAe=mhu@3?HzFIEuSpQy9Ixg)MgN
zFjGD*X+8%a=c2&S0#mktB!2Q3!@DE)@pdXn-S8P&KVMep6*E&esM9&Uh)(E5Z-FM=
za)kZkr~9Q&jBlYBZh>9WGcAq28$R1?Gxpt3TDeaV=LL6$FX$p*P*>>3MFh>OSW|sd
z;U`k}b(g$G(_gu=C#C?+C%j51Cse@{EvMG=SC?eOwG#cWLHR)9GSZFvmX;PBmi)fc
zI-AzvK|Y(xS@o-n_0>NN-&YT5y_Yv`?k_yM3{(OL^u|BqxX(l#$h31VDmr4Wg;$b?
z!QZY8_C)<vv+dNRn}*@zrS4QkyJLo2uv$+GP6RMWr5v#wO}X+(PR2s8p6YLzAeR7n
zW<$xGDN~QqIER)C&M5EU8eYuDDpOl#nrm4MXfP(qc!|1*N#iuG+hmWHv?}jkAlZ`i
z?7qC|)K1F&lsbp$b0i-=Wm|>9FBL}3uP_;~{;brjfvHnd$P%pqx<cc>Wdf&<#nhE|
z5#fQ4dkD}J^uVK6!^}%qjMkS(mV~PZ?CTO@Wqy!<Lq3Lco6)o*4)s}5*=9hp2Z@Qs
zQ>Ysu(itK}C7|5`Q!;#7Y3s#`)6>mVP2y7>yC^30s;YPA{l*@7h#G*7mP>KCX%j#+
z_yP?LT(q|wKa(;JJv?^ESR%EGahJV}u~+OUMOnj$HK7Z!$kJAb5Kk+Xy`ugkLsB<x
zM8rQmgTcep$0)HyIV<!*SJ-l?L<^CX{=6=E|B*Flt0)}CDa|{NN&|mb-}8{C?m&~C
zYmJ2=g1MhSs(|ODDAwurrM7K1|5cyX6HL2Dz{a2$N;jct0gaK&y)~$xlA3~Ebv{c*
z@7u-*bpUiiLxGSeT?l;OdWx=V_FB1ofn0&&+H%<~09?R=*Xw<k|BLD_5i63Y^2g0N
zeKH|3x{`!43h;r@D_QWS?(L&_`*uh;sBxyJtUTOh@u=d#GoZoUlMtP6)cs4e$~hSh
zNR!AC6tlB)?#DjQL8}<}`g2g6L8^zoJezhO^16FnbuZ-u@>1x|1(Euo3llab1PwQo
z5@|^EKzGK9E;Ax{WUrGa=-%N3o8MTkFnRDk1^J&`4$==&*%nJTc0{4Fke~)mpNawq
zZ({UzBj7KvXz^Pms!vTw<IrYkdBd)$Fm_6lAQj@;M>S`iLL#1TVaHXcy>hdI2^%UU
z#J%r9<4O4+D!=*)V~0-Ab$Wm5A1|w+XAe|j*Xf7`4Wjd=fI!$`nx}997(D}U_DuK=
zRhTTynU#LmEA`pxuqR<NOzwASPVE0NHbJIgBpa3DP>j6?SEk|8NKm*V7+=>Xu1I{<
z)D^iZ;~IYA)d$WsLowi*Yfq~YCAw!4rwi#xhkiLpSF@s`maJpm=i#4U{Ta6CMpVlC
zE99iSk$>O{JmW(+Fi8p8cLN%STgww=B*}z7OZ89wl>3F0f5VzGO|h(-dwlbjJeYEb
zGOhtRiSGwd{I7hnOG#wqP)7M;8D#LEXlHa3F+P^Xb<+IET(b~KA!Fr_<mg<kMq-UO
zU6c~+q%rr2O*tVUTDvl13(1@{p$08_Bw^EJVo_m4D&AP7`|eO|hUWtABuOnOYHH0q
z<FQ=hNuUC^soBJtN$jGqchE60=!v|(Oi{_Fw8W%Yjn3?9(^UA$3q*aV6bHqRc#gku
z`C3eK{Z^NliUZAjOGLW5^s6p%5A*zJKxV;g9Bl)f!>4yh!1NCu!%*Uwc5P`EEXZ+B
z4Neu&6@0}>bWD{jkKQp}R(n6Ya_0<p+jByy;fFLY=h#jlJ5}(G2G5_24;MeK12;Hy
z|7<F{nv2aQZAO>BAmCTnS7|H~auh4wT*=J4nx9XP#&)b-MCM?6@iP%vO92nq9fgd?
zWQid1Y2~~Pg&5`PbXDyT_X~*G2?sMWfky0?4S>4>{bsDR6rg%EheZ0hQ?i_moAn5d
z1~WZP?SkX;g}Wm&oSb1}XlR0nvxcB~=B?~Dw`{HMu;5&muO^UJ)j;M&0ygZ0rt=LZ
z8tZ{B_H({*r{~BWFO@QQ%1h;zII*ZZwu)xo#&N$aB~&!hz;>qItY(eKH}+`ZjM`W!
zK^&>KY+%_YkTGmjA@o}hNlqnQXuxaCh;DZKneCRkjiugT;AbeuCZKYLVzS=W*Vp8*
zY2`T6W798_6a`eRR;okZ)pY^AOif!awjpx~Y&l-a`v5N(*cv4~M}}-3y-TSP6uASH
z;G^e$?T9}h(^-Wa0QnIWA{j{F3a2|t?(YQ<s!Pl+o{G^0_nMLsw{t0I^LxYK#($44
zh$*Laz2zuA^wSr8-~?_ir9P@GLJAjw6Ud1l^#$if43NE88xSEhv$k3^wTvSch@{{^
zRV*pdh9glr@XV`^$e)$gVdEHYxyDiY_6{hb4=IVPCC_&tdcRuv7%Z>dNyj(^^%zfR
zf!5nSIJ*#I*!-q`iZ1c>2-&0m0W2pX;sB~ybEXnYDtg(8@$DLOdriO7{d$A-Bd@NN
zYB`bu+_K#mLuLlv`^l?r`mT<O${ysCfMU25W}w4MjL(H0h^*tbUBsxg-%K<o62gu;
z)_o~Yio)JMg7W814=Kv9>y|9cTNS*c0k&G5+V_>r#7|guni_Xi5IoUqYb!=g)DU>4
z`Y*}KQg?>0@~=C2>uy@B$}PlkPf0pKIniZaimVZ8o>-SD78*IRvhctf{qW`ZF9xK(
zw=(>U3{x$EvBoKvm@iLB^8A7C@}3HwbO3PWBkIiY(+Q9_V?<n!C#C0V$k<dDoC%Hw
z6LK%cQu$cbU|z%v<)gA;lsJOP)YV+N8L(3V9m!aRHX!U_^Z+W|tD*VHMtr3r@yG8p
zS|jrE4`t@D(7}+<xIRVbg$ge<2Ug+$lWb2QF4UksHm}<SGTcqFqIL_oEwoS2t`(NU
zvZwjTrQHl5L@Y&twT6t@^p2uXCA6i^y<g=adWc(FY>HA84KSx;xe)1ex1@XMxMub(
zcwwy?dT-Owq6&VQ(27t{g7@Xp5bdD-4&*&|<s>>F+?t_a`RPzM{uIC7M-iIii%z~h
zZtF8p1it?qFf?6u=$v|JL2v7a|MH!eFWjvhoY|kh=Exlea-T!l`;g$?_XJh+!NzbR
zuvt<;0%Om8z^eK)Vmi9J<tPJzazA5@US~qk&C%RZ#eQ)b3J#<*#^b-JtX-n&lqb3i
zi4|O7O)f@w(j93D84=QjC~2XfHLm1)klDSgKzBqG;F8i9JW1&fa{Ls`nNme`Z7d}}
z$X}hPdi-WDK>y*3@69QhztkDPlV0^@x4g>nCio~)x9W)&o(_?82L0U{;*h>f-UF|x
zrT}KEp{7T%#2tJ>D58XN{Cf$iHLil2(6EDxY&=Pq@>alP34jDwS}g`C3g!j4A7Z}^
zr8$NsvqOJZBT()u%y(QQds#{`)s$SYrnKOr7O5jynN`%((}KO$mn37L6+u^sgUq4K
zX{QfvU0KuA>uc&b@@wr`9p>S*A<-46$Q2!ulsx|wEi<KhlqBs$wk|q+l9a@I6+~@-
z6I}*+JCLJ3OEWXowUl>J>V|ikM-h_&RVjUrZem82-c;)Q3}KT5Cf4bj2)BcdOX?g4
zeiEa8X-zutb*gfX&{h6mrRT12sIu1Kpt9(RWm=96KAx=ngN&GZ6r4zz#|TyeJ5V^z
zKfjs2cn%ju3O<q);W<`~Qrj1<4AF-$^6nF%n%OrS8l+n1+<vG31%9mIbgxr%dl=^=
zKg91-67B3$-UKQZUbWY;k;T=VE+bO7nB;PdmdYD@fKQ%OE>JZ5S_MS9@V<{I5Ttjr
zFZ*yQ105>3gX_2$Wl4Y2CqgF#0%nAZ)tf_vmjvh&s+dmSKe|F(BnRg>kk5uZs8jtF
zza>^+O(-ih_jY0y1kBHW>?(6{*-A(bdz6o*S~p_vubFxoXH1^HF071=08^lMD~lfP
z-%iE)<@<?>Oi?}i0R9tF?-C8~l%G|a)S(c8QMs^k8LbX*B(;IdV(te!$oM56U^jnM
z8<TaO7%xO@ORHUQB3porKx%2L4n)3kE2ojCRsD{r;L*ANhQsUL!G5v9@<anC`~%-2
zO9R@0Z>>mFdsnO>4kl0VRhliUV5>ifXeoj48jEl@Wh6`@h<30}I08ApQ8j=g(a^dP
z9)X>=n-|0COpDM665rC_F=E+FTmk;rQ5uA{o)ZDrr2VFXM7zx%#!rl*o9y&UincBF
zeu{*E*3RkBFM1|tVp^x72MBlYneH%=e(p69+mleI_2?ojn|8)2;|^0aFQ6GaD|&IZ
z7U%lzTg~&a_un2D?q=e`C<6fij=%r_5&#m&)ZRqV$=<=4!NlIl>_0`C|2roS002Ug
zcCCULF^6v;ydlQBM=V!k3(#8^s?fkMzUn&@d~D6IMUtl9IepW5){0tZ<_GALoqG&s
z-XxhfQ$t_iHjYwdk)VW+0*_M1j>*LsszUw4c}+4=t1C!LDu9B`*Pqk|(2i5XDD<f2
z*dY$Nl2}u!P;G0}P)!Eg6q!*t!(9$K7RZ{eD>yWnzQ)-DiWzebkZDn-n74p^*%0TE
zs9pn94LVK%K_-+1pg-Wqf%<#(VLDhbAh^wrXq`7HSI;orr_j4FAYNvUf*Wct3gS93
z=>__4CPz<dEAuDaG;kHuAm!V^&1rJG@t=R!uf}o+T$;g)1xXlpjs;<Ly6_mB5MF1)
zd^yJ-y1Twh2zt;HUR~s*w7nYjXcy2z7q3waA(YcF7n({-ea?%&vh0FiGfbEy_(vuZ
z?9`6I<#HOc66XQ5f@b-pp8qkP{C8oZkrWhSBoF|A1Ofmc{%ar_IXL`p9R3qINkaCU
zjIg0MAnydQ+c;d?im-vz#*!M3^+rHRtrl`+CWVcp5!H#8tMRS#OY2_eu}9t>@1j!M
zxZDPh3G>5>k;g@-V4yhG7|*F5YukE$XkbZDEq6?UWN`rp;s!p-*|;dCP61#Npw*%>
zDeB5awuLOe47utThPJQ{*l)~iur2o4H`3vO$EzB<(i{jO*_P7JP$|oX)D#HdYKrk*
zZynubVXK$hQo5SLUen&oo4AZ^Dqj8S_fm7Bqt03l4H}D!=~HvstgK_h*&r@PJV42I
z!O!uh>YHO7v0Bc5EC-inz_|E(*lHBL+9HDINI#PEphPr)Z!X2OC`f7v41dPZ0Sc3B
zGQv!_US_Oc#26$%Fiu8@41taIaUD;_K)$Tl$rpKsCb{m$81LjcHv{dtoo6`oGZo$`
zyzx3s2NFY7o(4lLd?Y(PtReMRJ^58PS4=D3z~nFZ;g<O9nLmh3x3lWQ-<KbH8F{}B
z9|xcAy_Edu-}Ee4$acRPzhM4r@CgW*4)A{yy#F2lM*gn&HwXV+n)|Ov2LS;7MX39C
z!@tWF|A{W}{~=!dyYYWlO#Lg|p#Nd~f6-6<-Ot};H2=g;*#EPM{~@aRyO+PukNp$R
zSpV?y_i3`fJNSDC{GV_o`iFym_QU^f`uEP+KjA_4AEtlrqy62(e=ny0igGRh;D40X
mznlMe3j9|v^8SnYe-fgi3>f%dzkvoo0|I~nfE)h5zWsj|)v>$)

literal 0
HcmV?d00001

diff --git a/mc-vod-sync/mc-vod-sync-brightcove/src/main/java/hu/user/mcvodsync/brightcove/ApiProperties.java b/mc-vod-sync/mc-vod-sync-brightcove/src/main/java/hu/user/mcvodsync/brightcove/ApiProperties.java
index 0a1fe4b7..87875710 100644
--- a/mc-vod-sync/mc-vod-sync-brightcove/src/main/java/hu/user/mcvodsync/brightcove/ApiProperties.java
+++ b/mc-vod-sync/mc-vod-sync-brightcove/src/main/java/hu/user/mcvodsync/brightcove/ApiProperties.java
@@ -11,6 +11,8 @@ import org.springframework.stereotype.Component;
 @ConfigurationProperties(prefix = "mc-vod-sync.api")
 public class ApiProperties {
 
+    private String baseUrl;
+
     private String tokenRequestUrl;
 
     private String clientId;
diff --git a/mc-vod-sync/mc-vod-sync-brightcove/src/main/java/hu/user/mcvodsync/brightcove/BrightCoveClient.java b/mc-vod-sync/mc-vod-sync-brightcove/src/main/java/hu/user/mcvodsync/brightcove/BrightCoveClient.java
index 8d4d4c8d..3463f6b1 100644
--- a/mc-vod-sync/mc-vod-sync-brightcove/src/main/java/hu/user/mcvodsync/brightcove/BrightCoveClient.java
+++ b/mc-vod-sync/mc-vod-sync-brightcove/src/main/java/hu/user/mcvodsync/brightcove/BrightCoveClient.java
@@ -5,6 +5,7 @@ import com.brightcove.cms.client.api.CustomFieldsApi;
 import com.brightcove.cms.client.api.PlaylistsApi;
 import com.brightcove.cms.client.api.VideosApi;
 import com.brightcove.cms.client.model.*;
+import com.fasterxml.jackson.databind.ObjectMapper;
 import lombok.extern.log4j.Log4j2;
 import org.apache.commons.lang3.StringUtils;
 import org.apache.oltu.oauth2.client.OAuthClient;
@@ -22,30 +23,32 @@ import org.springframework.web.client.HttpClientErrorException;
 import org.springframework.web.client.HttpServerErrorException;
 import org.springframework.web.client.RestClientException;
 
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
-import java.util.Objects;
+import java.util.*;
 
 @Log4j2
 @Service
 public class BrightCoveClient {
+    private final ApiProperties apiProperties;
     private String authToken;
     private long tokenExpires;
 
     public static final String BEARER = "Bearer ";
-    private final ApiClient apiClient = new ExtendedApiClient();
+    private final ApiClient extendedApiClient = new ExtendedApiClient();
     private final PlaylistsApi playListApi = new PlaylistsApi();
     private final VideosApi videosApi = new VideosApi();
     private final CustomFieldsApi customFieldsApi = new CustomFieldsApi();
 
+
     @Autowired
-    private ApiProperties apiProperties;
+    private ObjectMapper objectMapper;
 
-    public BrightCoveClient() {
-        playListApi.setApiClient(apiClient);
-        videosApi.setApiClient(apiClient);
-        customFieldsApi.setApiClient(apiClient);
+    @Autowired
+    public BrightCoveClient(ApiProperties apiProperties) {
+        this.apiProperties = apiProperties;
+        extendedApiClient.setBasePath(apiProperties.getBaseUrl());
+        playListApi.setApiClient(extendedApiClient);
+        videosApi.setApiClient(extendedApiClient);
+        customFieldsApi.setApiClient(extendedApiClient);
     }
 
     private String createToken() {
@@ -134,28 +137,32 @@ public class BrightCoveClient {
         final MultiValueMap<String, String> cookieParams = new LinkedMultiValueMap<String, String>();
         final MultiValueMap<String, Object> formParams = new LinkedMultiValueMap<String, Object>();
 
-        queryParams.putAll(apiClient.parameterToMultiValueMap(null, "q", query));
+        queryParams.putAll(extendedApiClient.parameterToMultiValueMap(null, "q", query));
 
         if (contentType != null)
-            headerParams.add("Content-Type", apiClient.parameterToString(contentType));
+            headerParams.add("Content-Type", extendedApiClient.parameterToString(contentType));
         if (authorization != null)
-            headerParams.add("Authorization", apiClient.parameterToString(authorization));
+            headerParams.add("Authorization", extendedApiClient.parameterToString(authorization));
 
         final String[] localVarAccepts = {
                 "application/json"
         };
-        final List<MediaType> localVarAccept = apiClient.selectHeaderAccept(localVarAccepts);
+        final List<MediaType> localVarAccept = extendedApiClient.selectHeaderAccept(localVarAccepts);
         final String[] contentTypes = {};
-        final MediaType localVarContentType = apiClient.selectHeaderContentType(contentTypes);
+        final MediaType localVarContentType = extendedApiClient.selectHeaderContentType(contentTypes);
 
         String[] authNames = new String[]{"BC_OAuth2"};
 
         ParameterizedTypeReference<PlaylistCount> returnType = new ParameterizedTypeReference<PlaylistCount>() {
         };
-        return apiClient.invokeAPI("/v1/accounts/{account_id}/counts/playlists", HttpMethod.GET, uriVariables, queryParams, postBody, headerParams, cookieParams, formParams, localVarAccept, localVarContentType, authNames, returnType);
+        return extendedApiClient.invokeAPI("/v1/accounts/{account_id}/counts/playlists", HttpMethod.GET, uriVariables, queryParams, postBody, headerParams, cookieParams, formParams, localVarAccept, localVarContentType, authNames, returnType);
     }
 
 
+    public Playlist getPlaylistsById(String id) {
+        return playListApi.getPlaylistById(apiProperties.getAccountId(), id, MediaType.APPLICATION_JSON_VALUE, getToken());
+    }
+
     public Playlist getPlaylistsByName(String name) throws Exception {
         Playlist result = null;
         PagedSearch<Playlist> page = PagedSearch.<Playlist>builder()
@@ -277,14 +284,81 @@ public class BrightCoveClient {
         return videosApi.createVideo(apiProperties.getAccountId(), MediaType.APPLICATION_JSON_VALUE, getToken(), fields);
     }
 
+    List<String> updatableVideoFields = Arrays.asList("name", "tags", "long_description", "description", "custom_fields");
+
     public Video updateVideo(String videoId, Video video) {
-        return videosApi.updateVideo(apiProperties.getAccountId(), videoId, MediaType.APPLICATION_JSON_VALUE, getToken(), video);
+        final Map<String, Object> videoEx = objectMapper.convertValue(video, objectMapper.getTypeFactory().constructMapType(Map.class, String.class, Object.class));
+        Map<String, Object> filteredVideo = new HashMap<>();
+        updatableVideoFields.forEach(f -> filteredVideo.put(f, videoEx.get(f)));
+        updateVideoWithHttpInfo(apiProperties.getAccountId(), videoId, MediaType.APPLICATION_JSON_VALUE, getToken(), filteredVideo);
+        return getVideoById(videoId);
     }
 
     public void deleteVideo(String id) {
         videosApi.deleteVideo(apiProperties.getAccountId(), "/" + id, MediaType.APPLICATION_JSON_VALUE, getToken());
     }
 
+    //generated function expects Video object, which has prohibited for update fields like variants
+    public ResponseEntity<Map<String, Object>> updateVideoWithHttpInfo(String accountId, String videoId, String contentType, String authorization, Map<String, Object> video) throws RestClientException {
+        Object postBody = video;
+
+        // verify the required parameter 'accountId' is set
+        if (accountId == null) {
+            throw new HttpClientErrorException(HttpStatus.BAD_REQUEST, "Missing the required parameter 'accountId' when calling updateVideo");
+        }
+
+        // verify the required parameter 'videoId' is set
+        if (videoId == null) {
+            throw new HttpClientErrorException(HttpStatus.BAD_REQUEST, "Missing the required parameter 'videoId' when calling updateVideo");
+        }
+
+        // verify the required parameter 'contentType' is set
+        if (contentType == null) {
+            throw new HttpClientErrorException(HttpStatus.BAD_REQUEST, "Missing the required parameter 'contentType' when calling updateVideo");
+        }
+
+        // verify the required parameter 'authorization' is set
+        if (authorization == null) {
+            throw new HttpClientErrorException(HttpStatus.BAD_REQUEST, "Missing the required parameter 'authorization' when calling updateVideo");
+        }
+
+        // verify the required parameter 'video' is set
+        if (video == null) {
+            throw new HttpClientErrorException(HttpStatus.BAD_REQUEST, "Missing the required parameter 'video' when calling updateVideo");
+        }
+
+        // create path and map variables
+        final Map<String, Object> uriVariables = new HashMap<String, Object>();
+        uriVariables.put("account_id", accountId);
+        uriVariables.put("video_id", videoId);
+
+        final MultiValueMap<String, String> queryParams = new LinkedMultiValueMap<String, String>();
+        final HttpHeaders headerParams = new HttpHeaders();
+        final MultiValueMap<String, String> cookieParams = new LinkedMultiValueMap<String, String>();
+        final MultiValueMap<String, Object> formParams = new LinkedMultiValueMap<String, Object>();
+
+        if (contentType != null)
+            headerParams.add("Content-Type", extendedApiClient.parameterToString(contentType));
+        if (authorization != null)
+            headerParams.add("Authorization", extendedApiClient.parameterToString(authorization));
+
+        final String[] localVarAccepts = {
+                "application/json"
+        };
+        final List<MediaType> localVarAccept = extendedApiClient.selectHeaderAccept(localVarAccepts);
+        final String[] contentTypes = {
+                "application/json"
+        };
+        final MediaType localVarContentType = extendedApiClient.selectHeaderContentType(contentTypes);
+
+        String[] authNames = new String[]{"BC_OAuth2"};
+
+        ParameterizedTypeReference<Map<String, Object>> returnType = new ParameterizedTypeReference<Map<String, Object>>() {
+        };
+        return extendedApiClient.invokeAPI("/v1/accounts/{account_id}/videos/{video_id}", HttpMethod.PATCH, uriVariables, queryParams, postBody, headerParams, cookieParams, formParams, localVarAccept, localVarContentType, authNames, returnType);
+    }
+
+
     //generated VideosApi returns Video entity not a List
     private ResponseEntity<List<Video>> getVideoByIdOrReferenceIdWithHttpInfo(String accountId, String videoIds, String contentType, String authorization, Boolean includeVariants) throws RestClientException {
         Object postBody = null;
diff --git a/mc-vod-sync/mc-vod-sync-db/migrations/bootstrap.sql b/mc-vod-sync/mc-vod-sync-db/migrations/bootstrap.sql
index c0eae3c6..9b855d7f 100644
--- a/mc-vod-sync/mc-vod-sync-db/migrations/bootstrap.sql
+++ b/mc-vod-sync/mc-vod-sync-db/migrations/bootstrap.sql
@@ -1,7 +1,3 @@
 -- // Bootstrap.sql
 -- DROP DATABASE IF EXISTS VODSYNC;
--- CREATE DATABASE VODSYNC AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY hu COLLATE USING UCA500R1_S2 PAGESIZE 32 K;
-
-TRUNCATE TABLE asset IMMEDIATE;
-TRUNCATE TABLE asset_sync IMMEDIATE;
-TRUNCATE TABLE playlist_sync IMMEDIATE;
+-- CREATE DATABASE VODSYNC USING CODESET UTF-8 TERRITORY hu catalog tablespace managed by system using ('catalog_TS') user tablespace managed by system using ('data_TS') temporary tablespace managed by system using ('temporary_TS');
diff --git a/mc-vod-sync/mc-vod-sync-db/migrations/scripts/003_create_business_tables.sql b/mc-vod-sync/mc-vod-sync-db/migrations/scripts/003_create_business_tables.sql
index ec2ddfdf..0d5194d3 100644
--- a/mc-vod-sync/mc-vod-sync-db/migrations/scripts/003_create_business_tables.sql
+++ b/mc-vod-sync/mc-vod-sync-db/migrations/scripts/003_create_business_tables.sql
@@ -11,17 +11,20 @@ CREATE TABLE upload_file (
 );
 
 CREATE TABLE asset (
+    id BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
     catalog_id VARCHAR(20) NOT NULL,
     reference_id VARCHAR(20),
     season_id BIGINT NOT NULL,
     series_id BIGINT NOT NULL,
     sunset DATE NOT NULL,
     sunrise DATE NOT NULL,
-    playlist VARCHAR(100) NOT NULL,
-    hub_info VARCHAR(100),
-    prog_local_title VARCHAR(255) NOT NULL,
-    season_local_title VARCHAR(255),
-    series_local_title VARCHAR(255),
+    playlist VARCHAR(255) NOT NULL,
+    hub_info VARCHAR(128),
+    prog_local_title VARCHAR(250) NOT NULL,
+    prog_synopsis_short_hun VARCHAR(250),
+    prog_synopsis_full_hun VARCHAR(5000),
+    season_local_title VARCHAR(128),
+    series_local_title VARCHAR(128),
     season_nr INTEGER,
     episode_nr INTEGER,
     production_year INTEGER,
@@ -30,12 +33,18 @@ CREATE TABLE asset (
     content_type VARCHAR(50),
     content_source VARCHAR(50),
     age_rating VARCHAR(10),
-    CONSTRAINT pk_catalog_id PRIMARY KEY (catalog_id)
+    director VARCHAR(128),
+    x_cast VARCHAR(128),
+    prog_genre1 VARCHAR(128),
+    prog_genre2 VARCHAR(128),
+    prog_genre3 VARCHAR(128),
+    CONSTRAINT pk_asset PRIMARY KEY (id)
 );
 CREATE INDEX idx_asset_playlist ON asset(playlist);
 
 CREATE TABLE asset_sync (
     id BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
+    asset_id BIGINT,
     catalog_id VARCHAR(20) NOT NULL,
     created TIMESTAMP NOT NULL,
     sync_type VARCHAR(6) NOT NULL,
@@ -47,7 +56,7 @@ CREATE INDEX idx_asset_sync_exported_success ON asset_sync(exported_success);
 
 CREATE TABLE playlist_sync (
     id BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
-    name VARCHAR(100) NOT NULL,
+    name VARCHAR(255) NOT NULL,
     created TIMESTAMP NOT NULL,
     sync_type VARCHAR(6) NOT NULL,
     exported_success TIMESTAMP,
diff --git a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/Asset.java b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/Asset.java
index 5290e061..e97ceddb 100644
--- a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/Asset.java
+++ b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/Asset.java
@@ -2,9 +2,7 @@ package hu.user.mcvodsync.db;
 
 import lombok.*;
 
-import javax.persistence.Column;
-import javax.persistence.Entity;
-import javax.persistence.Id;
+import javax.persistence.*;
 import java.io.Serializable;
 import java.sql.Date;
 
@@ -17,6 +15,9 @@ import java.sql.Date;
 @AllArgsConstructor
 public class Asset implements Serializable {
     @Id
+    @GeneratedValue(strategy = GenerationType.IDENTITY)
+    private Long id;
+
     private String catalogId;
 
     private Long seasonId;
@@ -34,13 +35,22 @@ public class Asset implements Serializable {
     @Column(nullable = false)
     private String playlist;
 
+    @Column(length = 128)
     private String hubInfo;
 
-    @Column(nullable = false)
+    @Column(nullable = false, length = 250)
     private String progLocalTitle;
 
+    @Column(length = 250)
+    private String progSynopsisShortHun;
+
+    @Column(length = 5000)
+    private String progSynopsisFullHun;
+
+    @Column(length = 128)
     private String seasonLocalTitle;
 
+    @Column(length = 128)
     private String seriesLocalTitle;
 
     private Integer seasonNr;
@@ -58,4 +68,20 @@ public class Asset implements Serializable {
     private String contentSource;
 
     private String ageRating;
+
+    @Column(length = 128)
+    private String director;
+
+    @Column(length = 128)
+    private String xCast;
+
+    @Column(name = "prog_genre1", length = 128)
+    private String progGenre1;
+
+    @Column(name = "prog_genre2", length = 128)
+    private String progGenre2;
+
+    @Column(name = "prog_genre3", length = 128)
+    private String progGenre3;
+
 }
diff --git a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/AssetSync.java b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/AssetSync.java
index 17908803..6dda3bb0 100644
--- a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/AssetSync.java
+++ b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/AssetSync.java
@@ -17,7 +17,9 @@ import java.util.Date;
 public class AssetSync implements Serializable {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    Long id;
+    private Long id;
+
+    private Long assetId;
 
     private String catalogId;
 
diff --git a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/Associate.java b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/Associate.java
index 9cbf6357..8b4fda85 100644
--- a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/Associate.java
+++ b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/Associate.java
@@ -17,9 +17,9 @@ import java.io.Serializable;
 public class Associate implements Serializable {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    Long id;
-    String name;
-    String login;
-    String password;
-    boolean active;
+    private Long id;
+    private String name;
+    private String login;
+    private String password;
+    private boolean active;
 }
diff --git a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/PlaylistSync.java b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/PlaylistSync.java
index 6e18d534..fa2f8f75 100644
--- a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/PlaylistSync.java
+++ b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/PlaylistSync.java
@@ -19,7 +19,7 @@ import java.util.List;
 public class PlaylistSync implements Serializable {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    Long id;
+    private Long id;
 
     private String name;
 
@@ -36,5 +36,5 @@ public class PlaylistSync implements Serializable {
     private Date exportedError;
 
     @Convert(converter = StringListConverter.class)
-    private List<String> ids;
+    private List<Long> ids;
 }
diff --git a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/UploadFile.java b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/UploadFile.java
index fc45d344..2b326d15 100644
--- a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/UploadFile.java
+++ b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/UploadFile.java
@@ -16,15 +16,15 @@ import java.util.Date;
 public class UploadFile implements Serializable {
     @Id
     @GeneratedValue(strategy = GenerationType.IDENTITY)
-    Long id;
+    private Long id;
 
     @CreationTimestamp
     @Column(updatable = false)
-    Date created;
+    private Date created;
 
-    String name;
+    private String name;
 
-    int size;
+    private int size;
 
-    byte[] file;
+    private byte[] file;
 }
diff --git a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/converter/StringListConverter.java b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/converter/StringListConverter.java
index b30d2638..28bc8952 100644
--- a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/converter/StringListConverter.java
+++ b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/converter/StringListConverter.java
@@ -5,19 +5,28 @@ import javax.persistence.Converter;
 import java.util.Arrays;
 import java.util.List;
 import java.util.Objects;
+import java.util.stream.Collectors;
 
 @Converter
-public class StringListConverter implements AttributeConverter<List<String>, byte[]> {
+public class StringListConverter implements AttributeConverter<List<Long>, byte[]> {
     private static final String SPLIT_CHAR = ",";
 
     @Override
-    public byte[] convertToDatabaseColumn(List<String> dataList) {
-        return Objects.isNull(dataList) ? null : String.join(SPLIT_CHAR, dataList).getBytes();
+    public byte[] convertToDatabaseColumn(List<Long> ids) {
+        if (Objects.isNull(ids) || ids.isEmpty()) {
+            return null;
+        }
+        List<String> converted = ids.stream().map(String::valueOf).collect(Collectors.toList());
+        return String.join(SPLIT_CHAR, converted).getBytes();
     }
 
     @Override
-    public List<String> convertToEntityAttribute(byte[] data) {
+    public List<Long> convertToEntityAttribute(byte[] data) {
+        if (data == null) {
+            return null;
+        }
         String stringData = new String(data);
-        return Arrays.asList(stringData.split(SPLIT_CHAR));
+        List<String> ids = Arrays.asList(stringData.split(SPLIT_CHAR));
+        return ids.stream().map(Long::parseLong).collect(Collectors.toList());
     }
 }
\ No newline at end of file
diff --git a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/AssetRepository.java b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/AssetRepository.java
index 37c8e74c..cec95118 100644
--- a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/AssetRepository.java
+++ b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/AssetRepository.java
@@ -7,25 +7,31 @@ import org.springframework.data.jpa.repository.Query;
 
 import java.sql.Date;
 import java.util.List;
+import java.util.Optional;
 
-public interface AssetRepository extends JpaRepository<Asset, String> {
+public interface AssetRepository extends JpaRepository<Asset, Long> {
 
     @Query("SELECT DISTINCT(a.playlist) FROM Asset a ORDER BY a.playlist")
     List<String> queryDistinctPlaylists();
 
-    @Query("SELECT a.catalogId FROM Asset a WHERE a.playlist = :playlist ORDER BY a.seasonNr, a.episodeNr")
-    List<String> queryPlaylistsAssets(String playlist);
+    @Query("SELECT a.id FROM Asset a WHERE a.playlist = :playlist ORDER BY a.seasonNr, a.episodeNr")
+    List<Long> queryPlaylistsAssets(String playlist);
 
-    @Query("SELECT a.catalogId FROM Asset a WHERE a.sunset <= :currentDate ORDER BY a.catalogId")
-    List<String> queryExpired(Date currentDate);
+    Optional<Asset> findByCatalogIdAndPlaylist(String catalogId, String playlist);
+
+    @Query("SELECT a FROM Asset a WHERE a.sunset <= :currentDate ORDER BY a.catalogId")
+    List<Asset> queryExpired(Date currentDate);
 
     @Modifying
     @Query("DELETE FROM Asset a WHERE a.sunset <= :currentDate")
     void deleteExpired(Date currentDate);
 
-    @Query("SELECT a.referenceId FROM Asset a WHERE a.catalogId = :catalogId")
-    String findReferenceIdByCatalogId(String catalogId);
+    @Query("SELECT a.referenceId FROM Asset a WHERE a.id = :id")
+    String findReferenceIdById(Long id);
+
+    @Query("SELECT a.catalogId FROM Asset a WHERE a.id = :id")
+    String findCatalogIdById(Long id);
 
-    @Query("SELECT a.catalogId FROM Asset a WHERE a.referenceId = :referenceId")
-    String findCatalogIdByReferenceId(String referenceId);
+    @Query("SELECT a.id FROM Asset a WHERE a.referenceId = :referenceId AND a.playlist = :playlist")
+    String findIdByReferenceId(String referenceId, String playlist);
 }
diff --git a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/AssetSyncRepository.java b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/AssetSyncRepository.java
index df29c9f9..08072972 100644
--- a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/AssetSyncRepository.java
+++ b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/AssetSyncRepository.java
@@ -11,6 +11,8 @@ public interface AssetSyncRepository extends JpaRepository<AssetSync, String> {
 
     long countBySyncType(SyncType syncType);
 
+    long countByExportedSuccessIsNull();
+
     @Query("SELECT a.id FROM AssetSync a WHERE a.exportedSuccess IS NULL ORDER BY a.created")
     List<Long> queryIdsForExport();
 
diff --git a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/PlaylistSyncRepository.java b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/PlaylistSyncRepository.java
index ff65fb39..57c88a8a 100644
--- a/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/PlaylistSyncRepository.java
+++ b/mc-vod-sync/mc-vod-sync-db/src/main/java/hu/user/mcvodsync/db/repository/PlaylistSyncRepository.java
@@ -11,6 +11,8 @@ public interface PlaylistSyncRepository extends JpaRepository<PlaylistSync, Long
 
     long countBySyncType(SyncType syncType);
 
+    long countByExportedSuccessIsNull();
+
     List<PlaylistSync> findAllByName(String name);
 
     @Query("SELECT p.id FROM PlaylistSync p WHERE p.exportedSuccess IS NULL ORDER BY p.created")
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/ServiceProperties.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/ServiceProperties.java
index 3cd7c29d..515b3e15 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/ServiceProperties.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/ServiceProperties.java
@@ -16,6 +16,7 @@ public class ServiceProperties {
     private boolean targetPlaylistInsertEnabled;
 
     private Scheduler scheduler;
+    private Report report;
 
     @Getter
     @Setter
@@ -29,8 +30,16 @@ public class ServiceProperties {
 
         private String exportCron;
 
-        private boolean sunriseCheckerEnabled;
+        private boolean sunsetCheckerEnabled;
+
+        private String sunsetCheckerCron;
+    }
+
+    @Getter
+    @Setter
+    public static final class Report {
+        private String sender;
+        private String recipient;
 
-        private String sunriseCheckerCron;
     }
 }
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/config/ScheduledTasks.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/config/ScheduledTasks.java
index 6746aa9d..4a8ffdd9 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/config/ScheduledTasks.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/config/ScheduledTasks.java
@@ -1,12 +1,18 @@
 package hu.user.mcvodsync.service.config;
 
+import hu.user.mcvodsync.db.repository.AssetSyncRepository;
+import hu.user.mcvodsync.db.repository.PlaylistSyncRepository;
 import hu.user.mcvodsync.service.ServiceProperties;
+import hu.user.mcvodsync.service.data.CompositeSummary;
+import hu.user.mcvodsync.service.event.ExportCompletedEvent;
+import hu.user.mcvodsync.service.event.ExportStartedEvent;
 import hu.user.mcvodsync.service.event.ImportCompletedEvent;
 import hu.user.mcvodsync.service.event.ImportStartedEvent;
-import hu.user.mcvodsync.service.in.ImportSummary;
+import hu.user.mcvodsync.service.mail.EmailSendService;
 import hu.user.mcvodsync.service.schedule.ScheduledExport;
 import hu.user.mcvodsync.service.schedule.ScheduledImport;
-import hu.user.mcvodsync.service.schedule.ScheduledSunriseChacker;
+import hu.user.mcvodsync.service.schedule.ScheduledSunsetChacker;
+import hu.user.mcvodsync.service.time.TimeUtils;
 import lombok.Getter;
 import lombok.extern.log4j.Log4j2;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -36,14 +42,29 @@ public class ScheduledTasks {
     private ScheduledImport scheduledImport;
 
     @Autowired
-    private ScheduledSunriseChacker scheduledSunriseChacker;
+    private ScheduledSunsetChacker scheduledSunsetChacker;
+
+    @Autowired
+    private AssetSyncRepository assetSyncRepository;
+
+    @Autowired
+    private PlaylistSyncRepository playlistSyncRepository;
+
+    @Autowired
+    EmailSendService emailSendService;
 
     @Getter
-    private ImportSummary importSummary;
+    private CompositeSummary importSummary;
+
+    @Getter
+    private CompositeSummary exportSummary;
 
     @Getter
     private String status;
 
+    @Getter
+    private boolean outOfSync;
+
     @PostConstruct
     public void scheduleTasks() {
         //new CronTrigger("0 0 4 1/1 * ? *")
@@ -56,9 +77,11 @@ public class ScheduledTasks {
         if (scheduler.isImportEnabled()) {
             taskScheduler.schedule(scheduledImport, new CronTrigger(scheduler.getExportCron()));
         }
-        if (scheduler.isSunriseCheckerEnabled()) {
-            taskScheduler.schedule(scheduledSunriseChacker, new CronTrigger(scheduler.getSunriseCheckerCron()));
+        if (scheduler.isSunsetCheckerEnabled()) {
+            taskScheduler.schedule(scheduledSunsetChacker, new CronTrigger(scheduler.getSunsetCheckerCron()));
         }
+
+        checkSyncStatus();
     }
 
 
@@ -75,7 +98,7 @@ public class ScheduledTasks {
     public void handleEvent(ImportStartedEvent evt) {
         log.info("ImportStartedEvent handle");
         importSummary = null;
-        status = String.format("Import from %s started", evt.getFileName());
+        status = String.format("Import from %s is in progress, started as %s", evt.getFileName(), TimeUtils.toString(evt.getTimestamp()));
     }
 
     @Async
@@ -83,6 +106,38 @@ public class ScheduledTasks {
     public void handleEvent(ImportCompletedEvent evt) {
         log.info("ImportCompletedEvent handle");
         importSummary = evt.getSummary();
-        status = "Import completed";
+        status = String.format("Import completed at %s", TimeUtils.toString(evt.getTimestamp()));
+        checkSyncStatus();
+        emailSendService.sendSimpleMessage("BrightCove import report", importSummary);
+    }
+
+    @Async
+    @EventListener
+    public void handleEvent(ExportStartedEvent evt) {
+        log.info("ExportStartedEvent handle");
+        exportSummary = null;
+        status = String.format("Export is in progress, started at %s", TimeUtils.toString(evt.getTimestamp()));
+    }
+
+    @Async
+    @EventListener
+    public void handleEvent(ExportCompletedEvent evt) {
+        log.info("ExportCompletedEvent handle");
+        exportSummary = evt.getSummary();
+        status = String.format("Export completed at %s", TimeUtils.toString(evt.getTimestamp()));
+        checkSyncStatus();
+        emailSendService.sendSimpleMessage("BrightCove export report", importSummary);
+    }
+
+    public void reset() {
+        importSummary = null;
+        exportSummary = null;
+        checkSyncStatus();
+    }
+
+
+    public void checkSyncStatus() {
+        outOfSync = assetSyncRepository.countByExportedSuccessIsNull() > 0
+                || playlistSyncRepository.countByExportedSuccessIsNull() > 0;
     }
 }
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/data/CompositeSummary.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/data/CompositeSummary.java
new file mode 100644
index 00000000..55017fce
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/data/CompositeSummary.java
@@ -0,0 +1,56 @@
+package hu.user.mcvodsync.service.data;
+
+import hu.user.mcvodsync.service.time.TimeUtils;
+import lombok.Builder;
+import lombok.Getter;
+import lombok.Setter;
+import org.apache.commons.lang3.StringUtils;
+import org.apache.commons.lang3.time.DurationFormatUtils;
+
+import java.time.Duration;
+import java.time.Instant;
+import java.util.Objects;
+
+@Getter
+@Setter
+@Builder
+public class CompositeSummary {
+    @Builder.Default
+    private Summary video = Summary.builder().build();
+
+    @Builder.Default
+    private Summary playlist = Summary.builder().build();
+
+    private Instant started;
+
+    private Instant finished;
+
+    public String toString() {
+        return String.format("Execution started at %s, finished at %s.", getStartedFormatted(), getFinishedFormatted()) +
+                System.lineSeparator() +
+                String.format("Process execution took %s, processed %d videos and %d playlists.", getDuration(), video.getAll(), playlist.getAll()) +
+                System.lineSeparator() +
+                String.format("Video success count: %d, error count: %d, skip count: %d", video.getSuccess(), video.getError(), video.getSkip()) +
+                System.lineSeparator() +
+                String.format("Video insert count: %d, update count: %d, delete count: %d", video.getInsert(), video.getUpdate(), video.getDelete()) +
+                System.lineSeparator() +
+                String.format("Playlist success count: %d, error count: %d, skip count: %d", playlist.getSuccess(), playlist.getError(), playlist.getSkip()) +
+                System.lineSeparator() +
+                String.format("Playlist insert count: %d, update count: %d, delete count: %d", playlist.getInsert(), playlist.getUpdate(), playlist.getDelete());
+    }
+
+    public String getDuration() {
+        Duration executionDuration = Duration.between(started, finished);
+        return DurationFormatUtils.formatDuration(executionDuration.toMillis(), "H:mm:ss", true);
+    }
+
+    public String getStartedFormatted() {
+        return Objects.isNull(started) ? StringUtils.EMPTY : TimeUtils.toString(started.toEpochMilli());
+    }
+
+    public String getFinishedFormatted() {
+        return Objects.isNull(finished) ? StringUtils.EMPTY : TimeUtils.toString(finished.toEpochMilli());
+    }
+
+
+}
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/data/Summary.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/data/Summary.java
new file mode 100644
index 00000000..f9572330
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/data/Summary.java
@@ -0,0 +1,53 @@
+package hu.user.mcvodsync.service.data;
+
+import lombok.Builder;
+import lombok.Getter;
+import lombok.Setter;
+
+@Getter
+@Setter
+@Builder
+public class Summary {
+    private long all;
+
+    private long success;
+
+    private long error;
+
+    private long skip;
+
+    private long insert;
+
+    private long update;
+
+    private long delete;
+
+    public void incAll() {
+        all++;
+    }
+
+    public void incSuccess() {
+        success++;
+    }
+
+    public void incError() {
+        error++;
+    }
+
+    public void incSkip() {
+        skip++;
+    }
+
+    public void incInsert() {
+        insert++;
+    }
+
+    public void incUpdate() {
+        update++;
+    }
+
+    public void incDelete() {
+        update++;
+    }
+
+}
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ExportCompletedEvent.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ExportCompletedEvent.java
index 95c7a623..c0639c97 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ExportCompletedEvent.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ExportCompletedEvent.java
@@ -1,6 +1,6 @@
 package hu.user.mcvodsync.service.event;
 
-import hu.user.mcvodsync.service.in.ImportSummary;
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import lombok.Getter;
 import lombok.Setter;
 import org.springframework.context.ApplicationEvent;
@@ -9,9 +9,9 @@ import org.springframework.context.ApplicationEvent;
 @Setter
 public class ExportCompletedEvent extends ApplicationEvent {
 
-    private final ImportSummary summary;
+    private final CompositeSummary summary;
 
-    public ExportCompletedEvent(ImportSummary summary, Object source) {
+    public ExportCompletedEvent(Object source, CompositeSummary summary) {
         super(source);
         this.summary = summary;
     }
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ExportStartedEvent.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ExportStartedEvent.java
new file mode 100644
index 00000000..7f0048b5
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ExportStartedEvent.java
@@ -0,0 +1,15 @@
+package hu.user.mcvodsync.service.event;
+
+import lombok.Getter;
+import lombok.Setter;
+import org.springframework.context.ApplicationEvent;
+
+@Getter
+@Setter
+public class ExportStartedEvent extends ApplicationEvent {
+
+    public ExportStartedEvent(Object source) {
+        super(source);
+    }
+
+}
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ImportCompletedEvent.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ImportCompletedEvent.java
index 1ef84d95..374e1d11 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ImportCompletedEvent.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/event/ImportCompletedEvent.java
@@ -1,6 +1,6 @@
 package hu.user.mcvodsync.service.event;
 
-import hu.user.mcvodsync.service.in.ImportSummary;
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import lombok.Getter;
 import lombok.Setter;
 import org.springframework.context.ApplicationEvent;
@@ -9,9 +9,9 @@ import org.springframework.context.ApplicationEvent;
 @Setter
 public class ImportCompletedEvent extends ApplicationEvent {
 
-    private final ImportSummary summary;
+    private final CompositeSummary summary;
 
-    public ImportCompletedEvent(Object source, ImportSummary summary) {
+    public ImportCompletedEvent(Object source, CompositeSummary summary) {
         super(source);
         this.summary = summary;
     }
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/AssetImportService.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/AssetImportService.java
index 9e656bf9..2fd8ca51 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/AssetImportService.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/AssetImportService.java
@@ -8,6 +8,7 @@ import hu.user.mcvodsync.db.SyncType;
 import hu.user.mcvodsync.db.repository.AssetRepository;
 import hu.user.mcvodsync.db.repository.AssetSyncRepository;
 import hu.user.mcvodsync.db.repository.PlaylistSyncRepository;
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import hu.user.mcvodsync.service.data.EntityDataService;
 import lombok.extern.log4j.Log4j2;
 import org.apache.commons.collections4.CollectionUtils;
@@ -34,33 +35,33 @@ public class AssetImportService {
     @Autowired
     private EntityDataService<Asset> entityDataService;
 
-    private Map<String, List<String>> currentPlaylists;
+    private Map<String, List<Long>> currentPlaylists;
 
-    private ImportSummary summary;
 
-    public void prepare(ImportSummary summary) {
-        this.summary = summary;
+    public void prepare() {
         currentPlaylists = getPlayLists();
     }
 
-    public Map<String, List<String>> getPlayLists() {
-        Map<String, List<String>> result = new HashMap<>();
+    public Map<String, List<Long>> getPlayLists() {
+        Map<String, List<Long>> result = new HashMap<>();
         List<String> playlistNames = assetRepository.queryDistinctPlaylists();
         playlistNames.forEach(playlist -> {
-            List<String> playlistsAssets = assetRepository.queryPlaylistsAssets(playlist);
+            List<Long> playlistsAssets = assetRepository.queryPlaylistsAssets(playlist);
             result.put(playlist, playlistsAssets);
         });
         return result;
     }
 
-    public void processAsset(Asset asset) {
-        Optional<Asset> optionalEntity = assetRepository.findById(asset.getCatalogId());
+    public void processAsset(Asset asset, CompositeSummary summary) {
+        Optional<Asset> optionalEntity = assetRepository.findByCatalogIdAndPlaylist(asset.getCatalogId(), asset.getPlaylist());
 
         AssetSync assetSync = AssetSync.builder()
                 .catalogId(asset.getCatalogId())
                 .build();
 
         if (optionalEntity.isPresent()) {
+            asset.setId(optionalEntity.get().getId());
+            asset.setReferenceId(optionalEntity.get().getReferenceId());
             boolean areDifferent = entityDataService.areDifferent(asset, optionalEntity.get());
             if (areDifferent) {
                 assetSync.setSyncType(SyncType.UPDATE);
@@ -69,37 +70,46 @@ public class AssetImportService {
             assetSync.setSyncType(SyncType.INSERT);
         }
 
-        if (Objects.nonNull(assetSync.getSyncType())) {
-            assetRepository.saveAndFlush(asset);
-            assetSyncRepository.saveAndFlush(assetSync);
-        }
+        if (new Date().after(asset.getSunset())) {
+            summary.getVideo().incSkip();
+            if (assetSync.getSyncType() == SyncType.UPDATE) {
+                assetRepository.saveAndFlush(asset);
+            }
+        } else {
+            if (Objects.nonNull(assetSync.getSyncType())) {
+                assetRepository.saveAndFlush(asset);
+                assetSync.setAssetId(asset.getId());
+                assetSyncRepository.saveAndFlush(assetSync);
+            }
 
-        if (assetSync.getSyncType() == SyncType.UPDATE) {
-            summary.incUpdated();
-        }
-        if (assetSync.getSyncType() == SyncType.INSERT) {
-            summary.incInserted();
+            if (assetSync.getSyncType() == SyncType.UPDATE) {
+                summary.getVideo().incUpdate();
+            }
+            if (assetSync.getSyncType() == SyncType.INSERT) {
+                summary.getVideo().incInsert();
+            }
         }
     }
 
-    public void removeExpired(LocalDate currentDate) {
-        List<String> ids = assetRepository.queryExpired(java.sql.Date.valueOf(currentDate));
+    public void removeExpired(LocalDate currentDate, CompositeSummary summary) {
+        List<Asset> expiredAssets = assetRepository.queryExpired(java.sql.Date.valueOf(currentDate));
         assetRepository.deleteExpired(java.sql.Date.valueOf(currentDate));
-        List<AssetSync> syncs = ids.stream().map(id -> AssetSync.builder()
-                .catalogId(id)
+        List<AssetSync> syncs = expiredAssets.stream().map(asset -> AssetSync.builder()
+                .assetId(asset.getId())
+                .catalogId(asset.getCatalogId())
                 .syncType(SyncType.DELETE)
                 .build()).collect(Collectors.toList());
         assetSyncRepository.saveAllAndFlush(syncs);
-        summary.setDeleted(summary.getDeleted() + ids.size());
+        summary.getVideo().setDelete(summary.getVideo().getDelete() + expiredAssets.size());
     }
 
-    public void finish() {
-        removeExpired(LocalDate.now());
-        processPlaylists();
+    public void finish(CompositeSummary summary) {
+        removeExpired(LocalDate.now(), summary);
+        processPlaylists(summary);
     }
 
-    public void processPlaylists() {
-        Map<String, List<String>> newPlaylists = getPlayLists();
+    public void processPlaylists(CompositeSummary summary) {
+        Map<String, List<Long>> newPlaylists = getPlayLists();
         Set<String> currentPlaylistNames = currentPlaylists.keySet();
         Set<String> newPlaylistNames = newPlaylists.keySet();
 
@@ -112,7 +122,7 @@ public class AssetImportService {
                         .created(Date.from(Instant.now()))
                         .build();
                 playlistSyncRepository.save(sync);
-                summary.incDeletedPlaylist();
+                summary.getPlaylist().incDelete();
             });
         }
 
@@ -126,13 +136,13 @@ public class AssetImportService {
                         .ids(newPlaylists.get(name))
                         .build();
                 playlistSyncRepository.save(sync);
-                summary.incInsertedPlaylist();
+                summary.getPlaylist().incInsert();
             });
         }
 
         currentPlaylistNames.forEach(name -> {
-            List<String> currentContent = currentPlaylists.get(name);
-            List<String> newContent = newPlaylists.get(name);
+            List<Long> currentContent = currentPlaylists.get(name);
+            List<Long> newContent = newPlaylists.get(name);
             if (isContentChanged(currentContent, newContent)) {
                 PlaylistSync sync = PlaylistSync.builder()
                         .name(name)
@@ -141,12 +151,12 @@ public class AssetImportService {
                         .created(Date.from(Instant.now()))
                         .build();
                 playlistSyncRepository.save(sync);
-                summary.incUpdatedPlaylist();
+                summary.getPlaylist().incUpdate();
             }
         });
     }
 
-    private boolean isContentChanged(List<String> currentContent, List<String> newContent) {
+    private boolean isContentChanged(List<Long> currentContent, List<Long> newContent) {
         if (currentContent.size() != newContent.size()) {
             return true;
         }
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/AssetMapper.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/AssetMapper.java
index 85f616b3..9cf46c07 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/AssetMapper.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/AssetMapper.java
@@ -24,6 +24,8 @@ public interface AssetMapper {
     @Mapping(target = "playlist", source = "PLAYLIST_NAME")
     @Mapping(target = "hubInfo", source = "HUB_INFO")
     @Mapping(target = "progLocalTitle", source = "PROG_LOCAL_TITLE")
+    @Mapping(target = "progSynopsisShortHun", source = "PROG_SYNOPSIS_SHORT_HUN")
+    @Mapping(target = "progSynopsisFullHun", source = "PROG_SYNOPSIS_FULL_HUN")
     @Mapping(target = "seasonLocalTitle", source = "SEASON_LOCAL_TITLE")
     @Mapping(target = "seriesLocalTitle", source = "SERIES_GROUP_LOCAL_TITLE")
     @Mapping(target = "seasonNr", source = "SEASON_NUMBER", qualifiedByName = "mapNullableNumber")
@@ -34,6 +36,11 @@ public interface AssetMapper {
     @Mapping(target = "contentType", source = "CONTENT_TYPE")
     @Mapping(target = "contentSource", source = "CONTENT_SOURCE")
     @Mapping(target = "ageRating", source = "AGE_RATING")
+    @Mapping(target = "director", source = "DIRECTOR")
+    @Mapping(target = "xCast", source = "X_CAST")
+    @Mapping(target = "progGenre1", source = "PROG_GENRE_1")
+    @Mapping(target = "progGenre2", source = "PROG_GENRE_2")
+    @Mapping(target = "progGenre3", source = "PROG_GENRE_3")
     Asset toEntity(Map<String, String> xlsRowData);
 
     @Named("mapNullableNumber")
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/ImportSummary.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/ImportSummary.java
deleted file mode 100644
index d5fbf36e..00000000
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/ImportSummary.java
+++ /dev/null
@@ -1,81 +0,0 @@
-package hu.user.mcvodsync.service.in;
-
-import lombok.Builder;
-import lombok.Getter;
-import lombok.Setter;
-import org.apache.commons.lang3.time.DurationFormatUtils;
-
-import java.time.Duration;
-import java.time.Instant;
-
-@Getter
-@Setter
-@Builder
-public class ImportSummary {
-    private Instant started;
-
-    private Instant finished;
-
-    private long all;
-
-    private long success;
-
-    private long error;
-
-    private long inserted;
-
-    private long updated;
-
-    private long deleted;
-
-    private long insertedPlaylist;
-
-    private long updatedPlaylist;
-
-    private long deletedPlaylist;
-
-    public String toString() {
-        Duration executionDuration = Duration.between(started, finished);
-        String duration = DurationFormatUtils.formatDuration(executionDuration.toMillis(), "H:mm:ss", true);
-        return String.format("Execution started at %s, finished at %s.", started, finished) +
-                System.lineSeparator() +
-                String.format("Process execution took %s on %d rows.", duration, all) +
-                System.lineSeparator() +
-                String.format("Success count: %d, error count: %d", success, error) +
-                System.lineSeparator() +
-                String.format("Insert count: %d, update count: %d, delete count: %d", inserted, updated, deleted);
-    }
-
-    public void incAll() {
-        all++;
-    }
-
-    public void incSuccess() {
-        success++;
-    }
-
-    public void incError() {
-        error++;
-    }
-
-    public void incInserted() {
-        inserted++;
-    }
-
-    public void incUpdated() {
-        updated++;
-    }
-
-    public void incInsertedPlaylist() {
-        insertedPlaylist++;
-    }
-
-    public void incUpdatedPlaylist() {
-        updatedPlaylist++;
-    }
-
-    public void incDeletedPlaylist() {
-        deletedPlaylist++;
-    }
-
-}
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/VodXlsProcessor.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/VodXlsProcessor.java
index 9ccc5bcf..b2e7fa99 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/VodXlsProcessor.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/in/VodXlsProcessor.java
@@ -1,6 +1,7 @@
 package hu.user.mcvodsync.service.in;
 
 import hu.user.mcvodsync.db.Asset;
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import lombok.extern.log4j.Log4j2;
 import org.apache.commons.lang3.StringUtils;
 import org.dhatim.fastexcel.reader.Cell;
@@ -8,7 +9,7 @@ import org.dhatim.fastexcel.reader.ReadableWorkbook;
 import org.dhatim.fastexcel.reader.Row;
 import org.dhatim.fastexcel.reader.Sheet;
 import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
+import org.springframework.stereotype.Component;
 import org.springframework.transaction.annotation.Transactional;
 
 import java.io.ByteArrayInputStream;
@@ -23,7 +24,7 @@ import java.util.stream.Collectors;
 import java.util.stream.Stream;
 
 @Log4j2
-@Service
+@Component
 public class VodXlsProcessor {
     private List<Cell> headers;
 
@@ -33,24 +34,26 @@ public class VodXlsProcessor {
     @Autowired
     private AssetImportService assetImportService;
 
+
     @Transactional
-    public ImportSummary process(String fileName, byte[] xlsData) {
-        ImportSummary summary = ImportSummary.builder().started(Instant.now()).build();
+    public CompositeSummary process(String fileName, byte[] xlsData) {
+        CompositeSummary summary = CompositeSummary.builder().started(Instant.now()).build();
         try (InputStream is = new ByteArrayInputStream(xlsData);
              ReadableWorkbook wb = new ReadableWorkbook(is)) {
             Sheet sheet = wb.getFirstSheet();
             try (Stream<Row> rows = sheet.openStream()) {
                 rows.forEach(row -> {
                     if (row.getRowNum() == 1) {
-                        assetImportService.prepare(summary);
+                        assetImportService.prepare();
                         headers = getHeaders(row);
                     } else {
-                        summary.incAll();
+                        log.info("Processing {}", row.getRowNum());
+                        summary.getVideo().incAll();
                         processRow(row, summary);
                     }
                 });
             }
-            assetImportService.finish();
+            assetImportService.finish(summary);
 
         } catch (IOException e) {
             log.error("Excel file reading error from {}. System message: {}", fileName, e.getMessage());
@@ -64,7 +67,7 @@ public class VodXlsProcessor {
         return row.stream().collect(Collectors.toList());
     }
 
-    private void processRow(Row r, ImportSummary summary) {
+    private void processRow(Row r, CompositeSummary summary) {
         Map<String, String> rowData = new HashMap<>();
         r.stream().filter(Objects::nonNull).forEach(c -> {
             try {
@@ -80,11 +83,13 @@ public class VodXlsProcessor {
         try {
             asset = assetMapper.toEntity(rowData);
             if (isAssetValid(asset)) {
-                assetImportService.processAsset(asset);
+                assetImportService.processAsset(asset, summary);
+            } else {
+                summary.getVideo().incSkip();
             }
-            summary.incSuccess();
+            summary.getVideo().incSuccess();
         } catch (Exception e) {
-            summary.incError();
+            summary.getVideo().incError();
             log.error("Processing error for {}", asset, e);
         }
     }
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/mail/EmailSendService.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/mail/EmailSendService.java
index 2eacce90..ca0472bd 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/mail/EmailSendService.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/mail/EmailSendService.java
@@ -1,23 +1,42 @@
 package hu.user.mcvodsync.service.mail;
 
+import hu.user.mcvodsync.service.ServiceProperties;
+import hu.user.mcvodsync.service.data.CompositeSummary;
+import lombok.extern.log4j.Log4j2;
+import org.apache.commons.lang3.StringUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.mail.SimpleMailMessage;
 import org.springframework.mail.javamail.JavaMailSender;
 import org.springframework.stereotype.Service;
 
+import java.util.Objects;
+
+@Log4j2
 @Service
 public class EmailSendService {
     //    https://www.baeldung.com/spring-email
-    @Autowired
+    @Autowired(required = false)
     private JavaMailSender emailSender;
 
-    public void sendSimpleMessage() {
+    @Autowired
+    private ServiceProperties serviceProperties;
+
+    public void sendSimpleMessage(String subject, CompositeSummary summary) {
+        if (Objects.isNull(emailSender)) {
+            log.warn("Missing email settings, can not initiate JavaMailSender");
+            return;
+        }
+        if (StringUtils.isBlank(serviceProperties.getReport().getRecipient())) {
+            log.info("No recipient specified, report not sent.");
+            return;
+        }
         SimpleMailMessage message = new SimpleMailMessage();
-        message.setFrom("noreply@useribm.hu");
-        message.setTo("vasary@elgekko.net");
-        message.setSubject("Teszt");
-        message.setText("Teszt1");
+        message.setFrom(serviceProperties.getReport().getSender());
+        message.setTo(serviceProperties.getReport().getRecipient());
+        message.setSubject(subject);
+        message.setText(summary.toString());
         emailSender.send(message);
+        log.info("'{}' report sent to {}", subject, serviceProperties.getReport().getRecipient());
     }
 }
 
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/AssetExportService.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/SyncExportService.java
similarity index 62%
rename from mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/AssetExportService.java
rename to mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/SyncExportService.java
index 335e1ea1..31390b37 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/AssetExportService.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/SyncExportService.java
@@ -3,7 +3,6 @@ package hu.user.mcvodsync.service.out;
 
 import com.brightcove.cms.client.model.Playlist;
 import com.brightcove.cms.client.model.Video;
-import com.google.common.collect.Lists;
 import hu.user.mcvodsync.brightcove.BrightCoveClient;
 import hu.user.mcvodsync.db.Asset;
 import hu.user.mcvodsync.db.AssetSync;
@@ -12,7 +11,7 @@ import hu.user.mcvodsync.db.SyncType;
 import hu.user.mcvodsync.db.repository.AssetRepository;
 import hu.user.mcvodsync.db.repository.AssetSyncRepository;
 import hu.user.mcvodsync.db.repository.PlaylistSyncRepository;
-import hu.user.mcvodsync.service.ServiceProperties;
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import lombok.extern.log4j.Log4j2;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -21,7 +20,6 @@ import org.springframework.transaction.annotation.Transactional;
 
 import javax.persistence.EntityNotFoundException;
 import java.time.Instant;
-import java.util.Collections;
 import java.util.Date;
 import java.util.List;
 import java.util.Objects;
@@ -29,7 +27,7 @@ import java.util.stream.Collectors;
 
 @Log4j2
 @Service
-public class AssetExportService {
+public class SyncExportService {
     @Autowired
     private BrightCoveClient bcClient;
 
@@ -45,160 +43,160 @@ public class AssetExportService {
     @Autowired
     private VideoMapper videoMapper;
 
-    @Autowired
-    private ServiceProperties serviceProperties;
-
-    private static final int ASSET_PROCESSING_LIMIT = 100;
-    private static final int PLAYLIST_PROCESSING_LIMIT = 10;
-
-    public void export() {
-        exportAssets();
-        exportPlaylists();
-    }
-
-    private void exportAssets() {
-        List<Long> ids = assetSyncRepository.queryIdsForExport();
-        if (ids.isEmpty()) {
-            log.info("There are no video changes to export");
-            return;
-        }
-        List<List<Long>> partitions = Lists.partition(ids, ASSET_PROCESSING_LIMIT);
-        partitions.forEach(currentIds -> {
-            List<AssetSync> result = assetSyncRepository.findAllByIdInOrderByCreated(currentIds);
-            if (serviceProperties.isTargetVideoInsertEnabled()) {
-                result.forEach(this::processAssetSync);
-            } else {
-                result.forEach(this::processAssetSyncWithoutInsert);
-            }
-        });
-    }
+    private static final String MC_VOD_SYNC = "mc-vod-sync";
 
     @Transactional
-    public void processAssetSyncWithoutInsert(AssetSync assetSync) {
+    public void processAssetSyncWithoutInsert(AssetSync assetSync, CompositeSummary summary) {
         try {
             if (SyncType.DELETE.equals(assetSync.getSyncType())) {
                 //delete not necessary, remove only from all playlists
                 assetSync.setExportedSuccess(Date.from(Instant.now()));
+                summary.getVideo().incDelete();
             } else {
-                Asset asset = assetRepository.findById(assetSync.getCatalogId()).orElseThrow(EntityNotFoundException::new);
+                Asset asset = assetRepository.findById(assetSync.getAssetId()).orElseThrow(EntityNotFoundException::new);
                 Video assetVideo = videoMapper.toVideo(asset);
                 String videoId = asset.getReferenceId();
                 if (StringUtils.isBlank(videoId)) {
                     Video video = bcClient.getVideoByReferenceId(asset.getCatalogId());
-                    videoId = video.getId();
-                    asset.setReferenceId(videoId);
-                    assetRepository.save(asset);
+                    if (Objects.isNull(video)) {
+                        summary.getVideo().incSkip();
+                    } else {
+                        videoId = video.getId();
+                        asset.setReferenceId(videoId);
+                        assetRepository.save(asset);
+                    }
+                }
+                if (StringUtils.isNotBlank(videoId)) {
+                    assetVideo.addTagsItem(MC_VOD_SYNC);
+                    bcClient.updateVideo(videoId, assetVideo);
+                    summary.getVideo().incUpdate();
                 }
-                bcClient.updateVideo(videoId, assetVideo);
                 assetSync.setExportedSuccess(Date.from(Instant.now()));
             }
+            summary.getVideo().incSuccess();
         } catch (Exception e) {
             log.error(e);
             assetSync.setExportedError(Date.from(Instant.now()));
+            summary.getVideo().incError();
         } finally {
             assetSyncRepository.save(assetSync);
         }
     }
 
     @Transactional
-    public void processAssetSync(AssetSync assetSync) {
+    public void processAssetSync(AssetSync assetSync, CompositeSummary summary) {
         try {
             if (SyncType.DELETE.equals(assetSync.getSyncType())) {
                 //delete not necessary, remove only from all playlists
                 assetSync.setExportedSuccess(Date.from(Instant.now()));
+                summary.getVideo().incDelete();
             } else {
-                Asset asset = assetRepository.findById(assetSync.getCatalogId()).orElseThrow(EntityNotFoundException::new);
+                Asset asset = assetRepository.findById(assetSync.getAssetId()).orElseThrow(EntityNotFoundException::new);
+                //TODO handle deleted
+
                 Video assetVideo = videoMapper.toVideo(asset);
-                assetVideo.setTags(Collections.singletonList("mc-vod-sync"));
+                assetVideo.addTagsItem(MC_VOD_SYNC);
+
                 if (SyncType.INSERT.equals(assetSync.getSyncType())) {
-                    Video createdVideo = bcClient.createVideo(assetVideo);
-                    asset.setReferenceId(createdVideo.getId());
+                    Video existingAssetVideo = null;
+                    if (StringUtils.isBlank(asset.getReferenceId())) {
+                        existingAssetVideo = bcClient.getVideoByReferenceId(asset.getCatalogId());
+                    }
+
+                    if (Objects.isNull(existingAssetVideo)) {
+                        Video createdVideo = bcClient.createVideo(assetVideo);
+                        asset.setReferenceId(createdVideo.getId());
+                        summary.getVideo().incInsert();
+                    } else {
+                        summary.getVideo().incUpdate();
+                        asset.setReferenceId(existingAssetVideo.getId());
+                    }
                     assetRepository.save(asset);
                 }
                 if (SyncType.UPDATE.equals(assetSync.getSyncType())) {
                     if (StringUtils.isBlank(asset.getReferenceId())) {
                         throw new IllegalArgumentException("Can not update Video when Asset entity reference ID is empty");
                     }
-                    bcClient.updateVideo(asset.getReferenceId(), assetVideo);
+
+                    Video origVideo = bcClient.getVideoById(asset.getReferenceId());
+                    origVideo.setName(assetVideo.getName());
+                    bcClient.updateVideo(asset.getReferenceId(), origVideo);
+                    summary.getVideo().incUpdate();
                 }
                 assetSync.setExportedSuccess(Date.from(Instant.now()));
+                summary.getVideo().incSuccess();
             }
         } catch (Exception e) {
             log.error(e);
             assetSync.setExportedError(Date.from(Instant.now()));
+            summary.getVideo().incError();
         } finally {
             assetSyncRepository.save(assetSync);
         }
     }
 
-    private void exportPlaylists() {
-        List<Long> ids = playlistSyncRepository.queryIdsForExport();
-        if (ids.isEmpty()) {
-            log.info("There are no playlist changes to export");
-            return;
-        }
-        List<List<Long>> partitions = Lists.partition(ids, PLAYLIST_PROCESSING_LIMIT);
-        partitions.forEach(currentIds -> {
-            List<PlaylistSync> result = playlistSyncRepository.findAllByIdInOrderByCreated(currentIds);
-            if (serviceProperties.isTargetPlaylistInsertEnabled()) {
-                result.forEach(this::processPlaylistSync);
-            } else {
-                result.forEach(this::processPlaylistSyncWithoutInsert);
-            }
-        });
-    }
-
-
     @Transactional
-    public void processPlaylistSync(PlaylistSync playlistSync) {
+    public void processPlaylistSync(PlaylistSync playlistSync, CompositeSummary summary) {
         try {
             if (SyncType.DELETE.equals(playlistSync.getSyncType())) {
                 playlistSync.setExportedSuccess(Date.from(Instant.now()));
+                summary.getPlaylist().incDelete();
             } else {
-                Playlist playlist = bcClient.getPlaylistsByName(playlistSync.getName());
+                Playlist playlist = bcClient.getPlaylistsById(playlistSync.getName());
                 //TODO check if all Asset has rferenceId
                 if (Objects.nonNull(playlist)) {
                     playlist.setVideoIds(toApiIds(playlistSync.getIds()));
                     bcClient.updatePlaylist(playlist);
+                    summary.getPlaylist().incUpdate();
                 } else {
                     playlist = new Playlist();
                     playlist.setName(playlistSync.getName());
-                    playlist.setDescription("mc-vod-sync");
+                    playlist.setDescription(MC_VOD_SYNC);
                     playlist.setVideoIds(toApiIds(playlistSync.getIds()));
                     bcClient.createPlaylist(playlist);
+                    summary.getPlaylist().incInsert();
                 }
                 playlistSync.setExportedSuccess(Date.from(Instant.now()));
             }
+            summary.getPlaylist().incSuccess();
         } catch (Exception e) {
             log.error(e);
             playlistSync.setExportedError(Date.from(Instant.now()));
+            summary.getPlaylist().incError();
         } finally {
             playlistSyncRepository.save(playlistSync);
         }
     }
 
-    private List<String> toApiIds(List<String> ids) {
-        return ids.stream().map(assetRepository::findReferenceIdByCatalogId).collect(Collectors.toList());
-    }
-
     @Transactional
-    public void processPlaylistSyncWithoutInsert(PlaylistSync playlistSync) {
+    public void processPlaylistSyncWithoutInsert(PlaylistSync playlistSync, CompositeSummary summary) {
         try {
             if (SyncType.DELETE.equals(playlistSync.getSyncType())) {
                 playlistSync.setExportedSuccess(Date.from(Instant.now()));
+                summary.getPlaylist().incDelete();
             } else {
-                Playlist playlist = bcClient.getPlaylistsByName(playlistSync.getName());
+                Playlist playlist = bcClient.getPlaylistsById(playlistSync.getName());
                 if (Objects.nonNull(playlist)) {
                     playlist.setVideoIds(toApiIds(playlistSync.getIds()));
                     bcClient.updatePlaylist(playlist);
+                    summary.getPlaylist().incUpdate();
                 } else {
                     log.warn("Playlist not found: {}", playlistSync.getName());
+                    summary.getPlaylist().incSkip();
                 }
                 playlistSync.setExportedSuccess(Date.from(Instant.now()));
             }
+            summary.getPlaylist().incSuccess();
         } catch (Exception e) {
             log.error(e);
             playlistSync.setExportedError(Date.from(Instant.now()));
+            summary.getPlaylist().incError();
+        } finally {
+            playlistSyncRepository.save(playlistSync);
         }
     }
+
+    private List<String> toApiIds(List<Long> ids) {
+        return ids.stream().map(assetRepository::findReferenceIdById).collect(Collectors.toList());
+    }
 }
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/SyncProcessor.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/SyncProcessor.java
new file mode 100644
index 00000000..0906b888
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/SyncProcessor.java
@@ -0,0 +1,83 @@
+package hu.user.mcvodsync.service.out;
+
+
+import com.google.common.collect.Lists;
+import hu.user.mcvodsync.db.AssetSync;
+import hu.user.mcvodsync.db.PlaylistSync;
+import hu.user.mcvodsync.db.repository.AssetSyncRepository;
+import hu.user.mcvodsync.db.repository.PlaylistSyncRepository;
+import hu.user.mcvodsync.service.ServiceProperties;
+import hu.user.mcvodsync.service.data.CompositeSummary;
+import lombok.extern.log4j.Log4j2;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Component;
+
+import java.time.Instant;
+import java.util.List;
+
+@Log4j2
+@Component
+public class SyncProcessor {
+
+    @Autowired
+    private AssetSyncRepository assetSyncRepository;
+
+    @Autowired
+    private PlaylistSyncRepository playlistSyncRepository;
+
+    @Autowired
+    private ServiceProperties serviceProperties;
+
+    @Autowired
+    private SyncExportService syncExportService;
+
+    private static final int ASSET_PROCESSING_LIMIT = 100;
+    private static final int PLAYLIST_PROCESSING_LIMIT = 10;
+
+
+    public CompositeSummary export() {
+        CompositeSummary summary = CompositeSummary.builder().started(Instant.now()).build();
+        exportAssets(summary);
+        exportPlaylists(summary);
+        summary.setFinished(Instant.now());
+        log.info(summary);
+        return summary;
+    }
+
+    private void exportAssets(CompositeSummary summary) {
+        List<Long> ids = assetSyncRepository.queryIdsForExport();
+        if (ids.isEmpty()) {
+            log.info("There are no video changes to export");
+            return;
+        }
+        List<List<Long>> partitions = Lists.partition(ids, ASSET_PROCESSING_LIMIT);
+        partitions.forEach(currentIds -> {
+            summary.getVideo().incAll();
+            List<AssetSync> result = assetSyncRepository.findAllByIdInOrderByCreated(currentIds);
+            if (serviceProperties.isTargetVideoInsertEnabled()) {
+                result.forEach(sync -> syncExportService.processAssetSync(sync, summary));
+            } else {
+                result.forEach(sync -> syncExportService.processAssetSyncWithoutInsert(sync, summary));
+            }
+        });
+    }
+
+    private void exportPlaylists(CompositeSummary summary) {
+        List<Long> ids = playlistSyncRepository.queryIdsForExport();
+        if (ids.isEmpty()) {
+            log.info("There are no playlist changes to export");
+            return;
+        }
+        List<List<Long>> partitions = Lists.partition(ids, PLAYLIST_PROCESSING_LIMIT);
+        partitions.forEach(currentIds -> {
+            summary.getPlaylist().incAll();
+            List<PlaylistSync> result = playlistSyncRepository.findAllByIdInOrderByCreated(currentIds);
+            if (serviceProperties.isTargetPlaylistInsertEnabled()) {
+                result.forEach(sync -> syncExportService.processPlaylistSync(sync, summary));
+            } else {
+                result.forEach(sync -> syncExportService.processPlaylistSyncWithoutInsert(sync, summary));
+            }
+        });
+    }
+
+}
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/VideoMapper.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/VideoMapper.java
index b257702f..d79721cb 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/VideoMapper.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/out/VideoMapper.java
@@ -2,6 +2,7 @@ package hu.user.mcvodsync.service.out;
 
 import com.brightcove.cms.client.model.Video;
 import hu.user.mcvodsync.db.Asset;
+import org.apache.commons.lang3.StringUtils;
 import org.mapstruct.Mapper;
 import org.mapstruct.ReportingPolicy;
 
@@ -9,13 +10,12 @@ import java.util.*;
 
 @Mapper(unmappedTargetPolicy = ReportingPolicy.IGNORE)
 public interface VideoMapper {
-
-    String NOTES = "notes";
-    String SHOW = "show";
-    String SEASON = "season";
-    String EPISODE = "episode";
-    String RATING_TV = "rating_tv";
-    String PRODUCTION_YEAR = "production_year";
+    String CUSTOM_NOTES = "notes";
+    String CUSTOM_SHOW = "show";
+    String CUSTOM_SEASON = "season";
+    String CUSTOM_EPISODE = "episode";
+    String CUSTOM_RATING_TV = "rating_tv";
+    String CUSTOM_PRODUCTION_YEAR = "production_year";
     String ACTORS_TALENT = "actors_talent";
     String DIRECTOR = "director";
     String GENRE = "genre";
@@ -38,20 +38,40 @@ public interface VideoMapper {
         Video result = new Video();
         result.setReferenceId(asset.getCatalogId());
         result.setName(asset.getProgLocalTitle());
-        result.putCustomFieldsItem(NOTES, asset.getHubInfo());
-        result.putCustomFieldsItem(SHOW, asset.getSeasonLocalTitle());
+        result.setLongDescription(asset.getProgSynopsisFullHun());
+        result.setDescription(asset.getProgSynopsisShortHun());
+        result.putCustomFieldsItem(CUSTOM_NOTES, asset.getHubInfo());
+        result.putCustomFieldsItem(CUSTOM_SHOW, asset.getSeasonLocalTitle());
         if (Objects.nonNull(asset.getSeasonNr())) {
-            result.putCustomFieldsItem(SEASON, asset.getSeasonNr().toString());
+            result.putCustomFieldsItem(CUSTOM_SEASON, asset.getSeasonNr().toString());
         }
         if (Objects.nonNull(asset.getEpisodeNr())) {
-            result.putCustomFieldsItem(EPISODE, asset.getEpisodeNr().toString());
+            result.putCustomFieldsItem(CUSTOM_EPISODE, asset.getEpisodeNr().toString());
         }
-        if (Objects.nonNull(asset.getAgeRating())
+        if (StringUtils.isNotBlank(asset.getAgeRating())
                 && valid_AgeRating.contains(asset.getAgeRating())) {
-            result.putCustomFieldsItem(RATING_TV, asset.getAgeRating());
+            result.putCustomFieldsItem(CUSTOM_RATING_TV, asset.getAgeRating());
         }
         if (Objects.nonNull(asset.getProductionYear())) {
-            result.putCustomFieldsItem(PRODUCTION_YEAR, asset.getProductionYear().toString());
+            result.putCustomFieldsItem(CUSTOM_PRODUCTION_YEAR, asset.getProductionYear().toString());
+        }
+        if (StringUtils.isNotBlank(asset.getDirector())) {
+            result.putCustomFieldsItem(DIRECTOR, asset.getDirector());
+        }
+        if (StringUtils.isNotBlank(asset.getDirector())) {
+            result.putCustomFieldsItem(DIRECTOR, asset.getDirector());
+        }
+        if (StringUtils.isNotBlank(asset.getXCast())) {
+            result.putCustomFieldsItem(ACTORS_TALENT, asset.getXCast());
+        }
+        if (StringUtils.isNotBlank(asset.getProgGenre1())) {
+            result.addTagsItem(asset.getProgGenre1());
+        }
+        if (StringUtils.isNotBlank(asset.getProgGenre2())) {
+            result.addTagsItem(asset.getProgGenre2());
+        }
+        if (StringUtils.isNotBlank(asset.getProgGenre3())) {
+            result.addTagsItem(asset.getProgGenre3());
         }
         return result;
     }
@@ -61,15 +81,20 @@ public interface VideoMapper {
                 .referenceId(video.getId())
                 .catalogId(video.getReferenceId())
                 .progLocalTitle(video.getName())
+                .progSynopsisFullHun(video.getLongDescription())
+                .progSynopsisShortHun(video.getDescription())
                 .build();
         Optional<Map<String, String>> opCustomFields = Optional.ofNullable(video.getCustomFields());
-        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(NOTES))).ifPresent(result::setHubInfo);
-        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(SHOW))).ifPresent(result::setSeasonLocalTitle);
-        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(SEASON))).ifPresent(val -> result.setSeasonNr(Integer.parseInt(val)));
-        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(EPISODE))).ifPresent(val -> result.setEpisodeNr(Integer.parseInt(val)));
-        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(RATING_TV))).ifPresent(result::setAgeRating);
-        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(PRODUCTION_YEAR))).ifPresent(val -> result.setProductionYear(Integer.parseInt(val)));
+        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(CUSTOM_NOTES))).ifPresent(result::setHubInfo);
+        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(CUSTOM_SHOW))).ifPresent(result::setSeasonLocalTitle);
+        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(CUSTOM_SEASON))).ifPresent(val -> result.setSeasonNr(Integer.parseInt(val)));
+        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(CUSTOM_EPISODE))).ifPresent(val -> result.setEpisodeNr(Integer.parseInt(val)));
+        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(CUSTOM_RATING_TV))).ifPresent(result::setAgeRating);
+        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(CUSTOM_PRODUCTION_YEAR))).ifPresent(val -> result.setProductionYear(Integer.parseInt(val)));
+        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(DIRECTOR))).ifPresent(result::setDirector);
+        opCustomFields.flatMap(fields -> Optional.ofNullable(fields.get(ACTORS_TALENT))).ifPresent(result::setXCast);
         return result;
     }
 
+
 }
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledExport.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledExport.java
index b97f81d1..8893abe1 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledExport.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledExport.java
@@ -1,7 +1,9 @@
 package hu.user.mcvodsync.service.schedule;
 
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import hu.user.mcvodsync.service.event.ExportCompletedEvent;
-import hu.user.mcvodsync.service.out.AssetExportService;
+import hu.user.mcvodsync.service.event.ExportStartedEvent;
+import hu.user.mcvodsync.service.out.SyncProcessor;
 import lombok.SneakyThrows;
 import lombok.extern.log4j.Log4j2;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -13,21 +15,23 @@ import org.springframework.stereotype.Component;
 public class ScheduledExport implements Runnable {
     @Autowired
     private ApplicationEventPublisher applicationEventPublisher;
-    
+
     @Autowired
-    private AssetExportService assetExportService;
+    private SyncProcessor syncProcessor;
 
     @SneakyThrows
     @Override
     public void run() {
+        CompositeSummary summary = null;
         try {
+            applicationEventPublisher.publishEvent(new ExportStartedEvent(this));
             log.info("ScheduledExport started");
-            assetExportService.export();
+            summary = syncProcessor.export();
         } catch (Exception e) {
             log.error("ScheduledExport error!", e);
         } finally {
-            applicationEventPublisher.publishEvent(new ExportCompletedEvent(null, this));
-            log.info("ScheduledImport finished");
+            applicationEventPublisher.publishEvent(new ExportCompletedEvent(this, summary));
+            log.info("ScheduledExport finished");
         }
     }
 
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledImport.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledImport.java
index f268bffe..bba8f9e6 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledImport.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledImport.java
@@ -2,9 +2,9 @@ package hu.user.mcvodsync.service.schedule;
 
 import hu.user.mcvodsync.db.UploadFile;
 import hu.user.mcvodsync.db.repository.UploadFileRepository;
+import hu.user.mcvodsync.service.data.CompositeSummary;
 import hu.user.mcvodsync.service.event.ImportCompletedEvent;
 import hu.user.mcvodsync.service.event.ImportStartedEvent;
-import hu.user.mcvodsync.service.in.ImportSummary;
 import hu.user.mcvodsync.service.in.VodXlsProcessor;
 import lombok.extern.log4j.Log4j2;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -27,12 +27,12 @@ public class ScheduledImport implements Runnable {
 
     @Override
     public void run() {
-        ImportSummary summary = null;
+        CompositeSummary summary = null;
         try {
             Optional<UploadFile> opUploadFile = uploadFileRepository.findFirstByOrderByCreatedDesc();
             if (opUploadFile.isPresent()) {
-                log.info("ScheduledImport started from {}", opUploadFile.get().getName());
                 applicationEventPublisher.publishEvent(new ImportStartedEvent(this, opUploadFile.get().getName()));
+                log.info("ScheduledImport started from {}", opUploadFile.get().getName());
                 summary = vodXlsProcessor.process(opUploadFile.get().getName(), opUploadFile.get().getFile());
             }
         } catch (Exception e) {
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledSunriseChacker.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledSunsetChacker.java
similarity index 91%
rename from mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledSunriseChacker.java
rename to mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledSunsetChacker.java
index 0ecb68c0..7b394dfb 100644
--- a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledSunriseChacker.java
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/schedule/ScheduledSunsetChacker.java
@@ -9,7 +9,7 @@ import java.util.concurrent.ThreadLocalRandom;
 @Log4j2
 @Component
 //@ConditionalOnExpression("'${mc-vod-sync.scheduler.sunrise-checker}'=='true'")
-public class ScheduledSunriseChacker implements Runnable {
+public class ScheduledSunsetChacker implements Runnable {
 
     @SneakyThrows
     @Override
diff --git a/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/time/TimeUtils.java b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/time/TimeUtils.java
new file mode 100644
index 00000000..dbde8440
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-service/src/main/java/hu/user/mcvodsync/service/time/TimeUtils.java
@@ -0,0 +1,14 @@
+package hu.user.mcvodsync.service.time;
+
+import java.text.Format;
+import java.text.SimpleDateFormat;
+import java.util.Date;
+
+public class TimeUtils {
+    private static final Format format = new SimpleDateFormat("yyyy.MM.dd. HH:mm:ss");
+
+    public static String toString(long timestamp) {
+        Date date = new Date(timestamp);
+        return format.format(date);
+    }
+}
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/ApplicationProperties.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/ApplicationProperties.java
index 38624181..344e45d2 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/ApplicationProperties.java
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/ApplicationProperties.java
@@ -12,4 +12,5 @@ import org.springframework.stereotype.Component;
 public class ApplicationProperties {
     String userName;
     String password;
+    boolean admin;
 }
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/Constants.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/Constants.java
index eb603f7b..ffb151a1 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/Constants.java
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/Constants.java
@@ -2,9 +2,8 @@ package hu.user.mcvodsync.ui;
 
 public class Constants {
     public static final String APPLICATION_NAME = "MC-VOD-SYNC";
-    public static final String NAV_IMPORT_FILE = "/import-file";
+    public static final String NAV_MAIN = "/main";
     public static final String NAV_BROWSE_REMOTE = "/browse-remote";
-    public static final String NAV_EXPORT_DATA = "/export-data";
     public static final String NAV_ASSOCIATES = "/associates";
     public static final String NAV_LOGIN = "/login";
     public static final String NAV_LOGOUT = "/logout";
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/config/ResourceConfigurer.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/config/ResourceConfigurer.java
index 3ec17f7b..cba8c67f 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/config/ResourceConfigurer.java
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/config/ResourceConfigurer.java
@@ -16,7 +16,7 @@ public class ResourceConfigurer {
         return "login";
     }
 
-    @GetMapping({Constants.NAV_IMPORT_FILE, Constants.NAV_BROWSE_REMOTE, Constants.NAV_EXPORT_DATA, Constants.NAV_ASSOCIATES})
+    @GetMapping({Constants.NAV_MAIN, Constants.NAV_BROWSE_REMOTE, Constants.NAV_ASSOCIATES})
     public String index() {
         return "index";
     }
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/config/WebSecurityConfig.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/config/WebSecurityConfig.java
index e35cc79b..c07ff7fe 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/config/WebSecurityConfig.java
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/config/WebSecurityConfig.java
@@ -41,7 +41,7 @@ public class WebSecurityConfig extends WebSecurityConfigurerAdapter {
                 .anyRequest().authenticated()
                 .and()
                 .formLogin()
-                .loginPage(Constants.NAV_LOGIN).defaultSuccessUrl(Constants.NAV_IMPORT_FILE)
+                .loginPage(Constants.NAV_LOGIN).defaultSuccessUrl(Constants.NAV_MAIN)
                 .and()
                 .logout().logoutUrl(Constants.NAV_LOGOUT).logoutSuccessUrl(Constants.NAV_LOGIN)
                 .and()
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/data/BrightCovePlaylistDataModel.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/data/BrightCovePlaylistDataModel.java
index 6b9ad0df..29c786d4 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/data/BrightCovePlaylistDataModel.java
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/data/BrightCovePlaylistDataModel.java
@@ -16,17 +16,19 @@ import java.util.List;
 @Log4j2
 @Scope(ConfigurableBeanFactory.SCOPE_PROTOTYPE)
 public class BrightCovePlaylistDataModel extends CachedSpringDataModel<Playlist> {
+
     @Autowired
     private BrightCoveClient brightCoveClient;
 
     @Override
     public List<Playlist> getResultSet(int page, int pageSize, FieldComparator sortComparator) {
-        return brightCoveClient.getPlaylists(page * pageSize, pageSize, "description:mc-vod-sync");
+        //"description:mc-vod-sync"
+        return brightCoveClient.getPlaylists(page * pageSize, pageSize, null);
     }
 
     @Override
     public int getResultSetCount() {
-        return brightCoveClient.getPlaylistCount("description:mc-vod-sync");
+        return brightCoveClient.getPlaylistCount(null);
     }
 
     public void refresh() {
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/data/BrightCoveVideoDataModel.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/data/BrightCoveVideoDataModel.java
index 959cb5a3..b094b8dd 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/data/BrightCoveVideoDataModel.java
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/data/BrightCoveVideoDataModel.java
@@ -12,9 +12,14 @@ import org.springframework.beans.factory.config.ConfigurableBeanFactory;
 import org.springframework.context.annotation.Scope;
 import org.springframework.stereotype.Component;
 import org.zkoss.zul.FieldComparator;
+import org.zkoss.zul.Messagebox;
 
+import java.util.ArrayList;
 import java.util.List;
+import java.util.Map;
 import java.util.Objects;
+import java.util.function.Function;
+import java.util.stream.Collectors;
 
 @Component
 @Log4j2
@@ -30,16 +35,50 @@ public class BrightCoveVideoDataModel extends CachedSpringDataModel<Video> {
             return null;
         }
         List<List<String>> partitions = Lists.partition(playlist.getVideoIds(), pageSize);
-        String query = StringUtils.join(partitions.get(page), ",");
-        return brightCoveClient.getVideos(pageSize * page, pageSize, query);
+        List<String> currentIds = partitions.get(page);
+        String query = StringUtils.join(currentIds, ",");
+        List<Video> unsortedList = null;
+        try {
+            unsortedList = brightCoveClient.getVideos(pageSize * page, pageSize, query);
+        } catch (Exception e) {
+            Messagebox.show(e.getMessage());
+            ArrayList<Video> videos = new ArrayList<>();
+            for (int i = 0; i < playlist.getVideoIds().size(); i++) {
+                Video video = new Video();
+                video.setName("Error!");
+                videos.add(video);
+            }
+            return videos;
+        }
+        return sortVideos(page, unsortedList, currentIds);
+    }
+
+    private static List<Video> sortVideos(int page, List<Video> unsortedList, List<String> currentIds) {
+        List<Video> result = new ArrayList<>(unsortedList.size());
+        Map<String, Video> mappedVideos;
+        try {
+            mappedVideos = unsortedList.stream().collect(Collectors.toMap(Video::getId, Function.identity()));
+            currentIds.forEach(id -> result.add(mappedVideos.get(id)));
+        } catch (Exception e) {
+            log.error(e);
+        }
+        return result;
     }
 
     @Override
     public int getResultSetCount() {
-        if (Objects.isNull(playlist) || Objects.isNull(playlist.getVideoIds())) {
+        if (Objects.isNull(playlist)) {
             return 0;
         }
-        return playlist.getVideoIds().size();
+
+        List<String> videoIds = null;
+        try {
+            videoIds = playlist.getVideoIds();
+        } catch (Exception e) {
+            log.error(e);
+        }
+
+        return Objects.isNull(videoIds) ? 0 : videoIds.size();
     }
 
     public void refresh(Playlist playlist) {
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ExportDataViewModel.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ExportDataViewModel.java
deleted file mode 100644
index 10485160..00000000
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ExportDataViewModel.java
+++ /dev/null
@@ -1,45 +0,0 @@
-package hu.user.mcvodsync.ui.view;
-
-import hu.user.mcvodsync.service.config.ScheduledTasks;
-import hu.user.mcvodsync.service.event.ExportCompletedEvent;
-import hu.user.mcvodsync.ui.Constants;
-import lombok.Getter;
-import lombok.extern.log4j.Log4j2;
-import org.springframework.context.ApplicationListener;
-import org.zkoss.bind.annotation.Command;
-import org.zkoss.bind.annotation.Init;
-import org.zkoss.zk.ui.select.annotation.VariableResolver;
-import org.zkoss.zk.ui.select.annotation.WireVariable;
-import org.zkoss.zk.ui.util.Clients;
-import org.zkoss.zkplus.spring.DelegatingVariableResolver;
-
-@Getter
-@Log4j2
-@VariableResolver(DelegatingVariableResolver.class)
-public class ExportDataViewModel implements ApplicationListener<ExportCompletedEvent> {
-
-    @WireVariable
-    private ScheduledTasks scheduledTasks;
-
-    @Init
-    public void init() {
-        Clients.evalJavaScript(String.format("pushNav('%s')", Constants.NAV_EXPORT_DATA));
-        onRefresh();
-    }
-
-    @Command
-    public void onRefresh() {
-        log.info("Refresh");
-    }
-
-    @Command
-    public void onStartExport() {
-        log.info("Starting export");
-        scheduledTasks.startExport();
-    }
-
-    @Override
-    public void onApplicationEvent(ExportCompletedEvent event) {
-        log.info("Export completed");
-    }
-}
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ImportEventHandler.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ImportEventHandler.java
index debc4c0c..3ae301a3 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ImportEventHandler.java
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ImportEventHandler.java
@@ -24,14 +24,12 @@ public class ImportEventHandler {
     @Async
     @EventListener
     public void handleEvent(ImportStartedEvent evt) {
-        log.info("ImportStartedEvent handle");
         Optional.ofNullable(startedConsumer).ifPresent(c -> c.accept(evt));
     }
 
     @Async
     @EventListener
     public void handleEvent(ImportCompletedEvent evt) {
-        log.info("ImportCompletedEvent handle");
         Optional.ofNullable(completedConsumer).ifPresent(c -> c.accept(evt));
     }
 }
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/IndexViewModel.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/IndexViewModel.java
index 27df65f8..c4b4a747 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/IndexViewModel.java
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/IndexViewModel.java
@@ -9,6 +9,7 @@ import hu.user.mcvodsync.db.repository.AssetSyncRepository;
 import hu.user.mcvodsync.db.repository.PlaylistSyncRepository;
 import hu.user.mcvodsync.db.repository.UploadFileRepository;
 import hu.user.mcvodsync.service.config.ScheduledTasks;
+import hu.user.mcvodsync.ui.ApplicationProperties;
 import hu.user.mcvodsync.ui.Constants;
 import hu.user.mcvodsync.ui.auth.CurrentProfile;
 import hu.user.mcvodsync.ui.session.SessionSettings;
@@ -31,6 +32,9 @@ import org.zkoss.zul.Messagebox;
 @Setter
 public class IndexViewModel {
 
+    @WireVariable
+    private ApplicationProperties applicationProperties;
+
     @WireVariable
     private BuildProperties buildProperties;
 
@@ -71,12 +75,13 @@ public class IndexViewModel {
     @Command
     public void onTimer() {
         BindUtils.postNotifyChange(scheduledTasks, "status");
+        BindUtils.postNotifyChange(scheduledTasks, "outOfSync");
     }
 
     @Command
     public void route(String path) {
         if (Constants.NAV_ROOT.equals(path))
-            path = Constants.NAV_IMPORT_FILE;
+            path = Constants.NAV_MAIN;
         setPage("~." + path + ".zul");
         BindUtils.postNotifyChange(this, "page");
     }
@@ -89,18 +94,24 @@ public class IndexViewModel {
     }
 
     @Command
-    public void onReset() {
-        cleanupLocal();
+    public void onResetRemote() {
         cleanupRemote();
         Messagebox.show("Cleanup completed.", "Info", Messagebox.OK, Messagebox.INFORMATION);
     }
 
+    @Command
+    public void onResetLocal() {
+        cleanupLocal();
+        Messagebox.show("Cleanup completed.", "Info", Messagebox.OK, Messagebox.INFORMATION);
+    }
+
     private void cleanupLocal() {
         log.info("cleanupLocal");
         playlistSyncRepository.deleteAllInBatch();
         assetSyncRepository.deleteAllInBatch();
         assetRepository.deleteAllInBatch();
         uploadFileRepository.deleteAllInBatch();
+        scheduledTasks.reset();
         log.info("cleanupLocal OK");
     }
 
@@ -108,6 +119,7 @@ public class IndexViewModel {
         log.info("cleanupRemote");
         cleanupRemotePlaylists();
         cleanupRemoteVideos();
+        scheduledTasks.reset();
         log.info("cleanupRemote OK");
     }
 
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ImportFileViewModel.java b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/MainViewModel.java
similarity index 91%
rename from mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ImportFileViewModel.java
rename to mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/MainViewModel.java
index 394e312b..5cf385d5 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/ImportFileViewModel.java
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/java/hu/user/mcvodsync/ui/view/MainViewModel.java
@@ -27,7 +27,7 @@ import static hu.user.mcvodsync.ui.data.common.CachedDataModel.NATURAL;
 
 @Getter
 @Log4j2
-public class ImportFileViewModel extends FilterActiveViewModel<UploadFile> {
+public class MainViewModel extends FilterActiveViewModel<UploadFile> {
 
     @WireVariable
     ImportFileDataModel importFileDataModel;
@@ -45,7 +45,7 @@ public class ImportFileViewModel extends FilterActiveViewModel<UploadFile> {
 
     @Override
     protected String getNavigation() {
-        return Constants.NAV_IMPORT_FILE;
+        return Constants.NAV_MAIN;
     }
 
     @Init
@@ -61,6 +61,7 @@ public class ImportFileViewModel extends FilterActiveViewModel<UploadFile> {
 
     @Command
     public void onTimer() {
+        BindUtils.postNotifyChange(scheduledTasks, "exportSummary");
         BindUtils.postNotifyChange(scheduledTasks, "importSummary");
     }
 
@@ -88,4 +89,10 @@ public class ImportFileViewModel extends FilterActiveViewModel<UploadFile> {
         scheduledTasks.startImport();
     }
 
+    @Command
+    public void onStartExport() {
+        scheduledTasks.startExport();
+    }
+
+
 }
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/metainfo/zk/zk.xml b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/metainfo/zk/zk.xml
index 09683498..4a764ee0 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/metainfo/zk/zk.xml
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/metainfo/zk/zk.xml
@@ -2,7 +2,7 @@
 <zk>
     <config-name/>
     <session-config>
-        <session-timeout>300</session-timeout>
+        <session-timeout>3600</session-timeout>
         <timeout-uri>/timeout</timeout-uri>
     </session-config>
     <client-config>
@@ -62,16 +62,6 @@
         <name>org.zkoss.zul.nativebar</name>
         <value>true</value>
     </library-property>
-    <language-addon>
-        <component>
-            <component-name>menuitem</component-name>
-            <extends>menuitem</extends>
-            <property>
-                <property-name>autodisable</property-name>
-                <property-value>self</property-value>
-            </property>
-        </component>
-    </language-addon>
     <!--    PROD    -->
     <!--    <desktop-config>-->
     <!--        <file-check-period>600</file-check-period>&lt;!&ndash; unit: seconds &ndash;&gt;-->
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/associates.zul b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/associates.zul
index b83435c9..b23780ce 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/associates.zul
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/associates.zul
@@ -6,24 +6,30 @@
     <!--        font-weight: bold;-->
     <!--        }-->
     <!--    </style>-->
-    <window vflex="true" viewModel="@id('vm') @init('hu.user.mcvodsync.ui.view.AssociatesViewModel')">
-        <caption label="Munkatársak"/>
+    <window vflex="true" viewModel="@id('vm') @init('hu.user.mcvodsync.ui.view.AssociatesViewModel')"
+            style="margin: 20px 0 20px 0">
         <borderlayout>
             <north flex="true">
-                <toolbar>
-                    <toolbarbutton label="Hozzáadás" iconSclass="z-icon-plus" onClick="@command('onAdd')"/>
-                    <toolbarbutton label="Szerkesztés" iconSclass="z-icon-edit" onClick="@command('onEdit')"
-                                   disabled="@load(empty vm.selectedEntity)"/>
-                    <toolbarbutton label="Törlés" iconSclass="z-icon-remove" onClick="@command('onDelete')"
-                                   disabled="@load(empty vm.selectedEntity)"/>
-                    <separator orient="vertical"/>
-                    <toolbarbutton mode="toggle" iconSclass="z-icon-check" label="Aktív"
-                                   checked="@bind(vm.filterShowActive)"/>
-                    <toolbarbutton mode="toggle" iconSclass="z-icon-ban" label="Inaktív"
-                                   checked="@bind(vm.filterShowInActive)"/>
-                    <toolbarbutton mode="toggle" iconSclass="z-icon-adjust" label="Mind"
-                                   checked="@bind(vm.filterShowBoth)"/>
-                </toolbar>
+                <vlayout>
+                    <hbox pack="start" align="center" hflex="true" vflex="true" style="padding: 10px">
+                        <label style="font-size: 1.5em; font-weight:bold; color: gray" value="USERS"/>
+                    </hbox>
+                    <toolbar>
+                        <toolbarbutton label="Add" iconSclass="z-icon-plus" onClick="@command('onAdd')"
+                                       style="font-size: 1.2em"/>
+                        <toolbarbutton label="Edit" iconSclass="z-icon-edit" onClick="@command('onEdit')"
+                                       disabled="@load(empty vm.selectedEntity)" style="font-size: 1.2em"/>
+                        <!--                        <toolbarbutton label="Delete" iconSclass="z-icon-remove" onClick="@command('onDelete')"-->
+                        <!--                                       disabled="@load(empty vm.selectedEntity)" style="font-size: 1.2em"/>-->
+                        <space bar="true"/>
+                        <toolbarbutton mode="toggle" iconSclass="z-icon-check" label="Active"
+                                       checked="@bind(vm.filterShowActive)" style="font-size: 1.2em"/>
+                        <toolbarbutton mode="toggle" iconSclass="z-icon-ban" label="Inactive"
+                                       checked="@bind(vm.filterShowInActive)" style="font-size: 1.2em"/>
+                        <toolbarbutton mode="toggle" iconSclass="z-icon-adjust" label="All"
+                                       checked="@bind(vm.filterShowBoth)" style="font-size: 1.2em"/>
+                    </toolbar>
+                </vlayout>
             </north>
             <center border="none" flex="true">
                 <listbox vflex="true" model="@load(vm.associatesDataModel)"
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/browse-remote.zul b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/browse-remote.zul
index c6d332ad..1e6a19c0 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/browse-remote.zul
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/browse-remote.zul
@@ -1,42 +1,71 @@
 <zk>
-    <window vflex="true" viewModel="@id('vm') @init('hu.user.mcvodsync.ui.view.BrowseRemoteViewModel')">
-        <caption label="Browse BrightCove"/>
+    <window vflex="true" viewModel="@id('vm') @init('hu.user.mcvodsync.ui.view.BrowseRemoteViewModel')"
+            style="margin: 20px 0 20px 0">
         <borderlayout>
             <north hflex="true">
-                <toolbar>
-                    <toolbarbutton label="Reload" iconSclass="z-icon-retweet" onClick="@command('onRefresh')"/>
-                </toolbar>
+                <vlayout>
+                    <hbox pack="start" align="center" hflex="true" vflex="true" style="padding: 10px">
+                        <label style="font-size: 1.5em; font-weight:bold; color: gray" value="BROWSE BRIGHTCOVE"/>
+                    </hbox>
+                    <toolbar>
+                        <toolbarbutton label="Reload" iconSclass="z-icon-refresh" onClick="@command('onRefresh')"
+                                       style="font-size: 1.2em"/>
+                    </toolbar>
+                </vlayout>
             </north>
             <center border="none" hflex="true" vflex="true">
 
                 <hbox spacing="0" hflex="true" vflex="true">
                     <listbox hflex="true" vflex="true" model="@load(vm.brightCovePlaylistDataModel)"
                              autopaging="true" mold="paging" pagingPosition="top" multiple="false"
-                             selectedItem="@bind(vm.selectedPlaylist)">
+                             selectedItem="@bind(vm.selectedPlaylist)" sizedByContent="true" span="true">
                         <listhead sizable="true">
                             <listheader label="ID" align="left"/>
                             <listheader label="Name" align="left"/>
                             <listheader label="Video count" align="left"/>
+                            <listheader label="Description" align="left"/>
                         </listhead>
                         <template name="model">
                             <listitem>
                                 <listcell label="@load(each.id)"/>
                                 <listcell label="@load(each.name)"/>
                                 <listcell label="@load(each.getVideoIds().size())"/>
+                                <listcell label="@load(each.description)"/>
                             </listitem>
                         </template>
                     </listbox>
                     <splitter collapse="before"/>
                     <listbox hflex="true" vflex="true" model="@load(vm.brightCoveVideoDataModel)"
-                             autopaging="true" mold="paging" pagingPosition="top" multiple="false">
+                             autopaging="true" mold="paging" pagingPosition="top" multiple="false"
+                             sizedByContent="true" span="true">
                         <listhead sizable="true">
                             <listheader label="ID" align="left"/>
-                            <listheader label="Catalog ID" align="left"/>
+                            <listheader label="Reference ID" align="left"/>
+                            <listheader label="Notes" align="left"/>
+                            <listheader label="Name" align="left"/>
+                            <listheader label="Description" align="left"/>
+                            <listheader label="Show" align="left"/>
+                            <listheader label="Season" align="left"/>
+                            <listheader label="Episode" align="left"/>
+                            <listheader label="Production year" align="left"/>
+                            <listheader label="Rating TV" align="left"/>
+                            <listheader label="Tags" align="left"/>
+                            <listheader label="Long description" align="left"/>
                         </listhead>
                         <template name="model">
                             <listitem>
                                 <listcell label="@load(each.id)"/>
                                 <listcell label="@load(each.referenceId)"/>
+                                <listcell label="@load(each.customFields['notes'])"/>
+                                <listcell label="@load(each.name)"/>
+                                <listcell label="@load(each.description)"/>
+                                <listcell label="@load(each.customFields['show'])"/>
+                                <listcell label="@load(each.customFields['season'])"/>
+                                <listcell label="@load(each.customFields['episode'])"/>
+                                <listcell label="@load(each.customFields['production_year'])"/>
+                                <listcell label="@load(each.customFields['rating_tv'])"/>
+                                <listcell label="@load(each.tags)"/>
+                                <listcell label="@load(each.longDescription)"/>
                             </listitem>
                         </template>
                     </listbox>
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/export-stats.zul b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/export-stats.zul
new file mode 100644
index 00000000..2dda2626
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/export-stats.zul
@@ -0,0 +1,181 @@
+<zk>
+    <style>
+        .bold-font {
+        font-weight: bold;
+        font-size: 1.3em;
+        }
+    </style>
+    <vlayout>
+        <grid span="true">
+            <columns>
+                <column hflex="min"/>
+                <column hflex="1"/>
+                <column hflex="1"/>
+                <column hflex="1"/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="left" valign="bottom">
+                        <label value="Started:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.startedFormatted)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Finished:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.finishedFormatted)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+        <label value="Video statistics:"/>
+        <grid span="true">
+            <columns>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="right" valign="bottom">
+                        <label value="All:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.video.all)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Success:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.video.success)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Error:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.video.error)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Skipped:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.video.skip)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+        <grid span="true">
+            <columns>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="right" valign="bottom">
+                        <label value="Inserted:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.video.insert)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Updated:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.video.update)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Deleted:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.video.delete)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+        <label value="Playlist statistics:"/>
+        <grid span="true">
+            <columns>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="right" valign="bottom">
+                        <label value="All:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.playlist.all)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Success:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.playlist.success)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Error:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.playlist.error)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Skipped:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.playlist.skip)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+        <grid span="true">
+            <columns>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="right" valign="bottom">
+                        <label value="Inserted:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.playlist.insert)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Updated:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.playlist.update)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Deleted:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.exportSummary.playlist.delete)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+
+    </vlayout>
+</zk>
\ No newline at end of file
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/import-stats.zul b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/import-stats.zul
new file mode 100644
index 00000000..7727e5b2
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/import-stats.zul
@@ -0,0 +1,180 @@
+<zk>
+    <style>
+        .bold-font {
+        font-weight: bold;
+        font-size: 1.3em;
+        }
+    </style>
+    <vlayout>
+        <grid span="true">
+            <columns>
+                <column hflex="min"/>
+                <column hflex="1"/>
+                <column hflex="1"/>
+                <column hflex="1"/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="left" valign="bottom">
+                        <label value="Started:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.startedFormatted)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Finished:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.finishedFormatted)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+        <label value="Video statistics:"/>
+        <grid span="true">
+            <columns>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="right" valign="bottom">
+                        <label value="All:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.video.all)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Success:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.video.success)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Error:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.video.error)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Skipped:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.video.skip)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+        <grid span="true">
+            <columns>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="right" valign="bottom">
+                        <label value="Inserted:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.video.insert)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Updated:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.video.update)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Deleted:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.video.delete)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+        <label value="Playlist statistics:"/>
+        <grid span="true">
+            <columns>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="right" valign="bottom">
+                        <label value="All:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.playlist.all)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Success:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.playlist.success)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Error:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.playlist.error)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Skipped:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.playlist.skip)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+        <grid span="true">
+            <columns>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+                <column/>
+            </columns>
+            <rows>
+                <row>
+                    <cell align="right" valign="bottom">
+                        <label value="Inserted:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.playlist.insert)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Updated:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.playlist.update)"/>
+                    </cell>
+                    <cell align="right" valign="bottom">
+                        <label value="Deleted:"/>
+                    </cell>
+                    <cell align="left" valign="middle">
+                        <label sclass="bold-font" value="@load(vm.scheduledTasks.importSummary.playlist.delete)"/>
+                    </cell>
+                </row>
+            </rows>
+        </grid>
+    </vlayout>
+</zk>
\ No newline at end of file
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/test.zul b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/test.zul
new file mode 100644
index 00000000..1c2e272b
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/form/test.zul
@@ -0,0 +1,3 @@
+<zk>
+    <label value="ANYÁD"/>
+</zk>
\ No newline at end of file
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/import-file.zul b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/import-file.zul
deleted file mode 100644
index 1b962a60..00000000
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/import-file.zul
+++ /dev/null
@@ -1,131 +0,0 @@
-<zk>
-    <window vflex="true" viewModel="@id('vm') @init('hu.user.mcvodsync.ui.view.ImportFileViewModel')">
-        <timer delay="2000" onTimer="@command('onTimer')" repeats="true"/>
-        <caption label="Import file"/>
-        <borderlayout>
-            <north hflex="true">
-                <toolbar>
-                    <toolbarbutton label="Upload" iconSclass="z-icon-plus" upload="true"
-                                   onUpload="@command('onUploadFile')"/>
-                    <!--                    <toolbarbutton label="Törlés" iconSclass="z-icon-remove" onClick="@command('onDelete')"-->
-                    <!--                                   disabled="@load(empty vm.selectedEntity)"/>-->
-                </toolbar>
-            </north>
-            <center border="none" hflex="true" vflex="true">
-
-                <hbox spacing="0" hflex="true" vflex="true">
-                    <listbox id="partnersList" hflex="2" vflex="true" model="@load(vm.importFileDataModel)"
-                             autopaging="true" mold="paging" pagingPosition="top" multiple="false"
-                             onSelect="@command('onListSelection')" onDoubleClick="@command('onEdit')">
-                        <listhead sizable="true">
-                            <listheader label="Created" sort="auto(created)" align="left"
-                                        sortDirection="@load(vm.cols['created'].sortDirection)"/>
-                            <listheader label="Name" sort="auto(name)" align="left"
-                                        sortDirection="@load(vm.cols['name'].sortDirection)"/>
-                            <listheader label="Size" sort="auto(size)" align="left"
-                                        sortDirection="@load(vm.cols['size'].sortDirection)"/>
-                        </listhead>
-                        <template name="model">
-                            <listitem>
-                                <listcell label="@load(each.created)"/>
-                                <listcell label="@load(each.name)"/>
-                                <listcell label="@load(each.size)"/>
-                            </listitem>
-                        </template>
-                    </listbox>
-                    <splitter collapse="before"/>
-                    <window title="Last import statistics" hflex="true" vflex="true">
-                        <vlayout>
-                            <grid span="true">
-                                <columns>
-                                    <column hflex="min"/>
-                                    <column hflex="1"/>
-                                    <column hflex="min"/>
-                                    <column hflex="1"/>
-                                </columns>
-                                <rows>
-                                    <row>
-                                        <cell align="left" valign="bottom">
-                                            <label value="Started:"/>
-                                        </cell>
-                                        <cell align="center" valign="middle">
-                                            <label value="@load(vm.scheduledTasks.importSummary.started)"
-                                                   sclass="hightlight"/>
-                                        </cell>
-                                        <cell align="left" valign="bottom">
-                                            <label value="Finished:"/>
-                                        </cell>
-                                        <cell align="center" valign="middle">
-                                            <label value="@load(vm.scheduledTasks.importSummary.finished)"
-                                                   sclass="hightlight"/>
-                                        </cell>
-                                    </row>
-                                </rows>
-                            </grid>
-                            <grid span="true">
-                                <columns>
-                                    <column/>
-                                    <column/>
-                                    <column/>
-                                    <column/>
-                                    <column/>
-                                    <column/>
-                                </columns>
-                                <rows>
-                                    <row>
-                                        <cell align="right" valign="bottom">
-                                            <label value="All:"/>
-                                        </cell>
-                                        <cell align="left" valign="middle">
-                                            <label value="@load(vm.scheduledTasks.importSummary.all)"
-                                                   sclass="hightlight"/>
-                                        </cell>
-                                        <cell align="right" valign="bottom">
-                                            <label value="Success:"/>
-                                        </cell>
-                                        <cell align="left" valign="middle">
-                                            <label value="@load(vm.scheduledTasks.importSummary.success)"
-                                                   sclass="hightlight"/>
-                                        </cell>
-                                        <cell align="right" valign="bottom">
-                                            <label value="Error:"/>
-                                        </cell>
-                                        <cell align="left" valign="middle">
-                                            <label value="@load(vm.scheduledTasks.importSummary.error)"
-                                                   sclass="hightlight"/>
-                                        </cell>
-                                    </row>
-                                    <row>
-                                        <cell align="right" valign="bottom">
-                                            <label value="Inserted:"/>
-                                        </cell>
-                                        <cell align="left" valign="middle">
-                                            <label value="@load(vm.scheduledTasks.importSummary.inserted)"
-                                                   sclass="hightlight"/>
-                                        </cell>
-                                        <cell align="right" valign="bottom">
-                                            <label value="Updated:"/>
-                                        </cell>
-                                        <cell align="left" valign="middle">
-                                            <label value="@load(vm.scheduledTasks.importSummary.updated)"
-                                                   sclass="hightlight"/>
-                                        </cell>
-                                        <cell align="right" valign="bottom">
-                                            <label value="Deleted:"/>
-                                        </cell>
-                                        <cell align="left" valign="middle">
-                                            <label value="@load(vm.scheduledTasks.importSummary.deleted)"
-                                                   sclass="hightlight"/>
-                                        </cell>
-                                    </row>
-                                </rows>
-                            </grid>
-
-                        </vlayout>
-                    </window>
-                </hbox>
-
-            </center>
-        </borderlayout>
-    </window>
-</zk>
\ No newline at end of file
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/index.zul b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/index.zul
index b863493f..da9f5e87 100644
--- a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/index.zul
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/index.zul
@@ -26,7 +26,7 @@
         }
     </script>
     <window vflex="true" viewModel="@id('vm') @init('hu.user.mcvodsync.ui.view.IndexViewModel')">
-        <timer delay="2000" onTimer="@command('onTimer')" repeats="true"/>
+        <timer delay="1000" onTimer="@command('onTimer')" repeats="true"/>
         <caption sclass="header" id="appHeader">
             <div style="display: block">
                 <div style="display: inline; float: left">
@@ -67,17 +67,20 @@
                 <vlayout>
                     <hlayout valign="middle">
                         <menubar autodrop="true" hflex="true">
-                            <menuitem iconSclass="z-icon-cloud-download" label="Import file"
-                                      onClick="@command(vm.route(Constants.NAV_IMPORT_FILE))"/>
-                            <menuitem iconSclass="z-icon-cloud-upload" label="Export data"
-                                      onClick="@command(vm.route(Constants.NAV_EXPORT_DATA))"/>
+                            <menuitem iconSclass="z-icon-retweet" label="Synchronization"
+                                      onClick="@command(vm.route(Constants.NAV_MAIN))"/>
                             <menuitem image="~./static/images/bc.ico" label="Browse BrightCove"
                                       onClick="@command(vm.route(Constants.NAV_BROWSE_REMOTE))"/>
-                            <menuseparator/>
+                            <menuseparator visible="@load(vm.applicationProperties.admin)"/>
                             <menuitem iconSclass="z-icon-user" label="Users"
-                                      onClick="@command(vm.route(Constants.NAV_ASSOCIATES))"/>
-                            <menuitem iconSclass="z-icon-trash" label="Reset data"
-                                      onClick="@command('onReset')"/>
+                                      onClick="@command(vm.route(Constants.NAV_ASSOCIATES))"
+                                      visible="@load(vm.applicationProperties.admin)"/>
+                            <menuitem iconSclass="z-icon-trash" label="Reset local data"
+                                      onClick="@command('onResetLocal')"
+                                      visible="@load(vm.applicationProperties.admin)"/>
+                            <menuitem iconSclass="z-icon-trash" label="Reset remote data"
+                                      onClick="@command('onResetRemote')"
+                                      visible="@load(vm.applicationProperties.admin)"/>
                         </menubar>
                         <hbox hflex="min" pack="right">
                         </hbox>
@@ -87,11 +90,17 @@
             <center border="none" hflex="true">
                 <include src="@load(vm.page)" hflex="true" vflex="true"/>
             </center>
-            <south height="50px">
-                <hbox pack="end" align="center" hflex="true" vflex="true">
-                    <label style="font-size: 1.5em; padding-right: 20px; color: navy"
-                           value="@load(vm.scheduledTasks.status)"/>
-                </hbox>
+            <south>
+                <hlayout>
+                    <hbox pack="start" align="center" hflex="true" vflex="true">
+                        <label style="font-size: 1.5em; font-weight: bold; padding: 20px; color: red"
+                               value="Out of sync!" visible="@load(vm.scheduledTasks.outOfSync)"/>
+                    </hbox>
+                    <hbox pack="end" align="center" hflex="true" vflex="true">
+                        <label style="font-size: 1.5em; padding: 20px; color: navy"
+                               value="@load(vm.scheduledTasks.status)"/>
+                    </hbox>
+                </hlayout>
             </south>
         </borderlayout>
     </window>
diff --git a/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/main.zul b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/main.zul
new file mode 100644
index 00000000..d458fd9a
--- /dev/null
+++ b/mc-vod-sync/mc-vod-sync-ui/src/main/resources/web/main.zul
@@ -0,0 +1,62 @@
+<zk>
+    <window vflex="true" viewModel="@id('vm') @init('hu.user.mcvodsync.ui.view.MainViewModel')"
+            style="margin: 20px 0 20px 0">
+        <timer delay="1000" onTimer="@command('onTimer')" repeats="true"/>
+        <borderlayout>
+            <north hflex="true">
+                <vlayout>
+                    <hbox pack="start" align="center" hflex="true" vflex="true" style="padding: 10px">
+                        <label style="font-size: 1.5em; font-weight:bold; color: gray" value="SYNCHRONIZATION"/>
+                    </hbox>
+                    <toolbar>
+                        <toolbarbutton label="Import" iconSclass="z-icon-cloud-download" upload="true"
+                                       onUpload="@command('onUploadFile')" style="font-size: 1.2em"/>
+                        <!--                    <space bar="true"/>-->
+                        <separator orient="vertical"/>
+                        <toolbarbutton label="Export" iconSclass="z-icon-cloud-upload"
+                                       onClick="@command('onStartExport')" style="font-size: 1.2em"/>
+                    </toolbar>
+                </vlayout>
+            </north>
+            <center border="none" hflex="true" vflex="true">
+
+                <hbox spacing="0" hflex="true" vflex="true">
+                    <listbox id="partnersList" hflex="2" vflex="true" model="@load(vm.importFileDataModel)"
+                             autopaging="true" mold="paging" pagingPosition="top" multiple="false"
+                             onSelect="@command('onListSelection')" onDoubleClick="@command('onEdit')">
+                        <listhead sizable="true">
+                            <listheader label="Created" sort="auto(created)" align="left"
+                                        sortDirection="@load(vm.cols['created'].sortDirection)"/>
+                            <listheader label="Name" sort="auto(name)" align="left"
+                                        sortDirection="@load(vm.cols['name'].sortDirection)"/>
+                            <listheader label="Size" sort="auto(size)" align="left"
+                                        sortDirection="@load(vm.cols['size'].sortDirection)"/>
+                        </listhead>
+                        <template name="model">
+                            <listitem>
+                                <listcell label="@load(each.created)"/>
+                                <listcell label="@load(each.name)"/>
+                                <listcell label="@load(each.size)"/>
+                            </listitem>
+                        </template>
+                    </listbox>
+                    <splitter/>
+                    <div hflex="true" vflex="true" style="overflow: auto">
+                        <vbox spacing="0" hflex="true" vflex="true">
+                            <window title="Last import" hflex="true" style="margin: 10px" border="normal"
+                                    visible="@load(not empty vm.scheduledTasks.importSummary)">
+                                <include src="~./form/import-stats.zul"/>
+                            </window>
+                            <window title="Last export" hflex="true" style="margin: 10px" border="normal"
+                                    visible="@load(not empty vm.scheduledTasks.exportSummary)">
+                                <include src="~./form/export-stats.zul"/>
+                            </window>
+                        </vbox>
+                    </div>
+
+                </hbox>
+
+            </center>
+        </borderlayout>
+    </window>
+</zk>
\ No newline at end of file
-- 
2.54.0