Proper format for Stream conversion

EveryMeasure currently has very strict requirements on the file format that can be uploaded and converted to a Stream.  Support for more file formats will be added in the future.

The file should:

• Be a .csv or .xlsx file.
• Contain header information on the first row
• Contain exactly one column with the header 'Timestamp' (case insensitive)
  • Each timestamp row should have a timestamp in the format YYYY-MM-DD hh:mm:ss.ssss
  • EveryMeasure timestamps support microsecond resolution
• Contain one or more Measure columns
  • Each measure column should have a header that specifies the Measure name
  • Measure rows should contain a numeric value or be empty
  • Each measure column must have at least one row with a value
  • Note: EverMeasure stores measure data as double precision floating point numbers

The file should not:

• Contain any empty rows
• Contain any empty columns

Simple example of proper Stream conversion format

Example python code to generate a valid EveryMeasure timestamp

from datetime import datetime

now = datetime.now()

now_str = now.strftime("%Y-%m-%d %H:%M:%S.%f")
print(now_str)

Troubleshooting

See How to troubleshoot Stream conversion issues