Import data problem: Unexpected number of fields

[fx.practic]

Hello.

I trying to import tick data.
Now file contains 2 lines only:

20130114 184723;14.53;2
20130114 195056;14.53;2

File name: EURUSD.Last.txt

When try to import as Tick data LLC get these 2 error messages in log tab:

8/4/2018 12:39:45 AM NinjaScript Import type 'Tick Data, LLC': Error on calling 'OnNextDataPoint' method: System.InvalidOperationException: Operation is not valid due to the current state of the object. at NinjaTrader.NinjaScript.ImportTypes.TickDataImport Type.OnNextDataPoint() in c:\Users\av240\Documents\NinjaTrader 8\bin\Custom\ImportTypes\@TickDataImportType.cs:li ne 106 at NinjaTrader.NinjaScript.ImportTypes.ImportType.Imp ort(MarketDataType marketDataType, TimeZoneInfo sourceTimeZoneInfo, Boolean generateMinuteBars, Boolean generateDailyBars, IProgress progress)


and

8/4/2018 12:39:45 AM Default EURUSD: Unexpected number of fields in line '0', should be 3, 5 or 6

I tried to replace semicolon to comas - same result.
I tried to re-enter lines in new file manually - same result.

What I did wrong?
And what does LLC abbreviation means in "Tick Data, LLC"?

[NinjaTrader_ChelseaB]

Hello fx.practic,

I was able to import this file.

Below is a public link to a video that demonstrates.

https://drive.google.com/file/d/1qFKU8L9BMLibhv_az5w0CLTtQDAlXSXG/view?usp=drivesdk

What version of NinjaTrader 8 are you using?

[fx.practic]

Chelsea, thank You, I can import it today too.

I have about 5 different files with tick historical data (all of them caused same error messages) - and all of them were imported with no problem today.

May be, I need just to restart NT instead of hours of tries.

[fx.practic]

Sorry, have continuation of this adventure.
Today tried to import attached file.
Got same problem.

At this time VisualStudio was running and catch exception.

File looks ok, separators ";" - ok.
Space between date and time looks ok too: x20.


8/8/2018 11:30:16 PM Default BTCUSD: Unexpected number of fields in line '0', should be 3, 5 or 6


8/8/2018 11:51:54 PM NinjaScript Import type 'Tick Data, LLC': Error on calling 'OnNextDataPoint' method: System.InvalidOperationException: Operation is not valid due to the current state of the object. at NinjaTrader.NinjaScript.ImportTypes.TickDataImport Type.OnNextDataPoint() in c:\Users\av240\Documents\NinjaTrader 8\bin\Custom\ImportTypes\@TickDataImportType.cs:li ne 106 at NinjaTrader.NinjaScript.ImportTypes.ImportType.Imp ort(MarketDataType marketDataType, TimeZoneInfo sourceTimeZoneInfo, Boolean generateMinuteBars, Boolean generateDailyBars, IProgress progress)

[NinjaTrader_ChelseaB]

Hello fx.practic,

I was able to import the new file BTCUSD without error on my end.

I was not able to confirm the version of NinjaTrader you are using.

Please send an email to platformsupport [at] ninjatrader [dot] com so that we may request your log and trace files. In the email please include a link to this forum thread.

[fx.practic]

Email sent.

[fx.practic]

Want to say many thanks to Chelsea for remote help.

[rjm1903]

I'm currently having the same issue that fx.practice was having. I'm unable to open the video link that NinjaTrader_ChelseaB posted for fixing this issue. Here is the link https://drive.google.com/file/d/1qFK...w?usp=drivesdk.

[NinjaTrader_ChelseaB]

Hello rjm1903,

Videos of simple tests are typically deleted after 1 year.

May I have the text file you are trying to import to try importing on my end?

[rjm1903]

I keep getting an error when I try to upload the attachment. It says Error uploading image. I don't know if it is because the file is too large. What do you recommend that I do?

[NinjaTrader_ChelseaB]

Hello rjm1903,

Please use a web transfer service such as wetransfer.com, google drive, dropbox, etc.

Then post the link in your next post.

[rjm1903]

Thank you! Here is the link to the file:

https://drive.google.com/file/d/1AuoBxO9NZy0_wi40wI497Qc7P-3IHDuJ/view?usp=sharing

[NinjaTrader_ChelseaB]

Hello rjm1903,

To confirm, this is historical tick data?

This does not have the correct format.

https://ninjatrader.com/support/helpGuides/nt8/importing.htm

The correct format for tick data is:

yyyyMMdd HHmmss;price;volume

The data from your file is:

20180101;170000092;6405.00;147

I think possibly the data should look like:

20180101 170000;6405.00;147

[rjm1903]

The extra numbers are likely milliseconds. I'm using TickWrite to format the data with the provided NinjaTrader.twj file so I don't understand how this issue is happening. I've uploaded data from TickWrite in the past without issue.

[NinjaTrader_ChelseaB]

Hello rjm1903,

You are using 3 semicolons while the required format is 2.

The format for sub second granularity is:

yyyyMMdd HHmmss fffffff;price;volume

It must be the right format or you are going to get the errors you are getting.