Alexander Dunkel<p>Just published a small tool we use in our non-profit to export user data from <a href="https://himself.alexanderdunkel.com/tags/Keycloak" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Keycloak</span></a> into Excel or LibreCalc ODS format. It pulls standard and custom fields like IBAN, birthdate, phone, etc., using the Keycloak Admin API. You can run it through a SOCKS proxy if access is restricted. We need this to unite online (Keycloak) and offline accounts (<a href="https://himself.alexanderdunkel.com/tags/JVerein" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>JVerein</span></a>).</p><p>Config is done via a `.env` file, and the output is a clean Excel/ODS file you can use for reporting or integration. Repo here [1] — feel free to use or adapt it! </p><p><a href="https://himself.alexanderdunkel.com/tags/keycloak" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>keycloak</span></a> <a href="https://himself.alexanderdunkel.com/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>python</span></a> <a href="https://himself.alexanderdunkel.com/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://himself.alexanderdunkel.com/tags/nonprofit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nonprofit</span></a> <a href="https://himself.alexanderdunkel.com/tags/automation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>automation</span></a> <br><a href="https://himself.alexanderdunkel.com/tags/excel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>excel</span></a> <a href="https://himself.alexanderdunkel.com/tags/adminapi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>adminapi</span></a> <a href="https://himself.alexanderdunkel.com/tags/ods" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ods</span></a> <a href="https://himself.alexanderdunkel.com/tags/jverein" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jverein</span></a> </p><p>[1]: <a href="https://framagit.org/lausitzer-surfer-eV/management/pull_user_keycloak" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">framagit.org/lausitzer-surfer-</span><span class="invisible">eV/management/pull_user_keycloak</span></a></p>