Category: Applications

Random Thoughts-Be Simply Consistent and You’ll be Surprised how Much Money you Save

Random Thoughts – Be Simply Consistent and You’ll be Surprised how Much Money you Save

Technology is complex.  For most businesses it is also necessary.  So most businesses go through quite a process to find and deploy the best technologies for their company.  Then, of course, they spend as much or more time to manage and maintain their technology.  Unfortunately, there really isn’t any better way.  With the incredible array of technologies available to business these days, and the importance they hold within our companies, it’s no wonder that everyone spends so much time and money on their technology.  Yet, it’s also easy to get carried away.  That’s why I highly recommend keeping two principles in mind as you evaluate and deploy technology for your company: simplicity and consistency.  Simply put, the more simple and consistent you can keep your technology, the less time and money you’ll spend maintaining it.  After spending over a decade in the IT field, there are few things that have proven more true over time.  Oh sure, sometimes multiple applications or a diverse technology environment is required.  But even within those environments there are opportunities to keep patch levels consistent, or run applications on similar hardware.  So as you begin tapping into your fresh, 2011 IT budget, consider a greater emphasis on keeping your technology simple and consistent -  your bottom line will feel a little bolder at the end of the year.

Integrated Communications – What is it and Why Should I Care?

Integrated communications is, on a very simple level, little more than making sure you can communicate well throughout your organization and to your customers.  It’s an important concept to understand because it can often lower your fixed costs and improve your ability to serve your customers. In essence, the simplest definition may be “the ability for businesses to communicate quickly and effectively internally and to customers.” Integrated Communications can include both hardware and software technology such as phone systems, e-mail systems, messaging software, mobile phones, remote access technologies, Internet service, websites, social media, and more.  Deployed well, the advantages of Integrated Communications can be very powerful.  Here are a few common advantages:

  • Creates a platform for developing new processes and efficiencies that drive competitive advantage
  • Allows businesses to do business anytime, anywhere
  • Enhances collaboration activities and improve organizational productivity
  • Creates an environment with multiple communication redundancies
  • Enables new service delivery methods by integrating voice, video and data communications
  • Enhances mobile workforce communication
  • Optimizes your communications and networking environments for cost-effective performance.

For example, at ITP we provide many different ways for our customers to contact us including phone, e-mail, and web access methods.  We manage all our client’s issues through a ticketing system that streamlines internal communication between engineers, operations, and our back-office support staff.  Doing so has increased our customer’s service experience enormously by allowing them to access ITP’s staff and services in the way that works best for them AND it has ensured our internal communications are efficient and seamless.

A few other examples of where these advantages could be realized would be:

  1. Deployment of a SharePoint server to allow secure document access and collaboration across multiple sites or between a geographically distant workforce
  2. Deployment of a VOIP phone system like a Shoretel phone system to save telecommunication costs between sites
  3. Deployment of MPLS Internet access to deliver secure communications between office locations and reduce hardware expenses.
  4. Implementation of a social media strategy

Ultimately, any technology initiative should be driven by business need or strategy.  However, with the response times customers have come to expect from all businesses today, along with the need for businesses to communicate quickly and efficiently to satisfy those expectations, deploying an integrated communications strategy is almost certainly a quality investment.

Info-Pro / Omniform Filler “out of memory” error

Just wanted to share a quick fix for an “out of memory” error a client was receiving when attempting to open older Info-Pro forms (these are the older style executable files that use Omniform filler).  The client recently upgraded all but one system to Windows 7 (an older system remained XP).  In addition we installed a new SBS 2008 server.  All workstations are 32-bit Windows.

Certain older forms would open, others would not.  However, one workstation was able to open any form – and surprisingly it wasn’t the old XP system.  That system failed with the same memory error.

After some trial and error it turned out that some of the forms would generate the “out of memory” error message when certain printers were set to the Windows default.  After setting the default printer on any system to match the one that the “working” Windows 7 system was using, that system functioned properly.  The only other default print driver that could be used was Adobe PDF (the Adobe writer driver).  All other printers set to default would throw the memory error.

So a workaround is to simply change the default printer before opening the specific forms that cause issues.

Info-Pro has since moved to Adobe fillable PDF but many law firms still retain their older Info-Pro Omniform forms that have been completed for clients.  Until the old forms are completely phased out this is a pretty quick and easy workaround.

Google in privacy trouble again for stealing wireless data from google street view

Google street view is a handy tool to use when you need to know what that building your looking for should look like from your car.  These Google cars traverse the U.S. and 30 countries taking pictures and sending back GPS data about locations around the world.  Recently Google has admitted to the F.C.C. that they were in fact in violation of Federal privacy and wiretapping statues when these cars were equipped with WiFi detectors.

Google originally set out only to mark the locations of wifi devices.  Recently though, for a yet explained reason, Google cars actually capture Wifi data on unencrypted Wifi connections.  Google in the process capture emails, web data and other traffic from thousands of unsuspecting citizens.

Once notified Google did delete the data and reported themselves to the authorities and no further legal action has been taken but privacy watchdogs are not happy with the lack of follow up but the federal government.

For businesses this is a stark reminder of how easy it is to let data outside the network.  Wifi is a handy tool but carries with it some risks when not properly configured and monitored.  We recommend all our clients with Wifi secure them with at least WPA+ security or higher and all passwords on public facing routers meet complex password policies.  Your firewall and routers simply cannot have the same basic passwords they must be complex and include no words in the dictionary.

Most businesses today think with anti virus and a firewall that is sufficient given they don’t have any “private” data or regulatory restrictions.  Keep in mind that PCI compliance requires network security and applies to almost every company that takes credit cards.

Do you have reports confirming your networks safety?

Excel 2007 Quick Access Toolbar macro buttons

I ran into a strange issue today when attempting to add Excel 2007 macro shortcuts to a Quick Access toolbar saved in a shared template.  I could add the buttons and save them to the template, but as soon as I closed and re-opened Excel the buttons disappeared.  Standard built-in Excel functions worked just fine when saved to the shared template.

Even if I added a few built-in buttons, and just a single macro link, the buttons would all disappear the next time Excel was closed and re-opened.

Turns out there’s a glitch in the way Excel stores the macro name in one of the stored XML files in the template.  To correct this I needed to extract the template file (just rename the Excel macro-enabled template to a zip file then extract as you would any other compressed file), then remove the path information from the CustomUI.xml file.  Specific steps can be found in the thread here:

http://www.pcreview.co.uk/forums/thread-3834831.php

Hopefully this will be corrected by Microsoft.  Of course with the new Ribbon bars that may be easily edited in Office 2010 this may be less of an issue.

Web Browsers – What’s Your Choice

I’ve been noticing some amongst my clients about the web browser they’re using.  Long established as the predominant browser in the market, Microsoft’s Internet Explorer (IE) is experiencing more competition than ever these days.  As a long time fan of Internet Explorer I recently switched due to some frustrations with performance – specifically with the newest iteration, IE 8.  Mostly my problems revolved around the way IE 8 presented text (often so small that it was unreadable) and errors experienced with certain java functions certain sites required.  This isn’t to say that other browsers don’t have problems – quite the opposite, actually – but I found I didn’t mind the problems other browsers had as much.  Anyhow, the three most popular browsers today (in my opinion) are IE, Google’s Chrome, and, Mozilla’s Firefox.  I’ve decided Google Chrome works best for me.  So what do you think?  What browser to you use and why?

The Best IT Firms…

At ITP we focus on delivering our services in a manner that rises above our competition.   Which got me thinking…the best IT firms do certain things well.  Among the most common are:

  1. They have skilled, experienced engineers
  2. They explain things clearly to you
  3. They are efficient and reliable
  4. They help you drive efficiency through your technology
  5. They are an asset to your business

I’ve seen many IT firms to some of these things well, but few do all of them well.  What are the most important things your IT firm does for you?

Virtualization. Simplified.

There’s no doubt that virtualization is becoming more and more prevalent for small businesses of all sizes.  There are lots of reasons for this including:

  • Reduced downtime
  • Increased performance
  • Strong disaster recovery
  • Scalability
  • Excellent business flexibility

But I find it curious that many companies I meet with are initially confused by the concept.  So…here’s my attempt to simplify virtualization.

At its most basic level, virtualization for small businesses generally involves running multiple server operating systems on one physical server.  That’s it.  Oh sure, more than one physical server can be deployed to create better redundancy, less downtime, etc.  But just knowing that simple concept – multiple server systems running on a single piece of hardware (server) – puts you way ahead of many small businesses.

Useful Excel Shortcuts

At the speed in which business moves today, useful productivity enhancers can make the difference between getting work out the door on time and fighting with endless tight deadlines.  Certainly, we’ve all heard about software tools and programs that promise to make us twice as productive as we already are.  Oddly enough I’ve never really had one of those programs do anything but waste my time.  However, one timesaving tool I’ve never had fail me is learning how to use quick and simple keyboard shortcuts.  So, because I’m a big fan of Excel (and wanted to learn a few new keyboard shortcuts) I thought I’d share a few with you.

Action Shortcut
Insert a new line within a cell [Alt] [Enter]
Enable editing within a cell [F2]
Add a comment to a cell [Shift] [F2]
Open Print Preview [Ctrl] [F2]
Fill selected cells with an entry you typed in one cell [Ctrl] [Enter]
Fill data down or to the right through selected cells [Ctrl] D or [Ctrl ] R
Create a name [Ctrl [F3]
Insert the current date or time Ctrl] and ; (semicolon) or Ctrl and : (colon)
Create a chart from a range of data [F11]
Toggle the display of formulas [Ctrl] ~

Another method I’ve used in the past to help me learn the “ins” and “outs” of a program is to use a quick reference guide.  For Microsoft Office programs, I’ve found the ones at Brainstorm.com to be quite good, however, you can find them at many different resellers.

E-mail Scams to Watch Out For

I ran across this article written for Tech Republic (a great source of all things technology) by  Debra Littlejohn Shinder and thought it would be helpful to many businesses. Being in IT, I’m all too familiar with the scams businesses see in their e-mail boxes every day, but I know some (many) people still get confused. So, here’s a little quick information on what to look out for when you’re reviewing your e-mail in the morning…
1. Fake Facebook “friend” messages – these are e-mail messages that look the same as when someone posts to your Facebook wall or sends you a private message.
2. Fake Messages from “The Administrator” – these are messages that come from “The Administrator” of any number of given organizations (facebook, your bank, credit card, etc.).  Here, there are two things that give away these “false” e-mails.

  • First beware of the “To” address – it will be incorrect and you most likely won’t recognize any of the domain name(s).
  • Secondly, if it’s not from your local IT administrator, you should immediately be wary.  Because honestly, when is the last time you had an “administrator” send you anything valid that wasn’t as simple as “server reboot tomorrow” or “turn your system off tonight”?

3. Messages that play on our fears – these are emails that feed off of current events or high profile media events a good example would be the (H1N1 virus ) Swine flu, etc.  Don’t panic, just don’t click on it.
4. Cancellation of an account Emails - these may show up even if you don’t have an account with them!  These messages are usually chocked full of spelling/grammar errors and are often sent from another country.
5. Fake “Holiday Cards”- these cards are usually very generic, rather than saying that they are from a specific person’s name they say it is from “a friend”. Be careful, because when you open them, you could be putting your computer at risk without every being aware of it! To be on the safe side, only open Holiday Cards from friends, or better yet just don’t open them at all.
6. Notice of the “Mysterious” package message – these are e-mails saying that you have an UPS, FedEx or perhaps DHL package that was undeliverable due to incorrect/incomplete address information with an attached form that they need you to complete in order to get the package to you. Just as you may suspect, there really isn’t a package at all! They want you to open the attachment so they can infect your computer with a virus. Because some people may be aware of this kind of scam, they will try and infect your computer by sending you an email with a link to a Web page to open instead.
7. Government “Threat” Emails – these can be sent to you to notify you that either the FBI or Homeland Security has been notified of your alleged involvement in terrorist activities or money laundering. Just as you may suspect from a hoax like this… they have an offer for you to avoid prosecution, which could be a payment of a few hundreds made to the Economic Financial Crimes Commission Chairman. If it would be an official threat, they would contact you in person, without asking for a payoff to buy your way out.
8. Fake “Census Survey” email – here again they will use the Federal Government to get you to respond to their emails. The Federal government does require you by law to fill out a census survey every 10 years, and yes, they may send you an online request for your participation in a census surveys, but they don’t ask for your personal information unlike email scams.
9. Abuse of “Trust” in software and hardware manufacturers – these e-mails are basically fake security warnings with a “quick fix” attachment, dubbed to look like it was sent from Microsoft or another familiar company. These “quick fixes” are really malware to fake special offers to payment requests which require you to download and install a transaction inspector module if you want to decline to have payment charged to you credit card.
10. The “Fake” You-are-a-Winner E-mail – You just won a prize, how awesome is that?  Well, the only problem is you didn’t enter into any contest to win the prize. These e-mails want you to fill out a form to claim your prize, complete with your social security number so “the value of your prize can be reported to the IRS.” Remember to check out the legitimacy of any email notification. If you need to send any sensitive information, remember to email it encrypted if you don’t have an alternative method in which to submit it.

Keep in mind, if you’re unsure just don’t open it.  It’s just that simple.  Instead, call your helpdesk, administrator, or IT manager and let them figure out whether it’s valid or not.  Trust me, they’d rather you call them than open it.

WordPress Themes