tag:infinitekind.tenderapp.com,2009-01-14:/discussions/general-questions/104139-importing-to-registerInfinite Kind: Discussion 2021-01-17T08:50:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/487390392020-10-17T23:04:40Z2020-10-17T23:04:42ZImporting to register <div><p>Is it possible to import more than date, description &!amount, to the register of an investment account from a cvs.<br>
Ie. Import to populate ‘Activity’ such as “sellxfr” or “divxfr” and to specify transfer account to relevant income or capital accounts.<br>
Import seems to “ignore” the ‘activity’ and ‘transfer’ columns or am I missing something.</p></div>kevintag:infinitekind.tenderapp.com,2009-01-14:Comment/487390392020-10-18T03:59:07Z2020-10-18T03:59:07ZImporting to register <div><p>I'm a fellow user.</p>
<p>The short answer is no.</p>
<p>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.</p>
<p>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.</p>
<p>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.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/487390392020-10-18T08:48:14Z2020-10-18T08:48:15ZImporting to register <div><p>Thanks for response.</p>
<p>I get the issues. (I’m an ex DB techy).<br>
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.</p>
<p>At least that reduces the boring click /C&P per transaction down to just the activity and security fields.<br>
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 .<br>
Oh well..... shame.</p>
<p>Repetitive strain here I come.</p>
<p>Appreciate the response.</p></div>kevin