Archive for the ‘features’ category

Innovation in Search

June 5th, 2009

Search is hot lately, with two new search engines being announced in recent weeks. As the world’s only easily-searchable database platform, we’re happy to see attention being paid to finding relevant data easily.

The first new search engine to come out is Wolfram Alpha, founded by physicist/inventor/crank Stephen Wolfram. I would describe Wolfram Alpha as a cross between Google and Wikipedia for technical topics: math, physics, chemistry, and so on. It’s neat that I can type in sin(x) and see a graph, or type in benzene and see everything from its molecular structure to a phase diagram. Then again, I’m a nerd. Outside of scientific fields, it does poorly. If I type in Brazil I see only a smattering of factoids about the country. Compare this to Google’s entry for Brazil, which gives me images, maps, recent news, and so on; or Wikipedia’s entry, which is simply awesome, and shows Wikipedia at its best.

The second recent search engine to be unveiled is Microsoft’s Bing. It copies recent Google innovations like chunking out search results into different areas (news, maps, facts, weather) and providing suggestions for refined or related searches. It also has some very useful new features, like a mouse-over preview of the content of each search result that a user can skim before deciding whether to follow the link.

All of this innovation shows that search is as important as ever. We couldn’t agree more. That’s why we built the world’s only searchable database. Type in what you’re looking for, like you would in an Internet search engine: phrases, people, dates, numbers, and so on. TrackVia translates your request into a search that’s appropriate to your data model, and presents a highlighted list of matching records from your database.

Search Results in TrackVia

You can then edit the data right in the results page. You can also search notes that colleagues have added to database records, and search the built-in change history that TrackVia keeps for every record. And you can use advanced tricks like phrase searches, exact matches, negative matches, field binding, and even searching for blank values. All of this with a single search box, and a button labeled “Go.” No queries or wizards required. Did I mention it’s really, really fast – even with a hundred thousand records in your database?

It’s sort of like TrackVia is the Google/Bing/WolframAlpha of your own data.

Peninsula Orthopaedic Associates Shoulda Had TrackVia

April 20th, 2009

As many as 100,000 patients of Peninsula Orthopaedic Associates were warned tapes containing their personal information were stolen on March 25, 2009. The tapes were stolen en-route to an offsite storage facility.

The good news is that Peninsula Orthopaedic was backing up its data. The bad news is the backup tapes were stolen while being transported to an offsite facility. If Peninsula Orthopaedic had used an online database like TrackVia, patient data would not have needed to be physically transported to an offsite storage facility.

With TrackVia, no data is stored on your computer. TrackVia uses RAID mirroring to store data on physically distinct and redundant storage devices. In addition, all data is stored in duplicate on physically separate servers in real time. This continuously running backup process eliminates the need for customers to back their data up on tapes and transport them to an offsite facility.

Peninsula Orthopedic and its patients alike could have rested easier knowing their data was continually backed up at TrackVia’s infrastructure partner, ViaWest, which provides a solid hosting infrastructure built with redundancy, security and performance in mind.

Ten Reasons an Online Database is Better than a Spreadsheet

April 9th, 2009

1. You can easily assign who has access to what data with user permissions in a database.

2. You can search a database like the Internet.

3. There are more ways to collect data with a database: website forms, email collection, excel import.

4. There is no software to download with an online database. Access data anywhere, anytime without the need to email files or worry whether or not you have the latest version.

5. You have the ability to store multiple data types in a database: music files, images, documents, etc.

6. With a database, you have the ability to publish dynamic real-time reports to the web.

7. Multiple team members can access and edit data in a database at the same time. Automatic change tracking lets you know who changed what/when. No longer worry about version control issues experienced with spreadsheets.

8. An online database is continually backed up minimizing the fear of losing changes made to your spreadsheet.

9. When you change a field type in a database, you receive a warning of the impact the change will have before the conversion occurs.

10. Databases allow you to set up email alerts or distribution schedules so you can stay informed of changes/updates to records in your database.

BONUS: If you are using a spreadsheet to track data, you can easily convert your spreadsheet into an online database within minutes via an excel import. You can even update an existing database with an excel import by mapping spreadsheet columns to database fields.

How an Online Database Can Streamline the Hiring Process

March 25th, 2009

Resume Overload With unemployment rates breaking records, hiring companies are being bombarded with applicants. National media outlets recently covered an open janitorial position at a school in Ohio that received 835 applicants for a full time job that pays $15 to $16 an hour with benefits. With numbers like these becoming more the norm than the exception, it becomes almost impossible for hiring managers to find the needle in the haystack.

During a recent conversation with one of our customers in the outplacement business, we learned how some hiring managers are dealing with the record number of candidate resumes that have been pouring in recently. The customer pointed out that hiring managers should view the thousands of resumes received as an opportunity to find the best candidate and a resource to build a candidate database for future positions rather than a never ending maze of paperwork.

After my discussion, I thought it would be worthwhile to share the advantages of using on online database with email collection to streamline the applicant review process:

1. No need to manually re-enter applicant emails received into your database. Enable online database’s email collection feature to automatically collect emails received from company’s career email address (careers@company.com) and applicant database records will automatically be created in your database and resume attachments will be uploaded into the notes section.

2. Don’t worry about forgetting to send out acknowledgment of resumes received. Enable the auto reply to automatically send out an email acknowledgment once a resume has been collected.

3. Categorize and organize applicants through the use of powerful database field types. Create fields to track progression of the applicant through the hiring process and record notes on the applicant.

4. Easily find the needles in the haystack. Use the powerful search functionality to search the entire database for key words or phrases used in the cover letter text included in the body of the collected email.

5. Control access to applicant data. Assign user permissions to give the hiring team the appropriate permission levels to view candidates in the pipeline. For example, if human resources should only view certain fields, you can restrict access to these fields.

6. Coordinate interview schedules within the database. Create a calendar view and set up a email campaign and mail merge feature to send out emails to those candidates who did not meet the qualifications for a particular job opportunity.

If you are hiring, I’d like to know how you are handling the volume of resumes being submitted to your company. Also, if you’d like help getting your applicant process on track with TrackVia, give me a call.

Read following case study to find out how an outplacement firm is using TrackVia:

Outplacement Firm Customer Case Study

Six Referral Database Tips

March 10th, 2009

make a referral weekAre you waiting around for the stimulus package to miraculously jump start your business? I hope not because it will take time to see the results. What can you do in the meantime to stimulate your business and the businesses of others that costs next to nothing? Make a referral to a business you admire and ask your customers for a referral.

Duct Tape Marketing has proclaimed this Make a Referral Week. As an employee of a company that values the referral process, I thought I’d highlight the importance of tracking referrals. After all, what good is a referral if you don’t follow up?

Here are six tips to make the most out of your referrals using an online database:

Make it easy for customers to submit referrals. Create a website form to capture referrals from your customers. Eliminate manual entry by using a web form powered by a database so submissions are automatically populated in your database.

Ask all customers for referrals. You have nothing to lose and everything to gain. Create a drop down field in your customer database denoting whether or not a referral has been requested. This will keep your account reps honest and make it easy to identify customers who have not been approached for a referral.

Capture the relevant referral information via flexible field types. Create a short answer field to document the name of the referral, an email field to capture the referral’s email address, a number field to record the phone number, a date field to record the date received, a paragraph field to take notes on the referral, and a drop down field to record the status (open, in progress, closed, dead).

Be Proactive and Follow-Up. Stay on top of referrals by using the status field to create a filtered view of all OPEN referrals and have it emailed to you daily. Contact these referrals and open the call by referencing the customer who referred them. If you really want to stay on top of referrals, create an email alert to notify you every time a referral is entered.

Be Appreciative and Thank Referrer. A simple acknowledgment is all it takes and often times when you thank referrers they will give you another referral. Create two fields to track referrer thank you: an acknowledgment drop down field (no acknowledgment, email, handwritten, and phone drop down choices) and a date sent field. Create a filtered view to identify and monitor all referrers with a status of “no acknowledgment” selected. As your volume of referrals increases, consider using a database with a built-in email campaign tool and mail merge feature to send acknowledgments.

Monitor Referral Statistics. Use the database statistics view to determine your referral conversion rate.

Want help setting up a tracking system for your referrals? Give us a call at 1.800.673.3302, and we will get your referrals on track.

Five Ways a Database Protects Data

March 6th, 2009

Preventing Data TheftDon’t leave your data unattended. According to a recent study by Symantec Corp. and the Ponemon Institute 79% of all workers who left an employer within the last year took data without an employer’s permission. Businesses must protect their data from employee theft in good and bad times.

As I read a recent post on Computer World that identified steps to protect your business from angry ex-employees, I could not help but think of how an online database helps businesses maintain control over data and data theft.

Five Ways to Protect Data in a Database

1. Control data access through user permissions. Set appropriate permissions to restrict access to records (viewing, editing and deleting), fields (viewing and editing), and features (tools and reports). For example, you can allow sales reps to view leads assigned to them while restricting their ability to export leads to Excel.

2. Restrict access to data with IP Filtering. Grant access to a group or range of IP addresses. No longer worry about employees accessing and downloading data from home.

3. Track database activity with automatic change history notes. These notes provide an audit trail so administrators can keep track of who did what when.

4. Enable Email Collection for laid off employee’s email. Eliminates the need to forward former employee’s emails to another employee and wonder if they are being monitored. Simply have them collected in a database making it easy to monitor any business correspondence received after the departure.

5. Delete user from database prior to notifying of lay off. All permissions previously granted will cease to exist so former employees can no longer access business critical data.

Leverage the power of your database to control access to your data and prevent former employees from walking off with your data.

I Need to Know. Everything. Immediately.

February 10th, 2009

One advantage of using an online database is the visibility it provides into one’s data. Custom views, statistics, and powerful search features make it easy to see what’s happening with customers, orders, inventory, and nearly everything else.

Sometimes, though, that’s not enough. If a customer logs a critical bug, I want to know about it right away, not the next time I log into TrackVia and look. If our sales group has a time-sensitive opportunity that requires senior management involvement, our CEO wants to know about it immediately, not the next time TrackVia emails him a pipeline report. In fact, come to think of it, I want to know about all bugs, and our CEO wants to know about all sales opportunities, as they happen. We have a high need to know.

Now we can know. Last week TrackVia launched a new alerts feature. Alerts allow TrackVia users to be notified by email whenever their data changes in ways they’re interested in. This could be an added record, a deleted record, or any change to a specific record. It could also be a change to one or more records that meets very specific criteria.

TrackVia Alerts

The specificity of those criteria make alerts great for workflow applications, that is, using TrackVia to manage a business process. For example, an alert can notify a claims processor that an investigator in her region has approved a claim and it’s now ready for payment.

If you have a high need to know, and you’re not getting it from your current database, you might try a better database.

TrackVia News: New Alerts Feature and Partnership with Parallels

February 4th, 2009

During the Parallels Conference in Las Vegas, we announced the public launch of our Alerts feature and a new partnership with Parallels.

The Alerts feature allows database users to receive real-time email notification whenever data is added, removed or changed in a database.  Data Alerts support a wide range of workflow and business process applications.  For example, an alert could be used in a CRM database to notify a sales rep when they have been assigned a new lead.

Through our partnership with the Parallels SaaS ISV Initiatives Program, TrackVia gains access to Parallel’s 10,000+ Service Provider Channel.  Parallels VP of SaaS and Service Provider states, “The TrackVia SaaS database provides our hosting partners with a high value-added product offering that complements and extends their existing hosting solutions.”

For more information on our new alerts feature or our partnership with Parallel’s drop us a line at support@trackvia.com or call us at 1.800.673.3302.

Database Architecture Meets Prefab Architecture

February 4th, 2009

The February 2009 issue of Dwell on Prefab Architecture intrigued me and led the data architect in me to identify some similarities between current prefab and database architecture.  In the past, all prefab options were kits.  For example, in the early 1900s a Sears and Roebuck home came with a 75 page instruction manual and 30,000 pieces, not including screws and nails.  There was little if any freedom to deviate from the manual.  The same could be said of packaged database software; you got what you purchased and nothing else.
As the issue pointed out, the times have changed in the prefab housing world; you can now purchase prefab offerings that you can customize with your own personal touch.  Your prefab pad no longer has to scream, “I am just like the house next door!”  The same is now true for the database world.  You can now purchase an online database solution like TrackVia, without worrying about getting trapped into a specific mold that was designed or dictated by someone else. Today, online databases are extremely flexible and give you a host of options to customize the database to suit your business’ individual needs.
Like the Dwell article, I have outlined the benefits of today’s prefab database architecture:

  • Affordable – Online databases are more affordable than pre-packaged and custom designed databases, and come with unlimited free phone and online support (at least with TrackVia).
  • Mobile – Online database solutions can be accessed wherever there is an Internet connection, allowing you to take your database with you.
  • Reconfigurable – Edit your database to meet your needs: easily add/concert fields, control user permissions and change format views to meet your specific criteria.
  • Completely Custom – Easily customize database to meet your specific data tracking needs without the need of a consultant with programming knowledge.  Also, receive new features in real-time.

There is always the option to hire an architect to build a custom house or a programmer to build a custom database, however it does not come cheap.  If you were an architect designing the future of “prefab” databases, what features would you look for to differentiate your blueprints?

Google Shows Its Human Side

February 3rd, 2009

Were you one of the Googlers worried you were infecting your computer with viruses on Saturday morning?

For about an hour on Saturday, each and every Google search resulted in a warning that “this site may harm your computer.” What happened, according to a Google statement, is due to – human error. Google works with a nonprofit that tracks the sites that install malicious software on visiting computers. On Saturday, someone accidentally checked the input value that applied to ALL URLs – ouch!

The term “human error” in situations like these is kind of amusing. It’s framed almost as a good thing (”don’t worry – there’s nothing wrong with our software. Bob just pushed the wrong button!), but the reality is that human error can be just as harmful as systemic errors – especially because you can usually weed out the systemic errors by fixing the code (or, for you Office Space fans out there, “fixing the glitch”).

There’s often no such quick fix for human error. And the more times you have people manually enter and manipulate data, the more risk you’re running of human error.

Obviously we are all humans, and this event has proven that even Google can’t escape the occasional human error.

TrackVia’s online database solution has a few features to help us with our humanly ways. Features such as automatic change tracking notes, user permissions and relational databases help to eliminate human error or at a minimum easily identify the culprit making changes to the database.

How do you prevent human errors?