{
$schema: "https:\/\/raw.githubusercontent.com\/VitexSoftware\/php-vitexsoftware-multiflexi-core\/refs\/heads\/main\/schema\/application.json",
image: "",
name: {
cs: "V\u00fdpisy Raiffeisenbank pro PohodaSQL a Sharepoint",
en: "Raiffeisenbank statements for PohodaSQL+Sharepoint"
},
description: {
cs: "Importujte v\u00fdpisy Raiffeisenbank do Pohody p\u0159es mServer a ulo\u017ete je do Sharepointu",
en: "Import Raiffeisenbank statements into Pohoda via mServer and store in Sharepoint"
},
executable: "pohodasql-raiffeisenbank-statements-sharepoint",
homepage: "https:\/\/github.com\/Spoje-NET\/pohoda-raiffeisenbank",
uuid: "e9893573-24aa-4518-bf05-66fae9ad153c",
tags: [
"Raiffeisen",
"Bank",
"Statements",
"Pohoda"
],
version: "1.7.1.222",
schemaVersion: "3.3.0",
requirements: [
"RaiffeisenBank",
"SQLServer",
"Office365",
"MServer"
],
environment: {
ACCOUNT_CURRENCY: {
type: "string",
description: "for multicurrency accounts please specify one",
defval: "",
required: false
},
ACCOUNT_NUMBER: {
type: "string",
description: "Bank Account Number",
defval: "",
required: true
},
APP_DEBUG: {
type: "bool",
description: "Show debug messages",
defval: "0",
required: false
},
CERT_FILE: {
type: "string",
description: "Path to RB Certificate file",
defval: "",
required: true
},
CERT_PASS: {
type: "password",
description: "Certificate password",
defval: "",
required: true
},
CNB_CACHE: {
type: "string",
description: "Use CNB cache to get actual rate from CNB",
defval: "http:\/\/localhost\/cnb-cache",
required: false
},
DB_CONNECTION: {
type: "string",
description: "Database Connection",
defval: "sqlsrv",
required: true
},
DB_DATABASE: {
type: "string",
description: "Database Name",
defval: "StwPh_12345678_2023",
required: true
},
DB_HOST: {
type: "string",
description: "Database Host",
defval: "127.0.0.1",
required: true
},
DB_PASSWORD: {
type: "password",
description: "Database Password",
defval: "",
required: true
},
DB_PORT: {
type: "integer",
description: "Database Port",
defval: "1433",
required: true
},
DB_SETTINGS: {
type: "string",
description: "Database Settings like encrypt=false",
defval: "",
required: false
},
DB_USERNAME: {
type: "string",
description: "Database Username",
defval: "sa",
required: true
},
EASE_LOGGER: {
type: "string",
description: "write log messages using",
defval: "console|syslog",
required: false
},
FIXED_RATE: {
type: "integer",
description: "Fixed rate for converting foreign currency transactions to CZK",
defval: "0",
required: false
},
FIXED_RATE_AMOUNT: {
type: "integer",
description: "Fixed rate amount for some currencies (e.g., \ud83d\udcb4)",
defval: "100",
required: false
},
IMPORT_SCOPE: {
type: "string",
description: "Time scope of transactions downloaded",
defval: "auto",
required: true
},
OFFICE365_CLIENTID: {
type: "string",
description: "Office 365 Client ID",
defval: "",
required: false
},
OFFICE365_CLSECRET: {
type: "string",
description: "Office 365 Client Secret",
defval: "",
required: false
},
OFFICE365_PASSWORD: {
type: "password",
description: "Office 365 Password",
defval: "",
required: false
},
OFFICE365_PATH: {
type: "string",
description: "Office 365 Path",
defval: "",
required: true
},
OFFICE365_SECRET: {
type: "string",
description: "Office 365 Secret",
defval: "",
required: false
},
OFFICE365_SITE: {
type: "string",
description: "Office 365 Site",
defval: "",
required: true
},
OFFICE365_TENANT: {
type: "string",
description: "Office 365 Tenant",
defval: "",
required: true
},
OFFICE365_USERNAME: {
type: "string",
description: "Office 365 Username",
defval: "",
required: false
},
POHODA_BANK_IDS: {
type: "string",
description: "Pohoda Bank IDs",
defval: "KB",
required: true
},
POHODA_COMPRESS: {
type: "bool",
description: "Pohoda Compress",
defval: "0",
required: false
},
POHODA_DEBUG: {
type: "bool",
description: "Pohoda Debug",
defval: "0",
required: false
},
POHODA_TIMEOUT: {
type: "integer",
description: "Pohoda Timeout",
defval: "60",
required: true
},
RATE_OFFSET: {
type: "string",
description: "Rate offset to get rate for previous day",
defval: "yesterday",
required: false
},
RBAPI_RATE_LIMIT_JSON_FILE: {
type: "string",
description: "write API rate limit file using",
defval: "{MULTIFLEXI_TMP}\/rbczpremiumapi_rates.json",
required: false
},
RESULT_FILE: {
type: "string",
description: "write output json data to",
defval: "bank_import_report_{ACCOUNT_NUMBER}.json",
required: false
},
STATEMENT_LINE: {
type: "set",
description: "Bank Statement line",
defval: "ADDITIONAL",
required: false
},
STATEMENT_SAVE_DIR: {
type: "string",
description: "Place for PDF files",
defval: "",
required: false
},
XIBMCLIENTID: {
type: "string",
description: "ClientID",
defval: "",
required: true
},
ZABBIX_KEY: {
type: "string",
description: "Default name for Zabbix Item key name",
defval: "Raiff-Import-{ACCOUNT_NUMBER}",
required: false
}
},
artifacts: [
{
name: {
cs: "Report importu",
en: "Import report"
},
path: "bank_import_report_{\\d+}.json$",
type: "file",
description: {
cs: "Stavy v\u00fdpisu: sta\u017een\u00ed z banky, import do pohody, nahr\u00e1t\u00ed do sharepointu, p\u0159\u00edloha linku do Pohody",
en: "Stauses of Statement: download from bank, import to Pohoda, upload to Shatepoint, Attachment link in Pohoda"
}
}
]
}
Download raiffeisenbank_statements_for_pohodasql_sharepoint.multiflexi.app.json