Research ways to sanitize malformed social media links in the database

[SAUMILDHANKAR]

Overview

Many of the social media links stored in the database are malformed. In this issue we will explore ways to clean up this data.

Action Items

• Research ways to correct malformed data in a database.
• Discuss the possible solutions with the team
• Implement the solution

Resources/Instructions

• devla site, all organizations

[SAUMILDHANKAR]

Progress Update: During the dev team meeting on 11/26/24 we discussed that I would share the csv containing updated links with John so the links can be directly updated in the production database. I will attach the csv here once done researching all the links.

[SAUMILDHANKAR]

Progress Update: I have checked the social media links for around 200 organizations out of total 1200 and am currently storing the updated links in a csv file. We discussed the next steps for this issue in the team meeting on 12/2/24 and some of the options to proceed could be:

1. Volunteers at UCLA might be better suited to update the malformed links.
2. Not the best approach to store updated links in a csv, should try some other method.
3. Another option could be to split the total organizations in one of the next team meetings so that the number of links to be updated is manageable per person.

Also, need to discuss where to store the csv file which I have been using for this issue, not sure if it should be saved with this issue. Will discuss this in the next team meeting which is officially on 12/23.