Skip to content

Posts by Martin Emerson Low, Senior Systems Engineer

The Web and I Masters Time Matters

The Web and I is working on a special installation of Time Matters for an esteemed attorney client. Time Matters is a Customer Relationship Management product from Lexis Nexis designed especially for attorneys.

The Software

One of the differences is that there is an entity called the Matter or Case which tracks court cases and legal matters. There are built-in roles for most of the parties a law office will deal with, and there is strong billing capability built right in. Some of the third-party document generating programs attorneys like to use like Hot Docs and others are supported by Time Matters.  There is robust synchronization between Time Matters and Outlook as well. Once installed, maintenance can be done remotely. In fact this client we are installing Time Matters for now is over a thousand miles away! What we can do is install and load the software with all data, customizations, and options, and then all you need to do is plug it in. No technical support needed, other than us, and we can log in remotely and fix problems. Repairs, as you will see under hardware, can be done by anyone in the office.

We are not affiliated with Lexis Nexis except that we install and service their products, so I did not go to their advertising place to say something nice about Time Matters. I really love the synchronization capabilities, the interactivity with document tools my clients already like and use, the wonderful service at Lexis Nexis if there is a problem and one more important feature. Regular Customer Relationship Management software does not include anything to perform or track legal research. So many attorneys are already using Lexis Nexis as their legal research source. Right in the software you can simply hit the Lexis Nexis buttons and do your legal research and have it attached to the case record.  For an attorney, this is a great gift and time saver.

The Hardware

The Dell PowerEdge T620 has a 9 Terabyte SAS Hard Drive Array with a special hardware controller. This means that the RAID services are done through firmware and the drives are set at the BIOS level: that level of machine that is below the operating system and resides on the motherboard itself in chips. That special combination of drives and a RAID Array Controller help provide fault-tolerant, redundant, and speedy disk service. The drives are also hot-swappable. If my client has an outage, an employee needs to simply pull out the bad drive and plug-in a fresh one, all without shutting down the server. The same is true for the power supplies. The twin 750 watt power supplies can also prevent failure. For power failures, there is power backup that will automatically shut everything down safely. For those that want to keep  a small office going and don’t mind a 2000 lb battery system, I can keep your office of ten running for an afternoon. Power failures being rare enough not to cause the loss of significant work in most offices, so a smaller system is fine. Larger companies are best served by a large battery backup and a diesel generator. We can source, deliver, and install these as part of your total disaster management plan. In addition, we recommend off-site backup. This ensures that in a disaster your server and everyone’s work can be up and running in one business day in case of the complete destruction of your facility. We never let our clients lose their data. Memory and CPU power is also important, sporting 24 cores of Xeon processing power, the model we are using has 16 GB of fault-tolerant RAM.

The database

The database is Microsoft SQL Server 2012. This is a wonderfully reliable and robust database, and it stores not only your data but all of the case documents you store in Time Matters. The 2012 Edition is the latest from Microsoft and considered the industry standard by most credible systems engineers.

To find out more, call one of our experts at (646) 853-0573.

New Office 365 2013 Preview: PowerPoint

Like other Microsoft Office 2013 products, PowerPoint 2013 uses the same basic ribbon command structure, but it has been optimized for tablet use. The simplification of the interface also makes it more phone ready.

PowerPoint’s built-in themes now have a variation feature which makes them more customizable than the original.

More Choices from the Start

The starting sequence of PowerPoint is different. Rather than opening to a default blank PowerPoint presentation, a starting screen offers you the option of using templates to start off with, open a recent file, and of course, the option of starting with a blank presentation.

More Ways to Start

More Ways to Start

The slide show view known as Presenter View now automatically adjusts to the projection setup in place by scanning the hardware in use and adapting the presentation to it.

Presenter View

Presenter View

  • Presenter View can now be used on a single monitor.
  • Clicking the magnifying glass allows the user to zoom in on a single slide.
  • Moving or jumping to any slide is possible within this interface.
  • Easy set-up: PowerPoint automatically detects hardware configuration and optimizes the presentation for the available audio-visual equipment.

For more help with Microsoft Office or any other computing issue call the experts at the Web and I at 646-853-0573

New Office 365 2013 Preview: Microsoft Excel

Microsoft is known for two things: being the provider of software which is the industry standard for business, and for being extremely innovative. Microsoft may not be the first company to come up with some innovative features, but Microsoft would rather be the first company to come out with those features executed correctly rather than the first chronologically. Microsoft Office 2013 is no exception. The first major goal of Microsoft Office 2013 was to clean up graphic effects to make the interface cleaner, smoother, and easier to operate. The second goal with the 2013 Edition was to make Microsoft Office tablet friendly.

The immediate impression that Excel 2013 users have is that the interface is a lot cleaner and more intuitive. It still does use the Microsoft Office Ribbon that users have trained and gotten used to from Microsoft Office 2010. This familiarity serves to lower the amount of necessary training time. The simplification of the ribbon improves functionality both on the desktop and for tablet uses.

Office Templates are something usually associated with Microsoft Word, but in Excel 2013, there is a rich collection of templates that provide both visual interest and functionality. With templates, you can concentrate on the data and leave the design to Microsoft. For the users that want more control, there are more design tools, and those tools are far easier to use.

Another new feature is the Quick Analysis feature. Just put the data into a spreadsheet and highlight it. Very quickly you can make charts and graphs to help you visualize  patterns in the data. Because of tight integration with the rest of Microsoft Office, you can easily take the data, charts, and graphs and quickly copy and paste them right into your Word, Publisher, or PowerPoint document.

Sometimes data requires columns to be filled in either identically or incrementally based on rules. The new Flash Fill feature allows missing cell data to be filled in quickly just by dragging the cursor across the column. In most cases, Flash Fill can figure out the pattern of the data you are trying to fill, making completion a breeze.

Different types of data are better represented visually with different types of charts, and if you do not like the recommended chart type, it is easy to flip back and forth between different chart styles, colors, sizes, and tables.

Sometimes, you may not wish to use the full set of data you entered to analyze, or you may wish to take out parts or limit the range using different parameters. This is very easy to facilitate using the new Slicers feature, which also allows for complex pivot functions.

In earlier versions of Microsoft Office Excel, you could open up more than one workbook at a time, but they would all be in the same window, in the same instance of Excel. Now with Excel 2013, you can have one window per workbook. This can prove very valuable when you are working with two different workbooks and want to see them both side-by-side. with this new feature, that scenario is now possible.

Saving and sharing files online is much easier with Excel 2013. It is optimized for the cloud and easier to save documents to SkyDrive or SharePoint on Microsoft Office 365.

Sometimes, webmasters want to display data, charts, and graphs, but in the past that had to be re-coded for the Web to share on public sites. Now with Excel 2013, sharing data on the Web is as easy as copying and pasting.

New programs and new features in Microsoft Office including in Excel 2013 sometimes require training. For an informal and enlightening conversation about Microsoft Excel 2013 or any other computing issue, contact the professionals at the Web and i at 646-853-0573.

The Microsoft Dynamics CRM Online Polaris Update

One of the best things about using Microsoft Online products, besides their unprecedented reliability and functionality, is the fact that they are always innovating. Microsoft has big plans for Microsoft Dynamics CRM this year, and they are going to wow us with a great many new features and functionality. This is not only to enable greater productivity through the features directly, but the idea is to expand the interest for users as well as the number of devices they can use to work with CRM. Consider this the first in a series of many updates of Microsoft Dynamics CRM Online and new capabilities.

Starting at the end of January and continuing today, Microsoft Dynamics CRM Online is implementing a new update that will affect all users. Microsoft reporters had stated that users would be given a choice of when and how these updates are applied, but these updates are actually applied behind the scenes, with users experiencing features one way on one day, and then the next day they return to improved features. Microsoft is very smart about how they apply the updates,  because changes and their functionality tend to be intuitive to the end users, requiring no formal explanation.

Part of the rollout that is the most exciting is the addition of support for new browsers. Now users can use Microsoft Dynamics CRM with Chrome, Safari, and Firefox including on the Mac. Before, Microsoft Dynamics CRM was not usable on the Mac, and this update is very major because of the sheer number of choices that are now available for using this application.

As a result of this update, users will be able to run Microsoft Dynamics CRM Online on their I-Pads. This is a major plus because of the strong adoption of the I-Pad.

Another significant feature that was added was support for Skype and Lync. With these applications, enterprises can have click-to-call capability, which I wrote about in my article yesterday.

Other updates for CRM were designed to provided added capability to deal with the new features in Microsoft Office 2013.

Many know that Microsoft purchased the enterprise social network Yammer, and many wonder how that would integrate with other applications on desktops or servers. Microsoft has with this update integrated Microsoft Dynamics CRM with Yammer. This will help larger organizations have internal social networking and collaboration in a manner in which users tend to like to work.

Microsoft is not stopping there either. Microsoft is working on new updates that will be available for mid 2013 that include:

  • A native Microsoft Dynamics CRM Online Windows 8 application.
  • A native Microsoft Dynamics CRM Online Windows Phone 8 application.

Eventually we will see newer and more exciting features, and some of these are already known to this author. I will write more this week about the exciting things that users can expect in Microsoft Dynamics CRM  Online.

In the meanwhile, if you want to talk about any of these great new features or about anything else Microsoft related, give us a call for an informal conversation at 646-853-0573.

New Office 365 2013 Preview: Microsoft Word

New Microsoft Office Word 2013 allows you to do more than you could with previous versions of Microsoft Office including Microsoft Office 2010. some of the new things you can do is add an online video to your Word document, use Word to open and edit *.PDF documents, and use it easier on tablet computers. For those working on team documents, editing and annotating with comments is easier in Word 2013 than in previous versions.

There are different features to make reading as pleasant as creating documents as well. There is a reading mode, a feature to zoom in easily on images, text, and graphs, plus the capability to click and define words and search the Web right from within Word. If you are reading a document and close it and re-open it later, Word will ask you if you want to pick up where you left off, or start in a new place.

Word 2013 Web Application, available for Enterprise Microsoft Office 365 versions will have additional features as well, making it more like the desktop version. Another great version for Office 365 users is that if you are using a computer that is not yours and does not have office you can do a quick temporary install of one or all of your apps, which will then disappear from the host computer when you are done.

When making any technology decision, you need to talk to people who know what you want to do. Call us any time at 646-853-0573.

 

For Users of Lync and Microsoft Dynamics Online, a Click to Dial Feature

Lync has a new feature when used with Office 365 Plan E4 and Microsoft Dynamics CRM Online and Jahjah Voice plan for Lync which could prove extremely useful to businesses. The fact is, it takes time to go look up a CRM record, pick up a phone, and then type in the numbers to dial. If you think that this takes you a long time, imagine how long it takes bored employees. Employees like things to be simple and direct. Simple and direct processes also speed up pace of work getting done. Speeding up the completion of work means more profits, less staffing costs, and greater efficiency.

With the advent of Skype joining Office 365 as well, this will work with Skype too. Please note that Lync will have to be configured to make and receive calls for your company. We have professionals who can help you do this.

The important part of preparing your telephone numbers for click to dial is that they are in the right format. If they are not in the right format and you do not wish to manually update all of them, there are tools available from Broadlook that we sell at the Web and I which help clean and  normalize your data, and these tools can automatically format your telephone numbers correctly.

The proper format is + then country code (1 for United States) then the rest of the telephone number. For instance, the formatting of the number to reach us at the Web and I is +16468530573 .

When you then save the contact form and click on it, the following message opens up the first time:

Do you want to open this link with Lync?

Do you want to open this link with Lync?

Once this dialog box opens up, un-check the check box next to the message “Always ask before opening this type of address”.

The great thing about this is that for call centers, law offices, medical offices, and financial services, wasted time spent dialing as well as miss-dials will become a thing of the past. If you are a company dealing with sensitive information and do not want your staff to actually see the numbers that they are calling this is a great solution as well, because we at the Web and I have a way to make the telephone numbers appear as all stars to users of a clerical security level.

These are powerful but complex solutions, useful for the company that does not want to pay a lot for staffing, but wants to keep their telephone operators in the United States. In order to get these features, contact a competent certified Microsoft Partner like the Web and I to help you. Please call us for a casual discussion of your needs or any technology problem at 646-853-0573. You’ll be glad you did!

 

Avoiding Identity Theft Online

Everyone these days is buying something online. Sometimes it is for personal use, but sometimes that can also be for business. Identity theft does not just happen to the ignorant, it can also happen to intelligent people who happen to leave the wrong information available for predators to find.

The first step to securing your identity online is to use a strong password. Wherever possible, letters, numbers, and a special character can be used. Avoid names, birthdays, places you know, or your childrens’ or spouse’s names or birthdays as well. This is important for  every E-Mail address and online banking login you have. Never stick your passwords to your laptop with stickers. People make the excuse that they forget, but this is a case where forgetting is as inexcusable as forgetting to hold the steering wheel while you drive.

Frequently check your credit report for lines of credit or debts that you do not recognize. If you see them, a lawyer or good credit counselor can help.

Do not share your social security number with anyone other than your spouse. That number is critical. there are  a number of services that provide protection for your social security number, but personal vigilance is all you really need.

It is vital to watch out for your mail. People could be ordering credit cards in your name and sent to your address and then they can pick the envelope right out of the mail. The same axiom is equally valid for checks that you are sent. All a criminal needs to do is head to the ghetto to the nearest “no ID” check cashing place and bingo, what was supposed to be your payday is now a payday for them. These types of scammers particularly look for tax refund checks and also the Social Security checks of the elderly of disabled.

Are you getting notices in the mail from credit card companies that say, “You’re pre-approved for a new ____Card”? If so you are on a list that is sharing your identity. Call 888-567-8688 to be removed from this list permanently. You will have to provide your social security number for this action.

People need to use a secure PIN number for their bank and credit cards. Please remember our advice about birthdays. This  pin number should be completely arbitrary. Make the extra effort and memorize it. If you write your bank PIN number on a piece of paper and put it in your wallet with your bank card, your life savings could be wiped out in days.

Be very careful when you shop online. Make sure the top of the browser bar has https:// instead of http://. The S is for security, and it indicates that the information is being sent in an encrypted manner. Do not use your bank  card with your life savings in your account to buy things online. There is very limited protection for using a bank card, and you are liable for fraudulent purchases. Instead, get a great credit card with consumer protection in case of theft. Most cards limit your liability to $50 in case your card number is stolen, provided you report the theft quickly. If you do not want to pay interest, pay back your card immediately. Using a credit card responsibly helps improve your credit as well.

For businesses, be careful about trusting employees with access to the online banking for the business. There are ways to reconcile the books through software automation between your online bank accounts and your accounting software. These methods are known to the Web and I, and we are prepared to help you. To discuss your privacy concerns informally, call us at any time at 646-853-0573.

What to Expect from the Office 365 2013 Edition Overhaul

Office 365 2010 Edition and Office 365 2013 edition are quite different not only in their outward appearance but also in their functionality. Little-known difficulties with Office 2010 are now making Office 2010 an attractive target for hackers, according to Kaspersky Labs. In the past, the most common files to exploit were Adobe Flash and Adobe Acrobat. Adobe has come up with a more aggressive update policy and they have changed their code to help prevent these exploits. Office 2013 has been completely re-written from the ground up to be safer and to avoid these troubles for businesses who rely on Microsoft Office. Other alternatives exist, such as Google Docs and others, but they do not provide the same look, the same features, or the same document compatibility. In fact with Google Docs, it is almost impossible to save a document sent to you on a hard drive, or have someone else open it without sharing your Google login credentials. In fact this author printed out one Google document as a favor, and now my Google account was hacked and an Indonesian bartender has taken over a facebook profile he made with my Google account. I have reclaimed my Google account, although facebook refuses to remove the page. All of this is reason enough to not go with cheap imitation software. Only Microsoft Office, with the latest versions and updates, is the industry standard. That will provide you with the most functionality and the greatest protection.

One of the new things that are available are public folders. SharePoint has its place for sharing and storing archived material, but it is too complex for some users to actually adopt and collaborate with, and the most important change that can happen in the workplace because of enterprise software is collaboration. So with Office 365 we can expect a lot more collaboration in businesses everywhere adopting the new Office 365.

Another good thing is that Lync and Skype will have improvements in video chat and collaboration. In Lync multiple faces can be seen when meeting with multiple persons in a “Brady Bunch” configuration. Skype users will have an easier time-sharing files because Skype will be federated to the user’s Skydrive account.

For tablet users, Office 365 has great news! Office 2013 is optimized for the Windows 8 tablet. All commands are touch-enabled, and pages can be flipped in a document just like flipping pages in a book.

For users who have mixed Mac and PC environment, users can install Mac or PC version of office on up to five computers even if they are not of the same kind, such as one on Mac and three on PC’s and one on a PC Notebook. Users who may be stuck on someone else’s computer occasionally, can use Office On Demand. With this feature, you can quickly sign in and use the office application that you wish to use, and when you leave that computer you leave no trace of the application or the work that has been done there. This feature is great for people on the go. A Windows 8 on a USB Key is also available, though it must require careful preparation. With it, users can use their own environment on someone else’s computer with no trouble at all.

Desktop Office 2013 has become a whole lot cooler too. You can now embed web parts such as bing maps directly into excel spreadsheets and word documents, and the interface has just gotten a whole lot less cluttered.

For help in deciding on, implementing, and training your employees with new technology you need to go to the Microsoft Experts. We have been with Microsoft since DOS was released the operating system that existed before Windows. Call us for an informal chat at any time at 646-853-0573.

 

The Importance of Effective Employee Training in Enterprise Systems

Employees are considered good by managers when they are comfortable enough with a business process to develop a “System”. This system is a way of doing things, a way of handling common business situations in an efficient way. Employees get very attached to their way of doing things, and when technologies change, they invariably come up with resistance to that change.

This resistance to change is often misunderstood. Suddenly managers and employees are pitted against each other over this sudden and  unexpected resistance by good employees. But what is at the root  of the resistance? The resistance is actually caused by employee’s worry about the health of the business and the business price. These good employees are resisting what they see as a threat to the organization: a threat to getting the job done well.

Because this resistance can now be seen in an entirely new light, as a positive emotion about protecting the business and its’ processes, there clearly needs to be a better way to handle this particular resistance than with anger.

Experts in change management and software implementation always say, “welcome the resistance”. This seems to be counterintuitive, until you listen to their reasoning and use  for  the resistance. The resistors need to be converted and have their energies put into the new technology project in a process of gaining consensus. This consensus among employees is actually the biggest part of training. If you have ever tried to train employees in a technology that they dislike, you will be met with resistance and claims that the technology is too difficult. If this is the case during training, then more consensus building is needed before training. Once the consensus among employees in general is positive toward a technology and a procedure, the training will take place by itself almost as if by magic.

Staff have a long way to go with technology when implementing a new enterprise system, but it is important to keep that staff happy. The main reason for this is that your implementation staff is your front-line army for turning  technology resisters into technology champions.

This staff will have to face your staff when they feel that they are not only losing beloved procedures, but that they are also losing power. The loss of power for employees with an enterprise system is the farthest thing from the truth: a new enterprise system used by all will give them complete transparency, control, and access to the data they need when they need it.  They will be able to churn out reports faster than ever  before, and be able to take advantage of the collaborative efforts of others, who are all using the same system. For some of the oldest employees, it is useful to bring up the times when people used to do all of their computing on a mainframe. That was a form of team computing, and this new enterprise computing is simply team computing without the removal of the individual.

Planning and executing a major enterprise technology initiative is difficult in any organization. Before you get started, be sure to call the professionals at the Web and I to talk about your needs on an informal basis at 646-853-0573.

New Office 365 2013 Preview: New Features

New features in Office 2013 are mostly tablet oriented as well as arranged around the new simplified ribbon menu style. One of the key features is the simpler look allows the user to flip through pages of a Microsoft Office Document on a touch-screen in a realistic manner, much as one would flip through the pages of a book.

Other features related to this Office 2013 Metro interface are a recurring theme on the Metro Windows 8 Phone and Windows 8 user interface, which are also metro.

While it seems exciting to technical types, I have experienced lack of enthusiasm and resistance to change in offices when dealing with the Metro theme, Windows 8, and Office 2013. Much of this resistance can and will be worn down over time, and new consensus will be hard-fought and won in the world of interfaces.

Some of the advantages to Metro style  features include the new start screen. Rather than loath it, consider that you have a whole screen and even more to pin all your favorite applications and documents. You can alter tile size and information content. For the developer, the tile is a valuable tool, able to convey information in the form of instant updates to applications, increasing their notoriety.

Closing Windows 8 style full-screen apps. There is no manual that comes with Windows 8 to tell you how to do this, so an old tech geek trick of closing the application by clicking <alt><f4>. You can switch between apps very quickly without closing them using <alt> <tab>. This option is very useful because it opens up a window showing all foreground applications so that you can select the one you want immediately.

On the right, the mouse will open the Windows 8 Charm Bar. This bar has a search feature at the top which is very powerful. Not only can you search your own local machine but any shared network resources as well.

Rebuilding Windows is much easier, faster, and cheaper than it was with Windows 7 or previous versions of Windows.  With Windows 8 you can re-install Windows with Windows running and without losing any documents, apps, or settings. This results in much less time spent re-building PC’s and much less user resistance because documents, settings, and apps remain the same after repair.

The Windows Mail and Social features built-in to Windows 8 are great for home users, but applications such as Mail should be turned off for business users, as business users are generally using Microsoft Outlook.

With so many decisions to make about training people for Windows 8, leaving them with Windows 7, it is good to have a company who knows the details that can help you make tough decisions. Our engineers at the Web and I are ready to speak to you today at  646-853-0573.

 

Follow

Get every new post delivered to your Inbox.

Join 904 other followers