MrGeneration / Zammad CSV-Import for Users and Organizations
0 likes
0 forks
2 files
Last active 19 hours ago
Sample CSV files to highlight the CSV import function - as shown in the youtube video https://www.youtube.com/watch?v=OeelYx106WU
| 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 | 4,mherrguth@example.com,Marcel,Herrguth,mherrguth@example.com,"","","","",,"","","","",,false,false,true,"",,false,,,Customer,"",,"",,,"", |
| 3 | 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 | 2,nicole.braun@zammad.org,Nicole,Braun,nicole.braun@zammad.org,"","","","","","","","","","",false,false,true,"",,false,,,Customer,"",,"",,,"",Zammad Foundation |
MrGeneration / Zammad-Repository Upgrades for Packager
0 likes
0 forks
1 files
Last active 1 month ago
| 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 / KB Catalan redirect
0 likes
0 forks
2 files
Last active 3 months ago
| 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 / Useful Minio Console and Restic commands
0 likes
0 forks
4 files
Last active 3 months ago
| 1 | { |
| 2 | "Version": "2012-10-17", |
| 3 | "Statement": [ |
| 4 | { |
| 5 | "Effect": "Allow", |
| 6 | "Action": ["s3:*"], |
| 7 | "Resource": ["arn:aws:s3:::resticsample/*"] |
| 8 | } |
| 9 | ] |
| 10 | } |
MrGeneration / Backup Paperless NGX with restic
0 likes
0 forks
4 files
Last active 3 months ago
| 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 / Backup Zammad with restic
0 likes
0 forks
2 files
Last active 3 months ago
| 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 / Search and Replace Gitlab / Github URLs in Tickets
0 likes
0 forks
2 files
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.
| 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 / Limit Elasticsearch Memory Usage
0 likes
0 forks
1 files
Last active 3 months ago
Code snippet to create linked storage directories for Zammad. As shown in https://youtu.be/EorlfrN6n60
| 1 | # /etc/elasticsearch/jvm.options.d/heap-size.conf |
| 2 | # Below limits Elasticsearch to 1GB memory usage |
| 3 | # It uses 50% of your hosts memory by default otherwise |
| 4 | -Xms1g |
| 5 | -Xmx1g |
MrGeneration / Move Store from DB to File (linked directory)
0 likes
0 forks
2 files
Last active 3 months ago
Code snippet to create linked storage directories for Zammad. As shown in https://youtu.be/EorlfrN6n60
| 1 | # Below works with existing data storage. STOP Zammad during below operation |
| 2 | mv /opt/zammad_storage/ /opt/zammad_storage/ |
| 3 | ln -s /opt/zammad_storage/ /opt/zammad/storage |
| 4 | chown zammad:zammad /opt/zammad_storage/ |
| 5 | chmod 700 /opt/zammad_storage/ |
MrGeneration / Install and Configure Grafana with Zammad
0 likes
0 forks
6 files
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
| 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 |
Newer
Older