Arch Linux

DonVla

Member

From: Bonn, Germany

Registered: 2007-06-07

Posts: 997

[somehow solved] homebanking app which supports csv files

hello all!!!

i'm collecting these csv files which one can download from online bank site for almost 2 and a half years.
now i need a program with which i can import these files to watch them in a clear way. i tried homebank and QBankManager. both should import these file types, but they don't.
any suggestions?

vlad

Last edited by DonVla (2008-07-25 14:26:38)

rebugger

Member

From: Germany

Registered: 2007-10-28

Posts: 229

Re: [somehow solved] homebanking app which supports csv files

What do you mean with "watch them"?
Why dont you keep downloading and import them in OpenOffice Calc?

DonVla

Member

From: Bonn, Germany

Registered: 2007-06-07

Posts: 997

Re: [somehow solved] homebanking app which supports csv files

i tried opening them in office calc, but they are totally messed up.
till now i watched and searched them in vim, but i have now about 30 csv files. and it's getting confusing.
i need a program with which i can get an overview over these files.

btw: can someone please explain this to me:
http://homebank.free.fr/help/06csvformat.html

Last edited by DonVla (2008-07-25 12:48:16)

rebugger

Member

From: Germany

Registered: 2007-10-28

Posts: 229

Re: [somehow solved] homebanking app which supports csv files

Why are they messed up?
When you import them into OpenOffice Calc you can decide the Seperator ( ; or | or ...) and then they will show up in the table.

Did this with many cvs-Files.

(Hey, i'm from Germany too)

DonVla

Member

From: Bonn, Germany

Registered: 2007-06-07

Posts: 997

Re: [somehow solved] homebanking app which supports csv files

When you import them into OpenOffice Calc you can decide the Seperator ( ; or | or ...) and then they will show up in the table.

how?
the other problem is that i also have duplicate entries. i also want to filter them out.

(Hey, i'm from Germany too)

rebugger

Member

From: Germany

Registered: 2007-10-28

Posts: 229

Re: [somehow solved] homebanking app which supports csv files

File => Open => Select the csv-File
Then select the seperator (in this screenshot i would need the ";")
http://uploadimage.org/images/tlhugjv8rij7tkiow2hn.jpg

Maybe you could give an example of the content of your csv-file?

DonVla

Member

From: Bonn, Germany

Registered: 2007-06-07

Posts: 997

Re: [somehow solved] homebanking app which supports csv files

thanks rebugger! i missed that.
now i opened the csv file in office calc. but as i said it's not really useful, because i have many double entries. i want to merge all 32 files and omit duplicate entries.
however, i got qbankmanager running, but it's totally cluttered.
is there no sane banking program out there????
homebank looks nice in the screenshots, but i cannot get it running....
does no one use such an app?

vlad

rebugger

Member

From: Germany

Registered: 2007-10-28

Posts: 229

Re: [somehow solved] homebanking app which supports csv files

Well there are methods to remove duplicate entrys in OpenOffice Calc... for example:
http://blogs.sun.com/oootnt/entry/remov … ws_in_calc
http://user.services.openoffice.org/en/ … f=9&t=5379

But it sounds like you want to use qBankmanager...

DonVla

Member

From: Bonn, Germany

Registered: 2007-06-07

Posts: 997

Re: [somehow solved] homebanking app which supports csv files

But it sounds like you want to use qBankmanager...

yeah, i want to use a similar application.
the point is that i don't really need the whole stuff provided by qbankmanager. i imported the csv files in qbankmanager, bt i needed about 15mins to find the interface where this entries ar listed....
perhaps the most sane way is simply using openoffice.
thanks rebugger.

if anyone knows another application please tell....

vlad

Last edited by DonVla (2008-07-25 13:21:18)

rebugger

Member

From: Germany

Registered: 2007-10-28

Posts: 229

Re: [somehow solved] homebanking app which supports csv files

Well you can do a lot of stuff with Calc and some formulas...

nj

Member

Registered: 2007-04-06

Posts: 93

Re: [somehow solved] homebanking app which supports csv files

now i opened the csv file in office calc. but as i said it's not really useful, because i have many double entries. i want to merge all 32 files and omit duplicate entries.

If your files have a csv extension, this might do what you want:

cat *.csv | sort | uniq > merged.csv

DonVla

Member

From: Bonn, Germany

Registered: 2007-06-07

Posts: 997

Re: [somehow solved] homebanking app which supports csv files

now i opened the csv file in office calc. but as i said it's not really useful, because i have many double entries. i want to merge all 32 files and omit duplicate entries.

If your files have a csv extension, this might do what you want:

cat *.csv | sort | uniq > merged.csv

hey thanks, that's great!
i never heard of "uniq". this is the best idea till now.
i discovered hibiscus, a java app.  but all the interfaces are way too much.
i think i'll simply merge all the files as you said and stick with vim.

vlad

ps: that's annoying! i wasted 2 hours checking crappy apps and the best idea is so simple!
thanks again nj!

Last edited by DonVla (2008-07-25 14:26:04)