Adding Data from a File to a Workspace

Sometimes, you need to upload a set of data to your GoodData workspace (project) and analyze it on an ad hoc basis.

CSV Uploader lets you add data from a file without affecting the rest of the data in your workspace (production data). The data from the file is added as a separate dataset (non-production data) and does not affect the existing datasets. Once the data is added, you can immediately start analyzing it in Analytical Designer (see Create Insights) or in the Report editor (see Creating New Reports in the Report Editor).

To learn how to upload CSV files, see Getting Started with GoodData CSV Uploader.

CSV Uploader is available for Direct customers. If you are a Powered by GoodData customer and want to use CSV Uploader, contact GoodData Support.

Contents:

File Requirements

You can add data from a CSV file or a plain text file. The file must meet the following requirements:

  • Up to 1 GB
  • Up to 250 columns
  • Up to 255 characters per cell
  • Delimiters:
    • Comma (,)
    • Semicolon (;)
    • Vertical bar (|)
    • Tab ()
  • The date in a supported format
  • At least one column that contains numbers (measurable data)

    The measurable data is converted to facts with the DECIMAL(15, 3) data type. The numbers with a greater scale are truncated to three decimal places and rounded up/down.

Supported Date Formats

  • The order of day, month, and year:
    • dd-mm-yyyy
    • mm-dd-yyyy
    • yyyy-mm-dd
    • dd-MMM-yyyy
    • MMM-dd-yyyy
    • yyyy-MMM-dd
    • MMM dd, yyyy

    The MMM month specifier requires the month as an abbreviation (Jan-Dec) and is not case-sensitive.

  • Separators:
    • Dash (-)
    • Slash (/)
    • Dot (.)
    • Space ( )
    • No separator as in yyyymmdd
  • The year between 1900 and 2050 inclusive
  • No time stamp

Two-digit Year Format

 The following date formats support the two-digit format of the year:

  • dd-mm-yyyy
  • mm-dd-yyyy
  • yyyy-mm-dd

That is, 18-08-14 and 18-08-2014 are interchangeable and will both work.

If you use the two-digit year format, consider the following:

  • The values from 00 to 68 inclusive refer to the years from 2000 to 2068 correspondingly.
  • The values from 69 to 99 inclusive refer to the years from 1969 to 1999 correspondingly.

Let's look at some specific cases:

  • If you use the yy-mm-dd format, the date 66-12-12 will not be accepted: according to the rules, it refers to the year of 2066, and 2066 is outside of the allowed range (which is, between 1900 and 2050 inclusive).
  • If you use the yymmdd format, the date 661212 will not be accepted as a date for the same reason as in the previous case. Instead, it will be treated as a measure.

One-digit Day and Month Format

All date formats support both one-digit and two-digit formats for a day and a month.

That is, 01-08-2014 and 1-8-2014 are interchangeable and will both work.

Examples of Dates

The following dates are supported and will work well:

  • 18.8.2014
  • 08 18 2014
  • 08-18-14
  • 18/08/14
  • Aug-18-2014
  • 2014.aug.18
  • 18 AUG 2014
  • Aug/18/2014
  • Aug 18, 2014

The following dates are not supported and will not be accepted:

  • August 18, 2014
  • 8\18\2014

Add Data from a File to a Workspace

Steps:

  1. Go to the Load page, and click Add Data.
  2. Select the file that you want to upload, and click Load.
    A data preview opens. At this point, the data is just read from the file and not yet uploaded to your project workspace.

    Depending on the size of the file, reading the data may take a few minutes. Do not navigate from the page, or do not refresh the page while the file is being read.

  3. Follow the instruction on the screen, verify the data, and fix any errors when prompted to do so.
  4. Click Done.
    The data is uploaded to the workspace.
    You are redirected back to the Load page where a dataset with the newly added data appears in your dataset list.
    When data loading is complete, a notification is sent to your email address.

You can now start analyzing your data in either of the following tools:

Next Steps

  • In some situations, you may need to view the data uploaded from the file together with your model data. In such a case, you can manually connect the data from the file with the workspace data and create an insight based on both. Some constraints apply to such insights (see Combine Data Uploaded from a File with Project Data).
  • If you get an update for the file with the data that you uploaded to the project, you can accordingly update the data in your project (see Update the Data Uploaded from a File).
  • When you do not need the data anymore, you can delete the data from the project (see Delete Data Uploaded from a File).
Powered by Atlassian Confluence and Scroll Viewport.