Warning: Undefined array key "subpage" in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_contactform/serendipity_event_contactform.php on line 504. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/lib3/src/Netcarver/Textile/Parser.php on line 2181. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/lib3/src/Netcarver/Textile/Parser.php on line 2181. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Warning: Undefined array key "comment" in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 180. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 180. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/lib3/src/Netcarver/Textile/Parser.php on line 2181. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Warning: Undefined array key "html_nugget" in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 180. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 180. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Notice: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/lib3/src/Netcarver/Textile/Parser.php on line 2181. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Warning: Undefined array key "ep_disable_markup_serendipity_event_imageselectorplus:34ba0343cf0d7f01a68354358af1be85" in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_imageselectorplus/serendipity_event_imageselectorplus.php on line 594. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Warning: Undefined array key "ep_disable_markup_serendipity_event_imageselectorplus:34ba0343cf0d7f01a68354358af1be85" in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_imageselectorplus/serendipity_event_imageselectorplus.php on line 594. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
CSVs und seine Fallstricke | Bernds RappelkisteSkip to content
Notice: Only variable references should be returned by reference in /var/www/virtual/bauigel/bernd.distler.ws/include/db/mysqli.inc.php on line 101. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
Nun dachte ich ja, nach meinen Versuchen hier und hier, hätte ich nun alle Daten korrekt auf mein iPhone übertragen…doch weit gefehlt
Ich habe mir jetzt nochmals alles Schritt für Schritt angesehen und festgestellt, dass in der gesicherten Datei aus PIMbackup zwar alle Daten enthalten sind, beim Einlesen in Excel oder OpenOffice gehen dann jedoch Daten verloren.
Das Problem: PIMbackup speichert für die Kontakte die Fotos mit in die CSV-Datei, wodurch diese sehr viele Daten enthält. Auch, wenn man beim Import dann sagt, dass die Foto-Spalte ignoriert werden soll, werden die Werte nach dieser Spalte ignoriert. Daher hatte ich für die Leute mit Fotos (was meistens dann natürlich wichtige Leute sind) keinerlei Kontaktdaten mehr in meinem neuen Adressbuch.
Leider lässt sich das auch mit einfachen Mitteln oder Einstellungen in den Tabellenkalkulationen nicht übergehen, man muss daher die CSV-Datei aus PIMbackup vorher in einem Texteditor bearbeiten, welcher RegEx (eine Such-Sprache) unterstützt. Für Windows würde ich hier Notepad++ empfehlen.
Im folgenden mal ein Screenshot von Notepad++ für Windows, wie man hier im Menü „Search” – „Replace…” vorgehen muss:
Als Suchbegriff gibt man
0x..,
an, das Feld für den Ersatz-Begriff lässt man leer (auch kein Leerzeichen!). Danach speichert man die Datei am Besten unter einem anderen Namen und prüft dann, ob die Werte alle bei Kontakten mit Fotos jetzt alle korrekt in Excel/OOo importiert werden können.
Für Linux/Ubuntu hat mir Christian (ein Bekannter aus dem OpenStreetMap-Bereich) weiter geholfen, nochmals meinen herzlichsten Dank dafür!
Man benötigt im Endeffekt nur das Paket csvtool, dann kann man mit dem Befehl
csvtool -t \; -u \; col 1-8,10- ./contacts_YYYYMMDD.csv > ./contacts_YYYYMMDD.new.csv
die Daten ohne die Foto-Spalte (sollte in diesem Fall Spalte 9 sein) in eine neue csv-Datei speichern. Sollte die falsche Spalte weg sein, einfach nochmal mit anderen Spalten (der Bereich nach col) versuchen.
Mit dieser Datei kann man nun wieder an geeigneter Stelle mit der anderen Anleitung weiter machen
Warning: Undefined variable $headcss in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_lightbox/serendipity_event_lightbox.php on line 226. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==
Warning: Cannot modify header information - headers already sent by (output started at /var/www/virtual/bauigel/bernd.distler.ws/include/compat.inc.php:207) in Unknown on line 0. For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt