Lenovo Warranty Lookup: Difference between revisions
No edit summary |
No edit summary |
||
| Line 12: | Line 12: | ||
In the top right drop down change it from '''Form Builder''' View to '''Ship''' | In the top right drop down change it from '''Form Builder''' View to '''Ship''' | ||
[[File:Warranty lookup 01.jpg|50px|frame| | [[File:Warranty lookup 01.jpg|50px|frame|none|warranty lookup 01]] | ||
Click on the '''Ship Date''' to isolate entries without warranty information, and click on the boxes to the left of each entry to select them | Click on the '''Ship Date''' to isolate entries without warranty information, and click on the boxes to the left of each entry to select them | ||
[[File:Warranty lookup 02.png|frame| | [[File:Warranty lookup 02.png|frame|none|Warranty Lookup 02]] | ||
Once the wanted entries are selected go down to the '''bottom of the page''' and in the '''Excel row''' change it from '''all''' to '''selected''' and click '''generate''' | Once the wanted entries are selected go down to the '''bottom of the page''' and in the '''Excel row''' change it from '''all''' to '''selected''' and click '''generate''' | ||
[[File:Warranty lookup 03.png|frame| | [[File:Warranty lookup 03.png|frame|none|Warranty Lookup 03]] | ||
Open up the excel file and '''delete the top 2 rows''' and '''keep only''' the '''columns''' to the '''left of Serial Number''', '''delete''' the rest | Open up the excel file and '''delete the top 2 rows''' and '''keep only''' the '''columns''' to the '''left of Serial Number''', '''delete''' the rest | ||
Revision as of 20:12, 30 March 2020
Warranty Lookup
Following applies to Lenovo brand computers
go to: https://pcsupport.lenovo.com/us/en/warrantylookup/batchquery
Download the latest template and open it up, enable editing and remove all example entries leaving only the top row intact
go to https://forms.swkls.org/clients/index.php
Login to account and go to view the Computer Inventory
In the top right drop down change it from Form Builder View to Ship
Click on the Ship Date to isolate entries without warranty information, and click on the boxes to the left of each entry to select them
Once the wanted entries are selected go down to the bottom of the page and in the Excel row change it from all to selected and click generate
Open up the excel file and delete the top 2 rows and keep only the columns to the left of Serial Number, delete the rest
Copy the Model and Serial Number entries, and paste them into the template you downloaded earlier and save it
Upload the file to the webpage where the template was downloaded from and start entering the information into the computer inventory entries using:
- start column as ship date entries
- end column as warranty 1 entries