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.