Generic CSV TikConverter question

Generic CSV TikConverter question


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.