Utilisation de l'IA - Phase 2:Continuous update of the prompts libraryEnsure proper utilisation across departments BREVO product owner Background: Our current CRM’s proposal to the clients involves sending newsletters, either as one-time blasts or on a regular schedule. However, we're lacking the proper follow-up and comprehensive marketing automation suite that Brevo offers. Therefore, we want to develop new services using Brevo's capabilities to offer these recurring services to the 25 clients already using Brevo and to the rest who haven’t.(Taking Google Ads Management as an example). Pipeline: 1. Greg owns always the set-up stageHA’s roadmap:Now: Business develomentUp coming 6 months: Brevo TLNext 12 months: Brevo Prod freelance
Strat de commercialisation de l’app commune pour upsell clients actuels + démarchage nouvelles communes Doc de travail: https://docs.google.com/spreadsheets/d/1bP9bFelQ69qy9R0R9s3vrxJ7TArY9UdS_S5RYL0HWJY/edit?gid=95763387#gid=95763387 Debut de brainstorm new features communes: https://app.paymoapp.com/#/Paymo.Projects/3221282/tasks/progress—> intégrer add-ons CRM/Brevo?
GOAL: Setup Premium featuresGUIDELINES / RELATED INFORMATION:--- Premium ---✓ Hébergement sécurisé✓ Certificat SSL Let's Encrypt✓ Certificat SSL personnel (non fourni)✓ Mises à jour CMS✓ 50G de stockage✓ Nom de domaine personnalisé pour les e-mails sortants✓ Backups 15 jours✓ SLA 99.5%✓ Firewall & CDN (WAF)✓ Monitoring uptime (alertes)✓ Frais annuelsASSIGNED ROLES: FE/IT/TL
CARD GOAL:Run an overall health check of a client squad's client portfolio to ensure setup errors are addressed. Check the subtasks of this card. TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed. ROLES ASSIGNED:CLIENT SQUAD : Client Satisfaction & Squad ProfitabilitySQUAD MANAGER > Quality & Profit > Delegates TLCSM > Client Satisfaction & Revenue > Delegates PO DELIVERY TEAM : Delivers on time, within budget and according to our quality standardsPO (STRAT) > Prioritizes > what to doTL > Decompose stories & builds the team > How to do it and by whom WORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each month Projects:EntrapaulusAlupseFondation Chrëschte mam SahelValorluxLes ThermesMedirelALK / LuxekineLWK / Sou SchmaachtBe ActiveLAAPepin
CARD GOAL:Run an overall health check of a client squad's client portfolio to ensure setup errors are addressed. Check the subtasks of this card. TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed. ROLES ASSIGNED:CLIENT SQUAD : Client Satisfaction & Squad ProfitabilitySQUAD MANAGER > Quality & Profit > Delegates TLCSM > Client Satisfaction & Revenue > Delegates PO DELIVERY TEAM : Delivers on time, within budget and according to our quality standardsPO (STRAT) > Prioritizes > what to doTL > Decompose stories & builds the team > How to do it and by whom WORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each month Projects:LetzshopPidalClean CenterBrinksLARNordpartsCloos KrausMa PharmacieSacemCravatPain Quotidien
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.USEFUL LINKS:GA4GA4 joinGA4 Dashboard CommerçantsRapport d’heures venteRapport d’heures commerçantsPlan mediaGoogle AdsMeta AdsMailchimpMonitoring VentesMonitoring CommerçantsWORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.USEFUL LINKS:GA4Rapport d’heuresPlan mediaGoogle AdsMeta AdsBrevoCMS Formse-Shop ReportsWORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.WORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthUSEFUL LINKS:GA4Rapport d’heuresPlan mediaGoogle AdsMeta AdsBrevoCMS Requests Form ContactCMS Requests Form ServiceCMS Request Révision TondeusesCMS Requests Révision Tracteurs CMS Requests JobsROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.WORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthUSEFUL LINKS:GA4Rapport d’heuresPlan mediaGoogle AdsMeta AdsMailchimp CMS Formse-Shop ReportsROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.USEFUL LINKS:GA4Rapport d’heuresPlan mediaGoogle AdsMeta AdsBrevoe-Shop ReportsWORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.USEFUL LINKS:GA4Rapport d’heuresPlan mediaGoogle AdsMeta AdsBrevoCMS Formse-Shop ReportsWORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.USEFUL LINKS:GA4Rapport d’heuresPlan mediaGoogle AdsMeta AdsBrevoCMS FormsWORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.USEFUL LINKS:GA4Rapport d’heuresPlan mediaGoogle AdsMeta AdsBrevoCMS FormsWORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.USEFUL LINKS:GA4Rapport d’heuresPlan médiaGoogle AdsMeta AdsBrevoCMS Requests Formse-Shop ReportsWORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.USEFUL LINKS:GA4Rapport d’heuresPlan mediaGoogle AdsMeta AdsBrevoCMS Formse-Shop ReportsWORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthROLES ASSIGNED:Project owner (PO), Team Lead (TL)
CARD GOAL:Run an overall health check of a client project to ensure production errors are addressed. Check the subtasks of this card.TASK DESCRIPTION:Once per month, we all need to run a health check using the checklist below for all the projects they are assigned to, and ensure all spotted issues are addressed.USEFUL LINKS:GA4Rapport d’heuresPlan mediaGoogle AdsMeta AdsBrevoCMS Formse-Shop Reports ?WORKING FRAME:- Feel free to use the comment section in this card- to do before the 15th of each monthROLES ASSIGNED:Project owner (PO), Team Lead (TL)
Le pack communes a plusieurs "Modules Complémentaires" https://invoice.zoho.eu/app/20074211986#/inventory/items/154037000000886045?filter_by=Status.All&per_page=200&search_criteria=%7B%22search_text%22%3A%22pack%22%7D&sort_column=created_time&sort_order=A → Verifier si certaines communes ont eu des modules ajoutés que l’on n’a pas facturé
CARD GOAL: Cleanup hosting so we don't keep migrated website active on old hosting for example.ASSIGNED ROLES: IT, CSM(, DEV) IP was : 35.156.119.142
CARD GOAL: Cleanup hosting so we don't keep migrated website active on old hosting for example.ASSIGNED ROLES: IT, CSM(, DEV)
CARD GOAL: Cleanup hosting so we don't keep migrated website active on old hosting for example. VPS AWS à supprimer pour le … (en attente confirmation client) ASSIGNED ROLES: IT, CSM(, DEV)
CARD GOAL: Cleanup hosting so we don't keep migrated website active on old hosting for example.ASSIGNED ROLES: IT, CSM(, DEV)
Il existe sur les ancien Quilium 1 et 2 des cronjobs qui appellent des URL backend (HTTP Crons) qui doivent se logger dans le CMS pour executer des script HTTP. Je pense que certains jobs Q2 tournent encore qqpart mais apellent des sites qui ont migrés sur Q3. Il faudrait les désactiver
Websites or apps are too often down for whatever reason. It seems restarting php-fpm or apache/nginx resolve the issue.Is it possible to setup a watchdog or a similar service that restarts all web services when website/app are down ?Legacy is also concerned.
Briefing:After the migration on new VPS we faced a huge performance degradation.Valorlux is unusable online (load exploding, MYSQL take a while, and PHP out of processes)Lesthermes has a loading time x4 compared to old VPS (DB problem too ?) → meaning impossible to use this config on courses booking dayObjective :Check new VPS and PHP/Mysql configuration to optimize performance and run smoothly like older VPS configurationRun a stress test with some tool to validate new configuration is working with some traffic
CARD GOAL: Cleanup hosting so we don't keep migrated website active on old hosting for example.VPS AWS à supprimer pour le 12/09/2024ASSIGNED ROLES: IT, CSM(, DEV)
Certains access log ne remontent pas dans kibana via logstash. Installer filebeat 6.8 https://www.elastic.co/fr/support/matrix#matrix_compatibility
CARD GOAL: Cleanup hosting so we don't keep migrated website active on old hosting for example.ASSIGNED ROLES: IT, CSM(, DEV)
CARD GOAL IT system monitoring is (slowly) transitioning from Sensu to Sensu Go. At the moment VPS instances are splitted between both apps.TASK DESCRIPTIONThe following checks are performed :keepalivecheck_disk_usagecheck_load_averagecheck_apache_statuscheck_https_certcheck_postfix_queuecheck_memory_usagecheck_mysql_statuscheck_s3_backupcheck_http_statusEvery state change to critical can trigger an alert in our ticketing system for immediate remediationGUIDELINES / RELATED INFORMATIONMore info about EOL schedule here : https://sensu.io/blog/eol-schedule-for-sensu-core-and-enterpriseLegacy Sensu : https://sensu.e-connect.lu:3000 (admin/admin)Sensu Go : https://sensugo.e-connect.lu:3000 (use your own credentials)ASSIGNED ROLES: IT
CARD GOAL: Keep VPS servers updated.TASK DESCRIPTION: check VPS in sub-tasks.ASSIGNED ROLES: IT
CARD GOAL: Keep VPS servers updated.TASK DESCRIPTION: check VPS in sub-tasks.ASSIGNED ROLES: IT
CARD GOAL IT system monitoring is (slowly) transitioning from Sensu to Sensu Go. At the moment VPS instances are splitted between both apps.TASK DESCRIPTIONThe following checks are performed :keepalivecheck_disk_usagecheck_load_averagecheck_apache_statuscheck_https_certcheck_postfix_queuecheck_memory_usagecheck_mysql_statuscheck_s3_backupcheck_http_statusEvery state change to critical can trigger an alert in our ticketing system for immediate remediationGUIDELINES / RELATED INFORMATIONMore info about EOL schedule here : https://sensu.io/blog/eol-schedule-for-sensu-core-and-enterpriseLegacy Sensu : https://sensu.e-connect.lu:3000 (admin/admin)Sensu Go : https://sensugo.e-connect.lu:3000 (use your own credentials)ASSIGNED ROLES: IT
CARD GOAL: installer le Gestion de bannière cookie dynamique Cookiebot ou CookieFirst installer Cookiebot sur Q3 www et le retirer sur Q1 shopWORKING FRAME (TO BE FILLED BY THE CSM BEFORE STARTING):SubscriptionCCM Provider: CookiebotCCM Subscription : Smalle-connect Subscription : SmallBilling : deduced from project hours CCM set up:Affected websites/subdomains: https://www.lesthermes.net/Set up: e-connectGUIDELINES & RELATED INFORMATION:Related Documents: ticket number, mail, devis...ASSIGNED ROLES: DA, FE
CARD GOAL: Migration dans le cadre de l’abonnement de service de gestion GDPR WORKING FRAME (TO BE FILLED BY THE CSM BEFORE STARTING):By default, I copy the cookiebot setting. If the setup change. Please let me know.ASSIGNED ROLES: DA, FE
StorageVMsCloud networking (Router, VPN, firewall, etc)Local networking Plan d’action :Contacter Marco pour password DC adminDC1 et DC2 : couper et reconfigurer le routeur et son dhcp.Mysql : récupérer un dump et l’archiver sur FS1FS1 : faire le tri (cold storage pour archive, google drive pour ce qui est utilisé)NAS : faire le tri idem, et réutiliser le serveur pour Jess avec SSDUNMS : A dégager, on ne sait pas à quoi ca sert exacterment.UNIFY : A dégager, reset les access point et les configurer 1 à 1
Résumé de la refelxion (sprint 0) intégration Podcast, services marketing, po brevo, paperless office …..Chaque vendredi, on change de thématique :Definition d’un Product OwnerAugmenter la valeur d’un produit specifique PROJET PAYMO : 1 projet “PAPERLESS OFFICE” gérant le backlog des projets internes+ 3 projets maximum liés au Paperless Office concernant les outils (permet de mieux tracer l’avancée des sous taches)
CARD GOAL: help client create a sendinblue account and get access to it through the e-connect agency account.ASSIGNED ROLES: Team Lead (TL) Front End (FE), Graphic Designer (GD)RESOURCES: Sendinblue Docs: https://developers.sendinblue.com/
Invalid text representation: 7 ERROR: invalid input syntax for type uuid: "[]" (SQL: select itemset_media.* from "itemset_media" left join "itemset_mediacateg" on (array_to_json(array["itemset_media"."categ"])->>0)::uuid = "itemset_mediacateg"."id" order by "itemset_mediacateg"."name" asc, "itemset_media"."id" desc limit 50 offset 0)
Briefing maxime : supervisor has tried to autorestart the worker after a crash (database was updating) but 1 minute later it stopped restarting. Worker was offline 24H hours...Supervisor should try to restart after crash less aggressively, wait more time before restarting, and keep trying way more times.
Refonte de la partie AccountPhp 8.2 + laravel 10 & upgrade librairies (PLUS TARD)New UI (remove angular)New Admin areaQC & Go Live + compatibilityASSIGNED ROLES: [CSM, DEV]
GOAL: Setup Premium featuresGUIDELINES / RELATED INFORMATION:--- Premium ---✓ Hébergement sécurisé✓ Certificat SSL Let's Encrypt✓ Certificat SSL personnel (non fourni)✓ Mises à jour CMS✓ 50G de stockage✓ Nom de domaine personnalisé pour les e-mails sortants✓ Backups 15 jours✓ SLA 99.5%✓ Firewall & CDN (WAF)✓ Monitoring uptime (alertes)✓ Frais annuelsASSIGNED ROLES: FE/IT/TL
Création d’une documentation client pour Q3 & Pour décharger le support des questions fréquentes Arborescence de niveau 1: Customize your website: Concerne l’utilisation du CMS, des éléments de contenus, des pages etc,… SEO & Accessibility: Concerne les bases du SEO et de l’accessibilité dans quilium Knowledge base: Concerne les questions récurrentes pas forcément liées au CMS (vider son cache, etc,…) et le vocabulaire de base (élément de contenu, CMS, collection, etc,…) Add-ons: Concerne les upsells (réservations de salles, form builder, etc,…) + chatbot lié au support. Updates : Concerne les nouveautés Q3 + Opt in newsletter FAQ:
CARD GOAL:Optimiser la vitesse du CMS (chargement navigation, collections, … medias ?)Ajouter un loader dans le chargement des collectionsVidéo loom : https://www.loom.com/share/b7dc545cbfe243b7a431dc4701f4634fASSIGNED ROLES: DEV
Cahier des charges pour la refonte et savoir comment vous envisageriez de l’organiser (timing, distribution du budget). Quels seraient les coûts du développement de l’application du côté commandes sacs bleus et les coûts d’entretien annuels ?Job to do:Migration de valorlux.lu vers Q3 + Application de gestion sur mesure Si nous réalisons une migration technique vers Q3 + App de gestion sur mesure nous ne recommandons pas de faire les services uniques optionnels maintenant.L’encryptage des données s’appliquera aussi à l’app (dans le cas d’une migration Q3 + app). Naturellement une migration est un budget à prévoir dans ce cas qui doit être estimé suite à une analyse complète. A la grande louche nous estimons environ 35 à 55 jours, ce qui correspond à un budget de 33.600 à 52.800 €. Les frais récurrents restent à estimer.C.f. mail du 30/01/2024Bonjour Charlotte, Claude, j'espère que vous allez bien. Comme promis, je reviens vers vous concernant des adaptations et des mises à jour de sécurité sur le site valorlux.lu suite aux tentatives de hack du mois de décembre 2023. Nous avons encore eu une attaque hier matin, nous avons du relancer le serveur. Aucune fuite de données, mais le serveur est tombé.Nous avons 3 cas de figure que nous aimerions discuter avec vous de vive voix en call. Nous vous conseillons vivement de planifier un budget les prochaines années pour planifier une migration technique de valorlux.lu de Quilium 2 vers la nouvelle technologie Quilium 3 + application de gestion développée sur mesure, vu le caractère sensible des données personnelles traitées par Valorlux. Quilium 2 repose sur une technologie plus ancienne, problématique pour garantir la sécurité à long terme. Une migration vers une technologie plus moderne et up to date s'imposera à moyen terme. Voici donc les 3 cas de figure dee ce que nous pouvons faire dans un premier temps. Services uniques Quick fix En annexe, un devis avec des quick fix suivants: Mots de passe:- Demande de réinitialisation du mot de passe (admin & users lors de leur prochain login)- Imposer mot de passe fort Firewall :- Affinement des règles Services uniques Optionnels sur Q2 - déconseillé si une migration technique vers Q3 sera réalisée dans les 2 ans à venir. Nous conseillons également l'implémentation de ces optimisations que nous avons mis en optionnel dans le devis en annexe - si nous restons dans l'infrastructure actuelle de Quilium 2 : - Encryptage données privées (en cas de hack réussi, toutes les données privées ne seront pas exploitables)- Mise à jour des librairies Q2 (client API CRM, etc) (Dans la limite du possible sur infrastructure existante). Migration de valorlux.lu vers Q3 + Application de gestion sur mesure Si nous réalisons une migration technique vers Q3 + App de gestion sur mesure nous ne recommandons pas de faire les services uniques optionnels maintenant.L’encryptage des données s’appliquera aussi à l’app (dans le cas d’une migration Q3 + app). Naturellement une migration est un budget à prévoir dans ce cas qui doit être estimé suite à une analyse complète. A la grande louche nous estimons environ 35 à 55 jours, ce qui correspond à un budget de 33.600 à 52.800 €. Les frais récurrents restent à estimer.