Unparseable number when converting sample csv Csv2OfxCmd

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Download and unzip 
http://sunriise.sourceforge.net/out/hleofxquotes/Build_20111026_28/csv2ofx.zip

2. run following command: java -cp hleOfxQuotes-Build_20111026_28-app.jar 
app.Csv2OfxCmd sample1.csv sample1.ofx csv2ofx.props 

3. You'll get the error  java.text.ParseException: Unparseable number: 
"($47.81)"

Ofx file is created but upon opening it seems to be blank or no transactions 
can be seen which were in the csv.


I'm using the program from the mentioned url above, I've tried it running with 
both the newest java 1.7.0_25 but also with java 1.6.0_29
I'm running Windows 8 Enterprise x64


Please provide any additional information below.

here can be seen the errors from sample files:

C:\Users\parol_000\Desktop\csv2ofx\New folder>java -cp hleOfxQuotes-Build_201110
26_28-app.jar app.Csv2OfxCmd sample1.csv sample1.ofx csv2ofx.props
0 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:3
4) - csvFile=sample1.csv
2 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:3
5) - ofxFile=sample1.ofx
2 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:3
7) - mapFile=csv2ofx.props
72 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createMapper(Csv2Ofx.jav
a:163) - mapFile=csv2ofx.props
74 [main] WARN  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createTransactions(Csv2O
fx.java:249) - java.io.IOException: java.text.ParseException: Unparseable number
: "($8.02)"
75 [main] WARN  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createTransactions(Csv2O
fx.java:249) - java.io.IOException: java.text.ParseException: Unparseable number
: "($7.53)"
75 [main] WARN  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createTransactions(Csv2O
fx.java:249) - java.io.IOException: java.text.ParseException: Unparseable number
: "($47.81)"
76 [main] WARN  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createTransactions(Csv2O
fx.java:249) - java.io.IOException: java.text.ParseException: Unparseable number
: "($19.50)"
76 [main] WARN  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createTransactions(Csv2O
fx.java:249) - java.io.IOException: java.text.ParseException: Unparseable number
: "$100.00"
77 [main] WARN  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createTransactions(Csv2O
fx.java:249) - java.io.IOException: java.text.ParseException: Unparseable number
: "($18.67)"
77 [main] WARN  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createTransactions(Csv2O
fx.java:249) - java.io.IOException: java.text.ParseException: Unparseable number
: "($16.13)"
77 [main] WARN  com.le.tools.moneyutils.csv2ofx.Csv2Ofx.createTransactions(Csv2O
fx.java:249) - java.io.IOException: java.text.ParseException: Unparseable number
: "$1000.00"
90 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:
48) - Parsed 0 transactions.
91 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:
49) - ofxFile=sample1.ofx
91 [main] INFO  com.le.tools.moneyutils.csv2ofx.Csv2OfxCmd.main(Csv2OfxCmd.java:
50) - < DONE

Original issue reported on code.google.com by [email protected] on 30 Jul 2013 at 12:27

Attachments:

• sample1.ofx

[GoogleCodeExporter]

I'll handle this one.

Original comment by [email protected] on 1 Aug 2013 at 6:33

• Changed state: Accepted

[GoogleCodeExporter]

Please also provide the input file and properties files: sample1.csv 
csv2ofx.props 

Original comment by [email protected] on 1 Aug 2013 at 6:34

[GoogleCodeExporter]

Here you go

Thanks for looking into this

Original comment by [email protected] on 1 Aug 2013 at 8:10

Attachments:

• sample1.csv
• csv2ofx.props