CSV One-time Upload

This article contains sections on:

Uploading a CSV File Upload Data Source
Creating a CSV file upload stream query 
Editing a Summary Table 
Parsing and Importing Settings  
Setting Customer Specified Parsing Parameters

 UPLOADING A CSV FILE UPLOAD DATA SOURCE

  1. In the Data manager window, click Source +.
  2. In Sources Types window, click START on the CSV_icon.ico icon. 
  3. Navigate and open a CSV file. After the file is successfully uploaded, the Stream Query window is displayed.

Note The file must be formatted using RTF-8 encoding with ASCII character sets.

CREATING A CSV FILE UPLOAD STREAM QUERY

If you have just created a CSV file upload data source, skip to step 3.

  1. In the Data Manager Sources + panel, choose the CSV file upload source for which you want to create a stream query.
    Note The streams associated with that source are displayed. If the Streams panel is empty, no stream queries exist for that source.
  2. Click Streams + to display the Stream Query dialog box.
    No_dimensions_-_AL_2858_01.png

Note

  • File Data is displayed in the File Upload panel. Click

EyeIcon.icoTo preview the uploaded file

File_settings_icon_update.ico To change parsing and import settings.
         See Parsing and Import Settings for CSV files

  • If there are row errors, they are listed in the File Upload panel. 
    Row_errors__1_.png
  • File Stream [date/time] is the default stream name. You can edit the name.

3. Click NEXT. The Stream Table is displayed. See Stream Tables.

Note
If there are no measure columns in the Stream Query, an editable Events Count column is automatically inserted in the Stream Table.

EDITING A STREAM QUERY

  1. To edit a Stream Query, click the Edit Pen in the Stream Query Measures & Dimensions window. 

CSV_measures_and_dimensions_panel.png

  • To add an item, drag from Available fields to the relevant Measures or Dimensions column.
    Note  At least one dimension and one measure [with a numerical value] are required.
  • To clear an item, click the X icon on the item.
  • Either choose a predefined date and time format from the drop-down menu or enter a user-defined date and time format. 
  • Choose a time zone. The time zone may be either from your browser, your file or a specific location.
    Note  The time stamp definition and the time pattern are required.

2. Click X to accept the changes and return to the Stream Query window.

3. Click NEXT. The Stream Table is displayed. See Stream Tables

PARSING AND IMPORT SETTINGS 

When uploading a CSV file, Anodot data analyzer detects parsing parameters. 

Parsing_and_Import_Settings.png

To accept the system-detected parsing parameters, click X

SETTING CUSTOMER SPECIFIED PARSING PARAMETERS

You can set your own parameters. Set any of the following parameters:

File delimiter Comma ,
  Ampersand &
  Tab  
  Pipe |
  Semicolon ;
  White space  
Quote character None  
  Double quotes "
  Single quotes '
Thousands separator None  
  Comma  ,
  Dot .
Escape character None  
  Back slash \
  Circumflex ^
  Record separator  
Decimal separator None  
  Comma ,
  Dot .

In addition, you can set to

  • Display header rows
  • ignore empty lines
  • Replace empty cells (fill with 'unknown')

Click APPLY to save the new settings.

SEE
Using Data Collectors
Data Manager
Stream Tables
Viewing Stream Summaries

Was this article helpful?
0 out of 0 found this helpful
-->