Google sheet channel synchronization improvements - Githubissues

bellingcat / cisticola

Coordinates scrapers and interfaces with database

15 stars 0 forks source link

Google sheet channel synchronization improvements #57

Closed loganwilliams closed 2 years ago

loganwilliams commented 2 years ago

No longer expects 'followers' column in Google Sheet
Will update the platform ID and screenname columns using the channel info data
Will highlight possible duplicate channels in the Google Sheet

Related changes to ChannelInfo class:

This class was missing certain database columns in the DB definition. Before deployment the channel_info table will be dropped and regenerated.

Related changes to Telegram scraper:

Uses channel ID where possible instead of screenname. This should be the default for all of the scrapers, I can't remember why I didn't do this for TelegramScraper, I hope I didn't have a very good reason.