Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create LOG file #434

Open
mattiagiupponi opened this issue Dec 16, 2024 · 0 comments
Open

Create LOG file #434

mattiagiupponi opened this issue Dec 16, 2024 · 0 comments
Labels
dbi enhancement New feature or request shape
Milestone

Comments

@mattiagiupponi
Copy link
Collaborator

mattiagiupponi commented Dec 16, 2024

After processing all the information, the client needs a log file with pointed out all the checks that failed.

As a sum-up the column assumes value 0 if is correct, 1 if is not correct.
At the end of each sheet, there are some checks in RED color which will sum-up the situation, if the value is different from OK, we have to report it
Image

The idea is to use the mapping created before #433 to report the wrong value.

In a brief the expected is:

  • The code will check if the value of the column of the check is != 0
  • if is 0,nothing to report
  • if is 1+ means that something went wrong
    In case of 1+ we have to:
  • loop all over the row of the column
  • take the value which is not 0
  • use the mapping created here Convert excel inputs in JSON structures #433 to check which is the correspective value in the sheet
  • save in the log file the sheet, codice ato, denominazione, value, and the description provided in the mapping file

Example log structure

odice ato denominazione sheet tipo check Valore errato col1 Valore errato col2
1 a fiumi Controllo su portata concessa {I} uso potabile {K} 123 (opzionale)
2 s distrib_tronchi Controllo su portata concessa uso potabile 123 (opzionale)
3 c fiumi Controllo su portata concessa uso potabile 123a abc
4 f fiumi Controllo su portata concessa uso potabile abc (opzionale)
@mattiagiupponi mattiagiupponi added the enhancement New feature or request label Dec 16, 2024
@mattiagiupponi mattiagiupponi added this to the 2.0.0 milestone Dec 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
dbi enhancement New feature or request shape
Projects
None yet
Development

No branches or pull requests

1 participant