Re: [GNC] Linux Mint 18.2 Sonya and Gnucash 3.2

[Colin Law]

On 28 July 2018 at 23:11, David Cousens  wrote:

> Colin,
>
> It is possible it has been compiled or is missing libdbi which supoports
> the db access via the various db backends. It has to be included in the
> dependencies to get the sqlbackend to run.
>

David,

I see MySQL as an option in Save As so I assumed that meant that it had
been compiled with libdbi enabled.  I am able to save to mysql using a
self-compiled 3.2 version of GnuCash so that suggests to me that the run
time system dependencies are there.  Can you suggest what the problem might
be?  As you say it is a pain that it seems that a trace file is not
generated (I did a full disk search for the trace file and could not find
it) as it is very difficult to know what is going on.

Colin
___
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] Post invoice still wants to be paid

[David Briggs]

Hi,  

 

First, let me say the books are in balance in all respects.

 

Early on, I created an invoice (let's call it Invoice #2) that was posted
and paid.   when I open GnuCash I get a nag to pay it.  When I open
Vendor->Find Bills and search for that invoice I see it as posted and paid.
I also see it in the appropriate ledgers as posted and paid.

 

I have opened the raw XML file and can only find one set of tags for that
invoice (easy enough, there is some unique text on one of the split lines.
)  My thought was to delete it, but if I do that, the books go out of
balance - as expected.

 

The "Pay me" nag persists whether the bill is flagged as active nor not.
Interestingly, nothing bad happens when I flag it as inactive.  I should
think the books would go out of balance, but that does not seem to be the
case, and the invoice and associated payment are still in the appropriate
ledgers.

 

Is there some way to get rid of this what appears to be a duplicate, posted
but not paid, invoice? 

 

David Briggs

dlbri...@cox.net  

918 625 9170

 

___
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 3.2 file open issue

[David Cousens]

Just an update. 

I have been converting from LM18.3 to LM 19 on my desktop and didn't have 
it setup for building GnuCash for the past week which is why I was using the
flatpack version. 
I've just completed building GnuCash 3.2 from sources in LM 19 with all the
options and I now see USB sticks in the sidebar and can open them. Other
Locations is not however showing shares from my NAS but I usually mount
these into directories under my home directory and they are accessible from
there.

It may be the flatpak version that is limiting access. I will build v3.2 on
LM18.3 on my laptop tomorrow to see if it is OS or flathub.

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] Post invoice still wants to be paid

[Rich Shepard]

On Sat, 28 Jul 2018, David Briggs wrote:


Early on, I created an invoice (let's call it Invoice #2) that was posted
and paid. when I open GnuCash I get a nag to pay it. When I open
Vendor->Find Bills and search for that invoice I see it as posted and
paid. I also see it in the appropriate ledgers as posted and paid.


David,

  How interesting! I have an analagous situation when I open my business
books: a window displaying a paid A/R invoice pops up (see attached) telling
me it's still wating to be paid. It was paid a long time ago.

  After trying to get gnucash to accept that client invoice was paid, I
shrugged and clicked the 'Close' button. The message box goes away and I do
what needs to be done.

  There is no similar issue with my personal books, only the business books.

  This with gnucash-3.2 (on Slackware-14.2 if that makes any difference).

  While our situations are benign it would be nice to have them cleared.

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] Linux Mint 18.2 Sonya and Gnucash 3.2

[David Cousens]

Colin,I now suspect it is possibly totally flatpak related. I have just
got my build environment setup after swapping over to Linux Mint 19
Tara  and a fresh build of V3.2  with all options enabled is giving me
all the database save options. I don't have mysql back up yet but it
saved the file as an sqlite3 file with no problems. My guess and it is
only that is there are modules associated with the flatpak system which
perhaps interface with the OS that may be missing. I had problems
seeing USB sticks and network shares form the flatpak, but these have
disappeared with a native build on LM19. I'd stick with your own build
and forget the flatpak at least for the moment. I can't see any
optional modules in the LM19 Software manager but I found a few
references on other forums to having to load additional support for
some interactions with the OS. I hear snap is a better system but have
no experience with it. there is a version on the snapcraft site. Might
have a look once my OS is sorted out and functioning
David
On Sun, 2018-07-29 at 09:04 +0100, Colin Law wrote:
> On 28 July 2018 at 23:11, David Cousens 
> wrote:
> > Colin,
> > 
> > It is possible it has been compiled or is missing libdbi which
> > supoports the db access via the various db backends.  It has to be
> > included in the dependencies to get the sqlbackend to run.
> 
> David,
> 
> I see MySQL as an option in Save As so I assumed that meant that it
> had been compiled with libdbi enabled.  I am able to save to mysql
> using a self-compiled 3.2 version of GnuCash so that suggests to me
> that the run time system dependencies are there.  Can you suggest
> what the problem might be?  As you say it is a pain that it seems
> that a trace file is not generated (I did a full disk search for the
> trace file and could not find it) as it is very difficult to know
> what is going on.
> 
> Colin
> 
___
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] Linux Mint 18.2 Sonya and Gnucash 3.2

[Les]

I don't think there is a 3.2 version of GC in Snap. I think the latest 
is 2.6.21. I am using it on my LM 18.2 production system.


Les


On 07/29/2018 07:53 AM, David Cousens wrote:

Colin,I now suspect it is possibly totally flatpak related. I have just
got my build environment setup after swapping over to Linux Mint 19
Tara  and a fresh build of V3.2  with all options enabled is giving me
all the database save options. I don't have mysql back up yet but it
saved the file as an sqlite3 file with no problems. My guess and it is
only that is there are modules associated with the flatpak system which
perhaps interface with the OS that may be missing. I had problems
seeing USB sticks and network shares form the flatpak, but these have
disappeared with a native build on LM19. I'd stick with your own build
and forget the flatpak at least for the moment. I can't see any
optional modules in the LM19 Software manager but I found a few
references on other forums to having to load additional support for
some interactions with the OS. I hear snap is a better system but have
no experience with it. there is a version on the snapcraft site. Might
have a look once my OS is sorted out and functioning
David
On Sun, 2018-07-29 at 09:04 +0100, Colin Law wrote:

On 28 July 2018 at 23:11, David Cousens 
wrote:

Colin,

It is possible it has been compiled or is missing libdbi which
supoports the db access via the various db backends.  It has to be
included in the dependencies to get the sqlbackend to run.

David,

I see MySQL as an option in Save As so I assumed that meant that it
had been compiled with libdbi enabled.  I am able to save to mysql
using a self-compiled 3.2 version of GnuCash so that suggests to me
that the run time system dependencies are there.  Can you suggest
what the problem might be?  As you say it is a pain that it seems
that a trace file is not generated (I did a full disk search for the
trace file and could not find it) as it is very difficult to know
what is going on.

Colin


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

[GNC] Stuck between versions

[1marc1]

Dear all,

I am a long time user of gnucash and a first time poster on this forum. I
find myself stuck between versions. On my desktop (Ubuntu 16.04) I am
running gnucash 2.6.17. On my phone I am running the mobile version. I keep
the mobile version up to date with whatever the latest version is.

I have been recording transactions on my mobile phone since about December
2017 and thought it would be a good idea to now import these into my
desktop. Prior to December 2017, I had run some tests and everything worked
fine: I could export a QIF file on the phone and import that into an
existing gnucash file on my desktop. The transactions that I created via the
phone app would simply be added to the transactions that existed on the
desktop version.

When I now come to import the QIF file, I get a message saying "An error
occurred while loading the QIF file", followed by the message "A bug was
detected while parsing the QIF file". I have tried to export my transactions
using CSV format, but the import does not work either. After Googling around
a bit, I learned that the import function (for CSV) does not work (properly)
in version 2.6 and below.

I found that the QIF files I had created during my tests prior to December
2017 are in plain text format, while the QIF file I created today seems to
be binary. As such, I thought to upgrade my desktop version to the latest
stable (3.2).

It seems to be quite a process to get that upgraded, but I followed the
instructions outlined here https://wiki.gnucash.org/wiki/BuildUbuntu16.04 to
the letter.

Unfortunately, when I reach the end, I run the command:

and that crashes with an error. See: https://pastebin.com/LPe9i6Em
The content of the cmake output file is here: https://pastebin.com/1s4jEUzG

Where do I go from here? How can I get my transactions for the last 8 months
added to the existing transactions on my gnucash desktop version?

Marc.



--
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] Loss of all data

[David Finbow]

Can any one help me ! I¹ve managed to lose/unable to open all my data !
I updated my Mac OS from 10.6 to ³El Capitan². When I came to open Gnucash I
got the message ³Could not obtain the lock for file:///...² on all my
files.
The update had corrupted the Gnucash files. There were no .LNK or .LCK files
to be found. I could get to the files as read only but was not able to save
any new data. I saved all the Gnucash files to a USB memory stick and then
deleted all the Gnucash files from the desktop. I then downloaded the most
recent Gnucash and set up some new files hoping to drop the files from
memory stick into the new Gnucash files. All that came up were the new empty
files. Alas the old data seems to have gone although there are log files on
the memory stick. 
David
___
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] Stuck between versions

[John Ralls]

> On Jul 29, 2018, at 7:02 AM, 1marc1 <1ma...@gmail.com> wrote:
> 
> Dear all,
> 
> I am a long time user of gnucash and a first time poster on this forum. I
> find myself stuck between versions. On my desktop (Ubuntu 16.04) I am
> running gnucash 2.6.17. On my phone I am running the mobile version. I keep
> the mobile version up to date with whatever the latest version is.
> 
> I have been recording transactions on my mobile phone since about December
> 2017 and thought it would be a good idea to now import these into my
> desktop. Prior to December 2017, I had run some tests and everything worked
> fine: I could export a QIF file on the phone and import that into an
> existing gnucash file on my desktop. The transactions that I created via the
> phone app would simply be added to the transactions that existed on the
> desktop version.
> 
> When I now come to import the QIF file, I get a message saying "An error
> occurred while loading the QIF file", followed by the message "A bug was
> detected while parsing the QIF file". I have tried to export my transactions
> using CSV format, but the import does not work either. After Googling around
> a bit, I learned that the import function (for CSV) does not work (properly)
> in version 2.6 and below.
> 
> I found that the QIF files I had created during my tests prior to December
> 2017 are in plain text format, while the QIF file I created today seems to
> be binary. As such, I thought to upgrade my desktop version to the latest
> stable (3.2).
> 
> It seems to be quite a process to get that upgraded, but I followed the
> instructions outlined here https://wiki.gnucash.org/wiki/BuildUbuntu16.04 to
> the letter.
> 
> Unfortunately, when I reach the end, I run the command:
> 
> and that crashes with an error. See: https://pastebin.com/LPe9i6Em
> The content of the cmake output file is here: https://pastebin.com/1s4jEUzG
> 
> Where do I go from here? How can I get my transactions for the last 8 months
> added to the existing transactions on my gnucash desktop version?

QIFs are plain-text, and the importer hasn’t changed much (a few bugs fixed) 
between 2.6 and 3.2, so the problem would seem to be with the Android export. 
The first thing to check is if the files are compressed and if so, uncompress 
them. You can use the file command in Ubuntu for the first part:
  file foo.qif
If it says that it’s a gzip-compressed file, then 
  mv foo.qif foo.qif.gz
  gunzip foo.qif.gz

Other compression schemes will be similar, rtfm for whatever scheme it is.
If it’s not a compressed file you’ll have to go ask at the Gnucash-for-Android 
forum for instructions.

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] GNUcash 3.2 file open issue

[Colin Law]

On 29 July 2018 at 13:34, David Cousens  wrote:

> Just an update.
>
> I have been converting from LM18.3 to LM 19 on my desktop and didn't have
> it setup for building GnuCash for the past week which is why I was using
> the
> flatpack version.
> I've just completed building GnuCash 3.2 from sources in LM 19 with all the
> options and I now see USB sticks in the sidebar and can open them. Other
> Locations is not however showing shares from my NAS but I usually mount
> these into directories under my home directory and they are accessible from
> there.
>
> It may be the flatpak version that is limiting access. I will build v3.2 on
> LM18.3 on my laptop tomorrow to see if it is OS or flathub.
>

That will likely be a flatpak issue.  Flatpak packages are by default
sandboxed and it is up to the packager to specify what it is allowed to
access.  Likely some permission is missing from there.

Come to think of it that may well be the reason for the missing trace file,
if the app cannot access the specified folder.

Colin
___
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] Linux Mint 18.2 Sonya and Gnucash 3.2

[Colin Law]

On 29 July 2018 at 14:53, Les  wrote:

> I don't think there is a 3.2 version of GC in Snap. I think the latest is
> 2.6.21. I am using it on my LM 18.2 production system.
>

I think I mentioned (much) earlier that I attempted to contact the
snapper(?) to ask if he was going to update it, but there was no response.

Colin



>
> Les
>
>
> On 07/29/2018 07:53 AM, David Cousens wrote:
>
>> Colin,I now suspect it is possibly totally flatpak related. I have just
>>
>> got my build environment setup after swapping over to Linux Mint 19
>> Tara  and a fresh build of V3.2  with all options enabled is giving me
>> all the database save options. I don't have mysql back up yet but it
>> saved the file as an sqlite3 file with no problems. My guess and it is
>> only that is there are modules associated with the flatpak system which
>> perhaps interface with the OS that may be missing. I had problems
>> seeing USB sticks and network shares form the flatpak, but these have
>> disappeared with a native build on LM19. I'd stick with your own build
>> and forget the flatpak at least for the moment. I can't see any
>> optional modules in the LM19 Software manager but I found a few
>> references on other forums to having to load additional support for
>> some interactions with the OS. I hear snap is a better system but have
>> no experience with it. there is a version on the snapcraft site. Might
>> have a look once my OS is sorted out and functioning
>> David
>> On Sun, 2018-07-29 at 09:04 +0100, Colin Law wrote:
>>
>>> On 28 July 2018 at 23:11, David Cousens 
>>> wrote:
>>>
 Colin,

 It is possible it has been compiled or is missing libdbi which
 supoports the db access via the various db backends.  It has to be
 included in the dependencies to get the sqlbackend to run.

>>> David,
>>>
>>> I see MySQL as an option in Save As so I assumed that meant that it
>>> had been compiled with libdbi enabled.  I am able to save to mysql
>>> using a self-compiled 3.2 version of GnuCash so that suggests to me
>>> that the run time system dependencies are there.  Can you suggest
>>> what the problem might be?  As you say it is a pain that it seems
>>> that a trace file is not generated (I did a full disk search for the
>>> trace file and could not find it) as it is very difficult to know
>>> what is going on.
>>>
>>> Colin
>>>
>>> ___
>> 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.
>
___
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] What does this mean?

[Daniel G Rodriguez]

Hi guys,

I'm new to GnuCash. In the New Book Options dialog box, the tooltip for
"Use Split Action Field for Number" says:

"Check to have split action field used in registers for 'Num' field in
place of transaction number; transaction number shown as 'T-Num' on second
line of register. Has corresponding effect on business features, reporting
and imports/exports."

Does the first part of the phrase mean:
1. 'Num' field normally uses the transaction number?
2. 'Num' field can be used as the transaction number?
3. 'Num' field is usually used to enter a transaction number?

I think it means #2, but want to be sure.

Thanks

--Daniel
___
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] Loss of all data

[John Ralls]

> On Jul 29, 2018, at 7:06 AM, David Finbow  wrote:
> 
> Can any one help me ! I¹ve managed to lose/unable to open all my data !
> I updated my Mac OS from 10.6 to ³El Capitan². When I came to open Gnucash I
> got the message ³Could not obtain the lock for file:///...² on all my
> files.
> The update had corrupted the Gnucash files. There were no .LNK or .LCK files
> to be found. I could get to the files as read only but was not able to save
> any new data. I saved all the Gnucash files to a USB memory stick and then
> deleted all the Gnucash files from the desktop. I then downloaded the most
> recent Gnucash and set up some new files hoping to drop the files from
> memory stick into the new Gnucash files. All that came up were the new empty
> files. Alas the old data seems to have gone although there are log files on
> the memory stick. 


What files did you copy to your USB stick? Do you have a recent backup from 
before the upgrade of your system disk?

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] What does this mean?

[Alex Aycinena]

Daniel,



> From: Daniel G Rodriguez 
> To: gnucash-user@gnucash.org
> Cc:
> Bcc:
> Date: Sun, 29 Jul 2018 23:42:48 +0800
> Subject: [GNC] What does this mean?
> Hi guys,
>
> I'm new to GnuCash. In the New Book Options dialog box, the tooltip for
> "Use Split Action Field for Number" says:
>
> "Check to have split action field used in registers for 'Num' field in
> place of transaction number; transaction number shown as 'T-Num' on second
> line of register. Has corresponding effect on business features, reporting
> and imports/exports."
>
> Does the first part of the phrase mean:
> 1. 'Num' field normally uses the transaction number?
> 2. 'Num' field can be used as the transaction number?
> 3. 'Num' field is usually used to enter a transaction number?
>
> I think it means #2, but want to be sure.
>
> Thanks
>
> --Daniel
>
>
Each transaction has data related to the whole transaction (like 'date' and
'transaction number') and data related to each split (like 'memo' and
'action') and there must be two or more splits that are the debits and
credits of the transaction.

The default is for 'transaction number' to be shown in the register as
'Num'. That means that if you look at a transaction in each of the two or
more registers that correspond to its splits, the 'Num' field in each
register will be the same. If you change it in one register, it will change
in the other(s).

If you check the option, 'action' is shown in the register as 'Num'. That
means that if you look at a transaction in each of the two or more
registers that correspond to its splits, the 'Num' field in each register
will be different. Only the 'Num' field of the register the transaction was
entered in will contain the entered number (or whatever was entered, since
it is not actually a number field). If you change the 'Num' field in one
register, it won't change in the others.

So the answer is 1.

If you come from Quicken, and are used to having the number field shown in
the register vary for each register, then selecting the option will make it
behave the way you are used to. The right choice for you depends on your
work practices around Gnucash and how you plan to use the 'Num' field.

Alex
___
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] Linux Mint 18.2 Sonya and Gnucash 3.2

[David Cousens]

Colin,I now suspect it is possibly totally flatpak related. I have just
got my build environment setup after swapping over to Linux Mint 19
Tara  and a fresh build of V3.2  with all options enabled is giving me
all the database save options. I don't have mysql back up yet but it
saved the file as an sqlite3 file with no problems. My guess and it is
only that is there are modules associated with the flatpak system which
perhaps interface with the OS that may be missing. I had problems
seeing USB sticks and network shares form the flatpak, but these have
disappeared with a native build on LM19. I'd stick with your own build
and forget the flatpak at least for the moment. I can't see any
optional modules in the LM19 Software manager but I found a few
references on other forums to having to load additional support for
some interactions with the OS. I hear snap is a better system but have
no experience with it. there is a version on the snapcraft site. Might
have a look once my OS is sorted out and functioning
David
On Sun, 2018-07-29 at 09:04 +0100, Colin Law wrote:
> On 28 July 2018 at 23:11, David Cousens 
> wrote:
> > Colin,
> > 
> > It is possible it has been compiled or is missing libdbi which
> > supoports the db access via the various db backends.  It has to be
> > included in the dependencies to get the sqlbackend to run.
> 
> David,
> 
> I see MySQL as an option in Save As so I assumed that meant that it
> had been compiled with libdbi enabled.  I am able to save to mysql
> using a self-compiled 3.2 version of GnuCash so that suggests to me
> that the run time system dependencies are there.  Can you suggest
> what the problem might be?  As you say it is a pain that it seems
> that a trace file is not generated (I did a full disk search for the
> trace file and could not find it) as it is very difficult to know
> what is going on.
> 
> Colin
> 
___
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] Stuck between versions

[David Cousens]

Marc,

QIF is an ASCCI formatted text file. It's format is described in a
Wikipedia article, https://en.wikipedia.org/wiki/Quicken_Interchange_Fo
rmat. It can be edited in a text editor (gedit,xed etc). I would first
check the format of your import file out for missing sysntax like
missing header lines or the lines with carets denoting the end of each
record or missing detail codes. It may be worth trying to rexport the
file from your phone again in case it was corrupted in transferring it.

Have you loaded build-essential first with sudo apt build-essential
when you attempted to build v 3.2? That should put the Gnu compilers on
your system. Can you post the command entries into the shell you used
for cmake. The errors  indicate you may be missing libofx in the
dependencies. Try sudo apt install libofx-dev.

cmake will run until it finds a missing package and then stop with an
error. The instructions list some of the dependencies as optional but
the default settings for cmake generally compile with all options but
the Python extensions by default in the more recent versions. I
realized that last night when compiling v3.2 myself and intend to
upgrade the page to reflect this. Try installing all of the optional
dependencies as well and then running cmake again. The Gnu compilers
may give you more interpretable output. 

I updated the dependencies list last night as I was building GnuCash
for the first time on a clean Linux Mint 19 system and found libsecret-
1-0-dev was missing and I have never come across it as a dependency
over the last 3-4 years. That usually means it is installed either by
default on most systems or is loaded by another commonly used package.

Generally the procedure with cmake is to run it, if it stops identify
the missing package that caused it to stop, install it and rerun it and
repeat that procedure until until it runs through without stopping and
writes the build files into the build directory. Just come back to the
forum if you have further problems.

Good luck

David

On Sun, 2018-07-29 at 09:02 -0500, 1marc1 wrote:
> Dear all,
> 
> I am a long time user of gnucash and a first time poster on this
> forum. I
> find myself stuck between versions. On my desktop (Ubuntu 16.04) I am
> running gnucash 2.6.17. On my phone I am running the mobile version.
> I keep
> the mobile version up to date with whatever the latest version is.
> 
> I have been recording transactions on my mobile phone since about
> December
> 2017 and thought it would be a good idea to now import these into my
> desktop. Prior to December 2017, I had run some tests and everything
> worked
> fine: I could export a QIF file on the phone and import that into an
> existing gnucash file on my desktop. The transactions that I created
> via the
> phone app would simply be added to the transactions that existed on
> the
> desktop version.
> 
> When I now come to import the QIF file, I get a message saying "An
> error
> occurred while loading the QIF file", followed by the message "A bug
> was
> detected while parsing the QIF file". I have tried to export my
> transactions
> using CSV format, but the import does not work either. After Googling
> around
> a bit, I learned that the import function (for CSV) does not work
> (properly)
> in version 2.6 and below.
> 
> I found that the QIF files I had created during my tests prior to
> December
> 2017 are in plain text format, while the QIF file I created today
> seems to
> be binary. As such, I thought to upgrade my desktop version to the
> latest
> stable (3.2).
> 
> It seems to be quite a process to get that upgraded, but I followed
> the
> instructions outlined here https://wiki.gnucash.org/wiki/BuildUbuntu1
> 6.04 to
> the letter.
> 
> Unfortunately, when I reach the end, I run the command:
> 
> and that crashes with an error. See: https://pastebin.com/LPe9i6Em
> The content of the cmake output file is here: https://pastebin.com/1s
> 4jEUzG
> 
> Where do I go from here? How can I get my transactions for the last 8
> months
> added to the existing transactions on my gnucash desktop version?
> 
> Marc.
> 
> 
> 
> --
> 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.
___
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 

Re: [GNC] Stuck between versions

[1marc1]

John, David,

Thank you both for your quick responses and suggestions.

It indeed turns out that the file created by the Export function on the
phone version is a compressed file. What threw me off was the fact that the
file's extension is simply .qif. Not having played with this in the last 8
months meant I forgot that it is a compressed file.

After opening the exported file in file-roller, I was able to extract the
actual .qif file, which I could import without any problems.

Marc.



--
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] Loss of all data

[John Ralls]

Please remember to copy the list on all replies. Others may have insights and 
suggestions for solving your problem.

The log files aren't what you want.

The file you need would be named ---.gnucash. At every save GnuCash renamed 
the old file .gnucash.MMDDHHMMSS.gnucash, where YYY... is a bunch 
of numbers forming a datestamp. Those also contain data, but using one implies 
that you'll have to do some re-entry. The OS version is irrelevant.

Regards,
John Ralls


On Jul 29, 2018, at 12:39 PM, d.finb...@gmail.com wrote:
> 
> 
> Hello  John Ralls
> Thanks for responding so quickly.
> I copied the old application of Gnucash (2.6.7) as well as log info from the 
> files that I use ( eg --.gnucash.2018071.log) onto the memory stick, 
> there were 10 such log files.
> I have a back up on another memory stick from the end of March this year (for 
> tax reasons ) but it was made with the old Mac 10.6 OS .
> Regards
> David
> 
> Sent from my iPad
> 
>> On 29 Jul 2018, at 17:16, John Ralls  wrote:
>> 
>> 
>> 
>>> On Jul 29, 2018, at 7:06 AM, David Finbow  wrote:
>>> 
>>> Can any one help me ! I¹ve managed to lose/unable to open all my data !
>>> I updated my Mac OS from 10.6 to ³El Capitan². When I came to open Gnucash I
>>> got the message ³Could not obtain the lock for file:///...² on all my
>>> files.
>>> The update had corrupted the Gnucash files. There were no .LNK or .LCK files
>>> to be found. I could get to the files as read only but was not able to save
>>> any new data. I saved all the Gnucash files to a USB memory stick and then
>>> deleted all the Gnucash files from the desktop. I then downloaded the most
>>> recent Gnucash and set up some new files hoping to drop the files from
>>> memory stick into the new Gnucash files. All that came up were the new empty
>>> files. Alas the old data seems to have gone although there are log files on
>>> the memory stick.
>> 
>> 
>> What files did you copy to your USB stick? Do you have a recent backup from 
>> before the upgrade of your system disk?
>> 
>> 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] Stuck between versions

[1marc1]

David,

I have copied my command history, along with some comments on what I am
doing here: https://pastebin.com/xLUrMmPw

Hopefully that can assist you. Those commands essentially lead to the Output
and Error logs I pasted in my original message.

Marc.



--
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] Stuck between versions

[David Cousens]

Thanks Marc,

I'll see if I can spot any problems. It helps to get feedback as we all
have systems with different sets of software and libraries installed
and widely varying levels of linux expertise, so instructions which
make sense to an experienced developer can be gobbledegook to a novice.
I don't claim to be in the former category, just a user with enough
knowledge to be dangerous.

It looks like you were building in /tmp  (mkdir /tmp/build-gnucash at
one point). I am not sure of the implications of that, but as it is a
system directory owned by root, it may cause issues with permissions. I
build googletest as a shared library in /usr/src and to do so I have to
prefix all cmake and make commands with sudo or open a shell as root in
/usr/src.

I normally build in a directory under my home directory, either in the 
/home//Downloads or a /home//Appliactions directory where I
keep software I compile and install. That simplifies any permissions
issues. The sudo make install command installs it system wide for all
users. 
A successful run of cmake looks something like this:

$ cmake -DCMAKE_INSTALL_PREFIX=/usr/local -DWITH_PYTHON=ON ../
-- Using guile-2.0.x
-- Using guile SRFI-64
-- Checking for module 'gwengui-gtk3'
--   No package 'gwengui-gtk3' found
-- Checking for GTEST
-- Checking for GMOCK
-- Performing Test have_mod_mask
-- Performing Test have_mod_mask - Success
-- Configuring done
-- Generating done
-- Build files have been written to: /home/david/Applications/gnucash-
3.2/build

My cmake command is slightly different because I have a preference for
keeping my build directory in the gnucash-3.2 directory and I normally
install GnuCash to /usr/local.

Looking at the commands you used it looks as though your directory
structure is something like the following:

  gnucash
 |
 gnucash-3.2
 |
 -
 ||
  gnucash sources  build-gnucash-3.2

In this case ../gnucash-3.2 is not finding the top level CMakeLists.txt
 file in the gnucash-3.2 directory which sets it upfor configuring the
rest.

Try 

cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local ../ 
 
from the build-gnucash-3.2 with your existing directory structure.

This should instruct cmake to look for the toplevel CMakeLists.txt file
in the gnucash-3.2 directory which is where it resides. There is
another gnucash folder in the sources under gnucash-3.2 and cmake is
likely picking up the CMakeLists.txt file in that folder. cmake has a
nested list of CMakeLists.txt files at each level in the directory
structure that tells it what to do specifically with the files at that
level.

Hope this helps get you a fulll build

David

On Sun, 2018-07-29 at 18:21 -0500, 1marc1 wrote:
> David,
> 
> I have copied my command history, along with some comments on what I
> am
> doing here: https://pastebin.com/xLUrMmPw
> 
> Hopefully that can assist you. Those commands essentially lead to the
> Output
> and Error logs I pasted in my original message.
> 
> Marc.
> 
> 
> 
> --
> 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.
___
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] Cannot create Budget

[Jim Passmore]

Mike,
I think this is the same issue discussed in this thread
https://lists.gnucash.org/pipermail/gnucash-user/2018-July/077885.html

A quick look at the gnucash bugzilla  doesn't
look like this is an officially filed bug  I'm running 2.6.19 on Ubuntu so
don't have the problem.  Maybe you should submit it so a developer will
check into it?


-- 

*Jim Passmore*




On Sat, Jul 28, 2018 at 5:14 PM Mike stagl  wrote:

> GnuCash 3.2 (3.2+ (2018-06-24))  on Windows 8.
>
> I have created a new file with the Common Accounts.  All the accounts
> populate with no transactions in them.  When I go to Actions -> Budget
> ->New Budget, a budget window open, but there are no Accounts or Sub
> Accounts.
>
> I have some existing Files that have worked in the past, but now when I
> create a budget, the only accounts I can create budgets for are accounts
> with transactions in them.
>
> Did I mess up a setting somewhere?
>
> Thanks to all the contributors!
> ___
> 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] Post invoice still wants to be paid

[David Cousens]

David

One possibility is that if you unposted the invoice at some point after
having paid it and then reposted it, it may be that the link between
the payment and the invoice has been broken by that action. 

There is also the law of conservation of invoices whereby they can only
be created and not destroyed. Unposting an invoice takes it out of your
accounts, but it doesn't remove the invoice record from the system. It
can however be used for another transaction. 


David Cousens

On Sat, 2018-07-28 at 22:51 -0500, David Briggs wrote:
> Hi,  
> 
>  
> 
> First, let me say the books are in balance in all respects.
> 
>  
> 
> Early on, I created an invoice (let's call it Invoice #2) that was
> posted
> and paid.   when I open GnuCash I get a nag to pay it.  When I open
> Vendor->Find Bills and search for that invoice I see it as posted and
> paid.
> I also see it in the appropriate ledgers as posted and paid.
> 
>  
> 
> I have opened the raw XML file and can only find one set of tags for
> that
> invoice (easy enough, there is some unique text on one of the split
> lines.
> )  My thought was to delete it, but if I do that, the books go out of
> balance - as expected.
> 
>  
> 
> The "Pay me" nag persists whether the bill is flagged as active nor
> not.
> Interestingly, nothing bad happens when I flag it as inactive.  I
> should
> think the books would go out of balance, but that does not seem to be
> the
> case, and the invoice and associated payment are still in the
> appropriate
> ledgers.
> 
>  
> 
> Is there some way to get rid of this what appears to be a duplicate,
> posted
> but not paid, invoice? 
> 
>  
> 
> David Briggs
> 
> dlbri...@cox.net  
> 
> 918 625 9170
> 
>  
> 
> ___
> 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] Cannot create Budget

[Mike stagl]

I found the solution, looking at some closed bug reports.  With the budget 
screen open, I needed to correct the filter settings.

View -> Filter By -> Other Tab  and select Show Unused Accounts

This solved my problem.  Thanks for the reply.  Hopefully this helps someone 
else too.

> On Jul 29, 2018, at 9:57 PM, Jim Passmore  wrote:
> 
> Mike,
> I think this is the same issue discussed in this thread
> https://lists.gnucash.org/pipermail/gnucash-user/2018-July/077885.html
> 
> A quick look at the gnucash bugzilla  doesn't
> look like this is an officially filed bug  I'm running 2.6.19 on Ubuntu so
> don't have the problem.  Maybe you should submit it so a developer will
> check into it?
> 
> 
> -- 
> 
> *Jim Passmore*
> 
> 
> 
> 
>> On Sat, Jul 28, 2018 at 5:14 PM Mike stagl  wrote:
>> 
>> GnuCash 3.2 (3.2+ (2018-06-24))  on Windows 8.
>> 
>> I have created a new file with the Common Accounts.  All the accounts
>> populate with no transactions in them.  When I go to Actions -> Budget
>> ->New Budget, a budget window open, but there are no Accounts or Sub
>> Accounts.
>> 
>> I have some existing Files that have worked in the past, but now when I
>> create a budget, the only accounts I can create budgets for are accounts
>> with transactions in them.
>> 
>> Did I mess up a setting somewhere?
>> 
>> Thanks to all the contributors!
>> ___
>> 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.
___
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.