Skip to content

Transformation of Information Structure

Transformation Highlights

  • The new structure only stores information from the CSV relevant to sticky note text analysis and recommendation generation.
  • Keywords extracted from the sticky notes by the NLP tool are added.
  • Recommended content information is added.
  • The new structure adds relevant metadata for:
    • The Mural file export.
    • The NLP tool used to generate keywords for sticky note texts.
    • The API run session information.
  • The new structure's fields are ordered for human reading.
  • Each section of the new structure has a distinct ID for future data access and modification tracking.

Original CSV Structure

This is the original structure of the Mural CSV export.

Sample of mural_sticky_notes.csv
ID,Text,BG Color,Sticky type,Border line,Position X,Position Y,Area,Link to,Last Updated By,Last Updated,Last Content Edited By,Last Content Edited,Tags,Integration Labels
0-1685223486498,I want to go to UW for UX ,#BAFFF5,circle,NO,2868.67,903.58,Intellectual,,E H,2023-05-27T14:38:06-07:00,E H,2023-05-10T18:06:42-07:00,,
0-1685223488741,I want to become an expert in Figma,#BAFFF5,circle,NO,2868.67,1140.28,Intellectual,,E H,2023-05-27T14:43:27-07:00,E H,2023-05-10T18:07:46-07:00,,
0-1685223493285,I should go to gym every day,#9BEDFD,circle,NO,3293.79,890.70,Physical,,E H,2023-05-27T14:38:20-07:00,E H,2023-05-10T18:09:13-07:00,,

View Full CSV

New JSON Structure

We created a new JSON structure to store the API data.

Empty JSON structure
[
  {
    "session": {
      "id": "10001",
      "call_time": "05/31/2023 3:30:00 PM",
      "url": "/session/10001",
      "tool": "Natural Language Toolkit (NLTK)"
    },
    "mural": {
      "mural_id": "MURAL05202023000001",
      "mural_url": "https://app.mural.co/12345",
      "mural_topic": [
        "Social",
        "Emotional",
        "Spiritual",
        "Intellectual",
        "Occupational",
        "Environmental",
        "Financial",
        "Physical"
      ],
      "sticky_note": [],
      "export": {
        "export_id": "202300520120000",
        "export_format": "json"
      }
    },
    "recommendation": []
  }
]

New Structure After API Call

Below is a sample of the JSON structure after an API call.

Sample of new_structure_full.json
[
  {
    "session": {
      "id": "10001",
      "call_time": "05/31/2023 3:30:00 PM",
      "url": "/session/10001",
      "tool": "Natural Language Toolkit (NLTK)"
    },
    "mural": {
      "mural_id": "MURAL05202023000001",
      "mural_url": "https://app.mural.co/12345",
      "mural_topic": [
        "Social",
        "Emotional",
        "Spiritual",
        "Intellectual",
        "Occupational",
        "Environmental",
        "Financial",
        "Physical"
      ],
      "sticky_note": [
        {
          "note_id": "0-1685223524232",
          "note_text": "I need an internship right now!",
          "note_topic": "Occupational",
          "note_keyword": [
            "need",
            "internship",
            "right",
            "career",
            "experiential learning"
          ]
        }
      ],
      "export": {
        "export_id": "202300520120000",
        "export_format": "json"
      }
    },
    "recommendation": [
      {
        "content_id": "UID15",
        "content_title": "How to Finad an Internship: Tips, Networking, and Professional Growth",
        "content_url": "www.content.com/uid15",
        "content_keyword": [
          "internship success",
          "tips",
          "networking",
          "professional growth",
          "experiential learning"
        ],
        "content_topic": "occupational"
      }
    ]
  }
]

View Full JSON