Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Table of Contents
classcontents

Overview

Wiki Markup
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/t6BbCslVsWE?color=white" frameborder="0" allowfullscreen></iframe>{html}
 

Load CSV

Before importing a CSV file you will need to ensure the functionality is enabled and your CSV file is ready.

...

Expand
titleClick to Expand Instructions
Section
Column
width30%

1. Navigate to Administration > Admin Console, expand the Views section and click on the view you wish to import the CSV in.
Note: the selected view must be based on a writable data source.

Column
width70%

Section
Column
width30%

2. Edit the view and access the first step of the View Builder.

Column
width70%

Section
Column
width30%

3. Click on the Add CSV Table button at the bottom of the Database Tables list on the left.

Column
width70%

...

Expand
titleClick to Expand Details

Date Conversion

This allows you to convert a non-standard format date field (one Yellowfin doesn't recognise as a date by default) to a recognised date/time field, by specifying its format.
See Date Conversion 日付変換 for more information.

Timestamp Conversion

This allows you to convert values stored in Java time format (milliseconds since midnight January 1, 1970, GMT) to timestamps.

Numeric Conversion

This allows you to convert fields recognised as text by Yellowfin, that contain numeric values, to numeric fields.

...