Lab Page

Lab page enables users to upload their own CSV/JSON files into Lucidum platform and do a quick search/comparison on the uploaded files.

Add data to a new table #

Users can start with adding data to a new table. Under the “Add data to new table” tab, users can specify the new table name and the table description, then choose the CSV/JSON file to upload and click “Confirm” to add to the new table. Users can also click “Preview” to preview the file contents before uploading the file.

 

Add data to an existing table #

Users can append records in a file to an existing table. For example, one user might create a NMAP_Scan table last month and upload some NMAP scan reports. This month the user does another scan. Since the scan reports have the same format, the user will upload the new report to the same NMAP_Scan table.

 

 

To do this, users can go to the “Add data to existing table” tab, where it lists all existing tables in the Lucidum database. Users can select one existing table and click “append” in the “Action” menu to add new data to this table. In the pop-up window, users can change the table description and choose the file to be appended to this table. Users can also click the “Preview” button to preview the file contents before uploading the file.

Other actions include:

  • Overwrite: Users can click “overwrite” to overwrite the whole records instead of appending the new data
  • Delete: Users can click “delete” to delete the table
  • View: Users can click “view” to view the file upload history of the table

Search #

After uploading the file, users can go to the “Search” tab to query the data. The search functions here are very similar to those on the “Explore” page. The lab search also supports adding comments to the search results.

Compare two tables #

Users can easily compare two tables to find out the differences:

  1. Select the base table for comparison in “Table 1 (Base)”
  2. Select “Compared by” field for Table 1. Lab will use this field as an external key from Table 1 to link these two tables
  3. Select the second table for comparison in “Table 2”
  4. Select “Compared by” field for Table 2. Lab will use this field as an external key from Table 2 to link these two tables
  5. Click “Compare” button to show the differences between these two tables:
    • Red color: Records do not exist in Table 2
    • Green color: Records exist in Table 2 but not in Table 1
    • Yellow color: Records exist in both tables but have different values in Table 2
    • Users can also click the “deleted|added|modified” buttons respectively to filter the comparison results. For example, users can click “deleted” to only display the records that do not exist in Table 2

Compare two upload histories #

Users can easily compare two upload histories under the same table to find out the differences between any two uploads:

  1. Select the target table in “Table”
  2. Select “Compared by” field. Lab will use this field as an internal key to link the two historical file uploads
  3. Select the first file upload as base from “Upload History (Base)”
  4. Select the second file upload from “Upload History”
  5. Click “Compare” button to show the differences between these two tables or “Export” to export the comparison results to an Excel spreadsheet
  • Red color: Records do not exist in the second file upload
  • Green color: Records exist in the second file upload but not in the first
  • Yellow color: Records exist in both file uploads but have different values in the second upload
  • UserS can also click the “deleted|added|modified” buttons respectively to filter the comparison results. For example, userS can click “deleted” to only display the records that do not exist in the second file upload

Leave a Reply

Your email address will not be published. Required fields are marked *