CSV File Format
- The following is the CSV file format used to bulk import IT devices into the Josys IT devices page.
Preventing Errors During Upload
-
Are all required fields completed?
Please check if the following required fields are entered correctly:-
Asset Number → Is a unique number assigned?
- If there is no asset number, assign one using a combination of the device type and a sequential number.
-
Asset Number → Is a unique number assigned?
-
Status → Is it set to one of the following:
In Stock,In Use,Unknown, orDisposed/Cancelled?- If you want to manage statuses in more detail, please use Custom Fields.
- Are the Custom Fields set as "Required" completed?
- If they do not apply to all assets, please uncheck "Required."
-
When the status is
In Use, please also check the following fields:-
User ID / Employee Email Address → Is it linked to a User ID?
- If the user is not unique, assign an administrator or responsible person.
-
User ID / Employee Email Address → Is it linked to a User ID?
-
Start Date → Is it entered in the format YYYY-MM-DD or YYYY/MM/DD?
- If the start date is unknown, enter a temporary date such as the registration date in Josys.
-
Is the data appropriate for the input type of the Custom Fields?
The input types for Custom Fields include Text, Number, Dropdown, Date, and Amount.Please verify that each field matches its input type before uploading.
To resolve errors that occur during upload, please refer to this error guide.
1. Device Registration
☝ Please use this file for reference.
IT Devices CSV Default Fields List
| Field Name | Required | Example | Description |
|---|---|---|---|
| Asset Number | Required | Mac-107 | The identifier assigned to the asset within the company. ・Must be unique within the company. ・If an existing record has the same number, it will be overwritten. |
| Status | Required | In Use | The current status of the device. 【Allowed Values】 In Stock|In Use |Unknown| Disposed/Cancelled
|
| Device Type | Optional | PC | The type of device. |
| Manufacturer | Optional | Apple | The name of the manufacturer. |
| Device Models | Optional | MV962LL/A | The model number of the device. ・If an existing model number is specified, the master model data will be overwritten. ・If the model number is unknown, you can register and use a unique string for the device model. |
| Device Name | Optional | MacBookPro-13(JIS) | The display name of the device. |
| OS | Optional | mac OS 11.5.2 | The OS of the device. |
| Serial Number | Optional | C02X646JHD2X | The unique serial number of the device. |
| Procurement Method | Optional | Purchased | The procurement method of the device. |
| Procurement Date | Optional | 2019/10/01 | ・The date ownership of the device began. Enter the purchase date or the date storage started at the office. ・Enter in the format YYYY-MM-DD or YYYY/MM/DD. |
| Disposal/Cancellation Date | Optional | 2021/03/01 | ・The date ownership of the device ended. If the procurement method is purchase, enter the disposal date; if leased, enter the return date. ・Enter in the format YYYY-MM-DD or YYYY/MM/DD. |
| Memo | Optional | Spare PC MacBook Pro 13-inch JIS Assigned as a spare | Notes related to this asset. ・Can also be used for management items such as rental numbers. |
| User ID | Required if "In Use" * | 00004 | The User ID of the employee currently assigned the device. ・Treated as a text string. If there are leading zeros, enter an apostrophe ( ' ) in spreadsheet software to prevent the zeros from being omitted. * If the device status is In Use, either User ID or Employee Email Address is required.
|
| Employee Email Address | Required if "In Use" * | i.tanaka@example.com | The email address of the employee currently assigned the device. You can use the email address to link the device to the employee. * If the device status is In Use, either User ID or Employee Email Address is required.
|
| Start Date | Required if "In Use" * | 2019/12/11 | ・The date the assignment to the user (employee) started. ・Enter in the format YYYY-MM-DD or YYYY/MM/DD. * Required if the device status is In Use.
|
| End Date | Optional | 2020/03/01 | ・The date the assignment to the user (employee) ended. ・Enter in the format YYYY-MM-DD or YYYY/MM/DD. |
2. Registering Past Users
CSV Sample File
☝ Please use this file for reference.
IT Devices - Past Users CSV Fields List
| Field Name | Required | Example | Description |
|---|---|---|---|
| Asset Number | Required | Mac-107 | The identifier assigned to the asset within the company. ・Must be unique within the company. ・If an existing record has the same number, it will be overwritten. |
| User ID | Required * | 00004 | The User ID of the employee currently assigned the device. ・Treated as a text string. If there are leading zeros, enter an apostrophe ( ' ) in spreadsheet software to prevent the zeros from being omitted. * Either User ID or Employee Email Address is required.
|
| Employee Email Address | Required * | i.tanaka@example.com | The email address of the employee currently assigned the device. You can use the email address to link the device to the employee. * Either User ID or Employee Email Address is required.
|
| Start Date | Required | 2019/12/11 | ・The date the assignment to the user (employee) started. ・Enter in the format YYYY-MM-DD or YYYY/MM/DD. |
| End Date | Required | 2020/03/01 | ・The date the assignment to the user (employee) ended. ・Enter in the format YYYY-MM-DD or YYYY/MM/DD. |