import from Spanish Banks

[Jordi Alfonso i Camús]

Hi.
I don't know if this is the right place to make this question. If not, please,
send it to the right recipent. Ah! And excuse me for my poor english.
I live in Spain and work with Deutsche Bank SAE and Caixa Terrassa. I've tried
to import the bank sheets into my kmymoney but I have no success. I've been
searching in www, looking in forums, but i get no answers.
I think there are two methods to make this (correct me if I am wrong). First
of them is an online connect plugin (OFX?) but I think my banks doesn't
support them. The second is importing a file whith the movements. Deutsche Bank
can export in .xls file and Caixa Terrassa in .html table file. So kmymoney
don't import them.
What can I do to solve this? I can send you a file of these Banks if it's
needed. Can you help me?
Thanks,

Jordi Alfonso.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

On Wed, Nov 11, 2009 at 7:48 AM, Camulus <camulus08940@...> wrote:

Hi.
I don't know if this is the right place to make this question. If not, please,
send it to the right recipent. Ah! And excuse me for my poor english.
I live in Spain and work with Deutsche Bank SAE and Caixa Terrassa. I've tried
to import the bank sheets into my kmymoney but I have no success. I've been
searching in www, looking in forums, but i get no answers.
I think there are two methods to make this (correct me if I am wrong). First
of them is an online connect plugin (OFX?) but I think my banks doesn't
support them. The second is importing a file whith the movements. Deutsche Bank
can export in .xls file and Caixa Terrassa in .html table file. So kmymoney
don't import them.
What can I do to solve this? I can send you a file of these Banks if it's
needed. Can you help me?
Thanks,

Jordi Alfonso.

Hello Jordi,
if your bank provides .csv (archivos separados con comas) you could import those using AqBanking, and the kmymoney plugin for aqbanking. Usually, the banks provide .xls files, but they are actually .csv files not real Excel files.
So, if that's your case, you might be able to setup an import profile in aqbanking (to match the format of the file) and import the files into KMM.

I'm sure someone else can provide more information if you need it, because I don't use the import plugins myself.

Regards,
Alvaro

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Alvaro Soliverez wrote:

>
>
> On Wed, Nov 11, 2009 at 7:48 AM, Camulus <camulus08940@...
> <mailto:camulus08940@...>> wrote:
>
>     Hi.
>     I don't know if this is the right place to make this question. If
>     not, please,
>     send it to the right recipent. Ah! And excuse me for my poor english.
>     I live in Spain and work with Deutsche Bank SAE and Caixa Terrassa.
>     I've tried
>     to import the bank sheets into my kmymoney but I have no success.
>     I've been
>     searching in www, looking in forums, but i get no answers.
>     I think there are two methods to make this (correct me if I am
>     wrong). First
>     of them is an online connect plugin (OFX?) but I think my banks doesn't
>     support them. The second is importing a file whith the movements.
>     Deutsche Bank
>     can export in .xls file and Caixa Terrassa in .html table file. So
>     kmymoney
>     don't import them.
>     What can I do to solve this? I can send you a file of these Banks if
>     it's
>     needed. Can you help me?
>     Thanks,
>
>     Jordi Alfonso.
>
>
> Hello Jordi,
> if your bank provides .csv (archivos separados con comas) you could
> import those using AqBanking, and the kmymoney plugin for aqbanking.
> Usually, the banks provide .xls files, but they are actually .csv files
> not real Excel files.
> So, if that's your case, you might be able to setup an import profile in
> aqbanking (to match the format of the file) and import the files into KMM.
>
> I'm sure someone else can provide more information if you need it,
> because I don't use the import plugins myself.
>
> Regards,
> Alvaro
>

Hi Jordi

Alvaro beat me to it.

If you can get csv files, I've just produced some scripts to convert
bank statements, and investment details, from csv to qif, which can
import to KMyMoney.

Without giving away any financial info., can you show the file layout,
preferably in English as my Spanish neighbour has just gone on holiday!.

Allan





------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

On Wed, Nov 11, 2009 at 8:51 AM, allan <aganderson@...> wrote:

Alvaro Soliverez wrote:
>
>
> On Wed, Nov 11, 2009 at 7:48 AM, Camulus <camulus08940@...

> <mailto:camulus08940@...>> wrote:
>
>     Hi.
>     I don't know if this is the right place to make this question. If
>     not, please,
>     send it to the right recipent. Ah! And excuse me for my poor english.
>     I live in Spain and work with Deutsche Bank SAE and Caixa Terrassa.
>     I've tried
>     to import the bank sheets into my kmymoney but I have no success.
>     I've been
>     searching in www, looking in forums, but i get no answers.
>     I think there are two methods to make this (correct me if I am
>     wrong). First
>     of them is an online connect plugin (OFX?) but I think my banks doesn't
>     support them. The second is importing a file whith the movements.
>     Deutsche Bank
>     can export in .xls file and Caixa Terrassa in .html table file. So
>     kmymoney
>     don't import them.
>     What can I do to solve this? I can send you a file of these Banks if
>     it's
>     needed. Can you help me?
>     Thanks,
>
>     Jordi Alfonso.
>
>
> Hello Jordi,
> if your bank provides .csv (archivos separados con comas) you could
> import those using AqBanking, and the kmymoney plugin for aqbanking.
> Usually, the banks provide .xls files, but they are actually .csv files
> not real Excel files.
> So, if that's your case, you might be able to setup an import profile in
> aqbanking (to match the format of the file) and import the files into KMM.
>
> I'm sure someone else can provide more information if you need it,
> because I don't use the import plugins myself.
>
> Regards,
> Alvaro
>

Hi Jordi

Alvaro beat me to it.

If you can get csv files, I've just produced some scripts to convert
bank statements, and investment details, from csv to qif, which can
import to KMyMoney.

Without giving away any financial info., can you show the file layout,
preferably in English as my Spanish neighbour has just gone on holiday!.

Sorry, Allan, I forgot about your scripts. That would be much faster.

Jordi,
if you have trouble producing them in English, I can help Allan through it, unless they are in Catalan.
 


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[Fernando Vilas-2]

On Wednesday 11 November 2009 06:01:25 Alvaro Soliverez wrote:
> On Wed, Nov 11, 2009 at 8:51 AM, allan <aganderson@...> wrote:
> > Alvaro Soliverez wrote:
> > > On Wed, Nov 11, 2009 at 7:48 AM, Camulus <camulus08940@...
> > > <mailto:camulus08940@...>> wrote:
> > >
[...]

> > Without giving away any financial info., can you show the file layout,
> > preferably in English as my Spanish neighbour has just gone on holiday!.
>
> Sorry, Allan, I forgot about your scripts. That would be much faster.
>
> Jordi,
> if you have trouble producing them in English, I can help Allan through it,
> unless they are in Catalan.
>
I also have a Spanish <-> Gallego dictionary handy, if that bank is from the
other region that spells "caja" as "caixa". :-)

--
Thanks,
Fernando Vilas
fvilas@...


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[Jordi Alfonso i Camús]

A Dijous 12 Novembre 2009 02:38:41, Fernando Vilas va escriure:

> On Wednesday 11 November 2009 06:01:25 Alvaro Soliverez wrote:
> > On Wed, Nov 11, 2009 at 8:51 AM, allan <aganderson@...> wrote:
> > > Alvaro Soliverez wrote:
> > > > On Wed, Nov 11, 2009 at 7:48 AM, Camulus <camulus08940@...
> > > > <mailto:camulus08940@...>> wrote:
>
> [...]
>
> > > Without giving away any financial info., can you show the file layout,
> > > preferably in English as my Spanish neighbour has just gone on
> > > holiday!.
> >
> > Sorry, Allan, I forgot about your scripts. That would be much faster.
> >
> > Jordi,
> > if you have trouble producing them in English, I can help Allan through
> > it, unless they are in Catalan.
>
> I also have a Spanish <-> Gallego dictionary handy, if that bank is from
>  the other region that spells "caja" as "caixa". :-)
>

Hi again. I've tried to import the two .xls files using Aqbanking import
plugin, but no success. The .xls file from CaixaTerrassa is not recognized. the
.xls file from deutsche bank seems to be imported successfully but nothing was
imported into KMM.
I don't know how to send the layouts with no financial data. I try to open
them, translate to english and change all imports to other numbers, ok?
And... I send the files... at what email?
Thanks.

jordi

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

On Thu, Nov 12, 2009 at 3:15 PM, Camulus <camulus08940@...> wrote:

A Dijous 12 Novembre 2009 02:38:41, Fernando Vilas va escriure:

> On Wednesday 11 November 2009 06:01:25 Alvaro Soliverez wrote:
> > On Wed, Nov 11, 2009 at 8:51 AM, allan <aganderson@...> wrote:
> > > Alvaro Soliverez wrote:
> > > > On Wed, Nov 11, 2009 at 7:48 AM, Camulus <camulus08940@...
> > > > <mailto:camulus08940@...>> wrote:
>
> [...]
>
> > > Without giving away any financial info., can you show the file layout,
> > > preferably in English as my Spanish neighbour has just gone on
> > > holiday!.
> >
> > Sorry, Allan, I forgot about your scripts. That would be much faster.
> >
> > Jordi,
> > if you have trouble producing them in English, I can help Allan through
> > it, unless they are in Catalan.
>
> I also have a Spanish <-> Gallego dictionary handy, if that bank is from
>  the other region that spells "caja" as "caixa". :-)
>

Hi again. I've tried to import the two .xls files using Aqbanking import
plugin, but no success. The .xls file from CaixaTerrassa is not recognized. the
.xls file from deutsche bank seems to be imported successfully but nothing was
imported into KMM.
I don't know how to send the layouts with no financial data. I try to open
them, translate to english and change all imports to other numbers, ok?
And... I send the files... at what email?
Thanks.

You can send the files to Allan, and he can help you setup the import using his import scripts.

I CC'ed him explicitly so you have his email.

Regards,
Alvaro

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Camulus wrote:

>>>>>>> On Wed, Nov 11, 2009 at 7:48 AM, Camulus <camulus08940@...
>>>>>>> <mailto:camulus08940@...>> wrote:
>>>> [...]
>>>>
>>>>>> Without giving away any financial info., can you show the file layout,
>>>>>> preferably in English as my Spanish neighbour has just gone on
>>>>>> holiday!.
>>>>> Sorry, Allan, I forgot about your scripts. That would be much faster.
>>>>>
>>>>> Jordi,
>>>>> if you have trouble producing them in English, I can help Allan through
>>>>> it, unless they are in Catalan.
>>>> I also have a Spanish <-> Gallego dictionary handy, if that bank is from
>>>>  the other region that spells "caja" as "caixa". :-)
>>> Hi again. I've tried to import the two .xls files using Aqbanking import
>>> plugin, but no success. The .xls file from CaixaTerrassa is not
>>> recognized. the .xls file from deutsche bank seems to be imported
>>> successfully but nothing was imported into KMM.
>>> I don't know how to send the layouts with no financial data. I try to
>>> open them, translate to english and change all imports to other numbers,
>>> ok? And... I send the files... at what email?
>>> Thanks.
>>>
>>> jordi
>> Hi jordi
>>
>> send to @@@ and I'll see what I can do.
>>
>> Allan
>>
> Ok I send this. thanks a lot. If you need more translation say me it.
> thanks,
>
> jordi

Hi jordi

Well, that's a mixed bunch!  The first problem is that they're in xls
format, not csv.  I've done a lot of Googling, and have found only an
Excel Add-In that converts data to QIF format, or a non-free converter.
   Just loading into an editor doesn't help, without knowing format
codes, etc.  The only other way I can see at the moment is to load into
calc then save as csv.  I've had to modify my script quite a bit, but
I've done that with the Deutsch_bank one, and was able to convert to qif
and import into KMM successfully.

If you're happy-ish with prior converting to csv, then before going on
further, the two banks have quite different formats (of course), so a
few queries/comments.

a) Both have two date columns, but qif allows only one.  Which should I use?
b) Only the actual transactions can be imported.
c) QIF has no field for balance.  Can this be dropped?
d) caixaterrassa has these fields:-
Date   Valor Date   Concept Reference   Amount   Balance
How do you want to see Concept and Reference?  Concatenated/joined into
KMM Details?  Or, one in Details an the other in Memo?  Or, what?  If
concatenated, separated by a space or colon : or what?
e) To avoid the need for two scripts, or added complexity, could you
adopt a common layout/headings for the two files?  Deutsch_bank could
have a blank Reference column added on conversion to csv, perhaps.
f) What character code do you use?  ISO 8859-14?

Allan

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Camulus wrote:
>> >> Hi jordi
>> >>
>> >> Well, that's a mixed bunch!  The first problem is that they're in xls
>> >> format, not csv.  I've done a lot of Googling, and have found only an
>> >> Excel Add-In that converts data to QIF format, or a non-free
converter.
>> >>    Just loading into an editor doesn't help, without knowing format
>> >> codes, etc.  The only other way I can see at the moment is to load
into
>> >> calc then save as csv.  I've had to modify my script quite a bit, but
>> >> I've done that with the Deutsch_bank one, and was able to convert
to qif
>> >> and import into KMM successfully.
> >
> > Hehe... I know there are REALLY a .xls files. I'm happy that you've
imported
> > successfully the Deutsche Bank file.
> >
>> >> If you're happy-ish with prior converting to csv, then before going on
>> >> further, the two banks have quite different formats (of course), so a
>> >> few queries/comments.
> >
> > I'm very happy whith the prior converting to csv option. Seems more
easy than
> > import all the assentments one for one. thanks!
> >
>> >> a) Both have two date columns, but qif allows only one.  Which
should I
>> >>  use? b) Only the actual transactions can be imported.
> >
> > I think it's better the first one, the only DATE field.
> >
>> >> c) QIF has no field for balance.  Can this be dropped?
> >
> > Yes, can be dropped. KMM calculates the total balance after each
assentment,
> > isn't?
> >
>> >> d) caixaterrassa has these fields:-
>> >> Date   Valor Date   Concept Reference   Amount   Balance
>> >> How do you want to see Concept and Reference?  Concatenated/joined
into

>> >> KMM Details?  Or, one in Details an the other in Memo?  Or, what?  If
>> >> concatenated, separated by a space or colon : or what?
> >
> > Joined in the same field, the DETAILS field.
> >
>> >> e) To avoid the need for two scripts, or added complexity, could you
>> >> adopt a common layout/headings for the two files?  Deutsch_bank could
>> >> have a blank Reference column added on conversion to csv, perhaps.
> >
> > Yes... DB can have a blank reference column. I can add this manually

prior to

> > convert to CSV. no problem.
> >
>> >> f) What character code do you use?  ISO 8859-14?
> >
> > mmmh.. I think so.
> >
> > Thanks again!
> >
> > Jordi
> >

Hi jordi

Here's the script.  First of all, a couple of cautions.  When converting
to csv in Calc, would you make sure to use ';' (semi-colon) as field
separator.  This is to avoid confusion with the decimal separator.
(Haven't looked at sorting this via KDE Settings, so it's hard-coded
in).  Secondly, your caixaterrassa file includes Euro symbols, which I
delete in the script.    However, While they appear as Euro symbols in
xls in Calc, when I output the csv file from Calc, they're not, they're
either question mark/query, or some other symbol.  I've used that in the
script to delete them, which works OK, but you might need to check your
own csv file and see how it turns out in the qif.

To check the output initially, ensure the script has execute permission,
then run as:-
./csvbankingqif-ES.py < yourinputfile.csv > youroutputfile.qif

If the csv and the qif files look OK, then go into KMM and set up a qif
profile - Tools/QIF Profile Editor, click on New, enter a profile name -
csvbank, or whatever, then select that profile on the left.  Then click
the Filter tab.  Enter the script name in the Input Filter Location, and
make the file type *.csv.  Then click OK.  Now, File/Import/QIF, browse
to and select your csv file, then select your new qif profile, and click
Import.

All being well, your transactions should appear in whatever account you
select!.

Let's know how you get on.

Allan




------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Camulus wrote:

> A Divendres 13 Novembre 2009 19:01:35, allan va escriure:
>> Camulus wrote:
>>>> Hi jordi
>>>>
>>>> Well, that's a mixed bunch!  The first problem is that they're in xls
>>>> format, not csv.  I've done a lot of Googling, and have found only an
>>>> Excel Add-In that converts data to QIF format, or a non-free converter.
>>>>    Just loading into an editor doesn't help, without knowing format
>>>> codes, etc.  The only other way I can see at the moment is to load into
>>>> calc then save as csv.  I've had to modify my script quite a bit, but
>>>> I've done that with the Deutsch_bank one, and was able to convert to qif
>>>> and import into KMM successfully.
>>> Hehe... I know there are REALLY a .xls files. I'm happy that you've
>>> imported successfully the Deutsche Bank file.
>>>
>>>> If you're happy-ish with prior converting to csv, then before going on
>>>> further, the two banks have quite different formats (of course), so a
>>>> few queries/comments.
>>> I'm very happy whith the prior converting to csv option. Seems more easy
>>> than import all the assentments one for one. thanks!
>>>
>>>> a) Both have two date columns, but qif allows only one.  Which should I
>>>>  use? b) Only the actual transactions can be imported.
>>> I think it's better the first one, the only DATE field.
>>>
>>>> c) QIF has no field for balance.  Can this be dropped?
>>> Yes, can be dropped. KMM calculates the total balance after each
>>> assentment, isn't?
>>>
>>>> d) caixaterrassa has these fields:-
>>>> Date   Valor Date   Concept Reference   Amount   Balance
>>>> How do you want to see Concept and Reference?  Concatenated/joined into
>>>> KMM Details?  Or, one in Details an the other in Memo?  Or, what?  If
>>>> concatenated, separated by a space or colon : or what?
>>> Joined in the same field, the DETAILS field.
>>>
>>>> e) To avoid the need for two scripts, or added complexity, could you
>>>> adopt a common layout/headings for the two files?  Deutsch_bank could
>>>> have a blank Reference column added on conversion to csv, perhaps.
>>> Yes... DB can have a blank reference column. I can add this manually
>>> prior to convert to CSV. no problem.
>>>
>>>> f) What character code do you use?  ISO 8859-14?
>>> mmmh.. I think so.
>>>
>>> Thanks again!
>>>
>>> Jordi
>> Hi jordi
>>
>> Here's the script.  First of all, a couple of cautions.  When converting
>> to csv in Calc, would you make sure to use ';' (semi-colon) as field
>> separator.  This is to avoid confusion with the decimal separator.
>> (Haven't looked at sorting this via KDE Settings, so it's hard-coded
>> in).  Secondly, your caixaterrassa file includes Euro symbols, which I
>> delete in the script.    However, While they appear as Euro symbols in
>> xls in Calc, when I output the csv file from Calc, they're not, they're
>> either question mark/query, or some other symbol.  I've used that in the
>> script to delete them, which works OK, but you might need to check your
>> own csv file and see how it turns out in the qif.
>>
>> To check the output initially, ensure the script has execute permission,
>> then run as:-
>> ./csvbankingqif-ES.py < yourinputfile.csv > youroutputfile.qif
>>
>> If the csv and the qif files look OK, then go into KMM and set up a qif
>> profile - Tools/QIF Profile Editor, click on New, enter a profile name -
>> csvbank, or whatever, then select that profile on the left.  Then click
>> the Filter tab.  Enter the script name in the Input Filter Location, and
>> make the file type *.csv.  Then click OK.  Now, File/Import/QIF, browse
>> to and select your csv file, then select your new qif profile, and click
>> Import.
>>
>> All being well, your transactions should appear in whatever account you
>> select!.
>>
>> Let's know how you get on.
>>
>> Allan
>>
>
> Well... i get the script and test with deutsche bank first. I open it with calc
> and export to CSV with ; as field separation. Execute the script and nothing
> happens. I send you a screenshot. I don't know how to continue...
>
> With caixaterrassa happens something strange. Calc in Windows import it as
> Excel xls file, but Calc in ubuntu tries to import as simple text in Writer...
> I don't know why...
>
> some idea?
>
> Jordi
>

Hi Jordi

On your screen-shot first, you've entered
./csvbankingqif-ES.py yourinputfile.csv  youroutputfile.qif , but you've
missed out the re-direction symbols.  It should have been
./csvbankingqif-ES.py < yourinputfile.csv  > youroutputfile.qif as shown
above.

With db, I don't understand that.  On my Kubuntu PC, I clicked the xls
file, it asked if I wanted to open with Open Office spreadsheet, which I
did and it opened as expected.  I was then able to export to csv and
convert to qif.

I was also able to use gnumeric instead of OOO.  That exported to csv
too, although if you use that, you'll need to adjust the date format as
my script needs dd/mm/yy not yy/mm/dd.

allan




------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[marce-5]

O Xoves, 12 de Novembro de 2009 02:38:41 Fernando Vilas escribiu:
> I also have a Spanish <-> Gallego dictionary handy, if that bank is from
>  the other region that spells "caja" as "caixa". :-)

Just curiosity: How is it that you have a galician lang dictionary?


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[Fernando Vilas-2]

On Sunday 15 November 2009 14:05:53 marce wrote:
> O Xoves, 12 de Novembro de 2009 02:38:41 Fernando Vilas escribiu:
> > I also have a Spanish <-> Gallego dictionary handy, if that bank is from
> >  the other region that spells "caja" as "caixa". :-)
>
> Just curiosity: How is it that you have a galician lang dictionary?
>

I have some family in Vigo.  Last time I was there I saw that La Xunta was
trying to push the teaching of the language, so I picked up a couple of books
to help me learn a little.

--
Thanks,
Fernando Vilas
fvilas@...


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Camulus wrote:

>> On your screen-shot first, you've entered
>> ./csvbankingqif-ES.py yourinputfile.csv  youroutputfile.qif , but you've
>> missed out the re-direction symbols.  It should have been
>> ./csvbankingqif-ES.py < yourinputfile.csv  > youroutputfile.qif as shown
>> above.
>
> Perfect! it works perfect!!!
>
>> With db, I don't understand that.  On my Kubuntu PC, I clicked the xls
>> file, it asked if I wanted to open with Open Office spreadsheet, which I
>> did and it opened as expected.  I was then able to export to csv and
>> convert to qif.
>>
>> I was also able to use gnumeric instead of OOO.  That exported to csv
>> too, although if you use that, you'll need to adjust the date format as
>> my script needs dd/mm/yy not yy/mm/dd.
>
>  Try to do this but don't works. gnumeric exports as CSV with the char "," as
> a fiels separator so the script don't work. but if y save as ODF in gnumeric,
> after I can open with OO. funny isn't?
> So after all, caixaterrassa works too!!!
>
> thanks! thanks! thanks! How can i pay this help?
> Thanks a lot!!
>
> Jordi
>

Hi Jordi

Great!  We're there then.  I've just looked at gnumeric and there is
another option.  Save as Text (configurable) allows you to specify
numerous settings, including the separator.  We live and learn.

Glad I was able to do my bit to help.

allan

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Camulus wrote:

> A Dimarts 17 Novembre 2009 19:10:59, allan va escriure:
>> Camulus wrote:
>>>> I think we're missing something here in our languages!  What you said
>>>> earlier was ".... and the "Reference" field again in the first one (paga
>>>> a).  But, with DB bank the reference field is always blank, so paga a
>>>> and Details would be blank.
>>>>
>>>> Anyway, see if this is satisfactory for both banks.
>>>>
>>>> Allan
>>> jajaja.. yes, I think it's too difficult to get a common point if the two
>>> KMM are in different languages! Script works well but not as I want, so I
>>> send you 2 PNG to show it.
>>>
>>> CaixaTerrassa (kmmct.png): Looks perfect and it works perfect. In the
>>> first field I have Reference and in the third I hace Concept + Reference.
>>> It works well, very well.
>>>
>>> DeutscheBank (kmmdb.png): Not working. imports well but ALL (concept and
>>> reference) appears in the first field (Paga a) and I want the same but in
>>> the third field (Descripci).
>>>
>>> Hope it was easy to solve...
>>> thanks again,
>>>
>>> Jordi
>> Hi jordi
>>
>> That's good about CaixaTerrassa.  Let's hope this doesn't screw it up!
>>
>> For DB, as I said, Reference is empty, so you have only concept in Paga
>> a, and you want that also in Descripci.
>>
>> I think this should do it.
>>
>> Allan
>>
>
> THAT'S IT! PERFECT!!
> YOU HAVE SAVE ME A LOT OF TIME EVERYTIME I LOOK AT MY ACCOUNTS!!!
> THANK YOU, THANK YOU VERY MUCH!!!
>
> JORDI
>

Hi jordi

That's a relief!  Don't change banks for a while, though.

Allan

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[Jack-160]

> Hi jordi
>
> That's a relief!  Don't change banks for a while, though.
>
> Allan
>

Whenever I complain about my bank, I have friends who tell me how easy  
it is to change banks.  Now I have a real example proving it is NOT  
always so easy!  (I knew it myself, but this shows a potential problem  
that is probably not immediately obvious.)

Jack

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

[allan anderson]

Jack wrote:

>> Hi jordi
>>
>> That's a relief!  Don't change banks for a while, though.
>>
>> Allan
>>
>
> Whenever I complain about my bank, I have friends who tell me how easy  
> it is to change banks.  Now I have a real example proving it is NOT  
> always so easy!  (I knew it myself, but this shows a potential problem  
> that is probably not immediately obvious.)
>
> Jack
>

To me, statement download is now an important factor.  That's why I'm on
my third bank in one year!

Bank 1 Good service but QIF.
Bank 2 OFX, but they dropped it for CSV.
Bank 3 Back to OFX, all being well.

Allan

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer