Connecting to CSV

The ElastiCube Manager enables easy and quick access to tables contained within CSV files.

There are two options for uploading data, the first is to upload your file to the Sisense Server. Once the file is uploaded, the data will be imported into the ElastiCube as it was at the time the file was uploaded.

The second option is to define the location of your files on the Sisense Server. This is the preferred option if your Excel files frequently change, but remain in the same location on the Sisense Server as the data is taken from the Excel files each time the ElastiCube is built.

When you import multiple files from a folder and build your ElastiCube, the data is combined together in a single table. To build multiple tables with separate tables for each file, you must repeat the process for each file you want to import as a table.

Notes:

To import data from your CSV files:

  1. In the Data page of ElastiCube Manager, open an ElastiCube or create a new ElastiCube.
  2. In the ElastiCube, click . The Add Data dialog box is displayed.
  3. Click CSVto open the CSV settings.
  4. Select the relevant option for importing your data:
    File Upload
    1. Select this option to import your data from your CSV file. If the file is updated later, you will need to upload it again. To upload the file, click Browse and navigate to the file to be uploaded or drag the CSV file to the File Upload area.
    2. The uploaded file is added to the Uploads list.
    3. Select the relevant CSV file(s) to be uploaded.
    4. (Optional) Toggle the Union Selected switch to append several CSV files together when the data is imported into the ElastiCube. The data in the files must have the same column and data types.
    5. After you have finished uploading the relevant CSV files, select them from the upload list and click Next. Continue to Step 5.

    Server Access

    1. Select this option to define the location of your files on the Sisense Server if your CSV files frequently change, but remain in the same location on the Sisense Server as the data is taken from the CSV files each time the ElastiCube is built.
    2. Select Input Folder Path and enter the full file path with the file name where your Excel files are located. This will display each Excel file in the folder in the next screen where you select what tables to add to the ElastiCube.
      OR
      Select Input File Path and enter the full file path with the file name and its extension of your CSV file. For example, C:\Example.csv. This file display all the tables in the CSV file on the next screen where you select what tables to add to the ElastiCube.
    3. (Optional) Toggle the Union Selected switch to append several Excel files together when the data is imported into the ElastiCube. The data in the files must have the same column and data types.
    4. After you have finished defining the locations of your CSV files, click Next and continue to Step 5. A list of CSV files in the directory are displayed.
  5. From the Select Table list, click to select preview the columns in the Excel file and display the Settings, which provides more options for customizing your data.

  6. In the Settings area, define the following settings:
    • Culture: Select the culture for your CSV. This defines settings such as the format of the date and time or delimiter (decimal or comma) used in your CSV file.

    • Text Qualifier: Change the value if necessary.

    • First Row Contains Field Names: Enables you to specify table column names based on the header in the first row of the spreadsheet.

    • Delimiter: Allows you to choose the character that separates values within the CSV file.

    • Ignore Rows that Start...: Specify rows to ignore that start with a specific symbol, value or letter.

    • Ignore Rows that Contain: Specify rows to ignore that contain a specific symbol, value or letter.

    • Ignore First Rows: Specify a number of first rows to ignore.

  7. After you have selected all the relevant tables, click Done. The tables are added to your schema in the ElastiCube Manager.