Click to Export File
Service Location Name Service Address 1
Use the area below to enter your work order informati The columns with black headers are required. Colum When you are finished, click the orange button to the If you have any questions please review the help work
Suite/Unit# Address 2
Limit 50 work orders per upload
w to enter your work order information, one work order per row. black headers are required. Columns with gray headers are optional. hed, click the orange button to the left to export your work orders for upload. estions please review the help worksheet or email us at uploadtool@onforce.com
City State ZIP Phone Extension Service Location Type End User Name
End User Phone Extension
Alternate Phone
Alternate Extension
Scheduling Option
Date Scheduled
Date Scheduled 2
Scheduling Notes
Category Code
Sub-Category ID Scope of Work
Detailed Description of Problem
Spend Limit Flat Fee Tech Supplies Parts
Operating System ID
Manufacturer
Model #
Serial # Support Contact Name
Support Contact Phone
Extension
Alternate Phone
Alternate Extension
Support Contact Instructions
Special Instructions
Dress Code
Custom Field 1 Custom Field 2 Custom Field 3 Custom Field 4
Custom Field 5 Custom Field 6 Custom Field 7 Custom Field 8 Custom Field 9 Custom Field 10
Custom Field 11 Custom Field 12 File Attachment IDs Autoroute
Provider IDs Assign to Username
Custom Logo ID PPN ID
Tags
End User Email Hourly Rate
This template has been tested in Excel 2000, 2003 & 2007 How to Enable Macros. On the Tools Menu, point to Macro, and then click Security. On the Security Level tab, select the Med To get more information on the upload tool or download the latest version, please visit https://www.onforce.com/media/onforce_workorderuploadtool.pdf
Sub-Categories and their IDs - grouped by their parent category
NW Wiring and Cabling 11 Ethernet Wiring (CAT3/5/5E/6) 12 Fiber 13 Phone System 138 Coax (RG6/59) 139 Structured Wiring DR Data Management and Recovery 14 RAID Array 16 NAS (Network Attached Storage) 76 PC Desktop Hard Drive 77 Apple Desktop Hard Drive 78 Server Hard Drive 79 External Storage Subsystem 306 Notebook Data Recovery 307 Data Migration
ID Operating System
68 AIX 65 Amiga 66 BeOS 42 Blackberry 62 FreeBSD 67 HP-UX 43 Irix
71 LindowsOS 44 Linux 45 Macintosh OS 9 46 Macintosh OS X 47 MS DOS 58 NetWare 3.xx 59 NetWare 4.xx 60 NetWare 5.xx 70 NetWare 6.xx 63 OS/2 48 Palm 61 Pocket PC 69 SCO Unix 64 Solaris 49 Unix 50 Windows 2000 Professional 51 Windows 2000 Server 80 Windows 2003 Server 52 Windows 95/98/ME 53 Windows CE 54 Windows NT Server 55 Windows NT Workstation 360 Windows Vista 56 Windows XP Home Edition 57 Windows XP Professional
e Security Level tab, select the Medium bullet point
HW Hardware Service 17 Data Storage System 19 Scanner Repair 20 System Diagnostics 21 Laptop Repair 22 Monitor Repair 23 PC Repair 24 Server Repair 82 Hardware Repair 83 Hard Drive Related 140 Tape Drives 317 Blackberry 318 Palm Based PDA 319 Microsoft CE Based PDA
NS Network Devices and Service 25 Switch 26 Hub 27 Routers 28 Firewall 29 Internet Connectivity 30 Network Setup 31 Network Appliance 85 Protocols 90 Print Server 119 Wireless Networking 120 Residential Networking 121 Residential Multimedia Setup 141 Wired Networking 142 Network Troubleshooting 143 Server Installation/Configuration 146 Network Security 320 VPN
SW Software Service and Support 32 Antivirus 33 Communications Software 34 Database 35 Document Creation 36 Graphics 37 Internet/Intranet/Web 38 Software Utilities 39 Productivity Suites 81 Contact Management 86 Server Software 87 Back Up Software 88 Accounting System 89 Email Software 144 CRM 145 Adware/Spyware Removal 322 VPN
PR Printer Service 91 Alps 92 Brother 93 Canon 94 Citizen 95 Dell 96 Digital 97 Epson 98 Fujitsu 99 HP 100 IBM 101 Kyocera Mita 102 Lexmark 103 Mannesmann 104 NEC 105 Okidata 106 Olivetti 107 Panasonic 108 Printek 109 Printronix 110 QMS 111 Star 112 Tally 113 Tektronix 114 Xerox 115 Zebra 116 OTC 117 Decision Data 118 Genicom 135 Apple 147 Kentek 148 C.Itoh 149 MemorexTelex 150 Texas Instruments 151 AMT 152 Unisys 153 Ithaca 154 Dataproducts 162 Konica/Minolta 163 Ricoh 321 Standard Register
OS Operating Systems 42 Blackberry 43 Irix 44 Linux 45 Macintosh OS 9 46 Macintosh OS X 47 MS DOS 48 Palm 49 Unix 50 Windows 2000 Professional 51 Windows 2000 Server 52 Windows 95/98/ME 53 Windows CE 54 Windows NT Server 55 Windows NT Workstation 56 Windows XP Home Edition 57 Windows XP Professional 58 NetWare 3.xx 59 NetWare 4.xx 60 NetWare 5.xx 61 Pocket PC 62 FreeBSD 63 OS/2 64 Solaris 65 Amiga 66 BeOS 67 HPUX 68 AIX 69 SCO Unix 70 NetWare 6.xx 71 LindowsOS 80 Windows 2003 Server
TR EndUser Training 72 Desktop Applications 73 Operating System Essentials 74 Desktop Peripherals 136 Multimedia Software 137 Productivity Suites 308 Home Networking Training 309 Camera/CCTV Training 310 Multiroom Audio Training 311 Home Automation Training 312 Programmable Lighting Training 313 Plasma / LCD Training 314 DVR / HDTV / Satellite Training 315 Home Theater Training 316 Digital Projector / DLP Training
PS POS 123 IBM 124 NCR 125 HP 126 Sharp 127 Dell 128 Panasonic 129 Epson 130 Fujitsu 131 Micros 132 Samsung 133 Casio 134 NEC 155 Ahiohm 156 Datasouth 157 Citizen 158 Intermec 159 Ithaca 160 SATO 161 Unisys
CE Consumer Electronics 260 Home Networking Installation 261 Camera/CCTV Installation 262 Multiroom Audio Installation 263 Home Automation Installation 264 Programmable Lighting Installation 265 Plasma / LCD Installation 266 DVR / HDTV / Satellite Installation 267 Home Theater Installation 268 Digital Projector / DLP Installation 269 Home Networking Service 270 Camera/CCTV Service 271 Multiroom Audio Service 272 Home Automation Service 273 Programmable Lighting Service 274 Plasma / LCD Service 275 DVR / HDTV / Satellite Service 276 Home Theater Service 277 Digital Projector / DLP Service
TV Telephony / VOIP 323 3ComNBX 324 Asterisk 325 AT&T 326 Avaya 327 Bogen 328 Cisco 329 Comdial 330 Ericcson 331 Executone 332 Extrom 333 Fujitsu/Focus 334 GTE 335 Harris 336 Hitachi 337 InterTel 338 Isoetec 339 ITT 340 Lucent 341 Meridian 342 Mitel 343 NEC 344 Nitsuko 345 Nortel 346 Panasonic 347 Plantronics 348 Polycom 349 Prostar 350 Samsung 351 Siemens/Rolm 352 Telco Systems 353 Telect 354 Telesynergy 355 Tellabs 356 TelPlus 357 Telrad 358 TIE 359 Toshiba
CM Copier / Fax / Multifunction 278 A.B. Dick 279 Brother 280 Canon 281 Copystar 282 Dell 283 Epson 284 Gestetner 285 HewlettPackard 286 IBM 287 IKON 288 Imagistics 289 Konica Minolta 290 Kyocera Mita 291 Lanier 292 Lexmark 293 Muratec 294 NEC 295 NEFAX 296 Océ 297 OKILaserfax 298 PanafaxLaserfax 299 Panasonic 300 Ricoh 301 Samsung 302 Savin 303 Sharp 304 Toshiba 305 Xerox