[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-finance-apps
Subject:    Re: GSoC project
From:       Ralf Habacker <ralf.habacker () freenet ! de>
Date:       2020-03-10 21:12:01
Message-ID: 259a350c-c56b-c1cc-ad11-aa3cd14b75c4 () freenet ! de
[Download RAW message or body]

Am 08.03.20 um 16:43 schrieb aryan jangid:
> Hi,
>
Hi Shubham,

thanks for your interest.

> Ralf, I have read about the ktoblzcheck project and successfully build
> the project from source. I have also tested its command line utility
> to see how it actually works. But I have a few questions.
>
> 1. Inside the ktoblzcheck source tree, under bankdata directory, I see
> multiple bankdata and blzcheck files. Why does bankdata.py generates
> multiple output

ktoblzcheck supports multiple bank data files because bank data can have
a limited life time and ktoblzcheck supports reading multiple bank data
files.

When migrating to a sqlite database, this support should also be
migrated by adding from/to date columns that specify the valid date
range. For example, if a bank is included in the current SQLLite
database and not in the file being imported, it should be marked as
unavailable from the current date. If a bank is not contained in the
sqlite database but in the current blz file, it should be marked as
available from today. If there is no from/to entry in the database for a
specific bank, it is available without restrictions.

> 2. This project is not hosted over github, so how do we submit the
> revisions (Pull Requests)?
> Through mail?

Because for historical reasons the project is hosted at sf.net.

It provides merge requests by forking the ktoblzcheck git repo similar
to github and then you can create a merge request from the personal repo.

It might be possible to migrate the project to the KDE infrastructure
(invent.kde.org, websites) as part of the GSOC project, but it would
have to be considered if this makes sense, as this project is intended
for KDE projects like KMyMoney, Skrooge, but also for non-KDE projects
like GnuCash, aqbanking and others.

One example: I can imagine to make the SQLite database available online
in the future. KDE uses the KDE Store for this purpose, but as far as I
know at the moment it only provides a  KDE based API
(https://api.kde.org/frameworks/knewstuff/html/), which excludes other
projects like aqbanking, because this project uses a standard c++
implementation and only optionally includes Qt.

> 3. Can you point to a small bug fix which is required, so I get a hang
> of its source code?
I will take a look at this and answer in this mailing list
>
> BTW regarding me, I am a KDE developer for past 1.5 years and a
> successful previous year GSoC student for KDE community.
> My phabricator profile: https://phabricator.kde.org/p/shubham/
>
> Regards,
> Shubham

Regards

Ralf

>
> On Fri, Feb 28, 2020 at 12:41 AM Ralf Habacker
> <ralf.habacker@freenet.de <mailto:ralf.habacker@freenet.de>> wrote:
>
>     Am 27.02.20 um 19:54 schrieb aryan jangid:
>>     Thanks Ralf.
>>     I understood most of the things.
>>     1. We need to generate SQLite DB from the bankdata text file.
>>     2. Use that DB in the calling API and command line tools.
>>     3. Write the unit-tests and documentation.
>>
>>     But I have a couple of questions. 
>>     1. These changes would be done in kmymonkey or should we
>>     integrate it inside ktoblzcheck itself?
>     in ktoblzcheck to be usable by any finance application
>>     2. I see SQLite DB already being created
>>     here https://cgit.kde.org/kmymoney.git/tree/kmymoney/plugins/ibanbicdata/germany/germany.py?h=4.8.
>     This should be moved to ktoblzcheck and could be used as base.
>>
>>     I would appreciate your reply.
>>
>     BTW:: Please subscribe to
>     https://mail.kde.org/mailman/listinfo/kde-finance-apps for further
>     communications, which should be public according to GSOC rules.
>
>     Regards
>
>     Ralf
>
>>
>>     On Sun, Feb 23, 2020 at 4:55 PM Ralf Habacker
>>     <ralf.habacker@freenet.de <mailto:ralf.habacker@freenet.de>> wrote:
>>
>>         Am 22.02.20 um 08:57 schrieb aryan jangid:
>>         > Hi Ralf,
>>
>>         Hi Aryan,
>>
>>         > I am interested in doing GSoC this summer. The project
>>         KtoBlzCheck
>>         > interests me. Can you please tell me a bit about it and
>>         some resources?
>>
>>         See http://ktoblzcheck.sourceforge.net/ for informations
>>         about the
>>         project.  The actual gsoc project covers:
>>
>>         1. integrate generating sqlite database from
>>         https://cgit.kde.org/kmymoney.git/tree/kmymoney/plugins/ibanbicdata/germany?h=4.8
>>
>>
>>         2. replace the code, which uses the bank data text file with
>>         code that
>>         uses the new sqlite database
>>
>>         3. write/refactor unit tests for the new code
>>
>>         4. It may required to refactor/simplify the cmake build
>>         system while
>>         working on it
>>
>>         5. add additional countries to the generated sqlite database (see
>>         https://cgit.kde.org/kmymoney.git/tree/kmymoney/plugins/ibanbicdata?h=4.8)
>>
>>         6. extend ktoblzcheck code to use  the additional countries
>>
>>         7. write/refactor unit tests for the new code
>>
>>         8. update ktoblzcheck documentation
>>
>>         You should subscribe
>>         https://mail.kde.org/mailman/listinfo/kde-soc for
>>         getting in contact with the project and study
>>         https://google.github.io/gsocguides/student/.
>>
>>         Regards
>>
>>         Ralf
>>

[Attachment #3 (text/html)]

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Am 08.03.20 um 16:43 schrieb aryan
      jangid:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAHvD0ePz0UJP6tZhB7HuSEd9p0EtM2fpiUt0ii5ch1by3Y_6-w@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div>Hi,</div>
        <div><br>
        </div>
      </div>
    </blockquote>
    <p> Hi Shubham,</p>
    <p>thanks for your interest.<br>
    </p>
    <blockquote type="cite"
cite="mid:CAHvD0ePz0UJP6tZhB7HuSEd9p0EtM2fpiUt0ii5ch1by3Y_6-w@mail.gmail.com">
      <div dir="ltr">
        <div>Ralf, I have read about the ktoblzcheck project and
          successfully build the project from source. I have also tested
          its command line utility to see how it actually works. But I
          have a few questions.</div>
        <div><br>
        </div>
        <div>1. Inside the ktoblzcheck source tree, under bankdata
          directory, I see multiple bankdata and blzcheck files. Why
          does bankdata.py generates multiple output<br>
        </div>
      </div>
    </blockquote>
    <p>ktoblzcheck supports multiple bank data files because bank data
      can have a limited life time and ktoblzcheck supports reading
      multiple bank data files.</p>
    <p>When migrating to a sqlite database, this support should also be
      migrated by adding from/to date columns that specify the valid
      date range. For example, if a bank is included in the current
      SQLLite database and not in the file being imported, it should be
      marked as unavailable from the current date. If a bank is not
      contained in the sqlite database but in the current blz file, it
      should be marked as available from today. If there is no from/to
      entry in the database for a specific bank, it is available without
      restrictions.<br>
    </p>
    <blockquote type="cite"
cite="mid:CAHvD0ePz0UJP6tZhB7HuSEd9p0EtM2fpiUt0ii5ch1by3Y_6-w@mail.gmail.com">
      <div dir="ltr">
        <div>2. This project is not hosted over github, so how do we
          submit the revisions (Pull Requests)? <br>
          Through mail?</div>
      </div>
    </blockquote>
    <p> Because for historical reasons the project is hosted at sf.net.
      <br>
    </p>
    <p>It provides merge requests by forking the ktoblzcheck git repo
      similar to github and then you can create a merge request from the
      personal repo.</p>
    <p>It might be possible to migrate the project to the KDE
      infrastructure (invent.kde.org, websites) as part of the GSOC
      project, but it would have to be considered if this makes sense,
      as this project is intended for KDE projects like KMyMoney,
      Skrooge, but also for non-KDE projects like GnuCash, aqbanking and
      others.</p>
    <p>One example: I can imagine to make the SQLite database available
      online in the future. KDE uses the KDE Store for this purpose, but
      as far as I know at the moment it only provides a  KDE based API (<a
        class="moz-txt-link-freetext"
        href="https://api.kde.org/frameworks/knewstuff/html/">https://api.kde.org/frameworks/knewstuff/html/</a>),
  which excludes other projects like aqbanking, because this project
      uses a standard c++ implementation and only optionally includes
      Qt.<br>
    </p>
    <blockquote type="cite"
cite="mid:CAHvD0ePz0UJP6tZhB7HuSEd9p0EtM2fpiUt0ii5ch1by3Y_6-w@mail.gmail.com">
      <div dir="ltr">
        <div>3. Can you point to a small bug fix which is required, so I
          get a hang of its source code?<br>
        </div>
      </div>
    </blockquote>
    I will take a look at this and answer in this mailing list<br>
    <blockquote type="cite"
cite="mid:CAHvD0ePz0UJP6tZhB7HuSEd9p0EtM2fpiUt0ii5ch1by3Y_6-w@mail.gmail.com">
      <div dir="ltr">
        <div> </div>
        <div><br>
        </div>
        <div>BTW regarding me, I am a KDE developer for past 1.5 years
          and a successful previous year GSoC student for KDE community.</div>
        <div>My phabricator profile: <a
            href="https://phabricator.kde.org/p/shubham/"
            moz-do-not-send="true">https://phabricator.kde.org/p/shubham/</a></div>
        <div><br>
        </div>
        <div>Regards,</div>
        <div>Shubham<br>
        </div>
      </div>
    </blockquote>
    <p>Regards</p>
    <p>Ralf <br>
    </p>
    <blockquote type="cite"
cite="mid:CAHvD0ePz0UJP6tZhB7HuSEd9p0EtM2fpiUt0ii5ch1by3Y_6-w@mail.gmail.com">
      <div dir="ltr">
        <div> </div>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">On Fri, Feb 28, 2020 at 12:41
          AM Ralf Habacker &lt;<a href="mailto:ralf.habacker@freenet.de"
            moz-do-not-send="true">ralf.habacker@freenet.de</a>&gt;
          wrote:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0px 0px 0px
          0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
          <div>
            <div>Am 27.02.20 um 19:54 schrieb aryan jangid:<br>
            </div>
            <blockquote type="cite">
              <div dir="ltr">Thanks Ralf.
                <div>I understood most of the things.</div>
                <div>1. We need to generate SQLite DB from the bankdata
                  text file.</div>
                <div>2. Use that DB in the calling API and command line
                  tools.</div>
                <div>3. Write the unit-tests and documentation.</div>
                <div><br>
                </div>
                <div>But I have a couple of questions. </div>
                <div>1. These changes would be done in kmymonkey or
                  should we integrate it inside ktoblzcheck itself?</div>
              </div>
            </blockquote>
            in ktoblzcheck to be usable by any finance application<br>
            <blockquote type="cite">
              <div dir="ltr">
                <div>2. I see SQLite DB already being created here <a
href="https://cgit.kde.org/kmymoney.git/tree/kmymoney/plugins/ibanbicdata/germany/germany.py?h=4.8"
                
                    target="_blank" \
moz-do-not-send="true">https://cgit.kde.org/kmymoney.git/tree/kmymoney/plugins/ibanbicdata/germany/germany.py?h=4.8</a>.</div>
  </div>
            </blockquote>
            This should be moved to ktoblzcheck and could be used as
            base.<br>
            <blockquote type="cite">
              <div dir="ltr">
                <div><br>
                </div>
                <div>I would appreciate your reply.</div>
                <div><br>
                </div>
              </div>
            </blockquote>
            <p>BTW:: Please subscribe to <a
                href="https://mail.kde.org/mailman/listinfo/kde-finance-apps"
                target="_blank" \
moz-do-not-send="true">https://mail.kde.org/mailman/listinfo/kde-finance-apps</a>  \
for further communications, which should be public  according to GSOC rules.</p>
            <p>Regards</p>
            <p>Ralf<br>
            </p>
            <blockquote type="cite"><br>
              <div class="gmail_quote">
                <div dir="ltr" class="gmail_attr">On Sun, Feb 23, 2020
                  at 4:55 PM Ralf Habacker &lt;<a
                    href="mailto:ralf.habacker@freenet.de"
                    target="_blank" \
moz-do-not-send="true">ralf.habacker@freenet.de</a>&gt;  wrote:<br>
                </div>
                <blockquote class="gmail_quote" style="margin:0px 0px
                  0px 0.8ex;border-left:1px solid
                  rgb(204,204,204);padding-left:1ex">Am 22.02.20 um
                  08:57 schrieb aryan jangid:<br>
                  &gt; Hi Ralf,<br>
                  <br>
                  Hi Aryan,<br>
                  <br>
                  &gt; I am interested in doing GSoC this summer. The
                  project KtoBlzCheck<br>
                  &gt; interests me. Can you please tell me a bit about
                  it and some resources?<br>
                  <br>
                  See <a href="http://ktoblzcheck.sourceforge.net/"
                    rel="noreferrer" target="_blank"
                    moz-do-not-send="true">http://ktoblzcheck.sourceforge.net/</a>
                  for informations about the<br>
                  project.  The actual gsoc project covers:<br>
                  <br>
                  1. integrate generating sqlite database from<br>
                  <a
href="https://cgit.kde.org/kmymoney.git/tree/kmymoney/plugins/ibanbicdata/germany?h=4.8"
  rel="noreferrer" target="_blank"
                    moz-do-not-send="true">https://cgit.kde.org/kmymoney.git/tree/kmymoney/plugins/ibanbicdata/germany?h=4.8</a><br>
  <br>
                  <br>
                  2. replace the code, which uses the bank data text
                  file with code that<br>
                  uses the new sqlite database<br>
                  <br>
                  3. write/refactor unit tests for the new code<br>
                  <br>
                  4. It may required to refactor/simplify the cmake
                  build system while<br>
                  working on it<br>
                  <br>
                  5. add additional countries to the generated sqlite
                  database (see<br>
                  <a
href="https://cgit.kde.org/kmymoney.git/tree/kmymoney/plugins/ibanbicdata?h=4.8"
                    rel="noreferrer" target="_blank"
                    moz-do-not-send="true">https://cgit.kde.org/kmymoney.git/tree/kmymoney/plugins/ibanbicdata?h=4.8</a>)<br>
  <br>
                  6. extend ktoblzcheck code to use  the additional
                  countries<br>
                  <br>
                  7. write/refactor unit tests for the new code<br>
                  <br>
                  8. update ktoblzcheck documentation<br>
                  <br>
                  You should subscribe <a
                    href="https://mail.kde.org/mailman/listinfo/kde-soc"
                    rel="noreferrer" target="_blank"
                    moz-do-not-send="true">https://mail.kde.org/mailman/listinfo/kde-soc</a>
  for<br>
                  getting in contact with the project and study<br>
                  <a href="https://google.github.io/gsocguides/student/"
                    rel="noreferrer" target="_blank"
                    moz-do-not-send="true">https://google.github.io/gsocguides/student/</a>.<br>
  <br>
                  Regards<br>
                  <br>
                  Ralf<br>
                  <br>
                </blockquote>
              </div>
            </blockquote>
          </div>
        </blockquote>
      </div>
    </blockquote>
  </body>
</html>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic