Script for basic CSV to QIF conversion

whwtan whwtan at hotmail.com
Fri Mar 6 22:45:03 EST 2015


Sorry John,

I forgot to mention:
Thank you for the script.

On 5/3/2015 4:29 AM, John Mason wrote:
> Simple Bash script to convert from CSV to QIF. I use it, figured 
> someone else might want to try it to see if it helps them with 
> transaction imports.
>
> Filename: mkqif.sh
> Type: Ascii text (BASH Script)
> Original Author: John A. Mason
> Purpose: Simply create a CSV file (comma separated text) any way you 
> wish. Then make it match the template formula (you can get a copy of 
> the template to see some examples and instructions by using the -x 
> command-line parameter). Then run mkqif on that csv file to create a 
> QIF file for importing into gnucash. (My version is 1.2.6.1-2)
>
> Features:
>     fault-tolerant about values in fields
>     Multiple options depending on how your bank provides CSV or just 
> copy/paste to CSV
>     Supports auto-account classifications (can assign transactions 
> to/from particular accounts from csv)
>     Supports split transactions from CSV (see template.csv for 
> details.... -x CLI parameter)
>     Built-in Help option (mkqif -h will show basic help, mkqif -x will 
> show detailed help within the template.csv)
>
> License: Don't care, just leave my original author line alone and do 
> what you will with the rest.
>
> Hope this helps someone.
>
>
> _______________________________________________
> 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.



More information about the gnucash-user mailing list