Dalle & DXter

I’m a pc geek with a iPhone

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?

 

Bill Gates at Twitter

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!

 

Poll about Twitter

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.

 

How to Backup Twitter Friends with PowerShell and Excel Automatically

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

 

How to backup Twitter Friends using PowerShell and Excel

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.

 

Visible Tweets

By Fredrik Wall

This was cool!

http://visibletweets.com/

 

Shows twitter feeds based on your choice.

 

And the animate it.

 

 

 

5 Spotify invites for my followers

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:

 

Waiting for the Video Stream at WPC09

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