How to use TATEMS Import Template

How to use TATEMS Import Template

We can do an import of your equipment for you and then send you a pre-populated TATEMS data file.

The data file we send back will overwrite any data you have already entered.

We can import your equipment into TATEMS for you if you use our template here:


Just paste your data in the fields you have data for.

For the column that says Category Type(1 of 3 types(Truck-Trailer-Other)(Required)

This is for the Equipment Types dropdown list in TATEMS and you no longer have to limit your entries to those 3 types

In the TATEMS database, we already include the following equipment types:

Truck
Trailer
Truck/Pickup
Heavy Equipment
Auto
Other
Bus
Fire Truck
Ladder Truck
SUV
Passenger Van
Delivery Van

So you can match your equipment with those or use your own but you should try to keep the categories as broad as possible.

For the Truck and Trailer equipment types the TATEMS will come with pre-populated inspection items lists.

You will be able to use those inspection items lists to copy to other equipment types and use as a starting point if needed.

The other columns with specific choices need to use only those choices. 

The only required fields are:
Equip Num(Required)
Description(Required)
Category Type(1 of 3 types(Truck-Trailer-Other)(Required)


I would recommend using at least 3 or 4 digits on your equipment numbers if you have numbers starting with single or double digits.

For example I would make (hint prefix 0 with '  single quote mark to make it stick)

1 into 001 or 0001

and

11 into 011 or 0011

Also make sure there are no commas , or  double quotes " in your data.

Once you have everything pasted into the spreadsheet, you can send it back. Then I can use it to populate an empty TATEMS database file with all your equipment and send it back to you.

And if you pave a parts list, you want imported here is the parts Import template:


On the parts template, the only requirement is the Part Number and make sure there are no commas , or quotes, single or double ' " in your data.

Once you have everything pasted into the spreadsheet templates, you can send them back. Then I can use them to populate an empty TATEMS database file with all your equipment and parts and send them back to you.

    • Related Articles

    • Copying Parts List

      To copy a parts list from one vehicle to another: 1. Select the vehicle with the parts you want copied. 2. Select all parts you want to copy by clicking on the left square box and highlighting all the parts you want copied. 3. Push ctrl-c to copy the ...

    • TATEMS Data file corruption

      Data file corruption can be repaired automatically starting with TATEMS version 4.6.28.000 and improved even further in 4.6.28.001 If you are eligible you can get the current update here: https://tatems.com/updates If you have expired you can renew ...

    • Add Parts Button Missing/Hidden

      If you are unable to see the bottom of your Parts Inventory screen and your Add New Part button seems to be missing or hidden please see this video: http://www.screencast.com/t/KSwSAQ10B If you need to update TATEMS as the video suggests you can do ...

    • Moving TATEMS to a new computer or Data file to a new Server

      ***These instructions apply to computers that do not store the data file on a network server. If your data is on a network server simply install TATEMS on the new computer and then use the networking tool in TATEMS to re-link to your data file on the ...

    • TATEMS Backup

      To Backup TATEMS Data: Here is a video we created to show you how to backup: See the above video on Youtube https://youtu.be/JLT2tePuz0o In order to save and backup your TATEMS data, you need to make a backup copy of a file called tatems2005be.mdb. ...