Login Register

All gists

MrGeneration

MrGeneration / Zammad CSV-Import for Users and Organizations

Last active 20 hours ago csv import users organizations

Sample CSV files to highlight the CSV import function - as shown in the youtube video https://www.youtube.com/watch?v=OeelYx106WU

0 0 2
1 login,firstname,lastname,email,web,phone,fax,mobile,department,street,zip,city,country,address,vip,verified,active,note,last_login,out_of_office,out_of_office_start_at,out_of_office_end_at,roles,two_factor_preferences,out_of_office_replacement,organizations,chat_agent_created_by,chat_agent_updated_by,overview_sortings,organization
2 mherrguth@example.com,Marcel,Herrguth,mherrguth@example.com,"","","","",,"","","","",,false,false,true,"",,false,,,Customer,"",,"",,,"",
3 some-employee@example.com,Marcel,Herrguth,some-employee@example.com,"",+492214710231,"","","","","","","","",false,false,true,"",2024-11-26T17:01:15Z,false,,,Admin~~~Agent~~~Customer,"",,"",,,"",Zammad GmbH
4 nicole.braun@zammad.org,Nicole,Braun,nicole.braun@zammad.org,"","","","","","","","","","",false,false,true,"",,false,,,Customer,"",,"",,,"",Zammad Foundation
MrGeneration

MrGeneration / Zammad-Repository Upgrades for Packager

Last active 1 month ago zammad repository change apt debian
0 0 1
1 # This quickly changes from the old packager.io to the new packager.io repository
2 # Commands require sudo / root permissions
3
4 # Drop existing GPG-Key and Repository-File
5 rm -f /etc/apt/trusted.gpg.d/pkgr-zammad.gpg /etc/apt/sources.list.d/zammad.list
6
7 # Download the new Keyring
8 curl -fsSL "https://go.packager.io/srv/deb/zammad/zammad/gpg-key.gpg" \
9 -o /usr/share/keyrings/zammad.gpg
MrGeneration

MrGeneration / KB Catalan redirect

Last active 3 months ago zammad knowledge base catalan es-ca

Redirects outdated locale slug for knowledge bases from 'es-ca' to 'ca' for improved usability and very easy switching. As shown in the Zammad 7.0 Release video: https://www.youtube.com/watch?v=unwYUx5--7M

0 0 2
1 # Default /help URL (replace help with your custom alias if needed; NOT for custom domains)
2 rewrite ^/help/es-ca/(.*)$ /help/ca/$1 permanent;
3
4 # for custom URLs
5 rewrite ^/es-ca/(.*)$ /ca/$1 permanent;
MrGeneration

MrGeneration / Backup Paperless NGX with restic

Last active 3 months ago restic backup restore paperless

As shown on https://youtu.be/P-Pr7Dy6mP8

0 0 4
1 #!/usr/bin/env bash
2 #
3 # 2025-09-25 Marcel Herrguth
4 # As shown on https://youtu.be/P-Pr7Dy6mP8
5 # Attribution back to this GIST is required!
6 #
7 # Parts of this script are oriented from https://github.com/zammad/zammad/tree/develop/contrib/backup
8 # This script supports PostGreSQL (docker) stacks only and expects your media to be in a mounted folder.
9 #
10 # Restoration only works on a pre-installed Paperless NGX installation of the same version (or higher).
MrGeneration

MrGeneration / Backup Zammad with restic

Last active 3 months ago restic backup restore zammad

As shown on https://youtu.be/P-Pr7Dy6mP8

0 0 2
1 #!/usr/bin/env bash
2 #
3 # 2025-09-06 Marcel Herrguth
4 # As shown on https://youtu.be/P-Pr7Dy6mP8
5 # Attribution back to this GIST is required!
6 #
7 # Parts of this script are oriented from https://github.com/zammad/zammad/tree/develop/contrib/backup
8 # Only PostGreSQL is supported; No symlinks are supported
9 #
10 # Restoration only works on a pre-installed Zammad installation of the same version (or higher).
MrGeneration

MrGeneration / Search and Replace Gitlab / Github URLs in Tickets

Last active 3 months ago

These snippets allow you to search and replace either just your Gitlab / Github URL or whole group / project URLs if needed. Proceed with care, you cannot undo this operation.

0 0 2
1 # URLs below can contain project / group URLs, but have to fit as this script
2 # does a very simple search and replace.
3 # Backup first
4 old_gitlab_url = 'https://git.my-old.domain/'
5 new_gitlab_url = 'https://git.my-new.domain/'
6
7 Ticket.where("preferences LIKE '%gitlab%'").find_in_batches.each do |b|
8 b.each do |t|
9 next if t.preferences[:gitlab][:issue_links].count.zero?
MrGeneration

MrGeneration / Install and Configure Grafana with Zammad

Last active 3 months ago

This gist provides contextual copy paste options for Using Grafana with Zammad. Video context to this: https://youtu.be/CdGdKE4hjUU

0 0 6
1 ##################### Grafana Configuration Example #####################
2 #
3 # Everything has defaults so you only need to uncomment things you want to
4 # change
5
6 # possible values : production, development
7 ;app_mode = production
8
9 # instance name, defaults to HOSTNAME environment variable value or hostname if HOSTNAME var is empty
10 ;instance_name = FQDN