Importing Data into curios.IT

curios.IT data is imported from CSV (comma separated values) text files. Your csv file must fulfill the following requirements to be loaded into curios.IT:

File requirements

  • File suffix must be .csv
  • Field separator character can be , or ; or TAB (detected automatically)
  • Character set should be ISO-8859-1 (Windows-1252/WinLatin1 will work too)
  • First row contains the column headers (field names)
  • ALL data rows must contain the same numer of fields as the column header!
  • Empty columns or rows are allowed (will be ignored)

Download the demo data set as CSV file

Record label column detection

curios.IT will try to detect a column which can be used as record labels:

  • If the first column contains unique values (each row has a different value, numeric or string) they are used as record labels
  • Otherwise the first category column which contains unique values is used
  • If no column can be used as record labels, the records are numbered (1,2,3,...) in the order they are loaded from the file

Field type detection

curios.IT is able do identify the data type (numeric, category) for each column automatically. The following rules apply:

  • If a column contains only numbers, it is identified as numeric
  • If a column contains at least one nonnumeric entry, it is identified as category

curios.IT will ignore columns, if they contain identical values (e.g. all 0)

Moving files into curios.IT on iPad (iOS version >= 11)

  1. Open the 'Files' app (preinstalled)
  2. Search for the file to import on iCloud, DropBox, Google Drive or in 'On my iPad' (other apps)
  3. Tap on 'select', select the file you want to import
  4. Tap on 'move'
  5. Select curios.IT as target destination (in 'On my iPad')

Copying files to iPad with iTunes (iOS version < 11)

  1. Connect your iPad to your computer and start iTunes (if it does not start automatically)
  2. Open the 'iPad' section and click on 'Apps'
  3. Scroll down to the file sharing section
  4. Click on curios.IT and select a .csv file
  5. Press the sync button to copy the files to the iPad