Warning, /office/kmymoney/contrib/csvimporter/InvestmentHOWTO is written in an unsupported language. File is not indexed.

0001 SampleIncFund.csv
0002 
0003 NOTE
0004         Please bear in mind that this import file was made to be complicated in order to 
0005                 demonstrate the different possibilities the plugin can handle.  In particular, 
0006                 it includes unclear investment activity types, and also two brokerage transactions.
0007                 Generally, most files can be imported with far  less interaction,
0008 
0009 a)      Click Investment tab.
0010                         On the right, Click 'Open File' and select your file to be imported.
0011 b)      Check that fields are properly separated.
0012                         If not, on Settings tab, choose ',' as separator.
0013 c)      On Investment tab, choose appropriate columns/fields.
0014                         Set Col 2 in Date.
0015                         Set Col 4 in Type/Action.
0016                         Set Col 6 in Quantity.
0017                         Set Col 7 in Price.
0018                         Set Col 8 in Amount.
0019                         Set any other columns you wish to import as Memo, successively.  Notice an '*' 
0020                                 marks the choices made.
0021                         Set Price/Fraction to '1' if the Price is to be imported 'as is', eg £.pence.
0022          or     Set Price/Fraction to '0.1' if the Price is to be imported as eg
0023                         pence.decimal.
0024                         These depend on your existing KMyMoney security file content.
0025          Leave 'Fee' settings empty as there is no fee data in the file.  If there
0026                 were, choose the column, and check 'Fee is a percentage' if the fee is that.
0027 d)      Enter the security name in that field to match exactly the name in
0028                         KMyMoney.  The name will be retained in the pop-up.  If you wish to remove
0029                         an entry from that list, click 'Hide Security'.  This has no effect on
0030                         KMyMoney data.
0031 e)      Click Settings tab.
0032                         The Field Delimiter should already be correctly set.
0033                         The Text Delimiter should not normally need to be changed.
0034                         Set the Start Line to your first data line - '9' in this case.
0035                         Set the End Line to your last data line - '22', to drop the trailer line.
0036                         Set the Decimal Symbol to match those in your file, not your locale.  If your 
0037                         locale setting has a different value, conversion will be seen to take   place.  
0038                         When you click on       'dot', you will see that your values get highlighted in green, 
0039                         if they are correct.  If an error is found, the colour will be red, and one, 
0040                         or      more than one, warning message will appear.  Try setting it to ';' to see
0041                         the effect.
0042                         Set the Date appropriately - 'd m y' in this case.
0043 f)              Now, finally, click 'Import' on the right.
0044 g)      The plugin will now evaluate your data.
0045 h)      As the first two lines appear to be Buy transactions, a message box will ask
0046                         for the account name from which to take the funds.  Respond with your
0047                         checking or brokerage account name.
0048 i)      Next you will get a new window indicating that an Invalid Transaction Type
0049                         has been encountered.  This is because the investment   type is shown as
0050                         'reinvestment', but only an Amount entry has been supplied.  Click on
0051                         'Select Transaction Type'.  A drop-down will appear, with the dividend
0052                         item ticked.  Assuming you choose this, the 'OK' box will be enabled, to
0053                         accept the change.
0054 j)      Another message box now appears.  This is because on line 11, a 'Bill
0055                         Payment'entry has been found, and the column number of the payee is
0056                         needed.  This appears in column 5, so enter 5.
0057 k)      Another Invalid Transaction type has been found, 'Purchase', on line 13. 
0058                 The drop-down now gives three choices.  Choose 'Buy' and click'OK'.
0059 l)      The plugin has now finished its work and control has passed to KMyMoney,
0060                 and the Account Selector wants your investment account to be selected.
0061 m)      Once you supply this, the Statement Stats box appears, for the investment
0062                 import.  Almost there now.
0063 n)      Another account selector now appears!  This is for the two brokerage items,
0064                 and you need to enter the brokerage/checking account for those transactions.
0065 o)      Another Statement Stats box appears, this time for these two non-investment
0066                 transactions.
0067 p)      Finally, the import is complete.  Please bear in mind that this import was
0068                 made to be complicated in order to demonstrate the different possibilities
0069                 the plugin can handle.  Generally, most files can be imported with far
0070                 less interaction, particularly as your selections are retained and should make
0071                 the next import quicker.
0072 
0073 If you have any comments, or encounter difficulties, first check the handbook in 
0074 KMyMoney.  If still having difficulty, contact us on 
0075 the developer list - kmymoney-devel@kde.org, or 
0076 the user list - kmymoney@kde.org.