openerp-expert-accounting team mailing list archive

[Vinicius Dittgen <vinicius@xxxxxxxxxxxx>]

Rafael,

I know that using an ETL, especially Kettle with TerminatOOOR, we can have
much more flexibility, but we will have to support some basic operations
outside the framework. We have to think what is the best cost/benefit for
bank files.




2011/7/7 Raphael Valyi <rvalyi@xxxxxxxxx>

> Hello guys,
>
> a few considerations:
> we have experience with SEPA bank exports in France. Alexis de Lattre,
> tried to use th banking framework. The expected conclusion was that:
>
>    - for file generation it helps little as it's essentially custom logic
>    and custom templating involved.
>    - It could help for parsing file, may be.
>
> But, as for parsing files, at Akretion we tend do that extensively using
> the Kettle ETL along with the "TerminatOOOR" technology. With the latest
> changes we made in the kettle_connector module, integration with OpenERP is
> awesome.
> the benefits are:
>
>    - lot's of bullet-proof, documented file and parsing tools
>    - even a trainee can customize a import or export. Compare this to the
>    hacking expertise required to develop OpenERP modules... This is due to
>    documented standard tools from Kettle and the OOOR API that is much cleaner
>    and intuitive than the OpenERP one.
>    - despite all the standard tools, total flexibility is still possible
>    via the Ruby step if required
>    - error management is straightforward and long term logging is
>    efficient
>    - you get incredible network interoperability, for instance all the
>    following is achieved thanks to the integrated Apache VFS:
>    http://wiki.apache.org/commons/VfsCapabilitiesMatrix
>    http://commons.apache.org/vfs/filesystems.html  So importing the files
>    or exporting the files anywhere is just a snap.
>
> Hopefully we soon get enough time to document that technology better. Our
> 18 months old video doesn't make the cut obviously.
>
> Vinicius,
> for the Brazilian boletos specifically, our proposal is we generate them
> right inside OpenERP first so that it's easy for people to have something
> running where quasi-standards can be achieved. Not sure if the banking
> framework will help here or not, that should be studied. But I'm not very
> sure. Let's try to get in touch, we need to start this very soon as well.
> As for the bank file importation, on our side, we are likely to privilege
> the Kettle ETL as it will allow better system automation for our customer
> projects.
>
>
> --
> Raphaël Valyi
> Founder and consultant
> +55 21 3010 9965
> www.akretion.com
>
>
>
> On Thu, Jul 7, 2011 at 2:32 PM, Vinicius Dittgen <vinicius@xxxxxxxxxxxx>wrote:
>
>> Hi David,
>>
>>   Sorry i was very busy lately, yes we can do it together!! Let's create
>> project for that!!
>>
>>
>> Hi Stefan,
>>
>>   I saw your merge submit for V6, but the process hasnt been finished yet.
>> how it is now?? we can use it in production for V6??
>>
>>
>>
>>
>> 2011/6/19 David Mitchell <david@xxxxxxxxxxxxxxxxxx>
>>
>>> Hi Vinicius,
>>>
>>> I would reiterate Stefan's comments and suggestion versus modifying the
>>> account_coda module to make an account_ofx module.
>>> Their approach is more flexible.
>>>
>>> To my knowledge there hasn't been an OFX parser developed yet.
>>> We'd be happy to work with you on it - members of our team have
>>> written/participated in the creation of some of the global banking standard
>>> transaction sets - and a ton of banking software itself.
>>>
>>> We're looking forward to seeing the module on v6 as well.
>>> I don't believe any of the other US based partners have attacked this
>>> either at this stage.
>>>
>>> David Mitchell
>>> President
>>> NovaPoint Group LLC
>>> david@xxxxxxxxxxxxxxxxxx
>>>
>>> On Mon, Jun 6, 2011 at 9:11 AM, Vinicius Dittgen <vinicius@xxxxxxxxxxxx>wrote:
>>>
>>>> Hi accounting experts,
>>>>
>>>> We are looking for some module to import bank statements in OFX format, how do you guys deal with bank statements formats today? And for CSV format, you use just account_coda for that or have another way??
>>>>
>>>> We are planing to do a parser to load OFX statements, but we need to know if nobody has done it yet!
>>>>
>>>>
>>>> tks.
>>>>
>>>> --
>>>>
>>>> Att.:
>>>> --
>>>> Vinicius Dittgen
>>>> Proge Informática
>>>> Programas de Gestão Empresarialhttp://www.proge.com.br
>>>> Tel.:(51)3085 0096 Cel.:(51) 9193 2020
>>>> Skype: vdittgen
>>>> Canal IRC: #openerp-br
>>>>
>>>>
>>>>
>>>> Seja um voluntário
>>>> www.centrorepensar.com.br
>>>> Centro especializado em Deficiência Intelectual, Autismo, Síndrome de Down e Dificuldade de Aprendizagem
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~openerp-expert-accounting
>>>> Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~openerp-expert-accounting
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>
>>
>> --
>>
>> Att.:
>> --
>> Vinicius Dittgen
>> Proge Informática
>> Programas de Gestão Empresarialhttp://www.proge.com.br
>> Tel.:(51)3085 0096 Cel.:(51) 9193 2020
>> Skype: vdittgen
>> Canal IRC: #openerp-br
>>
>>
>>
>> Seja um voluntário
>> www.centrorepensar.com.br
>> Centro especializado em Deficiência Intelectual, Autismo, Síndrome de Down e Dificuldade de Aprendizagem
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~openerp-expert-accounting
>> Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~openerp-expert-accounting
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 

Att.:
-- 
Vinicius Dittgen
Proge Informática
Programas de Gestão Empresarialhttp://www.proge.com.br
Tel.:(51)3085 0096 Cel.:(51) 9193 2020
Skype: vdittgen
Canal IRC: #openerp-br



Seja um voluntário
www.centrorepensar.com.br
Centro especializado em Deficiência Intelectual, Autismo, Síndrome de
Down e Dificuldade de Aprendizagem