Data

DATA IMPORT

We currently support three data formats:

• paste from spreadsheet/HTML page. You can cut and paste from either an Excel grid or an HTML table. Note that if your Excel file includes long text fields with line breaks and quotes, you should check the results of your import carefully: Excel’s format can actually be ambiguous in certain situations.


• import CSV file


• import TSV file

Limitation: if your database has more than 20,000 rows, you may run into problems. Also, once your database has more than a few thousand rows, you may experience sluggish response time.

DATA FIELDS

TimeFlow supports five types of data fields:

• text
• lists: compilations of comma-separated text values
• URLs
• numbers: European style numbers are not supported (e.g. 2.000,00 is not supported)
• dates: a variety of formats are supported (having dashes, slashes, all numbers, numbers with words in English for months, etc.) Years are always required. Hours aren’t required but, when present, are supported in a 24-hour clock. European style dates (with days before months) are not supported (e.g. 08/02/2010 is interpreted as August 2, 2010)