Showing posts with label programs. Show all posts

Working with Large Lists

Photo by Stuart Miles
Bossman got you facepalming on your latest project? Working with large subscriber or customer information lists can be a headache. You may run into a project where you have to combine several types of lists with different column information and they don't match up with your new system. You might have to prune, merge, cut or otherwise make sure a huge list is clean/tidy. Microsoft Excel can handle csv files, but keep in mind that Excel does have its limitations:

Microsoft Excel has size limitations:

Here are some alternate tools and information I've run into to help maintain your larger lists:

CSVed
For managing large CSV files (think super-excel):
http://csved.sjfrancke.nl/

CSV Splitter
For splitting huge CSV files (can keep header and apply to split files):

Combine using Command Prompt
How to combine several CSV files into one file using cmd:

Classic Menu for Office

I've had several requests from users to keep older versions of Office because they don't know how to navigate the newer Office "ribbon" menus. Microsoft has made it a pain for legacy users who may not have the patience or time to relearn an entirely new navigation system.


UBitMenu is a snazzy little program that adds back the classic menu from Office 2003 to your modern Office suite. It adds an extra tab called "Menu" with all the familiar items you are used to. Here's the website where you can download the applicaton:

http://www.ubit.ch/software/ubitmenu-languages/

Google Chrome for All Users

If you go to http://www.google.com/chrome, you can download one of my favorite web browsers:


Google Chrome Speed Tests - HD

I ran into an issue a couple weeks back and discovered that when you install Chrome from http://www.google.com/chrome, the program installs to your local profile. This means that if you have someone else using your computer on a separate account, the 2nd user might not see your Chrome installation.

Solution?

If you go to http://pack.google.com, you can download and install Chrome via Google Pack. This will install Chrome in your My Programs folder rather than your local profile (where there's a good chance that nobody else could access it).

Ctrl+Alt+Del for Remote Desktop

When you're using Remote Desktop, you can't use ctrl+alt+del to bring up the remote computer's task manager. Here's an easy solution: use ctrl+alt+end

Also, here's a video on the history of Ctrl+Alt+Del:


Down Them All! - Nice File Download Manager


DownThemAll (or just dTa) is a powerful yet easy-to-use Mozilla Firefox extension that adds new advanced download capabilities to your browser.
DownThemAll lets you download all the links or images contained in a webpage and much more: you can refine your downloads by fully customizable criteria to get only what you really want.
DownThemAll is all you can desire from a download manager: it features an advanced accelerator that increases speed up to 400%, it allows you to pause and resume downloads at any time and, last but not least, it's fully integrated into your favorite browser!

http://www.downthemall.net

Filehippo Update Checker


Not sure what programs you might need to update? Tried of having to look them up the old fashioned way? Try FileHippo Update Checker! It scans your computer for the programs you have installed and it will let you know what updates are available. The updates are displayed on a customized page for you and you can download your updates from FileHippo.




inSSIDer - Wireless Network Analyzer

It's a a free program from Metageek.com! You can use this handy-dandy tool to analyze the wireless network around you.

In this post I'll explain how to download and install inSSIDer.


1. In a Web browser enter the address http://www.metageek.net/products/inssider/download

2. When the File Download dialog box appears click Save.

3. After the program has downloaded click Open to begin the installation process.

4. Accept the default settings to install inSSIDer on your computer.

===
NOTE: inSSIDer is an award-winning free Wi-Fi network scanner for Windows Vista and Windows XP. Because NetStumbler doesn't work well with Vista and 64-bit XP, Metageek built an open-source Wi-Fi network scanner designed for the current generation of Windows operating systems.
Source: Metageek.com – http://www.metageek.com/products/inssider
===

5. Once you start the inSSIDer program, you will notice a drop down menu on the top of the program window. Make sure your wireless card is selected. Click the Start Scanning button to begin.

6. Depending on the number of wireless signals that inSSIDer picks up, your screen will look similar to the picture at the top of this article.

7. There are several sections and columns listed in the program window…

The Start/Stop Scanning Button will turn the program’s scanning feature on and off.

The drop down menu will allow you to select the network device you want to analyze.

The Channel Graph section will display either the 2.4 GHz or 5 GHz spectrum on the Signal Strength graphs below

Vendor lists the name of the device’s manufacturer. This is determined by the MAC Address of the device.

The check box will show/hide the device on your signal strength charts below. This becomes very useful when performing a site survey so that you can isolate specific devices.

MAC Address lists the physical address of the device that is broadcasting a wireless signal.

SSID is the name of the device.

Channel lists the frequency on which the device is operating.

RSSI means signal strength.

===
NOTE: The term RSSI, used in the interface of inSSIDer, is not accurate.

The unit dBm is related to the signal strength, and is generally negative, ranging from -30 to -100 (in the most cases).

RSSI is an arbitrary value, ranging from 0 to 255 (it varies between manufacturers), used by the wireless adapters to determine, for example, when the channel is free or when they have to do the roaming to another AP.

Sometimes, tools converts and shows this RSSI value as percentage, what causes the confusion with the signal strength.
Source: Meta Geek Forums - http://www.metageek.net/forums/showthread.php?t=2968
===

Security displays the type of encryption (if any) that is currently implemented.

Network Type shows what the device is functioning as.

Speed lists the data rate of the device.

The First Seen & Last Seen columns display when the time when the device was in range.

Location displays GPS coordinates of the device.

===
NOTE: As you move closer to the device, if the signal is stronger in 2 consecutive readings, inSSIDer updates the location of the AP.
Source: Meta Geek Forums –
http://www.metageek.net/forums/showthread.php?t=2999
===

Useful Programs!

CCleaner is a nice tool to clean up old temp files and clear out registry errors. When running this program, make sure you know what you're checking to get rid of. Here's a nice walk through guide on how to use the program (Click here!).

http://www.ccleaner.com

http://www.filehippo.com/download_ccleaner/

There are other nice FREE cleaning programs out there. I also recommend checking out (1) Malwarebytes' Anti-Malware or (2) Spybot Search & Destroy and (3) AVG free

(1) http://www.malwarebytes.org/mbam.php

(2) http://www.safer-networking.org/en/download/index.html

(3) http://free.avg.com

Sayz Me - A Free Text to Speech Program

I had this program a while back that would read text from my computer. I thought it was really cool but up until about 10 minutes ago... I forgot what that program was called!

"Sayz Me is a free text-to-speech reader for Windows. Text is typed in or copied from the clipboard and then read aloud. Words are highlighted as they are spoken. Select voice, adjust reading speed, voice pitch, font, font size and color. Hides in the system tray. Very simple and easy to use. Freeware. BSD style license."


Requirements

Sayz Me has been tested on Windows 98, 2000 and XP.

Please ensure that the Microsoft Speech API 4.0 and the Microsoft synthetic voices are installed.

NOTE: the installation order is important!

Be sure to install "spchapi.exe" first, followed by "msttsl.exe". These files should only need to be installed for Windows 98 and XP. They are already included in the default setup for Windows 2000.

More information about the myriad of Speech setups can be found at the Microsoft Speech website.

Source: http://www.datafurnace.net.au/sayzme/html/documentation.html

Fine Arts Festival 2010

This year's Fine Arts Festival @Orme was awesome! We had several artists running classroom workshops for the students. You can checkout the school's event flyer on the event here. I was involved with assisting Kevn Lambson who teaches the Computer Art class at Orme during Fine Arts Festival Week. Kids used several programs including NewTek Lightwave 3D, Pixologic Zbrush, Corel Painter, and Adobe Photoshop.

You can check out Kevn Lambson's website at http://www.idearstudios.com


Here are a few useful links to find the demo versions of the programs listed above:

Lightwave 3D
http://www.newtek.com/lightwave/lwtrial.php

Zbrush
http://www.pixologic.com/zbrush/trial/

Corel Painter
http://www.corel.com/servlet/Satellite/us/en/Content/1152796555406

Adobe Photoshop (and other Adobe products)
http://www.adobe.com/downloads/

Also, Kevn reccomended some open-source (free) programs out there you can take advantage of if you're working in Linux or don't like the price tags on the above programs:

Unreal Development Kit
UDK is Unreal Engine 3 – the complete professional development framework. All the tools you need to create great games, advanced visualizations and detailed 3D simulations. The best tools in the industry are in your hands.
http://www.udk.com/

Blender 3D
Blender is the free open source 3D content creation suite, available for all major operating systems under the GNU General Public License.
http://www.Blender3D.org

The Gimp
GIMP is the GNU Image Manipulation Program. It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
http://www.Gimp.org

InkScape
An Open Source vector graphics editor, with capabilities similar to Illustrator, CorelDraw, or Xara X, using the W3C standard Scalable Vector Graphics (SVG) file format.
http://www.inkscape.org

PDF Files Larger Than Actual Size When Printing - Forum RePost

We were having a problem with printing to our color Xerox machine in the Faculty Room. A 7MB PDF file would expand to over 300MB in the queue and literally take f-o-r-e-v-e-r to print. Not sure what was the problem at first but there were alot of factors to take into consideration. I found an article on http://www.petri.co.il/forums that explained a similar situation someone else had.

Here's the link to the post:
http://www.petri.co.il/forums/showthread.php?t=23752

And here's what Moderator Sorinso had to say...
"There is a big difference between PCL and PS drivers... Especially PCL6, that has some advanced capabilities that might be problem-makers when printing PostScript files. I don't recall the whole theory, and my printers' guru is out of reach at the moment, so cannot give you the whole picture.
Anyway, a PDF file is a PostScript file, that you are printing with a non-PostScript driver.
I would suggest two things:
1) in the printer's Properties, on the Advanced page, uncheck the Enable Advanced Printing Features box (see the attached screenshot).
2) install the PS driver for the same printer on the server and map it to the users.

Test these two and see which of them is better.
Good luck and let us know the outcome.

Added: also, see these articles from Adobe's site:
- http://kb.adobe.com/selfservice/view...ernalId=333091
- http://kb.adobe.com/selfservice/view...ernalId=323299"

It turned out we had that printer installed using the PCL6 driver rather than the PS driver. The option to change the driver was grayed out so I had to add the printer locally via it's IP address. Followed the instructions in the forum post and sure enough it printed great!

With the PCL6 driver, it took about an hour to get that job to go through. Now with the PS driver installed it took only about 5 minutes! And the file only expanded to about 120MB instead of 300MB.

Free Online File Conversion - Zamzar.com



I found an awesome online file conversion website called Zamzar. You can upload files or send youtube links to their site and have them converted to other formats. Enter your email and they’ll send you a link to download your converted file.

This is a great service for teachers who receive papers from students that save their documents in programs like Microsoft Works (.wps) or Office 2007 (.docx) format. Also great for those who like to show youtube videos in the classroom but would rather download the videos for future use instead of reloading a page and waiting for their video to load.

http://www.zamzar.com

OpenOffice - A Free Office Suite

This goes out to all of you who got a new computer back in December. You know that, shiny new laptop that has a copy of Office 2007 installed on it. If you didn't end up getting a license for that, it means your 60-day trial is either coming to an end or it has already expired. Good news for you, you can buy a license over at your local computer store or online at a site like Newegg.com - I highly recommend that you do not purchase a license unless it's from a well established retailer. You could get into trouble if you think you're getting a good deal by purchasing Office online through an auction site.

For those of you that either don't have the money for that yet or need a nice office suite to replace your expired Office suite, look no further!

OpenOffice is a nice office suite that'll get you where you need to go. Got a paper to write that's due but you can't use Office because your trial expired? Go to http://www.openoffice.org and download their FREE office suite that runs using Java. It's cross platform so for all you Linux users out there (I know you're out there) can take advantage of this too. 150MB download so be advised if you're on a slow connection, it might take a while to download.


And hey, are you borrowing a friend's computer and they don't want you installing anything on it? There's always OpenOffice Portable. You can get a copy and install it to a USB drive. Works like a charm! http://portableapps.com/apps/office/openoffice_portable
Note: Like the site says "99MB Download - 248MB installed" I'd advise installing to a least a 512MB USB drive so you can also have some space for your documents/presentations/spreadsheets if need be.