Importing CSV

Maurizio's Avatar

Maurizio

15 Apr, 2015 10:11 AM

I tried the new Import Text file. From a CSV, the transactions are imported, but not as before, with the Unconfirmed flag, they just come in without an account, no flag and as such, useless...

how can i solve this?

And to add, what is the meaning of the STATUS field?

thanks,

Maurizio

  1. 1 Posted by rmerrin on 15 Apr, 2015 11:52 AM

    rmerrin's Avatar

    Look at the discussion CSV to QIF you should find some suggestions their.

  2. Support Staff 2 Posted by Ben Spencer on 15 Apr, 2015 12:15 PM

    Ben Spencer's Avatar

    If you attach a sample of your csv file I'll see what settings are needed to import it.

    Ben Spencer
    Infinite Kind Support

  3. 3 Posted by Maurizio on 15 Apr, 2015 02:07 PM

    Maurizio's Avatar

    Here it is. changed vendor and amounts, but format is the same.

    thanks

    M

  4. Support Staff 4 Posted by Ben Spencer on 15 Apr, 2015 02:35 PM

    Ben Spencer's Avatar

    Can you tell me what the columns are in your csv file?

    e.g.

    12/02/2015;xxxxxxxxxxxxxxxxxxxxxxx;;34.5

    1) Date
    2) is this supposed to be description or category?
    3) Is this debit?
    4) Is this credit?

    Note that the Text File Importer extension does not support debit and credit in separate columns. It only supports a single amount column where a negative value indicates debit.

    Ben Spencer
    Infinite Kind Support

  5. 5 Posted by Maurizio on 15 Apr, 2015 02:51 PM

    Maurizio's Avatar

    sure.
    Date-description-credit-debit
    I know the minus sign thing, but that's minor, it is not the problem i'm facing. The old version, on top of giving the possibility to define and save formats, also brought records in with the blue circle, indicating the need to confirm/merge. And the account as a standard to whatever... Now it is all gone...

    Thanks,

    maurizio

  6. Support Staff 6 Posted by Ben Spencer on 15 Apr, 2015 03:06 PM

    Ben Spencer's Avatar

    I believe I understand. I think when you say the "old version" you are referring to the 3rd party extension called "CSV Importer". "CSV Importer" is not an old version of "Text File Importer" it is a different extension.

    The extension "CSV Importer" is not yet available for MD2015. I am afraid I do not know when the writer of this extension will update it to be compatible MD2015.

    Ben Spencer
    Infinite Kind Support

  7. 7 Posted by -Kevin N. on 15 Apr, 2015 03:20 PM

    -Kevin N.'s Avatar

    Hi Maurizio, Ben,

    The developer of the CSV Importer has created a version compatible with MD 2015.

    It can be downloaded from here:
    https://github.com/stant/mdcsvimporter2015/releases

    It is not yet signed by T.I.K. so you will receive a warning as such when you go to install it.

    BTW, I was able to import your CSV with the new version.

    HTH -Kevin N.

  8. 8 Posted by Maurizio on 15 Apr, 2015 05:01 PM

    Maurizio's Avatar

    works like a charm!!!!

    Many many thanks!

    maurizio

  9. Ben Spencer closed this discussion on 15 Apr, 2015 05:16 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