Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

UTF-8 byte order data included on first record when using file



A file listener is configured to fetch a CSV file and create a case for each record in the file.

The CSV file contains the following pattern type: 
Integer String, String, String.

The first case created, displays an error indicating that the integer value from the first record (only the first record) is not an integer. All other records process correctly.
When the value on the UI is replaced with another integer, the application considers it as an integer and continues processing.
When the actual value from the UI is copied and pasted to a tool where the value is converted to HEX, the UTF-8 byte order mark is included. 

For example, integer value: 22.

Error Messages

22 is not an integer value

Steps to Reproduce

  1. Create a simple Microsoft Excel file using the pattern: Integer, Sting, String, String. Do not include a header.
  2. Configure a file listener or service to retrieve the file and process it one record at a time.
  3. Configure the Service File to use UTF-8 encoding.
  4. Configure the Service File request to use a Delimited ParseRule.
  5. Configure the parse rule to map data to the Clipboard.
  6. Configure the Service File request to invoke an activity that creates the work item.

Root Cause

A third-party product issue.
Excel 365 generated CSV files were encoded using the UTF-8-BOM. This is not a supported encoding format for file listeners.


Make the following change to the operating environment:

Ensure that the files which are fetched are encoded using ASCII.

Published April 3, 2019 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us