GSoC/2020/StatusReports/PrasunKumar: Difference between revisions

From KDE Community Wiki
< GSoC‎ | 2020‎ | StatusReports
No edit summary
 
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
=== Project Overview ===
=== Project Overview ===
<big>
 
KtoBLZCheck is a library to check bank account numbers and bank codes
KtoBLZCheck is a library to check bank account numbers and bank codes
(BLZ) of German Banks and other international banks. Currently, KtoBLZCheck
(BLZ) of German Banks and other international banks. Currently, KtoBLZCheck
Line 14: Line 14:


'''Mentors''' : Ralf Habacker, Thomas Baumgart, Ingo Klöcker
'''Mentors''' : Ralf Habacker, Thomas Baumgart, Ingo Klöcker
</big>
=== Milestones Achieved ===




=== Link to Blog ===


=== Blog ===
* GSoC Blog: http://prasunka.github.io/tag/gsoc
=== Repositories ===
* [https://sourceforge.net/p/ktoblzcheck/code/ci/master/tree/ KtoBLZCheck]
* [https://sourceforge.net/u/prasun/ktoblzcheck-gsoc2020/ci/master/tree/ Development fork]
=== Deliverables Progress===
==== Phase I ====
* To create a script that generates the SQLite database from the latest available bankdata file downloaded from the Deutsche Bundesbank's [https://www.bundesbank.de/de/aufgaben/unbarer-zahlungsverkehr/serviceangebot/bankleitzahlen/download-bankleitzahlen-602592 website] by following the specifications available [https://www.bundesbank.de/en/tasks/payment-systems/services/bank-sort-codes/ here]. - '''Done'''
* Modifications in the CMake build system to run this script at build time. - '''Done'''
* Methods to allow the library to query required data from the databases. - '''Done'''
* Replacing the part of code that uses the text data-file with code that reads from the databases while maintaining the similar structure so as to least impact the public API. - '''Done'''
* Adding tests to work with the new database and documentation for the added code. - '''Done'''
* Updating the benchmark tool to work with the new database. - '''Done'''
* Modifying the command-line tool to enable support for the user-supplied database. - '''Done'''
=====Blog Posts =====
* [https://prasunka.github.io/posts/gsoc2020-week-1 GSoC'20 progress : Week 1]
* [https://prasunka.github.io/posts/gsoc2020-week-2-3 GSoC'20 progress : Week 2 & 3]
* [https://prasunka.github.io/posts/gsoc2020-wrapping-phase-1 GSoC'20 progress : Phase I] 
==== Phase II ====


=== Link to commits ===
* To create a script that generates the SQLite database for the Netherlands from the latest available bankdata Excel file downloaded from the Dutch Payments Association [https://www.betaalvereniging.nl/betalingsverkeer/giraal-betalingsverkeer/bic-sepa-transacties/ website]. - '''Done'''


* To create a script that generates the SQLite database for Switzerland from the latest available bankdata file downloaded from the SIX group's [https://www.six-group.com/de/products-services/banking-services/interbank-clearing/online-services/download-bank-master.html website] which operates the infrastructure for the Swiss financial centre. - '''Done'''
 
* Modifications in the CMake build system to generate these databases on build time - '''Done'''
   
* Modifications in the library to enable it to accept databases of these additional countries as there is support for only German databases - '''Done'''
   
* Modifications in the command-line tool to take 'country' as an option to distinguish between different country's validation checks. - '''Done'''
   
* Add tests and documentation for these additions. - '''Done'''


=== Link to Proposal ===
Blog Post : [https://prasunka.github.io/posts/gsoc2020-phase-2 GSoC'20 progress : Phase II]


==== Phase III ====
   
* Add support for validation of bankIds and accountIds for additional countries. - '''Done'''
* Mark the now redundant and unusable methods of the public API as deprecated. - '''Done'''
* Create a public API to enable and extend the functionality of checking for updates and updating of bank-data databases from the project's source site to a client of the library. - '''Setting up the remote source'''
* Create an API to enable the query of these databases to integrate them into other applications. - '''Work in Progress'''
* Add documentation for these APIs. - '''Adding along with code'''
Blog Post : [https://prasunka.github.io/posts/gsoc2020-phase-3 GSoC'20 progress : Phase III]
==== Bug Fixes ====
* [https://sourceforge.net/p/ktoblzcheck/code/merge-requests/9/ Fixed test errors when run using python3]
* [https://sourceforge.net/p/ktoblzcheck/code/merge-requests/10/ Fix for code beautifier not finding any files]
* [https://sourceforge.net/p/ktoblzcheck/code/merge-requests/11/ Fixed warning on running code beautifier]
=== Opened Merge Request ===
* [https://sourceforge.net/p/ktoblzcheck/code/merge-requests/12/ Provision of bank data in SQLite Format]
=== Proposal ===
* GSoC Proposal: https://drive.google.com/file/d/1bbmQB_THdbA0T15atBLEtAJjL05Zdfyu/view?usp=sharing


=== About Me ===
=== About Me ===
<big>
 
*'''Name'''    : Prasun Kumar
*'''Name'''    : Prasun Kumar
*'''Email'''    : [email protected]
*'''Email'''    : [email protected]
*'''IRC Nick''' : prasunkr
*'''IRC Nick''' : prasunkr
*'''Location''' : Guwahati, India (UTC +05:30)<br>
*'''Location''' : Guwahati, India (UTC +05:30)
 
*'''Telegram'''    : [https://t.me/prasunkr prasunkr]
*'''Telegram'''    : [https://t.me/prasunkr prasunkr]
*'''GitHub'''      : [https://github.com/prasunka prasunka]
*'''GitHub'''      : [https://github.com/prasunka prasunka]
*'''Phabricator''' : [https://phabricator.kde.org/p/prasunkr/ prasunkr]
*'''Phabricator''' : [https://phabricator.kde.org/p/prasunkr/ prasunkr]
*'''SourceForge''' : [https://sourceforge.net/u/prasun/profile/ prasun]
*'''SourceForge''' : [https://sourceforge.net/u/prasun/profile/ prasun]
*'''KDE Identity''': [https://identity.kde.org/index.php?r=people/view&uid=prasunkr prasunkr]  
*'''KDE Identity''': [https://identity.kde.org/index.php?r=people/view&uid=prasunkr prasunkr]
</big>

Latest revision as of 09:15, 30 August 2020

Project Overview

KtoBLZCheck is a library to check bank account numbers and bank codes (BLZ) of German Banks and other international banks. Currently, KtoBLZCheck uses multiple bankdata files in text format which are valid at different dates. The data which is regularly retrieved from ​Deutsche Bundesbank is valid for three months. This leads to a lot of duplication of data.
The idea is to integrate the support for query and generation of SQLite databases into KtoBLZCheck to replace the text files used currently. This will avoid duplicate data and enable the support for multiple countries improving the scope of this library.
I also aim to create an API for querying the databases, so as to integrate these databases into other applications.

Mentors : Ralf Habacker, Thomas Baumgart, Ingo Klöcker


Blog


Repositories

Deliverables Progress

Phase I

  • To create a script that generates the SQLite database from the latest available bankdata file downloaded from the Deutsche Bundesbank's website by following the specifications available here. - Done
  • Modifications in the CMake build system to run this script at build time. - Done
  • Methods to allow the library to query required data from the databases. - Done
  • Replacing the part of code that uses the text data-file with code that reads from the databases while maintaining the similar structure so as to least impact the public API. - Done
  • Adding tests to work with the new database and documentation for the added code. - Done
  • Updating the benchmark tool to work with the new database. - Done
  • Modifying the command-line tool to enable support for the user-supplied database. - Done
Blog Posts

Phase II

  • To create a script that generates the SQLite database for the Netherlands from the latest available bankdata Excel file downloaded from the Dutch Payments Association website. - Done
  • To create a script that generates the SQLite database for Switzerland from the latest available bankdata file downloaded from the SIX group's website which operates the infrastructure for the Swiss financial centre. - Done
  • Modifications in the CMake build system to generate these databases on build time - Done
  • Modifications in the library to enable it to accept databases of these additional countries as there is support for only German databases - Done
  • Modifications in the command-line tool to take 'country' as an option to distinguish between different country's validation checks. - Done
  • Add tests and documentation for these additions. - Done

Blog Post : GSoC'20 progress : Phase II


Phase III

  • Add support for validation of bankIds and accountIds for additional countries. - Done
  • Mark the now redundant and unusable methods of the public API as deprecated. - Done
  • Create a public API to enable and extend the functionality of checking for updates and updating of bank-data databases from the project's source site to a client of the library. - Setting up the remote source
  • Create an API to enable the query of these databases to integrate them into other applications. - Work in Progress
  • Add documentation for these APIs. - Adding along with code

Blog Post : GSoC'20 progress : Phase III

Bug Fixes

Opened Merge Request

Proposal

About Me

  • Name  : Prasun Kumar
  • Email  : [email protected]
  • IRC Nick : prasunkr
  • Location : Guwahati, India (UTC +05:30)