← Back to team overview

openerp-expert-accounting team mailing list archive

Re: OFX/CSV Bank statements

 

Brazil and USA uses OFX as a standard, and other latin america countries??
anyone know?




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


-- 

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

References