WebGuru’s Blog about Digital Life

How to change the Domain name URL for the SharePoint site

WebGuru — Thu, 29 Jul 2010 21:49:13 +0000

We just launched a new Intranet web site powered by the SharePoint 2007 (MOSS 2007). Everything works fine except the URL. By default, the SharePoint services uses the computer name of the server. But we need a nice name like “http://intranet” as the new site name. We created a new DNS record named “Intranet” and [...]

How to correctly import no-English (UTF-8) characters from MySql4 into MySql 5.0 with mysqldump

WebGuru — Sun, 02 May 2010 04:50:56 +0000

I tried to upgrade my WordPress to 2.9.2 but I had to upgrade my database MySql first since WordPress 2.9.2 requires higher MySQL version. Just like I usually did with the database backup routine, I used “mysqldump” command to export data from MySQL 4.0 and then used “mysql” to import data into MySql 5.0. Everything [...]

How to display SharePoint list from another site

WebGuru — Thu, 01 Apr 2010 21:29:42 +0000

There is no a straight way to add SharePoint list from another site to the web part page. Recently I found out a simple way to do so from Path to SharePoint blog. 1), Create a new Content Editor Web part on the page you are working on. 2), Paste the following code in the [...]

How to refresh a SharePoint page automatically in 60 seconds

WebGuru — Wed, 31 Mar 2010 17:25:43 +0000

As I indicated in my previous post, I need to set up a SharePoint page with some frequently-updated lists. And I need this SharePoint page to be refreshed automatically every minute. Here are some methods I tried. Method #1: Use Javascript in Content Editor Web part. A simple Javascript can refresh the web page automatically. [...]

How to add weather and traffic information to SharePoint page

WebGuru — Tue, 30 Mar 2010 16:47:00 +0000

Recently I added some weather and traffic information to one of our SharePoint page, and would like to share the process here. Of course, you will have to select the right web service based on your location. I use Georgia state here as the example. Normally to add external information to the SharePoint page, you [...]

How to open SharePoint link list item in a new window

WebGuru — Mon, 29 Mar 2010 15:11:00 +0000

In SharePoint 2007 (WSS 3.0), you can put any URLs in the Links List. But when you click any of these links, they will be opened in the same browser window instead of in a new window. I checked the Internet, and found a couple of ways to open the links list in a new [...]

Post emails onto SharePoint list

WebGuru — Fri, 26 Mar 2010 20:38:00 +0000

Challenge: We are using a service called Roam Secure Alert Network to notify subscribers about any news needs immediate attentions. These alerts can be posted through Web, Email and SMS. And the subscriber can receive alerts with emails, phone text messages. Recently we need an internal SharePoint web page to be developed to show all [...]

Issues with creating Database Connections to Oracle in SharePoint Designer 2007 (Resolved)

WebGuru — Wed, 17 Mar 2010 20:07:00 +0000

Challenges: I tried to connect to Oracle database in SharePoint (MOSS 2007). But got the following error when I tried to create a Database connections in Designer 2007. 1), Use custom connection string; 2), Select Microsoft .NET Framework Data Provider for Oracle as the Provider Name; 3) Post the below as the Connection String: Password=<passwd>;User [...]

How to pass InfoPath form fields to SharePoint workflow but hide from Document Library item properties

WebGuru — Mon, 08 Mar 2010 22:11:40 +0000

Challenge: Create a form in InfoPath 2007 and implement a SharePoint Workflow to it for approval processes. In each step, a Status field in the InfoPat form should be updated automatically according to the change of workflow task status. So a different view in the InfoPath can be opened based on the Status field in [...]

Be aware: New Law in GA which can cause you $500 fine

WebGuru — Thu, 04 Mar 2010 04:00:21 +0000

A few days ago, got an email forwarded by co-worker regarding a new law effective in Georgia. Its name is Move-Over Law, which says drivers must move-over for emergency vehicles stopped on the side of the highway. The law is meant to keep officers AND traffic violators safe from crashes with passing cars. Here is [...]

How to fix non working “Edit this task” button of SharePoint workflow notice in Outlook and InfoPath 2007

WebGuru — Mon, 01 Mar 2010 14:13:45 +0000

Challenge: Set up a workflow for the InfoPath form in the MOSS 2007 and the workflow worked fine. The approval notice had been sent to the next person’s mailbox, but the Edit this task button on the toolbar of Outlook 2007 did not work. When you click it, nothing happened. You can click the infopath [...]

How to remove XP Internet Security 2010 malware rogues

WebGuru — Thu, 25 Feb 2010 16:56:49 +0000

Today got a call from a friend and was told that her computer might be virus infection since a new anti-virus software always prompted up and warned her everything. And this new anti-virus is named “XP Internet Security 2010″, but she said she never installed it before. Now she was scared since too many viruses [...]

Reebok CrossWalk V 7.90 Folding Treadmill review

WebGuru — Tue, 23 Feb 2010 03:54:13 +0000

20" x 55" Running Treadbelt, 2.8 HP DURX Drive Motor, iPod® Compatible Music Port Costco price: $599.99 Shipping & Handling included Product Recommendations: Increase your cardio benefits and workout entertainment with the Reebok CrossWalk V 7.90. Equipped with all the extras, this treadmill will help you reach the finish line of weight loss. Burn [...]

SpongeBob SquarePants: Npower Fusion™ 1GB Digital Media Player Review and MTP device driver issue resolved

WebGuru — Mon, 22 Feb 2010 04:54:01 +0000

My daughter got this tiny media player as a Christmas present from one of my friends. It is a nice media player considered that it can play music, video and games with 1GB capacity on its price range (listed price $99 but Amazon.com is selling it for $21). And it has SpongeBob cartoon icon everywhere which [...]

How to use script auto-convert all WORD files into PDF with Office 2007

WebGuru — Sat, 20 Feb 2010 04:37:00 +0000

Say you have a few hundreds WORD (*.doc and *.docx) files on your computer, and you need to convert them all into PDF format files. Yes, you can open them and then Save As into PDF in WORD 2007 one by one, or you can highlight all of them (provided they are in the same [...]