Collecting and Processing Data from Uploaded CSV Files

To collect and process data for uploaded CVS files:

  1. Click the menu icon Hamburger_icon.ico,  to display the Navigation panel. 
  2. Select Data Collector.  
  3. The Data Manager window is displayed.
    Note: By default all Data Sources and Uploaded Files, Streams and Stream status are displayed in the Data Manager window. For details about the Data Manager window, see Business Collectors - Overview.
    If files have already been upload, skip to step 6.
  4. To upload a file, click Sources__Icon.ico . The Data Sources /Upload File dialog box is displayed.

Data_source_db_new.png

 

5. Browse for the file you want to upload. 

6. After the file is successfully uploaded, the Stream Query window is displayed.
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.ico To change file settings [File delimiter/ quote character/separator/escape character, decimal separator, include header row/ignore empty lines]

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 Metrics & Dimensions information is specified.  

7. To edit the query, click the Edit Pen. the Metrics and Dimensions  dialog box is displayed.

CSV_metrics_and_dimensions_DB_new.png

  • To add an item, drag from the repository on the left to the relevant Metrics or Dimensions pane.
    Note  At least one dimension and one measure [metric with a numerical value] are required.
  • To clear an item, click the X icon on the item.
  • Choose a time format from the drop-down menu.
  • 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.


8. Click Accept.ico  to accept the changes and return to the Stream Query window.

9. Click Next.ico. Anodot now retrieves the data from the uploaded file. Streaming will take a few moments - how long depends on your system and the amount of data to be processed. 
A Stream Table is displayed, showing the metrics and dimensions retrieved and a balance of your metrics account. 
File_Upload_Stream_query.png

Note:

MIissing_aggregation_type_icon.icoindicates that the aggregation type  [Average/Sum] is missing. Streaming is disabled until the aggregation type is defined for all the values. Aggregation type in uploaded files, must be manually specified for each value. 

10. Click Stream-It to stream the data into Anodot for processing.  

Note: If the retrieval process appears to be taking too long, use the breadcrumbs to return to the Stream Query window. Make the necessary changes and click Next.

To view the metrics created, navigate to the Anodot Metrics window.

See also
Business Collectors - Overview 
Collecting and Processing Data from Website Data Sources 
Editing a Stream Table
Editing What Columns
Fine-tuning Properties Columns
Adding User-defined Columns
Concatenating Properties Columns
Renaming What and Properties Column Headings

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