Re: [GNC] Import bug? no account matching options

[David Carlson]

I am confused about Account ID vs Transaction ID as used in this thread.
They are not the same, and transaction ID would not be used for account ID
purposes anyway.  I have Chase OFX files that have Account ID's but no
transaction ID's that, so far, have imported fine for me, except I never
noticed that some transactions should be missing from imports with
overlapping date ranges because I never download overlapping files.  Yes,
transaction ID's should be present, but GnuCash doesn't crash if they are
missing from OFX files, at least in older 2.6.x releases.

For QIF files, is the problem with the source account ID which only appears
at the beginning of the transaction list or with the 'transfer' account in
each transaction?  I think account ID is optional in QIF files.

David Carlson



On Fri, Sep 27, 2019 at 11:08 PM Liz  wrote:

> On Fri, 27 Sep 2019 07:18:21 -0400
> David Reiser via gnucash-user  wrote:
>
> > > I have no experience with Chase, but my bank does not use unique
> > > transaction ID codes in their OFX files.
> > >
> > > Liz
> >
> > Then they aren’t standards-compliant ofx files. Gnucash doesn’t
> > display them anywhere, but they are stored with the transactions. Dave
> > --
>
>
> I know that, but I have not succeeded in getting the bank to change (so
> far).
>
> Liz
> ___
> 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.
>


-- 
David Carlson
___
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] Relocating user specific application data to another directory

[mark101]

Thanks Adrien for your reply.

Yes, in Windows, the financial data file (e.g johndoe.gnucash) is easily
saved in the location of choice.

What I want to work out is how to relocate (migrate) the user data files
(particularly the 'saved-reports' file), which in my Windows 10, are in
their default directory: '(%APPDATA%)\GnuCash'.

My basic understanding of the documentation is that relocation is achievable
in GnuCash V3.x  by creating an 'enviroment.local' file and writing a
GNC_DATA_HOME environmetal variable entry with the appropriate syntax. I
haven’t, as yet, been successful in working out this syntax.

My terminology is likely inaccurate, so I do appreciate your patience.

Mark



--
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] Import bug? no account matching options

[Liz]

On Fri, 27 Sep 2019 07:18:21 -0400
David Reiser via gnucash-user  wrote:

> > I have no experience with Chase, but my bank does not use unique
> > transaction ID codes in their OFX files.
> > 
> > Liz  
> 
> Then they aren’t standards-compliant ofx files. Gnucash doesn’t
> display them anywhere, but they are stored with the transactions. Dave
> --


I know that, but I have not succeeded in getting the bank to change (so
far).

Liz
___
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] Relocating user specific application data to another directory

[Adrien Monteleone]

To be clear, that variable is not for your accounting books, (user data files) 
that is for things like user prefs, CSS or .ini based UI customizations and 
saved report configurations.

If all you want to do is move your data file, just move it. And since you are 
on Windows, you get the luxury (I’m pretty sure) of just double-clicking the 
data file once from the new location to open it and then GnuCash will look for 
it in this new location from there on out.

In a worst, case, you’ll need to do a File > Open and navigate to the new 
location, though, I’m also pretty sure that a File > Save As (and then delete 
the old copy) would probably accomplish the same.

If however, you are truly intending to migrate your config stuff to some other 
location than the default, that *might* involve messing with environment 
variables.

That would be GNC_CONFIG_HOME in that case, if I understand the wiki correctly.

Regards,
Adrien

> On Sep 27, 2019 w39d270, at 7:20 PM, mark101  
> wrote:
> 
> Hi
> 
> For easier backup, I wish to relocate my user specific application data in
> the default directory to another directory on my PC. My operating system is
> Windows 10 and I’m using Gnucash v3.7.
> 
> Documentation suggests this can be achieved by creating an
> 'environment.local' file in the same location as the 'environment' file, and
> adding to it, the GNC_DATA_HOME variable to override the default location.
> 
> Could someone show how the syntax should look in the environment.local file,
> if I want to relocate to the data, to say
> "C:\Users\Mark\OneDrive\Documents\Gnucash_data\GnuCash". I’ve had a number
> of goes at the syntax but to no avail… it keeps using the default directory. 
> 
> For those interested, as well as the text in the environment.local file,
> here are the wiki links which have helped so far:
> 
> https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Windows
> https://wiki.gnucash.org/wiki/Configuration_Locations
> 
> Many thanks and please excuse my ignorance as I’m new to GnuCash.
> 
> Mark

___
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] Relocating user specific application data to another directory

[mark101]

Hi

For easier backup, I wish to relocate my user specific application data in
the default directory to another directory on my PC. My operating system is
Windows 10 and I’m using Gnucash v3.7.

Documentation suggests this can be achieved by creating an
'environment.local' file in the same location as the 'environment' file, and
adding to it, the GNC_DATA_HOME variable to override the default location.

Could someone show how the syntax should look in the environment.local file,
if I want to relocate to the data, to say
"C:\Users\Mark\OneDrive\Documents\Gnucash_data\GnuCash". I’ve had a number
of goes at the syntax but to no avail… it keeps using the default directory. 

For those interested, as well as the text in the environment.local file,
here are the wiki links which have helped so far:

https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Windows
https://wiki.gnucash.org/wiki/Configuration_Locations

Many thanks and please excuse my ignorance as I’m new to GnuCash.

Mark




--
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] Can not insert text on transaction after import QIF

[David Cousens]

David

I am running GnuCash 3.7 built on Linux Mint 19.2 from the tarball download
and I don't experience any of the problems you are describing with editing
the Description or Memo fields in a transaction in an account  register or
in the General Journal tab at all.  They change and are saved and can be
reopened.

I keep my GnuCash files in a Dropbox account and can open them in GnuCash
3.7 on a laptop running Windows 10 with no problem as well, even
simultaneously, if I bypass the lock (definitely not recommended practice
though). Much easier than transferring via QIF files if only going from
GnuCash on Windows to GnuCash on Linux.  You would have to be caerful that
you have the same major version on each. Going from a 2.6 version on Windows
to a 3.7 on Linux would not work for example.

When you installed GnuCash 3.7 was it a new installation? If not, if you
have previously installed GnuCash you may have library files for the
previous version which may not have been overwritten or replaced. I have had
problems in the past with the Linux Mint distribution version's files
conflicting ( I install in /usr/local) if I do not totally remove the
distribution version before installing your own build. Which location did
you install GnuCash 3.7 in?  As long as you don't install to the same
location it should be OK. I often have one or two development builds as well
as the current stable version on my computer as long as I install the
development builds to separate locations in my user directory and my
production stable version to /usr/local I haven't had any problem.  It does
pay to uninstall any previous version that has been installed in a
particular location before installing another version to that location
however.

David Cousens





-
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] Can not insert text on transaction after import QIF

[dmeece]

Sorry John, tried to reply;

but lost in the maze of nabble vs user and got rejected.  As mentioned
earlier, I've got tax season and really don't have time this week to debug
troubleshoot - maybe next month.  
My comments are only to be viewed at the 20,000 foot level anyway - my
overall  impression is that since we went over to the cmake install method,
my experience with Ubuntu/Linuxmint machines have mainly been fails.  I have
no idea as to where these particular Linux boxes store files and libraries.
After this last failed attempt with the ppa load of version 3.7, I spent the
rest of the morning restoring my production machines to a workable
configuration even to the point of timeshifting them.  Every though I
thought I had clean uninstall, both command line and synaptic, I had to
spend a number of hours playing "whereis waldo" with this to get to a point
where I had ripped out enough of the residual gnucash versions so I could
reload a usable ver 2.6.19 (from the synaptic) and get my machines back on
line.  Right now, for me anyway, it appears, gnucash 3.* is a windows
product.   Any ideas about the version 4.* series?
thanks for all the suggestions, I check back shortly.



--
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] Import bug? no account matching options

[David Reiser via gnucash-user]

> On Sep 27, 2019, at 02:36, Liz  wrote:
> 
> On Thu, 26 Sep 2019 19:20:17 -0400
> David Reiser via gnucash-user  wrote:
> 
>> Another workaround would be to download QFX files instead. That has
>> the added advantage that if you do it more than once per billing
>> period, the presence of the unique transaction ID makes it trivially
>> easy for the import matcher to throw out duplicates without even
>> having to ask you about them.
>> 
>> Dave
> 
> I have no experience with Chase, but my bank does not use unique
> transaction ID codes in their OFX files.
> 
> Liz

Then they aren’t standards-compliant ofx files. Gnucash doesn’t display them 
anywhere, but they are stored with the transactions. 
Dave
--
Dave Reiser
dbrei...@icloud.com
___
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] Transactions Associations

[Greg Feneis]

It's possible that when you first started importing this data, GnuCash
didn't initially recognize the source of the data so you needed to tell it
which GnuCash account to import the data to.  At this point, you may have
selected a sub account of the account you actually wanted.  Once GnuCash
learns what account receives what imported data source, I don't know how
that can be changed.

I think another member here faces a similar situation, only in their case,
Gnucash incorrectly recognized a new account's import data as belonging to
an established GnuCash account, so GnuCash denied them the opportunity to
steer the new account's data to the new GnuCash account established for
it.




Kind regards,

Greg Feneis 




On Wed, Sep 25, 2019 at 8:30 PM Joseph G. Keithley, III via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Thanks Dave.
>
> I tried all the clicking I could think of and the only one that did
> anything was when I selected the "R" box on the import screen for an item
> and then double clicked on that row.  A window titled "Select Matching
> Existing Transaction" and the bottom part of that window labeled "Potential
> Splits..." was blank.
>
> I downloaded your guide, I will give it a read.
>
>
> iii
>
>
>
>
>
>
>
>
>  On Thursday, September 26, 2019, 2:16:18 AM UTC, David Cousens <
> davidcous...@bigpond.com> wrote:
>
>
>
>
>
>  Transaction associations are not formed automatically on imported data.
>
> The purpose of the feature is to associate an external file such as an
> image
> or pdf file of a receipt or invoice or other documentation to a transaction
> entry in GnuCash so that if you need to view it, it can be opened from
> within Gnucash.
>
> If by Transaction Associstaions you are referring to the assignment of a
> transfer account in the window called the Generic Import Matcher, this is
> not done from the menu. The documentation is in the process of being
> rewritten and updated at the moment and the current documentation is not as
> clear as I wold like.
>
> Generally single left clicking on a row in the import matcher will select
> it. Ctrl-left click will add to the selection. Double clicking on the row
> will either bring up a dialog to examine the match if a row is not to be
> imported or if it is marked for import it will bring up the dialog to
> assign
> the account for a second split.
>
> The following is a link to the help manual under development in a shared
> folder on my dropbox. It is still under development but the section on
> importing transactions in the chapter on transactions may help you.  It
> hasn't been fully reviewedand accepted by the documentation team at this
> stage. If you do use it I would certainly appreciate any feedback on
> clarity
> and anything which doesn't work as described.
>
> To use it paste the following link into a browser, look for the file
> help.html in the folder the webpage opens at and doubleclick on it. This
> should give you the help manual index on the page. The importing is
> discussed towards the end of chapter 6.
>
> https://www.dropbox.com/sh/dqvn0owqleud2g3/AACsnyg0W-3Qbb4UcddTP6ATa?dl=0
>
> David Cousens
>
>
>
> -
> 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.
> ___
> 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] Import bug? no account matching options

[Liz]

On Thu, 26 Sep 2019 19:20:17 -0400
David Reiser via gnucash-user  wrote:

> Another workaround would be to download QFX files instead. That has
> the added advantage that if you do it more than once per billing
> period, the presence of the unique transaction ID makes it trivially
> easy for the import matcher to throw out duplicates without even
> having to ask you about them.
> 
> Dave

I have no experience with Chase, but my bank does not use unique
transaction ID codes in their OFX files.

Liz
___
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] Can not insert text on transaction after import QIF

[dmeece]

As for further punishment, I unloaded via synaptic the old 2.16.19 version
and gave it a go with Ronal's idea of using the sickylife.ppa load out. 
After cleaning, I loaded the ppa and installed - no problems - no errors. 
3.7 still force closes on touching the files.  Unload it, remove PPA,
attempt to restore my Synaptic - its buggered up.  May have to time shift
this whole thing back to yesterday.

Need to get my linux machine restored and move on.  I'll watch this thread
and see if anyone has ideas as a complete tax season.



--
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] Can not insert text on transaction after import QIF

[dmeece]

Hi,
Thanks for the suggestions and some more definitions about QIF and CSV
importers.  Bottom line for me on my LM 19.2, other than the QIF importer
none of the other techniques work on my Win or Linux machines.  On my linux
box, the program itself did not work although I did get a clean cmake
install this last time.

As this is tax season, I don't have a lot of time to program this stuff - I
need to work on my books.  My history with Gnucash started long ago in the
early 2.* series.  I suppose I was on LM13 or less at that time.  Gnucash
worked in Linux just fine and was a great help. At that time even the auto
downloads aqbank was working for me.  As time went by and especially after
we jumped to the 3.* series, the importing, automation, aqbank, etc stopped
working.  I was still able to create a working program via the tar ball
method until we got to the mandatory cmake procedure.  At that time I was
not able to make an install from any kind of cmake instructions. As I had
hopes to restore some of the functions I had lost, I updated gnucash.  For a
time I was able to get 3.2 from flatpac to work and lately a 3.5 deb package
from Stephen Butler to work.  As mentioned I was able to get a cmake install
for 3.7 using a different procedure to install to $HOME/.local.  Previously
all attempts to install to any /usr or /opt directory failed.
Today I tested old and new .gncash files and all of them failed would not
work in the 3.7 (did the autoclose bit).  I did the "make uninstall" the 3.7
- it came out clean.  I checked the synaptic - clean.  Did the terminal
autoclean/autoremove bit - clean.  Checked dependencies again - attempted to
reinstall the 3.5 deb package.  Now this 3.5 deb package did install
cleanly, but again the files are untouchable - the magic program autoclose.
Is this a new feature?  I unloaded the 3.5, clean it up and then went to the
Synaptic and loaded the old 2.16.19 - the last gnucash Ubuntu/LM put in
their repositories.  This apparently is working.  What the heck!
So this is apparently pointing to issues with the newer Ubuntu/LM
programming/kernels or something. No clues beyond this - have to get
something to work on my books either on the Win machine or old linux
installs.
David



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