Allowing Special Characters

We have students with names that include an accent.  We currently cannot note this in our system.  

  • Guest
  • Jan 13 2016
  • Under consideration
  • Attach files
  • Neil MacDonald commented
    3 Oct 02:14pm

    Yes, I have a family that just started that have č and ū in their last names. We've been able to support all the families with accent letters until now.

  • Marita Gonsalves commented
    8 Nov, 2022 03:47pm

    I concur with Jim Robb "With an ever widening diverse population, we as schools need to respect the cultures and languages of the customer."

  • Linda Lutes commented
    27 Oct, 2022 05:47pm

    We have been copying and pasting accented names from emails into student records. However, our students from Vietnam that have an ồ in their name turns into a ? question mark.

  • Andrew Teets commented
    4 Mar, 2022 04:38pm

    +1 on allowing different file formats on imports - mac based shop here TY!!

  • Kirstin McDonald commented
    15 Feb, 2022 10:57pm

    Rather then starting another idea, I would like to piggy-back on this one. When a new family is accepted and an account is created in Tuition Manager, the transfer of data should include the correct accent, tilda and umlaut characters. TM does not even support the copy and paste functionality that Core has.

  • Oona McKnight commented
    24 Jan, 2022 10:16pm

    We would like to be able to use accents everywhere - in assignment titles, as well. Currently if our French teacher types "passé" it shows up as "pass&#233".

  • Troy Yochelson commented
    4 Aug, 2021 11:13pm

    Since I spent over an hour with Blackbaud Support working out an import failure, I thought I'd share a workaround to Blackbaud's import failures when accents are involved. I've also noted this on https://blackbaudk12.ideas.aha.io/ideas/K12CO-I-284.


    Blackbaud's undocumented encoding (both for import and export) is ISO-8859-1; Windows' ANSI encoding is an offshoot of ISO-8859-1, and the encoding is known by other names as well.


    Note that Google Sheets (at least on a Mac) defaults to UTF-8 encoding, so an export from Google Sheets will need to have its encoding changed to ISO-8859-1.


    IMPORT TO BLACKBAUD

    From Windows:

    1. Open your CSV file in Notepad, which will automatically detect the correct encoding, unlike Excel);

    2. Select "File > Save as..."

    3. At the bottom, where the "Encoding" drop down is, select "ANSI" (this is Microsoft's ISO-8859-1, and seems close enough to be usable)

    4. Either save over the existing file or enter a new name, make sure your File Type is "All Files", include your .CSV extension and save it as a new file

    5. Upload to Blackbaud for import (and hope they haven't changed the format or messed it up in a novel fashion)

    From macOS:

    1. Open Terminal

    2. Run the following command:
      iconv -t ISO-8859-1 {your CSV filename and path} > {new CSV filename and path}

    3. Upload to Blackbaud for import (and hope they haven't changed the format or messed it up in a novel fashion)


    EXPORT FROM BLACKBAUD

    On a Windows system, you shouldn't have to do anything; Blackbaud's standard encoding should work just fine.


    If you want to import into Google Sheets, Blackbaud's standard encoding also works...because Google Sheets checks the encoding of the file before importing it.


    On a macOS system, Numbers will also auto-detect the encoding properly.


    With Excel for Mac:

    1. Open an empty spreadsheet file

    2. Select "File > Import"

    3. Select "CSV", then click "Import"

    4. Locate and double-click the Blackbaud export file

    5. At "Text Import Wizard - Step 1 of 3", select "File origin: Windows (ANSI), then click Next
      NOTE: Western (ISO Latin 1) or Western (Windows Latin 1) will also work; however, "Macintosh" will NOT...and of course it can't auto-detect.

    6. At "Text Import Wizard - Step 2 of 3", select "Delimiters: Comma and click Finish OR click Next and make any additional changes in "Text Import Wizard - Step 3 of 3", then click Finish


    With Terminal:

    1. Open Terminal

    2. Run the following command:
      iconv -t UTF-8 {blackbaud's CSV filename and path} > {UTF-8 CSV filename and path}

    3. Profit!


    Credit to Stack Exchange, which provided many many clues to lead me to this solution.

  • Matthew Poirier commented
    15 Jun, 2021 03:14pm

    Additionally, ensuring consistency across the system is important. For instance, we have a kid with a "ñ" in his name. Looking in any SKY list requires the use of the "ñ" but in data imports, you must use "n". The "ñ" should work everywhere.

  • Peggy Volrath commented
    7 Aug, 2018 12:46pm

    Please please please allow us to use special characters!  We have current families that are very upset that these cannot display for them.  They feel that it is against their heritage to have it show without the accent.

  • Jim Robb commented
    11 Oct, 2016 12:37pm

    I agree. With an ever widening diverse population, we as schools need to respect the cultures and languages of the customer.

  • Katherine Lewis commented
    4 Apr, 2016 07:11pm

    I have found that there is a work-around for this.  If you cut and past the name with the special characters from Word (or another document that allows for the special characters) the system will take them and display them correctly.  There are a few instances, however, that they do not appear correctly (for instance when you run a list).

  • Guest commented
    13 Jan, 2016 06:04pm

    An additional comment about  "special characters" - There are many accents in family names that are not "special characters" any more than the apostrophe is in O'Keefe or O'Reilly.  It is an integral part of the name.  And in an increasingly diverse world and at  schools with international students, it is important that names be spelled correctly.