[GNC] OFX Requirements

Sat Jan 7 15:32:39 EST 2023

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 <ripngo at gmail.com> 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
>>> <OFX>
>>> <SIGNONMSGSRSV1>
>>> <SONRS>
>>> <STATUS>
>>> <CODE>0</CODE>
>>> <SEVERITY>INFO</SEVERITY>
>>> </STATUS>
>>> <DTSERVER>20230107105800</DTSERVER>
>>> <LANGUAGE>ENG</LANGUAGE>
>>> </SONRS>
>>> </SIGNONMSGSRSV1>
>>> <BANKMSGSRSV1>
>>> <STMTTRNRS>
>>> <TRNUID></TRNUID>
>>> <STATUS>
>>> <CODE>0</CODE>
>>> <SEVERITY>INFO</SEVERITY>
>>> </STATUS>
>>> <STMTRS>
>>> <CURDEF>USD</CURDEF>
>>> <BANKACCTFROM>
>>> <BANKID>b9fc6ca936ba09958d5076dd5ebfac69</BANKID>
>>> <ACCTID>384d7d0b77b259606be9c29de2e05b45</ACCTID>
>>> <ACCTTYPE>CHECKING</ACCTTYPE>
>>> </BANKACCTFROM>
>>> <BANKTRANLIST>
>>> <DTSTART>19700101</DTSTART>
>>> <DTEND>20230107</DTEND>
>>> <STMTTRN>
>>> <TRNTYPE>CREDIT</TRNTYPE>
>>> <DTPOSTED>20220101000000</DTPOSTED>
>>> <TRNAMT>500.00</TRNAMT>
>>> <FITID>743df964dc21309d6d8a7c0ca5eaa657</FITID>
>>> <NAME>Tim</NAME>
>>> </STMTTRN>
>>> </BANKTRANLIST>
>>> </STMTRS>
>>> </STMTTRNRS>
>>> </BANKMSGSRSV1>
>>> </OFX>
>>>
>>>
>>>> On Jan 7, 2023, at 12:41 PM, Jean L <ripngo at gmail.com> 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:
>>>>>
>>>>> <STMTTRNRS>
>>>>> <TRNUID></TRNUID>
>>>>> <STATUS>
>>>>> <CODE>0</CODE>
>>>>> <SEVERITY>INFO</SEVERITY>
>>>>> </STATUS>
>>>>> <STMTRS>
>>>>> <CURDEF>USD</CURDEF>
>>>>> <BANKACCTFROM>
>>>>> <BANKID>b9fc6ca936ba09958d5076dd5ebfac69</BANKID>
>>>>> <ACCTID>384d7d0b77b259606be9c29de2e05b45</ACCTID>
>>>>> <ACCTTYPE>CHECKING</ACCTTYPE>
>>>>> </BANKACCTFROM>
>>>>> <BANKTRANLIST>
>>>>> <DTSTART>19700101</DTSTART>
>>>>> <DTEND>20230107</DTEND>
>>>>> <STMTTRN>
>>>>> <TRNTYPE>CREDIT</TRNTYPE>
>>>>> <DTPOSTED>20220101000000</DTPOSTED>
>>>>> <TRNAMT>500.00</TRNAMT>
>>>>> <FITID>743df964dc21309d6d8a7c0ca5eaa657</FITID>
>>>>> <NAME>Tim</NAME>
>>>>> </STMTTRN>
>>>>> </BANKTRANLIST>
>>>>> </STMTRS>
>>>>> </STMTTRNRS>
>>>>>
>>>>> 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 YYYYMMDDHHMMSS.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 YYYYMMDDHHMMSS.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 at 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 at 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.
>>>
>