Re: Headers for importing accounts from CSV

2018-02-15 Thread Sébastien de Menten
FYI: Commodityn=commodity namespace=CURRENCY for currencies or NASDAQ for commodities on NASDAQ (see https://www.gnucash.org/docs/v2.6/C/gnucash-help/tool-security-edit.html) Commoditym=commodity mnemonic=USD for us dollar or AAPL for Apple stock=the symbol in the page referenced hereabove On Feb

Re: Headers for importing accounts from CSV

2018-02-15 Thread Adrien Monteleone
Sorry, I don’t use that feature at all, so I’ll have to defer. Try a google search on the list with “site:lists.gnucash.org” (without the quotes) followed by your search terms. You’ll get hits only from the list archives. There are many threads on OFX and AqWizard and I doubt you’re the first

Re: Headers for importing accounts from CSV

2018-02-15 Thread Holly Ochidi
Sweet! What a simple solution... Can't believe I didn't think of trying to make an account then export it. Setting up all the accounts I need one by one is painful. Thanks for the info! Regards, Holly Ochidi On Thu, Feb 15, 2018 at 4:49 PM, Adrien Monteleone < adrien.montele...@gmail.com> wrote

Re: Headers for importing accounts from CSV

2018-02-15 Thread Adrien Monteleone
Sorry, I forgot to mention that in the hidden and place_holder columns, the export shows ‘F’ and ‘T’ so those should work, but if not, using or 0 or 1 should suffice. The tax column also appears to be binary. I think the setting is just a check box for each account that asks “Tax Related?” so t

Re: Headers for importing accounts from CSV

2018-02-15 Thread Adrien Monteleone
Holly, I’m relying on what I see from an export, but here’s something that might help: ‘full_name' is the entire tree path, so 'Assets:Current Assets:Cash In Wallet' where ‘name’ is just ‘Cash In Wallet’ All of my ‘commoditym’ fields contain ‘USD’ and all of my ‘commodityn’ fields contain ‘CUR