Discover does not offer the download option of .ofx (Open financial exchange) format and etc

[Olga Topitges]

My first time posting, if I'm not doing this right, I apologize.  

I found out today that they only options for Discover offers for downloads of Transactions on their card are Excel, CSV or PDF.  I have been using OFX (Open Financial Exchange)

What can I do now, or do I not use Discover.

Thanks

Olga

[Doris Tomlin]

Oh that's bad news! I haven't used my Discover Card recently, but I used to be able to export/download my transactions in .QFX format and just change the file extension from .qfx to .ofx . That used to work fine. The last download I did like that was on May 10 of 2022.
I just logged into my DiscoverCard account and I see the option to download to QFX is gone. 

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/f5ae4cfa-d35b-4fcc-99ab-95f394c3d1f9n%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Robert Jacobson (bobjbkln)]

You'll have to enter the data manually.

[Patrick Sewell]

I have been using an application called CSV2OFX.  This works well to convert the CSV files, downloaded from my bank, to OFX files for Money.  It appears that the program has been improved and is now called Transactions.  The site is https://www.propersoft.net/products/transactions.  I set my windows environment to automatically open CSV files with this application.  Then I just select the account and hit convert.  Sends it right to MS Money.

[Doris Tomlin]

That Transactions software seems pretty pricey: 

$19.99 / month

$119.99 / year

$199.99 lifetime, with 24 months of "support"

😬

I'm guessing that you don't/didn't spend that much on your CSV2OFX application. 

[joe dempsey]

There are a couple of free tools if you search

Otherwise, if you adept at Excel macros, it is easy enough to program your own CSV to QIF converter

[Patrick Sewell]

You're correct.  I paid $40 in June of 2020.  However, I would pay the $200 today.  Compared to the alternatives (Quickbooks et al), that isn't too bad for a one time fix.

[Matt Petersen]

Discover did this once in the past and after a while, they re-instated the QFX download option.  I would complain to their customer support.

[First Last]

Here is a free version.

A while back, I wrote a CSV to OFX converter that is configurable and can work on different types of CVS format.

For example, for Discover Card download, you just need to define a configuration that tells the tool which column to find the Data, Amount, and so on.

I just whip up a configuration account file that should work for Discover Credit Card CVS file.

What is it?

A java program that will convert Discover credit card CVS download file into OFX file.

I spent about 5-minutes writing up the configuration account file. I think it should work but needed someone to try it.

My suggestion is to create a test Money (mny) file. Try the generate OFX file. Make sure that it will work for you before importing it into your actual mny file.

See:

https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/csv2ofx%20-%20Discover

I am happy to take questions, make changes, and improve as needed.

Best,

--

You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/CAJnk8n6T0wcL%2B8CCn0qdoFyU9zoL-ffj%3Dw%3DKajMxT5eDBgXqKg%40mail.gmail.com.

[M B II]

hleofx,

How do you switch up the values from positive to negative?   I've been playing with this converter today and have it 98% setup but noticed the values were backwards.  I tried just adding a neg to the amount in the yaml file but that seems to break the conversion.  Thanks in advance if you get the chance to respond.

[Bill & Michelle Becker]

Yes, in addition to Discover's elimination of ofx and qfx downloads, their csv file has debits as positive numbers and credits as negative.  Apparently they are intent on really annoying their customers.

I've greatly reduced the problem by discontinuing use of the Discover card and changing my automatic charges to Visa.  Since there are only a few Discover charges left, it's relatively painless to manually edit the csv file using Notepad before submitting it to the csv to ofx converter. I plan to only use Discover for big purchases where they are offering 5% cashback.

Bill Becker

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/394a52b3-3b6c-418d-a7e1-e79fbab786dbn%40googlegroups.com.

[Dan Adkins]

check out the scrub routine "def _scrubINVsign(ofx):", as it could probably be modified and added into scrub_Discover.

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/394a52b3-3b6c-418d-a7e1-e79fbab786dbn%40googlegroups.com.

[Fur Rari]

I had the same problem, and built pepperfox to solve it.  If you're interested in how, look at https://pepperfox.biggianthead.org

[M B II]

Thanks Ameridan.   The scrubbers are a little beyond my skillset, but I recognize that the logic in that routine is correcting a situation where Units/trxamount are inversed and to correct them if they aren't.  I also recognize that the easy code, once you grab the right values, is to just do amount = amount * -1.   The trick is knowing the coding to filter and grab the correct fields you want to change.

Also thank you fur*   I'm trying to NOT go the direction of having to setup another account somewhere.  I'm hoping I can do this by downloading the CSV manually from Discover, running it through a batch/python scrubber to convert to an OFX/QFX and then opening that for MSMoney to grab.  I was hoping Robert@pocketsense would end up creating a CSV 2 OFX routine but I'm not putting that on him as he's allowed me to use MSMoney well beyond it's discontinuation date and I'm assuming there is already some solutions for CSV2OFX (like HLE's program).

Similar to Bill Becker, I've mostly shoe-boxed my Discover cards now but a couple routine grocery stores only do Discover.   I could manually enter them, but why take 5 min every month to do that when I can spend hours/day figuring out how to convert a CSV to OFX using a batch file.   Yes that is some sarcasm, but I suspect a few of us have similar mindsets on these types of things...I want to figure out how to manipulate the files.    I also suspect it will be helpful in the future such that I can get another decade or more out of MSMoney if I figure out how to go from CSV to OFX using a simple local program.

[First Last]

I did another update to 'fix' the reversed amount sign for Discover CSV file. Change

* support a new setting reverseAmountSign in discover_cc.yaml

# Discover output amount values in reverse order, so we need to "reverse" it for OFX purpose
reverseAmountSign : "True"

Download: https://bitbucket.org/hleofxquotesteam/hleofxquotes/downloads/hleOfxQuotes-csv2ofx-Build_20230115_9.zip (general download URL: https://bitbucket.org/hleofxquotesteam/hleofxquotes/downloads/

Doc: https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/csv2ofx%20-%20Discover

Control test. I am using the following files for testing

* setting file: https://bitbucket.org/hleofxquotesteam/hleofxquotes/downloads/discover_cc.yaml

* input CSV file (attached): Discover-AllAvailable-20230115.csv

* output OFX: (attached) test1.ofx

Once imported into a test account and test mny, the register should look something like this

To view this discussion on the web visit https://groups.google.com/d/msgid/microsoft-money/CAJy4qrE1h%3DLP%2BzShJaMWPJRfmNKbDYRVAboZOKa-aOLRVuqG9Q%40mail.gmail.com.

[M B II]

FYI, reviewing how I'm using hle's converter.

I have a tendency to use portable apps (so settings are all backed up in the app folder and I can move from computer to computer easier).

Saying that, I have java installed thru portableapps and I have setup a cmd and yaml file for each discover account.   When I get a new CSV for account x1234, I drag it into the x1234 CMD file and that will auto convert it to OFX using hle's converter.

To setup the CMD file, paste the lines below into a text file and save it with extension .cmd in windows.

@echo off
echo.
echo.
rem modify the line below to where your java.exe file is located.
set PATH=""C:\PortableApps\CommonFiles\OpenJDK64\bin""
echo **************************************
echo.
echo.  Takes one or multiple CSV files that are dragged (in file explorer) to this CMD file and converts from csv to OFX for Microsoft Money
echo.  OFX files will have the same name as the CSV files.
echo.  Uses the yaml file as the configuration file (header, FID, acct number, etc)
echo.  NOTE you must modify the YAML file for your information (like acct number)
echo.      
echo **************************************
echo.
echo.
IF [%1] == [] goto :eof
:loop
rem The %~1 refers to file in.
set filein=%~1
set fileout=%filein:~0,-4%
rem modify location of csv2ofx.jar file to your needs.
java.exe -Dloader.main=app.Csv2OfxCmd -jar C:\PortableApps\csv2ofx\hleOfxQuotes-csv2ofx\hleOfxQuotes-csv2ofx.jar "%~1" x1234discover_cc.yaml "%fileout%.ofx"
shift
if not [%1]==[] goto loop