[GNC] OFX Requirements

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