Categories: All - excel - modernization - deployment

by bilal chraibi 3 years ago

313

2020 projects

The document outlines a variety of projects and technological considerations for 2020, focusing on an Excel add-in and the investigation of JavaScript frameworks. It emphasizes the importance of understanding how cookies and login tokens work for persistence, and how caching mechanisms might be implemented using dictionaries or data tables.

2020 projects

2020 projects

Team

Scrum meetings
Workshops
containers, angular & react, .net core, azure, and git
share knowledge / level up
Sharing gathering ?
work on lvl 1-2 tasks

Long-term

Mobile app
Xamarin
Cordova is dead
distribution
Use quartz ?
Cloud
Statelessness
BUS (rabbitmq, ... )
Microservices architecture
Investigate IIS deploy with virtual
Investigate Orchestrator in-code (orchard)
Azure for Devs

Security

Gather questions for consulting
Hashing for passwords
Distribution / other things may break
requirements
Distribution
Co-existence, what would it look like ?

Retrocompatilibty is NTH

Convert script ?

One or the other is fine

Multi-platform (mac / office 365 / windows)
Deployment / updates
How to provide multiple versions
In the store?
Investigate Js frameworks technologies
How would the cache work ? dictionaries / data table
Cookies ?
Persistence ? (login token)
Demo / train on Excel add-in

Olap

Use SSAS in Nectari ?
On pause for now

Process Design

xml to db
Need UX to know which framework ?
Can start UI / UX work

Medium term

Frontend
flexicious deprecated ? check with Christophe
Prototype process design in different languages ?
Is it worth modernizing ?

We could code new features in new technologies

modernization

Component-based approach

Incremental approach

Split features ?

move admin features to new technology

use Iframes style ?

React ? Easier than Angular

Es5 to es6 ?

Kendo

Ask kendo about upgrading jquery

Remove progressively ?

Backend
5.replace security with authentication server (identity)

Nectari Security

do we need to change BD / what happens when we upgrade

Script to migrate

plug identity with existing BD ?

Analyse

4.Replace dataservice with dbProvider

@lib handling

Connection details of additional connectors

OLEDB to review

3.DbExpressions plug visitors

Nuget

SQLGen

2.switch everything to .net core
1.Do merge of BI Service and components (remove the windows service)

olap jobservice calls to redo

Check with clients that have the BIService installed without the webclient

Need to change the documentation

Need to check where the logs will be stored

The JobService and the distribution needs to be changed into webAPIs as well

Fix the pipeline of the build

QA and test integration

need to fix the package installation

need to fix the cloud provisionning

distribution calls to redo

rewrite calls of scheduler

excel add-in calls to redo

rewrite wcf calls to webapi (swagger)

Plug WCF service generator

Shared project reuse type

Versionning and updates

Not solved the proper way. We have manual part in that

Azure devops server

Cloud ?

Better machine

Cloud vs On Prem

Agents not working

Git

Learn

History ?

Branches

Prod vs release vs new feature vs bug fixes

Repos management

Nugets

Do we need to branch often

Datasync

How can I test code and debug nuget without committing a new nuget

is monorepo a bad thing ? see google

How many repos would we need ?

We don't want too many

Understand how the pipeline are built

Alain is working on providing the big picture of the pipelines/builds/packages

Intégration Tests

Short-term

Investigate Cake
Cheikh
Patrick
Olivia
R&D Doc
R&D project
Jira filter
Audit feedback
Finish V9
Finish Datasync
Prepare Jira
Excel add-in
code management
Investigation

Wix

front-end modernization

Backend Modernization
PROD