Database considerations

[Marcelo_Adamatti]

Hi Igor,

        Let me explain something about database:

·       I worked in software houses and isn’t a good practice use quotes (“”) in table and column names. It force the developer to use only the same case in SQL commands.

o       Another point is use quotes are not SQL ANSY. For example , to do the same in MS Access you need use [].

o       HSQLDB Manager (http://hsqldb.org/doc/guide/apf.html) not works with tables with quotes.

·       In table and column names: see research in www.nealford.com:

Compare:

§       testUpdateCacheAndVerifyThatItemExists

to

§       test_Update_cache_and_verify_that_item_exists

Be honest...which is more readable?

·       In DDL.SQL: The most common is use ALTER TABLE … FOREIGN KEY (http://hsqldb.org/doc/guide/ch09.html#alter_table-section) in final of file, outside table definitions. With this you can define table in any order. And is easier to see relationship.

o       About relationships: I will try create one ER diagram in http://ondras.praha12.net/sql. If you can describe each table, I appreciate =)

To resolve that’s problems without break the code, you can recreate the tables and create views to current structure. You can put the name of tables and columns in English too =). See sample:

CREATE CACHED TABLE INCOME_FORECAST  (

ID INTEGER,

ACCOUNT_TYPE VARCHAR,

INCOME_DATE DATE,

INCOME_VALUE DOUBLE,

PRIMARY KEY (ID, ACCOUNT, INVOME_DATE)

); 

CREATE VIEW "PrevisaoRendimento"  as

Select

ID as "Id",

ACCOUNT_TYPE  as "TipoConta",

INCOME_DATE  as "DataRendimento",

INCOME_VALUE  as "ValorRendimento"

From INCOME_FORECAST;

        What do you think about that?

[]s

Marcelo Adamatti
http://adamatti.googlepages.com

http://adamatti.blogspot.com

http://code.google.com/p/fumigant

-------------------------------------------------------------------------
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 Igor,

        Thanks for the tables description!
        Are security items disable for now? What is your plans for it?
        Could you tell me more about forecast functionality?
        Are "LancamentoPendente" table only a temporary table?
        Have MapeamentoDeImportacaoPorHistorico functionality like Ms
Access import mappings?

[]s

Marcelo Adamatti

-------------------------------------------------------------------------
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

[igor4java-gfp]

Hi Marcelo!

The Brasilia weather is dry! Ouch! How is the weather
down there? Hey, Have I told you that there are many
people from RS here? From every where!

About your questions:
Yes security items are disable. Need time ti implement
it. I believe that an encryption feature is more
important than access level control.
I have been working on these features for GFP 0.9.0
and finishing the 0.8.0 release (only fix the OFX and
OFC importing feature are pending) that is in RC3 by
now.
As you may see on GFP history the projects was quite
active until February, so my second soon born and on
May I suffer a surgery to remove a cancer, since these
I slow down the GFP project to enjoy my life :-)
Past Thursday I released the 0.8.0-RC3 with some bug
fixes and small changes.
You can see the next release features on project page
tracker; as well as a bug list.

The "LancamentoPendente" may be a temporary table, it
depends when user will make the temp transactions
(that are stored on this table) definitive or not. It
depends of conciliation. Then content of this table
will be shown only when user import data from external
data sources.

Sorry, but I don't know how MS Access importing
mapping works, there are some years that I don't use
MS Office and rarely I touch a Windows computer :-p.
I will try to explain:
When you import data from your banking OFC/OFX file
(or other source; there are usually a memo field (like
a transaction description). In Bank of Brazil write
there then place where user make that transaction and
the time. Something like:
"Compra cartão débito - Extra Hipermercados -
20/08/2007 as 17:15"
Every negative value GFP treats as a expense (the type
of transaction). and store this transaction on
"LancamentoPendente" table and store a piece of this
memo on MapeamentoDeImportacaoPorHistorico classifying
as expense. Expenses has subtypes, one of then may be
"Groceries Expenses" and you may want to classify this
transaction in such a way. You go on "Config Mappings
Window" and select the already registered memo and
change it from "Expense" to "Groceries Expenses", so
for future imported data GFP will treat every
transaction that contain "Compra cartão débito - Extra
Hipermercados" as "Groceries Expenses" instead of
"Expenses".

Regards,
Igor Regis


--- Marcelo_Adamatti@... escreveu:

> Hi Igor,
>
> Thanks for the tables description!
> Are security items disable for now? What is your
> plans for it?
> Could you tell me more about forecast
> functionality?
> Are "LancamentoPendente" table only a temporary
> table?
> Have MapeamentoDeImportacaoPorHistorico
> functionality like Ms
> Access import mappings?
>
> []s
>
> Marcelo Adamatti
>

      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

[igor4java-gfp]

HI again!

> Ok, but using views you will not  break anything.

Yes, but its better to change the database
definitively.

> May be change
> the "personal file" (.gfp) to xml file would be a
> good choice, to don't
> worry with structure. For example when you start the
> application, load
> the xml to new database.
> In the future you can integrate with Spesa
> (http://www.spesa.com.br/) or Money Log
> (http://aurelio.net/web/moneylog.html) =)
>

Every time you load a finance file, parse a huge xml
and insert the data to a database? wouldn't it be slow
for a file with thousands transactions? And every save
you would need to load database data and convert to
xml.
Some Open Source app that began with a xml file move
or start to move to database.
Example: JGnash. Curiously they added many features to
this software just after GFP show up with that
feature, like the DB use and field auto completion.

> If you want people to help, it is very important can
use database tools. Developers needs this =)

So Squirrel is a good choice.

> Hum... one challenge? Hehehe I will try do that.
> Maybe replace GFPController class to Spring
> framework...

Could be :-) If Hibernate keeps the performance it
would be a great improvement. Of course using JPA
(Annotations), not XML.

> I don't think so...
> Ok, I created "a copy of Middlegen"
> (http://fumigant.googlecode.com), one web server
> using nanoHTTP +
> nanoXML, one jme dictionary... it is good to
> understand architecture.
> But I prefer don't recreate the wheel
(http://www.aguinelopedroso.com/index.php/2007/04/29/use-convencoes-nao-
> reinvente-a-roda/, in Portuguese).
> Working with a team, you need know tools/frameworks
> and use it.
> Is more easy search help in another tools =)
> For example: Fumigant VS Greenbox. Exists one big
> team developing Greenbox... I only me writing
Fumigant.
> What will have more
> releases, docs and functionalities?

I'm not against the framework use, I use a lot of them
in my work daily, they save development time, save
money to keep the software working, but when we need
performance we by pass the framework to get speed. I
mean that sometimes you need to make your own solution
to achieve your goal, and sometimes you simply don't
need to use the framework because the problem is too
simple that the framework would make it look like a
big problem.
In GFP, some of the code began to be written 7 years
ago, in that year the news were Java 2 :-), of course
these piece of codes suffered refactoring (a la Martin
Fowler) to evolve without break (I love refactoring),
on that time GFP ran in OS/2 stations that support
only JRE up to 1.3.
I would love to have time to make another refactoring
on GFP to make it use hibernate BUT Users need some
improvement, like a working OFX importing tool :-)

> Why you didn't use Log4J?

The question is: Do I need Log4J?

> One suggestion: Use one presenter tool to create
> helps, like
>
http://code.google.com/p/fumigant/wiki/ExemplosUso.See:
>
> * http://www.adobe.com/products/captivate
> * http://www.techsmith.com/camtasia.asp
> * http://www.debugmode.com/wink/ (free)

It would be greate!
My big problem isn't the help format/formatter, the
problem is find out time to write the content :-)



      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

[igor4java-gfp]

I see that you are taking a overview of GFP code, but
I have one advise: Try to keep your mind focused in
one task at time. You could make a wish list, so we
rank then to make a time line.


      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 Igor,

>> The Brasilia weather is dry! Ouch! How is the weather down there?

        Is cold and raining here by now.

>> Hey, Have I told you that there are many people from RS here? From
every where!

        Cool. "We will dominate the Country" =)
        There are many people from another states here too.

>> Yes security items are disable. Need time ti implement it. I believe
that an encryption feature is more important than access level control.
>> I have been working on these features for GFP 0.9.0 and finishing the
0.8.0 release (only fix the OFX and OFC importing feature are pending)
that is in RC3 by now.

        Hum... I saw user table and thought in GFP multi user...
        Is very cool use aspect to control security. What do you think
about that?

>> You can see the next release features on project page tracker; as
well as a bug list.

        I will look that, tks!

>> Sorry, but I don't know how MS Access importing mapping works, there
are some years that I don't use MS Office and rarely I touch a Windows
computer :-p.

        Are you using linux or mac? I don't like windows but I need work
in this OS.

>>> ... MapeamentoDeImportacaoPorHistorico...
       
        Hum... This table works like a replace category when import some
data. Ok, I got it now.
------------------------------------------------------------------------
----------------------------------
        Another questions:
* Why you implemented a class loader? I prefer use class path and search
class with some annotation...
* Why you create one class for each file in
br.com.gfp.internationalization package?


[]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]

Hello Igor,

>> Yes, but its better to change the database definitively.

        I agree.

>> Every time you load a finance file, parse a huge xml and insert the
data to a database? wouldn't it be slow for a file with thousands
transactions?
>> And every save you would need to load database data and convert to
xml.

        Is a personal file, wouldn't to be slow... And with this you
don't need store system tables (banks for example) in xml file.
        I will try do that. I am doing big changes in my sand box =)

>> Some Open Source app that began with a xml file move or start to move
to database.
>> Example: JGnash. Curiously they added many features to this software
just after GFP show up with that feature, like the DB use and field auto
completion.

        Hehehe

>> So Squirrel is a good choice.

        Ok... you win =)
        But the default tool to work with HSQLDB is a DatabaseManager

>> Could be :-) If Hibernate keeps the performance it would be a great
improvement. Of course using JPA (Annotations), not XML.

        I don't like xml to configurations. But is very good idea to
transport data.

>> I'm not against the framework use, I use a lot of them in my work
daily, they save development time, save money to keep the software
working, but when we need
>> performance we by pass the framework to get speed. I mean that
sometimes you need to make your own solution to achieve your goal, and
sometimes you simply don't
>> need to use the framework because the problem is too simple that the
framework would make it look like a big problem.

        I not agree. Others peoples having same problems and frameworks
comes to resolve it.

>> In GFP, some of the code began to be written 7 years ago, in that
year the news were Java 2 :-), of course these piece of codes suffered
>> refactoring (a la Martin Fowler) to evolve without break (I love
refactoring), on that time GFP ran in OS/2 stations that support only
JRE up to 1.3.

        I forgive you =) hehehe

>> I would love to have time to make another refactoring on GFP to make
it use hibernate BUT Users need some improvement, like a working OFX
importing tool :-)

        I agree. I am studding GFP to do that with HSBC file... and
commenting about architecture =)

>> The question is: Do I need Log4J?

        Maybe use commons loggings framework. That's cool to control log
outside the application, like change level (debug/warning/error)..

>> It would be greate! My big problem isn't the help format/formatter,
the problem is find out time to write the content :-)

        Using a presenter tool you only need use system and describe
some screens... or record a voice =)


[]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

[igor4java-gfp]

Good morning,

> Hum... I saw user table and thought in GFP multi
> user... Is very cool use aspect to control security.

> What do you think about that?

Oh yes, I like AP, is interesting.
There are a new guy (my neighbor), that proposed to
implement an encryption layer integrated with GFP
persistence layer by using annotations to tag fields
that need encryption (he will do it for his monograph
prove of concept), lets see if it will work fine.

>Are you using linux or mac? I don't like windows
> but I need work in this OS.

I use OpenSuSe Linux, even at work. I really don't
need to use windows as many of the user base for the
system I'm responsible use Linux on their work
station. Of course I test the system on Windows Labs,
you know java "Code once, debug everywhere", but when
I deal with the web app I don't mind about the user
OS, as they all use FireFox.


> Another questions:
> * Why you implemented a class loader? I prefer use
> class path and search
> class with some annotation...

Using a custom class loader user can add plugins to
GFP without having to change the classpath and without
restart GFP to load that plugin. I can treat multiple
files as one transparently to the application.

> * Why you create one class for each file in
> br.com.gfp.internationalization package?

That's something that I have asking me for the last
months. I believe that was some kind of precaution,
but until know I see no reason. Even the use of many
files for translation stuff, sometimes I think that
would be better to have only one.

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

[igor4java-gfp]

>Is a personal file, wouldn't to be slow... And with
> this you don't need store system tables (banks for
example)
> in xml file. I will try do that. I am doing big
changes in my
> sand box =)

My personal file have about 15.000 transactions
registered, this mean that a XML file would have 1.5MB
of data. I'm not considering the data from other
tables as they don't "grow up" like the transaction
table.
If you will do some tests don't forget the scalability
for big files.

>I not agree. Others peoples having same problems
> and frameworks comes to resolve it.

The problem is that when I have big problems, they are
indeed more than big... In a talk with oracle
consulting team they asked how big is the user base
that we were planing for their system, so we mention
that, just to start, we would like to make a pilot
with 100.000 users that would use the system
intensively and they got scared :-) and asked for time
to think about it.

>I agree. I am studding GFP to do that with HSBC
> file... and commenting about architecture =)

I am likening this talk, its useful and make me revise
GFP architecture.

> >> The question is: Do I need Log4J?
>
>Maybe use commons loggings framework. That's cool
> to control log outside the application, like change
level
> (debug/warning/error)..

About log level, they are unnecessary, the GFP log
politic is to log only the necessary things, like
stack trace and relevant messages about user
environment. When GFP users ask for help, they
typically and to solve the problem in one shot, they
don't want exchange many messages. So I take care to
have enough info on log files when its needed, but
only what is needed.
The GFP on line support plugin automatically attach a
log file for each user request. And I receive a e-mail
notification when a user make a request (See on GFP
Help Menu).

>Using a presenter tool you only need use system and
> describe
>some screens... or record a voice =)

I Chinese site made something like that to GFP but
with tips in simplified Chinese.


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

[José Gabriel Moya Yangüela]

HI All.

I guess you've noticed the big spam traffic in this list in august. I
can't imagine how that get full of spam, but now I have to unsubscribe
from the list in order to get rid of all this spam. It means that i'm
going to abandon igor's project. I had almost abandoned it, indeed.

Igor, I hope you have some other Spanish translator... If you don't
have one, contact me by other means -- maybe from your personal email
instead listed one.

Yours,

José Moya.

2007/9/3, igor4java-gfp@... <igor4java-gfp@...>:

> >Is a personal file, wouldn't to be slow... And with
> > this you don't need store system tables (banks for
> example)
> > in xml file. I will try do that. I am doing big
> changes in my
> > sand box =)
>
> My personal file have about 15.000 transactions
> registered, this mean that a XML file would have 1.5MB
> of data. I'm not considering the data from other
> tables as they don't "grow up" like the transaction
> table.
> If you will do some tests don't forget the scalability
> for big files.
>
> >I not agree. Others peoples having same problems
> > and frameworks comes to resolve it.
>
> The problem is that when I have big problems, they are
> indeed more than big... In a talk with oracle
> consulting team they asked how big is the user base
> that we were planing for their system, so we mention
> that, just to start, we would like to make a pilot
> with 100.000 users that would use the system
> intensively and they got scared :-) and asked for time
> to think about it.
>
> >I agree. I am studding GFP to do that with HSBC
> > file... and commenting about architecture =)
>
> I am likening this talk, its useful and make me revise
> GFP architecture.
>
> > >> The question is: Do I need Log4J?
> >
> >Maybe use commons loggings framework. That's cool
> > to control log outside the application, like change
> level
> > (debug/warning/error)..
>
> About log level, they are unnecessary, the GFP log
> politic is to log only the necessary things, like
> stack trace and relevant messages about user
> environment. When GFP users ask for help, they
> typically and to solve the problem in one shot, they
> don't want exchange many messages. So I take care to
> have enough info on log files when its needed, but
> only what is needed.
> The GFP on line support plugin automatically attach a
> log file for each user request. And I receive a e-mail
> notification when a user make a request (See on GFP
> Help Menu).
>
> >Using a presenter tool you only need use system and
> > describe
> >some screens... or record a voice =)
>
> I Chinese site made something like that to GFP but
> with tips in simplified Chinese.
>
>
> 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
>

--
Tengo poco tiempo para leer. Compré estos libros a peso. Ordené que me
trajeran una tonelada.

-------------------------------------------------------------------------
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 Igor,


        Sorry for my English. I am revising my texts and I did big
errors =)

>> My personal file have about 15.000 transactions registered, this mean
that a XML file would have 1.5MB of data. I'm not considering the
>> data from other tables as they don't "grow up" like the transaction
table. If you will do some tests don't forget the scalability for big
files.

        I had 37 transactions by month (avg). 444 transactions by year.
4440 transaction in 10 years. It is too small buts ok, I will use big
files.

>> The problem is that when I have big problems, they are indeed more
than big... In a talk with oracle consulting team they asked how big is
the user
>> base that we were planing for their system, so we mention that, just
to start, we would like to make a pilot with 100.000 users that would
use
>> the system intensively and they got scared :-) and asked for time to
think about it.

        It is interesting...

>> I am likening this talk, its useful and make me revise GFP
architecture.

        Cool. Some people don't like it =)

>> About log level, they are unnecessary, the GFP log politic is to log
only the necessary things, like stack trace and relevant messages about
user
>> environment. When GFP users ask for help, they typically and to solve
the problem in one shot, they don't want exchange many messages. So I
>> take care to have enough info on log files when its needed, but only
what is needed.

        I would like to see debug messages to know the flow... I am not
thinking in the user now, but in dev team... Do you can turn off log
today?

>> The GFP on line support plugin automatically attach a log file for
each user request. And I receive a e-mail notification when a user make
a
>> request (See on GFP Help Menu).

        Ok, I will look that.

>> I Chinese site made something like that to GFP but with tips in
simplified Chinese.

        Do you have the link for that?


[]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

[igor4java-gfp]

Hi!

> Sorry for my English. I am revising my texts and I
> did big errors =)

I'm sure a make more misspelling errors than you.

> I would like to see debug messages to know the
> flow... I am not
> thinking in the user now, but in dev team... Do you
> can turn off log today?

Ok, You make me think about it :-)

> Do you have the link for that?

http://www.opensourceinstall.org/index.php?tab=1#GFP
I remember that I needed to register, its a nice
challenge to register in a Chinese site :-)

There is a Italian magazine that publicized a small
article about GFP. You can find a link to it in GFP
Web site.

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]

Hi Igor,

        I am doing big changes in my sand box. For example, I am
replacing SimpleLog class to common Logger. I found little pieces
calling logging...
        I removed the security, DBMigrator (I am doing tests with XML
files), SevenZip to class path... I believe you will not like this =)
        I found connection pool implementation.... why? Aren't GFP
stand-alone? Why you didn't use DBConnectionBroker Framework? Tsc tsc...
You don't like use frameworks =)
        http://gfd.cvs.sourceforge.net/gfd/GFP%20Unit%20Tests/ - Do you
have updated tests?
        I found image compressors and SubtitleUtils too
http://gfd.cvs.sourceforge.net/gfd/Utilitarios/br/com/igor/uteis/ =)
        In my OFC case with HSBC:  Can I create PendingTransaction List
and call ImportUtils.conciliate only?
        I not found any Junit... I like JUnit... :-(

[]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

[igor4java-gfp]

Hi Marcelo,

>I removed the security, DBMigrator (I am doing
> tests with XML files),

   1 - We will see the performance.
   2 - So you will need a "XMLFileMigrator" to control
file layout changes.

>SevenZip to class path...

    What do you mean ? It's already on the class path.

>I believe you will not like this =)

That's my guess too :-p

> I found connection pool implementation.... why?
> Aren't GFP
> stand-alone? Why you didn't use DBConnectionBroker
> Framework? Tsc tsc...

 Long history, at the beginning (5 years ago) I was
making testing with multiple clients, I gave up and
the pool was just left behind (the old free time
problem). I don't mind to remove it.

> You don't like use frameworks =)

It's a "play for fun" project the goal was to
experiment new things and not to do boring work :-)

>http://gfd.cvs.sourceforge.net/gfd/GFP%20Unit%20Tests/
> - Do you
> have updated tests?

Oh yes! I need time to implement JUnit test cases...

>I found image compressors and SubtitleUtils too
>http://gfd.cvs.sourceforge.net/gfd/Utilitarios/br/com/igor/uteis/
> =)

Oh! Personal stuff. Not really personal you see :-)

>In my OFC case with HSBC:  Can I create
>PendingTransaction List and call
>ImportUtils.conciliate only?

You shouldn't need to do it. Once the import action
work again (I mean with the XML file - I am adapting
it to read the resulting file that your converser
created)
this action should be able to load OFCfiles from both
banks.

>I not found any Junit... I like JUnit... :-(

Yes you know the time problem stuff...



      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

[igor4java-gfp]

Hi,

I have changed GFP to use the your "Conversor" class.
It will use a lightly different implementation to
convert OFX files. I have test it with BB files,
please test if you can import now HSBC files.

Download it here:
http://gfd.sourceforge.net/gfp_0.8.0-RC4.zip

I will remove this file from this site in 2 days.

[]'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 Igor,

>> 1 - We will see the performance. 2 - So you will need a
"XMLFileMigrator" to control file layout changes.

        Ok ok... Please, wait for the results =)

>> SevenZip to class path...
>> What do you mean ? It's already on the class path.

        I removed this package for now... I don't know, but the GFP is
working without SevenZip.

>> I believe you will not like this =)
>> That's my guess too :-p

        Hehehe.
        I am changing to my personal use. I not want force anything.
        I would create a personal financial manager, but I prefer use
GFP. I am only play with the code =)

>>  I found connection pool implementation.... why? Aren't GFP
stand-alone? Why you didn't use DBConnectionBroker Framework? Tsc tsc...
>> Long history, at the beginning (5 years ago) I was making testing
with multiple clients, I gave up and the pool was just left behind
>> (the old free time problem). I don't mind to remove it.

        Ok, no problem.

>> It's a "play for fun" project the goal was to experiment new things
and not to do boring work :-)

        I know that. I am doing the same. But with frameworks =)

>> Oh yes! I need time to implement JUnit test cases...

        I am including logs to trace the functionalities. Would be good
if I could run test to see if I don't break anything.

>>In my OFC case with HSBC:  Can I create PendingTransaction List and
call ImportUtils.conciliate only?
>> You shouldn't need to do it. Once the import action work again (I
mean with the XML file - I am adapting
>> it to read the resulting file that your converser created) this
action should be able to load OFCfiles from both banks.

        Ok, I'll waiting for that.

        So, it's me again: I don't like classes names started with "I"
(Ex: IMenuBar). I thought the file was a Interface, but was a Class.

[]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

[igor4java-gfp]

>Ok ok... Please, wait for the results =)

I am :-P

>I removed this package for now... I don't know, but
> the GFP is working without SevenZip.

Yes it works, but as you probably noticed GFP download
file has about 2.5MB but the sum of all jar files has
about 10MB (look at ext folder). SevenZip (Or LZMA
algorithm) is used by GFP on the first start up after
setup to deflate the files that are also packed
(pack200). thats why SevenZip is inside the gfd.jar
that has the only feature uncompress GFP jar files, if
necessary, before to start up GFP.

>I am changing to my personal use. I not want force
> anything.
>I would create a personal financial manager, but I
> prefer use GFP. I am only play with the code =)

Its good! I hope you have a lot of fun! :-) Don't
forget to show me your changes, so I could see what
would be part of GFP code (with your respective
copyright notice, of course).

>I know that. I am doing the same. But with
> frameworks =)

Okie Dokie!

>So, it's me again: I don't like classes names
> started with "I"
> (Ex: IMenuBar). I thought the file was a Interface,
> but was a Class.

It's my bad behavior again :-), but be aware,
remember: You can't judge a book by its cover! :-)

[]'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]

>> Ok ok... Please, wait for the results =)
>> I am :-P

        I will try send you in Monday. I am playing with the code =)

>> Yes it works, but as you probably noticed GFP download file has about
2.5MB but the sum of all jar files has about 10MB (look at ext folder).
>> SevenZip (Or LZMA algorithm) is used by GFP on the first start up
after setup to deflate the files that are also packed (pack200). thats
why
>> SevenZip is inside the gfd.jar that has the only feature uncompress
GFP jar files, if necessary, before to start up GFP.

        hum.. I will revise that point.

>> Its good! I hope you have a lot of fun! :-) Don't forget to show me
your changes, so I could see what would be part
>> of GFP code (with your respective copyright notice, of course).

        Cool. I will do that.

>> It's my bad behavior again :-), but be aware, remember: You can't
judge a book by its cover! :-)

        No problem. Just remember...

[]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