[GNC] migration from locale currency to EUR

[Saša Janiška]

Hello!

From the beginning of next year our country (Croatia) will replace 
locale currency (HRK) with the EUR. Considering that I already track 
some EUR/USD accounts, I would like to hear some hints from some of the 
EU users who faced the same issue in the past how they handled it?



Sincerely,
Saša

--
In this endeavor there is no loss or diminution,
and a little advancement on this path can protect
one from the most dangerous type of fear.


signature.asc
Description: PGP signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] email seems so crude 30 years after MULTICS forums.

[Saša Janiška]

On Fri, 8 Oct 2021 00:08:02 -0700
Stan Brown  wrote:

> No, Google did its best to destroy it in favor of Google Groups. most
> formerly active newsgroups are moribund, but some are still quite
> active: misc.taxes.moderated, for instance.

Following this mailing list via news.gmane.io and no need for anything
else.  ;)


Sincerely,
Gour

-- 
Many, many births both you and I have passed. I can remember
all of them, but you cannot, O subduer of the enemy!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash very slow to start up and quit

[Saša Janiška]

On Sun, 13 Jun 2021 09:10:42 +
Tim Hume  wrote:

> I just ran a test. My data file is 37 MByte in SQLite format, and 52
> MByte when in XML and uncompressed. However, the compressed XML is
> under 4 MByte.
> 
> It took 1m 17s to open GnuCash with the compressed XML file, and 55s
> with the SQLite file. I'd recommend the SQLite format based on these
> tests.

Thank you for your input!

I am getting pretty much the same result - ~15s and just wonder
whether Sqlite3 could be considered more robust storage format
although I keep XML uncompressed under VCS (Fossil)?


Sincerely,
Gour

-- 
One who restrains the senses of action but whose mind dwells on
sense objects certainly deludes himself and is called a pretender.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash very slow to start up and quit

[Saša Janiška]

On Sun, 13 Jun 2021 08:28:12 +0100
Chris Green  wrote:

> > Backend: SQLite database
> >  
> Ditto

Just wonder how does SQLite back-end compare with XML and whether you
recommend one over the other? (my XML is 20MB uncompressed and under
VCS).


Sincerely,
Gour

-- 
As a lamp in a windless place does not waver, so the transcendentalist,
whose mind is controlled, remains always steady in his meditation on the
transcendent self.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] barcode & invoices

[Saša Janiška]

On Tue, 15 Dec 2020 18:17:36 -0600 (CST)
David Cousens  wrote:

> Good find but the perennial problem arises  Bulgaria, Croatia,
> Czechia, Denmark, Hungary, Poland, Romania, Sweden are not in the
> Eurozone and don't comply/use the EPC system within Europe, at least
> as yet but it looks like a good start. 

Can you shed some light on the above?

All the above countries are part of EU and I'm not sure how does EPC can help
in regard?

> It would appear that the QR code in the EPC guidelines is pretty well
> defined. My generic QR code reader on my phone returns the correct
> information from the examples.  I don't know how universal the use of IBAN
> and BIC codes is outside of Europe...

As I can see here, barcode scanner does contain only few data - total amount to
be paid, purpose of payment and IBAN of the receiver (model of payment etc.).
Iow. I'm not looking for universal solution to be available in GC, but just
some hooks so that we as end-user can select what to include in the barcode to
customize it locally...


With QR code is bit different story as I learnt about its use on invoices in
Croatia.


Sincerely,
Gour

-- 
When your intelligence has passed out of the dense forest
of delusion, you shall become indifferent to all that has
been heard and all that is to be heard.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] barcode & invoices

[Saša Janiška]

On Wed, 16 Dec 2020 08:37:42 +1100
Liz Dodd  wrote:

> Is it the same code each time (easier) or a new code each time (hard)?

I'm more interested in barcode than QR code since the former is used in
iternet-banking apps to make payment easier and it is new code each time since
it contains data releted to the paying invoice (amount, so called referencefor
approval number etc.)

> I worry about the fraud opportunities when the payment details are not
> easily seen. How are people asked to verify correct banking details on
> these QR-coded invoices?

Well, all the invoice here (in Croatia) have all the payment details visible in
normal print and most of them contains so called payment slip form, so ability
to scan barcode is just a convenience over manually entering data which is
prone to errors. Moreover, banking app always does ask, after scan is done, to
approve payment.

Sincerely,
Gour

-- 
Never was there a time when I did not exist,
nor you, nor all these kings; nor in the future
shall any of us cease to be.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] barcode & invoices

[Saša Janiška]

Hello,

I'm using GC to track our personal finances, non-profit account and my small
1-man company.However, for generating company's invoices I use web-based
solution offering ability to have separate quotes/invoices etc.

However, I'm considering to simplify my workflow and take advantage of GC's
invoicing features. Of ocurse, I'd need to customize several things by adding
some custom data to the invoice, but wonder how to e.g. add time when the
invoice is generated or what is the recommended customization method in GC-4.2?

Moreover, since the beginning of 2021 every invoice in Croatia when paid via
cash must have QR code soe that end customer can check its fiscalization data
via tax office. I plan to void dealing with cash, but many/most of generated
invoice do contain barcode which enables one to use his/her smart phone and
scan the barcode via banking application for easy payment, so I am interested
how that feature could be added to GC-created invoices? (I'm running Debian
Sid...)


Sincerely,
Gour









-- 
Thus the wise living entity's pure consciousness becomes covered by
his eternal enemy in the form of lust, which is never satisfied and
which burns like fire.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Addition of Mailing List Subject Prefix

[Saša Janiška]

Dave H  writes:

Hello Dave,

> There is one at Nabble - http://gnucash.1415818.n4.nabble.com/ ?

Thanks for the info, although my comment was just a joke...usually
discussion of people not happy with the mailing lists turns into
suggestion to create web forum as panacea for all the problems. :-D

But, we won't feed this thread any more. ;)


Sincerely,
Gour

-- 
Many, many births both you and I have passed. I can remember
all of them, but you cannot, O subduer of the enemy!

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Addition of Mailing List Subject Prefix

[Saša Janiška]

George Riner  writes:

> I also am subscribed to about 20 email lists and Gnucash was the only
> one that did *not* have bracketed tag in the subject line.

I still haven't seen list of mailing clients which are *not* capable to
perform filtering by List-Id and if it is really such a problem, maybe
the solution is to turn mailing lists into web forum?


Sincerely,
Gour

-- 
As fire is covered by smoke, as a mirror is covered by dust,
or as the embryo is covered by the womb, the living entity is
similarly covered by different degrees of this lust.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Addition of Mailing List Subject Prefix

[Saša Janiška]

William Bixby  writes:

> I'm surprised at the objections, as my experience is that mail lists
> adding the list ID in the subject is the 'norm' and very common.  The
> few, like gnucash was, that don't are the outlier.

I follow about 20 mailing lists and gnucash-users is the only one having
prefix.

For those which do not want or can't use Gmane, they ca filter either
locally or at the server level by using List-ID, so I simply do not see
the reason for this poor-man's filtering...


Sincerely,
Gour

-- 
While contemplating the objects of the senses, a person
develops attachment for them, and from such attachment lust
develops, and from lust anger arises.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Addition of Mailing List Subject Prefix

[Saša Janiška]

Alain Williams  writes:

> All very nice if you want to do that; some do, some don't.

Personally I do not mind too much since I use Gmane, but isn't it
strange that *all* users are paying the 'price' for users that "don't
want to do that" (aka mail filtering) ? ;)


Sincerely,
Gour

-- 
As the ignorant perform their duties with attachment to results,
the learned may similarly act, but without attachment, for the
sake of leading people on the right path.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC Addition of Mailing List Subject Prefix

[Saša Janiška]

Mark Lawrence  writes:

> I see it as a fourth rate solution to a problem that simply does not
> exist.  As I've said previously just point your email/news reader app
> at news.gmane.org and get all of the filtering done for free.

+1 for Gmane, but I also wonder what mail clients do people use that
do not provide simple filtering features?

E.g. gnucash-users list uses Mailman which does provide e.g. List-Id
header for simple filtering...


Sincerely,
Gour


-- 
Abandoning all attachment to the results of his activities,
ever satisfied and independent, he performs no fruitive action,
although engaged in all kinds of undertakings.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] migrating data back to Gnucash

[Saša Janiška]

Hello,

I've Gnucash XML file containing ~8k transactions covering the period of
several years up to the end of 2017 (not exactly, sometime around 20th
of Dec) when I migrated to (h)ledger and keep my journal file up to
date.

Now, after discovering that ytd-budget.scm report can cover my needs for
envelop budgeting (maybe along with Chris' work on the feature) - I also
plan to learn some Scheme/Guile to possibly cover forecasting feature -
I'd like to migrate my data back to GnuCash, but I wonder whether I
should:

a) import the diffence of missing txns from Dec 2017 up to now?

b) import all the txns from hledger-exported CSV(s) - one file per
currency, as I'm told in #gnucash, into a new XML file, although in this
case I'd probably have to import tree of accounts exported from the
current one?

c) some other scenario?


Any other thing I should be concerned about?


Sincerely,
Gour

-- 
As fire is covered by smoke, as a mirror is covered by dust,
or as the embryo is covered by the womb, the living entity is
similarly covered by different degrees of this lust.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] future of custom reports in 3.x

[Saša Janiška]

John Ralls  writes:

> While we would like to replace the reporting system with something
> more flexible and user friendly we’re a very long way from being in a
> position to even start on it.

OK - that's nice to know. ;)

> In the meantime there are four alternatives for custom reports:

> 4. With an XML file use your favorite language's XML bindings with
> XPATH or XQUERY to retrieve the data and format your report.

I'd rather stay away from fiddling with XML stuff.

> 3. Learn Python and use either the python bindings or PieCash (also
> requires the SQL backend) to query the database and write custom
> reports.

I'll take a closer look at this option.

> 2. Learn SQL and use a SQL backend to extract the data you want. The
> results are generally amenable to import into a spreadsheet for
> further processing; you could also install the appropriate ODBC module
> for your SQL engine of choice and connect to it with Libre/OpenOffice,
> Microsoft Access, or some similar tool with a custom report writer or
> your favorite programming language’s SQL interface (e.g. DBAPI for
> Python).

This one seems to be close to 2nd option...

> 1. Learn Scheme and qof-query to make custom reports for use inside
> GnuCash.

This seems to be the most lucrative option enabling one to take
advantage of GC's infrastructure, but just wonder if replacing qof-query
with SQL query query would still allow using it along with Scheme since
"make reports for use inside GnuCash" certainly has its adavantages?


Sincerely,
Gour

-- 
You have a right to perform your prescribed duty, but you
are not entitled to the fruits of action. Never consider
yourself the cause of the results of your activities,
and never be attached to not doing your duty.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC Addition of Mailing List Subject Prefix

[Saša Janiška]

John Ralls  writes:

> Add me to the list of folks who dislike this change.

+1


Sincerely,
Gour

-- 
When your intelligence has passed out of the dense forest
of delusion, you shall become indifferent to all that has
been heard and all that is to be heard.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] future of custom reports in 3.x

[Saša Janiška]

Hello,

while having problems to load certain (ytd-budget.scm) report in 2.6.20
under (Fedora) Linux i nthe attempt to return back to GnuCash from
(h)ledger, I wonder if there is some plan in regard to the future of
custom reports, iow. is it still recommended to learn some Scheme in
order to achieve/tweak  what is missing, do you envision using Python or
something else suitable to enable end-users write custom reports (more)
easily?


Sincerely,
Gour

-- 
Many, many births both you and I have passed. I can remember
all of them, but you cannot, O subduer of the enemy!

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Budgets: showing total-to-date in budget period, and previous month totals only

[Saša Janiška]

Phil Longstaff  writes:

Hello Phil,

> I have attached a report which does this.
>
> I have attached ytd-budget.scm. I have this file in
> c:\Users\phill\.gnucash\reports. I then add this line to
> c:\Users\phill\.gnucash\config.user:
>
> (load "c:\\Users\\phill\\.gnucash\\reports\\ytd-budget.scm")

I took your report from here:

https://lists.gnucash.org/pipermail/gnucash-user/2018-March/075748.html

and put it into ~/.gnucash on my Linux machine.

Moreover, I've the following line:

(load (gnc-build-dotgnucash-path "ytd-budget.scm"))

in my ~/.gnucash/config.user

and the report is not visible nor I get anything in the terminal despite
launching Gnu cash with:

$ gnucash --debug --log gnc.scm=debug

Any hint?

Let me say that I have several years of data in Gnucash (since Nov 2010,
but recently moved to (h)ledger due to Budgeting/ Forecasting features
(https://github.com/simonmichael/hledger/wiki/Budgeting%20and%20forecasting)
- there is '--cumulative' switch for budgets and I believe that your
report does provide same/simialčr feature to do envelope budgeting.

Moreover, entering data, recurring transactions, reconciling etc. are
all quicker and/or more convenient in GC that with #plaintextaccounting
apps, so I'm eager to go back to GC, if possible.


Sincerely,
Gour

-- 
As a strong wind sweeps away a boat on the water,
even one of the roaming senses on which the mind
focuses can carry away a man's intelligence.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: custom reports: guile or eguile

[Saša Janiška]

On Mon, 11 Sep 2017 04:53:26 -0400
Dennis Powless  wrote:

> Where did u find the report?

This one:

https://lists.gnucash.org/pipermail/gnucash-user/2017-May/070519.html

helps me a lot to achieve my goals.


Sincerely,
Gour

-- 
The senses, the mind and the intelligence are the sitting places
of this lust. Through them lust covers the real knowledge of the
living entity and bewilders him.


pgp7JoFqKssBa.pgp
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Start-date in Estimate-budget-value dialog

[Saša Janiška]

On Thu, 03 Aug 2017 09:28:29 -0400
D via gnucash-user  wrote:

> While my understanding of the budget features lacks depth, I do
> believe that the estimating features average the transactions in the
> time frame you choose, so the start date should reflect the time
> period for which you want estimates derived. If your expenses have
> been stable for a long time, you could use the whole data set; if
> they have changed radically for some reason,you might wish to limit
> the averaging period to a smaller set.

Thanks a lot. It is clear now and my experiments confirm your point. ;)


Sincerely,
Gour

-- 
In the material world, one who is unaffected by whatever good
or evil he may obtain, neither praising it nor despising it,
is firmly fixed in perfect knowledge.


pgpVqMthCo4QA.pgp
Description: OpenPGP digital signature
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.