1000 1 10 1000 1 10 False 12 CSV Transaction Import 400 500 True False start start 12 12 This assistant will help you import a delimited file containing a list of transactions. It supports both token separated files (such as comma separated or semi-colon separated) and fixed width data. For a successful import three columns have to be available in the import data: • a Date column • a Description column • a Deposit or Withdrawal column If there is no Account data available, a base account can be selected to which all data will be imported. Apart from a choice of delimiter, there are several options to tweak the importer. For example a number of lines can be skipped at the start or the end of the data, as well as odd rows. Several date and number formats are supported. The file encoding can be defined. The importer can handle files where transactions are split over multiple lines, with each line representing one split. Lastly, for repeated imports the preview page has buttons to Load and Save the settings. You can save your adjusted settings to reuse them on later imports. After loading your settings you can also tweak them again for similar imports and save them under another name. True intro Transaction Import Assistant True False True False 12 vertical True False Select location and file name for the Import, then click "Next"… True False False 0 Select File for Import False True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK 12 vertical 2 True False start 6 5 5 True False 0 in True False 3 True True True Delete Settings Deletes the settings saved under the name as entered in the adjacent text field. There are two reserved names which can never be deleted: - No settings - Gnucash default export format True False edit-delete False False end 0 True True True Save Settings Saves current settings under the name as entered in the adjacent text field. There are two reserved names which can't be used to save custom settings: - No settings - Gnucash default export format True False document-save False False end 2 True False <b>Load and Save Settings</b> True False 0 0 True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK 0 True False 6 6 vertical True False Character-separated True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start True True 0 0 Fixed-Width True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start True csv_button 1 0 True False True 0 1 2 False False 0 True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK 3 Space True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start True 0 0 Tab True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start True 1 0 Comma (,) True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start True True 2 0 Colon (:) True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start True 0 1 Semicolon (;) True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start True 1 1 Hyphen (-) True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start True 2 1 Custom True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start True 0 2 True True GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK ● False False 1 2 2 False False 1 False True True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start start dialog-information 3 False True 2 0 True False 5 True False • True 0 0 True False start Double-click anywhere on the table below to insert a column break True 0 1 0 True False • True 0 1 True False start Right-click anywhere in a column to modify it (widen, narrow, merge) True 0 1 1 True True 1 False False 2 True False True False 3 3 True 0 0 Multi-split True True False Normally the importer will assume each line in the input file will correspond to one transaction. Each line can have information for one transaction and one or two splits. When Multi-split is enabled the importer will assume multiple consecutive lines together hold the information for one transaction. Each line provides information for exactly one split. The first line should also provide the information for the transaction. To know which lines belong to the same transaction, the importer will compare the provided transaction information in each line. If that information is empty or the same as the first transaction line the importer will consider this line part of the same transaction. start True 0 1 False False 3 True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK <b>File Format</b> True 0 1 True False 0 True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK vertical True False 6 6 3 6 6 True False end Date Format 0 1 True False end Currency Format 0 2 True False end Encoding 0 0 True False end Leading Lines to Skip 0 4 True False end Trailing Lines to Skip 0 5 True False True True start ● False False start_row_adj True False False 0 1 4 True False True True start ● False False end_row_adj True False False 0 1 5 True False 3 3 0 3 2 True False 1 1 True False 1 0 True False 1 2 True True False Starting from the first line that is actually imported every second line will be skipped. This option will take the leading lines to skip into account as well. For example * if 'Leading Lines to Skip' is set to 3, the first line to import will be line 4. Lines 5, 7, 9,… will be skipped. * if 'Leading Lines to Skip' is set to 4, the first line to import will be line 5. Lines 6, 8, 10,… will be skipped. start True 1 6 True False end Skip alternate lines 0 6 False True 0 True False <b>Miscellaneous</b> True 1 1 True False 0 none True False 3 True True False <b>Account</b> True 1 0 False False 0 True True True True GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK both True True 1 True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start start dialog-information 3 False True 2 0 True False GDK_POINTER_MOTION_MASK | GDK_POINTER_MOTION_HINT_MASK | GDK_BUTTON_PRESS_MASK | GDK_BUTTON_RELEASE_MASK start Select the type of each column to import. True True 1 False False 5 2 True False Skip Errors True False right True False False end 0 False False 3 Import Preview True False True False 12 vertical True False Select a row to change the mappings False False 5 0 True True in True True To change mapping, double click on a row or select a row and press the button… account_match_store False True True Account ID 0 True Account Name True 1 True True 1 True False True False Error text. 0 True True 0 Change GnuCash _Account… True True True True False False end 1 False False 2 Match Import and GnuCash accounts False True False start vertical True False 12 12 If you click "Next" Gnucash will perform a number of checks. If one of those <i>checks fails</i> you'll be automatically redirected to the preview page to try and correct. On the following page you will be able to associate each transaction to a category. If this is your <i>initial import into a new file</i>, you will first see a dialog for setting book options, since these can affect how imported data are converted to GnuCash transactions. If this is an existing file, the dialog will not be shown. If this is the <i>first time importing</i>, you will find that all lines may need to be associated. On subsequent imports, the importer will try to associate the transactions based on previous imports. The confidence of a correct association is displayed as a colored bar. More information can be displayed by using the help button. True True True True 0 progress Transaction Information True False True False 12 vertical True False label False False end 0 confirm Match Transactions False True False 12 vertical True False label True True True True 0 summary Import Summary True False False