Standards for Importing a CSV File

The imported comma-separated values (CSV) file must adhere to the following standards.

File Requirements

  • Save the file using UTF-8 encoding to maintain character compatibility.
  • Keep the file formatted as a CSV file, adhering to RFC 4180 standards.
  • You can include comment lines before the header. Begin each comment line with a # symbol. The importer will automatically skip these lines.
  • Use double quotation marks as follows:
    • If a field includes a double quotation mark, represent it as two consecutive double quotation marks ("") within the quoted field.
    • Enclose any field in double quotation marks if it contains a comma, a newline (line break), or a double quotation mark (as per RFC 4180 specifications). For example, to name an AP as: "VIP" Guest AP, you must enter the entire AP name as follows: """VIP"" Guest AP".
    Note: RUCKUS strongly recommends adhering to the RFC 4180 standard for field encapsulation in CSV files. Only the example formatting method is officially supported and guaranteed to work correctly with the importer.

Editing in Microsoft Excel

Before entering or pasting any data, set the format of every column to Text by navigating to Format Cells.. > Number > Text. This step prevents Excel from automatically reformatting long numbers or trimming characters. After editing, save the file as CSV UTF-8 (.csv) to ensure proper encoding.

Editing in Apple Numbers

When exporting your data (File > Export To > CSV...), ensure the following:
  • Do not check the Include table name option. Enabling the option inserts an extra line above the header row, which breaks the expected file format and causes import errors.
  • Set Encoding to Unicode (UTF-8) to ensure proper character formatting.

Rules for Required and Optional CSV Fields

AP Name (Required)
  • AP Name must be unique and cannot be duplicated.
  • Enter between 2 and 32 characters.
  • You may use letters, numbers, spaces, and the following symbols:

    !"#$%'()*+&,-./:;<=>?@[]^_{|}~

  • Do not use ` or the sequence "$(".
  • If the AP Name includes a comma or double quotation marks, apply the RFC 4180 quoting rules described in File Requirements section.
Serial Number (Required)
  • Only digits (0–9) are allowed.
  • Enter exactly 12 digits. The number must not begin with 0.
Description (Optional)
  • Enter up to 180 characters.
  • If the content includes commas or double quotation marks, apply the RFC 4180 quoting rules as described in File Requirements section.
AP Group (Optional)
  • If the specified AP group exists in the venue, RUCKUS One assigns the AP to that group.
  • If the specified AP group does not exist, RUCKUS One creates a new AP group during import, provided the venue has not reached its limit of 511 custom AP groups and one default AP group.
  • If this field is left empty, RUCKUS One assigns the AP to the default AP group.
  • AP group names are case-sensitive.
Tags (Optional)
  • Separate multiple tags using a semicolon (;) — for example: tag1;tag2;tag3.
  • The system ignores blank spaces before or after each tag.
Latitude and Longitude (Optional)
  • Enter a numeric value between -90 and 90, inclusive, for latitude.
  • Enter a numeric value between -180 and 180, inclusive, for longitude.
  • You may include up to six decimal places for precision.
  • Provide both latitude and longitude for each AP to ensure accurate results.
  • Verify that coordinates fall within the country where the venue is registered.
Global Untagged VLAN ID (Optional)
  • The VLAN ID should be between 1 and 4094.
  • This feature applies only to AP models whose default access port is greater than or equal to 2.

Handling Special Characters

  • Enclose the field in double quotes if it contains a comma, newline, or double quote character.
  • To represent a double quote within an encapsulated field, use two consecutive double quotes ("").
  • RUCKUS strongly recommends adhering to the RFC 4180 standard for field encapsulation in CSV files.
  • Only the formatting methods outlined below are officially supported and guaranteed to work correctly with the importer.

    Example: For a name containing double quotes, such as "VIP" Guest AP, format it as: """VIP"" Guest AP".