Skip to content
Evolphin Documentation
Evolphin Documentation
  • Home
  • Contact

Search

Categories

  • Administration
    • AI
      • AI FAQs
    • Analytics & Reporting
    • Archive
      • Archive Hub FAQ
      • Client-Hub
    • Auto Checkout (ACO)
    • Auto Retirement
    • Client Logs
    • Configuration
      • database
    • Curator Server
      • Curator FAQ
    • EZ
      • EZ FAQ
      • EZ Installation
    • General FAQ
    • HADR
    • Hot Folder
      • Hot Folder Administration
      • Hot Folder FAQ
    • Hub
      • Hub FAQ
    • Indexer
    • LDAP
    • License FAQ
    • Metadata
      • Metadata FAQ
    • OS Issues
    • OS Plugins
    • Ping FAQ
    • Preview Server
      • Zoom Preview Server FAQ
    • Security
      • OpenID Connect
        • OpenID FAQ
    • Server Logs
    • SSL
    • Web Management Console FAQ
    • Workflow
    • Zoom Server
      • Zoom Server FAQ
    • Zoom VideoFX
      • VideoFX FAQ
    • Zoom VideoLX
  • API and Scripting
  • Deployment
    • Data Migration
    • Guides
    • Install/Upgrade FAQ
    • Perl SDK
    • Pre-Deployment
    • Server Installation and Upgrade
    • Zoom Client Installation and Upgrade
    • Zoom Plugin Installation
  • Docs
  • Release Notes
    • Features and Enhancements
    • Patches
  • Search
  • Uncategorized
  • Using Zoom
    • Adobe Plugin
      • Adobe Plugins FAQ
    • Asset Browser
      • Asset Browser FAQ
      • Metadata in Asset Browser
    • Asset Linking FAQ
    • Check-in FAQ
    • Cinema 4D plugin
      • Cinema4D Plugin FAQ
    • Collaboration
      • Video Editing
    • Collections FAQ
    • Desktop Apps
      • Desktop Apps FAQ
    • Versioning FAQ
    • Web Apps
      • Web Apps FAQ
    • Zoom Client
      • Zoom Client FAQ
      • Zoom Desktop
  • Home
  • Administration
  • General FAQ
  • UTF-8 BOM and Line Endings FAQ

UTF-8 BOM and Line Endings FAQ

By Akila / February 20, 2023 February 20, 2023

The CSV can use UNIX style line endings, ‘\n’ (newline or LF) or Windows style line endings, ‘\r\n’ (CRLF). If you are using Microsoft Excel to export the CSV please avoid saving as CSV UTF-8 as that adds the UTF-8 BOM.

Avoid UTF-8 CSV
Use CSV or MS-DOS CSV format instead

In case you need to test BOM and the line endings on a shell, use a tool like od for e.g. on MacOS Terminal app:

$ od -c zm-metadata.csv
File with a UTF-8 BOM as the beginning of the file
File without a UTF-8 BOM at the beginning of the file

Alternatively, you can open the sample file in Windows Notepad++ and check the right bottom corner where the file’s encoding is highlighted.

Typically, for all Zoom operations involving inputting data you will need to provide a file without UTF-8 BOM. Therefore save the files with the encoding option of “UTF-8” as oppposed to “UTF-8 BOM”.

To remove the BOM from the first line of a file you can use something like:

 $ sed -e '1 s/^.//' md.csv > clean-md.csv

Post navigation
← Previous Post
Next Post →
  • Home
  • Contact
  • Submit a Ticket
  • Solutions
  • Technology
  • Resources
  • Company
  • Privacy Policy
  • Software EULA
Copyright © 2023 Evolphin Software, Inc