Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Convert CSV to OFX RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Is there an inexpensive way to convert comma separated values data to the OFX format?

     

    My friend's bank does not offer the OFX file download anymore.

    Regards
    Tuesday, September 13, 2011 2:09 AM

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote

     

    Thanks Cal for the info on the field size limit. I've created a new version that truncates the values of  NAME (first 32-chars) and MEMO (first 255 chars)

     

    As previous version, unzip to get directory csv2ofx and use the csv2ofx.bat file

     

    Interestingly enough, Sunset enforces the limit but handle it more gracefully. Instead of giving a bad OFX error, Sunset just truncates the long values to the given limit.

     


    • Edited by hleOfxQuotes Thursday, October 27, 2011 4:16 AM
    • Marked as answer by rustyfender04 Saturday, October 29, 2011 12:43 AM
    Thursday, October 27, 2011 4:15 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    http://csmale.home.xs4all.nl/mt2ofx/en/  MT2OFX

    You said you used MT20FX when you probably meant MT2OFX in your earlier post.

    Here is another a search turned up: http://www.fanhow.com/knowhow:Convert_CSV_to_OFX_or_QIF_File_42767078 


    Tuesday, September 13, 2011 2:27 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    "Inexpensive" can be a confusing term. There are free converters available and also licensed converters. Try iCreateOFX Basic and see what you think.
    pkkltd
    Tuesday, September 13, 2011 10:33 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Try CSV2OFX at http://www.csv2ofx.com

    CSV2OFX supports command line mode to automate the conversion, automatic column detection as well as manual mapping.

    Tuesday, September 13, 2011 1:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I use the Propersoft CSV2OFX. It works great ans support is excellent.
    Tuesday, September 13, 2011 8:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks, but I can't get either program to work correctly.

    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.

    The 2nd program (TXT OFX Converter) makes corrupted files that Money can't import.

    I'm back to square one for now.

     

    Regards
    Tuesday, September 13, 2011 8:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, I saw that tool, but I wasn't sure if I wanted to spend 20.00 for it.
    Regards
    Wednesday, September 14, 2011 2:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You might consider posting a sanitized CSV in case somebody wants to try an application on it. You also might even consider naming the FI.
    Wednesday, September 14, 2011 4:58 PM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote

    I've had good luck with this csv2ofx python script:  https://github.com/mulicheng/csv2ofx 

    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.
    • Proposed as answer by ameridan Thursday, September 15, 2011 4:41 PM
    • Edited by ameridan Thursday, September 15, 2011 4:56 PM
    • Unproposed as answer by ameridan Saturday, October 22, 2011 2:40 PM
    Thursday, September 15, 2011 4:40 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You might consider posting a sanitized CSV in case somebody wants to try an application on it. You also might even consider naming the FI.


    The name of the bank is Branch Banking & Trust (better known as BB&T).

    Here is an older sanitized file...

    Date,Transaction Type,Check Number,Description,Amount
    02/03/2011,POS,,WAL-MART SUPER CENTER 02-02-11 **** BB&T CHECK CARD PURCHASE-PIN,($8.02)
    02/04/2011,POS,,SALLY BEAUTY 02-02 **** BB&T CHECK CARD PURCHASE,($7.53)
    02/07/2011,POS,,WAL-MART SUPER CENTER 02-05-11 **** BB&T CHECK CARD PURCHASE-PIN,($47.81)
    02/07/2011,POS,,WILCO 02-05 **** BB&T CHECK CARD PURCHASE,($19.50)
    02/08/2011,Deposit,,TRANSFER FROM SAVINGS ************* 02-08-11 BB&T ONLINE TRANSFER,$100.00
    02/08/2011,Debit,,ONLINE PMT AT&T CKF*********POS BB&T ONLINE BILL PAYMENT,($18.67)
    02/08/2011,Debit,,ONLINE PMT TIME WARNER CKF*********POS BB&T ONLINE BILL PAYMENT,($16.13)
    Regards


    Sunday, September 18, 2011 8:22 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    By any chance the bank offers QFX download? If yes, that might be an easier path to get the download data into Money. Just change file association to allow Money to handle *.qfx file. See: http://microsoftmoneyoffline.wordpress.com/reg-file-to-import-quicken-qfx-files-automatically-into-money/

    Just for kick, I poke the OFX URL for BB&T and it still answer. URL: http://ofxblog.wordpress.com/2008/10/16/ofx-fi-details-for-bbt/

    Reference: http://ofxblog.wordpress.com/2008/10/16/ofx-fi-details-for-bbt/

    Sunday, September 18, 2011 1:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    On Tue, 13 Sep 2011 02:09:16 +0000, rustyfender04 wrote:
     
    >
    >
    >Is there an inexpensive way to convert comma separated values data to the OFX format?
    >
    > 
    >
    >My friend's bank does not offer the OFX file download anymore.
    >Regards
     
    Does it still offer downloads for Quicken?  Quicken downloads are usually in .qfx format and Money can usually read them unless they contain illegal characters (e.g. "unquoted" ampersands).
    You can download the .qfx file and merely change it's suffix to .ofx; or somewhere on the WWW there is a procedure to allow MSMoney to open .qfx files directly.
     
    Ron
    Sunday, September 18, 2011 1:55 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    By any chance the bank offers QFX download? If yes, that might be an easier path to get the download data into Money. Just change file association to allow Money to handle *.qfx file. See: http://microsoftmoneyoffline.wordpress.com/reg-file-to-import-quicken-qfx-files-automatically-into-money/

    Just for kick, I poke the OFX URL for BB&T and it still answer. URL: http://ofxblog.wordpress.com/2008/10/16/ofx-fi-details-for-bbt/

    Reference: http://ofxblog.wordpress.com/2008/10/16/ofx-fi-details-for-bbt/

    Unfortunately, no.

    This bank only offers the CSV format, but you can pay a monthly fee to use their version of Quicken. I think Quicken works in the background, or something like that.

     

    Sorry, I don't quite understand your last two links.

    Regards
    Sunday, September 18, 2011 9:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    In short, you need to convert the *.csv data into something that looks like the "response section" shown in this URL: http://www.ofx.net/OFXExamplesPage/OFXExamples.aspx

     

    OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE

...
            <STMTTRN>
              <TRNTYPE>CREDIT
              <DTPOSTED>20070329
              <DTUSER>20070329
              <TRNAMT>150.00
              <FITID>980310001
              <NAME>TRANSFER
              <MEMO>Transfer from checking
            </STMTTRN>
            <STMTTRN>
              <TRNTYPE>PAYMENT
              <DTPOSTED>20070709
              <DTUSER>20070709
              <TRNAMT>-100.00
              <FITID>980309001
                <CHECKNUM>1025
              <NAME>John Hancock
            </STMTTRN>


    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".

     

     

     

    Monday, September 19, 2011 1:09 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    In short, you need to convert the *.csv data into something that looks like the "response section" shown in this URL: http://www.ofx.net/OFXExamplesPage/OFXExamples.aspx

     

    OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE

...
            <STMTTRN>
              <TRNTYPE>CREDIT
              <DTPOSTED>20070329
              <DTUSER>20070329
              <TRNAMT>150.00
              <FITID>980310001
              <NAME>TRANSFER
              <MEMO>Transfer from checking
            </STMTTRN>
            <STMTTRN>
              <TRNTYPE>PAYMENT
              <DTPOSTED>20070709
              <DTUSER>20070709
              <TRNAMT>-100.00
              <FITID>980309001
                <CHECKNUM>1025
              <NAME>John Hancock
            </STMTTRN>


    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".

     

     

     

    Is Python a program?

    I didn't see a link for it.

    Regards
    Monday, September 19, 2011 3:11 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Is Python a program?

    I didn't see a link for it.

    Regards

    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.
    Monday, September 19, 2011 3:21 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Is Python a program?

    I didn't see a link for it.

    Regards

    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.

     

    If there is a python program, I can't find it.

    Regards
    Tuesday, September 20, 2011 1:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    1. Install Python: http://www.activestate.com/activepython/downloads
    2. After installation of above package, verify that python is working, open cmd window, type 'python'. Expect output 
    3. C:\>python
ActivePython 2.7.2.5 (ActiveState Software Inc.) based on
Python 2.7.2 (default, Jun 24 2011, 12:21:10) [MSC v.1500 32 bit (Intel)] on win
32
Type "help", "copyright", "credits" or "license" for more information.
>>> quit()

C:\>
    4. 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
    5. Open cmd to c:\temp\mulicheng-csv2ofx-0.3-0-gc4316e2 
    6. C:\TEMP\mulicheng-csv2ofx-c4316e2>python setup.py install
running install
running build
running build_py
creating build
creating build\lib
creating build\lib\csv2ofx
copying src\csv2ofx\csvutils.py -> build\lib\csv2ofx
copying src\csv2ofx\mappings.py -> build\lib\csv2ofx
copying src\csv2ofx\ofx.py -> build\lib\csv2ofx
copying src\csv2ofx\qif.py -> build\lib\csv2ofx
copying src\csv2ofx\__init__.py -> build\lib\csv2ofx
copying src\csv2ofx\csv2ofx.xrc -> build\lib\csv2ofx
running build_scripts
creating build\scripts-2.7
copying and adjusting csv2ofx -> build\scripts-2.7
running install_lib
creating C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\csv2ofx.xrc -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\csvutils.py -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\mappings.py -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\ofx.py -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\qif.py -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\__init__.py -> C:\Python27\Lib\site-packages\csv2ofx
byte-compiling C:\Python27\Lib\site-packages\csv2ofx\csvutils.py to csvutils.pyc

byte-compiling C:\Python27\Lib\site-packages\csv2ofx\mappings.py to mappings.pyc

byte-compiling C:\Python27\Lib\site-packages\csv2ofx\ofx.py to ofx.pyc
byte-compiling C:\Python27\Lib\site-packages\csv2ofx\qif.py to qif.pyc
byte-compiling C:\Python27\Lib\site-packages\csv2ofx\__init__.py to __init__.pyc

running install_scripts
copying build\scripts-2.7\csv2ofx -> C:\Python27\Scripts
running install_egg_info
Writing C:\Python27\Lib\site-packages\csv2ofx-0.2-py2.7.egg-info

C:\TEMP\mulicheng-csv2ofx-c4316e2>
    7. Download wxpython: http://www.wxpython.org/download.php. Make sure you choose the one for python 2.7. Install it. Just accept the default values.
    8. Start csv2ofx 
    9. C:\TEMP\mulicheng-csv2ofx-c4316e2>python csv2ofx
Using Default Mappings
GoodBye
    10. That will start up a window to start the tool. Unfortunately, I've never used the tool before so won't be much help from this point on. Ameridan might be to jump in.
    Tuesday, September 20, 2011 4:05 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    1. Install Python: http://www.activestate.com/activepython/downloads
    2. After installation of above package, verify that python is working, open cmd window, type 'python'. Expect output 
    3. C:\>python
ActivePython 2.7.2.5 (ActiveState Software Inc.) based on
Python 2.7.2 (default, Jun 24 2011, 12:21:10) [MSC v.1500 32 bit (Intel)] on win
32
Type "help", "copyright", "credits" or "license" for more information.
>>> quit()

C:\>
    4. 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
    5. Open cmd to c:\temp\mulicheng-csv2ofx-0.3-0-gc4316e2 
    6. C:\TEMP\mulicheng-csv2ofx-c4316e2>python setup.py install
running install
running build
running build_py
creating build
creating build\lib
creating build\lib\csv2ofx
copying src\csv2ofx\csvutils.py -> build\lib\csv2ofx
copying src\csv2ofx\mappings.py -> build\lib\csv2ofx
copying src\csv2ofx\ofx.py -> build\lib\csv2ofx
copying src\csv2ofx\qif.py -> build\lib\csv2ofx
copying src\csv2ofx\__init__.py -> build\lib\csv2ofx
copying src\csv2ofx\csv2ofx.xrc -> build\lib\csv2ofx
running build_scripts
creating build\scripts-2.7
copying and adjusting csv2ofx -> build\scripts-2.7
running install_lib
creating C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\csv2ofx.xrc -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\csvutils.py -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\mappings.py -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\ofx.py -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\qif.py -> C:\Python27\Lib\site-packages\csv2ofx
copying build\lib\csv2ofx\__init__.py -> C:\Python27\Lib\site-packages\csv2ofx
byte-compiling C:\Python27\Lib\site-packages\csv2ofx\csvutils.py to csvutils.pyc

byte-compiling C:\Python27\Lib\site-packages\csv2ofx\mappings.py to mappings.pyc

byte-compiling C:\Python27\Lib\site-packages\csv2ofx\ofx.py to ofx.pyc
byte-compiling C:\Python27\Lib\site-packages\csv2ofx\qif.py to qif.pyc
byte-compiling C:\Python27\Lib\site-packages\csv2ofx\__init__.py to __init__.pyc

running install_scripts
copying build\scripts-2.7\csv2ofx -> C:\Python27\Scripts
running install_egg_info
Writing C:\Python27\Lib\site-packages\csv2ofx-0.2-py2.7.egg-info

C:\TEMP\mulicheng-csv2ofx-c4316e2>
    7. Download wxpython: http://www.wxpython.org/download.php. Make sure you choose the one for python 2.7. Install it. Just accept the default values.
    8. Start csv2ofx 
    9. C:\TEMP\mulicheng-csv2ofx-c4316e2>python csv2ofx
Using Default Mappings
GoodBye
    10. That will start up a window to start the tool. Unfortunately, I've never used the tool before so won't be much help from this point on. Ameridan might be to jump in.

    I have Python installed, but I can't get past step 5.

    I even typed in the word "setup", but it did not help.

    By the way, I did not use "C:\temp", because I downloaded the file to my desktop.

     

    Edit:

    Here is what I get after typing in setup...

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer\mulicheng-csv2of
    x-0.3-0-gc4316e2\mulicheng-csv2ofx-c4316e2>setup
    usage: setup.py [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]
       or: setup.py --help [cmd1 cmd2 ...]
       or: setup.py --help-commands
       or: setup.py cmd --help

    error: no commands supplied

     

    I tried it with & without typing in "setup".

     

    Regards


    Friday, September 23, 2011 2:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Please re-read instruction. Step #5 is

     

    python setup.py install


    Not just

    setup


    Friday, September 23, 2011 3:27 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Please re-read instruction. Step #5 is

     

     

    python setup.py install

     


    Not just

     

    setup


     

    Actually, I tried that, too, but I must have copied and pasted the command incorrectly.

    Nevertheless, I have succeeded with all of your instructions.

    I opened python csv2ofx, and imported the latest CSV file from BB&T, but I could not get the program to export to an OFX file...in fact, I could not export anything.

    I assume I may need a different script?

    Regards
    Friday, September 23, 2011 3:53 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    No promise but if I have some time this week-end, I can whip up some Java code to do the conversion for you. Probably will roll that into hleofxquotes. Can you add an issue at 

    http://code.google.com/p/hle-ofx-quotes/issues/list

    so that we can track it. Something along the line of: enhancement, add CSV to OFX conversion.

     

     

    Friday, September 23, 2011 4:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    No promise but if I have some time this week-end, I can whip up some Java code to do the conversion for you. Probably will roll that into hleofxquotes. Can you add an issue at 

    http://code.google.com/p/hle-ofx-quotes/issues/list

    so that we can track it. Something along the line of: enhancement, add CSV to OFX conversion.

     

     

    I started a new thread, but I incorrectly listed it as a defect instead of an enhancement.  

    Thanks.

    Regards
    Monday, September 26, 2011 12:03 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    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.

    Looking back at your old messages. You said:

    The 2nd program (TXT OFX Converter) makes corrupted files that Money can't import.

    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.

     



    Monday, October 17, 2011 6:08 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Update: an initial version for a tool to convert *.csv into *.ofx (for transactions).

    See: http://code.google.com/p/hle-ofx-quotes/wiki/Csv2OfxCmd

     

    Monday, October 17, 2011 11:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I apologize, but I am confused at the moment.

     

    The link for the java tool, am I supposed to open it (the downloaded file) with Python?

     

    I tried to open the java file itself, and import the latest .csv file from BB&T, but Money said the file was corrupt.

     

    I didn't know what to do with the posted command line...

    java -cp hleOfxQuotes-Build_20111017_98-app.jar app.Csv2OfxCmd sample1.csv sample1.ofx csv2ofx.props
    Regards
    Tuesday, October 18, 2011 4:58 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The link for the java tool, am I supposed to open it (the downloaded file) with Python?

     

    I think you will want to install Java. http://java.com/en/ That is what runs the *.jar file. It is also the thing you would invoke when you type "java".
    Tuesday, October 18, 2011 5:04 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    As Cal mentioned. The first thing you need to do is to install Java

    Your will need a recent version of Java: 1.6 and later is best. To check your Java version

    # Start cmd window
    Run -> cmd 
    # Then run
    java     -version

    # You want to see something that looks like this
    C    :\Documents and Settings\Administrator>java -version
    java version     "1.6.0_24"
    Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
    Java HotSpot(TM) Client VM (build 19.1-b02, mixed mode, sharing)
    Tuesday, October 18, 2011 5:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Then in same cmd window, type the following command literally

    java -cp hleOfxQuotes-Build_20111017_98-app.jar app.Csv2OfxCmd sample1.csv sample1.ofx csv2ofx.props

    You will need to create the first (sample1.csv) and third file (csv2ofx.props): the wiki page has example that you can download and use as starting point

    The second file (sample1.ofx) is what the tool generated. You can double-click on sample1.ofx to import to MsMoney.

    Summary:

    • How to start the tool 
      java -cp hleOfxQuotes-Build_20111017_98-app.jar app.Csv2OfxCmd
    • It takes two input file: *.csv and *.props
    • Generate one output file *.ofx which you can use to import into MsMoney
    Tuesday, October 18, 2011 5:21 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.

    C:\Documents and Settings\Owner>java -version
    java version "1.6.0_29"
    Java(TM) SE Runtime Environment (build 1.6.0_29-b11)
    Java HotSpot(TM) Client VM (build 20.4-b02, mixed mode, sharing)

    C:\Documents and Settings\Owner>

     

     

    Looks good.

    Regards
    Wednesday, October 19, 2011 7:45 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Then in same cmd window, type the following command literally

    java -cp hleOfxQuotes-Build_20111017_98-app.jar app.Csv2OfxCmd sample1.csv sample1.ofx csv2ofx.props

    You will need to create the first (sample1.csv) and third file (csv2ofx.props): the wiki page has example that you can download and use as starting point

    The second file (sample1.ofx) is what the tool generated. You can double-click on sample1.ofx to import to MsMoney.

    Summary:

    • How to start the tool 
      java -cp hleOfxQuotes-Build_20111017_98-app.jar app.Csv2OfxCmd
    • It takes two input file: *.csv and *.props
    • Generate one output file *.ofx which you can use to import into MsMoney

    C:\Documents and Settings\Owner>java -cp hleOfxQuotes-Build_20111017_98-app.jar
    app.Csv2OfxCmd sample1.csv sample1.ofx csv2ofx.props
    Exception in thread "main" java.lang.NoClassDefFoundError: app/Csv2OfxCmd
    Caused by: java.lang.ClassNotFoundException: app.Csv2OfxCmd
            at java.net.URLClassLoader$1.run(Unknown Source)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
            at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
    Could not find the main class: app.Csv2OfxCmd.  Program will exit.

    C:\Documents and Settings\Owner>  

     

    This is as far as I got.

    I did a copy & paste. Is that OK?

    Regards
    Wednesday, October 19, 2011 7:48 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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?

     

    Wednesday, October 19, 2011 2:52 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Regards
    Thursday, October 20, 2011 6:42 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Directory is another name for a folder.

    Thursday, October 20, 2011 10:18 AM
    Moderator
  • Question
    Sign in to vote
    1
    Sign in to vote

    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

    • Edited by hleOfxQuotes Thursday, October 20, 2011 12:32 PM
    Thursday, October 20, 2011 12:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Here is what I found using the dir command...

    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer>dir
     Volume in drive C has no label.
     Volume Serial Number is 003A-9821

     Directory of C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer

    10/20/2011  02:29 AM    <DIR>          .
    10/20/2011  02:29 AM    <DIR>          ..
    09/20/2011  01:35 PM        47,198,208 ActivePython-2.7.2.5-win32-x86.msi
    09/22/2011  11:57 PM               108 CMD string.txt
    09/13/2011  12:56 PM    <DIR>          Converted OFX file(s)
    09/13/2011  12:57 PM    <DIR>          Corrupted OFX files
    10/17/2011  05:28 PM            10,365 Date.docx
    10/18/2011  12:18 AM        14,672,085 hleOfxQuotes-Build_20111017_98-app.jar
    10/20/2011  04:16 AM             3,541 hleOfxQuotes-log.txt
    09/19/2011  09:08 PM    <DIR>          mulicheng-csv2ofx-0.3-0-gc4316e2
    02/10/2011  10:51 PM    <DIR>          OFX converters
    09/09/2011  09:18 PM           184,320 OFXAnlyz04.exe
    09/13/2011  01:04 PM               571 Read Me.txt
    10/20/2011  02:29 AM                 0 velocity.log
    09/22/2011  10:44 PM        11,398,572 wxPython2.8-win32-unicode-2.8.12.1-py27.e
    xe
                   9 File(s)     73,467,770 bytes
                   6 Dir(s)   5,667,090,432 bytes free

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer>

     

    ``````````````````````````````````````````````````````````````

     

    Later, I tried to make a command string to open the latest EXPORT.csv file, but I could not get any farther...



    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer>java -cp hleOfxQ
    uotes-Build_20111017_98-app.jar app.Csv2OfxCmd EXPORT.csv EXPORT1.ofx csv2ofx.pr
    ops
    0 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:3
    5) - csvFile=EXPORT.csv
    16 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:
    36) - ofxFile=EXPORT1.ofx
    16 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:
    38) - mapFile=csv2ofx.props
    375 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:153) - mapFile=csv2ofx.props
    375 [main] ERROR com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java
    :46) - java.io.FileNotFoundException: csv2ofx.props (The system cannot find the
    file specified)
    java.io.FileNotFoundException: csv2ofx.props (The system cannot find the file sp
    ecified)
            at java.io.FileInputStream.open(Native Method)
            at java.io.FileInputStream.<init>(Unknown Source)
            at java.io.FileReader.<init>(Unknown Source)
            at com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.java:169
    )
            at com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createTransactions(Csv2Ofx.ja
    va:122)
            at com.le.tools.moneyutils.csv2ofx.Csv2Ofx.convert(Csv2Ofx.java:78)
            at com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:44)
            at app.Csv2OfxCmd.main(Csv2OfxCmd.java:9)
    391 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java
    :48) - < DONE

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer>

    Regards
    Friday, October 21, 2011 6:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Error indicates that the tool cannot find fie csv2ofx.props

    java.io.FileNotFoundException: csv2ofx.props (The system cannot find the file sp
    ecified)

    You will need both files:

      . EXPORT.csv

      . csv2ofx.props

    in current folder. For example of csv2ofx.props, see http://code.google.com/p/hle-ofx-quotes/wiki/Csv2OfxCmd

     

    Friday, October 21, 2011 4:56 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    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.


    Friday, October 21, 2011 10:37 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Cal. What Cal said is correct. Let us know if that helps. On clarification, the order of the lines in the *.props file  is not significant. Think of it as

    • key=value pair
    • so as-long-as the key is unique, order is not significant

    Taking a clue from Cal's suggestion for the *.bat file, I create a cs2ofx.zip file that has all the files needed to get started

    • Download: http://sunriise.sourceforge.net/out/hleofxquotes/Build_20111017_98/csv2ofx.zip
    • Unzip to to get folder csv2ofx
    • Open 'cmd' to folder csv2ofx
    • Run csv2ofx.bat sample1.csv sample1.ofx
    • That should get you a successful run to generate file sample1.ofx
    •  Make a copy of your *.mny file to test importing in above sample1.ofx.  On successful import, you should see new entries in your account looking like this

    The content of the csv2ofx.props file has three general sections:

    1. How to map the column name from your bank *.csv to tag name in the generated *.ofx file. In the distributed *.props file, I already map them for you based on the sample *.csv you provided.
    2. Financial Institution info: Cal indicates that Money does not care, so you can leave these value alone
    3. You account information: account number (just got put into the generated *.ofx file). I think Money uses the account id information to find the right account to import the *.ofx into.


    Saturday, October 22, 2011 5:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Bear with me.

    I am trying to dissect the info a bit at the time.

    This is uncharted territory for me.

     

    Regards
    Monday, October 24, 2011 8:33 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Here are my latest results...

     

    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.

    C:\Documents and Settings\Owner>cd Desktop\Money 2004 OFX analyzer\csv2ofx

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer\csv2ofx>java -cp
     hleOfxQuotes-Build_20111017_98-app.jar app.Csv2OfxCmd EXPORT.csv EXPORT1.ofx cs
    v2ofx.props
    0 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:3
    5) - csvFile=EXPORT.csv
    0 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:3
    6) - ofxFile=EXPORT1.ofx
    0 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:3
    8) - mapFile=csv2ofx.props
    328 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:153) - mapFile=csv2ofx.props
    344 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - BANKID, (removed for security purposes)
    344 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - column.TRNAMT, Amount
    344 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - column.NAME, Description
    359 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - CURDEF, USD
    359 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - ACCTID, (removed for security purposes)
    359 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - ACCTTYPE, CHECKING
    375 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - ORG, HAN
    375 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - FID, 6805
    375 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - column.MEMO, Check Number
    375 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.ja
    va:177) - column.DTPOSTED, Date
    609 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java
    :48) - < DONE

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer\csv2ofx>

     

     

    As you can see above, I managed to convert a .csv file to an .ofx file, but Money could not import it due to corruption issues.

    I edited the existing PROPS file to include the bank's routing number and account number instead of creating my own PROPS file. Is that where I made my mistake?

    Regards
    Wednesday, October 26, 2011 1:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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.

    Looking back at your old messages. You said:

    The 2nd program (TXT OFX Converter) makes corrupted files that Money can't import.

    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?

     

     

     

    Regards

    Wednesday, October 26, 2011 1:39 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I quoted a post about midway above. There was no post number, so I have nothing to identify the new post with.
    Regards
    Wednesday, October 26, 2011 1:42 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Wednesday, October 26, 2011 2:10 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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:

    fc /W "good file.ofx" "bad file.ofx" >abc.txt

     

     

    Wednesday, October 26, 2011 2:25 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    The generated *.ofx from my tool should have multiple lines, so Cal instruction should yield useful results.

    I did test a sample generated *.ofx and got it imported into Sunset with no issue. What version of Money are you using? is it US, UK, International?

     

    Wednesday, October 26, 2011 2:52 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The generated *.ofx from my tool should have multiple lines, so Cal instruction should yield useful results.

    I did test a sample generated *.ofx and got it imported into Sunset with no issue. What version of Money are you using? is it US, UK, International?

     

     

    My version of Money is 2004.

     

     

    It is getting late, here, so I will try to follow up on Cal's recommendations later.

     

    Edit: Sorry, I left out the country (USA).

    Regards
    Wednesday, October 26, 2011 3:49 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Wednesday, October 26, 2011 6:09 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    That value is a generated id number specific to that transaction. So OK to show.
    Wednesday, October 26, 2011 6:38 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    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.

    Wednesday, October 26, 2011 6:39 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Instead of using the * symbol to replace sensitive account numbers, I used digits going from 1 thru 9, and from 9 thru 1 (if I needed more than 9 digits).

    Example...

    12345678987654321

    I thought numbers would be easier to track instead of identical * symbols.

     

    Here is the sanitized abc.txt file...

     

    Comparing files goodfile.OFX and BADFILE.OFX
    ***** goodfile.OFX
          <LANGUAGE>ENG
        </SONRS>
    ***** BADFILE.OFX
                <LANGUAGE>ENG
                <FI>
                    <ORG>HAN
                    <FID>6805
                </FI>
            </SONRS>
    *****

    ***** goodfile.OFX
        <STMTTRNRS>
          <TRNUID>1
          <STATUS>
    ***** BADFILE.OFX
            <STMTTRNRS>
                <TRNUID>0
                <STATUS>
    *****

    ***** goodfile.OFX
                <DTPOSTED>20111021040000
                <TRNAMT>230.00
                <FITID>9130ed6fc22bf199e98b6e322513a239
                <NAME>CREDIT LINE ADVANCE 123456789876
              </STMTTRN>
    ***** BADFILE.OFX
                            <DTPOSTED>20111021040000
                            <TRNAMT>230
                            <FITID>9130ed6fc22bf199e98b6e322513a239
                            <NAME>CREDIT LINE ADVANCE 1234567898765 10-21-11 BB&amp;T ONLINE CREDIT LINE ADV
                        </STMTTRN>
    *****

    ***** goodfile.OFX
                <FITID>c638a4f87973d6d797ca2f399da0d4db
                <NAME>ONLINE PMT ALLSTATE INS CKF12345
              </STMTTRN>
    ***** BADFILE.OFX
                            <FITID>c638a4f87973d6d797ca2f399da0d4db
                            <NAME>ONLINE PMT ALLSTATE INS CKF123456789POS BB&amp;T ONLINE BILL PAYMENT
                        </STMTTRN>
    *****

    ***** goodfile.OFX
                <FITID>bdbd5456d9130c060780d03b90ec05ac
                <NAME>ONLINE PMT ALLSTATE INS CKF12345
              </STMTTRN>
    ***** BADFILE.OFX
                            <FITID>bdbd5456d9130c060780d03b90ec05ac
                            <NAME>ONLINE PMT ALLSTATE INS CKF123456789POS BB&amp;T ONLINE BILL PAYMENT
                        </STMTTRN>
    *****

    ***** goodfile.OFX
                <FITID>1184e47f91adaa75fd9b6cd6671af41d
                <NAME>WM SUPERCENTER 10-23 GASTONIA NC
              </STMTTRN>
    ***** BADFILE.OFX
                            <FITID>1184e47f91adaa75fd9b6cd6671af41d
                            <NAME>WM SUPERCENTER 10-23 GASTONIA NC 8012 BB&amp;T CHECK CARD PURCHASE
                        </STMTTRN>
    *****

    ***** goodfile.OFX
                <DTPOSTED>20111024040000
                <TRNAMT>-228.00
                <FITID>62e222fde3aaaf7584ea37630c969974
                <NAME>PAYMENTS ONEMAIN FIN 12345678987
              </STMTTRN>
    ***** BADFILE.OFX
                            <DTPOSTED>20111024040000
                            <TRNAMT>-228
                            <FITID>62e222fde3aaaf7584ea37630c969974
                            <NAME>PAYMENTS ONEMAIN FIN 123456789876543 INTERNET PAYMENT
                        </STMTTRN>
    *****

     

    Regards
    Thursday, October 27, 2011 1:20 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    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.


    Thursday, October 27, 2011 2:44 AM
    Moderator
  • Question
    Sign in to vote
    2
    Sign in to vote

     

    Thanks Cal for the info on the field size limit. I've created a new version that truncates the values of  NAME (first 32-chars) and MEMO (first 255 chars)

     

    As previous version, unzip to get directory csv2ofx and use the csv2ofx.bat file

     

    Interestingly enough, Sunset enforces the limit but handle it more gracefully. Instead of giving a bad OFX error, Sunset just truncates the long values to the given limit.

     


    • Edited by hleOfxQuotes Thursday, October 27, 2011 4:16 AM
    • Marked as answer by rustyfender04 Saturday, October 29, 2011 12:43 AM
    Thursday, October 27, 2011 4:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.

    C:\Documents and Settings\Owner>cd Desktop\Money 2004 OFX analyzer\csv2ofx

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer\csv2ofx>java -cp
     hleOfxQuotes-Build_20111017_98-app.jar app.Csv2OfxCmd EXPORT.csv EXPORT.ofx csv
    2ofx.props
    Exception in thread "main" java.lang.NoClassDefFoundError: app/Csv2OfxCmd
    Caused by: java.lang.ClassNotFoundException: app.Csv2OfxCmd
            at java.net.URLClassLoader$1.run(Unknown Source)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
            at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
    Could not find the main class: app.Csv2OfxCmd.  Program will exit.

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer\csv2ofx>

     

    As you can see above, I am having trouble with my command string.

    I am using the same string as before. Should it be modified?

    Regards
    Thursday, October 27, 2011 6:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.

    C:\Documents and Settings\Owner>cd Desktop\Money 2004 OFX analyzer\csv2ofx

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer\csv2ofx>java -cp
     hleOfxQuotes-Build_20111017_98-app.jar app.Csv2OfxCmd EXPORT.csv EXPORT.ofx csv
    2ofx.props
    Exception in thread "main" java.lang.NoClassDefFoundError: app/Csv2OfxCmd
    Caused by: java.lang.ClassNotFoundException: app.Csv2OfxCmd
            at java.net.URLClassLoader$1.run(Unknown Source)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
            at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
            at java.lang.ClassLoader.loadClass(Unknown Source)
    Could not find the main class: app.Csv2OfxCmd.  Program will exit.

    C:\Documents and Settings\Owner\Desktop\Money 2004 OFX analyzer\csv2ofx>

     

    As you can see above, I am having trouble with my command string.

    I am using the same string as before. Should it be modified?

    Regards

    OK, I see what's wrong.

    I had to modify the command string to include the proper build number.

    Once I did that, the Java program worked as it should, and Money 2004 accepted the .ofx file with no gripes.

    Kind of reminds me of writing CNC G code during my days in tech school. If one character was out of place it affected everything.

     

    Regards
    Thursday, October 27, 2011 9:35 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    Friday, October 28, 2011 5:05 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    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.
    Friday, October 28, 2011 2:29 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    Friday, October 28, 2011 9:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I am starting a new thread: Part #2. This one is getting long. See: http://social.microsoft.com/Forums/en-US/money/thread/2aab47da-fe95-45ca-8338-1f63af5ecdc6
    Friday, October 28, 2011 9:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    See attached Macro enabled XL that I created after searching for FREE tools online but not able to find any.  

    The XL has instruction sheet and should serve your purpose.

    You can download the same from my profile on guru.com (under Work Samples)

    http://www.guru.com/freelancers/CPA-Accountant-Financial-Planner/India/Kolkata/1422037

    Cheers

    AT

    Friday, June 1, 2012 1:24 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    See attached Macro enabled XL that I created after searching for FREE tools online but not able to find any.  

    The XL has instruction sheet and should serve your purpose.

    You can download the same from my profile on guru.com (under Work Samples)

    http://www.guru.com/freelancers/CPA-Accountant-Financial-Planner/India/Kolkata/1422037

    Cheers

    AT

    I can't locate any of your solutions.

    Regards

    Friday, June 1, 2012 8:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    try iCreateOFX Basic
    Sunday, January 12, 2014 5:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    try iCreateOFX Basic

    Thanks, but someone already posted that link back in 2011.

    Regards

    Sunday, January 12, 2014 7:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hallo,

    habe die CSV mit dem Link in ofx entpackt, es kommt keine mit csv2ofx.bat und wo kann ich die Währung von US in € ändern.

    Danke

    Tuesday, August 4, 2020 11:58 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    This thread is very long. I suggest that you start a new thread that will be specific to your question. To help the users who volunteer their time on this forum. please take the time to:

    - clearly state what you are trying to accomplish

    - describe what you did

    - describe what happened

    In Google Translate's German:

    Dieses Profil ist sehr lang. Ich schlage vor, dass Sie einen neuen Thread starten, der spezifisch für Ihre Frage ist. Um den Benutzern zu helfen, die ihre Zeit freiwillig in diesem Forum verbringen. Bitte nehmen Sie sich Zeit für:
    - Geben Sie deutlich an, was Sie erreichen möchten
    - Beschreibe, was du getan hast
    - Beschreibe was passiert ist

    Bill Becker

    Tuesday, August 4, 2020 4:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hallo,

    Ich habe die CSV mit dem Link in ofx entpackt, es kommt keine mit  csv2ofx.bat und wo kann ich sterben die von US in € ändern.

    Danke


    Tuesday, August 4, 2020 7:40 PM