Importing to register

kevin's Avatar

kevin

17 Oct, 2020 11:04 PM

Is it possible to import more than date, description &!amount, to the register of an investment account from a cvs.
Ie. Import to populate ‘Activity’ such as “sellxfr” or “divxfr” and to specify transfer account to relevant income or capital accounts.
Import seems to “ignore” the ‘activity’ and ‘transfer’ columns or am I missing something.

  1. 1 Posted by dwg on 18 Oct, 2020 03:59 AM

    dwg's Avatar

    I'm a fellow user.

    The short answer is no.

    CSV files can only use used to load data that can be mapped to a consistent table type structure, hence it can handle banking type data pretty well.

    Investment type data does not fit well into this. The action field must contain one of a number of predetermined standard transaction types, no other entries are accepted. The particular action type determines what fields are active, however not all fields may be required. Hence depending on the action you may have a different number of fields which will not be consistent with a fixed table structure.

    It is very unusual to see a CSV file with a structure that would suit loading into Investment registers, the only ones I have seen were produced by another financial program, In that instance I used a Excel add on to create QIF files from them.

  2. 2 Posted by kevin on 18 Oct, 2020 08:48 AM

    kevin's Avatar

    Thanks for response.

    I get the issues. (I’m an ex DB techy).
    Found that if you import the date amount and desc for dividend trans, you can at least batch change ‘transfer’ into the income Acct by doing it in reverse. Ie. The import allocates ‘transfer’ to a default account. After the import. (Before confirming each) Go into that default account and batch change to the income account.

    At least that reduces the boring click /C&P per transaction down to just the activity and security fields.
    Although Would have thought it feasible to have an import option that used the ‘activity’ as the template for fields required. Given Its easier to batch change a column in xcel to “divxfr” as the driving flag than manually click, drop down etc of every row .
    Oh well..... shame.

    Repetitive strain here I come.

    Appreciate the response.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac