SyriaTel releasing a new service – My Backup

One of the two Mobile networks in Syria, SyriaTel, is about to release a new service called “My Backup”.

The service let you backup your mobile by first installing a software from the company (a .sis file some program) and then it uploads all kinds of data from the mobile like the SMS, MMS, Contacts, Calendar, and folders to be stored online, where you can manage them.

I heard the service will be like a subscription, there is a 3 months plan, 6 months, and a year subscription. The one year subscription costs 350 S.P (~$8). Without GPRS costs probably.

This service is especially useful when you lose your mobile or when it gets stolen, so then you can restore your mobile data.

I see this as a really cool feature and great advance in services provided by the SyriaTel.

There is a service which I’ve been using for a while to back up my mobile and it is Mobile Network independent, which is ZYB. The only thing I miss with ZYB is that it doesn’t backup MMS, SMS, nor special folders.

Share

Read Sharepoint 2007 Scale Survey with some statistics

Just an hour before letting the employees hit the survey link on our Sharepoint server, the department changed their mind and they doesn’t want the Single Choice for each question Survey I did. They wanted to change the type of the survey from Multiple radio buttons choices for each question(Which returns one Choice) to Scale Survey (GridChoice Survey in Sharepoint terms or Rating Survey) where the vote is of 1 to 5 scale for each point in a question.

Sharepoint does have a Scale Survey, but if you glimps at it you can’t tell who got the best score, which is something they wanted for the “Employee of the month”.

So in the same way I did to read the items of the Choice Survey, I did it again with some modifications. So instead of looking for the “Choice” type, I used “GridChoice”. Also, the value of the response is different. In a GridChoice value you woud see something like:

Co-operation#4#Skills#3#Outgoing#4#Ideas#3#Attendance#2#

This means the employee got a vote of 4 out of 5 for Co-operation,3 for Skills,4 for Outgoing,3 for Ideas and 2 for Attendance.

So now all I had to do is find a way to extract the numbers out of the string and sum up the numbers for each employe. To do that I did the following C# function:


  private int ResponceScore(string expr)
  {
  String[] numbers = System.Text.RegularExpressions.Regex.Split(expr, @"[^\d+]");
  int total = 0;
  foreach (String number in numbers)
  {
  if (number != "")
  {
  int num = int.Parse(number);
  total += num;
  }
  }
  return total;
  }

What the funtion does is it recieves the response’s text, use a regular expression to select or extract the numbers in the string, sum up the numbers of the response and send it back to be saved in an array or in a variable (Like adding to a variable for each employee).

So the final code is something like:

 

foreach (SPListItem item in SurveyList.Items)
  {
  foreach (SPField field in item.Fields)
  {
  if (field.TypeAsString == “GridChoice”)
  {
  if (field.Title.ToString() == “Employee Name”)
  {
  empScore+= ResponceScore(item[field.Title].ToString());
  }
}
}

So that is how I managed to do a web part to show the top scores in a Scale Survey in Sharepoint.

Have fun 😉
kick it on DotNetKicks.com

Share

How to read Sharepoint 2007 Survey list and get some statistics

Sharepoint Services is awesome new framework from Microsoft. And these days where I work, I mostly do Sharepoint 2007 and MOSS development.

I got this request where they wanted a Survey. Sharepoint does have survey, but it lacks statistics on the survey. In their Survey, the Choices for all the questions are identical. For example voting on “Employee of the Month”. MOSSAfter responding to this survey, they wanted to show the top employee in each Choice. The style of the answers are Choice type, where the user choose one of the option under the name of the employee. For example:
– Emplyee name 1
Choice 1: Co-Operation
Choice 2: Great Example

– Emplyee name 2
Choice 1: Co-Operation
Choice 2: Great Example
.
.
.

So the best solution is to make your Web Part read from that Survey’s items.

And to do that, we just need to loop through the Items of the Survey List, look for the “Choice” type of field in it and read its content (The choosen Choice. Choice 1 or Choice 2 … etc). The title of the field is the question text(Employee name).

So we need two loops one to look for the items, and one to look for items’ fields with the type “Choice” – then its title and content.

This is the code to do the loops and readings:

using (SPSite mySite = SPContext.Current.Web.Site)
{
using (SPWeb myWeb = mySite.OpenWeb())
{
SPList SurveyList = myWeb.Lists["Employee of the month"];
foreach (SPListItem item in SurveyList.Items)
{
foreach (SPField field in item.Fields)
{
if (field.TypeAsString == "Choice")
{
if (item[field.Title].ToString() == "Co-operation")
{
coop += field.Title.ToString() + ",";
}
else if (item[field.Title].ToString() == "Great Example")
{
example += field.Title.ToString() + ",";
}
}
}
}
}
}

Here I used normal string variables to store the names of the employees for each Choice, maybe you would like to use some sort of array instead, but I didn’t since I dont have many questions.

So when the code run, I will have something like the following in my variables:
Co-Operation variable: “Hasan B, Ahmad D, Farah H, Aya K, Hasan B, Amal K, Ahmad D”
Great Example variable: “Tahseen K, Sebhi J, Jafar A, Tahseen K”

Now by counting how many times each name is repeated for each choice, I can get an idea of who got the most votes for each choice.

I used the following C# function to count how many times each phrase or word accured in a string variable:

private string CountWords(string input)
{
char[] delims = new char[] { '.', ',', ';' };
string[] wordlist = input.Split(delims, StringSplitOptions.RemoveEmptyEntries);
SortedList words = new SortedList();
foreach (string item in wordlist)
{
if (!words.ContainsKey(item))
words.Add(item, 1);
else
words[item]++;
}
StringBuilder sb = new StringBuilder();
foreach (KeyValuePair kvp in words)
sb.Append(kvp.Key + ": " + kvp.Value + "
");
return sb.ToString();
}

So now from my Web Part I can write:

writer.Write("Co-Operation" + "
" + CountWords(coop) + "
" +
"Great Example" + "
" + CountWords(example))

And the function CountWords will return me the number of times a name accured in that passed string variable which represents the Choice.

For my example the output would look like:

Co-Operation
Hasan B: 2
Ahmad D: 2
Aya K: 1
Amal K: 1
Farah H:1
Great Example
Tahseen K: 2
Jafar A: 1
Sebhi J: 1

This code needs some additions to make it more useful, but I searched on the net, and I didn’t find answer for this, so I thought I would share with you what I got so far. I’m probably going to work more on this.

Hope it helped.
kick it on DotNetKicks.com

Share

Vista DVI problem

This is how I solved a problem which a lot of people are facing when they try connecting Windows Vista computer to a Flat Panel like LCD through the DVI output – you get “No Signal” or such a message from your TV.

I did a lot of research about this, and it seems to be the problem is in Vista drivers and how it handles DVI. If the LCD have VGA it would be much easier since the VGA is Plug and Play.

Microsoft promised to fix this bug with SP1. Now SP1 is out and seems it didn’t really fix the problem! At least it didn’t for me when I was trying to connect the computer with a 52″ Sharp LCD through DVI.

I tried updating the Graphics’s card driver, didn’t help. Tried to use a program called PowerStrip to define custom resolutions to be compatible with the LCD, also didn’t help.

At the end, I replaced the DVI cable with “DVI -> HDMI” cable, and finally it did work!

I didn’t remove the PowerStrip software, because I think I need to use it to define a custom resolution for the big LCD.

Share

Kids Cancer Support Walking

Last Friday (15 Feb 2008) Kids Cancer Support Walking 2008 took off in Damascus, Syria.
Kids Cancer Support Walking 2008 in Damascus, Syria

The event was organized by Basma organization and the marketing campaign by U.G.

This walking was arranged to raise the attention and understanding about Kids Cancer, and at the same time try to entertain the Kids.

There were some activities for the Kids like Painting, Painting on the faces, Clowns, lunching balloons, gifts, and some other stuff like small dances 🙂

A few facts I learned about Kids Cancer and some people should know about:

  • Kids Cancer can effect kids from the ages 1 month to 18 years old.

  • It is curable, but costs so much and needs specialized doctors. Unfortunately in Syria there isn’t enough support. There is one Center in Damascus which is lacking financial support and expertise. The available doctors aren’t much specialized in this.

  • Cancer is NOT contagious! I heard stories saying that some parents lock their infected kids from the world!

Basma is an organization which try to help in this. Visit their site to get to know more about this and learn how you can help.

UPDATE: Here is a small Video capture I took from the event when the kids released the Balloons.

Kids Cancer Support Walking – The best video clips are right here

Share