mrc's Cup of Joe Blog

Join us in exploring the world of modern development, evolving technologies, and the art of future-proof software

How to build a secure customer portal in one day

By /

Save TimeBuilding a customer/vendor portal (also called an extranet) is a tricky task. Typically, one portal must display different data to different users. If one user logs in and sees data that they shouldn’t see, you’ll have a big problem on your hands.

For example, suppose that your product pricing varies by customer. If one customer logs in and sees pricing meant for another customer, you’ll have problems. Or, suppose that your customers have different levels of users which require different permissions. For example, the CEO must see different data than the salespeople, and the salespeople from one region must see different data than those from another region, and so on…

All in all, it’s an extremely complicated application. Fortunately, extranets are actually easy to create with the right process. If you’re planning on building an extranet/portal, this video explains how to build a secure extranet in one day.

Turning COBOL programmers into web developers

By /

Save MoneyBack in 1997, Gartner estimated that 80% of the world’s businesses ran on COBOL. These days, the numbers are a little more uncertain. Some say that number is down to 70%. I’ve also seen surveys that put it right around 62%. Regardless of the figures, one thing is clear: COBOL is still widely used in many businesses.

However, many of these businesses find themselves in a tough situation. They have their COBOL programmers on staff to maintain their current apps. But, they don’t have the skills necessary to build modern web apps, and can’t afford to bring in new employees. …

Turning COBOL programmers into web developersRead More »

How application architecture can save time and money

By / ,

Save TimeA few months into owning our first house, we learned something: The builder took some short-cuts. Unfortunately, you don’t recognize architectural defects when you buy the house. They become apparent after you’ve lived in it for some time.

Business applications are the same way.

If you’re building/buying new business apps, or buying software to build new business apps, be careful. It’s easy to fall in love with the interface and features without paying any attention to what really matters: The architecture. …

How application architecture can save time and moneyRead More »

3 questions to ask before buying a development tool

By / ,

ProductivityOpinions of development tools vary widely in the IT industry. Some people swear by them. They couldn’t imagine working without a development tool. Others refuse to use them. Typically, these people have had a bad experience with a development tool, and assume that all development tools are alike. (Hint: They’re not.)

A good development tool can drastically increase productivity and let anyone in your office develop web applications. A bad development tool can be a waste of time and money. How do you know which is good and which is bad? Ask the right questions. Here are 3 of the most important questions to ask before buying a development tool: …

3 questions to ask before buying a development toolRead More »

Meeting immovable deadlines

By /

Save TimeDepending on which research firm you believe, anywhere from 50-90% of IT projects are completed late. While I could rattle off any number of reasons for this, I think that (much of the time) it boils down to one problem: Being late is an option. The deadline is viewed merely as a suggestion…it’s not the end of the world if it’s missed. We’ll just inform management that the project is running behind schedule and then set a new deadline.

But, what if being late wasn’t an option? …

Meeting immovable deadlinesRead More »

Pivot tables in Google Docs: How do they compare?

By /

EducationA couple of weeks ago, Google announced some big news: Google Docs now has pivot tables! I know what you’re thinking: How is this different than other pivot table options, such as those found in Excel? Are they right for business? I’d like to help you answer these questions.

First, how does this differ from other pivot table options? Before we answer that question, we must first answer this question: What are the other options? Before Google pivot tables came around, there were 2 main approaches to pivot tables: Excel pivot tables and database-driven web pivot tables (like those created with m-Power). With Google’s foray into pivot tables, we now have 3 legitimate pivot table options. So, which one is best for your business? The best way to answer that question is to take a look at how each option compares in 5 key areas: …

Pivot tables in Google Docs: How do they compare?Read More »

6 essential elements of a good reporting solution

By /

EducationHave you ever purchased business software, only to realize later that it didn’t quite meet every requirement? Maybe you overlooked a requirement, or maybe you assumed certain capabilities were standard, but they weren’t.

If you’re looking around at reporting tools, I want to help you avoid that mistake. The first (and most important) piece of advice is this: Never assume. Don’t just assume that every tool is created equal, or has similar features. Some tools may look impressive, but completely leave out some “basic” features.

So, what do you look for in a reporting tool? Obviously, the requirements vary by company, but I believe that certain elements are essential in a good reporting tool. What are they? We’ve put together a handy list of 6 essential elements you should look for in any good reporting solution. I hope you find it useful!

Solving the “build vs. buy” debate

By / ,

Save MoneyIt’s a common question, one that undoubtedly emerges with most large software purchases: Should we build or buy? Do we build our own solution from scratch or purchase a pre-built, off-the-shelf solution?

On one hand, building a custom solution is ideal. You’re left with software built specifically for your company, built to handle those small details unique to your business. That sounds great, but…there’s a problem: It’s expensive and time consuming. Building a custom solution from the ground up can take a year or two, depending on complexity. Oftentimes, it requires bringing in outside consultants, which only adds to the cost. …

Solving the “build vs. buy” debateRead More »