To collect and process data for uploaded CVS files:
- Click the menu icon , to display the Navigation panel.
- Select Data Collector.
- 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.
- To upload a file, click . The Data Sources /Upload File dialog box is displayed.
5. Browse for the file you want to upload.
6. After the file is successfully uploaded, the Stream Query window is displayed.
- File Data is displayed in the File Upload panel. Click
To preview the uploaded file
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.
- 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 to accept the changes and return to the Stream Query window.
9. Click . 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.
indicates 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.
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