Search Your Twitter Archive

-=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- (c) WidthPadding Industries 1987 0\|645\|0 -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=-
SoCoder -> Snippet Home -> File Access

Jayenkai	Created : 20 August 2021 Edited : 20 August 2021 System : Cross Platform Language : PHP Search Your Twitter Archive
Wanting to grab all my "Today's Stroll" tweets and bundle them into a spreadsheet, I tried all manner of Web Rip tools, but nothing seemed to do what I wanted. In the end, I instead downloaded my Complete Twitter Archive. Head to twitter settings/Your Account/"Download an archive" Takes about 24 hours to prepare, then it lets you download a huge (mine was 5gb!!) archive of all your tweets, along with all the included media and whatnot. .. And then I was right back at square one, because although I had all the files there, it was all a great big sodding mess. Eventually, I decided to write a php script to scan for a search string, and export anything it finds into a Tab-Seperated-Values file. Seems to work well enough. It hunts for the string within your tweets, adds it to the list of results, sorting them by date as it goes. The exported values include the date, \t, the tweet, \t, then a link to the tweet. If you've downloaded your twitter archive, you might find this useful. <?php // Change this to whatever you want to search for $search="Parappa"; // Include your handle, here $MyUsername="Jayenkai"; $sorted=[]; $sorttime=[]; $Tweets=-1; // Strip out filename-unsafe chrs $sfw=str_replace("'","",$search);$sfw=str_replace(".","",$sfw);$sfw=str_replace("+","",$sfw);$sfw=str_replace("*","",$sfw);$sfw=str_replace("?","",$sfw); ScanFile("data/tweet.js"); for ($n=1;$n<1000;$n++) {if (file_exists("data/tweet-part$n.js")) {ScanFile("data/tweet-part$n.js");}} $fo=fopen($sfw.".tsv","w"); for ($n=0;$n<$Tweets;$n++) { fwrite($fo,$sorted[$n]); } fclose($fo); function ScanFile($fname){ global $search,$fo,$sorted,$sorttime,$Tweets,$MyUsername; $fh=fopen($fname,"r"); while (!feof($fh)) { $in=fgets($fh,5120); if (strpos($in,'"tweet"')>0) {$link="";$tstamp="";$tweet="";} if (strpos($in,'"id_str"')>0) { $id=trim($in); $id=str_replace('"id_str" : "',"",$id); $id=str_replace('",',"",$id); $link="https://twitter.com/$MyUsername/status/".$id; } if (strpos($in,'"created_at"')>0) { $id=trim($in); $id=str_replace('"created_at" : "',"",$id); $id=str_replace('",',"",$id); $id=strtotime($id); $tstampT=$id; $tstamp=date('Y-m-d', $id); } if (strpos($in,'"full_text"')>0 && stripos($in,$search)>0) { $id=trim($in); $id=str_replace('"full_text" : "',"",$id); $id=str_replace('",',"",$id); $id=str_replace("\t"," ",$id); $id=str_replace("\r","",$id); $id=str_replace("\n"," ",$id); $id=str_replace("\\r","",$id); $id=str_replace("\\n"," ",$id); $id=str_replace("\\\"",'"',$id); $tweet=$id; if ($tstamp!="" && $link!="") { $Tweets++; $w=$Tweets; $sorttime[$Tweets]=0; $sorted[$Tweets]=""; for ($n=$Tweets;$n>-1;$n--) { if ($tstampT<$sorttime[$n]) {$w=$n;} } for ($n=$Tweets;$n>$w;$n--) { $sorttime[$n]=$sorttime[$n-1]; $sorted[$n]=$sorted[$n-1]; } echo "$tstamp\t$tweet\t$link\n"; $sorttime[$w]=$tstampT; $sorted[$w]="$tstamp\t$tweet\t$link\n"; } } } fclose($fh); } ?> --v

Comments
Friday, 20 August 2021, 12:59
PHS	Cool man.

Search Your Twitter Archive

Comments