MT2OFX needs a script written for my particular bank, but when I e-mailed (a few months ago) the author of the software he never followup with me after I sent him a sanitized CSV file. I sent him repeated followup emails, but to no avail.

I was experimenting with PayPal, but they offer QIF as well, which is much easier. The author has some predefined mappings already included for UBS, Yodlee, Credit Union, etc.

Another item worth mentioning - He mapped Microsoft Money Report (csv) as well. I assume this was for converting Money data from a non-US version into an OFX file to bring back into the US Sunset version of Money.

The row in your *.csv file just need to be transform into a list <STMTTRN>...</STMTTRN>. It is quite straight-forward. In fact, that is what the python package that Ameridan pointed out (https://github.com/mulicheng/csv2ofx) a couple of post above
does: read *.csv, generate the *.ofx output using the above "template".

The row in your *.csv file just need to be transform into a list <STMTTRN>...</STMTTRN>. It is quite straight-forward. In fact, that is what the python package that Ameridan pointed out (https://github.com/mulicheng/csv2ofx) a couple of post above
does: read *.csv, generate the *.ofx output using the above "template".

Python is a language and a program that runs the language for you. You install that program, and then run an application-specific program that uses the Python program to execute. See Ameridan's post of Thursday.

Python is a language and a program that runs the language for you. You install that program, and then run an application-specific program that uses the Python program to execute. See Ameridan's post of Thursday.

Sorry for my ignorance, but I can't make heads or tails out Ameridan's post.

Download csv2ofx from https://github.com/mulicheng/csv2ofx. There is Download on the right. Get file mulicheng-csv2ofx-0.3-0-gc4316e2.zip. Unzip to get directory mulicheng-csv2ofx-0.3-0-gc4316e2. You can move mulicheng-csv2ofx-0.3-0-gc4316e2 to anywhere
you like. For this example, I am using c:temp\mulicheng-csv2ofx-0.3-0-gc4316e2

Download csv2ofx from https://github.com/mulicheng/csv2ofx. There is Download on the right. Get file mulicheng-csv2ofx-0.3-0-gc4316e2.zip. Unzip to get directory mulicheng-csv2ofx-0.3-0-gc4316e2. You can move mulicheng-csv2ofx-0.3-0-gc4316e2 to anywhere
you like. For this example, I am using c:temp\mulicheng-csv2ofx-0.3-0-gc4316e2

I was able to spend some times on the the week-end. About 80% there: got the actual transaction data translate to OFX format.

BUT ... I think there is a fundamental issue that might be a problem. One of the REQUIRED tag is LEDGERBAL (with two child nodes: BALAMT (balance amount), and DTASOF (date of balance)). That means you will need to be able to tell me the account current balance
(and date for that balance). I will figure out a way to have to specify them but you will need that information.

Now that I have a chance to see your sample file. Perhaps, the "corrupted file" is due to your payee name having ambersand in them and the above tool did not escape correctly. Try again, edit the *.csv to remove the ambersand for now.

Is there a file name hleOfxQuotes-Build_20111017_98-app.jar in current directory? Can you use winzip to see if you can open it (to confirm that the file is not corrupted? If able to open, see if there is a file name app/Csv2OfxCmd.class?

Is there a file name hleOfxQuotes-Build_20111017_98-app.jar in current directory? Can you use winzip to see if you can open it (to confirm that the file is not corrupted? If able to open, see if there is a file name app/Csv2OfxCmd.class?

Not sure what you mean by directory.

I downloaded the Java tool (hleOfxQuotes-Build_20111017_98-app) into a folder on my desktop where I store all other files pertaining to this thread.

I can't find an app (program?) called "app/Csv2OfxCmd.class". I did a search with Windows search tool, but nothing by that name was found.

In that case, goal is to be able to go the folder where you store the *.jar file

In your cmd window, use command 'cd': 'cd folder'; where folder is the name of the folder you created to store the *.jar file. The name of the folder likely to be 'c:\Users\Your Name\Desktop\SomeFolderName'

Then try 'dir' and see if you can you see hleOfxQuotes-Build_20111017_98-app.jar in the list of the files displayed.

Look for a tutorial/reference example on the net on "DOS' or 'window cmd' for help on command mentioned here: 'cd', 'dir' ...

Top-level:

Currently, it is a command-line tool, you need to run it with java and a bunch of arguments

You need to run it in a 'cmd' window while in the same folder as file *.jar

Just a couple comments by an observer that may or may not add clarity: In this,
EXPORT.csv represents the file you downloaded from your bank. If that file has a different name, you would adjust your command. I would think that once you prove out the concept, you might put the long command into a *.batch file, and pass
the *.csv filename as a parameter to the batch file. Within the batch file, %1 would represent the first paramater passed to the batch file. Your ISP or virus checker might be concerned if it sees you receiving a *.bat file. That is because any type of command
might be contained in the file. Batch files can be very simple. You could put more than one command in. For example, the file might have the cd line you are typing followed by the java command. These files can also be complex. You would only
need a simple one.

If you were to post an example line from your *.csv file, and if it is clear what the various comma-separated fields are being used for, I suspect that hleOfxQuotes might create the file for you.

The csv2ofx.props would be a file that you create once. It describes the bank-specific ordering of the fields in the *.csv file. Note that any line that starts with a # character is a comment. The example csv2ofx.props file itself is actually
at
http://sunriise.sourceforge.net/out/hleofxquotes/Build_20111017_98/csv2ofx.props In that example, if I understand correctly, that file is saying that the first field is the date of the transaction, and the second is the amount. If the order was different
in your *.csv files, you would re-order the lines in the *.props file. You might want to name your .props file
yourbankname.props

Note that Money doesn't care about the FID, so that field is ignored by Money.

BUT ... I think there is a fundamental issue that might be a problem. One of the REQUIRED tag is LEDGERBAL (with two child nodes: BALAMT (balance amount), and DTASOF (date of balance)). That means you will need to be able to tell me the account
current balance (and date for that balance). I will figure out a way to have to specify them but you will need that information.

Now that I have a chance to see your sample file. Perhaps, the "corrupted file" is due to your payee name having ambersand in them and the above tool did not escape correctly. Try again, edit the *.csv to remove the ambersand for now.

Maybe the ledger balance is where I messed up.

*.csv files downloaded from BB&T do not include a ledger balance.

How would I address this issue? Check the posted online balance and enter it into the exported file? Will the starting balance be an issue?

Sorry for the many replies, but after modifying the latest exported .csv file to include a ledger balance obtained online from BB&T, Money was still not able to import the (newly created) .ofx file due to corruption issues.

However, I opened the corrupted .ofx file with the MT2OFX program and the .ofx file was repaired and imported into Money.

Great!

But I would like to find the error that corrupted the .ofx file to begin with.

Sorry for the many replies, but after modifying the latest exported .csv file to include a ledger balance obtained online from BB&T, Money was still not able to import the (newly created) .ofx file due to corruption issues.

However, I opened the corrupted .ofx file with the MT2OFX program and the .ofx file was repaired and imported into Money.

Great!

But I would like to find the error that corrupted the .ofx file to begin with.

I am doing something wrong, somewhere.

Regards

OFX files can have a bunch of lines (makes it easier) or everything can be run together. So if you have a lot of lines, there is a possible help. You have a problem OFX file and a working OFX file.

Try running the fc command, putting the names of the good and bad ofx file on the same command line. If there are spaces in the filenames, put double-quotes around each name. Also, you can add the /W switch so that the comparision will ignore
differences that only consist of "whitespace" (spaces, tabs, etc). So your command would look like this:

fc /W goodfile.ofx badfile.ofx

or

fc /W "good file.ofx" "bad file.ofx"

Ideally, there will be just a small section that is different. If the difference is small enough, post the difference. It will probably not contain sensitive things such as account number.

If you entered this, it would write the differences to a file called abc.txt:

I have the abc.txt file ready, but I did a bit of sanitizing on a few lines. What (appear to be account) numbers I deleted, I replaced them with an equal amount of * characters. I hope this editing doesn't hurt anything.

Before I post the comparison file, can you tell me what this line of coding is...

<FITID>

Does it stand for Financial Transaction Identification?

There are long numbers associated with, and I just wanted to make sure I was not posting anything worthy of ID theft.

I have the abc.txt file ready, but I did a bit of sanitizing on a few lines. What (appear to be account) numbers I deleted, I replaced them with an equal amount of * characters. I hope this editing doesn't hurt anything.

Before I post the comparison file, can you tell me what this line of coding is...

<FITID>

Does it stand for Financial Transaction Identification?

There are long numbers associated with, and I just wanted to make sure I was not posting anything worthy of ID theft.

Regards

1. Replacing with * is fine. Replacing with 12345678 would be good too.

2. Very close: Financial Institution Transaction Identification. It is used to uniquely identify a transaction. It can be made however the FI wants. For example, it could incorporate the account number, date, amount, sequence number, but it could be
something random. If you don't see your account number in it, then you could leave it as is without giving out info.

3. If the difference in the processed files includes different FITIDs, that sounds as if the difference between the working and non working is very different. I was thinking the difference would probably be fairly small.

I see the problem. The <NAME> field is an alphanumeric that should be limited to 32 characters. So the fix would be to cut down that field to 32 characters. But which 32? The obvious choice would be the first 32. However in an ideal situation, there
might be a better choice. This field comes in as the Payee into Money.

I think for this the &amp; would count as one character and would be treated as a single ampersand by Money.

Money does have the Payee Rules Manager that can help to improve processing. We can discuss that later, but it lets you ignore words like PAYMENTS that you can define.

A <MEMO> field could be 255 characters. So if it is useful, the long string could be copied into a Memo field.

I tried to convert a line of credit file with the java script program, but it was imported into the checking account. I had to restore a backup file to get rid of the unwanted items. Would it be possible for me to modify the existing props file for savings
& line of credit .csv files, or would I need to create a new props file for each account? Edit: I guess what I'm saying is, is it OK to have 3 different props files in the same folder?
Regards

Yes, the *.props file is for specifying per account specific info. Make sure you specify the right *.props file as the third argument when you run the java tool. The sample *.bat file I distributed has csv2ofx.props file hard-coded.

OK, after some trial & error, I finally created three separate .props files, and I even created three different .bat files (a major accomplishment for me). My newly created files are working great for checking and the savings .csv downloads, but in spite
of no visible mapping differences, Money cannot import the LOC (line of credit) .ofx file due to corruption issues. I have compared .props files and .csv files, but I can't find anything wrong on my end. Edit: Sorry my reply is in one paragraph. I am using
Firefox 7 and I am getting scripting errors on this site.
Regards