CSV Database

 > Data Sources > CSV Database

To connect a CSV Database Data Source go to Data Sources page.

Click on the green Add Data Source button and choose CSV Database.

Then you have to go through these steps:

 

1- File Details #

  • Database: When uploading a file for the first time you'll be creating a private database under your Viur account, so we ask you to give it a friendly name.
  • Table: The file you're about to upload will become a table, so here you can give that table a name.
  • CSV file: Your CSV file. Make sure the file size is under 25MB.
  • Column Separator: Typically CSV file columns should be separated by commas, but it's very common to find semicolons or tabs as separators. In this field put the correct separator.
  • Text delimiter: If your file has the text columns that are delimited by quotation marks or other character you can define it here.
  • File encoding: In this field you can choose the file encoding. If you are exporting CSV from Microsoft Excel it probably is in Windows-1250 encoding.

CSV database 1

 

2- Data Types #

In this step Viur tries to guess the best data types for your data, but we ask you to revise and change them if needed.

To change a data type click on the pencil icon and change the data type.

Click on the pencil again to close the popup.

CSV database 2

 

Important Note
The file must contain headers for all columns. Headers must be unique.

There are 6 data types available:

  • text
  • number
  • date
  • date & time
  • boolean
  • currency

If the data type is Date or Date & Time you must define a mask so the dates are correctly parsed by Viur. Below are some example masks:

Example Mask
19/08/2016 dd/MM/yyyy
19-08-2016 dd-MM-yyyy
08.19.2016 MM.dd.yyyy
19/08/2016 09:12:12 PM dd/MM/yyyy hh:mm:ss a
19/08/2016 12:12:12 dd/MM/yyyy HH:mm:ss
19/08/2016 12:12:12.345 dd/MM/yyyy HH:mm:ss.SSS

 

Date Formatting Reference #

Mask Token Date or Time Examples
y Year 1996; 96
M Month in year July; Jul; 07
w Week in year 27
W Week in month 2
D Day in year 189
d Day in month 10
E Day in week Tuesday; Tue
a Am/pm marker PM
H Hour in day (0-23) 0
h Hour in am/pm (1-12) 12
m Minute in hour 30
s Second in minute 55
S Millisecond 978

 

3- Review & Confirm #

This step is a confirmation screen and clicking Finish will upload your file.

CSV database 3

 

Working with SQL over CSV Data

You can use the Drag & Drop mode with CSV Data, but if you choose to use the SQL code editor to perform data analysis over your CSV Data you can do so. Viur uses the H2 SQL syntax, please consult the H2 SQL grammar for more information.

Still need help? Get in touch!
Last updated on 16th Oct 2018