CSV One-time Upload

This article contains sections on:

Uploading a CSV File Upload Data Source
Creating a CSV file upload stream query
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.
    CSV_Stream_query_uploaded_file.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

Row errors  are listed and include a brief description

  • The default stream name, File Stream 12/14/2017 10:57 is the time stamp when the stream was created. You can edit the name.
  • Missing Measures & Dimensions information is specified.  

3. To edit the query, click the Edit Pen. The Measures and Dimensions panel is displayed.

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.

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

5. 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