Generic CSV TikConverter question

Hi,
I’m brand new to Glean and I ran into a little trouble converting existing data using TikConverter. As I was bootstrapping my setup, I attempted to use TikConverte to convert a generic CSV file of minute data I purchased awhile ago. The CSV file only has the following columns — Date, Time(minute), Open, High, Low, Close.

When I uploaded the data TikConverter auto-select the “Type” as Bar. I was missing some fields(symbol, volume, barinterval) so I created these extra columns in my data, uploaded the file again, and lined up the columns appropriately. This did not work. At the bottom I get “Sample import: Got 0 records and expected …”

I suspect that the formats of some of my columns are not correct and therefore cannot be injested. I’ve included a snippet of my original data. Any idea what might be going wrong?

Date,Time,Open,High,Low,Close
06/22/1999,09:31,1376.0000,1376.0000,1376.0000,1376.0000
06/22/1999,09:32,1376.0000,1376.0000,1376.0000,1376.0000
06/22/1999,09:33,1376.0000,1376.0000,1376.0000,1376.0000

Thank you for your help!
Clinton

support Posts: 106 August 2013

as you mention the data you upload is missing columns.

when we add these columns, everything works fine.

here is the working set

symbol,Date,Time,Open,High,Low,Close,vol,barintervalsec
SPY,6/22/1999,9:31:00,1376,1376,1376,1376,4,60
SPY,6/22/1999,9:32:00,1376,1376,1376,1376,4,60
SPY,6/22/1999,9:33:00,1376,1376,1376,1376,4,60

clinton Posts: 2 August 2013

Thank you for the help…I realized I put a zeros in for the volume column. This seemed to cause issues. Works now!

Originally published at gleanusers.vanillaforums.com.

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.