Is CSV import support really still this weak?

lordpixel's Avatar

lordpixel

28 Aug, 2020 02:06 PM

Trying to import a CSV into an investment report, I am struck, and not for the first time, that the CSV importer lacks many features that CSV importers generally have.

e.g.

1. there is no ability to import investment account columns, not even Price
2. I would want to be able to map securities
3. There should be the option to ignore lines at the top of the file
4. There should be display of column names discovered in the file to aid mapping
5. There should be a a live preview, with a GUI for all of the above, selecting lines, mapping columns to Moneydance concepts

I really hate sending feedback which is purely a list of how much is missing. I'd prefer to be constructive. To that end, can you please at least prioritize item #1 above? Maybe its not economical to do a great job here but can you enhance the basic stuff?

  1. 1 Posted by dwg on 28 Aug, 2020 10:03 PM

    dwg's Avatar

    I'm a fellow user.

    While you can import investment price information from a correctly formatted CSV file it is not possible to import transactional information from a CSV file into Investment accounts.

    While the Investment register may look similar to the other registers it functions in a completely different way. It not a table like the other registers. A transaction in the investment account is driven by the action field. There are a defined number of actions and any action you enter must match with one of these. The action choosen will also determine what fields are active and also what fields are mandatory and what are optional.

    A CSV file is really just a table of information and is expected to be consistent. The data that is in investment records does not have this consistency because of the way they work. The rules with investment accounts also means that a simple free form table will not work.

    I have never seen an investment house that did produce CSV files that could be used in an investment account without a considerable amount of work. I have seen other financial programs produce such reports which with a bit of work could be used in a spreadsheet like Excel or Calc with some macros can produce QIF files which can be loaded into Moneydance Investment accounts.

    To import CSV files into most account you have two options, the inbuilt importer or the user written importer installed through the Extensions menu item. CSV files are the least preferred import method, since although the format is flexible, the very flexibility can mean there is a possibility of layout being badly defined or inconsistent.

  2. System closed this discussion on 27 Nov, 2020 10:10 PM.

Comments are currently closed for this discussion. You can start a new one.

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