Can't use my CSV files from bank, how to convert QFX to QIF

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
April
New MMEX User
Posts: 1
Joined: Sat Dec 03, 2016 2:32 am
Are you a spam bot?: No

Can't use my CSV files from bank, how to convert QFX to QIF

Post by April »

My bank supplies CSV files that have the month in a 3 letter format rather than numbers so unless anyone can tell me how to use those I need to convert the QFX files that they can also supply into QIF files.  The only other download option for this bank is PDF, can that work?
spoker
New MMEX User
Posts: 14
Joined: Wed Nov 09, 2016 11:24 pm
Are you a spam bot?: No

Re: Can't use my CSV files from bank, how to convert QFX to

Post by spoker »

I don't think pdfs will work.

I would open the csv in excel, and replace name in letters by a number, save it again as csv and import it then.
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Can't use my CSV files from bank, how to convert QFX to

Post by Nikolay »

spoker wrote:I don't think pdfs will work.

I would open the csv in excel, and replace name in letters by a number, save it again as csv and import it then.
That is smart solution.

This issue looks like feature request.
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Can't use my CSV files from bank, how to convert QFX to

Post by Nikolay »

Another option is to set cells format for colunm after excel import of a csv file.
Then export it to csv again.

Code: Select all

10-ноя-2016;10.11.16;120;test;
11-ноя-2016;11.11.16;120;test;
12-ноя-2016;12.11.16;120;test;
Attachments
screenshot.307.jpg
screenshot.307.jpg (32.08 KiB) Viewed 2442 times
screenshot.305.jpg
screenshot.305.jpg (31.74 KiB) Viewed 2442 times
Post Reply