Bring the devices, accessories and employees you already have into Factorial IT, either by asking ONE or by uploading a CSV file. Use it when you start out, or whenever you need to track hardware that is not enrolled.
Feature/Functionality
Overview
Once a device is enrolled, it shows up in Equipment > Devices on its own and is assigned to its employee. Importing covers everything else: devices that are not enrolled yet, and accessories such as monitors or keyboards.
There are two ways to import:
- With ONE: attach your inventory file and ask ONE to create the items.
- With a CSV file: upload a file for devices, employees or accessories.
How to use: import with ONE
- Open ONE. You can reach it from any page of the console.
- Attach your inventory as a spreadsheet or CSV, for example an export from the tool you used before.
- Tell ONE what to do. For example: Import the devices in this file and assign each one to the employee in the email column.
- ONE creates each device or accessory and asks you to approve before it saves anything. A device is assigned only when the file includes the employee's work email.
- Check the new items in Equipment > Devices and Equipment > Accessories.
You need permission to create equipment. ONE adds items one at a time, so go through the list it reports before you confirm a big import.
How to use: import devices from a CSV file
- Go to Equipment > Devices and click Add a device.
- Choose Import from CSV. You can download a template from the import window.
- Upload your file and map its columns.
- Confirm the import.
The import runs in the background. When it finishes, you get a notification that explains why any row was skipped.
| Column | Format |
|---|---|
| Work email | Assigns the device to the existing employee with this email. If empty, the device goes to stock |
| Device name | Uses the serial number when empty |
| Serial number | If the serial number already exists, no new device is created: only the purchase date, decommissioning date and price are updated |
| Device type |
LAPTOP, DESKTOP, TABLET or SMARTPHONE
|
| Platform |
MACOS, WINDOWS, LINUX, IOS, IPADOS, ANDROID or CHROME_OS. Worked out from the brand and type when empty |
Brand, model, year, screen size, keyboard layout, notes
|
Optional |
| Purchase date, decommissioning date |
YYYY-MM-DD or DD/MM/YYYY
|
| Purchase price | Optional |
Every row must have at least one of these: serial number, device name, model or platform.
How to use: import employees from a CSV file
Use this when you do not sync an HR system, or for people your HR system leaves out.
- Go to Settings > HR System > Import from CSV.
- Download the template from the window and add one row per person.
- Click Upload your CSV file.
First name, Last name and Work email are mandatory. Everything else is optional: personal email, phone, team, job, manager, work location, legal entity, start date and termination date.
Employees added this way are not synced. You keep their data up to date yourself, start and termination dates included. If you connect an HR system later, its first sync replaces the fields it manages.
How to use: import accessories from a CSV file
- Go to Equipment > Accessories and click Import from CSV.
- Upload your file. Mandatory columns: name and type (for example
MONITOR,KEYBOARD,MOUSEorOTHER). Optional: brand, model, serial number, tags (separated by commas), description and condition (NEW,GOOD,DAMAGEDorUNUSABLE). - Check Preview accessories import and click Apply import. The preview tells you, row by row, whether it will create an accessory, update one you already have, or reject the row. An existing accessory is recognised by its serial number, or by the combination of name, type, brand and model.
After the import
- Make sure each device is assigned to the right employee.
- Fill in any missing details from the item's page.
- Enrol the devices so you can manage them and their inventory stays current without manual work.
Tips and Best Practices
- Include the work email. Without it, devices land in stock instead of with their employee.
- Fill in serial numbers. They stop duplicates: a known serial number updates the device instead of creating a second one.
- Start from the template. Download it from the import window so the columns match first time.
- Review before you confirm with ONE. It imports item by item, so read its list on large files.
- Enrol as soon as you can. Imported devices are only records until they are enrolled.
Troubleshooting and FAQ
Troubleshooting
- Some rows were not imported. Read the notification you get at the end of the import. It gives the reason for each skipped row. Check that each row has at least a serial number, device name, model or platform.
- A device went to stock instead of to an employee. The work email was missing or did not match an existing employee.
- A device was not created a second time. Its serial number already exists. Only its purchase date, decommissioning date and price were updated.
- Imported employee data was overwritten. You connected an HR system, and its first sync replaced the fields it syncs.
FAQ
-
Do I need to import devices that are already enrolled?
No. Enrolled devices appear in Equipment > Devices automatically and are assigned to their employee.
-
Which date formats can I use?
YYYY-MM-DDorDD/MM/YYYY.
-
Are imported employees kept in sync?
No. You update them yourself, unless you later connect an HR system.
-
How does the accessory import spot an existing accessory?
By serial number, or by name, type, brand and model together.