icon

An inside look at MetaCommunications products and services by those who develop, support, and work with them...


  • All

Protecting your data: A cautionary tale

Posted By: jbierman Fri, Mar 12 2010 7:49 AM
There are moments when we do things that seem like a good idea at the time, but wind up putting ourselves (or our data) in danger. Take the details of a recent support case as an example.

Conceptual image of databases in the MetaCommunications product colors.Ray is the production manager at his company. He also happens to manage his company’s Workgroups system and the related servers. Late one Friday afternoon, Ray called me at technical support. "The drive where my database was located was full, so I deleted some files to free up some space," he said. "Now I can't log in to my database." While not the ideal reason to have to use one, this is the reason we have backups. So I asked Ray if we could just restore from backup. "Uhhh, I think I may have deleted my most current backups too." The panic was rising in his voice. "My boss is going to kill me," he said. Ray was beyond nervous.

Upon examination of the server, I determined that Ray had in fact deleted part of his database by deleting the transaction log file. "I thought it was an old backup file, so I deleted it," Ray explained. Ray had also deleted the previous night's full backup from the server. Indeed, things did not look good for Ray. Without a full backup, the database would be lost.

Then something dawned on Ray. "Hey, let me check the tapes... I may have backed this server up to tape last night," he said, hopefully. It turned out that the backups he deleted were on the tape. He was in luck because of this, and we were able to help him recover his database.

The object lesson for all of us is this: Recovering from a database loss shouldn’t come down to luck.

You should have a plan in place to ensure that you can recover your database in the event of any type of failure. Here are some things to consider when protecting your own Workgroups data:

  1. Make a full backup of your database daily. If possible, this backup should be kept on a drive where the database DOES NOT also reside. You should also make frequent transaction log backups throughout the day.
  2. Back up your database backups to tape as a part of your network backups and rotate those tapes off-site regularly.
  3. If you have Approval Manager, your proof files should be backed up to tape on a regular basis. If possible, you should also re-direct the location where the proof files are stored by Approval Manager.

MetaCommunications Technical Support is currently working with customers to help them review and verify how their data is being backed up. If you have questions about your own backups, please contact us to schedule a time to review your data protection scheme. A few minutes of preparation will save headaches when, like Ray, you need to recover your database.

  • Comments: 0

A Day in the Life... Hiding Form Elements

Posted By: clewis Thu, Mar 04 2010 12:12 PM
In this installment of A Day in the Life... we find that the past few weeks have been going pretty good for our developer friend. He has had time to catch up on other duties and to read up on some new Virtual Ticket features. Until one day:

Boss: "We have new temporary staff entering data into Virtual Ticket. They are having some trouble understanding what data is needed in some of the fields. The fields are labeled but that is not enough. Could you add brief descriptions to these fields to help the temp staff?"

Developer: "The form design is already pretty tight."

Boss: "Well you have to do something to address this issue."

Well the developer liked the current look of his forms. He did not want to clutter them up with paragraphs of instructions just to help some people that rarely use the system. He remembered reading about a new feature in Virtual Ticket that allows form elements to be hidden or shown as needed. This is done in MetaScript by setting the elements visibility property. He got to work developing a solution that included a popup bubble graphic and a text box.

Developer: "See, just click that  button and the help bubble pops up to give the user directions."
Screenshot of Virtual Ticket Form with a Help Button Screenshot of a Virtual Ticket Form with a popup help bubble displayed.

Boss: "Boy, I like that. Hey you know, I have always hated the way you have us going to another form just to send an email. Can you do something like this popup to create emails?"

Well the boss beat him to the next step in his plan. Yes, he could use this same technique to collect email information in a popup, and in fact, that was next on his list to do. He understands that he can control the visibility of all types form elements. It took a little bit of work to script all of the elements needed, but when he got it done is was really pretty neat.  To get you started, we've created an example in Toolbox Snippet 18593: Create an Email Popup
A popup email editor is used to write and send emails from within the Virtual Ticket form.

Boss: "That looks great! I'm glad I thought of it. I gotta go show the VP..."

Wanting to stay ahead of his boss, the developer came up with another application for this feature. His form had only enough room for a single cell file collector, but this collector usually held many images. The users always had to scroll through one image at a time in order to see them all.

He thought about it and realized that this would be another opportunity to use this new visibility feature. So he placed a  button in the corner of the current single cell collector. Clicking this  button toggled the visibility of a twelve cell file collector. This twelve cell collector was positioned directly over the single cell file collector. He then placed a  button in the corner of the larger collector. Clicking this  button would hide the larger collector. 
We've provided an example of this in Toolbox Snippet 18596: Create Expandable File Collector

He showed his solution to his boss and his boss loved it. He couldn’t stop clicking the buttons to expand and shrink the file collector window.
A standard one column file collector in a Virtual Ticket form. A multi-column file collector popped-up over a Virtual Ticket form containing a single column file collector.

Boss: "Now this is great! Can we still drag images into this larger collector?"

Developer: "Yes, this larger collector retains all of the standard functionality."

Later that day, the boss is overheard telling the VP what a great job the developer did on the new Virtual Ticket features.

So it turned out to be another great week; got a lot accomplished, learned some new tricks in Virtual Ticket, and got some recognition for his efforts.

  • Comments: 0

Quick-Start Rollout Strategies for Workgroups 2010

Posted By: mguthart Fri, Feb 26 2010 11:57 AM
I recently wrapped up a series of online training sessions for a client covering the entire Workgroups 2010 suite. For most of the attendees, this was their first real-world exposure to how Approval Manager, Digital Storage Manager, Job Manager, and Virtual Ticket might be set up for their own environment. From the training experience itself, the sessions were a success - everyone felt much more comfortable not only with what Workgroups does, but also with what the steps are for setting up each of the different products.

At the end of the training, we reserved some time as a group to discuss next steps: where to start. This tends to differ based on the critical needs are for each group and how they plan to use Workgroups to address them. The nice part, though, is that there are numerous areas within the system that can be set up and running in a short amount of time and with very little effort, but that tend to bring significant value almost immediately. 

Depending upon your own needs, you might consider beginning with any one of the following:

  • Manage proofs with Approval Manager: This is one of my favorite places to start. With Approval Manager, the setup is very minimal - simply define internal and collaborative users and then assign access privileges. The result is immediate - you can start creating proofs and routing files through the proofing process. As an extension to this, you may elect to associate proofs with jobs and customers. But even this is minimal - enter a customer code/name, enter a job number/name, and off you go. As a result, proof files are available for review online, proofs are reviewed/routed faster as more internal and collaborative users are engaged in the process, and you have a fundamental management system in place to monitor proofs throughout entire production/approval workflow. 

  • Catalog digital assets with Virtual Ticket: Of the four products that make up the Workgroups suite, Virtual Ticket is by far the most extensible and customizable. With this great power, however, comes the potential need for greater planning - determining what fields you'll want to define, formatting the tickets to your needs, etc. But one area where you can hit the ground running is in cataloging of digital assets with Virtual Ticket. Imagine you have a file server with hundreds, thousands, or millions of files. You might have a vague notion of where files are located, or maybe what they are. Or maybe not. Taking these files and simply cataloging them into Virtual Ticket gives you immediate results with absolutely no setup required at all: you can visually see what files are out there, you can search for files (search where the file location contains a job number for example), append keywords and other metadata, etc. Longer-term you could build on this to associate those files with jobs, job tickets, and other data you create in Virtual Ticket, but the cataloging process itself can get you up and running with the system in a very short amount of time.

  • Catalog digital assets with Digital Storage Manager: As an extension to cataloging with Virtual Ticket, Digital Storage Manager can make the cataloging of assets even easier to get started with. Digital Storage Manager introduces InterSync - a server agent that can be set up and configured to automatically monitor/catalog your file server and its volumes. There is some initial set up required to tell InterSync what file servers to monitor and how to connect to them, but the results are that files show up in the system automatically when they are added to the monitored file servers. This giving you the same level of benefit found with cataloging digital assets directly with Virtual Ticket, but with even less manual work on your part.

  • Track time with Job Manager: Of the four quick-start functions I'm describing in this article, tracking time with Job Manager involves the most amount of setup and configuration, but comparatively speaking, even this is pretty minimal. Certainly there are other areas of Job Manager that you could start with quicker and easier (using Job Manager to start entering estimates or quotes, for example). However, in my experience, it's the time tracking capabilities that give customers the biggest return on initial investment. Setting up Job Manager to track time involves defining users, and defining a base structure for your company: departments, cost centers, and tasks/services your company provides.  It also involves entering a base set of customer and job information into the system. But, if the goal is to focus initially on the time tracking functions, then these steps can be minimized pretty easily (skip the setup of tax structures, shipping options, etc. and just focus on the base areas). The result is worth it. You get a system up that will track what jobs your users are working on, how much time they spend on what, and an endless number of ways to report and analyze this information - review how many hours went into a job, see how much time was spent this month for specific departments, cost centers, and/or tasks, review how much work was performed for a customer, etc.

As a complete solution, Workgroups 2010 is a tremendous product that enables companies to track and manage a multitude of information: estimates and quotes, job tickets, workflow and scheduling, job costing and billing, etc. Each area has its own unique set of features and functionality, with some requiring a more involved setup process than others. With the 'quick-start' areas described above, you can see that getting up, running, and achieving results with Workgroups can be a simple, quick process with requiring minimal effort.

How about your system? Are there some quick-start functions you've found with Workgroups 2010? If so, let us know - I'd love to hear about them!

  • Comments: 0