Loading ...
The Buxfer Post » Blog Archive » Drastically improved CSV imports

Drastically improved CSV imports

May 8th, 2008 by Ashwin

Until now, we had a very restrictive format in which we accepted CSV files for import. This was a big pain not only because of the strict format, but because one would need to manually convert (into the format we required) a bank-downloaded CSV every single time one wanted to import.

Not anymore.

We now accept almost all formats for CSVs as long as each transaction line contains at least the following fields:

date, description and amount

Each line may also contain an optional tag field.

These fields may occur in any order which we will try our best to identify. We will also try our best to get rid of the garbage that most banks like spewing in their CSV files. If we don’t succeed, we will ask you for help — only one time per account. So once you have set this up, future CSV imports into that account will all be achieved with a single click.

Enjoy!

9 Responses to “Drastically improved CSV imports”

  1. Steve Affen Says:

    I’m very pleased to see this; it was one of the (very few) key things keeping me from using Buxfer in earnest.

    Just a quick question: can you specify separate “debit” and “credit” transaction amount columns? One of my primary banks does this, without a sign (+/-) preceding the amount.

  2. Ashwin Says:

    Steve- I *knew* these banks would throw some weird thing at us no matter what we do :) Thanks for the note. I will try to incorporate or detect such weirdness as well. Could you send us a sample CSV statement of this kind? Send it to support AT buxfer.

  3. Sam Brightman Says:

    This feature is still not working for me at all. Either it cannot recognise a date because of some cruft at the bottom of the CSV (e.g. “Total of this column:”) or it cannot recognise a simple date format (”01 May 2008″). I additionally have the separate credit and debit columns mentioned by the user above if this is still an issue (and in multiple banks in multiple countries - I don’t think it’s as strange as you believe). I do not get offered the opportunity to specify which columns are which.

    Additionally, I would always have to import these statements manually as the synchronisation feature seems to fail completely. I have Firebux and it tells me that it is recording, but seems to do nothing. When I press stop recording it doesn’t give me an error, but the accounts never sync either. A lack of automatic syncing sort of defeats the point for me…

    Although, that sort of brings me to my final point - how do you hope to deal with banks that actually have some security? I’ve heard American banks can be notoriously poor at web security but in Europe we have SecurID dongles and/or partially, mouse-entered passcodes as standard…

  4. Ashwin Says:

    Steve, Sam: we have updated our CSV import process now — you can specify separate credit and debit columns as well as multiple description columns.

  5. shrek Says:

    how can you import with separate debit/credit columns w/o - or + sign?
    it doesn’t seem to recognize it. :(

  6. David Says:

    Ok so I made a mistake the first time Buxfer was proposing the matching collumns. Now this “only ask once” feature is nice but how can I reset this so Buxfer asks me again how to match collumns?

  7. Ashwin Says:

    David: yah, that is annoying. We will get that fixed. In the meantime, you can just create another bank account within your Buxfer account and try uploading into that account. Would that work?

  8. David Says:

    I guess I could do that. The mistake I made was that I did not identified enough collumns as “description”. Some of my descriptions were blank because of that and Buxfer did not import transactions with empty description I think. Am I correct about this?

  9. Ashwin Says:

    David: yep, that’s exactly right.

Leave a Reply