Re: GnuCash OFX import not matching accounts of same ID

2013-09-16 Thread Derek Atkins
Hi, Ngewi Fet nge...@gmail.com writes: On Fri, Sep 13, 2013 at 3:15 PM, Derek Atkins warl...@mit.edu wrote: Hi, Ngewi Fet nge...@gmail.com writes: At the moment I am trying to export QIF from the Android app.  GnuCash keeps asking for a default account name to

Re: GnuCash OFX import not matching accounts of same ID

2013-09-15 Thread Ngewi Fet
On Fri, Sep 13, 2013 at 3:15 PM, Derek Atkins warl...@mit.edu wrote: Hi, Ngewi Fet nge...@gmail.com writes: At the moment I am trying to export QIF from the Android app. GnuCash keeps asking for a default account name to import into and says the QIF file does not specify an account

Re: GnuCash OFX import not matching accounts of same ID

2013-09-13 Thread Derek Atkins
Hi, Ngewi Fet nge...@gmail.com writes: At the moment I am trying to export QIF from the Android app.  GnuCash keeps asking for a default account name to import into and says the QIF file does not specify an account (4th page of the import wizard).  Here is an example QIF file content that I

Re: GnuCash OFX import not matching accounts of same ID

2013-09-13 Thread Ngewi Fet
Thanks for the links. I had found mostly the Wikipedia links and some mirrors. But it was not clear to me how to include the account information, @David the example is very helpful. I can now get the default account detected. On Sep 13, 2013 3:38 AM, Tommy Trussell tommy.truss...@gmail.com

Re: GnuCash OFX import not matching accounts of same ID

2013-09-12 Thread Ngewi Fet
I don't think it would break anything to have it do a look-and-see and fall back to current behavior if it does not find a match. Agreed, If you look at the GNC Account GUID first, I cannot think of any current use case it could break. Good to know, thanks. At the moment I am trying

Re: GnuCash OFX import not matching accounts of same ID

2013-09-12 Thread Ngewi Fet
I am jumping in awfully late. I was on vacation and not reading and responding to all my e-mail. Regarding OFX and multiple accounts, one of my banks concatenates transactions from several accounts into one OFX file and GnuCash imports all the transactions correctly, including transfers

Re: GnuCash OFX import not matching accounts of same ID

2013-09-12 Thread David Carlson
On 9/12/2013 5:08 PM, Ngewi Fet wrote: I don't think it would break anything to have it do a look-and-see and fall back to current behavior if it does not find a match. Agreed, If you look at the GNC Account GUID first, I cannot think of any current use case it could break. Good to

Re: GnuCash OFX import not matching accounts of same ID

2013-09-12 Thread David Carlson
On 9/12/2013 7:34 PM, David Carlson wrote: On 9/12/2013 5:08 PM, Ngewi Fet wrote: I don't think it would break anything to have it do a look-and-see and fall back to current behavior if it does not find a match. Agreed, If you look at the GNC Account GUID first, I cannot think of any

Re: GnuCash OFX import not matching accounts of same ID

2013-09-12 Thread Tommy Trussell
On Thu, Sep 12, 2013 at 7:44 PM, David Carlson carlson...@sbcglobal.netwrote: This reference gives a start for definitions of records of various types. http://money.mvps.org/articles/qifspecification.aspx It doesn't cover everything, it has no examples, and it doesn't explain how to connect

Re: GnuCash OFX import not matching accounts of same ID

2013-09-10 Thread Benoit Grégoire
John, It is indeed easy to forget. I looked through the source but didn't want to make any changes yet. For one I'm not sure if I'll be breaking what is expected behaviour in order to suit my case. So I need more information first and also familiarize myself with the code base, but I'll

Re: GnuCash OFX import not matching accounts of same ID

2013-09-09 Thread David Carlson
On 9/4/2013 11:01 AM, Ngewi Fet wrote: On Wed, Sep 4, 2013 at 4:31 PM, Derek Atkins warl...@mit.edu wrote: John Ralls jra...@ceridwen.us writes: On Sep 4, 2013, at 7:04 AM, Derek Atkins warl...@mit.edu wrote: The importer does map the OFX Account ID to the GNC Account, but it does not

Re: GnuCash OFX import not matching accounts of same ID

2013-09-06 Thread Derek Atkins
Hi, Philip Tait phi...@taits.org writes: Would it be feasible for an app like GCfA to write out transactions in GC log file format (instead of writing OFX or QIF files), so that these files could be log-replayed against the GnuCash data file to import the transactions? Seems like this could

Re: GnuCash OFX import not matching accounts of same ID

2013-09-06 Thread Derek Atkins
Hi, Ngewi Fet nge...@gmail.com writes: Thanks for the input. Derek, I will take another look at QIF. Amongst other things I stayed away from it for lack of standardization, no transaction IDs etc [1]. The issue of duplicate transactions is handled because the app itself tracks already

Re: GnuCash OFX import not matching accounts of same ID

2013-09-04 Thread Ngewi Fet
Anyone? On Mon, Sep 2, 2013 at 12:12 PM, Ngewi Fet nge...@gmail.com wrote: Hello everyone, I am having some reports from users of the GnuCash Android app that import of the OFX accounts into GnuCash desktop does not work seamlessly. GnuCash does not seem to be able to resolve the accounts

Re: GnuCash OFX import not matching accounts of same ID

2013-09-04 Thread Derek Atkins
Hi, I don't believe the OFX importer will use any account IDs to match against account GUIDs at all. There was no expectation that the importer would be used this way when it was written, so AFAIK, unless you added code to implement it, the importer does what it always does which is match based

Re: GnuCash OFX import not matching accounts of same ID

2013-09-04 Thread John Ralls
On Sep 4, 2013, at 7:04 AM, Derek Atkins warl...@mit.edu wrote: Hi, I don't believe the OFX importer will use any account IDs to match against account GUIDs at all. There was no expectation that the importer would be used this way when it was written, so AFAIK, unless you added code to

Re: GnuCash OFX import not matching accounts of same ID

2013-09-04 Thread Derek Atkins
Hi, On Wed, September 4, 2013 12:01 pm, Ngewi Fet wrote: On Wed, Sep 4, 2013 at 4:31 PM, Derek Atkins warl...@mit.edu wrote: John Ralls jra...@ceridwen.us writes: On Sep 4, 2013, at 7:04 AM, Derek Atkins warl...@mit.edu wrote: The importer does map the OFX Account ID to the GNC Account,

Re: GnuCash OFX import not matching accounts of same ID

2013-09-04 Thread Ngewi Fet
On Wed, Sep 4, 2013 at 4:31 PM, Derek Atkins warl...@mit.edu wrote: John Ralls jra...@ceridwen.us writes: On Sep 4, 2013, at 7:04 AM, Derek Atkins warl...@mit.edu wrote: The importer does map the OFX Account ID to the GNC Account, but it does not expect the OFX Account ID to be the GNC

Re: GnuCash OFX import not matching accounts of same ID

2013-09-04 Thread Derek Atkins
John Ralls jra...@ceridwen.us writes: On Sep 4, 2013, at 7:04 AM, Derek Atkins warl...@mit.edu wrote: Hi, I don't believe the OFX importer will use any account IDs to match against account GUIDs at all. There was no expectation that the importer would be used this way when it was

Re: GnuCash OFX import not matching accounts of same ID

2013-09-04 Thread John Ralls
On Sep 4, 2013, at 9:13 AM, Derek Atkins de...@ihtfp.com wrote: Hi, On Wed, September 4, 2013 12:01 pm, Ngewi Fet wrote: On Wed, Sep 4, 2013 at 4:31 PM, Derek Atkins warl...@mit.edu wrote: John Ralls jra...@ceridwen.us writes: On Sep 4, 2013, at 7:04 AM, Derek Atkins warl...@mit.edu

Re: GnuCash OFX import not matching accounts of same ID

2013-09-04 Thread Ngewi Fet
Thanks for the input. Derek, I will take another look at QIF. Amongst other things I stayed away from it for lack of standardization, no transaction IDs etc [1]. The issue of duplicate transactions is handled because the app itself tracks already exported transactions. So if QIF can fill in the

Re: GnuCash OFX import not matching accounts of same ID

2013-09-04 Thread Philip Tait
Would it be feasible for an app like GCfA to write out transactions in GC log file format (instead of writing OFX or QIF files), so that these files could be log-replayed against the GnuCash data file to import the transactions? Seems like this could provide all needed features (Splits, etc.).

GnuCash OFX import not matching accounts of same ID

2013-09-02 Thread Ngewi Fet
Hello everyone, I am having some reports from users of the GnuCash Android app that import of the OFX accounts into GnuCash desktop does not work seamlessly. GnuCash does not seem to be able to resolve the accounts even though there exists an account in the GnuCash desktop with the same ID. I am