edb360 Executive summary document
almogaverok opened this issue · 3 comments
A couple of months ago I was asked by a very important bank in Spain to do an assessment of their databases.
I quickly thought of edb360, which I have used in the past on more than one occasion.
When I presented the result in HTML format, with its hyperlinks, and they saw such a large amount of information, they asked me if it would be possible to make an automated summary of all these hyperlinks in a single document, in which the most frequent incidents would be reflected. important and recommendations for their resolution.
And I got to work on it, and in the end using Python and sqlite I managed to do it.
It is possible that this process already exists, or that someone has already done it, but I am showing it to you in case you are interested.
The steps are very simple.
1.- We generate edb360 with the option to generate XML
2.- Once unzipped on our computer, we copy the python file into the folder.
3.- We execute the python file, at the end of its execution a Word document will have been created with the summary of the incidents and proposed recommendations.
I put some screenshots as an example, If you want more information I will be happy to share it with you.
Best regards from Barcelona
Thank you. With the new inclusion of the new multitenant dictionary views this summary report may need to be revised.
This is a great idea. I see a lot of benefit toward something that at least generates a base executive summary.
I'm working on the same process myself, but I'm stuck at the part where it copies charts from html to word. Can you share how you did it? Thank you