Overview
You can use the Threat Analytics Manager to import .CSV records into Data Sources.
Using the wizard, it is easy to specify CSV header rows, field names, as well as quote and separator characters.
Importing the CSV File
To import the CSV record
- From the Treat Analytics Dashboard, click on Data Sources (top right).
- Under "What kind of source would you like to create?" specify "CSV Record Import Source."
- Click on Next.
- Configure the fields as described in the table below.
Field | Description | Note |
---|---|---|
File Path | Local file path where the CSV file can be located. | urls? |
Date | Specific date that you would like to associate with the uploaded CSV file | What is the benefit of this, especially for files where each record has different date/time? |
Time | Specific time that you would like to associate with the imported CSV file | |
Quote Character | Default: " | These should not require manual input, and should take defaults if user specifies nothing (currently throws an error). Default values should be viewable on GUI |
Separator | Default: , | |
Escape | Default: \ | Shouldn't escape also be on the GUI? |
Column Headers | Manually specify each column header | Shouldn't have to do this. Eg. If each header field starts with '#' they should be able to only specify this. Or leave blank for platform to do it automatically. |
Advanced Options
The following fields are also available for more advanced CSV import settings.
Field | Description | Note |
---|---|---|
Geo IP | Input the "src_ip" (source IP address) that you want associated to this record. It will be used to geocode the CSV field to latitude and longitude information. | |
Type | Not sure what this is referring to. | |