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,,
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"
}
]
}
]