locked
Convert CSV to OFX - Part #2 RRS feed

  • General discussion

  • See part #1: http://social.microsoft.com/Forums/en-US/money/thread/1e01e5a8-3c06-4265-931d-9601af50db56

    Friday, October 28, 2011 9:46 PM

All replies

  • Can you try the OFX analyzer tool: http://microsoftmoneyoffline.wordpress.com/ofx-file-analzer/ on the *.ofx file with error and report back the output.
    Friday, October 28, 2011 9:46 PM

  • Can you try the OFX analyzer tool: http://microsoftmoneyoffline.wordpress.com/ofx-file-analzer/ on the *.ofx file with error and report back the output.

     

    *** All line number references do not include header lines ***
    ***OFX 1.02 Add ~10
    ***OFX 2.0 Add ~2
    Running Data Through Parser
    HRESULT       = 0
    Error Code    = 0

    HRESULT       = -2147450874
    Error Code    = 243
    Severity      = X
    Type          = C
    Error Message = XCInvalid Data at "%s". Enumeration value not allowed. (Data in pszBuffer)
    Other Info    = MNYSGMPB: SGML error at (null), line 29 at ">":
              XCInvalid Data at "\030XBANKACCTFROM.ACCTTYPE". Enumeration value not allowed. (Data in pszBuffer)

    Current Buffer = L

    ****************************************** 

    Here are the final lines of the .props file...

    #CHECKING Checking
    #SAVINGS Savings
    #MONEYMRKT Money Market
    #CREDITLINE Line of credit
    ACCTTYPE=Line of credit

    Regards
    Friday, October 28, 2011 10:09 PM
  • I think you want to change

    ACCTTYPE=Line of credit

    to

    ACCTTYPE=CREDITLINE

    Friday, October 28, 2011 10:57 PM
    Moderator
  • I think you want to change

    ACCTTYPE=Line of credit

    to

    ACCTTYPE=CREDITLINE

    Thanks for pointing that out!

    Evidently, I interpreted the code incorrectly.

    I imported the file with no problems to speak of.


    Regards
    Saturday, October 29, 2011 12:30 AM
  • Wow, such a long thread!

     

    I want to thank you, Cal, and especially hleOfxQuotes (and others) for all of the great help I have received these past few weeks in solving this problem.

    You all went above & beyond the call of duty to assist me.

     

     


    Regards
    Saturday, October 29, 2011 12:36 AM
  • csv2ofx at http://www.csv2ofx.com converts csv files to ofx format.
    • Edited by seletit1 Monday, October 31, 2011 12:38 PM
    Saturday, October 29, 2011 1:45 PM