El 13/10/20 a las 15:03, Dr Eberhard Lisse escribió:[...]
I find that logging on and downloading the files for processing reduced
my workload significantly.
For sure. And if there are an insane amount of formats it's ok.
Best.
Ah, resistant to advice as they say in German :-)-O
mapping files for csv2ofx (python) take 2-15 minutes to write and test,
I have about 10 or so of them, no drama whatsoever.
greetings, el
On 13/10/2020 16:01, gamo wrote:
El 13/10/20 a las 15:03, Dr Eberhard Lisse escribió:[...]
I find that logging on and downloading the files for processing reduced
my workload significantly.
For sure. And if there are an insane amount of formats it's ok.
Best.
El 14/10/20 a las 11:09, Dr Eberhard Lisse escribió:[...]
Ah, resistant to advice as they say in German :-)-O
mapping files for csv2ofx (python) take 2-15 minutes to write and test,
I have about 10 or so of them, no drama whatsoever.
greetings, el
Phyton? No need at all...
https://metacpan.org/search?q=OFX
5 hits, up to date.
Greetings.
Yes, of course, and I am using Finance::OFX::Parse::Simple but I can not
find an easy way of taking multiple CSV formats and generate OFX. That
is what the Python tool csv2ofx does, and it has "mapping" files for different CSV format which makes this easy.
But from the sound of things, you don't like easy :-0-O
el
On 14/10/2020 14:01, gamo wrote:
El 14/10/20 a las 11:09, Dr Eberhard Lisse escribió:[...]
Ah, resistant to advice as they say in German :-)-O
mapping files for csv2ofx (python) take 2-15 minutes to write and test,
I have about 10 or so of them, no drama whatsoever.
greetings, el
Phyton? No need at all...
https://metacpan.org/search?q=OFX
5 hits, up to date.
Greetings.
El 15/10/20 a las 13:06, Dr Eberhard Lisse escribió:[...]
Yes, of course, and I am using Finance::OFX::Parse::Simple but I can
not find an easy way of taking multiple CSV formats and generate OFX.
That is what the Python tool csv2ofx does, and it has "mapping" files
for different CSV format which makes this easy.
But from the sound of things, you don't like easy :-0-O
el
No, no, I do know nothing of OFX, but nearly for sure should not have
any problems with a CSV or what is denominted as CSV (not pure CSV
probably). So I could use one of the modules already avalaible.
That's what I would do, but I'm not the original poster and I have no problems doing anything manually.
It's a matter of taste. I enjoy Perl.
Greetings.
Of course there are my ways of making things more complicated than
necessary in Perl and there is almost nothing wrong with re0inventing
the wheel repeatedly :-)-O.
But I find that for the original question, slightly amplified, because
it surely is something that many people do, how to pull several bank statements from several banks, that there exist tools which can be
easily cobbled together even by an elderly Gynecologist dabbling in Perl which make this easy.
I would LOVE to see csv2ofx with easy mapping in Perl, by the way...
If it wasn't frowned upon by the banks one could even (try and) script
this to log in, pull the CSV, run it through csv2ofx (with its easy way
of "mapping" the CSV (needs to be done once)), and feed the resulting
OFX into whatever accounting package one fancies (many support OFX out
of the box), or put it into a database to play with R on the data.
My accounting package (SQL-Ledger) has a nasty API, but what is self isolation for in these times :-)-O
el
El 21/10/20 a las 10:50, Dr Eberhard Lisse escribió:
Of course there are my ways of making things more complicated than
necessary in Perl and there is almost nothing wrong with re0inventing
the wheel repeatedly :-)-O.
But I find that for the original question, slightly amplified, because
it surely is something that many people do, how to pull several bank
statements from several banks, that there exist tools which can be
easily cobbled together even by an elderly Gynecologist dabbling in Perl
which make this easy.
I would LOVE to see csv2ofx with easy mapping in Perl, by the way...
If it wasn't frowned upon by the banks one could even (try and) script
this to log in, pull the CSV, run it through csv2ofx (with its easy way
of "mapping" the CSV (needs to be done once)), and feed the resulting
OFX into whatever accounting package one fancies (many support OFX out
of the box), or put it into a database to play with R on the data.
My accounting package (SQL-Ledger) has a nasty API, but what is self
isolation for in these times :-)-O
el
Don't go that fast, doctor. If I could get the CSV file (which happens
to could not be a pure CSV, I repeat) I could manage in around 25 lines
to put the data in a perl data structure (an array, a hash) and that's
my short and simple lines style of code. I could be the dumbest Perl
user here. So been there, done that.
OFX is an interesting format concept, but I already have the data in
memory, so I could bypass that format. Why? Because you want to use an special accounting program to end up reading it in R to show fancy statistics. What statistics do you want? Miller-Orr? It must be too in
my web, in the sign. 8-)
It's not a problem of using Perl as an adiction, is that with not much
effort you could go directly to what you want. If it's a graph or
something like that and pretty print it, I would face a real problem of time-effort versus results that leads to use others software. I have
to admit that. But I like to disscuss.
Greetings.
In theory and in Usenet everything is possible including a finite state machine in TeX, but having a simple way to quickly plug in different CSV formats to generate a well known and widely used standard is helpful.
I have to parse CSV all the time, and some are so bad they would be
better called text files.
But not everybody is a Perl expert (and I most certainly am not).
If it is so easy, why don't you reverse engineer csv2ofx into a Perl
module? I for one would be very, very grateful to be able to make my
scripts less complicated.
el
OFX is an interesting format concept, but I already have the data in
memory, so I could bypass that format. Why? Because you want to use an special accounting program to end up reading it in R to show fancy statistics. What statistics do you want? Miller-Orr? It must be too in
my web, in the sign. 8-)
| Sysop: | Keyop |
|---|---|
| Location: | Huddersfield, West Yorkshire, UK |
| Users: | 715 |
| Nodes: | 16 (2 / 14) |
| Uptime: | 05:50:56 |
| Calls: | 12,100 |
| Calls today: | 8 |
| Files: | 15,003 |
| Messages: | 6,517,914 |
| Posted today: | 1 |