This document tells you how prepare a CSV file for mass import into maiLink – it’s the quickest way to add a batch of new devices.
Note: The syntax of the CSV file matters, so please follow this guidance carefully.
Note: Once your CSV file is ready, contact support@maidata.io for help. Our team will upload the file for you. We offer this service as a protection for all our customers to prevent accidental SQL injection issues.
Creating a CSV File
Most users will create an Excel file containing the required data and then simply export it into a CSV file. The Excel file will be created by exporting data from some sort of asset manager, CRM system, or other database. Once the data is in Excel, it will be manipulated to meet the CSV Requirements below.
If you think your CSV file is ready, contact support@maidata.io.
CSV Requirements
The CSV file you create should have the following:
- Values seperated by commas (',').
- Any values containing commas enclosed in double quotes ('"').
- One header row.
- Any number of additional rows, where each row corresponds to one unique device.
- The following column headers in row 1:
| Column | Heading | Cell Meaning |
|---|---|---|
| A | Device ID | A unique identifier for the device on this row. Should be globally unique within your organization. Often a serial number. |
| B | Device Name | A friendly name for this device. |
| C | Model | The type of device. Often the manufacturer’s name for the model. |
| D | Address | The address at which the devices in installed. Should include street address, city, state/province, postal/zip code, country. It is not necessary to put commas in between sections of the address. So, you can have 1 Able Street Missisauga ON Canada rather than 1 Able Street, Missisauga, ON, Canada. |
| E | Device Tag 1 Key | The value of a device tag that will be filled with the text given in column E for the device of a given row. |
| F | Device Tag 2 Key | The value of a device tag that will be filled with the text given in column F for the device of a given row. |
| G | Device Tag 3 Key | The value of a device tag that will be filled with the text given in column G for the device of a given row. |
| zz | Device Tag xx Key | The value of a device tag that will be filled with the text given in column zz for the device of a given row. |