j-j.co.za
Sharing thoughts and ideas on business, security and photographyNasty little hack, but it works.
- Download Curl
- Download the OpenSLL DLL’s
- Create your text file with the list of Twitter accounts you want, one line per account (twits.txt)
- Create your batch file in the same folder as the above 3, just the following 2 lines needed (doit.bat)
- DEL out.xml
- FOR /F %%i IN (twits.txt) do (curl http://twitter.com/users/show.xml?screen_name=%%i >>out.xml & ping -n 2 -w 1 127.0.0.1>NUL)
- Run the batch file, it creates “out.xml”
- Load the XML file into notepad/wordpad
- Search and replace to remove the following <?xml version=”1.0″ encoding=”UTF-8″?>
- Except for the first line which must remain
- Then add in <twits> as the second line in the file and </twits> as the last line of the file
- Now save the XML file
- Load it into Excel.
- All done, enjoy
This is the third post in four days on the matter of the top twitter users in (South) Africa, ranked by number of followers.
You can read the previous posts here explaining how this arose:
- Will South Africa’s real Top Twits stand up (25/7/2011) – How it all started
- The new improved (South) African Top Twits July 2011 (26/7/2011) – The updated second version, then updated again for a third version
See the final list here : j-j.co.za/toptwits
Yesterday’s post (here) attempted to list the Top Twits (by number of followers) in (South) Africa. If you didn’t read the post yesterday, take a read to see where this all started. It had some flaws. There were some big names missing. After some manual processing and prompting for various parties, here is the new improved (still very much draft) (South) African Top Twits. The top 10 has changed a bit, and beyond that even more so. To make yesterday’s top 50 you needed 13 251 followers, today that has jumped to 22 613.
Once again, if there are some big names out there that have been missed please let me know.
Change log :
- Removed duplicated @BusRep, @BibleThoughts now makes it in at number 50 (26/7/2011)
- Added in some more users @Elbaradei, Jacob Zuma (SAPresident), Presidency, MetroFM (27/7/2011)
- Expanded the list to top 60 (so that some didn’t drop out of yesterday’s list)
- Included the date updated field
- Checked the numbers of all the accounts listed against current twitter.com numbers as previous sources were unreliable. Checked the balance of the top 120 as well just in case any jumped up the list, some of which did.
Read the rest of this entry »
Update : See the final list here : j-j.co.za/toptwits (updated monthly)
The Strategy Worx recently released their ‘Social Media in SA – The Numbers‘ Report for Quarter two. Makes some interesting reading. There is some discussion on Google Plus here.
In the report is a list of the Top 20 South African twitter personalities. The list was interesting, but on reflection seemed to be missing some of the people who I would have expected to be in the report. There appear to be some obvious missing ones eg. DJ Fresh 98 656 followers and Pigspotter (Cliff) with 61 000 Jack Parrow 22 281 Steven Pienaar (ok, he lives in the UK most of the time) 67 480 John Robbie 23 377, Bryan Habana 46 270 etc etc
I quickly posted a question on the discussion asking what was the selection criteria for this? After going back and reading the report more closely I found the reference : http://twitaholic.com/top100/following/bylocation/South%20Africa/
Going onto Twitaholic and playing a little gave some insight into the problem. The query used only picks you up if you list South Africa (Country), not City, Country (Eg. Durban South Africa).
This is very clear, Bruce Attridge in Durban, South Africa has 213 000 followers and is top of the Durban list, but doesn’t come up (would be 1st) in the South Africa query. Problem. Playing a bit more and you find that Durban, Durban South Africa and South Africa all produce different lists.
To top it all off, looking at the follower numbers shows some more problems. I am listed way down on the list (not that I have that many followers), but the numbers were vastly different from what Twitter shows as my followers. It seems the list is quite dated. If you click on a user, there is a button to “Update my Stats!” which can be used once a day. A manual process – though some numbers are more recent than others. Ok, so the data is flawed.
Mail me at justin.j.williams (at) gmail.com and I will send you an invite.
What is Google Plus? Another social network, that is still busy developing and evolving. It is almost a combination of Twitter, LinkedIn and Facebook. Most of the people I am following use it more for sharing articles / news / opinions than personal information, so for me, it is more like LinkedIn and Twitter. The beauty in the design of the circles is that you can use it for whatever you and your social/professional circles choose.
Keeping up with the local deals – bring on “Today’s Deals”
Justin | 3 Comments » Posted on April 02, 2011There are now a number of collective buying sites (in the vein of Groupon) that are operating in South Africa. You can get some really good deals from them and I have bought quite a number of things from them over the last 3 months or so, ranging from dinners, sailing cruises, Blo-kart racing through to massages and other pamper sessions (yeah those were for the girlfriend, mostly
Originally there was just Wicount and Twangoo (now bought by Groupon) that were of interest and doing good deals, but now there are more competitors in the space all providing good deals (across multiple cities) I am finding my email inbox is getting flooded and it is a pain to try and keep up with all the deal, and it is really easy to miss the good ones.
Bring on “Today’s Deals – all the deals in one place” recently started by Eve Dmochowska. This great site monitors the other deal sites for you and acts as a central hub to monitor them all. So far it includes:
- Collective Cow (www.collectivecow.com)
- One Day Only (www.onedayonly.co.za)
- Zappon (www.zappon.co.za)
- Dealio (www.dealio.co.za)
- Ubuntu Deal (www.ubuntudeal.co.za)
- Vuvu Plaza (www.vuvuplaza.com)
- 24 hours only (www.24hoursonly.co.za)
- Groupon MyCityDeal (www.mycitydeal.co.za)
- Wicount (www.wicount.co.za)
The only one that I watch that’s not on the list is Twangoo (www.twangoo.co.za) though with the takeover by Groupon it seems to have a lot of deals in common with MyCityDeal. Still worth watching that one by itself for now.
These deal sites now cover Johannesburg, Pretoria, Capetown, Durban and National Deals so there is something for everybody.
Add this site, Todays deals, to your daily watch list, subscribe by email or use the RSS feed and enjoy the bargains. Thanks for the great service Eve.
P.S. I have bought from Wicount, Twangoo and Zappon. All work very well, other than a few minor niggles. Zappon is the newsest on the block of those 3 and had the most problems, but their user support team was quick to resolve my issues in a friendly and efficient manner.
Vodacom COLOR provides good value prepaid SMS/Data bundles for under 25s
Justin | 2 Comments » Posted on September 09, 2010My daughter alerted me to a new R29 Vodacom bundle for Under 25’s. Vodacom COLOR is a free service for Under 25’s. When you sign up you get 15 MMSs, 15 SVSs and 3MB data FREE every 30 days. On top of that your get to buy COLOUR UP add on bundles.
The “COLOR UR FRIENDS” bundle gets you 100 SMS and up to 100 Meg of data to be used for The Grid, Mxit and Facebook mobile. That’s a fairly decent price compared to a standard SMS bundle, you are basically getting your Facebook and Mxit access free for the month. Only one of these bundles can be used each month. The other bundles are for those interested in Games, Music, or early morning cheap calls.
To sign up SMS agent135 to 31118, it’s a free SMS. (Disclaimer, that is my daughter’s agent code). Once you are signed up you can buy the other bundles (at R29 each).
To read more about the COLOR packages, terms and conditions etc you can go to the website here. Sam can also help with questions and setup, get her on : samibabez93@yahoo.com , facebook or twitter @samw1993 .
ISACA South Africa is now live on Twitter.
We intend to see how we can use Twitter to promote ISACA South Africa and our activities, including the annual conference and the regional chapter meetings. Follow us to keep up to date on ISACA happenings, especially around the conference coming up next month (13-15th September).
Follow us at : www.twitter.com/isacaza and ISACA International here : www.twitter.com/ISACANews
And find ISACA South Africa’s website here : www.isaca.org.za
Reports on DLP, Service Auditor Standard & Social Media Security
Justin | No Comments » Posted on August 02, 2010Social Media: Business Benefits and Security, Governance and Assurance Perspectives (ISACA)
This week, ISACA released a white paper outlining the five biggest risks posed by social media in the workplace–and how to manage them without banning the technology. The download page also includes links to a number of other usesful reports on social media by Forbes, Enisa, Web-strategist, and socialmediagovernance.com.
Download the ISACA report here
New Service Auditor Standard (Replacing SAS70) : A User Entity Perspective (ISACA)
The International Auditing and Assurance Standards Board (IAASB) and the Auditing Standards Board (ASB) of the American Institute of Certified Public Accountants (AICPA) have recently approved new standards for reporting on controls at a service organization with a truly global constituency in mind. Under the approach adopted by the IAASB and the ASB, Statement on Auditing Standard No. 70 (SAS 70) will be replaced by two new standards: an attestation standard that will guide service auditors in the conduct of an examination of, and the resulting reporting on, controls at a service organization and an auditing standard that will guide user auditors in consideration of internal control when processing is performed by a service organization. While these new standards are intended to be a communication from the service auditor to the user independent auditor that permit a user entity independent auditor to fulfill auditing requirements, management at user entities also has recognized its responsibility for designing and implementing internal control over financial reporting, whether performed internally or by a service provider, and acknowledged the benefits of SAS 70 reports as part of their risk management, vendor management or regulatory compliance processes. This paper will address the changes in the new standards and will focus on providing management of user entities with valuable practical guidance on their responsibilities to help ensure that they are ready for the changes.
The 2010 Data Loss Prevention Report (Aberdeen Group
AberdeenGroup have temporarily made their 2010 data loss preventation report available for free download.
Report Intro:
Companies achieving top results successfully use content-aware technologies to identify sensitive data across multiple channels, and to invoke a range of remediation options to enforce established security policies. In doing so, they reap the substantial benefits of fewer incidents of data loss or data exposure, fewer audit deficiencies, and lower operational cost.
I just added a Facebook ‘like’ button to the site. It appears below each post (for now) and let’s people like a particular article, with the added benefit that it posts through to their Facebook page, with an optional comment if they like.
I have used the WordPress “Like” plugin by Bottomless (found here). The quick bit of testing I have done so far seems to show that it works well enough. I will test it out for a while and then see whether to keep it on, come up with another option or what to do.
If anyone has added something similar to their site and would like to share the experiences please do. The more input and ideas the better. I am already thinking I would like a “social media” bar that gives the option to Facebook Like, Tweet etc all from one place instead of having in a number of different places. I have yet to find something that does that for me. Will keep looking.
Visualising twitter at Conferences / Interacting with the web
Justin | 3 Comments » Posted on July 25, 2010The ISACA South Africa Annual conference is coming up in a few months and I though it would be pretty cool if we could have some kind of real-time visualisations of what the twitterverse (or net) was saying about the conference.
So this morning I was reading up on how best to do this and the first article I came across was 5 Ways to Visualize Twitter at Events which was on the Event Manager Blog : http://www.eventmanagerblog.com/event-management/visualize-twitter-at-events
This starts by answering the questions “A lot of fuzz is being made about if tweets should be displayed at events or not. The answer is simple, Yes! And in a fancy way.” and then proceeds to list 5 options for methods/tools that can be used to achieve this, and gives some pro’s and con’s for each.
Based on this article and the followup comments I whipped through the tools to see what might be suitable and jotted down some of my own thoughts. These are still fairly preliminary and I need to do some more investigation into features being offered and the overall robustness of the solutions.
The 4 tools I took a look at were : visibletweets, wiffiti, twazzup and twitterfountain
The tool we use (if the concept is approved) would probably run from a laptop with a projector attached and run in an unattended fashion. I wanted to be able to select a few keywords / #hashtags, have some kind of title (or instruction) on the page, be able to add a custom background, and have cool visualisations of the results. I suspect the display is also going to have to run over a 3G connection at the conference, so it will also need to be reasonably bandwidth friendly, but that will have to be tested at a later stage.
My thoughts based on this rough criteria for each of the options is briefly noted below :
Visible Tweets (www.visibletweets.com) Sample link
- Supports multiple keywords, tags, and exclusions
- 3 visualisation options suited for conference projections (looks great) and full screen operation (unattended)
- builds tag cloud which displays between tweets
- displays profile picture of tweeter
- simple to setup and custom URL
- No header option or custom background
- Doesn’t seem to support twitpic or other picture services
- Can make use of TidyTweet service to have filtered/moderated tweets (and prevent profanity/embarassment), $10 /month for non-personal use
Conclusion : Fairly good option, quick and easy to set up, would be better with a bit more customisation and twitpic support
Wiffiti (www.wiffiti.com) sample link
- Allows custom background to be uploaded
- Custom title can be set
- Does censorship (can set rating level)
- Allows multiple tags
- Can use pictures from flickr with tags
- Displays tweets with profile picture, tags and location
- Accepts mesages directly from website
- Accepts SMS however is USA based short message code, not clear if could get a South African number
- Easy to set up, however required signup to “publish” the screen and save it
- Visualisation looks pretty good with multiple messages onscreen at once, full screen option
Conclusion : Very professional looking service, definitely one that could do the job.
Twazzup (www.twazzup.com) Sample Link
- looks good in a browser for individual use but doesn’t seem suitable for conference projection
- breaks the page up into different sections giving Highlights, Community Influencers, Live pictures, News, Twitter stream.
- No custom headers or backgrounds
- Seems to displays pictures (twitpic etc)
- Lists common links
Conclusion : This is great way to get a view on a topic, but not for conference projection
Twitterfountain (www.twitterfountain.com) Sample link
- does pictures in background, tweets scaled flying into background
- gives twitter profile picture, name, tweet
- link to blog top right (cant seem to remove)
- banner across top (defaults to twitterfountain) and can be customised / removed
- options for how messages animated
- background image allowed
- can change size of tweets and how they are displayed
- fullscreen option
- The URL generated for the fountain doesn’t contain all of the settings so these would have to be set up again each time
Conclusion : Also a viable option, not quite up to wiffiti, and I prefer the visualisation of visibletweets (although twitterfountain has far better customisation and does support the custom backdrops and banner whereas visibletweets doesn’t)
Summary (for now)
Each of these products is great in its own right, having a time and place where it may be the most suitable. For the conference I would tend to think either visibletweets (using tidytweet) or wiffiti would be the best options, though twitterfountain still needs a bit more investigation. More to come later.