From 1c6828ba59053f56e2fd2f13ecb2725f24ce8383 Mon Sep 17 00:00:00 2001
From: Vincent Vanwaelscappel <vincent@cubedesigners.com>
Date: Mon, 9 Feb 2026 15:03:31 +0100
Subject: [PATCH] wip #7868 @0.5

---
 src/app/Magic/Traits/CustomDataSource.php | 11 +++++++++--
 1 file changed, 9 insertions(+), 2 deletions(-)

diff --git a/src/app/Magic/Traits/CustomDataSource.php b/src/app/Magic/Traits/CustomDataSource.php
index e522c58..856c6f6 100644
--- a/src/app/Magic/Traits/CustomDataSource.php
+++ b/src/app/Magic/Traits/CustomDataSource.php
@@ -63,7 +63,7 @@ trait CustomDataSource
             $keys[] = $row[$pk];
         }
 
-        $toInsert = array_diff($keys, $existingKeys);
+        $toInsert = $keys;
         $toDelete = array_diff($existingKeys, $keys);
 
         $inserts = [];
@@ -73,8 +73,14 @@ trait CustomDataSource
             }
         }
 
+
         try {
-            static::insert($inserts);
+            foreach ($inserts as $key => $i) {
+                $id = [$pk => $key];
+                $data = $i;
+                unset($data[$pk]);
+                static::updateOrCreate($id, $data);
+            }
         } catch (\Exception $e) {
             $hadError = true;
             Log::error($e);
@@ -124,4 +130,5 @@ trait CustomDataSource
         touch(static::getDataLastChangeFile());
     }
 
+
 }
-- 
2.39.5