creating QIF file under Dos using AWK

[Edward Doolittle]

> And can I implement the perl script in GnuCash?

If I understand correctly, you're asking whether GnuCash will execute the
Perl script, or will facilitate the execution of the Perl script.  The
answer to that is almost surely "no", at least for normal users. "Power
users" might be able to do something with pycash, I guess.

For most of us, converting CSV to QIF would be part of a "workflow" that
would include manually downloading CSV from the bank, running the
conversion script, starting GnuCash, then manually importing the QIF. I
imagine some or all of that workflow could be automated with the
appropriate tool set, but the automation task is far from trivial. Aside
from the issue of assembling the tool set, there is the problem of dealing
with errors. What if the bank changes the format of the CSV file, changing
the headers? What if your disk is full at the file conversion stage? Etc.,
etc.  The problem is not even well-defined if you don't have documentation
for the bank's CSV format, so my advice to you would be to do the
conversion manually. I think there are similar arguments for doing all of
the steps in the workflow manually, but that's certainly a matter of
opinion.

On 21 March 2015 at 08:10, piggyb <piggybattery at gmail.com> wrote:

> Thank you for the attachment
>
> I was wondering if I used the field Payee correctly. I could not find a
> field for the account number so I use the account name, because clearer to
> read with the import.
> !Type:Bank
> !Account
> NAccountName
> ^
> !Type:Bank
> D31-12-2014
> T-30,12
> MGrandmother cake factory
> NAtem
> PG mam bakery
> AAdress
>
> Is there a field that I can use to store the bank number of grandmother's
> cake factory?
> And can I implement the perl script in GnuCash?
>
>
>
>
> --
> View this message in context:
> http://gnucash.1415818.n4.nabble.com/creating-QIF-file-under-Dos-using-AWK-tp4676673p4677084.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>



-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI