It's been a while since I posted. I hope everything is going well for you and yours.
In this post a new spreadsheet and a Kiba update…
Cristy, one of our California clients asked for an equipment list that shows
whether each piece of equipment is out of service or not.
So the Excel spreadsheet I created will link to and display your TATEMS data just like the other ones posted at:
This is number 63 on the list an is called oddly enough:
I know, pretty original right?
The columns included in the spreadsheet/report are:
Our of Service?
Once you refresh your data you can sort and filter any way you want to.
This video shows you the columns and how to link your data if your data is on a network or on a 64 bit version of windows:
Now for a little Kiba (our puppy, now 8 months old) news.
A few weeks ago we had a scare…
He got a hold of my pack of trident gum on my nightstand. The Gum has “Xylitol” in it which is poison to dogs.
We took him to the vet and they forced him to regurgitate and took his glucose readings…
He came through it with flying colors and is fine and hyper crazy as ever…
A few days ago we got some snow in the hills near our house here in Las Vegas. So we took him and Maya(Golden Lab) up to his first snow (about a 15 minute drive) and he had fun biting it and romping around a bit. We couldn't get very far off the highway so we had to keep them on leash.
Kiba's first snow experience!
Until next time…
By the way if you have a request for a custom spreadsheet I can create and share let me know.
I'm going to change things up a little and put the tip at the top…
Now on to today's Tip:
Last week one of our clients asked if we could create a spreadsheet that would display all the items on the Inspections/Permits tab in TATEMS for all equipment.
This new spreadsheet links to your live TATEMS data and will display the following fields which you can now filter and sort any way you want to in Excel.
Last DOT Insp
Last 90 Permit
Next 90 Day
Last Annual State Insp
Next State Insp
Last Over OverAxTollerance Permit
Last Motor Carrier Certificate Reg
Next Motor Carrier
Last Smoke Insp
Next Smoke Insp
The spreadsheet is called:
It is spreadsheet number 62 on our Spreadsheets page:
If you have Excel 2007 or 2010 and you are running a 32 bit version of Windows and your TATEMS data is NOT on a server or other computer then you should be able to simply open and run this spreadsheet.
In the video below I show you how to use it on either a 64 bit version Of Windows or if your data is housed on a server. I also show you how to Filter and sort the data in this spreadsheet.
Other random stuff…..
As I write this on Saturday afternoon, it's suppose get up to 94° F today and we've had a few thunderstorms here in Las Vegas. The Gas prices at our local Sam’s club is at $3.55 per gallon… It’s going up.
Our Sprolie puppy Kiba finished his recovery from neutering and is as feisty as ever.
Thanks for visiting and remember to share TATEMS with a friend or colleague.
It's hot here today supposed to get up to 112° F here in Las Vegas and Gas at the local
Costco was down to $3.32 per gallon yesterday.
We just released a new version of TATEMS and it includes the following changes and improvements.
Added New checkbox to preferences to Always Display the Parts Notes field on a Work Order/Invoice printout. If unchecked the Parts Notes field will not display even if there is notes added to a part
Changed the way the “Parts Notes” field in a Work Order/Invoice printout is displayed. If there are no “Parts Notes” then that row will no longer display the the word “notes” and it also shrinks the empty row to save space and paper.
This video shows you the 2 updates listed above:
Updated All Equipment Due Next 30 Days report to include the new Work Order short description field
This video shows you update listed above:
Updated Lube Service Types- Now when a Lube Service Type is inactive you won't see it in the dropdown list even if used previously for that equipment, It still remains in Lube/Service History
Changed Accomplished by field in Lube Service tab so that it does not ask you if you want to add to list, Instead you can double click to bring up personnel windows
Updated Equipment Summary Screen to display the Miles/Km to go – Hours to go and Days to go in the Lube/Service list
Resized Lube Service Display on Equipment summary screen to fit extra fields and resized windows on sub tabs to utilize extra space
This video shows you the 4 updates listed above
Updated Work Order printout to display Invoice # instead of WO Num when it is printed as an invoice.
Updated Work Order Printout to display Make, Model, Year, Lic Plate, Serial/Vin and Moved Warranty and Recall to Footer by Cost Totals
Updated Work Order Screen to prevent inadvertent data entry into the Labor and Parts Cost totals fields
Updated Work Order screen to display Make, Model, Year, Lic Plate, Serial/Vin and Moved Warranty
Added Status bar and tool tips to Cost Totals fields and un-editable fields in the Work Order Screen
This video shows you the 4 updates listed above:
Added usability feature to simply double click to enter the current date into all date fields except date ranges on reports. Will also ask before changing if a date is already entered into the field
Updated Equipment Summary screen to display Vin number as Serial/Vin Number
Updated Current Life Remaining Until Replacement on Financials Popup window to not display error when Life Expectancy Years at purchase is not filled in.
This video shows you the 3 updates listed above:
Added dropdown to Inspectors Name to select from Personnel file, you can also just enter inspectors name
This video shows you the update listed above:
Updated Repairs Completed Reports under Reports->More Reports to also sort by completed date (For people who still use the repairs completed tab instead of using Work Orders)
It’s completed for you online and ready to download at the link above or here:
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.
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.
That's where the user will log in to the server and see an entire remote desktop with a TATEMS icon on it.
In this video I show you how to setup TATEMS in Terminal Services Server as a RemoteApp.
This is where the user clicks an icon on their own desktop and TATEMS opens. It looks like TATEMS is running on their own computer but it is in fact running on the server.
It's also a great way to restrict users from having access to an entire desktop on your server.
Either way you setup TATEMS on a Terminal Services Server you will find performance improvement and better stability, especially if you want to use TATEMS on a wireless network or over the internet or via a VPN.
Usually you will have an IT person handle this for you and if you do you can point them to these videos.
If you need help with this or anything else please let us know.
Also please make sure you stay current on your Support and Version Upgrades extensions with us.
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
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.