346 lines
14 KiB
Ruby
346 lines
14 KiB
Ruby
# Copyright (C) 2012-2022 Zammad Foundation, https://zammad-foundation.org/
|
|
|
|
class SettingUpdates < ActiveRecord::Migration[6.0]
|
|
def change
|
|
|
|
return if !Setting.exists?(name: 'system_init_done')
|
|
|
|
settings_update = [
|
|
{
|
|
title: '2 lower case and 2 upper case characters',
|
|
name: 'password_min_2_lower_2_upper_characters',
|
|
description: 'Password needs to contain 2 lower case and 2 upper case characters.',
|
|
},
|
|
{
|
|
title: 'User email for multiple users',
|
|
name: 'user_email_multiple_use',
|
|
description: 'Allow using one email address for multiple users.',
|
|
},
|
|
{
|
|
title: 'sipgate.io alternative FQDN',
|
|
name: 'sipgate_alternative_fqdn',
|
|
description: 'Alternative FQDN for callbacks if you operate Zammad in an internal network.',
|
|
},
|
|
{
|
|
title: 'Auto Assignment',
|
|
name: 'ticket_auto_assignment',
|
|
},
|
|
{
|
|
title: 'BCC address for all outgoing emails',
|
|
name: 'system_bcc',
|
|
description: 'To archive all outgoing emails from Zammad to external, you can store a BCC email address here.',
|
|
},
|
|
{
|
|
title: 'Additional follow-up detection',
|
|
name: 'postmaster_follow_up_search_in',
|
|
description: 'By default, the follow-up check is done via the subject of an email. This setting lets you add more fields for which the follow-up check will be executed.',
|
|
},
|
|
{
|
|
title: 'Note - default visibility',
|
|
name: 'ui_ticket_zoom_article_note_new_internal',
|
|
description: 'Defines the default visibility for new notes.',
|
|
},
|
|
{
|
|
title: 'Defines postmaster filter.',
|
|
name: '0014_postmaster_filter_own_notification_loop_detection',
|
|
description: 'Defines postmaster filter to check if the email is a self-created notification email, then ignore it to prevent email loops.',
|
|
},
|
|
{
|
|
title: 'HTTP type',
|
|
name: 'http_type',
|
|
description: 'Defines the HTTP protocol of your instance.',
|
|
},
|
|
{
|
|
title: 'Defines the timeframe during which a self-created note can be deleted.',
|
|
name: 'ui_ticket_zoom_article_delete_timeframe',
|
|
},
|
|
{
|
|
title: 'Import Endpoint',
|
|
name: 'import_freshdesk_endpoint',
|
|
description: 'Defines a Freshdesk endpoint to import users, tickets, states, and articles.',
|
|
},
|
|
{
|
|
title: 'Import Endpoint',
|
|
name: 'import_kayako_endpoint',
|
|
description: 'Defines a Kayako endpoint to import users, tickets, states, and articles.',
|
|
},
|
|
{
|
|
title: 'Import Endpoint',
|
|
name: 'import_otrs_endpoint',
|
|
description: 'Defines an OTRS endpoint to import users, tickets, states, and articles.',
|
|
},
|
|
{
|
|
title: 'Import Endpoint',
|
|
name: 'import_zendesk_endpoint',
|
|
description: 'Defines a Zendesk endpoint to import users, tickets, states, and articles.',
|
|
},
|
|
{
|
|
title: 'Stats Backend',
|
|
name: 'Stats::TicketWaitingTime',
|
|
description: 'Defines a dashboard stats backend that gets scheduled automatically.',
|
|
},
|
|
{
|
|
title: 'Stats Backend',
|
|
name: 'Stats::TicketEscalation',
|
|
description: 'Defines a dashboard stats backend that gets scheduled automatically.',
|
|
},
|
|
{
|
|
title: 'Stats Backend',
|
|
name: 'Stats::TicketChannelDistribution',
|
|
description: 'Defines a dashboard stats backend that gets scheduled automatically.',
|
|
},
|
|
{
|
|
title: 'Stats Backend',
|
|
name: 'Stats::TicketLoadMeasure',
|
|
description: 'Defines a dashboard stats backend that gets scheduled automatically.',
|
|
},
|
|
{
|
|
title: 'Stats Backend',
|
|
name: 'Stats::TicketInProcess',
|
|
description: 'Defines a dashboard stats backend that gets scheduled automatically.',
|
|
},
|
|
{
|
|
title: 'Stats Backend',
|
|
name: 'Stats::TicketReopen',
|
|
description: 'Defines a dashboard stats backend that gets scheduled automatically.',
|
|
},
|
|
{
|
|
title: 'Import Password for HTTP basic authentication',
|
|
name: 'import_otrs_password',
|
|
description: 'Defines HTTP basic authentication password (only if OTRS is protected via HTTP basic auth).',
|
|
},
|
|
{
|
|
title: 'Developer System',
|
|
name: 'developer_mode',
|
|
description: 'Defines if the application is in developer mode (all users have the same password and password reset will work without email delivery).',
|
|
},
|
|
{
|
|
title: 'Group selection for ticket creation',
|
|
name: 'form_ticket_create_group_id',
|
|
description: 'Defines the group of tickets created via web form.',
|
|
},
|
|
{
|
|
title: 'Limit tickets by IP per day',
|
|
name: 'form_ticket_create_by_ip_per_day',
|
|
description: 'Defines a limit for how many tickets can be created via web form from one IP address per day.',
|
|
},
|
|
{
|
|
title: 'Limit tickets by IP per hour',
|
|
name: 'form_ticket_create_by_ip_per_hour',
|
|
description: 'Defines a limit for how many tickets can be created via web form from one IP address per hour.',
|
|
},
|
|
{
|
|
title: 'Limit tickets per day',
|
|
name: 'form_ticket_create_per_day',
|
|
description: 'Defines a limit for how many tickets can be created via web form per day.',
|
|
},
|
|
{
|
|
title: 'Defines postmaster filter.',
|
|
name: '5400_postmaster_filter_jira_check',
|
|
description: 'Defines postmaster filter to identify Jira mails for correct follow-ups.',
|
|
},
|
|
{
|
|
title: 'Defines postmaster filter.',
|
|
name: '5401_postmaster_filter_jira_check',
|
|
description: 'Defines postmaster filter to identify Jira mails for correct follow-ups.',
|
|
},
|
|
{
|
|
title: 'Defines postmaster filter.',
|
|
name: '0950_postmaster_filter_bounce_delivery_permanent_failed',
|
|
description: 'Defines postmaster filter to identify postmaster bounces; and disables sending notification if delivery fails permanently.',
|
|
},
|
|
{
|
|
title: 'Defines postmaster filter.',
|
|
name: '0955_postmaster_filter_bounce_delivery_temporary_failed',
|
|
description: 'Defines postmaster filter to identify postmaster bounces; and reopens tickets if delivery fails permanently.',
|
|
},
|
|
{
|
|
title: 'Defines postmaster filter.',
|
|
name: '0900_postmaster_filter_bounce_follow_up_check',
|
|
description: 'Defines postmaster filter to identify postmaster bounces; and handles them as follow-up of the original tickets',
|
|
},
|
|
{
|
|
title: 'Defines postmaster filter.',
|
|
name: '5400_postmaster_filter_service_now_check',
|
|
description: 'Defines postmaster filter to identify ServiceNow mails for correct follow-ups.',
|
|
},
|
|
{
|
|
title: 'Defines postmaster filter.',
|
|
name: '5401_postmaster_filter_service_now_check',
|
|
description: 'Defines postmaster filter to identify ServiceNow mails for correct follow-ups.',
|
|
},
|
|
{
|
|
title: 'Defines postmaster filter.',
|
|
name: '0005_postmaster_filter_trusted',
|
|
description: 'Defines postmaster filter to remove X-Zammad headers from untrustworthy sources.',
|
|
},
|
|
{
|
|
title: 'HTML Email CSS Font',
|
|
name: 'html_email_css_font',
|
|
description: 'Defines the CSS font information for HTML emails.',
|
|
},
|
|
{
|
|
title: 'Geo IP Service',
|
|
name: 'geo_ip_backend',
|
|
description: 'Defines the backend for geo IP lookups. Also shows location of an IP address if it is traceable.',
|
|
},
|
|
{
|
|
title: 'CTI config',
|
|
name: 'cti_config',
|
|
description: 'Defines the CTI config.',
|
|
},
|
|
{
|
|
title: 'Set agent limit',
|
|
name: 'system_agent_limit',
|
|
description: 'Defines the agent limit.',
|
|
},
|
|
{
|
|
title: 'Product Name',
|
|
name: 'product_name',
|
|
description: 'Defines the name of the application, shown in the web interface, tabs, and title bar of the web browser.',
|
|
},
|
|
{
|
|
title: 'Define postmaster filter.',
|
|
name: '5500_postmaster_internal_article_check',
|
|
description: 'Defines postmaster filter which sets the articles visibility to internal if it is a rely to an internal article or the last outgoing email is internal.',
|
|
},
|
|
{
|
|
title: 'CTI customer last activity',
|
|
name: 'cti_customer_last_activity',
|
|
description: 'Defines the duration of customer activity (in seconds) on a call until the user profile dialog is shown.',
|
|
},
|
|
{
|
|
title: 'Slack config',
|
|
name: 'slack_config',
|
|
description: 'Defines the Slack config.',
|
|
},
|
|
{
|
|
title: 'Auto-close state',
|
|
name: 'icinga_auto_close_state_id',
|
|
description: 'Defines the state of auto-closed tickets.',
|
|
},
|
|
{
|
|
title: 'Auto-close state',
|
|
name: 'nagios_auto_close_state_id',
|
|
description: 'Defines the state of auto-closed tickets.',
|
|
},
|
|
{
|
|
title: 'Auto-close state',
|
|
name: 'check_mk_auto_close_state_id',
|
|
description: 'Defines the state of auto-closed tickets.',
|
|
},
|
|
{
|
|
title: 'Auto-close state',
|
|
name: 'check_mk_auto_close_state_id',
|
|
description: 'Defines the state of auto-closed tickets.',
|
|
},
|
|
{
|
|
title: 'Locale',
|
|
name: 'locale_default',
|
|
description: 'Defines the default system language.',
|
|
},
|
|
{
|
|
title: 'Timezone',
|
|
name: 'timezone_default',
|
|
description: 'Defines the default system timezone.',
|
|
},
|
|
{
|
|
title: 'Defines transaction backend.',
|
|
name: '9100_cti_caller_id_detection',
|
|
description: 'Defines the transaction backend which detects caller IDs in objects and stores them for CTI lookups.',
|
|
},
|
|
{
|
|
title: 'User Organization Selector - email',
|
|
name: 'ui_user_organization_selector_with_email',
|
|
description: 'Defines if the email should be displayed in the result of the user/organization widget.',
|
|
},
|
|
{
|
|
title: 'GitHub App Credentials',
|
|
name: 'auth_github_credentials',
|
|
description: 'Enables user authentication via GitHub.',
|
|
},
|
|
{
|
|
title: 'Customer selection based on sender and receiver list',
|
|
name: 'postmaster_sender_is_agent_search_for_customer',
|
|
description: 'If the sender is an agent, set the first user in the recipient list as the customer.',
|
|
},
|
|
{
|
|
title: 'Import API key for requesting the Freshdesk API',
|
|
name: 'import_freshdesk_endpoint_key',
|
|
description: 'Defines Freshdesk endpoint authentication API key.',
|
|
},
|
|
{
|
|
title: 'Import API key for requesting the Zendesk API',
|
|
name: 'import_zendesk_endpoint_key',
|
|
description: 'Defines Zendesk endpoint authentication API key.',
|
|
},
|
|
{
|
|
title: 'Knowledge Base active',
|
|
name: 'kb_active',
|
|
description: 'Defines if Knowledge Base navbar button is enabled.',
|
|
},
|
|
{
|
|
title: 'Knowledge Base active publicly',
|
|
name: 'kb_active_publicly',
|
|
description: 'Defines if Knowledge Base navbar button is enabled for users without Knowledge Base permission.',
|
|
},
|
|
{
|
|
title: 'Knowledge Base multilingual support',
|
|
name: 'kb_multi_lingual_support',
|
|
description: 'Support of multilingual Knowledge Base.',
|
|
},
|
|
{
|
|
title: 'Maximum Email Size',
|
|
name: 'postmaster_max_size',
|
|
description: 'Defines the maximum accepted email size in MB.',
|
|
},
|
|
{
|
|
title: 'Maximum failed logins',
|
|
name: 'password_max_login_failed',
|
|
description: 'Defines after how many failed logins accounts will be deactivated.',
|
|
},
|
|
{
|
|
title: 'Sender based on Reply-To header',
|
|
name: 'postmaster_sender_based_on_reply_to',
|
|
description: 'Set/overwrite sender/from of email based on "Reply-To" header. Useful to set correct customer if email is received from a third-party system on behalf of a customer.',
|
|
},
|
|
{
|
|
title: 'Ticket Last Contact Behaviour',
|
|
name: 'ticket_last_contact_behaviour',
|
|
description: 'Sets the last customer contact based on either the last contact of the customer in general or on the last contact of the customer that has not received a response.',
|
|
},
|
|
{
|
|
title: 'CTI Token',
|
|
name: 'cti_token',
|
|
description: 'Token for CTI.',
|
|
},
|
|
{
|
|
title: 'CTI integration',
|
|
name: 'cti_integration',
|
|
description: 'Defines if generic CTI integration is enabled or not.',
|
|
},
|
|
{
|
|
title: 'Placetel Token',
|
|
name: 'placetel_token',
|
|
description: 'Defines the token for Placetel.',
|
|
},
|
|
]
|
|
|
|
settings_update.each do |setting|
|
|
fetched_setting = Setting.find_by(name: setting[:name])
|
|
next if !fetched_setting
|
|
|
|
if setting[:title]
|
|
# "Updating title of #{setting[:name]} to #{setting[:title]}"
|
|
fetched_setting.title = setting[:title]
|
|
end
|
|
|
|
if setting[:description]
|
|
# "Updating description of #{setting[:name]} to #{setting[:description]}"
|
|
fetched_setting.description = setting[:description]
|
|
end
|
|
|
|
fetched_setting.save!
|
|
end
|
|
end
|
|
end
|