If you do not have a green import button at the top right of your main screen, see Why do I not have an option to import data into my repository?
Import data into your system with an easy-to-use wizard.
Import instructions have changed. Click your version number below to ensure you access the correct instructions.
Supported formats
The following file formats are supported to import data:
- .XLS, .XLSX
As of version 1.5, Microsoft® Excel files are imported as datasets. In versions 1.4 and earlier, they are imported as events. - Apache log
Imported as events - .CSV
As of version 1.5, Microsoft® Excel files are imported as datasets. In versions 1.4 and earlier, they are imported as events. - Custom
Imported as configured by the user
How to import the files (Version11.2)
1. There are two ways to get to the import wizard:
- On the left toolbar, select Landing Page>Analyze Your Data
- On the left toolbar, select Data Import > Import New Data.
For further information, refer to versions 1.5 to 11.1.
How to import the files (Versions 1.5 to 11.1)
1. There are two ways to get to the import wizard:
- Go to the Landing Page and select Analyze Your Data:
- Click the green Import Data button at the top right of your dashboard:
2. Select your file format on the left side of the screen.
3. Click Choose File to navigate to and select the import file.
4. Click Next.
5. Analyze the preview. Make any desired updates. The following processing options are available:
- First row as header: Specify whether the first row is a header row.
- File encoding: Select encoding type. In version 1.6, you can choose the character encoding of CSV files at import. For example, you can select UTF-8 or Windows-1252.
- Column separator: From the drop-down menu select the column delimiter: comma, semicolon or tab.
- Decimal character: Specify the decimal number delimiter: period or comma.
- Date formats: Select a predefined Date format, or enter a Custom date format in the field provided.
6. Click Next.
7. Additional processing options are available on this screen. You can:
- Change the name of column headers. Select from the drop-down list or type over the existing header name.
- Map imported data to an existing field in the data model. Alternatively, select new property to import custom data.
- Remove a column
8. Click Next.
9. By default, .CSV and .XLS (or XLSX) files are imported as datasets. Choose whether you want to import the data into a new dataset or, if one or more datasets exist, import it into an existing one. By default, a new dataset has the same name as the imported file, but you can change it.
10. (In version 11.2, you can specify the length of time want the dataset to be retained. Selections are Temporary (1 Hour), Maximum available (5 Days), or a Custom length of time in minutes, hours, days, weeks, or months.
(For version 1.6 and later only. If you're running version 1.5, skip to the next step.) Click Next. You can specify the length of time you want the dataset to be retained. Selections are Temporary (1 Hour), Maximum available (180 Days), or a Custom length of time in minutes, hours, days, weeks, or months.
11. Click Next. An overview is displayed so that you can confirm the origin of the imported information.
12. Click Start Import to import the prepared file. Depending on the amount of data, the import may take a while. After you've started the process, you may close the import wizard to perform other tasks and come back to the wizard when the import has completed.
- If you choose to wait, then when the import process is complete, statistics about the import process are displayed on the Upload information page. Click Next and skip to step 3 of the View the Imported Data (Version 1.5) section below.
- If you've closed the wizard, you can resume it at this step later. See View the Imported Data (Version 1.5) below.
View the Imported Data (Versions 11.2)
To view all data previously imported, select Data Import > Manage Imported Data from the left toolbar.
For further information, refer to "View the Imported Data (Versions 1.5 and later)".
View the Imported Data (Versions 1.5 to 11.1)
To view all data previously imported, go to Main Menu > Import / Export > Data. The Manage Imported Data dialog box opens. It lists all data files that have been imported into the system. Perform the following to select a file and generate a dashboard to view the imported data.
1. Click the Edit icon of the imported file for which you want to view data. The Upload information page of the Wizard is displayed with statistics about the import results.
2. Click Next.
3. New viewlets are automatically created based on the content of the imported data. At a minimum, a table viewlet is created. Based on the data provided, other potentially useful viewlets, such as charts or maps, may be suggested. By default, all viewlets are selected. Deselect the viewlets you do not want to add to your dashboard. Click Next.
4. Create a dashboard for the new viewlets, or select an existing one.
5. Click Publish to publish your viewlets and view them.
How to import the files (Version 1.4 and earlier)
1. There are two ways to get to the import wizard:
- Either go to the Landing Page and select Analyze Your Data:
- Or click the green Import Data button at the top right of your dashboard:
2. Select your file format on the left side of the screen.
3. Click Choose File to select the import file.
4. Analyze the preview. If your file does not look correct, click Advanced to change processing options.
5. The following advanced processing options are available. Make desired updates and click Next.
- First row as header: Specify if the first row is a header row.
- File encoding: Select encoding type.
- Column separator: From the drop-down menu select the column delimiter: comma, semicolon or tab.
- Decimal character: Specify the decimal number delimiter: period or comma.
6. Additional processing options are available on this screen. You can:
- Change the name of column headers. Select from the drop-down list or type over the existing header name.
- Map imported data to an existing field in the data model. Alternatively, select new property to import custom data.
- Remove a column
7. The fields on the following screen are optional. Populate them to make the data more detailed.
8. Click Start to import the prepared file.
View the Imported Data (Version 1.4 and earlier)
To view all data previously imported, go to Main Menu > Import / Export > Data. The Manage Imported Data dialog box opens which lists all data files that have been imported into the system. Perform the following to select a file and generate a dashboard to view the imported data.
1. Select a file from the list of imported files and click Open to start the Wizard. The Wizard will alter the data, import it into a dashboard and create new viewlets.
2. New viewlets are automatically created. By default, all viewlets are selected. Deselect the viewlets you do not want to add to your dashboard. Click Next.
3. Select an existing dashboard or create a new one by giving your dashboard a name and selecting the number of columns in the layout. Click Finish to publish your viewlets.