Upload CSV Files

You have the option to upload one or more CSV files that will act as a data source.

Managing CSVs

In the Logical Data Model (LDM), you can link data from multiple CSV files within the same data source. This is not possible if the CSV files are in different data sources.

If you need to update or delete a CSV file, follow these steps:

1. Open the Data Sources tab.
2. Select your CSV data source.
3. In the dialog that appears, select the CSV file you want to update or delete.
4. Click the three dots icon on the right and choose the appropriate action. For updating, select a CSV file whose content will overwrite the previously uploaded CSV file.

How to Format Your CSV

To ensure maximum compatibility with GoodData, your CSV file should adhere to the following formatting guidelines:

Field Names

• Place field names in the first line of your CSV file.
• Field names must be unique; ensure there are no duplicates.

Quotation Marks

• It’s recommended to enclose string fields in double quotes (") especially if they might contain characters used as field separators or newline characters.
• If a string field contains a double quote character (") within, escape it by using two double quote characters ("").
• As a general guideline, adhering to RFC 4180 standards is advisable.

Newlines

Avoid using newline characters within fields. If unavoidable, use LF (\n) as the newline separator within fields and CRLF (\r\n) as the record separator.

Date

Your CSV file can accommodate various common date formats:

• dd-MM-yyyy, MM-dd-yyyy, yyyy-MM-dd
• dd-MMM-yyyy, MMM-dd-yyyy, yyyy-MMM-dd
• MMM dd, yyyy
• Dates can be separated by a dash (-), slash (/), dot (.), space ( ), or no separator at all (for example yyyymmdd).
• Both one-digit and two-digit day and month formats are supported.
• The following formats also support two-digit year representations: dd-MM-yyyy, MM-dd-yyyy, yyyy-MM-dd.

Example Dates

• 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

Time

• Only the ISO format HH:MM:SS is supported for time.
• We consider all times to be UTC, there is currently no support for timezones.

Limits

• A maximum of 250 columns is allowed.
• Each cell can contain up to 255 characters.
• The CSV file size must not exceed 200MB and the combined size of all the files must not exceed 1GB per data source.
• SQL Datasets are not supported when using a CSV file as your data source.

Disable CSV Uploads

If you prefer not to use this feature, you can disable it with the following API call:

curl $HOST_URL/api/v1/entities/organizationSettings \
-H "Content-Type: application/vnd.gooddata.api+json" \
-H "Accept: application/vnd.gooddata.api+json" \
-H "Authorization: Bearer $API_TOKEN" \
-X POST \
-d '{
  "data": {
    "attributes": {
      "content": {
        "value": false
      },
      "type": "ENABLE_FILE_ANALYTICS"
    },
    "id": "csv_disable",
    "type": "organizationSetting"
  }
}' | jq .