30日間の無料評価版をお試しいただけます。

Versions Compared

Key

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

...

Expand
titleClick to Expand Instructions
Section
Column
width30%

1. Click Create in the main navigation menu, and select the Report option 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%

Image RemovedImage Added

Section
Column
width30%

2. Click the Create button on the Report Initialisation page Edit the view and access the first step of the View Builder.

Column
width70%

Image RemovedImage Added

Section
Column
width30%

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

Column
width70%

Image RemovedImage Added

Load

From here you will be taken to the ... CSV File step where you will need to locate and load the CSV file.

Expand
titleClick to Expand Instructions
Section
Column
width30%

1. Either click on the Browse Files link, or the CSV image to locate your file, or drag your file from the file system onto the grey area.

Column
width70%

Section
Column
width30%

2. Once selected, Yellowfin will confirm that the file has been uploaded.

Column
width70%

Section
Column
width30%

3. From here, if you have Advanced CSV Settings permissions, you can click on the Advanced Settings link, otherwise progress to step 4.
Advanced Settings include:

  • Field Separator - this allows you to specify which character is used in the CSV to separate values in the case that it's not a comma. If Other is selected, you can type your own character.
  • Precision - this allows you to define how many rows of the CSV Yellowfin will examine in order to define the field types and size.
    • Low Precision is fast, and only examines the first 1000 rows of the file.
    • High Precision is slower, depending on the size of the file, as it examines all rows.
Column
width70%

Section
Column
width30%

4. Once complete, click the Next button to progress to the formatting preview step.

Column
width70%

...

Configure Data

Styleclass
ClasstopLink

top

Once you've selected your file, and defined any settings required, you will be taken to the CSV Data step of the process. This is where you will be able to define several things, including Column Titles, Column Default Formatting Settings, CSV View Security, CSV View Table Settings, Additional Fields, and converted Converted Fields.

Data Step Options

These options are available outside of the Data Step menus.

...