> For the complete documentation index, see [llms.txt](https://docs.verifone.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.verifone.com/support-us/verifone-hq/device-management/adding-devices/adding-devices-via-file-import/csv-import-file-reference.md). # CSV import file reference Field reference for the CSV device import file format used in VHQ. ## What is the CSV import format? You can add, modify, or delete one or more devices using .csv files. The device model naming convention must follow the *Verifone Style Guideline*.
Sample Import Device .CSV

Sample Import Device .CSV

## CSV field reference | Tags | Required / Optional | Description | | ----------------- | ------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | REM Version = 1.1 | | Version information of the file. | | REM Bulk Device | | Header information. | | Device operations | Mandatory |

First field of each line should start with an operation tag of ADD, MODIFY, ADD\_MODIFY, or DELETE, indicating the operation to be performed. Each record is processed based on this tag.
• ADD: Adds a device record. If the record already exists, the insert fails and is reported as an error.
• MODIFY: Modifies an existing record. If the record isn't present, no row is modified, and it's reported as an error.
• ADD\_MODIFY: If the device record is present, it's modified; otherwise, a new record is inserted. If either MODIFY or ADD fails, it's reported as an error.
• DELETE: Deletes an existing record.

Note: If an invalid value is specified for this field, or no value is specified, the default is assumed to be ADD. The value is not case-sensitive, so ADD is the same as Add. If no value is specified and it's followed by a comma, the value is assumed to be ADD.

| | Serial Number | Mandatory | Serial number of the device being created or modified. Maximum length 255 characters. The actual device serial number is in the nnn-nnn-nnn format; the import tool does not validate this format. | | Hierarchy | Optional |

Complete path to the hierarchy from the root node, indicating where the device should be located. The path uses ">>" as the separator.
Example: MyCompany>>MyRegion>>MyState>>MyCity>>MyStore. If the operation is ADD, ADD\_MODIFY, or MODIFY, a value must be specified, or VHQ will place the device at the root node.

| | Model Name | Mandatory | Indicates the device model. | | Group | Optional | Associates a device to an already existing group in VHQ. A group is a collection of terminals not categorized by a hierarchy level — terminals in a group can be within a hierarchy or across hierarchies, such as a group of stores based on common attributes. | | Device ID | Optional | Device or terminal identifier used to reference the device — not the internal unique device identifier. | ## Device import results for .CSV file The device import result file returns the results or status of the imported devices. ## Related topics * [Adding devices via file import](/support-us/verifone-hq/device-management/adding-devices/adding-devices-via-file-import.md) * [XML import file reference](/support-us/verifone-hq/device-management/adding-devices/adding-devices-via-file-import/xml-import-file-reference.md) * [Device import error codes](/support-us/verifone-hq/device-management/adding-devices/adding-devices-via-file-import/device-import-error-codes.md) --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.verifone.com/support-us/verifone-hq/device-management/adding-devices/adding-devices-via-file-import/csv-import-file-reference.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.