Guideline for Finno charts
CMS & finnoscore
We have a Content Management System (powered by STRAPI) to manage dynamic content for the FinnoConsult websites. Visit this page to access CMS admin: CMS Login
The CMS is password protected is required, you can by contacting firstname.lastname@example.org
The Finno Chart generator & FinnoScore tools utilise the data from the CMS.
FinnoScore data is managed manually on local machines separately as Excel, and finalized separately from this website using macros.
Both the official finnoscore tool
and the protected Chart generator tool
uses the same input data from the CMS.
Choose Finnoscore uploader on the left sidebarYou should see the following pagePick a date/periodBe careful, if you don't want to overwrite an already existing file, don't use an upload with the same date!Select the file you want to uploadAfter a successful upload you should see your file below:
Preview draft data in Finnoscore
You can preview your uploaded data by clicking to the PREVIEW buttonIt will navigate you to FinnoScore tool, and then starts to load your previewed data If you notice that an image (bank logo) is missing, it is likely that the required asset is not uploaded to the CMS. Look at how to upload an asset to the Media Library
Status can be Draft | Current | Previous | Legacy. Initially it becomes Draft on data upload, but then we Finalize a particular dataset. The very latest Final status would be considered as Current (used by FinnoScore tool), comparing trend graphs to Previous Finals. All previous (meaning, more than 2 years old), would become Legacy.
When you use the chart generator you usually want to use DRAFT statuses.
Uploaded file format should be XLS, XLSM or any Excel compatible extension, also it has to match our column format configuration.
Manually adjust Excel file
Open the file you want to edit or create a new Excel document.Select the row you want to edit or select an empty row/cell after existing data. To select an entire row you need to click on the row number at the left side. After you have selected the desired row, just copy (Command+C | CTRL+C) it, then select the target cell where you want to paste it. Paste it with Command+V (on Mac) or CTRL+V (on Windows).Now that you duplicated the row, you can easily edit the data to whatever you want. Important!!! In the excel file Import Banken tab, the Logo (FileName) should be the exact name of the logo you will upload to the STRAPI media library. In the excel file, you don't have to upload the image, it is just the name of the bank logo. Strapi will search in the media library for the same image name you added to the excel file.After you have achieved your goal with the editing, save the file and upload it to the cms in the strapi file uploader. Go to Plugins -> Media Library on the left sidebar panel in StrapiGo to Upload Asset on the top right cornerUpload a single asset or multiple assets.Open your uploaded asset with left clickImportant!!! The name of your file should be the exact same name that you gave in the excel file to your Bank logo (FileName).Add an alternative text to your image so we could have better SEO results!You also have options to delete, download, copy link or crop the image.Finish the upload by clicking to the finish button
Search images in STRAPI
Go to the search bar.Search for the NAME of the image.If you have multiple results, you can expand the count of it by clicking the button below.You can also sort your results.Or filter them.Select all displayed asset & Delete all at once.
FAQ - troubleshoot with example use case & screenshots
What to do when image is missing on XLS upload?
If you notice that an image (bank logo) is missing, it is likely that the required asset is not uploaded to the CMS. Look at how to upload an asset to the Media Library
What to do when we overwrite a previous period selecting the same date?
Be careful, if you don't want to overwrite an already existing file, don't use an upload with the same date!
What to do when XLS format is wrong. When type or date selection wrong?
Uploaded file format should be XLS, XLSM or any Excel compatible extension.
Chart generator is available at: https://finnoconsult.at/de/charts/
link. Chart generator is only available for finnoconsult team members, therefore authentication is required
Currently 4 different charts are supported:
History chart is created to compare a specific institution's past with its current result.Select the type: insurance or bankSelect the two periods (relative & current)Periods are labeled as a help, but it is important to remember that the first period is representing the past (relative), and the second period is the current state of the bank/insurance. Colors are also representing the different states.Only after this will the list of banks or insurances be available to usThe list is sorted by countries and has a search function
Comparison chart is created to compare 2 Institution's result based on a specific period.Select the type: insurance or bankSelect the periodSelect banks/insurances we would like to compareCompared banks/insurances are labeled as a help, but it is important to remember that the first dropdown is representing the past (relative), and the second dropdown is the current state of the bank/insurance. Colors are also representing the different states.In Comparison chart we can choose if we want to compare the current institution with a relative or country institution (Best/Average).
International Chart is created to see and compare the differences between top (best institutions by countries) with one specific institution.Select the type: insurance or bankSelect the periodSelect the top institutions you want to compare. It is ordered by countries: Austria top 10 | Austria top 5...Second selector is the current insitution. If it is present in the top/best list than it will be shown in the left chart and also in the right chart where we display the current bank group. Bank group represent the same banks, for example if we choose ING, we will see all the ING banks in different countries. We should see the indication of the country after the name of the bank.
Multi comparison chart
Multi chart is representing the differences of 4 type of institutions. Top national, Best worldwide, Past and Current state of a choosen institution.First we have to select the type: insurance or bankSelect the two periods (relative & current)Then select the institution. It will grab the past (Last year) and the current (This year) statistical data of the institution.We can see the connection between periods - institution - color picker section in this picture.We can change the default colors of the different institutions.Then select the dimensions we want to display. The limit is 6 dimension, we have to deselect a dimension if we have already 6 selected, and then select a new one.With multi chart we not only able to display multiple institution's data but we are able to download multiple things like the chart or the legend.
How to edit chart data
Almost every data editable in chart generator.From top to bottom, titles, labels, bank names or ratings. For editing, you have to double click on the text you would like to change.Even the bars, we can increase or decrease bar percentages (Fill/Monochrome).or position status indicator. We can do that with the inputs next to the bars. Inputs are only visible when we hover over (take the mouse over) the input option.International chart bars are also editable. There we only have one bar to edit.Multi chart is also editable in the same way as the others.
Save Chart images
Charts can be exported in two ways.
PrintScreen with Command-Shift-4. A cross-hair cursor will appear and you can click and drag to select the area you wish to capture.Export button: Download chart. Available for all charts.Select the folder where you want to save the image.If download is completed you should see it at the bottom of your browser, Double click on the file!Cut out the part of the image we need (Drag with left click on your mouse)With Command-V or choose Edit < Paste on Mac or CTRL + V on Windows we able to paste in our transparent image