Home - Tech Blog

1/9/2012

Open .pages file in Windows or without Mac Pages!

I encountered a few .pages files that were created on a Mac.

I am using a PC and my MacBook doesn't have Pages on it, so I was a bit stumped as to what to do (short of asking the author to export them as PDF).

Instead, here is a solution:

change the extension to .ZIP and open the files with Winzip or whatever. Inside there, you will find a folder called "QuickLook." Inside Quicklook, you will find a PDF of the .pages document! Bingo! Copy and paste the content, and you should be good to go.

Posted at 1:04 PM by David Henderson | Category: Mac / OS X; Office 2007 | Permalink | Email this Post | Comments (0)

1/5/2012

Decipher an unknown text file with Wintext

I had a user with a file that had a WPD extension. Normally, this would be a WordPerfect file that could easily be opened in Microsoft Office or Open Office or a myriad of other programs. Nothing worked. Instead, all we got was jibberish. I even tried zamzar.com to convert it to Word, and that produced garbage.

After searching the net, I found a program called "Wintext!" Wintext will take ANY file and extract any viable text from it. With that program, I was able to pull out the text the user needed.

The file can be had from here:

http://www.softoxi.com/download-wintext.html

Posted at 3:19 PM by David Henderson | Category: Office 2007; Troubleshooting; Windows (Any version/All versions) | Permalink | Email this Post | Comments (0)

1/3/2012

Create expanded Announcements views WITHOUT Sharepoint Designer

I was having trouble with Announcements on one site: it kept cutting off the text. I searched for a "More..." solution where users could click "More..." to read the whole article, but came up empty. I know I have seen that somewhere, though.

In any case, I came up with another solution: Custom View.

First, go to the Announcements List you want to 'fix.'

Settings > List Settings > Create New View.
Name the view.
Choose items (Title with link to edit, body, created, etc).
Sort by Created.
Limit items to 5 or 6.
Save.

On the page with the webpart itself, modify the existing webpart then change the view to your new one. Viola!

Posted at 9:27 AM by David Henderson | Category: SharePoint - MOSS 2007 | Permalink | Email this Post | Comments (0)

12/14/2011

Kill the "Error in SYSFADER.EXE" crash!

Sometimes, when visiting a web page, Internet Explorer will crash with some kind of "SYSFADER.EXE" error. Here are steps to prevent that from happening again:

First:

Open Task Manager (hold the CTRL+Shift+Delete)
Click Processes tab
Select Sysfader.exe process (if it is running)
Click End Process to kill Sysfader.exe (again, if it is running)

Second:

Open Internet Explorer
Click On Tools
Click Internet Options
Click the Advanced Tab
UNCHECK the box next to Enable Page Transitions
Click Apply
Click OK

Third:

Right-click On the Desktop
Select Properties
Click On Display Properties tab
Click the Appearance button.
Click On Effects
UNCHECK the box next to Page transition effects for menus (should be top-most item in list)
Click Apply
Click OK

Now you should be able to visit web pages without seeing that stupid SYSFADER.EXE error!

Posted at 11:32 AM by David Henderson | Category: Internet Explorer; Troubleshooting; Windows (Any version/All versions); Windows XP; Win7 or Vista | Permalink | Email this Post | Comments (0)

11/21/2011

Windows Moodle Email STARTTLS error - fixed!

The Windows Moodle package is a great, easy way to get Moodle up and running on a Windows machine. The downside? Setting up email is a pain in the rump. It didn't have to be.

The problem we had was one where the SMTP server would respond with "STARTTLS" errors. I spent a LOT of time editing my sendmail.ini file (and even installed the latest sendmail for Windows). Nothing would cure the problem.

I started poking around the Moodle forums, and while they are generally helpful for many things, the STARTTLS error is not one of them. However, *nix forums ARE helpful.. sorta.

In the Moodle directory on your Windows server, you need to edit the class.phpmailer.php file *in addition* to setting up sendmail as your mailer. Why? Who the heck knows. In any case, here is what is working for us, so I hope it helps you!

FIRST: MOODLE ADMIN

Site Administration > Plugins > Message Outputs > EMAIL
Type your SMTP host, username, password as needed (you NEED the SMTP host, the others may be optional based on YOUR mail handler/mail host. Google requires it)
Type noreply@yourdomain.com for the no-reply address. Substitute your REALY domain for the "yourdomain" part there!

SECOND: SENDMAIL

Download the latest SENDMAIL to your Moodle server and unzip it to X:\moodle\server\sendmail (substitute the actual driver letter for X there!)
On your server, go to your X:\moodle\server\sendmail folder
EDIT the sendmail.ini file:

smtp_port=25 (usually leave this as is)
smtp_ssl=auto (could specify TLS here)
auth_username=valid.user@yourdomain.com
auth_password=ValidUsersPa$$word
hostname=yourdomain.com

THIRD: PHPMAILER

Navigate to X:\moodle\server\moodle\lib\phpmailer on your server (again, substitue your actual location for X)
EDIT the class.phpmailer.php file (use WordPad)
SEARCH for TLS
A few lines down, edit the "SMTPSecure" line:

public $SMTPSecure = 'tls';

DO NOT CHANGE ANYTHING ELSE IN THIS FILE!!

FOURTH: PHP.INI

Navigate to X:\moodle\server\php
EDIT the php.ini file:

SMTP = yourmailserver.com
smtp_port = 25
sendmail_from = valid.user@yourdomain.com
sendmail_path = "X:\moodle\server\sendmail\sendmail.exe -t"

SAVE the file.

Once you have done these, you need to STOP MOODLE then START MOODLE in order for the system to take the changes.

Moodle email may not run by itself. You can use Task Scheduler in order to call the CRON.PHP page in your Moodle environment. Or you can use MoodleCron for Windows. Very easy to use!

NOTE: Use at your own risk. This worked for me. I hope it works for you, but I will not be held liable for anything that goes wrong with your server/environment/etc.

NOTE: The above steps may be a bit of overkill. Some steps may not be required in order to get email working in Moodle. I have not gone back to determine just which step(s) worked. Once it was fixed, I didn't break it again.

Posted at 11:08 AM by David Henderson | Category: Moodle | Permalink | Email this Post | Comments (0)

11/18/2011

RichCopy: Microsoft’s File Copy Gem

Microsoft had (or maybe still has) a command line utility called "RoboCopy" that would copy files and folders, retaining their permissions (within same domain/workgroup).

That has been replaced (some time ago actually) by a program called "RichCopy." It used to be an internal Microsoft program, but they released to the general public some time ago. I just came across it and thought I would share!

The program first needs to be put into Advanced Mode. Do this by clicking VIEW > ADVANCED.

After that, click the little gear to check out the settings:

The main area that most techie folks will want to explore is "File attributes, Error Handling" because that is where you can set the security/permissions settings. But, notice on this screen above, there is an option for "Directory Copy: 3." This indicates the number of threads that the program will use during the copying process! Yes, that's right, whatever number you specify in there, that's how many different files can be copied at the same time! Well, at least how many can be copying at the same time. For example, if you are copying 2,000 files and you specify "10" in the box, it will start to copy 10 files. If some of those files are large, then the program continues to copy those (using up a thread for each file) but will keep copying with any available threads! This beats the tar out of copying one file at a time! In my case, I had several 400MB files that started, all the while the program plugged away at the smaller files it was encountering. Theoretically, you could have 10 threads all running with a large file copying in each one. I ran into that on my own server. But, it did not take long to muscle through those and pick up copying smaller files at a flying pace.

The program is available from Microsoft: HERE!

Just run the EXE which will extract several files into a folder on your hard drive called "c:\HoffmanUtilitySpotlight" and in there, you run SETUP. Easy peasy.

I also turned off some of the errors that would stop the copying. If the program ran into a file that it couldn't copy, for example, I just wanted it to keep on truckin. I would deal with rogue files later.

Posted at 1:54 PM by David Henderson | Permalink | Email this Post | Comments (0)

11/1/2011

Excel 2007 remains open after clicking X

When you work on a workbook in Excel 2007, then click the "Red X" (which is really a red BOX with a WHITE "X" but most of us call it the "Red X" anyway), Excel remains open and you have to click the "X" again to close the program.

There are two ways to cure this, and each has its positives and negatives. It it up to each person to decide what they can or cannot live with.

Method Number 1: In Excel, click the Office Button, then "Excel Options," then "Advanced." Look for "Display" section. In there, UNCHECK the box labeled "Show all windows in the Taskbar." This will let Excel close whenever the "X" is clicked. The downside? Now all your workbooks will appear in one tab on the Taskbar.

Method Number 2: Click START (or the MS Button for Vitsa/Win7), and do an advanced search for "Personal.xls" Note: You will have to search for HIDDEN/SYSTEM files and folders in your search options. You may NOT HAVE a Personal.xls file, in which case, use the first option. The downside? If you have any macros that run on startup, you will lose those by deleting your Personal.xls/Personal.xlsb file(s).

Posted at 9:28 AM by David Henderson | Category: Microsoft (General/Company); Office 2007; Windows (Any version/All versions); Troubleshooting | Permalink | Email this Post | Comments (0)

10/26/2011

Easily Create Block Quotes in Word 2007

There seem to be a lot of posts online asking, "How do I create Block Quotes in Word 2007?" But, the answers I've found are either useless, confusing, or both. It turns out to be a lot easier than anyone wants to explain. I thought I'd do it here:

First, type a paragraph that you'd like to be in the block quote format. Then, select that paragraph.

Next, click the 'breakout' arrow under the Paragraph section of the Home tab:

Once the Paragraph dialog box opens up, set the indentation for both right and left margins as needed:

Once that's done, click OK to apply the formatting. If the paragraph is no longer selected, re-select the paragraph and then click the drop-down in the Styles section of the Home ribbon. From there, select the option to "SAVE" the style:

You will be presented with a new box. Type the name of this style (I chose "Block Quote" so I could easily remember it!):

After you click "OK," you will see the newly created style in your styles list! Now, anytime you want a block quote, select the text and choose that style!

**UPDATE: Some folks have mentioned that this did not work. The key to making this work is that it applies to a paragraph. If you have used SHIFT-ENTER or have copy/pasted from web pages, that content is generally treated within Word as being the same paragraph. My number one suggestion is to go through your document and make sure you have proper paragraphing. If you need, turn on the 'hidden characters' to verify. If that fails, try highlighting the portion you'd like block-quoted and then apply the formatting. If *that* fails, then there is something else going on with the formatting of the document.

**UPDATE #2: I am still getting responses that it does not work for some folks. I've tried everything I could to create a scenario in which the entire paper gets "blockquoted," and it just will not do that for me. I cannot duplicate that problem. I wish I could so I could help with it. The only thing I can suggest is to copy the document into something like NOTEPAD and the copy it back to Word so that ALL the formatting is stripped out. I know that is ugly and is not really a "solution," but since I can't make it happen, I can't figure out how to fix it. If you would like, you can post the document to Google Docs (or some other online site) and leave a comment here with a link to the file. I could then download it (leave it as a word doc) and play with it. Leaving comments here REQUIRE my approval, so no one else would see the link. (I have also updated the timestamp on this since I've added a significant update.)

Posted at 11:40 AM by David Henderson | Category: Office 2007 | Permalink | Email this Post | Comments (33)

User's extension rings when trying to page

We've had several occasions where a user's phone will no longer allow us to page the extension directly. And direct dialing from the internal system just caused the phone to ring and go directly to voicemail. Here are a few possible things to check:

1. Be sure DND and/or call forwarding is turned off. This can be done at the extension by using the PROG soft key.

2. If all that checks out, try this: hit the SPEAKER button then dial 721 and you should see "VOICE" on the display. This will cause the extension to switch to VOICE INTERCOM. If the user wants the phone to ring instead, use SPEAKER 723.

I've had a hard time finding this information online, so I figured I would post it here!

Posted at 11:07 AM by David Henderson | Category: IPK-II Phones or System; Troubleshooting | Permalink | Email this Post | Comments (0)

Voicemail Light Flashes But No Message

User has voicemail light flashing and display reads:

MSG >>> SOMENAME