ForexTester issue

I don't know how to import ForexTester report to Analyzer.
I export from file ForexTester with an option "Export history to Excel" and than no matter how I save, like xls or csv I'm getting the error message:
This is for csv:
17:44:07.980 [SwingWorker-pool-1-thread-6] INFO  OrdersLoader - Detected delimiter: ','
17:44:07.985 [SwingWorker-pool-1-thread-6] INFO  MT4ReportLoader - Loading MetaTrader4 .csv report file.
17:44:07.986 [SwingWorker-pool-1-thread-6] INFO  OrdersLoader - Detected delimiter: ','
17:44:07.987 [SwingWorker-pool-1-thread-6] INFO  OrdersLoader - Detected delimiter: ','
17:44:07.989 [SwingWorker-pool-1-thread-6] INFO  OrdersLoader - Detected delimiter: ','
17:44:07.994 [SwingWorker-pool-1-thread-6] INFO  OrdersLoader - Detected delimiter: ','
17:44:07.994 [SwingWorker-pool-1-thread-6] INFO  TradestationLoader - Loading Tradestation .csv report file.
17:44:07.995 [SwingWorker-pool-1-thread-6] INFO  OrdersLoader - Detected delimiter: ','
17:44:07.997 [SwingWorker-pool-1-thread-6] ERROR TradestationLoader - Failed to load Tradestation report file: eur_test.csv Exc: 
java.lang.Exception: Loading CSV settings failed. Invalid values length. Expected: 12, got: 16
at com.strategyquant.plugin.Loader.impl.Tradestation.TradestationCsvReportLoader.loadCsvSettings(TradestationCsvReportLoader.java:141) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.impl.Tradestation.TradestationCsvReportLoader.load(TradestationCsvReportLoader.java:65) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.impl.Tradestation.TradestationLoader.load(TradestationLoader.java:66) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.preloadFile(ReportLoader.java:194) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.loadFile(ReportLoader.java:64) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:123) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:1) [QuantAnalyzer4.exe:na]
at javax.swing.SwingWorker$1.call(SwingWorker.java:295) [na:1.8.0_31]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_31]
at javax.swing.SwingWorker.run(SwingWorker.java:334) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_31]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31]
17:44:07.998 [SwingWorker-pool-1-thread-6] ERROR StrategyReportsLoader - Failed to load report D:\FX\Testing\eur_test.csv
java.lang.Exception: - error loading using NinjaTrader loader - Failed to parse order. Line: ,,,,,,,,,,,,,,Balance:,13303.22
- error loading using MT4ReportLoader - Loading CSV settings failed. Invalid values length. Expected: 14, got: 16
- error loading using GeneralCsv loader - Incorrect csv file or format unrecognized. Failed to parse order. Line: ,,,,,,,,,,,,,,Balance:,13303.22
- error loading using ForexTester loader - Failed to parse order. Line: ,,,,,,,,,,,,,,Balance:,13303.22
- error loading using ZuluTrade loader - Automatic detection of date format failed. Reason: Date format not recognized(1).
Sample: 0.00000
- error loading using Myfxbook loader - Incorrect Myfxbook file or format unrecognized. Automatic detection of date format failed. Reason: Date format not recognized(1).
Sample: 
- error loading using FxBlue loader - Failed to parse order. Line: 0,,deposit,0.000,2017.04.14 00:00:00,0.00000,0.00000,0.00000,2017.04.14 00:00:00,0.00000,Initial deposit,0.00,0.00,0.00,0,10000.00
- error loading using Tradestation loader - Failed to load Tradestation report file: eur_test.csv - Loading CSV settings failed. Invalid values length. Expected: 12, got: 16

at com.strategyquant.plugin.Loader.core.ReportLoader.loadFile(ReportLoader.java:69) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:123) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:1) [QuantAnalyzer4.exe:na]
at javax.swing.SwingWorker$1.call(SwingWorker.java:295) [na:1.8.0_31]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_31]
at javax.swing.SwingWorker.run(SwingWorker.java:334) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_31]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31]
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is for XLS:

17:46:46.615 [SwingWorker-pool-1-thread-7] ERROR MultichartsLoader - Exc.
org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package should contain a content type part [M1.13]
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:39) ~[poi-ooxml-3.11.jar:3.11]
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:258) ~[poi-ooxml-3.11.jar:3.11]
at com.strategyquant.plugin.Loader.impl.Multicharts.MultichartsLoader.load(MultichartsLoader.java:68) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.preloadFile(ReportLoader.java:194) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.loadFile(ReportLoader.java:64) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:123) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:1) [QuantAnalyzer4.exe:na]
at javax.swing.SwingWorker$1.call(SwingWorker.java:295) [na:1.8.0_31]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_31]
at javax.swing.SwingWorker.run(SwingWorker.java:334) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_31]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31]
Caused by: org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package should contain a content type part [M1.13]
at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:203) ~[poi-ooxml-3.11.jar:3.11]
at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:673) ~[poi-ooxml-3.11.jar:3.11]
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:274) ~[poi-ooxml-3.11.jar:3.11]
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:37) ~[poi-ooxml-3.11.jar:3.11]
... 12 common frames omitted
17:46:46.617 [SwingWorker-pool-1-thread-7] ERROR StrategyReportsLoader - Failed to load report D:\FX\Testing\eur_test.xls
java.lang.Exception: - error loading using Multicharts loader - org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package should contain a content type part [M1.13]

at com.strategyquant.plugin.Loader.core.ReportLoader.loadFile(ReportLoader.java:69) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:123) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:1) [QuantAnalyzer4.exe:na]
at javax.swing.SwingWorker$1.call(SwingWorker.java:295) [na:1.8.0_31]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_31]
at javax.swing.SwingWorker.run(SwingWorker.java:334) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_31]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31]
-----------------------------------------------------------------------------------------------------------------
Attachments
eur_test.csv
(1.38 KiB)
eur_test.xls
(32.50 KiB)
  • Votes +1
  • Project QuantAnalyzer
  • Type Bug
  • Status Fixed
  • Priority Low

History

TM
#1

tmatejka

15.04.2019 20:59

Task created

NA
#2

Niko

08.05.2019 20:17
Voted for this task.
TT
#3

Tamas

03.07.2019 13:01

Status changed from New to In progress

Supported format is 

Order,Symbol,Type,Lot,Open time,Open price,Stop loss,Take profit,Close time,Close price,Swap,Pips,Profit


Format in attached file is different

Ticket,Symbol,Type,Lots,Open Time,Open Price,S/L,T/P,Close Time,Close Price,Comment,Swap,Max Equity,Min Equity,Points,Profit


Votes: +1

Drop files to upload

or

choose files

Max size: 5MB

Not allowed: exe, msi, application, reg, php, js, htaccess, htpasswd, gitignore

...
Wait please