Re: [GNC] GnuCash 5.0 Released

[Tim Rohrer]

I’ve been working over the past few months on a Python app to help users 
migrate from Quicken Mac, which will only export csv files. I’m using Piecash 
for writing the database.

As I look through this list of note/features, I’m not seeing anything that 
changes the the book’s sql file structure. 

Am I missing anything?

Thank you for your work! I look forward to downloading and experimenting.

Tim

> On Mar 26, 2023, at 16:13, John Ralls  wrote:
> 
> The GnuCash development team announces GnuCash 5.0.
> 
> New Features
> 
>A new Stock Transaction Assistant to guide you through entering most 
> investment transactions for stocks, bonds, and mutual funds. You can access 
> it from Actions>Stock Assistant when the focus tab is the Accounts page or a 
> Stock or Fund account register.
>A new Investment Lots report showing a graph of capital gains and losses 
> in a period by investment lot. Note that if you don't use the View Lots 
> dialog to manage capital gains and losses this report won't have anything to 
> show you. Use Reports>Assets & Liabilities>Investment Lots to see the report.
>The Online Quotes facility has been completely rewritten and the old 
> gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced with 
> finance-quote-wrapper. The functions performed by those programs may now be 
> accomplished by passing commands to gnucash-cli -Q, see gnucash-cli --help 
> for specifics. The perl module requirements have changed with the rewrite: 
> The new version doesn't need Date::Manip but needs JSON::Parse instead. 
> gnc-fq-update has been, er, updated to reflect that.
>A new tab on the New/Edit Account dialog called More Properties includes 
> entries to set a high and low limit on an account. That's coupled to a new 
> column that's available on the Accounts Page, Balance Limit. If you set a 
> high or low limit and the account balance falls above or below the respective 
> limit an indicator will be shown in the Balance Limit column.
>The description field quickfill in the register now displays a drop-down 
> list of possible completions instead of just one inline completion.
>File import menu items for the MT940, MT942, and DTAUS formats is replaced 
> with a single Import from AQBanking that supports importing any file format 
> supported by AQBanking, including the frequently requested CAMT. (Note that 
> some CAMT profiles are under the XML format.)
>The import matcher now permits editing descriptions, notes, and memo 
> fields in the matcher window before creating the transactions. Right-click 
> and select from the context menu.
>The report generated by the Print Invoice button on the Edit Invoice tab 
> can now be configured as a book option at the bottom of the Business tab; 
> this permits selecting a saved configuration of one of the standard invoice 
> reports. Another option enables a delay, during which a dialog box will 
> appear enabling the user to select a different report. Note: When saving a 
> configuration make sure that the invoice number is not set or you'll get that 
> particular invoice instead of the one that you pressed the button for.
> 
> Significant Code Changes
> Deprecations (will be removed in GnuCash 6.0)
> 
>_ (the alias for gettext. Use G_ instead)
>gnc:make-account-list-limited-option
>gnc:make-account-list-option
>gnc:make-account-sel-limited-option
>gnc:make-account-sel-option
>gnc:make-budget-option
>gnc:make-color-option
>gnc:make-commodity-option
>gnc:make-complex-boolean-option
>gnc:make-counter-format-option
>gnc:make-counter-option
>gnc:make-currency-option
>gnc:make-date-format-option
>gnc:make-font-option
>gnc:make-internal-option
>gnc:make-invoice-option
>gnc:make-list-option
>gnc:make-multichoice-callback-option
>gnc:make-multichoice-option
>gnc:make-number-plot-size-option
>gnc:make-number-range-option
>gnc:make-owner-option
>gnc:make-pixmap-option
>gnc:make-query-option
>gnc:make-radiobutton-option
>gnc:make-simple-boolean-option
>gnc:make-string-option
>gnc:make-taxtable-option
>gnc:make-text-option
>gnc:option-set-default-value
>gnc:option-set-value
>gnc:option-setter
>gnc:option-value
>gnc:register-option
>The invoice option to gnc:register-report-create-internal
> 
> Report and Book Options
> 
>This major change will affect everyone who has written custom reports in 
> Guile Scheme.
>The report and book options code has been completely rewritten in C++ with 
> SWIG providing Guile Scheme access for reports. The new design requires 
> directly registering options with for example 
> gnc-optiondb-register-string-option instead of calling gnc:make-string-option 
> to create an option followed by gnc:register-option to insert it in the 
> report's options.
>Value access is also changed: Instead of retrieving an option and then 
> querying or 

Re: [GNC] Account Types -- what are the implications of getting them wrong?

[Tim Rohrer]

Thank you David.

Would it be correct for me to assume that *any* account type can be edited 
prior to the addition of any data?

Either way, it sounds like this can be an iterative process to an extent. And 
that most negative consequences can be reversed with a little creativity.

Tim

> On Feb 20, 2023, at 20:56, David Cousens  wrote:
> 
> Tim ,
> 
> In most cases if you get an account type wrong you can edit the account type 
> and
> its parent account from the account tree structure. There may be some
> limitations associated with the type of the parent account which may have to 
> be
> worked around. In the worst case scenario you can create an account of the
> correct type and then delete the account of the wrong type. If there are
> transactions to the account you are deleting the dialogue will ask which 
> account
> you wish them transferred to and here you specify the new account of the 
> correct
> type. Apart from the basic top level account types Asset, Liability, Equity,
> Income and Expenses there are a number of account sub-types which are usually
> tied to aspects of the business features, stock trading etc
> 
> David Cousens
> 
>> On Mon, 2023-02-20 at 19:25 -0600, m...@tgr66.me wrote:
>> Thanks Jim for the reply.
>> 
 On Feb 20, 2023, at 15:49, Jim DeLaHunt  wrote:
>>> 
>>> It sounds like you are trying to answer two questions:
>>> 
>>> 1. How do you extract meaning from account name strings in incoming
>>> migration data, such that you can pick the appropriate GnuCash account type?
>> 
>> Ummm, sort of. Yes, I am asking myself that because I have to make decisions.
>> But I was really providing the scenarios to help shape the reader's thinking
>> about the implications.
>> 
>> Yes, the question I’m asking is in the subject line. I should have included 
>> it
>> more in the body. I did ask specifically in the body though if there was "any
>> negative implications of assigning too general of an account type to an
>> account?” I’m inclined to err on the side of general and tell the user they
>> need to review all of them and edit appropriately based on GnuCash’s
>> documentation. But, it is still a good challenge to get them as close to 
>> right
>> as possible.  
>> 
>> The decisions I’m making are naturally heavily influenced by my personal
>> account and categories structure in Quicken along with my understanding about
>> how GnuCash structures accounts and defines types. There are undoubtedly
>> members of this mailing list who migrated data from some other app to 
>> GnuCash.
>> They made decisions about account types, perhaps after creating their chart 
>> of
>> accounts, and they may have found adjustments were necessary because 
>> something
>> didn’t work as expected. I believe hearing that would be helpful to me and
>> others. 
>> 
>>> 
>>> 2. What are the GnuCash account types, and what are their meanings (or,
>>> purposes, or semantics)?
>>> 
>>> I think question 1 is up to you. It is not a GnuCash question.
>>> 
>>> The place to start for question 2 is the GnuCash /Help/ documentation, 5.1.
>>> *Types of GnuCash Accounts*[1]. You might find it helpful to consult the
>>> notes about what kinds of child account type each parent account type
>>> accepts.  Missing from this page is the Trading Account type.
>>> 
>> 
>> I had read
>> https://code.gnucash.org/docs/MAINT/group__Account.html#ga398c5d6f7a5127db7b81789e05262908
>>  <
>> https://code.gnucash.org/docs/MAINT/group__Account.html#ga398c5d6f7a5127db7b81789e05262908
>>> but will make sure to go back and read section 5.1. I appreciate that you’ve
>> highlighted that there can be child-parent mismatches as that is a real
>> implication. I realize that if a user migrating to GnuCash using the tool I’m
>> developing had a Credit Card under an Asset account, they could potentially
>> have a problem. I’m using PieCash for my GnuCash writes, and I *think* it
>> checks the parent-child rules, but I might want to test that.
>> 
>> 
>>> Trading accounts are described in the GnuCash /Tutorial and Concepts Guide/,
>>> 12.3. *Automatically Recording Currency Transactions using Trading
>>> Accounts*[2], and at wiki page *Trading Accounts*[3].
>>> 
>>> You might have to resort to reading the GnuCash code[4] to answer more
>>> detailed questions. I remember doing this once to clear up some of my own
>>> questions.
>>> 
>>> Your subject: line asks, "what are the implications of getting [Account
>>> Types] wrong?" I don't see you asking that in your message body. But as far
>>> as I know, the implication can be unusability if you get the account type
>>> very wrong (e.g. an Asset type for what should be an Expense type account),
>>> or inconvenience if you get the account type a little wrong (e.g. no option
>>> to add an interest payment during the reconciliation process if you assign a
>>> Liability type for what should be a Credit type account). Note that users
>>> can, within limits, change account types for a book which is in use. 

Re: [GNC] Account Types -- what are the implications of getting them wrong?

[Tim Rohrer]

Hi Simon,

I appreciate that perspective. 

I have considered only only assigning only top level types, because if someone 
is importing 25 or 30 accounts (INCOME/EXPENSES types should be much easier for 
most users), going through and editing them isn’t that difficult.

But as I said earlier, the challenge of getting them right the first time is 
intriguing. :-)

Tim 

> On Feb 20, 2023, at 21:52, Simon Roberts  
> wrote:
> 
> FWIW, I have taken the perspective that if I don't know what
> category/account to put something in, I don't guess, I put it in
> "Unbalanced" and then ask someone who knows. As I understand it, there
> shouldn't be anything in that category, so it's a big red flag that you
> can't miss that this thing needs attention. Then at suitable intervals, you
> can ask your accountant, and learn. If you make a guess and get it wrong,
> there's no obvious way, other than a really thoughtful audit, questioning
> essentially everything, that will reliably catch all the erroneous guesses.
> 
> Just my two cents, of course, since I'm not an accountant either
> (presumably if I were, I'd not be suffering from these uncertainties!)
> 
> 
>> On Mon, Feb 20, 2023 at 7:55 PM David Cousens 
>> wrote:
>> 
>> Tim ,
>> 
>> In most cases if you get an account type wrong you can edit the account
>> type and
>> its parent account from the account tree structure. There may be some
>> limitations associated with the type of the parent account which may have
>> to be
>> worked around. In the worst case scenario you can create an account of the
>> correct type and then delete the account of the wrong type. If there are
>> transactions to the account you are deleting the dialogue will ask which
>> account
>> you wish them transferred to and here you specify the new account of the
>> correct
>> type. Apart from the basic top level account types Asset, Liability,
>> Equity,
>> Income and Expenses there are a number of account sub-types which are
>> usually
>> tied to aspects of the business features, stock trading etc
>> 
>> David Cousens
>> 
>>> On Mon, 2023-02-20 at 19:25 -0600, m...@tgr66.me wrote:
>>> Thanks Jim for the reply.
>>> 
 On Feb 20, 2023, at 15:49, Jim DeLaHunt  wrote:
 
 It sounds like you are trying to answer two questions:
 
 1. How do you extract meaning from account name strings in incoming
 migration data, such that you can pick the appropriate GnuCash account
>> type?
>>> 
>>> Ummm, sort of. Yes, I am asking myself that because I have to make
>> decisions.
>>> But I was really providing the scenarios to help shape the reader's
>> thinking
>>> about the implications.
>>> 
>>> Yes, the question I’m asking is in the subject line. I should have
>> included it
>>> more in the body. I did ask specifically in the body though if there was
>> "any
>>> negative implications of assigning too general of an account type to an
>>> account?” I’m inclined to err on the side of general and tell the user
>> they
>>> need to review all of them and edit appropriately based on GnuCash’s
>>> documentation. But, it is still a good challenge to get them as close to
>> right
>>> as possible.
>>> 
>>> The decisions I’m making are naturally heavily influenced by my personal
>>> account and categories structure in Quicken along with my understanding
>> about
>>> how GnuCash structures accounts and defines types. There are undoubtedly
>>> members of this mailing list who migrated data from some other app to
>> GnuCash.
>>> They made decisions about account types, perhaps after creating their
>> chart of
>>> accounts, and they may have found adjustments were necessary because
>> something
>>> didn’t work as expected. I believe hearing that would be helpful to me
>> and
>>> others.
>>> 
 
 2. What are the GnuCash account types, and what are their meanings (or,
 purposes, or semantics)?
 
 I think question 1 is up to you. It is not a GnuCash question.
 
 The place to start for question 2 is the GnuCash /Help/ documentation,
>> 5.1.
 *Types of GnuCash Accounts*[1]. You might find it helpful to consult
>> the
 notes about what kinds of child account type each parent account type
 accepts.  Missing from this page is the Trading Account type.
 
>>> 
>>> I had read
>>> 
>> https://code.gnucash.org/docs/MAINT/group__Account.html#ga398c5d6f7a5127db7b81789e05262908
>>> <
>>> 
>> https://code.gnucash.org/docs/MAINT/group__Account.html#ga398c5d6f7a5127db7b81789e05262908
 but will make sure to go back and read section 5.1. I appreciate that
>> you’ve
>>> highlighted that there can be child-parent mismatches as that is a real
>>> implication. I realize that if a user migrating to GnuCash using the
>> tool I’m
>>> developing had a Credit Card under an Asset account, they could
>> potentially
>>> have a problem. I’m using PieCash for my GnuCash writes, and I *think* it
>>> checks the parent-child rules, but I might want to test that.
>>> 
>>> 
 Trading accounts 

Re: [GNC] OFX Requirements

[Tim Rohrer]

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!TimJeanOn 1/7/2023 10:59 AM, Tim 
Rohrer wrote:Correct. And the errors and warnings I pasted earlier are
 logged.Linux GnuCash 4.11Build 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:OFXSGMLENCODING:UTF-80INFO20230107105800ENG0INFOUSDb9fc6ca936ba09958d5076dd5ebfac69384d7d0b77b259606be9c29de2e05b45CHECKING1970010120230107CREDIT2022010100500.00743df964dc21309d6d8a7c0ca5eaa657TimOn
 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.JeanOn 
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,Account1/1/2022,Tim,Income:Salary,500,Family
 CheckingUsing csv2ox with a custom mapper, I get an
 ofx with guts of the transaction like 
this:0INFOUSDb9fc6ca936ba09958d5076dd5ebfac69384d7d0b77b259606be9c29de2e05b45CHECKING1970010120230107CREDIT2022010100500.00743df964dc21309d6d8a7c0ca5eaa657TimBut
 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

Re: [GNC] OFX Requirements

[Tim Rohrer]

Correct. And the errors and warnings I pasted earlier are logged.Linux GnuCash 
4.11Build 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:OFXSGMLENCODING:UTF-80INFO20230107105800ENG0INFOUSDb9fc6ca936ba09958d5076dd5ebfac69384d7d0b77b259606be9c29de2e05b45CHECKING1970010120230107CREDIT2022010100500.00743df964dc21309d6d8a7c0ca5eaa657TimOn
 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.JeanOn 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,Account1/1/2022,Tim,Income:Salary,500,Family
 CheckingUsing csv2ox with a custom mapper, I get an ofx
 with guts of the transaction like 
this:0INFOUSDb9fc6ca936ba09958d5076dd5ebfac69384d7d0b77b259606be9c29de2e05b45CHECKING1970010120230107CREDIT2022010100500.00743df964dc21309d6d8a7c0ca5eaa657TimBut
 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 finishedI 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 
listgnucash-user@gnucash.orgTo 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 
listgnucash-user@gnucash.orgTo 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

[Tim Rohrer]

Thanks, Jean.Here is the entire file (attached and pasted). For testing, I was simply trying to get one transaction to work 
first.DATA:OFXSGMLENCODING:UTF-80INFO20230107105800ENG0INFOUSDb9fc6ca936ba09958d5076dd5ebfac69384d7d0b77b259606be9c29de2e05b45CHECKING1970010120230107CREDIT2022010100500.00743df964dc21309d6d8a7c0ca5eaa657TimOn
 Jan 7, 2023, at 12:41 PM, Jean L  wrote:Can you post a small OFX file that's generate
d that way? I'll take a quick look.JeanOn 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,Account1/1/2022,Tim,Income:Salary,500,Family CheckingUsing csv2ox with a custom mapper, I get an ofx with guts of the transaction like 
this:0INFOUSDb9fc6ca936ba09958d5076dd5ebfac69384d7d0b77b259606be9c29de2e05b45CHECKIN
G1970010120230107CREDIT2022010100500.00743df964dc21309d6d8a7c0ca5eaa657TimBut
 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 OfxDummyC
ontainer 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 
finishedI 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 
listgnucash-user@gnucash.orgTo update your subsc
ription 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 
listgnucash-user@gnucash.orgTo 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.

[GNC] OFX Requirements

[Tim Rohrer]

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

[GNC] OFX Requirements

[Tim Rohrer]

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 use https://github.com/reubano/csv2ofx to generate OFX files from exported csv. A dummy csv transaction:Date,Payee/Security,Category,Amount,Account1/1/2022,Tim,Income:Salary,500,Family CheckingUsing csv2ox with a custom mapper, I get an ofx with guts of the transaction like 
this:0INFOUSDb9fc6ca936ba09958d5076dd5ebfac69384d7d0b77b259606be9c29de2e05b45CHECKING1970010120230107CREDIT2022010100500.00743df964dc21309d6d8a7c0ca5eaa657TimBut
 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 finishedI 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.