Import data into TSS from XLS file

Import data into TSS from XLS file

Import data into TSS from XLS file

 

1 Click the tools menu then data then Import Data into TSS

2 Click Next

3. Choose the type of data like Inventory

4. Navigate to where you saved your .xls file

5 Next choose the sheet and it should preview your data like seen below

 

6.  

 

 

 

Click next and map your fields to the appropriate TSS fields the most important and only required fields are Make and Model 

 

 

Next then decide which fields to check for duplicates I would just leave it as Make and Model the more fields and the bigger the file the longer the import will take

 

 

Next

 

Now tell TSS where the data starts in the file most likely line 2 as the first line is the list of field names

 

 

Next and the last step is actually importing the data into TSS

 

    • Related Articles

    • Template File in Excel that can be used to import inventory into TSS XP

      Use the attached file to import data.

    • Routine Maintenance for TSS Data (Version 3.23 MTAS)

      To ensure optimal performance and data integrity, it is recommended to regularly restructure the TSS data—similar to a defragmentation process. This maintenance task should be scheduled to run nightly, or at a minimum, at the end of each week. ...

    • TSS XP Pre-Use Checklist

      Please note that the checklist required prior to using TSS XP is currently incomplete and remains a work in progress as of October 2024. Updates and finalization are actively underway to ensure comprehensive coverage and usability. In consideration ...

    • TSS Plus important tools and tips

      Fixdata.exe is the tool to backup and try to help with fixing your Plus data In TSS2000 it is the program that runs when you click on the ambulance within TSS. In general have all users close TSS before running Fixdata Do the manual choice from the ...

    • Moving a TSS XP Server to a new computer

      1. Go to the server computer for TSS XP and look for the ^ icon near the time, and locate the Application server icon at the bottom right in the task bar or hidden system tray (Green dot with letters IN)and double click it. 2. Click on Tools at the ...