This page summarizes the errors that may occur when uploading the IT Devices CSV.
Please check the details of the error, correct the CSV file, and try uploading it again.
Errors When Uploading IT Devices CSV
| Error Message | Solution |
|---|---|
| Please check the headers | The headers of the uploaded CSV may have been modified from the original format. Please download the CSV template again, copy your edited data under the correct headers, and try uploading it again. |
| Please enter an Asset Number | The Asset Number is a required field. If you do not have asset numbers, we recommend assigning a format such as "Device Type-Sequential Number" (e.g., PC-001, SP-001 for smartphones, USB-001). |
| Please specify the status as "In Stock", "In Use", "Disposed/Cancelled", or "Unknown" | If you wish to use other statuses such as "Broken" or "Under Repair", please add them as Custom Fields. |
| Please specify "In Use" status when assigning a device | An assignment refers to a state where a "User ID" or "Employee Email Address" is entered. If these fields are filled, you must set the status to "In Use" and enter the "Start Date" at the same time. If a device is being used by an employee but the device's exact condition is unclear, you can set the status to "Unknown" and record the employee's information in the notes section instead. |
| Please enter a User ID or Employee Email Address / Please enter a Start Date | If the status is "In Use", entering a "User ID" or "Employee Email Address", as well as a "Start Date", is required. If you do not know the exact start date, you can enter a temporary date (which can be modified later). |
| There are duplicate rows in the Asset Number column |
Please check if there are duplicate asset numbers within the uploaded file. If it is difficult to assign new numbers immediately, we recommend temporarily adding sub-numbers. Example: If "PC-001" is duplicated, change them to "PC-001-1" and "PC-001-2". |
| To change status to "In Stock", please unassign the active user from the UI | Currently, in Josys, you cannot change a device's status from "In Use" to "In Stock" via CSV upload. Please go to the details page of the relevant IT device, select "Current User" > "Unassign" > "In Stock", and then upload the CSV. |
| The End Date contains a value. To unassign an active user, please perform the operation from the UI | Currently, in Josys, if a value is entered in the "End Date", the device is determined to be in "In Stock", "Disposed/Cancelled", or "Unknown" status. It is also determined as "In Use" if a value is entered in "User ID" or "Employee Email Address". To set an "End Date", please go to the relevant IT device page, select "Current User" > "Unassign" > "In Stock". |
| Historical assignments end date must be on or after the start date | Please ensure that the End Date is on or after the Start Date. If only the End Date is entered, please make sure to also enter the Start Date. |
| XX (Custom Field Name) is required. | If the field is required, please enter the data for the relevant IT device. If it does not need to be required, go to "Home" > "Settings" > "IT Device Custom Fields" > "Edit" and uncheck the required option. |