Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[jean laroche]

You can put this in a combine.py file. Install python3 (preferably), 
change the names of the files

at the bottom and give it a shot (python combine.py)
Python is a blast as far as languages are concerned, so give it a shot, 
you probably won't regret it!


Good luck,
Jean


# This combines a list of strings (ofx_list) that are read from ofx files
# into a single ofx file suitable to be imported in GnuCash.
def combine_ofx(ofx_list,out_name):
    if len(ofx_list) < 2: return
    # This function finds the occurrences of  and  tags,
    # and outputs the lines numbers in two arrays, along with the lines.
    def findOFXTag(ofx_str):
    ofxIdx = []
    sofxIdx = []
    # Some ofx files have all the tags combined in a single line!
    # Split at < character.
    all_lines = ofx_str.split('<')
    out_lines = []
    for ii,line in enumerate(all_lines):
    # split() removes the '<' character, but we need it. Put it 
back at the start

    # of each line.
    line='<'+line
    if '' in line: ofxIdx.append(ii)
    if '' in line: sofxIdx.append(ii)
    out_lines.append(line)
    # ofxIdx has the indices of lines that have 
    # sofxIdx has the indices of lines that have 
    # out_lines is an array of strings, one per line.
    return ofxIdx,sofxIdx,out_lines
    # Output the first ofx string to the last  (excluded) then 
the next ones from  ->  (excluded)

    print("Outputting first file")
    o,s,lines = findOFXTag(ofx_list[0])
    A = ''.join(lines[0:s[-1]])
    for ofx in ofx_list[1:]:
    print("Outputting next file")
    o, s, lines = findOFXTag(ofx)
    A += ''.join(lines[o[0]+1:s[-1]])
    # Finally add the last  tag
    A += '\n'
    # And write the file.
    print("Writing out file",out_name)
    with open(out_name,'w') as f:
    f.write(A)

def read_ofx_file(file_name):
    # This reads an ofx file and return a long string.
    print("Reading",file_name)
    with open(file_name) as f:
    ofx_as_string = f.read()
    return ofx_as_string

if __name__ == '__main__':
    # You could use this this way:
    file1 = r"E:\temp\Dropbox\OurAccount\OFX\80_Patelco_Checking.ofx"
    file2 = r"E:\temp\Dropbox\OurAccount\OFX\79_Patelco_Checking.ofx"
    file3 = r"E:\temp\Dropbox\OurAccount\OFX\77_Patelco_Visa.ofx"
    all_strings = 
[read_ofx_file(file1),read_ofx_file(file2),read_ofx_file(file3)]

    combine_ofx(all_strings,'combined.ofx')




On 4/15/2020 6:49 PM, Stu Perlman wrote:

Jean,

I would love to see how you did it with Python. That's actually on the 
shortlist of languages I want to learn.


I realized that at least in so far as the Citi produced OFX file is 
concerned, I will always need to delete a fixed number of lines.  If I 
download only one account at a time, I must delete the first 30 
lines.  I have been using sed to do this:


sed -i '1,30d' /tmp/ofx.log


I realized just now (after grabbing some sample downloads of various 
sizes) that if there is more than one account I need to find that 
first  tag and then delete that line and the 31 that follow.  I 
tried using sed with regex but can't get it quite right as it only 
deletes the  line; the next 31 lines are left alone:


sed -i '/<[^>]*\/OFX>/,32d' /tmp/ofx.log


Much appreciation for your help!

Stu


On Wed, Apr 15, 2020 at 6:22 PM Jean Laroche > wrote:


I hacked some python code to do that if you're interested. I'm taking
ofx files, reading them and combining them just the way you
describe it.
It's not beautiful code but it works.
What would be awesome would be if you could select multiple files
in GC,
and then do the import!

On 4/15/20 2:58 PM, Stu Perlman wrote:
> I did some experimenting today and I think I am seeing something
similar.
>
> If I take the  tag that ends the first account’s
transaction data
> and then select all text up to and including the  tag that
starts
>   the next account’s transaction it will work perfectly.
>
> There is a bunch of stuff in between those two tags, including
another
> pair of   tags that wrap some header info that
appears before
> the second account’s transactions.
>
> I’d rather not have to manipulate the file each time so if I can
figure
> out a script that can do what I am doing by hand I should be
set.   If
>   it’s not the same number of lines or characters each time my
script
> will need to be able to detect the correct tags as start and
stop points
> before removing the text.   I plan on working on this a little
more now
> that I know it is possible to import multiple accounts using a
single file.
>
> On Tue, Apr 14, 2020 at 10:11 PM jean laroche mailto:rip...@gmail.com>
> >> wrote:
>
>     Well, combined OFX files *are* supported, at l

Re: [GNC] Should i create "Equity Account" for each currency I had ?

[David Cousens]

Long,

As long as i have been doing accounting, profit or gain  has *never* been
the difference between Assets and Equity.
   
Assets = Liabilities + Equity 

or in the extended form with the temporary accounts broken out separately
from Equity:

Assets =Liabilities + Equity + Income - Expenses.  

You can break that out even further to:

Assets =Liabilities + Equity + Income - Expenses + Gains - Losses

Any transaction which affects an asset, without being purchased via credit,
i.e introducing a Liability ,has the same effect on Equity since such a
transaction credits an Asset account and debits an Equity account and
decreases both the account balances (or vice versa a debit to an asset has a
corresponding split which is a credit to an Equity account and increases the
balances of both accounts). Remember Income and Expense accounts are still
Equity accounts, they are only maintained separately as temporary Equity
accounts for the purposes of calculating profit. Trading accounts are
similarly Equity accounts introduced for the purposes of tracking changes in
capital values. 

It is the value in your trading account which is your gain or loss.

Your assumptions are not correct!

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] OFX Import with Multiple Banks/Accounts in a single file

[Stu Perlman]

Jean,

I would love to see how you did it with Python. That's actually on the
shortlist of languages I want to learn.

I realized that at least in so far as the Citi produced OFX file is
concerned, I will always need to delete a fixed number of lines.  If I
download only one account at a time, I must delete the first 30 lines.  I
have been using sed to do this:

sed -i '1,30d' /tmp/ofx.log


I realized just now (after grabbing some sample downloads of various sizes)
that if there is more than one account I need to find that first  tag
and then delete that line and the 31 that follow.  I tried using sed with
regex but can't get it quite right as it only deletes the  line; the
next 31 lines are left alone:

sed -i '/<[^>]*\/OFX>/,32d' /tmp/ofx.log


Much appreciation for your help!

Stu


On Wed, Apr 15, 2020 at 6:22 PM Jean Laroche  wrote:

> I hacked some python code to do that if you're interested. I'm taking
> ofx files, reading them and combining them just the way you describe it.
> It's not beautiful code but it works.
> What would be awesome would be if you could select multiple files in GC,
> and then do the import!
>
> On 4/15/20 2:58 PM, Stu Perlman wrote:
> > I did some experimenting today and I think I am seeing something similar.
> >
> > If I take the  tag that ends the first account’s transaction data
> > and then select all text up to and including the  tag that starts
> >   the next account’s transaction it will work perfectly.
> >
> > There is a bunch of stuff in between those two tags, including another
> > pair of   tags that wrap some header info that appears before
> > the second account’s transactions.
> >
> > I’d rather not have to manipulate the file each time so if I can figure
> > out a script that can do what I am doing by hand I should be set.   If
> >   it’s not the same number of lines or characters each time my script
> > will need to be able to detect the correct tags as start and stop points
> > before removing the text.   I plan on working on this a little more now
> > that I know it is possible to import multiple accounts using a single
> file.
> >
> > On Tue, Apr 14, 2020 at 10:11 PM jean laroche  > > wrote:
> >
> > Well, combined OFX files *are* supported, at least when the
> > originate from the same bank.
> > I just created a combined OFX file by joining two separate OFX
> > files, and putting the two data in between the BANKMSGSRSV1 tags in
> > a row.
> >
> >  
> > 
> >  
> >  
> > 
> >  
> >
> > In other words, I took everything that was between 
> > and   (including these) from one file, and copied it
> > right after the
> >   from the other file, saved and imported. I get the
> > transactions from both accounts in one shot.
> > That's pretty cool.
> > So if that's not working for you, you should look at your OFX file
> > and try to identify where the problem originates...
> > Jean
> >
> >
> > On 4/14/2020 1:29 PM, David Carlson wrote:
> >> Stu,
> >>
> >> Are you doing online banking through GnuCash or importing OFX
> >> files that you downloaded earlier?
> >>
> >> I am importing OFX files that I imported directly from my bank's
> >> website.
> >>
> >> I think that the same OFX format  is used either way but a
> >> different procedure is used to get the data into GnuCash.
> >>
> >> When I mentioned three tags that appear in OFX files that I
> >> receive I only gave selected examples   not a complete definition.
> >> One would need to get a copy of the OFX standard for completeness.
> >>
> >>
> >>
> >>
> >> On Tue, Apr 14, 2020, 3:14 PM Stu Perlman  >> > wrote:
> >>
> >> Jean, I always assumed it was supported because if you use GNC
> >> to configure
> >> AqB, you only need to set up one User per financial
> >> institution even though
> >> you can set up multiple accounts for that single user.
> >>
> >> - Stu
> >>
> >> On Tue, Apr 14, 2020 at 4:01 PM Jean Laroche  >> > wrote:
> >>
> >> > BTW, that's a feature I was interested in (importing
> >> combined OFX
> >> > files). If there are others interested, I'll look at a way
> >> to support
> >> > that. Another thing that I miss is the ability to
> automatically
> >> > reconcile after an OFX import (not to highjack this thread).
> >> > J.
> >> >
> >> > On 4/14/20 12:53 PM, Ove Grunnér wrote:
> >> > > Ah, I was talking of QIF, not QFX, sorry about that.
> >> > > yes the java code writes QIF.
> >> > > Ove.
> >> > >
> >> > > On Tue, 14 Apr 2020 at 20:45, Stu Perlman
> >> mailto:sgperl...@gmail.com>> wrote:
> >> > >
> >> > >> Ove,
> >> > >>
> >> > >> Thanks for the info that you shar

Re: [GNC] Should i create "Equity Account" for each currency I had ?

[Long]

David Cousens,

Do you know that : if you created each accounts (equity) for each currencies
you are holding. And when the rate changed, you will never know Gain or Loss
after exchange rate changed, You can create a new file to test it! I had
talking about this in previous comment. 
Example :
Assets : 20 vnd
-Usd : 5$ = 10vnd
-Vnd : 10 vnd
Equity : 20 vnd
-opening :
-- usd : 5$ = 10vnd
-- vnd : 10 vnd
And exchange rate changed.
5$ = 20vnd.
=> assets and equity will have the same value, you will never know  your
trading gains. 
Very clear that create each accounts for each currencies are not the good
idea, I don't believe that people don't want to know Gain/Loss their assets. 
You should create a new file and test first before say something. 




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Should i create "Equity Account" for each currency I had ?

[David Cousens]

Long,

Adrien's description applies to the situation where you are starting off
with all your money in the one currency, the home currency of your set of
accounts /book and then you subsequently have trading transactions.  If this
is your situation, then you will not need foreign currency accounts in
equity.

A more general situation is that when you start recording in your books you
might initially have money held in more than one currency. E.g some in VND
and some already in USD.

If this is the case then you will  have to have Equity:Opening
Balances: accounts for each currency you hold money in at that time
where  takes the value of each currency you hold.

In either case the Balance Sheet and Income Statement will reflect this and
convert any foreign currency amounts to then main currency of the book.

Hope this is a bit clearer.

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] OFX Import with Multiple Banks/Accounts in a single file

[David Carlson]

Sorry, I wasn,t clear that I was intentionally comparing apples with
oranges because they both grow on trees

On Wed, Apr 15, 2020 at 5:49 PM Jean Laroche  wrote:

> I think we're talking about OFX here, which is a lot more robust that
> QIF as far as importing. In any event, when you combine the OFX files,
> the OFX import is done sequentially (apparently) in GC as if you opened
> them one after the other, but I may be wrong. The transactions do all
> appear combined in a single match dialog, which is super nice.
> Jean
>
> On 4/15/20 3:42 PM, David Carlson wrote:
> >
> >
> > On Wed, Apr 15, 2020 at 5:22 PM Jean Laroche  > > wrote:
> >
> > I hacked some python code to do that if you're interested. I'm taking
> > ofx files, reading them and combining them just the way you describe
> > it.
> > It's not beautiful code but it works.
> > What would be awesome would be if you could select multiple files in
> > GC,
> > and then do the import!
> >
> > Jean,
> > I don't know if it is still true with the current QIF importer, but IIRC
> > back in the release 2.4.x era the QIF importer could handle multiple
> > files in one pass. The downside was that it couldn't match both sides of
> > a transfer in the same file. Multiple files would be a nice Request for
> > Improvement if it did match transfers.
> >
> > On 4/15/20 2:58 PM, Stu Perlman wrote:
> >  > I did some experimenting today and I think I am seeing something
> > similar.
> >  >
> >  > If I take the  tag that ends the first account’s
> > transaction data
> >  > and then select all text up to and including the  tag that
> > starts
> >  >   the next account’s transaction it will work perfectly.
> >  >
> >  > There is a bunch of stuff in between those two tags, including
> > another
> >  > pair of   tags that wrap some header info that appears
> > before
> >  > the second account’s transactions.
> >  >
> >  > I’d rather not have to manipulate the file each time so if I can
> > figure
> >  > out a script that can do what I am doing by hand I should be set.
> >If
> >  >   it’s not the same number of lines or characters each time my
> > script
> >  > will need to be able to detect the correct tags as start and stop
> > points
> >  > before removing the text.   I plan on working on this a little
> > more now
> >  > that I know it is possible to import multiple accounts using a
> > single file.
> >  >
> >  > On Tue, Apr 14, 2020 at 10:11 PM jean laroche  > 
> >  > >> wrote:
> >  >
> >  > Well, combined OFX files *are* supported, at least when the
> >  > originate from the same bank.
> >  > I just created a combined OFX file by joining two separate OFX
> >  > files, and putting the two data in between the BANKMSGSRSV1
> > tags in
> >  > a row.
> >  >
> >  >  
> >  > 
> >  >  
> >  >  
> >  > 
> >  >  
> >  >
> >  > In other words, I took everything that was between
> > 
> >  > and   (including these) from one file, and
> > copied it
> >  > right after the
> >  >   from the other file, saved and imported. I
> > get the
> >  > transactions from both accounts in one shot.
> >  > That's pretty cool.
> >  > So if that's not working for you, you should look at your OFX
> > file
> >  > and try to identify where the problem originates...
> >  > Jean
> >  >
> >  >
> >  > On 4/14/2020 1:29 PM, David Carlson wrote:
> >  >> Stu,
> >  >>
> >  >> Are you doing online banking through GnuCash or importing OFX
> >  >> files that you downloaded earlier?
> >  >>
> >  >> I am importing OFX files that I imported directly from my
> bank's
> >  >> website.
> >  >>
> >  >> I think that the same OFX format  is used either way but a
> >  >> different procedure is used to get the data into GnuCash.
> >  >>
> >  >> When I mentioned three tags that appear in OFX files that I
> >  >> receive I only gave selected examples   not a complete
> > definition.
> >  >> One would need to get a copy of the OFX standard for
> > completeness.
> >  >>
> >  >>
> >  >>
> >  >>
> >  >> On Tue, Apr 14, 2020, 3:14 PM Stu Perlman
> > mailto:sgperl...@gmail.com>
> >  >> >>
> > wrote:
> >  >>
> >  >> Jean, I always assumed it was supported because if you
> > use GNC
> >  >> to configure
> >  >> AqB, you only need to set up one User per financial
> >  >> institution even though
> >

Re: [GNC] Should i create "Equity Account" for each currency I had ?

[Long]

Hi David Cousens,

I can't understand what you mean and what you are talking about. I think
because you are guiding me more information about Equity accounts.

Generally, i will do the same way like Adrien Monteleone-2 does. only "My
home currency" for Equity.

Thanks for your helped.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

I think we're talking about OFX here, which is a lot more robust that 
QIF as far as importing. In any event, when you combine the OFX files, 
the OFX import is done sequentially (apparently) in GC as if you opened 
them one after the other, but I may be wrong. The transactions do all 
appear combined in a single match dialog, which is super nice.

Jean

On 4/15/20 3:42 PM, David Carlson wrote:



On Wed, Apr 15, 2020 at 5:22 PM Jean Laroche > wrote:


I hacked some python code to do that if you're interested. I'm taking
ofx files, reading them and combining them just the way you describe
it.
It's not beautiful code but it works.
What would be awesome would be if you could select multiple files in
GC,
and then do the import!

Jean,
I don't know if it is still true with the current QIF importer, but IIRC 
back in the release 2.4.x era the QIF importer could handle multiple 
files in one pass. The downside was that it couldn't match both sides of 
a transfer in the same file. Multiple files would be a nice Request for 
Improvement if it did match transfers.


On 4/15/20 2:58 PM, Stu Perlman wrote:
 > I did some experimenting today and I think I am seeing something
similar.
 >
 > If I take the  tag that ends the first account’s
transaction data
 > and then select all text up to and including the  tag that
starts
 >   the next account’s transaction it will work perfectly.
 >
 > There is a bunch of stuff in between those two tags, including
another
 > pair of   tags that wrap some header info that appears
before
 > the second account’s transactions.
 >
 > I’d rather not have to manipulate the file each time so if I can
figure
 > out a script that can do what I am doing by hand I should be set.
   If
 >   it’s not the same number of lines or characters each time my
script
 > will need to be able to detect the correct tags as start and stop
points
 > before removing the text.   I plan on working on this a little
more now
 > that I know it is possible to import multiple accounts using a
single file.
 >
 > On Tue, Apr 14, 2020 at 10:11 PM jean laroche mailto:rip...@gmail.com>
 > >> wrote:
 >
 >     Well, combined OFX files *are* supported, at least when the
 >     originate from the same bank.
 >     I just created a combined OFX file by joining two separate OFX
 >     files, and putting the two data in between the BANKMSGSRSV1
tags in
 >     a row.
 >
 >          
 >     
 >          
 >          
 >     
 >          
 >
 >     In other words, I took everything that was between

 >     and   (including these) from one file, and
copied it
 >     right after the
 >       from the other file, saved and imported. I
get the
 >     transactions from both accounts in one shot.
 >     That's pretty cool.
 >     So if that's not working for you, you should look at your OFX
file
 >     and try to identify where the problem originates...
 >     Jean
 >
 >
 >     On 4/14/2020 1:29 PM, David Carlson wrote:
 >>     Stu,
 >>
 >>     Are you doing online banking through GnuCash or importing OFX
 >>     files that you downloaded earlier?
 >>
 >>     I am importing OFX files that I imported directly from my bank's
 >>     website.
 >>
 >>     I think that the same OFX format  is used either way but a
 >>     different procedure is used to get the data into GnuCash.
 >>
 >>     When I mentioned three tags that appear in OFX files that I
 >>     receive I only gave selected examples   not a complete
definition.
 >>     One would need to get a copy of the OFX standard for
completeness.
 >>
 >>
 >>
 >>
 >>     On Tue, Apr 14, 2020, 3:14 PM Stu Perlman
mailto:sgperl...@gmail.com>
 >>     >>
wrote:
 >>
 >>         Jean, I always assumed it was supported because if you
use GNC
 >>         to configure
 >>         AqB, you only need to set up one User per financial
 >>         institution even though
 >>         you can set up multiple accounts for that single user.
 >>
 >>         - Stu
 >>
 >>         On Tue, Apr 14, 2020 at 4:01 PM Jean Laroche
mailto:rip...@gmail.com>
 >>         >> wrote:
 >>
 >>         > BTW, that's a feature I was interested in (importing
 >>         combined OFX
 >>         > files). If there are others interested, I'll look at a way
 >>         to support
 >>         > that. Another thing that I miss is the ability to
automatically
 >>         > reconcile after an OFX import (not 

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[David Carlson]

On Wed, Apr 15, 2020 at 5:22 PM Jean Laroche  wrote:

> I hacked some python code to do that if you're interested. I'm taking
> ofx files, reading them and combining them just the way you describe it.
> It's not beautiful code but it works.
> What would be awesome would be if you could select multiple files in GC,
> and then do the import!
>
> Jean,
I don't know if it is still true with the current QIF importer, but IIRC
back in the release 2.4.x era the QIF importer could handle multiple files
in one pass. The downside was that it couldn't match both sides of a
transfer in the same file. Multiple files would be a nice Request for
Improvement if it did match transfers.



> On 4/15/20 2:58 PM, Stu Perlman wrote:
> > I did some experimenting today and I think I am seeing something similar.
> >
> > If I take the  tag that ends the first account’s transaction data
> > and then select all text up to and including the  tag that starts
> >   the next account’s transaction it will work perfectly.
> >
> > There is a bunch of stuff in between those two tags, including another
> > pair of   tags that wrap some header info that appears before
> > the second account’s transactions.
> >
> > I’d rather not have to manipulate the file each time so if I can figure
> > out a script that can do what I am doing by hand I should be set.   If
> >   it’s not the same number of lines or characters each time my script
> > will need to be able to detect the correct tags as start and stop points
> > before removing the text.   I plan on working on this a little more now
> > that I know it is possible to import multiple accounts using a single
> file.
> >
> > On Tue, Apr 14, 2020 at 10:11 PM jean laroche  > > wrote:
> >
> > Well, combined OFX files *are* supported, at least when the
> > originate from the same bank.
> > I just created a combined OFX file by joining two separate OFX
> > files, and putting the two data in between the BANKMSGSRSV1 tags in
> > a row.
> >
> >  
> > 
> >  
> >  
> > 
> >  
> >
> > In other words, I took everything that was between 
> > and   (including these) from one file, and copied it
> > right after the
> >   from the other file, saved and imported. I get the
> > transactions from both accounts in one shot.
> > That's pretty cool.
> > So if that's not working for you, you should look at your OFX file
> > and try to identify where the problem originates...
> > Jean
> >
> >
> > On 4/14/2020 1:29 PM, David Carlson wrote:
> >> Stu,
> >>
> >> Are you doing online banking through GnuCash or importing OFX
> >> files that you downloaded earlier?
> >>
> >> I am importing OFX files that I imported directly from my bank's
> >> website.
> >>
> >> I think that the same OFX format  is used either way but a
> >> different procedure is used to get the data into GnuCash.
> >>
> >> When I mentioned three tags that appear in OFX files that I
> >> receive I only gave selected examples   not a complete definition.
> >> One would need to get a copy of the OFX standard for completeness.
> >>
> >>
> >>
> >>
> >> On Tue, Apr 14, 2020, 3:14 PM Stu Perlman  >> > wrote:
> >>
> >> Jean, I always assumed it was supported because if you use GNC
> >> to configure
> >> AqB, you only need to set up one User per financial
> >> institution even though
> >> you can set up multiple accounts for that single user.
> >>
> >> - Stu
> >>
> >> On Tue, Apr 14, 2020 at 4:01 PM Jean Laroche  >> > wrote:
> >>
> >> > BTW, that's a feature I was interested in (importing
> >> combined OFX
> >> > files). If there are others interested, I'll look at a way
> >> to support
> >> > that. Another thing that I miss is the ability to
> automatically
> >> > reconcile after an OFX import (not to highjack this thread).
> >> > J.
> >> >
> >> > On 4/14/20 12:53 PM, Ove Grunnér wrote:
> >> > > Ah, I was talking of QIF, not QFX, sorry about that.
> >> > > yes the java code writes QIF.
> >> > > Ove.
> >> > >
> >> > > On Tue, 14 Apr 2020 at 20:45, Stu Perlman
> >> mailto:sgperl...@gmail.com>> wrote:
> >> > >
> >> > >> Ove,
> >> > >>
> >> > >> Thanks for the info that you shared.  Is your Java
> >> program writing to
> >> > the
> >> > >> QIF format or the OFX format?
> >> > >>
> >> > >> David - my apologies, I never noticed your reply to my
> >> original email
> >> > last
> >> > >> month!  I'm happy to read that it should work.
> >> > >>
> >> > >> I'm still running GNC 3.8 from a mid-march build on my
> >> WIndows system. I
> >> > >> 

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

I hacked some python code to do that if you're interested. I'm taking 
ofx files, reading them and combining them just the way you describe it. 
It's not beautiful code but it works.
What would be awesome would be if you could select multiple files in GC, 
and then do the import!


On 4/15/20 2:58 PM, Stu Perlman wrote:

I did some experimenting today and I think I am seeing something similar.

If I take the  tag that ends the first account’s transaction data 
and then select all text up to and including the  tag that starts 
  the next account’s transaction it will work perfectly.


There is a bunch of stuff in between those two tags, including another 
pair of   tags that wrap some header info that appears before 
the second account’s transactions.


I’d rather not have to manipulate the file each time so if I can figure 
out a script that can do what I am doing by hand I should be set.   If 
  it’s not the same number of lines or characters each time my script 
will need to be able to detect the correct tags as start and stop points 
before removing the text.   I plan on working on this a little more now 
that I know it is possible to import multiple accounts using a single file.


On Tue, Apr 14, 2020 at 10:11 PM jean laroche > wrote:


Well, combined OFX files *are* supported, at least when the
originate from the same bank.
I just created a combined OFX file by joining two separate OFX
files, and putting the two data in between the BANKMSGSRSV1 tags in
a row.

     

     
     

     

In other words, I took everything that was between  
and   (including these) from one file, and copied it

right after the
  from the other file, saved and imported. I get the
transactions from both accounts in one shot.
That's pretty cool.
So if that's not working for you, you should look at your OFX file
and try to identify where the problem originates...
Jean


On 4/14/2020 1:29 PM, David Carlson wrote:

Stu,

Are you doing online banking through GnuCash or importing OFX
files that you downloaded earlier?

I am importing OFX files that I imported directly from my bank's
website.

I think that the same OFX format  is used either way but a
different procedure is used to get the data into GnuCash.

When I mentioned three tags that appear in OFX files that I
receive I only gave selected examples   not a complete definition.
One would need to get a copy of the OFX standard for completeness.




On Tue, Apr 14, 2020, 3:14 PM Stu Perlman mailto:sgperl...@gmail.com>> wrote:

Jean, I always assumed it was supported because if you use GNC
to configure
AqB, you only need to set up one User per financial
institution even though
you can set up multiple accounts for that single user.

- Stu

On Tue, Apr 14, 2020 at 4:01 PM Jean Laroche mailto:rip...@gmail.com>> wrote:

> BTW, that's a feature I was interested in (importing
combined OFX
> files). If there are others interested, I'll look at a way
to support
> that. Another thing that I miss is the ability to automatically
> reconcile after an OFX import (not to highjack this thread).
> J.
>
> On 4/14/20 12:53 PM, Ove Grunnér wrote:
> > Ah, I was talking of QIF, not QFX, sorry about that.
> > yes the java code writes QIF.
> > Ove.
> >
> > On Tue, 14 Apr 2020 at 20:45, Stu Perlman
mailto:sgperl...@gmail.com>> wrote:
> >
> >> Ove,
> >>
> >> Thanks for the info that you shared.  Is your Java
program writing to
> the
> >> QIF format or the OFX format?
> >>
> >> David - my apologies, I never noticed your reply to my
original email
> last
> >> month!  I'm happy to read that it should work.
> >>
> >> I'm still running GNC 3.8 from a mid-march build on my
WIndows system. I
> >> have yet to get GNC, AqBanking 6.x and Citi's OFX API to
all play well
> with
> >> each other.  I am able to get my data from Citi by using
an older AqB
> >> release that I have running under Cygwin to pull the data
from the
> Citi's
> >> web server.  I have found that in order to import the
files that are
> >> download into GNC that I need to make one file for each
account at Citi
> (by
> >> running aqbanking-cli for one account at a time). I then
strip out the
> 1st
> >> dozen or so lines in the response received.  I have
managed to script
> most
> >> of this so it's not nearly as cumbersome as it may
appear, but needing
> to
> >> enter the password once for each account at Citi is
   

Re: [GNC] Should i create "Equity Account" for each currency I had ?

[David Cousens]

Long,
Tthese accounts in Equity are Opening Balances. They are intended to treat
the situation where you start using Gnucash and you already have existing
assets or accounts with existing balances in other currencies when you
create the set of books. They serve no other purpose. Any trading gains or
losses prior to this are not in this set of books. Any trading gains or
losses after this are reflected in the trading accounts and reported in the
Balance Sheet

If a currency 's value increases relative to your book currency, then both
assets and your equity are increasing by the amount of that increase. this
is the way double entry accounting works.

How is it that you don't know what is going on with the trading accounts?
AFAIK The trading gains or losses in other currencies should be converted to
the book currency and the totals displayed in the book currency but it
should be possible to display the balances in the original currency and then
converted to the book currency by increasing the number of levels in the
balance sheet display as it is for Assets and Equity and that would be my
expectation. I do not at this point have a dummy transaction setup to create
a gain or loss in my dummy test book for trading accounts. You can also opt
to display the exchange rates which also appear without labels for the
currencies involved. I must say I find the lack of column headers
identifying the currency a column is in in the expanded displaya bit
disconcerting. but you can always copy the report to a spreadsheet and add
such niceities there.

If you increase the number of levels of account displayed does it not
display the individual currency trading accounts as it does for assets and
equity? Have you explored the report options. Edit->ReportOptions? The
report has to be open before you edit the options and then you use the apply
button to apply them to the open report. You cn aslo save the report with
specific options set for later use.

David





-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] OFX Import with Multiple Banks/Accounts in a single file

[Stu Perlman]

I did some experimenting today and I think I am seeing something similar.

If I take the  tag that ends the first account’s transaction data and
then select all text up to and including the  tag that starts  the
next account’s transaction it will work perfectly.

There is a bunch of stuff in between those two tags, including another pair
of   tags that wrap some header info that appears before the
second account’s transactions.

I’d rather not have to manipulate the file each time so if I can figure out
a script that can do what I am doing by hand I should be set.   If  it’s
not the same number of lines or characters each time my script will need to
be able to detect the correct tags as start and stop points before removing
the text.   I plan on working on this a little more now that I know it is
possible to import multiple accounts using a single file.

On Tue, Apr 14, 2020 at 10:11 PM jean laroche  wrote:

> Well, combined OFX files *are* supported, at least when the originate from
> the same bank.
> I just created a combined OFX file by joining two separate OFX files, and
> putting the two data in between the BANKMSGSRSV1 tags in a row.
>
> 
> 
> 
> 
> 
> 
> In other words, I took everything that was between   and
>   (including these) from one file, and copied it right after
> the
>   from the other file, saved and imported. I get the
> transactions from both accounts in one shot.
> That's pretty cool.
> So if that's not working for you, you should look at your OFX file and try
> to identify where the problem originates...
> Jean
>
>
> On 4/14/2020 1:29 PM, David Carlson wrote:
>
> Stu,
>
> Are you doing online banking through GnuCash or importing OFX files that
> you downloaded earlier?
>
> I am importing OFX files that I imported directly from my bank's website.
>
> I think that the same OFX format  is used either way but a different
> procedure is used to get the data into GnuCash.
>
> When I mentioned three tags that appear in OFX files that I receive I only
> gave selected examples   not a complete definition. One would need to get a
> copy of the OFX standard for completeness.
>
>
>
>
> On Tue, Apr 14, 2020, 3:14 PM Stu Perlman  wrote:
>
>> Jean, I always assumed it was supported because if you use GNC to
>> configure
>> AqB, you only need to set up one User per financial institution even
>> though
>> you can set up multiple accounts for that single user.
>>
>> - Stu
>>
>> On Tue, Apr 14, 2020 at 4:01 PM Jean Laroche  wrote:
>>
>> > BTW, that's a feature I was interested in (importing combined OFX
>> > files). If there are others interested, I'll look at a way to support
>> > that. Another thing that I miss is the ability to automatically
>> > reconcile after an OFX import (not to highjack this thread).
>> > J.
>> >
>> > On 4/14/20 12:53 PM, Ove Grunnér wrote:
>> > > Ah, I was talking of QIF, not QFX, sorry about that.
>> > > yes the java code writes QIF.
>> > > Ove.
>> > >
>> > > On Tue, 14 Apr 2020 at 20:45, Stu Perlman 
>> wrote:
>> > >
>> > >> Ove,
>> > >>
>> > >> Thanks for the info that you shared.  Is your Java program writing to
>> > the
>> > >> QIF format or the OFX format?
>> > >>
>> > >> David - my apologies, I never noticed your reply to my original email
>> > last
>> > >> month!  I'm happy to read that it should work.
>> > >>
>> > >> I'm still running GNC 3.8 from a mid-march build on my WIndows
>> system. I
>> > >> have yet to get GNC, AqBanking 6.x and Citi's OFX API to all play
>> well
>> > with
>> > >> each other.  I am able to get my data from Citi by using an older AqB
>> > >> release that I have running under Cygwin to pull the data from the
>> > Citi's
>> > >> web server.  I have found that in order to import the files that are
>> > >> download into GNC that I need to make one file for each account at
>> Citi
>> > (by
>> > >> running aqbanking-cli for one account at a time). I then strip out
>> the
>> > 1st
>> > >> dozen or so lines in the response received.  I have managed to script
>> > most
>> > >> of this so it's not nearly as cumbersome as it may appear, but
>> needing
>> > to
>> > >> enter the password once for each account at Citi is annoying as is
>> > needing
>> > >> to import multiple files into GNC instead of one consolidated file. I
>> > tried
>> > >> to eliminate the repeating password step with the Expect tool, but I
>> > could
>> > >> not get it to work in the Cygwin environment.
>> > >>
>> > >> Unfortunately, the other financial institutions where I have multiple
>> > >> accounts don't even support OFX (or at least if they do, the info is
>> not
>> > >> available on OFXhome.net)  so I don't know if the issues I have run
>> into
>> > >> are caused by Citi, GNC, or AqB. These issues are not so annoying
>> that I
>> > >> would go back to Quicken! LOLI may mess around with trying to
>> > automate
>> > >> my calls to aqbanking-cli using PowerShell so that I can take Cygwin
>> > out of
>> > >> the mix and/or just try moving over to my Ubu

Re: [GNC] Should i create "Equity Account" for each currency I had ?

[Adrien Monteleone]

Long,

It’s one thing to start a new topic for a truly new question. It is also a good 
idea to change the subject line of a thread if it really does branch off to 
something else.

But simply starting a new thread with the same question, though re-worded makes 
following the discussion difficult for everyone, especially people in the 
future who will find these threads looking to see if their questions have 
already been answered.

As to this particular question, I’ve already answered it in your other thread.

I don’t think you are grasping yet, what GnuCash is doing. Perhaps some more 
use and practice and things will become clearer.

I have trading accounts turned on and I have assets accounts in 16 different 
currencies. (2 of which are metals) I only have USD equity accounts. (my home 
currency)

If you have Equity accounts in currencies other than your book currency, either 
you intentionally or mistakenly created them. I don’t know of a process where 
GnuCash would create them automatically. (certainly at least not without your 
confirmation)

Also, the examples in the documentation are just that, examples. They are not 
the definitive end-all, be-all of how to structure your accounts or 
transactions. It is a guide to get you started using general accounting 
principles.

Your own specific needs and legal requirements may vary, so adjust your 
accounts and transactions accordingly.

Regards,
Adrien

> On Apr 15, 2020 w16d106, at 2:52 PM, Long  wrote:
> 
> This is a new topic moved from older topic : Because my question is not
> clearly. 
> -
> In GnuCash documents - chapter 12 : They created Equity accounts for each
> currency in their guide.(More details)
> 
> I think, it not good if we follow that, because when the exchange rate
> changed, Your both assets and equity accounts will increasing at the same
> time, Which mean you never know what going on (Trading Gain or Loss) with
> your currency in the Report.
> 
> I think we should follow this way : Create Equity Account for only your
> "Default currency", If your starting balance (Opening Balance) had multi
> currencies, just use "Currency Transfer". By this way, you will know (in the
> report) what happen with your currencies (Trading Gain or Loss) in your book
> period.
> 
> And ... Yes, my question is : My idea is right ?
> 
> Thank you for spent your time to helping me.
> --
> Thanks to all, who helped me solved my questions when i'm using GnuCash,
> special Thanks to David Cousens, Adrien Monteleone-2, they are working very
> hard to help GnuCash's Users.


___
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] Should i create "Equity Account" for each currency I had ?

[Long]

Update : Add some pictures for more details, click to the link to view.
1 -  GnuCash documents - chapter 12
  
2 -  Currency Transfer

  



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Should i create "Equity Account" for each currency I had ?

[Long]

This is a new topic moved from older topic : Because my question is not
clearly. 
-
In GnuCash documents - chapter 12 : They created Equity accounts for each
currency in their guide.(More details)

I think, it not good if we follow that, because when the exchange rate
changed, Your both assets and equity accounts will increasing at the same
time, Which mean you never know what going on (Trading Gain or Loss) with
your currency in the Report.

I think we should follow this way : Create Equity Account for only your
"Default currency", If your starting balance (Opening Balance) had multi
currencies, just use "Currency Transfer". By this way, you will know (in the
report) what happen with your currencies (Trading Gain or Loss) in your book
period.

And ... Yes, my question is : My idea is right ?

Thank you for spent your time to helping me.
--
Thanks to all, who helped me solved my questions when i'm using GnuCash,
special Thanks to David Cousens, Adrien Monteleone-2, they are working very
hard to help GnuCash's Users.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Manuals for GnuCash

[Rich Shepard]

On Wed, 15 Apr 2020, Derek Atkins wrote:


But for version 2.4 docs when 3.10 is now current?


The book has not been updated, but MOST of the content is still relevant.
Certainly all the background and process planning is still relevant, even
if the UI has moved on.



Maybe we should reach out and see if they want to refresh the book?


Derek,

That would make good sense if there's still value in a dead-tree version for
software that updates frequently. Perhaps leaving out specifics that would
change more frequently and expanding the background and process planning for
various types of businesses, currencies, and financial transactions would be
relevant longer.

Regards,

Rich
___
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] Delayed Direct Payment of Sales Tax from Vendor Bill?

[Adrien Monteleone]

It would probably be easier to treat this as a separate ‘use tax’ type 
transaction where you recognize the liability independent of the invoice. (some 
jurisdictions impose a tax on items used in business that otherwise wasn’t 
charged sales tax for some reason)

So a separate transaction like:

Dr. Expenses:Taxes:Sales
  Cr. Liabilities:Sales Tax Payable

This lets you pay the vendor bill as-is in full and still track and pay the 
sales tax liability separately. (with the rest of your accumulated sales tax 
liability)

Alternatively, if you don’t want to unpost and re-edit the bill and keep the 
tax on it, then you can ‘pay’ the remainder of the bill with the Sales Tax 
Payable account. (you can pay a liability with a liability)

Thus you can pay the bill partially (but fully as actually invoiced from the 
vendor) and transfer the remaining tax amount from the special AP account to 
Sales Tax Payable.

Note, this would be two separate payments, one from cash/check/card/other for 
the vendor’s portion, and a second ‘payment’ from Sales Tax Payable.

Note, the tax on the bill (as part of the bill) should post to an expense 
account, not a liability account. It could be an accrued expense account that 
you then shift later as needed, however.

Regards,
Adrien

> On Apr 15, 2020 w16d106, at 1:10 PM, Eric H. Bowen via gnucash-user 
>  wrote:
> 
> Okay, folks, I'm lost.
> 
> I normally use cash accounting, not accrual. But I recently purchased a
> software package from a vendor who offered "Net 30" terms and wanted a
> purchase order. I hadn't really used the billing function before and
> since I'm paying before the end of the month I set up the vendor, used
> the "Bill" function and added some verbiage in the notes making it into
> a purchase order, and the vendor accepted it and sold me the product. So
> far so good.
> 
> The fun part came when I tried to post it. The software package is
> taxable in my home state, but the vendor did not invoice sales tax.
> Responsible (cowardly!) citizen that I am, I tried to split it out as a
> line item. I've done that before on other (checking, credit card)
> purchases...enter a split item noting the sales tax amount and
> accumulating it in a "Sales Tax Payable" account until quarterly filing
> time comes and I pay all the taxes due to the state at once.
> 
> In the bill, I marked the software package as taxable. It computed the
> proper amount of tax, but the vendor's invoice was for the purchase
> price only. I enter a payment for the invoice amount, and I'm prompted
> to pay the tax balance. Understandable, but it won't let me split the
> tax out to another payee or account. And, at the same time, it posts the
> tax amount as a credit (negative balance) to my "Sales Tax Payable"
> liability account. If I was paying taxes with the invoice, it would
> throw off my actual tax liability at the end of the quarter.
> 
> How best to make this work properly?


___
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] Manuals for GnuCash

[Derek Atkins]

On Wed, April 15, 2020 2:12 pm, Rich Shepard wrote:
> On Wed, 15 Apr 2020, Derek Atkins wrote:
>
>> It's working for me...  https://www.gnucash.org/
>
> Derek,
>
> It's now working for me, too. Perhaps it was restricted from being viewed
> at
> the time I visited.
>
>> Just a note that the GnuCash team DOES receive a small royalty fee from
>> PACKT publishing for copies of this book that get sold (assuming this is
>> the PACKT publishing book). It's not a lot, mind you, but it is
>> something.
>
> But for version 2.4 docs when 3.10 is now current?

The book has not been updated, but MOST of the content is still relevant.
Certainly all the background and process planning is still relevant, even
if the UI has moved on.

Maybe we should reach out and see if they want to refresh the book?

> Regards,
>
> Rich

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Manuals for GnuCash

[Rich Shepard]

On Wed, 15 Apr 2020, Derek Atkins wrote:


It's working for me...  https://www.gnucash.org/


Derek,

It's now working for me, too. Perhaps it was restricted from being viewed at
the time I visited.


Just a note that the GnuCash team DOES receive a small royalty fee from
PACKT publishing for copies of this book that get sold (assuming this is
the PACKT publishing book). It's not a lot, mind you, but it is something.


But for version 2.4 docs when 3.10 is now current?

Regards,

Rich
___
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] Delayed Direct Payment of Sales Tax from Vendor Bill?

[Eric H. Bowen via gnucash-user]

Okay, folks, I'm lost.

I normally use cash accounting, not accrual. But I recently purchased a
software package from a vendor who offered "Net 30" terms and wanted a
purchase order. I hadn't really used the billing function before and
since I'm paying before the end of the month I set up the vendor, used
the "Bill" function and added some verbiage in the notes making it into
a purchase order, and the vendor accepted it and sold me the product. So
far so good.

The fun part came when I tried to post it. The software package is
taxable in my home state, but the vendor did not invoice sales tax.
Responsible (cowardly!) citizen that I am, I tried to split it out as a
line item. I've done that before on other (checking, credit card)
purchases...enter a split item noting the sales tax amount and
accumulating it in a "Sales Tax Payable" account until quarterly filing
time comes and I pay all the taxes due to the state at once.

In the bill, I marked the software package as taxable. It computed the
proper amount of tax, but the vendor's invoice was for the purchase
price only. I enter a payment for the invoice amount, and I'm prompted
to pay the tax balance. Understandable, but it won't let me split the
tax out to another payee or account. And, at the same time, it posts the
tax amount as a credit (negative balance) to my "Sales Tax Payable"
liability account. If I was paying taxes with the invoice, it would
throw off my actual tax liability at the end of the quarter.

How best to make this work properly?

-- 

Eric H. Bowen
e...@ehbowen.net 


smime.p7s
Description: S/MIME Cryptographic 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
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] Manuals for GnuCash

[Derek Atkins]

Hi,

On Wed, April 15, 2020 1:34 pm, Rich Shepard wrote:
> On Wed, 15 Apr 2020, Edward Bainton wrote:
>
[snip]
>  The gnucash web site seems to be down now as I get to look at only
> a blank page.

It's working for me...  https://www.gnucash.org/

> Don't give Amazon your money for that book.

Just a note that the GnuCash team DOES receive a small royalty fee from
PACKT publishing for copies of this book that get sold (assuming this is
the PACKT publishing book).  It's not a lot, mind you, but it is
something.

> HTH,
>
> Rich

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Manuals for GnuCash

[Rich Shepard]

On Wed, 15 Apr 2020, Edward Bainton wrote:


I'm planning to start using Gnucash in my small business.


Edward,

Good for you!


There appears to be one published beginners manual
,
by Ashok Ramachandran.  It relates to GnuCash 2.4, though.


Er, not correct ...


Before I buy it, can anyone comment on its usefulness, especially as we're
now at 3.10 I gather. And are there other good introductory guides?


There are two, free, docs for current versions: the guide and a help
manual. The gnucash web site seems to be down now as I get to look at only
a blank page. But, I uploaded both docs (for gnucash-3.6; I've not upgraded
to 3.10 docs yet) to a cloud sever. Download them from
. They'll be there for 5 days.

Read those, grab newer versions when available, and ask for help here. Don't
give Amazon your money for that book.

HTH,

Rich
___
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] Manuals for GnuCash

[Edward Bainton]

Hello

I'm planning to start using Gnucash in my small business.

There appears to be one published beginners manual
,
by Ashok Ramachandran.  It relates to GnuCash 2.4, though.

Before I buy it, can anyone comment on its usefulness, especially as we're
now at 3.10 I gather. And are there other good introductory guides?

Thanks all

Edward
___
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] Would like to use, but ....

[Geert Janssens]

Op woensdag 15 april 2020 18:12:29 CEST schreef John Ralls:
> That solves the problem of the link on our page but there's still a
> SourceForge problem: When you visit any of the GnuCash pages on SF there's
> a big green download button. What download it points to is determined by
> the user agent string from your browser, and if that says you're running
> Windows it points to the latest gnucash-xxx-setup.exe. There's no reliable
> way for it to know what version of Windows you have. The same is true of
> MacOS: Someone connecting with a PPC Mac running 10.5 will get pointed to
> the latest Mac bundle, which won't work.
> 
> Regards,
> John Ralls

True. That's a problem we can't fix.

Regards,

Geert
___
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] Would like to use, but ....

[John Ralls]

> On Apr 15, 2020, at 7:27 AM, Geert Janssens  
> wrote:
> 
> Op woensdag 15 april 2020 15:31:35 CEST schreef Fred Bone:
>> On 15 April 2020 at 9:02, Derek Atkins said:
>>> Hi Andrew,
>>> 
>>> First, please remember to CC gnucash-user on your replies so that others
>>> may benefit from the conversation and chime in.  You can do this by using
>>> the Reply-To-List or Reply-All functionality in your mailer.
>>> 
>>> If you could supply us with the URL of the page that points to WinXP,
>>> there is a chance that we might be able to fix it.  BUt of course it
>>> depends if it is on a page that we can control or not.  No way for us to
>>> tell without knowing the specific page ;)
>> 
>> The "XP/Vista" text in the "Download Gnucash 3.10" box at the top of the
>> main gnucash.org page links to
>> https://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.21.setup
>> .exe
> 
> Right, this turns out to be a typo in the link. I have fixed it now; If you 
> reload the gnucash home 
> page it should now properly download the correct package.

That solves the problem of the link on our page but there's still a SourceForge 
problem: When you visit any of the GnuCash pages on SF there's a big green 
download button. What download it points to is determined by the user agent 
string from your browser, and if that says you're running Windows it points to 
the latest gnucash-xxx-setup.exe. There's no reliable way for it to know what 
version of Windows you have. The same is true of MacOS: Someone connecting with 
a PPC Mac running 10.5 will get pointed to the latest Mac bundle, which won't 
work.

Regards,
John Ralls
___
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] Would like to use, but ....

[Geert Janssens]

Op woensdag 15 april 2020 15:31:35 CEST schreef Fred Bone:
> On 15 April 2020 at 9:02, Derek Atkins said:
> > Hi Andrew,
> > 
> > First, please remember to CC gnucash-user on your replies so that others
> > may benefit from the conversation and chime in.  You can do this by using
> > the Reply-To-List or Reply-All functionality in your mailer.
> > 
> > If you could supply us with the URL of the page that points to WinXP,
> > there is a chance that we might be able to fix it.  BUt of course it
> > depends if it is on a page that we can control or not.  No way for us to
> > tell without knowing the specific page ;)
> 
> The "XP/Vista" text in the "Download Gnucash 3.10" box at the top of the
> main gnucash.org page links to
> https://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.21.setup
> .exe

Right, this turns out to be a typo in the link. I have fixed it now; If you 
reload the gnucash home 
page it should now properly download the correct package.

Thanks for the heads-up.

Geert
___
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] Would like to use, but ....

[Robert Heller]

At Wed, 15 Apr 2020 14:31:35 +0100 fred.b...@dial.pipex.com wrote:

> 
> On 15 April 2020 at 9:02, Derek Atkins said:
> 
> > Hi Andrew,
> > 
> > First, please remember to CC gnucash-user on your replies so that others
> > may benefit from the conversation and chime in.  You can do this by using
> > the Reply-To-List or Reply-All functionality in your mailer.
> > 
> > If you could supply us with the URL of the page that points to WinXP,
> > there is a chance that we might be able to fix it.  BUt of course it
> > depends if it is on a page that we can control or not.  No way for us to
> > tell without knowing the specific page ;)
> 
> The "XP/Vista" text in the "Download Gnucash 3.10" box at the top of the 
> main gnucash.org page links to 
> https://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.21.setup
> .exe
> which does not go directlly where you expect, but to
> https://sourceforge.net/projects/gnucash/files/
> from which clicking on the top ("gnucash (stable)") link leads you to the 
> list of available releases. Which, yes, does include 2.6.21 which the 
> main page tells you is the latest one supported on XP/Vista. So the OP's 
> complaint that it "just goes to the version for 7, 8 and 10" is 
> incorrect.
> 
> It might be better to have the link on the main page point to
> https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.
> 21/
> or
> https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.
> 21/gnucash-2.6.21-setup.exe/download
> 
> Incidentally I am still on 2.6.21 (on Win10) and find it entirely 
> satisfactory. I have tried one or two of the 3.x series but see no 
> compelling reason to upgrade (if it ain't broke ...)

And I am using 2.4.15 under CentOS 6 and it works just fine. Newer versions
are not available in the repository and I am not sure if they will even
compile and would likely require chasing down dependencies (and dependencies
of dependencies ...) if I were to try to build from source on my CentOS 6
systems. Not presently worth my time to deal with. "if it ain't broke ...".

Sometime later this year I play to move to an ARM Linux system running a 
newer version of some Debian-ish O/S (probably Ubuntu 16.04 or 18.04).  At 
which point I will probably upgrade...

> 
> 
> ___
> 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.
> 
>   
>   

-- 
Robert Heller -- 978-544-6933 Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services
  
___
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] Would like to use, but ....

[Fred Bone]

On 15 April 2020 at 9:02, Derek Atkins said:

> Hi Andrew,
> 
> First, please remember to CC gnucash-user on your replies so that others
> may benefit from the conversation and chime in.  You can do this by using
> the Reply-To-List or Reply-All functionality in your mailer.
> 
> If you could supply us with the URL of the page that points to WinXP,
> there is a chance that we might be able to fix it.  BUt of course it
> depends if it is on a page that we can control or not.  No way for us to
> tell without knowing the specific page ;)

The "XP/Vista" text in the "Download Gnucash 3.10" box at the top of the 
main gnucash.org page links to 
https://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.21.setup
.exe
which does not go directlly where you expect, but to
https://sourceforge.net/projects/gnucash/files/
from which clicking on the top ("gnucash (stable)") link leads you to the 
list of available releases. Which, yes, does include 2.6.21 which the 
main page tells you is the latest one supported on XP/Vista. So the OP's 
complaint that it "just goes to the version for 7, 8 and 10" is 
incorrect.

It might be better to have the link on the main page point to
https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.
21/
or
https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.
21/gnucash-2.6.21-setup.exe/download

Incidentally I am still on 2.6.21 (on Win10) and find it entirely 
satisfactory. I have tried one or two of the 3.x series but see no 
compelling reason to upgrade (if it ain't broke ...)


___
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] Would like to use, but ....

[Derek Atkins]

Andrew,

PLEASE CC gnucash-user on your replies!

-derek

On Wed, April 15, 2020 9:24 am, Andrew Ruddle wrote:
>
> https://www.gnucash.org/download.phtml   - towards the bottom has the last
> XP version.
>
> Although page  https://www.gnucash.org/offers a link CALLED with
> reference to the old version, when you get there [
> https://sourceforge.net/projects/gnucash/files/sourceforge  ] sourceforge
> have screwed it up so you just get the 7/8/10 one.
>
> APR
>
> -Original Message-
> From: Derek Atkins [mailto:de...@ihtfp.com]
> Sent: 15 April 2020 14:02
> To: Andrew Ruddle
> Cc: gnucash-user@gnucash.org
> Subject: RE: [GNC] Would like to use, but 
>
> Hi Andrew,
>
> First, please remember to CC gnucash-user on your replies so that others
> may
> benefit from the conversation and chime in.  You can do this by using the
> Reply-To-List or Reply-All functionality in your mailer.
>
> If you could supply us with the URL of the page that points to WinXP,
> there
> is a chance that we might be able to fix it.  BUt of course it depends if
> it
> is on a page that we can control or not.  No way for us to tell without
> knowing the specific page ;)
>
> Thanks,
>
> -derek
>
> On Wed, April 15, 2020 9:02 am, Andrew Ruddle wrote:
>>
>> I fully recognise and accept that the XP one will be a bit creaky.
>>
>> After some more poking about, the substance of my problem was / is
>> that the Sourceforge link to download the XP version just goes to the
>> version for 7,
>> 8 & 10 - which explains the funny messages.
>>
>> I have dropped a line to Sourceforge, but I have little doubt nothing
>> will change.
>>
>> APR
>>
>> -Original Message-
>> From: Derek Atkins [mailto:de...@ihtfp.com]
>> Sent: 15 April 2020 13:20
>> To: Andrew Ruddle
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Would like to use, but 
>>
>> Hi,
>>
>> On Tue, April 14, 2020 8:00 am, Andrew Ruddle wrote:
>>>
>>> Greetings
>>>
>>> I have been very highly recommended to GnuCash, but I am having
>>> difficulty getting started.
>>>
>>> I have downloaded and installed [the XP Vista version on
>>> Sourceforge], but when I try to open it all I get is a rather
>>> unhelpful message as
>> follows :
>>
>> What version did you download?  We have not supported Windows XP for a
>> few years already, and all currently supported releases defintely wont
>> work on that old platform.  The minimum-required version is Windows 7.
>>
>>> The procedure entry point GetTickCount64 could not be located in the
>>> dynamic link library KERNEL32.dll
>>>
>>> If anyone can either tell me what extra I need to do, or point me to
>>> a more reliable download, I shall be very grateful.
>>
>> You need to upgrade to Win7, or you need to download a VERY OLD (and
>> probably very buggy, and DEFINITELY unsupported) version of GnuCash.
>> This error message means that the application is trying to call into a
>> function that XP doesn't implement or support, which is not surprising
>> since XP is almost 20 years old.
>>
>> Sorry, but you're into unsupported territory by trying to run on XP.
>> Even
>> Win7 has already expired but we do still support that, barely.
>>
>> Good Luck,
>>
>>> Kind Regards
>>> Dr. Andrew Ruddle
>>> UK
>>
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>>
>> --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com
>>Computer and Internet Security Consultant
>>
>>
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Would like to use, but ....

[D. via gnucash-user]

Andrew, 

The XP version won't be "creaky;" it will be a hazard. Microsoft stopped 
supporting XP years ago, and all sorts of unfixed security threats exist in it. 
Those threats are not just for the machine in question; they give a foothold 
into entire networks. You really should reconsider this. 

Frank's suggestion that you install some thin linux client would be vastly 
preferable to using XP.


 Original Message 
From: Derek Atkins 
Sent: Wed Apr 15 18:32:11 GMT+05:30 2020
To: Andrew Ruddle 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Would like to use, but 

Hi Andrew,

First, please remember to CC gnucash-user on your replies so that others
may benefit from the conversation and chime in.  You can do this by using
the Reply-To-List or Reply-All functionality in your mailer.

If you could supply us with the URL of the page that points to WinXP,
there is a chance that we might be able to fix it.  BUt of course it
depends if it is on a page that we can control or not.  No way for us to
tell without knowing the specific page ;)

Thanks,

-derek

On Wed, April 15, 2020 9:02 am, Andrew Ruddle wrote:
>
> I fully recognise and accept that the XP one will be a bit creaky.
>
> After some more poking about, the substance of my problem was / is that
> the
> Sourceforge link to download the XP version just goes to the version for
> 7,
> 8 & 10 - which explains the funny messages.
>
> I have dropped a line to Sourceforge, but I have little doubt nothing will
> change.
>
> APR
>
> -Original Message-
> From: Derek Atkins [mailto:de...@ihtfp.com]
> Sent: 15 April 2020 13:20
> To: Andrew Ruddle
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Would like to use, but 
>
> Hi,
>
> On Tue, April 14, 2020 8:00 am, Andrew Ruddle wrote:
>>
>> Greetings
>>
>> I have been very highly recommended to GnuCash, but I am having
>> difficulty getting started.
>>
>> I have downloaded and installed [the XP Vista version on Sourceforge],
>> but when I try to open it all I get is a rather unhelpful message as
> follows :
>
> What version did you download?  We have not supported Windows XP for a few
> years already, and all currently supported releases defintely wont work on
> that old platform.  The minimum-required version is Windows 7.
>
>> The procedure entry point GetTickCount64 could not be located in the
>> dynamic link library KERNEL32.dll
>>
>> If anyone can either tell me what extra I need to do, or point me to a
>> more reliable download, I shall be very grateful.
>
> You need to upgrade to Win7, or you need to download a VERY OLD (and
> probably very buggy, and DEFINITELY unsupported) version of GnuCash.  This
> error message means that the application is trying to call into a function
> that XP doesn't implement or support, which is not surprising since XP is
> almost 20 years old.
>
> Sorry, but you're into unsupported territory by trying to run on XP.  Even
> Win7 has already expired but we do still support that, barely.
>
> Good Luck,
>
>> Kind Regards
>> Dr. Andrew Ruddle
>> UK
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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.
___
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] Would like to use, but ....

[Derek Atkins]

Hi Andrew,

First, please remember to CC gnucash-user on your replies so that others
may benefit from the conversation and chime in.  You can do this by using
the Reply-To-List or Reply-All functionality in your mailer.

If you could supply us with the URL of the page that points to WinXP,
there is a chance that we might be able to fix it.  BUt of course it
depends if it is on a page that we can control or not.  No way for us to
tell without knowing the specific page ;)

Thanks,

-derek

On Wed, April 15, 2020 9:02 am, Andrew Ruddle wrote:
>
> I fully recognise and accept that the XP one will be a bit creaky.
>
> After some more poking about, the substance of my problem was / is that
> the
> Sourceforge link to download the XP version just goes to the version for
> 7,
> 8 & 10 - which explains the funny messages.
>
> I have dropped a line to Sourceforge, but I have little doubt nothing will
> change.
>
> APR
>
> -Original Message-
> From: Derek Atkins [mailto:de...@ihtfp.com]
> Sent: 15 April 2020 13:20
> To: Andrew Ruddle
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Would like to use, but 
>
> Hi,
>
> On Tue, April 14, 2020 8:00 am, Andrew Ruddle wrote:
>>
>> Greetings
>>
>> I have been very highly recommended to GnuCash, but I am having
>> difficulty getting started.
>>
>> I have downloaded and installed [the XP Vista version on Sourceforge],
>> but when I try to open it all I get is a rather unhelpful message as
> follows :
>
> What version did you download?  We have not supported Windows XP for a few
> years already, and all currently supported releases defintely wont work on
> that old platform.  The minimum-required version is Windows 7.
>
>> The procedure entry point GetTickCount64 could not be located in the
>> dynamic link library KERNEL32.dll
>>
>> If anyone can either tell me what extra I need to do, or point me to a
>> more reliable download, I shall be very grateful.
>
> You need to upgrade to Win7, or you need to download a VERY OLD (and
> probably very buggy, and DEFINITELY unsupported) version of GnuCash.  This
> error message means that the application is trying to call into a function
> that XP doesn't implement or support, which is not surprising since XP is
> almost 20 years old.
>
> Sorry, but you're into unsupported territory by trying to run on XP.  Even
> Win7 has already expired but we do still support that, barely.
>
> Good Luck,
>
>> Kind Regards
>> Dr. Andrew Ruddle
>> UK
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Would like to use, but ....

[Derek Atkins]

Hi,

On Tue, April 14, 2020 8:00 am, Andrew Ruddle wrote:
>
> Greetings
>
> I have been very highly recommended to GnuCash, but I am having difficulty
> getting started.
>
> I have downloaded and installed [the XP Vista version on Sourceforge], but
> when I try to open it all I get is a rather unhelpful message as follows :

What version did you download?  We have not supported Windows XP for a few
years already, and all currently supported releases defintely wont work on
that old platform.  The minimum-required version is Windows 7.

> The procedure entry point GetTickCount64 could not be located in the
> dynamic
> link library KERNEL32.dll
>
> If anyone can either tell me what extra I need to do, or point me to a
> more
> reliable download, I shall be very grateful.

You need to upgrade to Win7, or you need to download a VERY OLD (and
probably very buggy, and DEFINITELY unsupported) version of GnuCash.  This
error message means that the application is trying to call into a function
that XP doesn't implement or support, which is not surprising since XP is
almost 20 years old.

Sorry, but you're into unsupported territory by trying to run on XP.  Even
Win7 has already expired but we do still support that, barely.

Good Luck,

> Kind Regards
> Dr. Andrew Ruddle
> UK

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Would like to use, but ....

[Frank H. Ellenberger]

please use "reply all" or "reply to list" for your answers.

Am 15.04.20 um 11:27 schrieb Andrew Ruddle:
> 
> Thank you
> 
> a) For my own reasons, it is desirable to run it on a machine that is not
> the main one I use. 

NP

> b) I accept that it is unsupported; however if they offer the XP version as
> a download, then they should make it properly available. Offering it but not
> delivering it - if they asked for any money - would be fraud. 

When we uploaded it 2 years ago, the links were correct. Then we went on
with other tasks.

> c) Thanks to a lot of digging-around, I located the correct download in
> another place after a great deal of wasted time. 

If you would tell us, which URL you at first tried and where you found
it finally, we could fix it, if the places are under our control.

> d) It is a pity they do not offer a proper help facility. 

We offer an IRC, a website, a wiki, the mailing lists, ship docs...
What kind of help facility are you missing?

Frank

> Dr. Andrew Ruddle 
> 
> -Original Message-
> From: Frank H. Ellenberger [mailto:frank.h.ellenber...@gmail.com] 
> Sent: 15 April 2020 10:09
> To: Andrew Ruddle
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Would like to use, but 
> 
> Greetings Andrew,
> 
> Am 14.04.20 um 14:00 schrieb Andrew Ruddle:
>>
>> Greetings
>>
>> I have been very highly recommended to GnuCash, but I am having 
>> difficulty getting started.
>>
>> I have downloaded and installed [the XP Vista version on Sourceforge], 
>> but
> 
> are you still running a computer with XP or Vista? Both are since years
> unsupported. Also Gnucash 2.6.21 is over 2 years old. In this case you
> should consider to install a more modern operating system. If your hardware
> is to weak for more recent Windows version you should consider to install a
> slim Linux distribution.
> 
> If you have a more recent operating sytem like Windows 7 or 10, you should
> install Gnucash 3.10
> 
>> when I try to open it all I get is a rather unhelpful message as follows :
>>
>> The procedure entry point GetTickCount64 could not be located in the 
>> dynamic link library KERNEL32.dll
>>
>> If anyone can either tell me what extra I need to do, or point me to a 
>> more reliable download, I shall be very grateful.
>>
>>
>> Kind Regards
>> Dr. Andrew Ruddle
>> UK
> 
> HTH
> Frank
> 
___
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] Would like to use, but ....

[Frank H. Ellenberger]

Greetings Andrew,

Am 14.04.20 um 14:00 schrieb Andrew Ruddle:
> 
> Greetings
> 
> I have been very highly recommended to GnuCash, but I am having difficulty
> getting started. 
> 
> I have downloaded and installed [the XP Vista version on Sourceforge], but

are you still running a computer with XP or Vista? Both are since years
unsupported. Also Gnucash 2.6.21 is over 2 years old. In this case you
should consider to install a more modern operating system. If your
hardware is to weak for more recent Windows version you should consider
to install a slim Linux distribution.

If you have a more recent operating sytem like Windows 7 or 10, you
should install Gnucash 3.10

> when I try to open it all I get is a rather unhelpful message as follows :
> 
> The procedure entry point GetTickCount64 could not be located in the dynamic
> link library KERNEL32.dll
> 
> If anyone can either tell me what extra I need to do, or point me to a more
> reliable download, I shall be very grateful. 
> 
> 
> Kind Regards
> Dr. Andrew Ruddle
> UK

HTH
Frank
___
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] Would like to use, but ....

[Andrew Ruddle]

Greetings

I have been very highly recommended to GnuCash, but I am having difficulty
getting started. 

I have downloaded and installed [the XP Vista version on Sourceforge], but
when I try to open it all I get is a rather unhelpful message as follows :

The procedure entry point GetTickCount64 could not be located in the dynamic
link library KERNEL32.dll

If anyone can either tell me what extra I need to do, or point me to a more
reliable download, I shall be very grateful. 


Kind Regards
Dr. Andrew Ruddle
UK
___
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.