posted
03/02/10
By Fredrik Wall
I did buy me an iPhone last week.
And now I have been using it a lot since I
got it.
Yes I’m a PC guy with a iPhone
The applications that I use most after the
the iPod application is Gowalla and Spotify.
My top 10 applications so far:
Gowalla
Spotify
iPod
Facebook
Res i STHLM
Mail
Twitterrific
Maps
Weather
Clock
Yesterday I made a Trip in Gowalla.
Stockholm Crazy Commuter Train –
Stockholm Märsta.

If you got Gowalla you can add me
if you like. http://gowalla.com/users/walle75
At work I just plug-in computer speakers into my
iPhone and use the Spotify application.
My favorite music at work to and with good
sound.
And I got my Twitter account in my iPhone too.
Is there a better Twitter client then the free version of Twitterrific?
Does anybody use a good messenger client in iPhone?
posted
20/01/10
By Fredrik Wall
Bill Gates have signed up on Twitter.
And every geek and every IT person wants
to follow him.
5 Tweets and he’s got over 120 000 followers.
That’s pretty good!
Technorati Tags:
Twitter,
Bill Gates
posted
12/10/09
By Fredrik Wall
The IO Guy at Microsoft have posted
a poll about Twitter and customers.
Take the poll here.
I think this deserves that everybody that see
this take the poll. It’s an interesting question.
posted
24/07/09
By Fredrik Wall
This script is an updated version of the
How to Backup Twitter Friends with PowerShell and Excel
post earlier today. In this version I use the
out-Excel function by The Pathological Scripter.
[System.Reflection.Assembly]::LoadWithPartialName(”System.Web") | Out-Null
$userName = "username"
$password = "password"
Function Get-TwitterFriends {
param ($username, $password, $ID)
if ($WebClient -eq $null) {$Global:WebClient=new-object System.Net.WebClient }
$WebClient.Credentials = (New-Object System.Net.NetworkCredential -argumentList $username, $password)
$page = 1
$Friends = @()
if ($ID) {$URL="http://twitter.com/statuses/friends/$ID.xml?page="}
else {$URL="http://twitter.com/statuses/friends.xml?page="}
do { $Friends += (([xml]($WebClient.DownloadString($url+$Page))).users.user )
$Page ++
} while ($Friends.count -eq 100)
$Friends
}
function out-excel {
param ([string[]]$property,[switch]$raw)
begin {
# start Excel and open a new workbook
$Excel = New-Object -Com Excel.Application
$Excel.visible = $True
$Excel = $Excel.Workbooks.Add()
$Sheet = $Excel.Worksheets.Item(1)
# initialize our row counter and create an empty hashtable
# which will hold our column headers
$Row = 1
$HeaderHash = @{}
}
process {
if ($_ -eq $null) {return}
if ($Row -eq 1) {
# when we see the first object, we need to build our header table
if (-not $property) {
# if we haven’t been provided a list of properties,
# we’ll build one from the object’s properties
$property=@()
if ($raw) {
$_.properties.PropertyNames | %{$property+=@($_)}
} else {
$_.PsObject.get_properties() | % {$property += @($_.Name.ToString())}
}
}
$Column = 1
foreach ($header in $property) {
# iterate through the property list and load the headers into the first row
# also build a hash table so we can retrieve the correct column number
# when we process each object
$HeaderHash[$header] = $Column
$Sheet.Cells.Item($Row,$Column) = $header.toupper()
$Column ++
}
# set some formatting values for the first row
$WorkBook = $Sheet.UsedRange
$WorkBook.Interior.ColorIndex = 19
$WorkBook.Font.ColorIndex = 11
$WorkBook.Font.Bold = $True
$WorkBook.HorizontalAlignment = -4108
}
$Row ++
foreach ($header in $property) {
# now for each object we can just enumerate the headers, find the matching property
# and load the data into the correct cell in the current row.
# this way we don’t have to worry about missing properties
# or the “ordering” of the properties
if ($thisColumn = $HeaderHash[$header]) {
if ($raw) {
$Sheet.Cells.Item($Row,$thisColumn) = [string]$_.properties.$header
} else {
$Sheet.Cells.Item($Row,$thisColumn) = [string]$_.$header
}
}
}
}
end {
# now just resize the columns and we’re finished
if ($Row -gt 1) { [void]$WorkBook.EntireColumn.AutoFit() }
}
}
Get-TwitterFriends $userName $password | select name,screen_Name,url | out-excel
posted
24/07/09
By Fredrik Wall
Twitter have been cleaning out spamers and some ordinary users got cleaned too.
It can be hard to know wish Twitter Friends you had yesterday and whish you got today.
From now on I will use a PowerShell script that I wrote today.
I did some changes to James O’Neils Twitter Function Get-TwitterFriend to
get It to work with more then 100 Friends.
And then Export it to a csv file and imported it in to Excel.
This can be handled with a export or import to Excel function.
[System.Reflection.Assembly]::LoadWithPartialName(”System.Web") | Out-Null
$userName = "username"
$password = "password"
$txtFile = "c:\textfile.txt"
Function Get-TwitterFriends {
param ($username, $password, $ID)
if ($WebClient -eq $null) {$Global:WebClient=new-object System.Net.WebClient }
$WebClient.Credentials = (New-Object System.Net.NetworkCredential -argumentList $username, $password)
$page = 1
$Friends = @()
if ($ID) {$URL="http://twitter.com/statuses/friends/$ID.xml?page="}
else {$URL="http://twitter.com/statuses/friends.xml?page="}
do { $Friends += (([xml]($WebClient.DownloadString($url+$Page))).users.user )
$Page ++
} while ($Friends.count -eq 100)
$Friends
}
Get-TwitterFriends $userName $password | select name,screen_Name,url | export-csv $txtfile
Then start Excel
and Open, file types .txt and chose your file.

In the text import Wizard step 1
Change Start import at row 1 to 2.
Then we do not get the row with PowerShell’s information.

In the text import Wizard step 2
Change Delimiters from Tab to Comma

When Excel opens you got all of your Friends in an excel document.
To view whole names in columns just push down right arrow over
the first row and to the left of the first column.
No you have the worksheet marked and then just double click on the
line between column A and B.


The first Friends on the list is the last Friends you have added to
Twitter.
I hope this will help you!
My next post will be a PowerShell and .net Windows Forms App
for this.
posted
15/07/09
By Fredrik Wall
This was cool!
http://visibletweets.com/
Shows twitter feeds based on your choice.

And the animate it.
posted
15/07/09
By Fredrik Wall
I got 5 spotify invites to give away and I think you as
my follower, blog reader etc maybe want an account.
Leave a comment here with your mail address
or contact me at one of the following sites:
posted
13/07/09
By Fredrik Wall
Microsoft will stream the keynote at WPC09.
http://www.digitalwpc.com/
But for now the stream has some problems.
The nice thing is the live feed from Twitter.
As you can se, my twitter was there too