Database considerations

[igor4java-gfp]

Hi Marcelo

>Cool. My first contribution =)
 
Yes! :-p
 
>The "Conversor" was a draft. It needs adjustments...
 
 Yes I see but don't worry... perform incremental
 refractory(don't forget to do this).
 
>Have OFX the same structure of OFC?
 
 Yes. OFX is SGML and has much more features, but its
 still based on OFC. Both have Microsoft behind the
 scenes, just because of MSMoney. OFX specification
 has
 about 500 pages :-p. They offer support for on-line
 transaction, this kind of feature the Brazilian Bank
 probably will never support.
 
 Try download it with this name extension:
 http://gfd.sourceforge.net/gfp_0.8.0-RC4.cpt
 I have just discovered that SF don't allow you to
 pĺace zip files for download at WEB servers. So
 rename it to zip.
 
 Continuing our conversation about file size, you
 mentioned you transaction volume, I see you probably
 are Single and don't have children. Don't measure
 average usage considering only your profile. A
 family
 with 4 people (Man, Woman and 2 children) will spend
 more money and perform much more transactions. If
 you
 use to save your money on DI referenced savings
 (Brazilian only) GFP will need to keep a daily
 control
  of your return over the amount of investment.
 
 I will explain in portuguese since DI exist (with
 this
 behavior only in Brazil):
 DI = Referenciado DI (de rendimento diário),
 portanto
 tem saldo calculado diariamente, gerando pelo menos
 20
 transações por mês para a aplicação.
 
 []'s Igor Regis




      Flickr agora em português. Você clica, todo mundo vê.
http://www.flickr.com.br/

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
gfd-developers mailing list
gfd-developers@...
https://lists.sourceforge.net/lists/listinfo/gfd-developers

[Marcelo_Adamatti]

Hi,


>The "Conversor" was a draft. It needs adjustments...
>> Yes I see but don't worry... perform incremental refractory(don't forget to do this).

        I tested the RC04 but I got a NullPointerException... See log attached.
        The temp file is a valid XML file.
        In the future we can change the parser to don't use temp file (see "conversor" code ).

>> Yes. OFX is SGML and has much more features, but its still based on OFC. Both have Microsoft behind the scenes, just because of MSMoney.
>> OFX specification has about 500 pages :-p. They offer support for on-line transaction, this kind of feature the Brazilian Bank probably will never support.

        I only need a OFC =)

>> Continuing our conversation about file size, you mentioned you transaction volume, I see you probably are Single and don't have children. Don't measure
>> average usage considering only your profile. A family with 4 people (Man, Woman and 2 children) will spend more money and perform much more transactions. If you
>> use to save your money on DI referenced savings  (Brazilian only) GFP will need to keep a daily control  of your return over the amount of investment.

        I got that now. Thanks for your explanation.

>> I will explain in portuguese since DI exist (with this behavior only in Brazil):
>> DI = Referenciado DI (de rendimento diário), portanto tem saldo calculado diariamente, gerando pelo menos 20 transações por mês para a aplicação.

        I don't have investment for now :-(


[]s

Marcelo Adamatti
http://adamatti.googlepages.com
http://adamatti.blogspot.com
http://fumigant.googlecode.com/




-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
gfd-developers mailing list
gfd-developers@...
https://lists.sourceforge.net/lists/listinfo/gfd-developers

[Marcelo_Adamatti]

Try import that sample file.

[]s

Marcelo Adamatti
http://adamatti.googlepages.com
http://adamatti.blogspot.com
http://fumigant.googlecode.com/


-----Original Message-----
From: Adamatti, Marcelo
Sent: Thursday, September 06, 2007 2:21 PM
To: 'igor4java-gfp@...'
Cc: 'gfd-developers@...'
Subject: RE: [Gfd-developers] Database considerations

Hi,


>The "Conversor" was a draft. It needs adjustments...
>> Yes I see but don't worry... perform incremental refractory(don't forget to do this).

        I tested the RC04 but I got a NullPointerException... See log attached.
        The temp file is a valid XML file.
        In the future we can change the parser to don't use temp file (see "conversor" code ).

>> Yes. OFX is SGML and has much more features, but its still based on OFC. Both have Microsoft behind the scenes, just because of MSMoney.
>> OFX specification has about 500 pages :-p. They offer support for on-line transaction, this kind of feature the Brazilian Bank probably will never support.

        I only need a OFC =)

>> Continuing our conversation about file size, you mentioned you
>> transaction volume, I see you probably are Single and don't have
>> children. Don't measure average usage considering only your profile. A family with 4 people (Man, Woman and 2 children) will spend more money and perform much more transactions. If you use to save your money on DI referenced savings  (Brazilian only) GFP will need to keep a daily control  of your return over the amount of investment.

        I got that now. Thanks for your explanation.

>> I will explain in portuguese since DI exist (with this behavior only in Brazil):
>> DI = Referenciado DI (de rendimento diário), portanto tem saldo calculado diariamente, gerando pelo menos 20 transações por mês para a aplicação.

        I don't have investment for now :-(


[]s

Marcelo Adamatti
http://adamatti.googlepages.com
http://adamatti.blogspot.com
http://fumigant.googlecode.com/




-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
gfd-developers mailing list
gfd-developers@...
https://lists.sourceforge.net/lists/listinfo/gfd-developers

[Marcelo_Adamatti]

But HSBC OFC file have other tags with bank information... Try use one of these informations.

[]s

Marcelo Adamatti


-----Original Message-----
From: igor4java-gfp@... [mailto:igor4java-gfp@...]
Sent: Thursday, September 06, 2007 2:50 PM
To: Adamatti, Marcelo
Subject: RE: [Gfd-developers] Database considerations

The NullPointerException happens because HSBC don't
write the BRANCHID field (Numero da Agencia). I will
prevent it and check for null values before loading
that data.

You sample file help on that analysis. Thanks.

I will need to do another rebuild...

Regards,
Igor Regis


      Flickr agora em português. Você clica, todo mundo vê.
http://www.flickr.com.br/

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
gfd-developers mailing list
gfd-developers@...
https://lists.sourceforge.net/lists/listinfo/gfd-developers

[Marcelo_Adamatti]

>> The Smaple file you sent to me have only these tags on bankform:
>> <BANKID>000
>> <ACCTID>00000000000
>> <ACCTTYPE>0

        In HSBC file (bankid = 399) the BRANCHID is ACCTID.substr(1,4)

>> I will keep prompting the user to select the account destination for
that transactions that came from the file.

        I will convert my Visa transactions to HSBC OFC file and import
too =)

>> And really thank you for your contribution! I was needing someone to
help me with this feature to me it work with any bank.

        Thank you for GFP =)
        I am only adapting GFP to my use.

>> You can download it from the project page.

        Did you change another file? I changed GFP in my sand box and
don't like forgot changes.

>> I have posted news on GFP Web Site thanking you for your
contribution, I near to make a stable release.

        Thanks! Could you please link my name to my blog
(http://adamatti.blogspot.com)? It is good to Google page rank =)


[]s

Marcelo Adamatti
http://adamatti.googlepages.com
http://adamatti.blogspot.com
http://fumigant.googlecode.com/



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
gfd-developers mailing list
gfd-developers@...
https://lists.sourceforge.net/lists/listinfo/gfd-developers