Week 4: Putting Code to Pixel | Ria’s Journey

Categories: Analytics, Case Studies, Implementation, | Sun, 21 Jun 2020 14:30:00 GMT
Blogs > https://www.sociallyconstructed.online/blogs/week-4-putting-code-to-pixel

If you’ve been following this series about our Partner Developer for Google Summer of Code implementing the Social Currency Metrics system, Last week Ria implemented the SCMS in our Standard Airtable format. 

This week Ria started coding the SCMSand we’ve cross-posted here! 

Putting Code to Pixel; My 1st week coding


​As of June 1st, 2020 the coding period’s begun! 

And this period’s started off teriffic!

​I get to understand the already written code, make drastic changes, and build new code systems and get to the final objective.

Picture: Definition of Debugging: being the detective in a crimve movie where you are also the murderer

I noticed that throughout my coding history, I had always undervalued the process of facing bugs, Now, I honestly feel that bugs make the entire coding process fun! After each set of debugging exercise, you tend to understand the main tasks in a better way, plus you get a sense of achievement, however small that might be. ?

So this past monday I put on my enthusiastic boots and set off to work.

I first understood which data attributes need to be extracted to maintain consistency in the output data. After this, I made a new enricher for extracting Github data for the Social Currency Metrics System. I have collected the comments made under a Github issue and under a Pull request.

We decided to keep the context for each GitHub comment, to bring more clarity and reduce idea redundancy to the table. So, I retrieved the ‘Title’ of a Pull request or ‘Title’ of an issue as the ‘context’. This is because the Title of the issue/PR conveys the same message as in the following comment. Similar steps were done while extracting mails from the mailing lists. The ‘subject’ of the mail was set as ‘context’ in this case.

Now, after performing an ElasticDump operation, I wrote a script called “ES2Excel” which converts data from Elastic Search indexes into a CSV file, further into an Excel format, and then further extending to an Airtable view.

Now, the data obtained by mails (MBox) and comments (Github) needed to be collected together in one excel sheet. So, for this, we perform “Aliasing” on ES indexes. We have 2 enriched indexes which we need to alias as a third index which can be used for creating CSV and Excel files.

The CSV sheet is then converted to an Airtable view using Airtable API. We execute ES2Excel script mentioned above on the aliased index. This Airtable view is ready for performing all tagging procedures to it. The output can be seen below.

Records of Github comments and mails in an Airtable view

Records of Github comments and mails in an Airtable view
Zooming a mail sent to Grimoirelabs Mailing list

Zooming a mail sent to Grimoirelabs Mailing list

Where we are and where we’re going


during our meeting on 5 June 20th I was given training about the various backround social theories that made the SCMS inlucing the “Grounded Theory Analysis” method.

It was fun to relate those theories with the Social Currency Metric System. Dylan and Venia also emphasized understanding the process of Community interactions and further bringing it to a codable form. My mentors suggested that we must have a third data source other than Github and mailing lists, to avoid biased data, so we’ll also be looking towards the addition of Twitter or IRC data in the next week.

For the most part next week, I’ll be focusing on converting the randomly tagged text data to ElasticSearch with the help of ‘Study’. The work done this week was nicely aligned with the timeline. Looking forward to more learning sessions! ?

Definitions in this blog:

You may wanna read these next

Share your thoughts with your own community to empower engaging conversation around your community’s health:

Share to Facebook
Share to Twitter
Share to LinkedIn
Share to Facebook

Venia Logan

I’ve spent the past 9 years learning the diverse skills necessary to create strong stable online communities that put your brand’s services at their center. ​​I started my own YouTube channel in 2010, and RESCQU.NET in 2013. I worked for Constant Contact, and returned to college for a specialization in online community management. Then I attained all 12 certifications from DigitalMarketer and helped dozens of communities. Spend fewer resources advertising to cold contacts or buying paid media and get back to focusing on what you love by growing a community that is financially and socially rewarding for you.