from:"Jean L"

Re: [GNC] Defining Keyboard shortcuts for Menu Functions

2024-03-07 Thread Jean L

You have a typo in your second line (missing > after Primary). I don't 
know whether that screws up the import of the file, or if the typo is 
only in your email, but that could be the reason it's not working?


Jean

On 3/7/2024 5:02 PM, Lincoln A Baxter wrote:

Thanks Jean...

I tried this as follows (while GC was not running):

; control-shift-c for csv import:
(gtk_accel_path 
"/gnc-plugin-csv-import-actions/CsvImportTransAction" 
"c")

; control-shift-o for Ofx import:
(gtk_accel_path "/gnc-plugin-ofx-actions/OfxImportAction" 
"o")


Then I ran GC, and Control-Shift-o and Control-Shift-c  did nothing.
FWIW I'm running GC version 4.13 on Debian stable. (bookworm) using 
the Xfce window manager.


Thanks for trying, I've decided I can live with  Alt-f-i-o  which does 
seem to work.


Lincoln


On Wed, 2024-03-06 at 09:38 -0800, Jean Laroche wrote:

As shown in
https://wiki.gnucash.org/wiki/Keyboard_Shortcuts#Modifying_Keyboard_Shortcuts

You need to find and edit the file accelerator-map
Then uncomment the line

(gtk_accel_path "/gnc-plugin-ofx-actions/OfxImportAction" "")

And modify to this (for example, for Ctrl-shift-o to import ofx).

(gtk_accel_path "/gnc-plugin-ofx-actions/OfxImportAction"
"o")

Jean

On 3/6/24 9:14 AM, Lincoln A Baxter wrote:

Hi

I've just spent 45 minutes searching the web, and GC docs for how to a
new keyboard shortcut.

The shortcut I want define would be to File->Import->Import OFX/QFX

Can someone provide me with enough information so that I can do this?

I have no problem editing text configuration files.

I would need to know the function-name for this action, and how to bind
a key to that function in a configuration file GC will read.

TIA,

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

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

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

Re: [GNC] Online Banking

2023-12-17 Thread Jean L

There's also this:

https://github.com/reubano/csv2ofx

I haven't tried it, just wanted to mention that sometimes you can find
really great stuff on github, which isn't reported in a google search

On 12/17/2023 11:52 AM, David Reiser via gnucash-user wrote:

I never got aqbanking to successfully connect to Fidelity’s ofx server. I used
ofxget to retrieve the files, and then imported into gnucash. However, Fidelity
has crippled their ofx creation policy so much that I’ve abandoned their ofx
feeds. Dividends show up with Descriptions and Memos of solely “Qualified
Dividend” or “Non-qualified Dividend”. If you have dividends from stocks or
funds that aren’t automatically reinvested, then you’ll have no idea which
stock or fund paid those dividends.

I’ve been using "csv2ofx Convert" from MoneyThumb to convert csv downloads from
Fidelity and Schwab into ofx files I can import into gnucash. It does cost money, and it
does have some gotchas to be wary of, but it does keep me from making fumble fingered
data input errors in my stock accounts.

I haven’t seen a good description of how to import a csv file of investment
transactions directly into gnucash. If a tutorial of that operation is
available, I’d be interested in pursuing it. The main challenge being (I think)
that many investment transactions involve multiple commodities ($ and shares).

Dave
--
Dave Reiser
dbrei...@icloud.com

On Dec 16, 2023, at 5:44 PM, david amaral via
gnucash-user wrote:

I am attemting to set up online banking to Fidelity and not having much luck. I keep
getting error of "bad request" Have no idea as to why,
AqBanking v6.5.4.0stableSending jobs to the bank(s)Sorting commands by accountSorting account queues by providerSend commands to providersSend
commands to provider "aqofxconnect"Locking customer "7"Sending request...Connecting to server...Resolving hostname
"ofx.fidelity.com" ...IP address is "23.209.84.151"Connecting to "ofx.fidelity.com"Connected to
"ofx.fidelity.com"Connected.Sending message...Message sent.Waiting for response...Receiving response...HTTP-Status: 400 (Bad
Request)Unlocking customer "7"
Any help would be greatly appreciated

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

Re: [GNC] Importing data from QuickBooks Online

2023-07-03 Thread Jean L


This may be slightly off topic, or too late to help, but...

In github, there is a repository
https://github.com/tim-rohrer/move2gnucash
That seems pretty well setup to migrate your data from a quicken csv 
export to GC. I haven't used it, but I looked at it for a friend and it 
looked interesting.


Jean

On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote:

[Resending to the list. Original reply went only to Jim.]

Jim,

Fair questions. Answers below, and I’ve attached the script itself which 
includes documentation which addresses some of the questions. I’ve reviewed all 
documentation that I can find.

 From QBO, I export a journal report to XLS (only usable option in QBO).

GnuCash 5.3 on macOS 11.7.8

See the script for the specific steps.

The import matcher step of the import process is fully satisfied. That is the 
step labeled “Match Import and GnuCash accounts”.

The  problem manifests at the “Match Transactions” screen where all 
transactions need to be matched. I’ve attached a screenshot if it is supported 
here.

One more data point: I tried changing one of the transactions in the 2022 
import file to 2023. It still failed the same way.

—
Tom


On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt  wrote:

Tom:

On 2023-07-02 15:10, Tom Olin via gnucash-user wrote:

I’m attempting to import data from QuickBooks Online to GnuCash. I’ve written 
an awk script which appears to work well except for one major issue.

What format is the data which you export from Quickbooks Online? CSV (Comma 
Separated Values text files with tabular data)? QFX (Quicken Financial 
Exchange, similar to OFX)?

What GnuCash version are you using? On what computer OS?

What GnuCash sequence of actions do you use to import the data?



The data I’m importing spans the years 2022 and 2023. All 2023 transactions 
import cleanly, but all 2022 transactions import unbalanced, meaning I have to 
manually match up each of them - doable but tedious.

Let's assume you are exporting data in CSV format, and using the current 
version of GnuCash (5.3), and importing using the File… Import… Import 
Transactions from CSV menu item. You should be directed through an import 
matcher. This is the place where GnuCash should assign accounts to balance each 
transaction. Is each transaction assigned to an account in the import matcher?

Have you read the section of the documentation explaining how to import data?


Can anyone think of anything that would cause this behavior? I’ve ruled out 
Accounting Period. I’ve imported each year separately. I’ve exported each year 
separately from QBO. The behavior persists.

I’m stumped. Any ideas?

I hope these questions help get enough information on the table to give someone 
ideas.

Best regards,
—Jim DeLaHunt


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


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

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

Re: [GNC] Using Plaid

2023-03-01 Thread Jean L

And now, vanguard apparently no longer offers OFX as a download option, 
just csv files. >:(

hopefully this is temporary, but I'm not holding my breath.

The entire download-you-data landscape for finances in the US is just broken

Jean

On 3/1/2023 2:51 AM, Steve Brown wrote:

This is interesting.

https://www.plaidsettlement.com/

This prompted me to look at a Quicken OFX log after downloading
investment transactions from Raymond James. That log stays traffic
comes from

https://directconnect.rjf.com/eftxweb/access.ofx

but the traffic really comes from

https://services.quicken.com/ofx-secure-plus

Third parties collecting your bank credentials and sniffing your
financial traffic, what can go wrong?

Steve

On Tue, 2023-02-28 at 15:51 -0800, Jean Laroche wrote:

To me it's very different.  You're not giving a user name and a
password
to AQBanking. I started using Plaid, then got really spooked by the
fact
that they do have access to your account as if they were you. Removed
my
account and canceled my keys.
There are no current alternatives at the moment, unlike in Europe
where
there seem to be, I believe mandated by the EU.
I wrote automated scripts to scrape my banks for the OFX files, but
that's a royal pain in the butt, and it's not robust at all.

Jean

On 2/28/23 3:44 PM, Ben Pracht wrote:

   I read that disclaimer. It says to keep the token secure and yes,
the
bearer of that token gets access. As they said:
"The access token generated by using this tool is sensitive
material as it
grants access to your accounts. It should be handled with care and
protected from unauthorized access. You must be sure to store it in
such a
way that makes it impossible for others to gain access. The
creators and
maintainers of Plaid2QIF are in no way responsible if you mishandle
your
access token."

GIving Plaid2QIF this token is no different than me giving a
username and
password to AQBanking, except that Plaid has a chance of working. I
don't
like having an intermediary, in this case Plaid and Plaid2QIF, but
OFX is
unusable, and at the moment, AQBanking isn't even showing the list
of banks
anymore. Does anyone know of a US bank or credit union that uses a
modern
REST based API that they actually share with developers?

Regards,
Ben

On 2/22/23 23:08, john wrote:

On Feb 22, 2023, at 2:01 PM, Ben Pracht
   wrote:

I'd like to use Plaid with GnuCash. There is a plaid2qif project
that
claims to have been extensively tested with GnuCash and Plaid.
However,
when I created the Plaid account, it asks for either a limited
developer
account or a production account with a compliance audit. What
account type
should I use? Anything else helpful to know?


Neither. See
https://github.com/ebridges/plaid2qif/blob/master/gen-access-token/README.md
,

Pay particular attention to the disclaimer at the bottom of that
page.

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

2023-01-07 Thread Jean L


Also, this

https://github.com/jrwrigh/csv2cash

Could be the answer to what you're trying to do?

Jean

On 1/7/2023 12:51 PM, Tim Rohrer wrote:




On Jan 7, 2023, at 2:32 PM, Jean L  wrote:


OK so I found that GC fais to import this ofx because the account 
name is too long. This is probably a bug, but I'm not sure what the 
specs are for account names in the OFX specifications.


Nice find! Thank you. So yeah, `csv2ofx` generates those randomly. Why 
the author made them so long is a little unclear; maybe the same code 
as the autogenerated FITD?


About the rest of your questions:

You're right that you can't specify the "other" account (like 
expense:dining) in the OFX file. That's specifically a GC thing. When 
you import your OFX, you have to specify the "other" account for each 
transaction, but GC learns to automatically assign it after a little 
while so you no longer have to assign it manually.


In your case it's not super helpful if you save *all* your migrated 
transactions into a single OFX then try to import that in one shot 
you'll have to specify the other account for each transaction, which 
would be super tedious.


Instead, you could import only the first N transactions, the 
re-import and deals with the N next ones, etc. Each time you import, 
GC learns the association between transactions and splits. But that 
too could be tedious.


Perhaps you can make it work better with the CSV idea. Even better 
would be to write a script that takes the CSV export, and generates 
the complete xml file that GC uses to represent your account tree. 
I.e., a tool to automatically create a GC account file from a csv 
export. Perhaps somebody's written that already?




This last idea is exactly what I was starting to think about. I don't 
know C/C++, but I can figure out XML. And I've not done a lot of 
Internet searching yet for others who've worked this migration (other 
than in our mailing list).


Again, thank you!

Tim


Jean

On 1/7/2023 10:59 AM, Tim Rohrer wrote:

Correct. And the errors and warnings I pasted earlier are logged.

Linux GnuCash 4.11
Build ID: 4.11+(2022-06-25)


On Jan 7, 2023, at 12:53 PM, Jean L  wrote:


And you're saying that when you import this into a blank account, 
nothing shows up?


On 1/7/2023 10:52 AM, Tim Rohrer wrote:

Thanks, Jean.

Here is the entire file (attached and pasted). For testing, I was 
simply trying to get one transaction to work first.



DATA:OFXSGML
ENCODING:UTF-8




0
INFO

20230107105800
ENG






0
INFO


USD

b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING


19700101
20230107

CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim









On Jan 7, 2023, at 12:41 PM, Jean L  wrote:


Can you post a small OFX file that's generated that way? I'll take a
quick look.

Jean

On 1/7/2023 10:18 AM, Tim Rohrer wrote:
I'm continuing my experimentation to migrate my Quicken for Mac 
data. I believe I'm on track for the investments, so I've 
switched back to regular accounts.


Originally, I was going to use the Quicken Mac 2007 Transfer 
File (QMTF aka QIF) but I started seeing some issues with how 
GnuCash handles splits, plus I'd lose tags and much of my notes.


Now I'm trying to usehttps://github.com/reubano/csv2ofx 
<https://github.com/reubano/csv2ofx> to generate OFX files from 
exported csv.


A dummy csv transaction:

Date,Payee/Security,Category,Amount,Account
1/1/2022,Tim,Income:Salary,500,Family Checking

Using csv2ox with a custom mapper, I get an ofx with guts of the 
transaction like this:





0
INFO


USD

b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING


19700101
20230107

CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim





But nothing appears to import.

In my logs:

LibOFX INFO: libofx_proc_file(): File format not specified, 
autodetecting...

(Above message occurred on Line 40, Column 1)
LibOFX INFO: libofx_proc_file(): Detected file format: OFX (Open 
Financial eXchange (OFX or QFX))

(Above message occurred on Line 40, Column 1)
LibOFX INFO: Created OfxDummyContainer to hold unsupported 
aggregate SIGNONMSGSRSV1

(Above message occurred on Line 2, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported 
aggregate SONRS

(Above message occurred on Line 3, Column 3)
LibOFX INFO: Created OfxDummyContainer to hold unsupported 
aggregate BANKMSGSRSV1

(Above message occurred on Line 12, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported 
aggregate STMTTRNRS

(Above message occurred on Line 13, Column 3)
LibOFX WARNING: ofxdate_to_time_t(): Successfully parsed date 
part, but unable to parse time part of string 19700101. It is 
not in proper MMDDHHMMSS.XXX[gmt offset:tz name] format!

(Above message occurred on Line 27, Column 23)
LibOFX WARNING: ofxdate_to_time_t(): Successfully parsed date 
p

Re: [GNC] OFX Requirements

2023-01-07 Thread Jean L

OK so I found that GC fais to import this ofx because the account name 
is too long. This is probably a bug, but I'm not sure what the specs are 
for account names in the OFX specifications.


About the rest of your questions:

You're right that you can't specify the "other" account (like 
expense:dining) in the OFX file. That's specifically a GC thing. When 
you import your OFX, you have to specify the "other" account for each 
transaction, but GC learns to automatically assign it after a little 
while so you no longer have to assign it manually.


In your case it's not super helpful if you save *all* your migrated 
transactions into a single OFX then try to import that in one shot 
you'll have to specify the other account for each transaction, which 
would be super tedious.


Instead, you could import only the first N transactions, the re-import 
and deals with the N next ones, etc. Each time you import, GC learns the 
association between transactions and splits. But that too could be tedious.


Perhaps you can make it work better with the CSV idea. Even better would 
be to write a script that takes the CSV export, and generates the 
complete xml file that GC uses to represent your account tree. I.e., a 
tool to automatically create a GC account file from a csv export. 
Perhaps somebody's written that already?


Jean

On 1/7/2023 10:59 AM, Tim Rohrer wrote:

Correct. And the errors and warnings I pasted earlier are logged.

Linux GnuCash 4.11
Build ID: 4.11+(2022-06-25)


On Jan 7, 2023, at 12:53 PM, Jean L  wrote:


And you're saying that when you import this into a blank account, 
nothing shows up?


On 1/7/2023 10:52 AM, Tim Rohrer wrote:

Thanks, Jean.

Here is the entire file (attached and pasted). For testing, I was 
simply trying to get one transaction to work first.



DATA:OFXSGML
ENCODING:UTF-8




0
INFO

20230107105800
ENG






0
INFO


USD

b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING


19700101
20230107

CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim









On Jan 7, 2023, at 12:41 PM, Jean L  wrote:


Can you post a small OFX file that's generated that way? I'll take a
quick look.

Jean

On 1/7/2023 10:18 AM, Tim Rohrer wrote:
I'm continuing my experimentation to migrate my Quicken for Mac 
data. I believe I'm on track for the investments, so I've switched 
back to regular accounts.


Originally, I was going to use the Quicken Mac 2007 Transfer File 
(QMTF aka QIF) but I started seeing some issues with how GnuCash 
handles splits, plus I'd lose tags and much of my notes.


Now I'm trying to usehttps://github.com/reubano/csv2ofx 
<https://github.com/reubano/csv2ofx> to generate OFX files from 
exported csv.


A dummy csv transaction:

Date,Payee/Security,Category,Amount,Account
1/1/2022,Tim,Income:Salary,500,Family Checking

Using csv2ox with a custom mapper, I get an ofx with guts of the 
transaction like this:





0
INFO


USD

b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING


19700101
20230107

CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim





But nothing appears to import.

In my logs:

LibOFX INFO: libofx_proc_file(): File format not specified, 
autodetecting...

(Above message occurred on Line 40, Column 1)
LibOFX INFO: libofx_proc_file(): Detected file format: OFX (Open 
Financial eXchange (OFX or QFX))

(Above message occurred on Line 40, Column 1)
LibOFX INFO: Created OfxDummyContainer to hold unsupported 
aggregate SIGNONMSGSRSV1

(Above message occurred on Line 2, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported 
aggregate SONRS

(Above message occurred on Line 3, Column 3)
LibOFX INFO: Created OfxDummyContainer to hold unsupported 
aggregate BANKMSGSRSV1

(Above message occurred on Line 12, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported 
aggregate STMTTRNRS

(Above message occurred on Line 13, Column 3)
LibOFX WARNING: ofxdate_to_time_t(): Successfully parsed date 
part, but unable to parse time part of string 19700101. It is not 
in proper MMDDHHMMSS.XXX[gmt offset:tz name] format!

(Above message occurred on Line 27, Column 23)
LibOFX WARNING: ofxdate_to_time_t(): Successfully parsed date 
part, but unable to parse time part of string 20230107. It is not 
in proper MMDDHHMMSS.XXX[gmt offset:tz name] format!

(Above message occurred on Line 28, Column 21)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpEkcf1m:37:11:E: end tag for "STMTRS" which is not 
finished


I do notice there is no category which could be a problem with my 
customer mapper, so I'll keep experimenting.


But, does anyone see what could be causing the error? Are the 
warnings of concern?


Tim
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscriptio

Re: [GNC] OFX Requirements

2023-01-07 Thread Jean L

And you're saying that when you import this into a blank account, 
nothing shows up?


On 1/7/2023 10:52 AM, Tim Rohrer wrote:

Thanks, Jean.

Here is the entire file (attached and pasted). For testing, I was 
simply trying to get one transaction to work first.



DATA:OFXSGML
ENCODING:UTF-8




0
INFO

20230107105800
ENG






0
INFO


USD

b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING


19700101
20230107

CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim









On Jan 7, 2023, at 12:41 PM, Jean L  wrote:


Can you post a small OFX file that's generated that way? I'll take a
quick look.

Jean

On 1/7/2023 10:18 AM, Tim Rohrer wrote:
I'm continuing my experimentation to migrate my Quicken for Mac 
data. I believe I'm on track for the investments, so I've switched 
back to regular accounts.


Originally, I was going to use the Quicken Mac 2007 Transfer File 
(QMTF aka QIF) but I started seeing some issues with how GnuCash 
handles splits, plus I'd lose tags and much of my notes.


Now I'm trying to usehttps://github.com/reubano/csv2ofx 
<https://github.com/reubano/csv2ofx> to generate OFX files from 
exported csv.


A dummy csv transaction:

Date,Payee/Security,Category,Amount,Account
1/1/2022,Tim,Income:Salary,500,Family Checking

Using csv2ox with a custom mapper, I get an ofx with guts of the 
transaction like this:





0
INFO


USD

b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING


19700101
20230107

CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim





But nothing appears to import.

In my logs:

LibOFX INFO: libofx_proc_file(): File format not specified, 
autodetecting...

(Above message occurred on Line 40, Column 1)
LibOFX INFO: libofx_proc_file(): Detected file format: OFX (Open 
Financial eXchange (OFX or QFX))

(Above message occurred on Line 40, Column 1)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate 
SIGNONMSGSRSV1

(Above message occurred on Line 2, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate 
SONRS

(Above message occurred on Line 3, Column 3)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate 
BANKMSGSRSV1

(Above message occurred on Line 12, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate 
STMTTRNRS

(Above message occurred on Line 13, Column 3)
LibOFX WARNING: ofxdate_to_time_t(): Successfully parsed date part, 
but unable to parse time part of string 19700101. It is not in 
proper MMDDHHMMSS.XXX[gmt offset:tz name] format!

(Above message occurred on Line 27, Column 23)
LibOFX WARNING: ofxdate_to_time_t(): Successfully parsed date part, 
but unable to parse time part of string 20230107. It is not in 
proper MMDDHHMMSS.XXX[gmt offset:tz name] format!

(Above message occurred on Line 28, Column 21)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpEkcf1m:37:11:E: end tag for "STMTRS" which is not finished

I do notice there is no category which could be a problem with my 
customer mapper, so I'll keep experimenting.


But, does anyone see what could be causing the error? Are the 
warnings of concern?


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

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



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

Re: [GNC] OFX Requirements

2023-01-07 Thread Jean L

Can you post a small OFX file that's generated that way? I'll take a 
quick look.


Jean

On 1/7/2023 10:18 AM, Tim Rohrer wrote:

I'm continuing my experimentation to migrate my Quicken for Mac data. I believe 
I'm on track for the investments, so I've switched back to regular accounts.

Originally, I was going to use the Quicken Mac 2007 Transfer File (QMTF aka 
QIF) but I started seeing some issues with how GnuCash handles splits, plus I'd 
lose tags and much of my notes.

Now I'm trying to usehttps://github.com/reubano/csv2ofx  
  to generate OFX files from exported csv.

A dummy csv transaction:

Date,Payee/Security,Category,Amount,Account
1/1/2022,Tim,Income:Salary,500,Family Checking

Using csv2ox with a custom mapper, I get an ofx with guts of the transaction 
like this:




0
INFO


USD

b9fc6ca936ba09958d5076dd5ebfac69
384d7d0b77b259606be9c29de2e05b45
CHECKING


19700101
20230107

CREDIT
2022010100
500.00
743df964dc21309d6d8a7c0ca5eaa657
Tim





But nothing appears to import.

In my logs:

LibOFX INFO: libofx_proc_file(): File format not specified, autodetecting...
(Above message occurred on Line 40, Column 1)
LibOFX INFO: libofx_proc_file(): Detected file format: OFX (Open Financial 
eXchange (OFX or QFX))
(Above message occurred on Line 40, Column 1)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate 
SIGNONMSGSRSV1
(Above message occurred on Line 2, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate SONRS
(Above message occurred on Line 3, Column 3)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate 
BANKMSGSRSV1
(Above message occurred on Line 12, Column 2)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate STMTTRNRS
(Above message occurred on Line 13, Column 3)
LibOFX WARNING: ofxdate_to_time_t():  Successfully parsed date part, but unable 
to parse time part of string 19700101. It is not in proper 
MMDDHHMMSS.XXX[gmt offset:tz name] format!
(Above message occurred on Line 27, Column 23)
LibOFX WARNING: ofxdate_to_time_t():  Successfully parsed date part, but unable 
to parse time part of string 20230107. It is not in proper 
MMDDHHMMSS.XXX[gmt offset:tz name] format!
(Above message occurred on Line 28, Column 21)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpEkcf1m:37:11:E: end tag for "STMTRS" which is not finished

I do notice there is no category which could be a problem with my customer 
mapper, so I'll keep experimenting.

But, does anyone see what could be causing the error? Are the warnings of 
concern?

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

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

Re: [GNC] Autofill on import OFX?

2022-12-31 Thread Jean L

No you don't need to do anything for it to learn, except select the 
account the transaction should be associated with when you import the 
transaction so the matcher can remember that. Of course, that's only if 
you haven't already entered the transaction manually (in which case you 
already selected the accounts involved).


So:
- If your OFX transaction matches an existing transaction you entered 
manually you have nothing to do
- If you're importing an OFX transaction that's "new" (you haven't 
entered it manually) then make sure you select the accounts during the 
import, not afterward. If you select the account afterward the matcher 
does not get a chance to learn the correct association.


J

On 12/31/2022 1:06 PM, Simon Roberts wrote:

Thanks for this Jean, Murugan, that's very helpful (and rather impressive!)

Do I infer that I need to use the " right click on a transaction in the
transaction matching window, you can edit various fields prior to the
transaction being imported" feature so it knows I'm trying to teach it,
rather than editing after the import is complete?

Cheers,
Simon


On Sat, Dec 31, 2022 at 12:15 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:


Simon

GNUCash learns the transactions matching when you start input, and stores
it for future reference. Same is the case with imported files, you can view
the  import map editor for details.  please note you cannot directly enter
the assocation here, but you can delete any wrong association and allow
GNUCash to relearn.

it takes some time for the system to learn the associations.



Saludos Cordiales


Murugan
--
*From:* gnucash-user  on behalf of Simon Roberts <
si...@dancingcloudservices.com>
*Sent:* Saturday, December 31, 2022 3:20 PM
*To:* Gnucash Users
*Subject:* [GNC] Autofill on import OFX?

Now that I have GC 4.13 and my imported transactions are correctly
recognized and not dumped, I have another question.

If I have a transaction with, for example, a description field of XYZ, and
I start to enter a new transaction with the same description, and then hit
tab, GC auto-fills all the rest of the fields; Transfer, Amount, Memo, etc.
This is great.

However, this behavior doesn't seem to occur with imported transactions.

To be clear, I don't expect (nor want!) it to overwrite transaction
details, but inferring the Transfer field, which is of course not specified
(nor could it be) in the OFX file, would be enormously helpful. Similarly,
copying over the most recent memo field would be good too.

Is there a way to configure this behavior, or does this constitute a
feature request?

Another question, which I think is sufficiently related to be OK to put in
the same message, is that in the system we're migrating away from
(quickbooks--washes mouth with soap and water :) there are "rules" one can
apply. For example, "if the description field of the import contains this
text, then fill out that field with that text". Is there such a mechanism
in GnuCash, and if so, what's it called (so I can read about it in
documentation)?

Thanks for all your ongoing help everyone, it's very reassuring that
there's a community as active and willing to help when making a transition
as critical as this!

Cheers,
Simon

--
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




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

Re: [GNC] Autofill on import OFX?

2022-12-31 Thread Jean L

The transfer will be automatically assigned once you import a few 
transactions. GC is smart in the way it learns from previous imported 
transactions which account a given imported transaction should be 
assigned to. So give it a little time and it'll do the right thing. 
Another thing you may not have noticed: if you right click on a 
transaction in the transaction matching window, you can edit various 
fields prior to the transaction being imported.


There are no "rules", the way you describe them, in GC, as far as I know...

Jean

On 12/31/2022 10:20 AM, Simon Roberts wrote:

Now that I have GC 4.13 and my imported transactions are correctly
recognized and not dumped, I have another question.

If I have a transaction with, for example, a description field of XYZ, and
I start to enter a new transaction with the same description, and then hit
tab, GC auto-fills all the rest of the fields; Transfer, Amount, Memo, etc.
This is great.

However, this behavior doesn't seem to occur with imported transactions.

To be clear, I don't expect (nor want!) it to overwrite transaction
details, but inferring the Transfer field, which is of course not specified
(nor could it be) in the OFX file, would be enormously helpful. Similarly,
copying over the most recent memo field would be good too.

Is there a way to configure this behavior, or does this constitute a
feature request?

Another question, which I think is sufficiently related to be OK to put in
the same message, is that in the system we're migrating away from
(quickbooks--washes mouth with soap and water :) there are "rules" one can
apply. For example, "if the description field of the import contains this
text, then fill out that field with that text". Is there such a mechanism
in GnuCash, and if so, what's it called (so I can read about it in
documentation)?

Thanks for all your ongoing help everyone, it's very reassuring that
there's a community as active and willing to help when making a transition
as critical as this!

Cheers,
Simon


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

Re: [GNC] Matching error in OFX import

2022-12-30 Thread Jean L

Don't forget to reply to the list.

Bear in mind: if you import an OFX file, match its transactions to some 
of your register transactions, the matched transactions will be silently 
ignored when you re-import the same OFX. That's by design. So if you 
match everything then re-import the same OFX, you'll have nothing to match.

GC uses the FITID to verify that an OFX transaction was already imported 
and matched (it compares the FITID value of the transaction in the 
register to that in the OFX file). When GC imports an OFX transaction, 
it copies the OFX FITID to the register transaction.

But yes, update to a recent version as there were bugs in this mechanism 
that were recently fixed.

J

On 12/30/2022 6:03 PM, Simon Roberts wrote:

Yes, different FITIDs.

I'm now finding that actually silently dumping some of these similar 
transactions. (But I've also discovered I'm not using the latest 
version--I'm on 3.8, so I think I should upgrade it and try again.)

On Fri, Dec 30, 2022 at 6:57 PM Jean L  wrote:

We might need a bit more info to give a useful answer. But just to
be sure:
- The FITID of the transactions in the OFX file are all different,
right? That's an absolute requirement, not just within a single OFX
file, but from ofx to ofx, the FITID is supposed to identify one and
only 1 transaction. If you re-download the same transaction the
FITID is
supposed to be the same as the first time you downloaded it. GC uses
this to know which transactions have already been matched when it
looks
at an imported OFX file.

- Is the problem that you have similar transactions in your register
(that you've entered manually) with the same amount and close dates?
It's not impossible that GC is a bit confused because it finds 2
or more
transactions in your register than seem to match 1 or more
transactions
in your OFX. In other words, GC does not have a way to figure out
which
OFX transaction should be matched with which transaction in your
register if everything is very similar between them.
I must say I've never run into this issue, so I don't know for a fact
what GC does in that case.

J

On 12/30/2022 5:36 PM, Simon Roberts wrote:
> With the same caveat about my being new to this...
>
> My transaction records show regular, very similar, transactions.
The same
> institution, identical amounts, usually close but not identical
dates.
>
> The importer's matcher is confused by these similar
transactions. It marks
> them in red and refuses to do anything with them directly. I can
unmark
> them, and then get them to import, but there are other fields
(specifically
> there is a field "" in the OFX file that seems like it should
> distinguish them, even if everything else is identical (I'm
assuming FITID
> is "Financial Transaction ID", but I could be wrong since that's
just a
> guess!)
>
> In the interest of being clear, these "conflicting" transactions
are in the
> *same* OFX file, it's not trying to match against something
already in
> place.
>
> Can I do anything to get this to behave more helpfully?
>
> Cheers,
> Simon
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

--
Simon Roberts
(303) 249 3613

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

Re: [GNC] Matching error in OFX import

2022-12-30 Thread Jean L


We might need a bit more info to give a useful answer. But just to be sure:
- The FITID of the transactions in the OFX file are all different, 
right? That's an absolute requirement, not just within a single OFX 
file, but from ofx to ofx, the FITID is supposed to identify one and 
only 1 transaction. If you re-download the same transaction the FITID is 
supposed to be the same as the first time you downloaded it. GC uses 
this to know which transactions have already been matched when it looks 
at an imported OFX file.


- Is the problem that you have similar transactions in your register 
(that you've entered manually) with the same amount and close dates? 
It's not impossible that GC is a bit confused because it finds 2 or more 
transactions in your register than seem to match 1 or more transactions 
in your OFX. In other words, GC does not have a way to figure out which 
OFX transaction should be matched with which transaction in your 
register if everything is very similar between them.
I must say I've never run into this issue, so I don't know for a fact 
what GC does in that case.


J

On 12/30/2022 5:36 PM, Simon Roberts wrote:

With the same caveat about my being new to this...

My transaction records show regular, very similar, transactions. The same
institution, identical amounts, usually close but not identical dates.

The importer's matcher is confused by these similar transactions. It marks
them in red and refuses to do anything with them directly. I can unmark
them, and then get them to import, but there are other fields (specifically
there is a field "" in the OFX file that seems like it should
distinguish them, even if everything else is identical (I'm assuming FITID
is "Financial Transaction ID", but I could be wrong since that's just a
guess!)

In the interest of being clear, these "conflicting" transactions are in the
*same* OFX file, it's not trying to match against something already in
place.

Can I do anything to get this to behave more helpfully?

Cheers,
Simon


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

Re: [GNC] OFX import date questions

2022-12-30 Thread Jean L

This is not expected behavior. I never happens to me, in fact ofx import 
usually works just fine.
There might be something off in your preferences. You could try to go 
into "import" and adjust the "likely match day" threshold and the 
"Unlikely match day threshold". Mine are set to 4 and 14, which I 
believe means that two dates less than 4 days apart are considered a 
good match, while dates more then 14 days apart are a "no match" and 
there's a continuous in between. Hover over the + sign to get a help 
balloon.

If that's not the issue, there has to be a reason why GC does not 
consider the transactions you've entered for a match. The issue is 
either a date mismatch or an amount mismatch. If you let GC enter the 
transaction for you (instead of matching the existing one) can you see a 
mismatch between the dates and amounts of each transaction?

On 12/30/2022 2:20 PM, Phyllis Bruce wrote:
Jean and  Adrien, I use QFX and reconciling is a pain!  When I import 
and data from my bank and begin reconciliation I often find the GNC 
has ignored the existing unreconciled transactions and created new 
cleared ones.

On Fri, Dec 30, 2022 at 3:51 PM Jean L  wrote:

I don't think you can "tweak" the OFX import. OFX import relies on an
external library (ofxlib I think?).
Are the dates way off? I've never noticed anything weird like that
in my
own OFX imports (which I do a lot of) the dates seem to always
coincide.

This *could* be a problem with the OFX created by your bank. If
you're a
programmer, you might want to write a small program to edit the
OFX file
before importing (I have to do that for citibank because of unique ID
issues).

J

On 12/30/2022 1:35 PM, Simon Roberts wrote:
> Beginner/refugee from QuickBooks here (more context below if you
> care).  I'm working in a scratch file, so I can do stupid things
while
> learning without damaging anything "important".
>
> I'm working with importing my bank transactions using OFX format
(though
> I've also tinkered with CSV, and am willing to use that if it
> solves my problem).
>
> I imported some transactions using OFX. Several things surprised
me, but
> the one that I think needs resolving first is that the
transaction dates do
> not match the bank statement.
>
> Earlier I tried the CSV import and saw there were *two* date fields
> (presumably difference between being received and being acted on?
>
> Can someone tell me what I should do to fix this? Is there a way
to "tweek"
> the OFX import, or do I need to use CSV? Or is this something
else entirely
> that's gone amiss?
>
> Thanks for any hints,
> Cheers,
> Simon
>
> Background in case it's relevant:
>
> I'm a refugee from Intuit, and very early in my learning process.
>
> I"m not a bookkeeper, I'm a programmer. Conversely, my
bookkeeper isn't a
> software person--she would have continued paying the annual
ransom to
> Intuit but I'm sick of their hostage taking. Of course this
means I need to
> do a decent part of the legwork for this transition.
>
> Of course because I'm not a bookkeeper, I don't understand the
accounting
> side of this stuff, and likely won't know how to ask/phrase the
questions.
>
> Neither of us are going to be great at searching the
documentation since it
> seems like the terminology is different between GC and QB (and I
don't
> really know the terminology anyway)
>
> So, please forgive the idiot question, and if the simple answer to a
> question is RTFM, we're very happy to do so, but likely are
asking as we've
> failed to find the relevant part of said references.
>
> Anyway, thanks for your indulgence :)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] OFX import date questions

2022-12-30 Thread Jean L

I don't think you can "tweak" the OFX import. OFX import relies on an 
external library (ofxlib I think?).
Are the dates way off? I've never noticed anything weird like that in my 
own OFX imports (which I do a lot of) the dates seem to always coincide.


This *could* be a problem with the OFX created by your bank. If you're a 
programmer, you might want to write a small program to edit the OFX file 
before importing (I have to do that for citibank because of unique ID 
issues).


J

On 12/30/2022 1:35 PM, Simon Roberts wrote:

Beginner/refugee from QuickBooks here (more context below if you
care).  I'm working in a scratch file, so I can do stupid things while
learning without damaging anything "important".

I'm working with importing my bank transactions using OFX format (though
I've also tinkered with CSV, and am willing to use that if it
solves my problem).

I imported some transactions using OFX. Several things surprised me, but
the one that I think needs resolving first is that the transaction dates do
not match the bank statement.

Earlier I tried the CSV import and saw there were *two* date fields
(presumably difference between being received and being acted on?

Can someone tell me what I should do to fix this? Is there a way to "tweek"
the OFX import, or do I need to use CSV? Or is this something else entirely
that's gone amiss?

Thanks for any hints,
Cheers,
Simon

Background in case it's relevant:

I'm a refugee from Intuit, and very early in my learning process.

I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper isn't a
software person--she would have continued paying the annual ransom to
Intuit but I'm sick of their hostage taking. Of course this means I need to
do a decent part of the legwork for this transition.

Of course because I'm not a bookkeeper, I don't understand the accounting
side of this stuff, and likely won't know how to ask/phrase the questions.

Neither of us are going to be great at searching the documentation since it
seems like the terminology is different between GC and QB (and I don't
really know the terminology anyway)

So, please forgive the idiot question, and if the simple answer to a
question is RTFM, we're very happy to do so, but likely are asking as we've
failed to find the relevant part of said references.

Anyway, thanks for your indulgence :)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Import is finding no matching transactions

2022-05-14 Thread Jean L

Yes, if the transactions have been imported before, they will not even 
show in the matching dialog, in the latest version of GC.

J

On 5/14/2022 4:26 PM, Greg Feneis wrote:

Another possibility is if you happen to be trying to import transactions
that GnuCash thinks have already been imported, the matcher dialogue may
appear like there are no transactions being proposed to be imported,
essentially there will be nothing displayed in the matcher dialogue. Just
in case this is what you're seeing.  This according to how GnuCash 3.21
works.  Maybe newer GnuCash still works the same?

Kind regards, Greg Feneis
(Pixel 3)


On Sat, May 14, 2022, 14:20 Jean L  wrote:


Can you give us more details? Are you saying that GC does not show
matching transactions, but does it at least show the imported
transactions (and fails to find matches)?

Note that the transaction dates have to match (the imported transactions
and the ones you have in your ledger) for them to be matched (look in
your preferences, the "import" tab, that's where the thresholds are
adjusted for days), they don't have to match exactly depending on the
"likely match day threshold" but they have to be within that. You could
try to debug by lowering the "match display threshold" to see whether
that helps GC find them. But in theory, if the days match and the
amounts match, GC should find the transactions and show them in the
reconcile dialog.

On 5/14/2022 2:06 PM, Thepwnd via gnucash-user wrote:

Hi all,

So I am still fairly new to Gnucash (and personal finances for that

matter), but I've been using it the last 2 months and change to track my
family's spending. I primarily use my debit card for daily purchases, but I
have begun keeping receipts for more immediate entry into the ledger and to
more accurately track what categories I spend the most money in. However,
there are still some purchases I make that don't give me a receipt, and in
those cases, the only record I have is on my bank statement.

I would like to be able to import my bank statement occasionally to

catch all those transactions, but not duplicate all the ones I already
entered. My understanding is that when importing transactions from a bank
statement, Gnucash should be able to match any existing transactions on the
ledger and mark those as "Reconcile" on the statement. I swear this was
working when I first started using Gnucash, but now, when I try to import
my bank statement, Gnucash isn't finding any matches on the ledger, even
though the vast majority of the transactions on the statement already exist
in Gnucash.

I can't figure out what happened, and there don't appear to be any

preferences for imports or matching, so I'm not sure what I might have
changed to cause this to stop working. Does anyone here have any ideas?

Thanks in advance!
-Aaron

Sent with [ProtonMail](https://protonmail.com/) secure email.
___
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 seehttps://

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 
seehttps://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 is finding no matching transactions

2022-05-14 Thread Jean L

Can you give us more details? Are you saying that GC does not show 
matching transactions, but does it at least show the imported 
transactions (and fails to find matches)?


Note that the transaction dates have to match (the imported transactions 
and the ones you have in your ledger) for them to be matched (look in 
your preferences, the "import" tab, that's where the thresholds are 
adjusted for days), they don't have to match exactly depending on the 
"likely match day threshold" but they have to be within that. You could 
try to debug by lowering the "match display threshold" to see whether 
that helps GC find them. But in theory, if the days match and the 
amounts match, GC should find the transactions and show them in the 
reconcile dialog.


On 5/14/2022 2:06 PM, Thepwnd via gnucash-user wrote:

Hi all,

So I am still fairly new to Gnucash (and personal finances for that matter), 
but I've been using it the last 2 months and change to track my family's 
spending. I primarily use my debit card for daily purchases, but I have begun 
keeping receipts for more immediate entry into the ledger and to more 
accurately track what categories I spend the most money in. However, there are 
still some purchases I make that don't give me a receipt, and in those cases, 
the only record I have is on my bank statement.

I would like to be able to import my bank statement occasionally to catch all those 
transactions, but not duplicate all the ones I already entered. My understanding is that 
when importing transactions from a bank statement, Gnucash should be able to match any 
existing transactions on the ledger and mark those as "Reconcile" on the 
statement. I swear this was working when I first started using Gnucash, but now, when I 
try to import my bank statement, Gnucash isn't finding any matches on the ledger, even 
though the vast majority of the transactions on the statement already exist in Gnucash.

I can't figure out what happened, and there don't appear to be any preferences 
for imports or matching, so I'm not sure what I might have changed to cause 
this to stop working. Does anyone here have any ideas?

Thanks in advance!
-Aaron

Sent with [ProtonMail](https://protonmail.com/) secure email.
___
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 
seehttps://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] QFX file for Bank of American business account not invoking Import Matcher

2022-05-04 Thread Jean L

You launch GC with the --debug flag. If you're on MacOS, you have to go 
to a console, find the path to your Gnucash, then do 
GnucashApp/contents/MacOs/Gnucash/Gnucash --debug (from memory, so I'm 
sure some of this is wrong)

Same idea on windows and linux, launch from the command line with the 
--debug flag.

J

On 5/4/2022 8:23 PM, Peter Wu wrote:

@Jean Laroche , can you send some 
instructions on how to run the debug mode?

I have another QFX file from BofA too.  It failed even after I remove 
CARDNUM, CARDNAME and MCC elements.

I suspect there are more invalid tags in this file.

Btw, the sample file I give you worked after removing above three tags.

Best,

Peter

*From: *gnucash-user 
 on behalf 
of Jean Laroche 

*Date: *Wednesday, May 4, 2022 at 09:52
*To: *gnucash-user@gnucash.org 
*Subject: *Re: [GNC] QFX file for Bank of American business account 
not invoking Import Matcher

Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized elements,
but that's the way it is.
Perhaps file a bug with libofx?

Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 

element "CARDNUM" undefined

(Above message occurred on Line 39, Column 14)
  X ERROR: startElement: incoming_data should be empty! You are
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 

element "CARDNAME" undefined

(Above message occurred on Line 40, Column 15)
  X ERROR: startElement: incoming_data should be empty! You are
probably using OpenSP <= 1.3.4.  The following data was lost: 9767
(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
element "MCC" undefined

On 5/4/22 8:38 AM, Peter Wu wrote:
> Hi David C,
>
> It is all new transactions.  If it is previously imported 
transaction, it would give a error dialog saying no new transaction.

>
> But for the given QFX, it just does nothing after you click okay to 
import the file.

>
> By the way, I am using the latest Mac OS on latest Gnucash version.
>
> Should I reply all with email or just reply to the mailing list?
>
> Best,
> Peter
>
> From: David Carlson 
> Date: Wednesday, May 4, 2022 at 08:30
> To: Peter Wu 
> Cc: stepbystepf...@comcast.net , Gnucash 
Users 
> Subject: Re: [GNC] QFX file for Bank of American business account 
not invoking Import Matcher
> If your file already contains a transaction that was previously 
imported with the same reference number, Gnucash does not import it again.

>
> On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
> Probably, but you do not explain what happens or doesn't happen when 
you click on "Import OFX/QFX"?  Are you able to see the filename and 
select it?  Is there an error message?

>
> On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:

> Quote:
> What is your reasoning to expect THAT (data intended for some sort 
of bookkeeping that is NOT double entry bookkeeping) to be correct 
data for gnucash

>
> For personal account checking or credit card. It is the same user 
flow, use the web connect for quicken 2018 or above download a qfx 
file and everything works fine.

>
> I would expect this biz credit to work too. They are from the same 
institution and UI flow is the same.

>
> Somehow the downloaded qfx won’t work. I attached the file in the 
first email.

>
> I used a diff checker to check personal qfx and biz credit card qfx. 
Inside the file, keys are different.

>
> Is it because how gnucash is parsing the file?
>
> Thanks,
> Peter
>
> Sent from my iPhone
>
>> On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
mailto:stepbystepf...@comcast.net>> wrote:

>>
>> What is your reasoning to expect THAT (data intended for some sort 
of bookkeeping that is NOT double entry bookkeeping) to be correct 
data for gnucash

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

Re: [GNC] Feature Request/Workaround Info: Preserve "Notes" Field?

2022-04-29 Thread Jean L

Again: the "append" check mark in the import dialog appends notes from 
the OFX to the notes you put in instead of replacing them if 'u+c' is 
selected.



On 4/29/2022 6:51 PM, Eric H. Bowen via gnucash-user wrote:

Gyle,

I do this when I remember, especially with regard to checks. But I've 
still had data overwritten later when I imported data, the import 
brought in data which I had already entered, and I neglected to go 
through the whole list and change everything to 'c'. I still think 
that a settings switch which preserves the 'Notes' field by default 
when importing data would be a worthwhile additionEric.


On 4/29/22 20:18, Gyle McCollam wrote:

Eric,
I know you probably tried this , but when you are importing Are you 
checking the "c" box and not the "u+c" box.  The "c" only clears, 
whereas the "u+c" UPDATES and clears.


Thank You,
*Gyle McCollam*

Gyle McCollam

609.680.2326Mobile

gmccol...@live.com email


*From:* gnucash-user 
 on behalf of Eric 
H. Bowen via gnucash-user 

*Sent:* Friday, April 29, 2022 8:09 PM
*To:* gnucash-user@gnucash.org 
*Subject:* [GNC] Feature Request/Workaround Info: Preserve "Notes" 
Field?

There is an issue which has been bugging me for some time with regard to
OFX/QFX imports: At least from my credit cards/financial institution,
when data is imported it overwrites the existing data in both the
"Description" and the "Notes" field...and, nine times out of ten, the
QFX "Notes" field is essentially a rehash of the "Description" field.

I like to leave transaction identification information in the "Notes"
field so that months later (Tax time!) I can recall the exact purpose of
a purchase without having to do a search through my email logs or PayPal
transactions in order to identify what that eBay purchase was actually
for. But at present any information I put there gets overwritten unless
I remember to manually re-enter it after the transaction clears when I
do an import from my financial institution.

I'd like to have a switch somewhere in "Settings" where you could
customize the QFX (and possibly QIF, although I don't use that much)
import so that if the Notes field is non-blank it does not get
overwritten by the imported data. Perhaps there already is such a switch
and I've just missed it; if so could someone enlighten me? Otherwise I'd
like to make this a formal feature request; how do I go about doing 
that?


Eric H. Bowen


___
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] Feature Request/Workaround Info: Preserve "Notes" Field?

2022-04-29 Thread Jean L

There's check box "append" in the import  dialog that does what you're 
asking for...

J.


On 4/29/2022 6:18 PM, Gyle McCollam wrote:

Eric,
I know you probably tried this , but when you are importing Are you checking the "c" box and not the 
"u+c" box.  The "c" only clears, whereas the "u+c" UPDATES and clears.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on behalf of 
Eric H. Bowen via gnucash-user 
Sent: Friday, April 29, 2022 8:09 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Feature Request/Workaround Info: Preserve "Notes" Field?

There is an issue which has been bugging me for some time with regard to
OFX/QFX imports: At least from my credit cards/financial institution,
when data is imported it overwrites the existing data in both the
"Description" and the "Notes" field...and, nine times out of ten, the
QFX "Notes" field is essentially a rehash of the "Description" field.

I like to leave transaction identification information in the "Notes"
field so that months later (Tax time!) I can recall the exact purpose of
a purchase without having to do a search through my email logs or PayPal
transactions in order to identify what that eBay purchase was actually
for. But at present any information I put there gets overwritten unless
I remember to manually re-enter it after the transaction clears when I
do an import from my financial institution.

I'd like to have a switch somewhere in "Settings" where you could
customize the QFX (and possibly QIF, although I don't use that much)
import so that if the Notes field is non-blank it does not get
overwritten by the imported data. Perhaps there already is such a switch
and I've just missed it; if so could someone enlighten me? Otherwise I'd
like to make this a formal feature request; how do I go about doing that?

Eric H. Bowen


___
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] Transaction Date issues during import OFX file (TD Bank)

2022-01-13 Thread Jean L

I'm a bit confused by this discussion. Is there a consensus as to 
whether the bug is located in libofx, or whether libofx is passing on 
the right info, and GC is misinterpreting it?


Jean


On 1/13/2022 8:41 PM, David Carlson wrote:

I have kept copies of OFX exports from several FI's for my personal data
for several years.  I could make a few of them available for testing if
needed.  They are from several different US banks, credit union, or credit
card companies.

I quoted the October 16 2020 edition of the OFX standard in
https://bugs.gnucash.org/show_bug.cgi?id=798418 which surprisingly states
that the datetime elements that libofx uses are expressed in FI local time
rather than Universal time and the burden is on the client software to
determine dates in the user's perspective.

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.


___
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 import QIF issue

2022-01-10 Thread Jean L


Also, can you tell us which version you're using, and which OS?


On 1/10/2022 4:21 AM, subscr...@nock.org.uk wrote:

I am trying to import a QIF file from Quicken XG 2004 for the UK.

  


Loading the file etc seems to be fine and I can get through all the option
windows.   It.

  


The import starts OK and gets about half way (having taken many minutes as
the QIF file is 11MB with transactions back decades) and then just closes
leaving no Gnucash window.

  


Restarting Gnucash just takes me back to the beginning option to import a
file etc.

  


Have tried twice and both times with same result though I have not actually
seen the moment the window closes.

  


Any ideas?  What can I do to work out what the problem is?

  


Thanks a lot,

  


Bob

___
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] Gnucash import QIF issue

2022-01-10 Thread Jean L


Can you do a bit of debugging?
https://wiki.gnucash.org/wiki/Stack_Trace
https://wiki.gnucash.org/wiki/Tracefile
That way we can get a chance to see where the crash happens. Another 
option is to send your qif file to one of us for us to repro the issue, 
but that's probably not something you want to do for privacy reasons.


Jean


On 1/10/2022 4:21 AM, subscr...@nock.org.uk wrote:

I am trying to import a QIF file from Quicken XG 2004 for the UK.

  


Loading the file etc seems to be fine and I can get through all the option
windows.   It.

  


The import starts OK and gets about half way (having taken many minutes as
the QIF file is 11MB with transactions back decades) and then just closes
leaving no Gnucash window.

  


Restarting Gnucash just takes me back to the beginning option to import a
file etc.

  


Have tried twice and both times with same result though I have not actually
seen the moment the window closes.

  


Any ideas?  What can I do to work out what the problem is?

  


Thanks a lot,

  


Bob

___
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] Incorrect QFX Import

2021-12-29 Thread Jean L

OK, that would have been too easy :D... Any chance you could send me the 
OFX? Remove anything that's private in it if you want. I'll debug on my 
end. If you get a chance, open a bug, and put the file there, otherwise 
send it to me directly...

Thanks!

Jean

On 12/29/2021 7:58 PM, Steve Cohen wrote:

There do not appear to be any duplicate FITIDs here.

I ran the command

grep FITID downloaded.QFX | sort > fitid.txt

and could easily see that there were no duplicates in the 136 entries 
in the file. The bank (Chase) appears to assign FITIDs of the form 
mmDD# where # is a consecutive number from 0-9.  What it would do 
if there were more than 10 entries isn't clear to me but that 
eventuality did not occur in this file which has only 136 entries over 
a year.

On Wed, Dec 29, 2021 at 4:18 PM Jean Laroche > wrote:

GC will not import an ofx transaction it thinks it already has
imported.
To determine whether a transaction has been imported GC looks at the
FITID. So if two transactions in your OFX file have the same
FITID, the
second one won't be imported.

Can you check that the transactions that are missing don't have
the same
FITID as some of the transactions that were imported?
Some banks are not good at assigning unique FITID to transactions,
and
that can cause a problem for GC.
Jean

On 12/29/21 2:13 PM, Steve Cohen wrote:
> Additionally, I tried exiting GnuCash and trying the import
again.  This
> made no difference.
>
> On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen mailto:stevec...@gmail.com>> wrote:
>
>> I downloaded all of 2021's transactions from my bank in QFX
format and
>> tried to import the file.
>>
>> As I was doing so, I noticed an anomaly.  I receive monthly direct
>> deposits from a pension, all arrive on or shortly after the
first of each
>> month, the same amount every month. But on the QFX import
screen, only 5 of
>> the months showed the deposit,
>> for January, May, August, September and December. The other
seven months
>> were not on the import screen. I tried sorting by date, by
amount, by
>> description - they aren't there.
>>
>> In an attempt to learn what was going on, I first checked my bank
>> statements.  Was the pension not being deposited? No, that
wasn't it, the
>> deposits came in every month as they were supposed to. I then
opened the
>> QFX file in a text editor to see if the deposits were listed in
the QFX.
>> They all were.  So I am trying to understand if there's a bug
in the import
>> function that would throw these transactions away.
>>
>> Here are the QFX entries from December and November. Perhaps
someone
>> looking at them can tell me why the first one was accepted and
the second
>> not? I see no important difference.
>>
>> 
>> CREDIT
>> 2021120112[0:GMT]
>> 1772.79
>> 202112010
>> COOK COUNTY PENS PENSIONS
>> PPD ID: 3660023021
>> 
>>
>> 
>> CREDIT
>> 2021110112[0:GMT]
>> 1772.79
>> 202111010
>> COOK COUNTY PENS PENSIONS
>> PPD ID: 3660023021
>> 
>>
> ___
> 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] Incorrect QFX Import

2021-12-29 Thread Jean L

There a debug flag you can enable to have info printed out when 
transactions are skipped, but I don't remember off the top of my head 
which flag that is.

On 12/29/2021 3:42 PM, Christopher Lam wrote:

It would be nice to have visibility of these imported transactions? 
Checkbox at the bottom would reveal them, all grayed out, and clicky 
link to the matched split in the register?

*From: *Jean Laroche 
*Sent: *Thursday, 30 December 2021 6:18 AM
*To: *gnucash-user@gnucash.org 
*Subject: *Re: [GNC] Incorrect QFX Import

GC will not import an ofx transaction it thinks it already has imported.

To determine whether a transaction has been imported GC looks at the

FITID. So if two transactions in your OFX file have the same FITID, the

second one won't be imported.

Can you check that the transactions that are missing don't have the same

FITID as some of the transactions that were imported?

Some banks are not good at assigning unique FITID to transactions, and

that can cause a problem for GC.

Jean

On 12/29/21 2:13 PM, Steve Cohen wrote:

> Additionally, I tried exiting GnuCash and trying the import again.  This

> made no difference.

>

> On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:

>

>> I downloaded all of 2021's transactions from my bank in QFX format and

>> tried to import the file.

>>

>> As I was doing so, I noticed an anomaly.  I receive monthly direct

>> deposits from a pension, all arrive on or shortly after the first 
of each

>> month, the same amount every month. But on the QFX import screen, 
only 5 of

>> the months showed the deposit,

>> for January, May, August, September and December.  The other seven 
months

>> were not on the import screen. I tried sorting by date, by amount, by

>> description - they aren't there.

>>

>> In an attempt to learn what was going on, I first checked my bank

>> statements.  Was the pension not being deposited?  No, that wasn't 
it, the

>> deposits came in every month as they were supposed to. I then 
opened the

>> QFX file in a text editor to see if the deposits were listed in the 
QFX.

>> They all were.  So I am trying to understand if there's a bug in 
the import

>> function that would throw these transactions away.

>>

>> Here are the QFX entries from December and November. Perhaps someone

>> looking at them can tell me why the first one was accepted and the 
second

>> not? I see no important difference.

>>

>> 

>> CREDIT

>> 2021120112[0:GMT]

>> 1772.79

>> 202112010

>> COOK COUNTY PENS PENSIONS

>> PPD ID: 3660023021

>> 

>>

>> 

>> CREDIT

>> 2021110112[0:GMT]

>> 1772.79

>> 202111010

>> COOK COUNTY PENS PENSIONS

>> PPD ID: 3660023021

>> 

>>

> ___

> 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] QFX Import in 4.8

2021-11-21 Thread Jean L


Good to hear!


On 11/21/2021 8:57 PM, Mike Alexander wrote:
I merged your branch into my copy of GnuCash and it seems to work 
fine.  I didn't try anything exotic, but it handled my TIAA QFX file 
fine (and with only one confirmation dialog).  Thanks for fixing it.


Mike

On 21 Nov 2021, at 22:17, Jean L wrote:


Apparently not merged yet, sorry

https://github.com/Gnucash/gnucash/pull/1167

I have no control over what gets merged when, hopefully soon?
In the meatime you can get that branch, rebase on main if needs be, 
and test...



On 11/21/2021 7:07 PM, Mike Alexander wrote:

On 21 Nov 2021, at 14:45, Jean L wrote:


This should be fixed in the next release. The code is already in.


In where?  I just rebuilt from commit 3f758ff2 which was the end of 
the Maint branch around 7PM EST tonight and when I imported my 
wife's TIAA changes I had to click OK over 20 times.  The last 
change to  gnc-ofx-import.c is in commit 81b48ee on Oct. 3.


Mike


___
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] QFX Import in 4.8

2021-11-21 Thread Jean L


Apparently not merged yet, sorry

https://github.com/Gnucash/gnucash/pull/1167

I have no control over what gets merged when, hopefully soon?
In the meatime you can get that branch, rebase on main if needs be, and 
test...



On 11/21/2021 7:07 PM, Mike Alexander wrote:

On 21 Nov 2021, at 14:45, Jean L wrote:


This should be fixed in the next release. The code is already in.


In where?  I just rebuilt from commit 3f758ff2 which was the end of 
the Maint branch around 7PM EST tonight and when I imported my wife's 
TIAA changes I had to click OK over 20 times.  The last change to  
gnc-ofx-import.c is in commit 81b48ee on Oct. 3.


Mike


___
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] QFX Import in 4.8

2021-11-21 Thread Jean L


This should be fixed in the next release. The code is already in.
Thanks for your patience.

To answer your question. Some ofx files have transfer between two 
accounts (at the same bank) which show up as two transactions that are 
the two ends of the transfer. GC used to then import them as separate 
transactions, not recognizing that they were a single transaction.


Jean


On 11/20/2021 10:21 PM, Mike Alexander wrote:
Have you thought about this any more?  I have the same issue with TIAA 
and it's annoying.  I gather this is a side effect of commit 248a850. 
I can see how this change could cause the behavior we're seeing, but 
I'm not sure what it is trying to fix.  The comment says "Add code to 
handle ofx files that include transfers between accounts."  What does 
this mean?  Two accounts in the OFX file? All transactions involve 
transfers between accounts.  Do you have any idea about how to fix the 
problem without breaking the original fix?


Mike

On 7 Oct 2021, at 13:32, Jean Laroche wrote:

No, there isn't such an option at this time. I agree that that's an 
annoying side effect of a change that was added for this version to 
fix an import bug.

I think I'll have to fix this.

Jean

On 10/7/21 10:11 AM, Dale Alspach wrote:

This is for the flatpak install of version 4.8 on linux mint.
I just downloaded transactions from TIAA and when I imported, I was
presented with a sequence of 16 screens (some containing only 1 
line) that

I had to OK. Each screen had transactions for a single security. I much
prefer getting a single screen with multiple lines as in earlier 
versions.

Is there an option somewhere to revert to the earlier behavior?
Dale
___
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] OFX Import with Investment Transactions

2021-10-05 Thread Jean L


Thanks! That's good news!
J.


On 10/5/2021 7:25 AM, Kalpesh Patel wrote:


I loaded up 4.8 version of GnuCash on another computer last night and 
imported one of the file that is most complex that had failed to 
import properly on 4.5 version of GnuCash. Good news is that where I 
was seeing 4.5 failing to import all transactions appears to be fixed 
in 4.8 and loaded all transactions properly. I imported same file in 
both, version 4.4 where it is known to work correctly, and in 4.8 and 
they both give the same end results after importing them into a clean 
new files. I will test out two more files which are not as complex as 
the one that is already tried one. Only case I am not able to test is 
the one with multiple accounts in the same ofx file where it is part 
of the same session. I will be testing multiple ofx files concatenated 
into a single file and import it in to see the end results. I’ll 
report back.


*From:*Roger Moore 
*Sent:* Sunday, October 03, 2021 11:50 PM
*To:* john 
*Cc:* Robin Chattopadhyay ; Kalpesh Patel 
; Gnucash Users 

*Subject:* Re: [GNC] OFX Import with Investment Transactions

There was indeed a bug so I opened 
https://bugs.gnucash.org/show_bug.cgi?id=798327 and created a PR with 
a simple fix.


I verified that on the file that Robin provided the import continues 
as expected for all 11 securities.


On Sun, Oct 3, 2021 at 2:21 PM john > wrote:


That sounds like https://bugs.gnucash.org/show_bug.cgi?id=798208
, which is fixed
in GnuCash 4.8.

Regards,
John Ralls


> On Oct 3, 2021, at 9:19 AM, Robin Chattopadhyay
mailto:robinra...@gmail.com>> wrote:
>
> Yes, I'm familiar with that issue as well as my spouse's 401K
OFX has fee
> transactions where shares are sold to pay plan expenses, but those
> transactions appear only as cash withdrawals and the sale
transactions do
> not get imported.
>
> That one doesn't bother me as much because it's one transaction
per month
> vs 9 every two weeks.
>
> On Sun, Oct 3, 2021 at 11:04 AM Kalpesh Patel
mailto:kalpesh.pa...@usa.net>> wrote:
>
>> The issues that you are seeing I believe has to do with changes
that OFX
>> introduced in libofx which has been included since 4.5 and
above version of
>> GnuCash. FWIW, I am running on Windows 10 Pro desktop but that
likely
>> doesn't matter when it comes to core functionality.
>>
>> I also had problems where some of transactions would not get
imported in
>> from an OFX file and these transactions I deduced from trial
and error are
>> specifically if they are related to deposit and withdrawal of
cash in Stock
>> or Mutual Fund account. I am not sure if this is the behavior
on your end
>> or
>> not but it sounds like it. This might be because libofx author
may have
>> changed philosophy and its implementation where cash in and out
are not
>> considered investment transactions such as buy and sell of a
stock, bond,
>> mutual fund, etc.
>>
>> Because of that I have stayed at GnuCash 4.4 (specifically
Build ID:
>> 4.4+(2020-12-28) for Windows) which I have known to properly import
>> brokerage created OFX files for import. I've reached out to the
author of
>> libofx for understanding and I am still waiting to hear back
from them.
>>
>> It may be worth a shot to install that version and see if it
imports OFX
>> correctly. If you have a blank file then it should ask for
appropriate
>> input
>> via dialogue box such as creation of "securities", corresponding
>> "brokerage"
>> account, etc. You can then go back and edit those "security"
and enable
>> download of prices using Finance::Quote Perl module with
yahoo_jason as the
>> source for it if you want to automate it.
>>
>> For FWIW, GnuCash 4.5 on windows used to crash when 'Actions'
--> 'Check &
>> Repair' --> 'Check & Repair All' would be selected to run which
I do now
>> and
>> then to make sure that my xml based file is in good shape (this
is carry
>> over habit from Quicken as it was known to corrupt files).
>>
>> This may not be the answer you are looking for but hope this
helps a bit.
>>
>> Kalpesh...
>>
>> --
>>
>> Message: 2
>> Date: Sat, 2 Oct 2021 10:58:44 -0500
>> From: Robin Chattopadhyay mailto:robinra...@gmail.com>>
>> To: Gnucash Users mailto:gnucash-user@gnucash.org>>
>> Subject: [GNC] OFX Import with Investment Transactions
>> Message-ID:
>>        > 7jjed1oqxw_jpqssxjx...@mail.gmail.com
>
>> Content-Type: text/plain; charset="UTF-8"
>>
>> Ubuntu 20.04 LTS (VMWare virtual machine in case that matters)
Gnucas

Re: [GNC] OFX Import with Investment Transactions

2021-10-03 Thread Jean L

Kalpesh, if you could give me samples of OFX files that do not work with 
the current code, I'd be happy to fix the issues. I've been working on 
the OFX import (not the libofx, but GC part of it) and it's quite 
possible that some of the issues that you're seeing are caused by GC, 
and not changes to libofx...

Jean


On 10/3/2021 9:43 AM, Kalpesh Patel wrote:

I believe your issue falls in the part of those libofx changes that were made. 
Are those nine transactions versus one in the same account or different account 
in same file?

  


There are multiple way to hash this and thus finding the issue: singe account 
or multiple accounts in same ofx file (even how they are constructed matters – 
similar to two fully ofx files concat’ed together version versus one session 
with two accounts in one file) –by- cash only transactions, cash and security 
transactions or security transactions only -by-  security/mutual fund account 
or non-security/non-mutual fund account. From what I can tell various combos of 
these fails to work properly, sadly. I didn’t keep the list of use cases 
validated around but I just fell back to earlier version (4.4) that has been 
working fine so far for all those use cases.

  


From: Robin Chattopadhyay 
Sent: Sunday, October 03, 2021 12:19 PM
To: Kalpesh Patel 
Cc: Gnucash Users 
Subject: Re: [GNC] OFX Import with Investment Transactions

  


Yes, I'm familiar with that issue as well as my spouse's 401K OFX has fee 
transactions where shares are sold to pay plan expenses, but those transactions 
appear only as cash withdrawals and the sale transactions do not get imported.

  


That one doesn't bother me as much because it's one transaction per month vs 9 
every two weeks.

  


On Sun, Oct 3, 2021 at 11:04 AM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

The issues that you are seeing I believe has to do with changes that OFX
introduced in libofx which has been included since 4.5 and above version of
GnuCash. FWIW, I am running on Windows 10 Pro desktop but that likely
doesn't matter when it comes to core functionality.

I also had problems where some of transactions would not get imported in
from an OFX file and these transactions I deduced from trial and error are
specifically if they are related to deposit and withdrawal of cash in Stock
or Mutual Fund account. I am not sure if this is the behavior on your end or
not but it sounds like it. This might be because libofx author may have
changed philosophy and its implementation where cash in and out are not
considered investment transactions such as buy and sell of a stock, bond,
mutual fund, etc.

Because of that I have stayed at GnuCash 4.4 (specifically Build ID:
4.4+(2020-12-28) for Windows) which I have known to properly import
brokerage created OFX files for import. I've reached out to the author of
libofx for understanding and I am still waiting to hear back from them.

It may be worth a shot to install that version and see if it imports OFX
correctly. If you have a blank file then it should ask for appropriate input
via dialogue box such as creation of "securities", corresponding "brokerage"
account, etc. You can then go back and edit those "security" and enable
download of prices using Finance::Quote Perl module with yahoo_jason as the
source for it if you want to automate it.

For FWIW, GnuCash 4.5 on windows used to crash when 'Actions' --> 'Check &
Repair' --> 'Check & Repair All' would be selected to run which I do now and
then to make sure that my xml based file is in good shape (this is carry
over habit from Quicken as it was known to corrupt files).

This may not be the answer you are looking for but hope this helps a bit.

Kalpesh...

--

Message: 2
Date: Sat, 2 Oct 2021 10:58:44 -0500
From: Robin Chattopadhyay mailto:robinra...@gmail.com> >
To: Gnucash Users mailto:gnucash-user@gnucash.org> >
Subject: [GNC] OFX Import with Investment Transactions
Message-ID:
 mailto:7jjed1oqxw_jpqssxjx...@mail.gmail.com> >
Content-Type: text/plain; charset="UTF-8"

Ubuntu 20.04 LTS (VMWare virtual machine in case that matters) Gnucash 4.8
libofx 0.9.15

I tried importing an OFX file from my 401K provider this morning and I got a
message box that said it had imported 2 transactions for a single security
in the file and there were no additional transactions to process.
This was incorrect as there were 18 new transactions across nine securities
(along with a number of other transactions that had already been imported
previously).

I tried a number of things to resolve (after taking a backup, of course):
1 - Tools > Import Map Editor and deleted all of the associations for this
file. When I re-imported, I was prompted to map each security in the file to
the correct account. No issues there. But when importing the OFX file again,
I had the same experience as described above
2 - Created a blank file and attempted to import the file there. Through the
import process, I created new securi

Re: [GNC] OFX Import with Investment Transactions

2021-10-02 Thread Jean L


Thanks Robin!
Good detective work here, and thanks for the examples, I think there 
must be a bug :( . I'll take a look.



If -- after importing the OFX file -- you open one of the account
registers, you'll see duplicate transactions! Although, if you close and
re-open the file, those duplicated transactions do not appear when you
re-open the account register. I don't know what to make of that.


That is super weird :(
Jean

On 10/2/2021 5:19 PM, Robin Chattopadhyay wrote:

Hi Jean-

I understand the logic for #1 and have no concerns about that.

As for #2, I did continue past the first matching dialog and there were no
additional dialogs, the focus returned to the account list.

There are definitely FITIDs that are already in the database that are also
in the most recent OFX file. This is because the provider doesn't allow you
to specify a date range, only 'current quarter' or 'some other quarter'.

I tried something else to research...

Using 4.8, I created a blank file and then imported an OFX file from Sep.
25, 2021. This file had 66 transactions and imported as expected with one
matcher screen per security/account as you indicated would happen. I then
attempted to import the OFX file from Oct. 2. This file has 84 transactions
-- the same 66 transactions from the Sep. 25 file plus 18 new transactions
dated 9/24.

The program then presents the dialog for the first account. There are two
transactions in the most recent file for this account; however they're
already in the database, thus triggering the message "OFX file
/home/robin/Downloads.qfx' imported transactions for account 'xxx' 2
transactions processed, no transactions to match". That makes sense as
those are older transactions that are already in the database. I clicked
'Close' for that dialog and then the focus returns to the main application.
It's almost as if the program -- having determined that there were no new
transactions to import into the first account -- decided not to look at the
subsequent accounts.

In service to the greater good, I am attaching the test file I created and
the Oct. 2 OFX file. I have removed all of the position data (there are
limits to what I'm willing to share :-) ), but that will not negatively
affect the import process.

Something else that I just noticed...

If -- after importing the OFX file -- you open one of the account
registers, you'll see duplicate transactions! Although, if you close and
re-open the file, those duplicated transactions do not appear when you
re-open the account register. I don't know what to make of that.

On Sat, Oct 2, 2021 at 1:52 PM Jean L  wrote:

Yes, there's a new behavior with OFX import. The match dialog shows up
for each target account, so if you're importing securities the dialog
will show up for each security. This could be a real annoyance if there
are many different securities, so we may want to change that behavior.
The new behavior was introduced to fix an issue when a single OFX file
had transfers between accounts.

I see two issues here:
1) The fact that the match dialog runs for each target account (see
comment above)
2) The fact that some of your imported transactions were simply ignored.

About 2): Did you try to continue with the import after the first
matching dialog? Did it then go to the next securities? Or did you just
abort thinking something was wrong (not expecting the new behavior of
seeing the matching dialog for each security instead of all together as
before)

If that was not the case (i.e., you tried continuing but nothing else
happened) one reason why this could happen is if the FITID used for the
imported transactions were already present in the target account. This
is new in the latest version: transactions that were previously imported
are no longer shown the matching dialog. In your case this seems
erroneous. So either it's a bug (i.e., the FITID of the imported
transactions are NOT found in any of the transactions of the account
you're imported into, so they should show) or it's a problem with the
OFX data that the transactions seem to reuse existing FITIDs.
The fact that things work normally when you import into a blank account
would indicate that indeed, the FITID of the imported transactions
already exist in your target account.

SO, could you re-try importing with the latest version, but making sure
you continue clicking OK for each match dialog? Does this work or not?
If not, then we'll need to check whether the FITID of the new imported
transactions somehow have been used before in the previously imported
transactions. To see that, you'd need to pick one that was not imported
(looking at the OFX file), get its FITID, and see in your account
database (save it as an xml file so it can be looked at with a regular
editor) whether that FITID exists.

Jean

On 10/2/2021 8:58 AM, Robin Chattopadhyay wrote:

Ubuntu

Re: [GNC] OFX Import with Investment Transactions

2021-10-02 Thread Jean L

Yes, there's a new behavior with OFX import. The match dialog shows up 
for each target account, so if you're importing securities the dialog 
will show up for each security. This could be a real annoyance if there 
are many different securities, so we may want to change that behavior. 
The new behavior was introduced to fix an issue when a single OFX file 
had transfers between accounts.


I see two issues here:
1) The fact that the match dialog runs for each target account (see 
comment above)

2) The fact that some of your imported transactions were simply ignored.

About 2): Did you try to continue with the import after the first 
matching dialog? Did it then go to the next securities? Or did you just 
abort thinking something was wrong (not expecting the new behavior of 
seeing the matching dialog for each security instead of all together as 
before)


If that was not the case (i.e., you tried continuing but nothing else 
happened) one reason why this could happen is if the FITID used for the 
imported transactions were already present in the target account. This 
is new in the latest version: transactions that were previously imported 
are no longer shown the matching dialog. In your case this seems 
erroneous. So either it's a bug (i.e., the FITID of the imported 
transactions are NOT found in any of the transactions of the account 
you're imported into, so they should show) or it's a problem with the 
OFX data that the transactions seem to reuse existing FITIDs.
The fact that things work normally when you import into a blank account 
would indicate that indeed, the FITID of the imported transactions 
already exist in your target account.


SO, could you re-try importing with the latest version, but making sure 
you continue clicking OK for each match dialog? Does this work or not?
If not, then we'll need to check whether the FITID of the new imported 
transactions somehow have been used before in the previously imported 
transactions. To see that, you'd need to pick one that was not imported 
(looking at the OFX file), get its FITID, and see in your account 
database (save it as an xml file so it can be looked at with a regular 
editor) whether that FITID exists.


Jean

On 10/2/2021 8:58 AM, Robin Chattopadhyay wrote:

Ubuntu 20.04 LTS (VMWare virtual machine in case that matters)
Gnucash 4.8
libofx 0.9.15

I tried importing an OFX file from my 401K provider this morning and I got
a message box that said it had imported 2 transactions for a single
security in the file and there were no additional transactions to process.
This was incorrect as there were 18 new transactions across nine securities
(along with a number of other transactions that had already been imported
previously).

I tried a number of things to resolve (after taking a backup, of course):
1 - Tools > Import Map Editor and deleted all of the associations for this
file. When I re-imported, I was prompted to map each security in the file
to the correct account. No issues there. But when importing the OFX file
again, I had the same experience as described above
2 - Created a blank file and attempted to import the file there. Through
the import process, I created new securities and new accounts, nothing
unexpected there. Then the generic transaction importer dialog popped up,
but with just the two transactions for the same security cited in the
original problem dialog. I imported those, clicked OK and then the generic
transaction importer dialog came up *again* but only with transactions for
a single, different security. I imported those and repeated the process for
each security with transactions in the file. Each time the generic
transaction importer dialog came up, it only had transactions for a single
security. This is definitely new behavior that I didn't see in 4.6.
Previously the import dialog had all the new transactions in the file
3 - Reverted to 4.7. Crashed when selecting Import from the File menu
(Trace/breakpoint trap (core dumped). Not unexpected, but thought I would
try anyway.
4 - Reverted to 4.6. This works as it used to with all the new transactions
in a single dialog

Finally, I don't know if this matters, but I scanned stdout from the
build/make/install process to see if anything looked obviously wrong and I
found this (I don't know if it's relevant):

-- Performing Test HAVE_OFX_BUG_39
-- Performing Test HAVE_OFX_BUG_39 - Failed

Thanks,
Robin
___
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

Re: [GNC] Problems setting up first OFX transaction download

2021-09-29 Thread Jean L

I'm exactly in the same boat. Online banking does not work for my banks, 
so I download ofx by hand and import into GC. Not ideal, but it works.


J.


On 9/29/2021 3:53 PM, David Carlson wrote:

David,

There are multiple ways to skin that cat, and it is not clear which one you
are asking about.

Quicken has an online banking type of feature which Gnucash can sometimes
emulate,  and sometimes not.  In Gnucash it is called online banking.

There is also a manual transaction download feature which works well with
many banks using a file format called QFX or OFX.  That requires manually
going to the bank's website and manually selecting a transaction download
in the OFX or QFX format if available,  saving it locally then importing it
into your data file.  Some banks only offer CSV or other formats.

I personally haven't been able to get the first way to work with any of the
banks that I use, so I use second method.  I would not be able to help you
with online banking.

On Wed, Sep 29, 2021, 5:22 PM Steve Welch via gnucash-user <
gnucash-user@gnucash.org> wrote:


I’ll be following this with interest — I just moved from Moneydance and am
trying to set up credit card transaction downloads from Citi.
No problems doing so in MD, but I haven’t been successful yet in GnuCash.

I’m sure there’s something I’m not understanding here…

Steve


On Sep 29, 2021, at 4:25 PM, David Ellis 

wrote:

I have been using Quicken for home and business for years to keep my one

man

office books. It does everything I need, especially auto-population of

bank

transactions in register for preparing financial statements. Now

converting

to GnuCash and used the wizard to a) import to gnu from Quicken data

file,

then b) set up OFX transaction download from bank directly to gnu. Got

data

import great, but efforts to get OFX duds. I am a retired dba so I kind

of

know what I'm doing, but didn't help much. I called the bank and worked

with

a tech person there but a detailed review of each item in the wizard

didn't

get anywhere with her either. I kept getting the error that there were no
new transactions to download since the last one, which was 3 weeks and 29
transactions ago. Am I going to just have to download CSV monthly and

import

to gnu or can I actually get OFX to work?  Thanks, 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.

___
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] Changing multiple transactions

2021-01-31 Thread Jean L

Note: as a dev I have (and probably many before me) tried to look at 
what it would take allow selecting multiple transactions at the same 
time and then do an operation. Sadly, there's no quick fix to GC that 
could make this happen, it's a large re-write apparently. One dev looked 
(is looking?) into changing the main register code to allow 
multi-transaction edits (among other things) but I haven't heard of any 
recent progress...


J.


On 1/31/2021 4:17 PM, Jeff Rizzo wrote:

On 1/31/21 2:30 PM, Stephen M. Butler wrote:


On 1/31/21 12:26 PM, Jeff Rizzo wrote:

On 1/31/21 12:05 PM, Stephen M. Butler wrote:


PPS  Backups are mandatory.



Yeah, they will be, once I get enough useful data in there that I 
don't keep starting over from scratch.  Since I sent out the 
original email, I've realized that it's any kind of bulk editing 
that will require this, and turns out, apparently I really like to 
change multiple things at once.  I'll give it a try and see if it's 
worth it.




Oh.  Starting over from scratch?  Just train the importer (you will 
have to do that anyway over time).  Don't let them go to the 
imbalance account in the first place.
If importing a CSV file, create an extra column that you call the 
transfer account (or something like that) and put your own strings in 
there for the different accounts.  During the import GnC will ask you 
for the real account name for each of those strings.  It will ask 
only once per string rather than each time it encounters that same 
string (as would be done if matching on something else).




Yeah, I'm still in the "evaluate whether this is going to work for me 
long-term" phase, so reimporting isn't TOO painful.  I will try to put 
what you've suggested here into action, though I'm currently puzzling 
a little about how to with an OFX source instead of CSV - it did ask 
me the real account name, but apparently only for one side of each 
transaction?  I'll dig.


Thanks for your help,

+j
___
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] Defining Keyboard shortcuts for Menu Functions

Re: [GNC] Online Banking

Re: [GNC] Importing data from QuickBooks Online

Re: [GNC] Using Plaid

Re: [GNC] OFX Requirements

Re: [GNC] OFX Requirements

Re: [GNC] OFX Requirements

Re: [GNC] OFX Requirements

Re: [GNC] Autofill on import OFX?

Re: [GNC] Autofill on import OFX?

Re: [GNC] Matching error in OFX import

Re: [GNC] Matching error in OFX import

Re: [GNC] OFX import date questions

Re: [GNC] OFX import date questions

Re: [GNC] Import is finding no matching transactions

Re: [GNC] Import is finding no matching transactions

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

Re: [GNC] Feature Request/Workaround Info: Preserve "Notes" Field?

Re: [GNC] Feature Request/Workaround Info: Preserve "Notes" Field?

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Re: [GNC] Gnucash import QIF issue

Re: [GNC] Gnucash import QIF issue

Re: [GNC] Incorrect QFX Import

Re: [GNC] Incorrect QFX Import

Re: [GNC] QFX Import in 4.8

Re: [GNC] QFX Import in 4.8

Re: [GNC] QFX Import in 4.8

Re: [GNC] OFX Import with Investment Transactions

Re: [GNC] OFX Import with Investment Transactions

Re: [GNC] OFX Import with Investment Transactions

Re: [GNC] OFX Import with Investment Transactions

Re: [GNC] Problems setting up first OFX transaction download

Re: [GNC] Changing multiple transactions

33 matches

Site Navigation

Mail list logo

Footer information