New Equipment Filters Spreadsheet with More Info and Video Tutorials
I hope you're doing well so far this week
Our puppy Kiba is not doing so well, He got clipped (neutered) yesterday.
The Vet says he has to stay confined for 10 days and he's already getting antsy.
Gas prices are down to $3.35 per gallon at the Sam's club nearest to us here in Las Vegas.
It's supposed to get up to 102 ° F today. It's cooling down…
Now on to today's Tip:
I had a request from a client yesterday for a filters report that could be broken down by customer or a list of equipment.
So I created a spreadsheet that will link to your TATEMS data And display the following columns in Excel:
Equip Num
Customer
Location
Dept Or Area
Lube Primary
Lube Secondary
Air Filter
Air Inner
Fuel Primary
Fuel Secondary
Hydraulic
Trans Filter
Water Filter
Other Filters
Once you open it up in Excel you can sort it and filter it anyway you want.
I show you how in this video:
You will need to have Microsoft Excel to use this spreadsheet and have it link to your TATEMS data.
This spreadsheet will link to your TATEMS data if it’s in the default installation location on 32 bit Windows.
C:Program FilesTATEMS 2005tatems2005be.mdb
The video in a previous post below shows you how to change the data path in the spreadsheet if you have Excel 2007 or Excel 2010. Click here to see the previous post.
And the video below shows you what you will probably need to do in order to make it work on your computer if you are not running Excel 2007 or 2010
You can get this newest spreadsheet at our website and it’s called:
TATEMS-EquipmentFilters-WithCustomer-Location-DeptOrArea-Fields
It’s completed for you online and ready to download at the link above or here:
http://tatems.com/spreadsheets
This spreadsheet is number 61 in the list on that spreadsheet page.
I hope this tip has been helpful for you.
Please leave any questions, comments or requests for special Excel Spreadsheets below. If your spreadsheet requests are feasible I’ll get them created and posted in a future TATEMS Tip.
Thanks Again,
Marc Ready
PCHelp, LTD
P.S. We plan to have a updated version of TATEMS in a a day or two.
P.P.S. We are also about ready to release a beta version of our new TATEMS Reminders program. This program runs in the windows notification tray down by the clock separately from TATEMS. It will automatically send out different reminder types via email to as many people as you need to send them to. Let me know if you would like to try out the beta version.
TATEMS on Terminal Services Server Video Part 1
It's been a crazy world the past couple of weeks. We live in interesting times.
I pray you're doing well and staying safe wherever you are.
My wife and daughter drove to Arkansas last week to visit her parents and they decided to drive back though the Rocky Mountains of Colorado. It sounded nice. I'm still waiting to see the pictures though.
Gas prices here in Las Vegas this week are at $3.39 per gallon at out local Sam's club and it's going to be 104° today.
Now on to today's tip:
I have been getting more and more people interested in installing TATEMS on Windows Terminal Services Server.
This allows you to run TATEMS entirely on the server and can really speed things up if you have multiple users accessing TATEMS on a network.
It's the only way you can use TATEMS over the internet or from remote shops that are not on your local area network.
We are in the process of partnering with a company that will offer Terminal Services Servers over the internet with TATEMS pre-installed; for a monthly fee per user plus a setup fee to anyone who wants it. These servers are completely maintained by the company we are partnering with and we will make sure TATEMS is updated and running properly on them as well.
If you are interested in this service please let me know. You will also be able to install and run other applications besides TATEMS on the servers if you need to.
If there is little or no interest we probably won't proceed.
In this video I demonstrate how to setup TATEMS on a Terminal Services Server (TS) that needs to have multiple users accessing the program at the same time. There are two types of remote access to the server you can take advantage of when setting up TATEMS on TS.
The first way is to grant the user remote desktop access. This is where the user logs in and sees his personal desktop that resides on the server and the TATEMS icon is on that desktop. He launches and runs TATEMS on the Remote desktop.
The other way is to setup what's called a RemoteApp. This is where the user gets an application icon on his computer for TATEMS but when he launches the application the program appears to be running on his computer but it is actually all running on the server. I'll go over setting up TATEMS as a RemoteApp in a second video in the next couple of days.
What's nice about either method is that TATEMS back end data file and front end files reside on the same computer(the server). So you don't get the performance degradation you get when you access the back end file over the network.
Here is the first video showing the setup of TATEMS in Remote Desktop Access environment on Windows Terminal Services Server:
I am also including some written instructions from out knowledge base:
For Terminal Services do a Full Install Logged as Administrator
and using Add/Remove Programs or the Terminal Service Application
installer to navigate to the setup file called:
tatemsmsi.exe on the CD or download.
When TATEMS is installed on Terminal Services
or Cirix only one person at a time can access
via remote access.
If you need to let more than one person at a time
use TATEMS via remote access then each additional
simultaneous user will be required to have their own license.
Here is the work around to let more than one person at
a time have access to TATEMS.
After the install is finished…
Create a sub folder for each user that will log in to use TATEMS
in this folder
C:Program FilesTATEMS 2005
(or in C:Program Files (x86)TATEMS 2005 on 64bit)
For Example for you might use
C:Program FilesTATEMS 2005Scott
copy this file
TATEMS2005.mde
in the
C:Program FilesTATEMS 2005
folder to each users sub-folder folder
( EX.C:Program FilesTATEMS 2005Scott ).
Then log in as each user and send a shortcut to the desktop for that file in the corresponding folder that matches the user name.
You can use the wrench.ico as the icon for the shortcut you create.
Then use the shortcut you create instead of the one created by the installer.
You can delete or hide or move the one created by the installer.
Whenever you do an update you will need to copy TATEMS2005.mde to each of the users sub-folders. You can create an Xcopy batch file to do the job for you.
You will need to own a separate license for each different user when logged in to terminal services or Citrix server in this configuration.
Take Care and Thanks Again,
Marc Ready
PCHelp, LTD