Step 3 - Create a Data Adapter

Tutorial 1 for Pro Version: Aggregate and Visualize Your Data

Step 3 - Create a Data Adapter in JSS

In JSS, go to:

• Repository Explorer Tab

• Right-click on Data Adapters

• Create Data Adapter

• Choose CSV File. Click Next.

• Name your data adapter the same name as your custom report.

• Click: "File" and select the txt file that was created when you downloaded the data from the custom report.

  • NOTE: You must tell the computer that you're not looking for a .csv file. Change the file type setting from "*.csv" to "*.*". (See screenshot.)

• Click: Open

Next,

• Click: "Separators"

• Change the field separator from "Comma" to "Tab"

Next,

• Go back to "Columns" Tab

• Click Get Column names from the first row of the file.

The column names from your custom report should appear in the window. Each column name should be on a separate line. If you are not seeing the column names, or all the column names are on one line, something has gone wrong.

>> Continue to Step 4. >>