Headers for importing accounts from CSV

[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 to stumble on this so someone may have a solution buried in past threads.

Also, please be sure to copy the list on all replies for non-personal messages as others may benefit from the discussion.

Regards,
Adrien

> On Feb 15, 2018, at 5:30 PM, Holly Ochidi <hsukup1 at gmail.com> wrote:
> 
> Adrien, 
> 
> Any advice on setting up OFX import via AqWizard for a bank that is not listed?
> 
> 
> Regards,
> 
> Holly Ochidi
> 
> On Thu, Feb 15, 2018 at 5:24 PM, Holly Ochidi <hsukup1 at gmail.com> wrote:
> 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.monteleone at gmail.com> wrote:
> 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 that makes sense. But I know the tax report setup is more complicated and likely that data lies somewhere else. Even after the import, you’ll likely have to set that up separately.
> 
> 
> Regards,
> Adrien
> 
> > On Feb 15, 2018, at 4:45 PM, Adrien Monteleone <adrien.monteleone at gmail.com> wrote:
> >
> > 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 ‘CURRENCY’ if that helps.
> >
> > I see the export doesn’t include trading accounts so I can’t help with what the other options are for ‘commodityn’. My suspicion would be it is used for stocks or mutual funds. (STOCK and FUND respectively would be the likely data)
> >
> > I tried looking for an explanation of the fields online, but haven’t managed to find them yet.
> >
> >
> > Regards,
> > Adrien
> >
> >> On Feb 15, 2018, at 1:28 PM, Holly Ochidi <hsukup1 at gmail.com> wrote:
> >>
> >> [image: Inline image 1]
> >>
> >> Kindly, please describe the column headers and where the data points to:
> >>
> >> name vs. full_name
> >> commoditym
> >> commodityn
> >>
> >> I have attempted to use the following entries for "commoditym" and
> >> "commodityn" without success:
> >> USD
> >> US Dollar
> >>
> >> Also, I assume the columns "hidden" and "place_holder" should hold a TRUE
> >> or FALSE? or should it be a "0" or "1"?
> >>
> >> Also, what values can I put under the "tax" column to automatically create
> >> accounts with the correct Income Tax account designations?
> >>
> >> I believe I understand the remaining columns.
> >>
> >> Much appreciation!
> >>
> >> Regards,
> >>
> >> Holly Ochidi
> >> <image.png>_______________________________________________
> >> 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
> >> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -----
> >> 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
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
>