CSV Import Guide

---

This guide explains how to use the CSV import features in WebAccess/DMP to claim or update devices in bulk. It covers supported formats, required columns, Excel compatibility, and ready-to-use CSV templates.

Example CSV Files

Use the following templates to prepare your CSV files:

• Claim CSV Template
• Update CSV Template

Each file contains the correct headers and sample data to help you get started.

Claiming Devices via CSV

To import new devices into the system, use the Claim CSV format.

TIP

You can also copy a pre-filled CSV template for your specific company directly in the WebAccess/DMP interface. This ensures the correct CompanyId and column formatting.

Required Columns

Column	Required	Description
Name	Yes	User-friendly name for the device.
Serial	Yes	Serial number of the device (e.g. ACZ1100001234567).
MacAddress	Yes	MAC address used to uniquely identify the device.
Imei	No	Optional IMEI number (can be left empty).
CompanyId	Yes	ID of the company to which the device should be assigned.

Notes

• All devices in the CSV must belong to the same company.
• Support for the WebAccess/DMP platform is limited for the S1 Router models.
• Devices must not already be claimed.
• The CSV must use a semicolon (;) as the separator.
• Save the file using UTF-8 encoding.
• Any errors during import are shown in the UI.

Updating Devices via CSV

Use the Update CSV format to modify the settings or metadata of existing devices.

Recommended flow

1. On the device dashboard, either create the fields you want to update using Add Field, or make existing fields visible using the settings sidebar (eye icon).
2. Click Export CSV, make your changes, and import the file back. This ensures correct column names and minimizes errors.

Required Columns

Column	Required	Description
MacAddress	Yes	Unique identifier for the device.

Optional Columns (examples)

Column	Required	Description
ConfigProfile	No	Name of the configuration profile to assign to the device.
Name	No	Friendly name of the device.
settings_ETH_IPADDR_v	No	IP address to assign to the device (overrides the profile value if set).
Description	No	Custom description shown in the dashboard.

Example from an Exported Update CSV

MacAddress	Name	settings_ETH_IPADDR_v	Description
00:11:22:33:44:55	Router A	192.168.1.1	Office Gateway
00:11:22:33:44:56	Router B	192.168.1.2	Backup Router Warehouse

Notes

• Leave optional values blank to keep the current device values.
• The MacAddress must always be present and valid.
• Field names such as settings_ETH_IPADDR_v must exactly match those generated in the exported CSV.
• If a field does not exist yet but the setting ID is correct, WebAccess/DMP creates the field automatically.
• If the device does not support the setting (e.g. Wi-Fi on a non-Wi-Fi model), the update is ignored.

Opening CSV Files in Excel

Due to regional settings, Excel may misinterpret the semicolon (;) delimiter.

Recommended Way to Import

1. Open Excel.
2. Go to File → Open and select your .csv file.
3. In the import wizard:
   • Choose Delimited.
   • Select Semicolon (;) as the separator.
   • Check that the preview shows the correct column separation.
4. Click Finish.

TIP

In newer versions of Excel, you can also import via Data → From Text/CSV for better control.

Import Behavior

• Each row is validated individually.
• Errors are reported with line numbers and reasons.
• Valid rows are processed; invalid ones are skipped.
• Use the dashboard export to generate the correct format and avoid guesswork.

Best Practices

• Always save as UTF-8 CSV with semicolon separators.
• Avoid Excel features such as formulas, merged cells, or formatting.
• Double-check column headers — they are case-sensitive.
• Keep a backup copy of your original file.

Troubleshooting

• Device not updated? Check for typos in the column names.
• Import failed? Make sure MacAddress and other required fields are present.
• All values in one column? Re-import with the correct delimiter selected.

For further assistance, see the Device Configuration and Add a Device pages, or contact support at wadmp@advantech.com.