Display Accented Characters in TrueContext-Generated CSV Files

Contents

About

Special characters in TrueContext-generated CSV files might display incorrectly when opened in Microsoft Excel. Excel does not recognize UTF-8 encoded CSVs and may consequently display them with the wrong encoding. For example, "Stéphane" may display as "Stéphane"). To ensure data with special characters is imported properly into Excel, the UTF-8 Encoded file option under Data & Analytics > Submissions (by Form) in the Web Portal must be cleared.

Remove UTF-8 encoding for manual exports

  1. In the TrueContext Web PortalClosed The TrueContext Web Portal is a web application used to manage security settings, forms, FormSpaces, other users, Data Sources, and Data Destinations., select Data & Analytics > Submissions (by Form).

    The Data & Analytics menu with Submissions (by Form) highlighted.

  2. In View Form Submissions, choose a form from the list, and then select Continue.

    Result: The system displays a list of dispatches and submissions for the selected form from the last 30 days.

  3. Select the CSV icon.

    Form Submissiions list page. The CSV button is selected.

  4. In Select Export Options, verify that the email address for the download link is correct.

  5. In the File Options section, clear the UTF-8 Encoded checkbox.

    "UTF-8 Encoded" checkbox in File Options, currently unchecked.

  6. Select Export.

    Result: The system sends you the file by email.

Remove UTF-8 encoding for scheduled exports

Info:You can remove UTF-8 encoding for data that is exported on a schedule.

Create a schedule and remove UTF-8 encoding

  1. Select Data & Analytics > Submissions (by Form).

    The Data & Analytics menu with Submissions (by Form) highlighted.

  2. Choose a form from the list, and then select Continue.

    Result: The system displays a list of dispatches and submissions for the selected form from the last 30 days.

  3. On the Form Submissions page, select the Create a Schedule icon.

    Form Submissiions list page. The Create a Schedule option is selected.

  4. Navigate to Data Options > File Options, and clear the UTF-8 Encoded checkbox.

    "UTF-8 Encoded" checkbox when creating a new submission schedule, currently unchecked.

  5. Select Create to save changes.

    Result: Accented characters display correctly in the scheduled export.

Update a schedule and remove UTF-8 encoding

  1. Navigate to the existing schedule:

    Data & Analytics > Submissions (by Form) > FormName > Continue.

    Result: The system displays a list of dispatches and submissions for the selected form from the last 30 days.

  2. Select FormName > List Schedules.

    Navigate to the schedule list from the Form Submissions page.

  3. From the list, select the schedule that you want to update.

    Result: The system displays the details page of the selected schedule.

  4. Go to ScheduleName > Update.

    Navigate to the schedule's name dropdown to update its settings.

  5. On the Data Options tab, in the File Options section, clear the UTF-8 Encoded checkbox.

    "UTF-8 Encoded" checkbox when creating a new submission schedule, currently unchecked.

  6. Select Update to save changes.

    Result: Accented characters display correctly in the scheduled export.