Removing Strange Characters in Reports
Why am I seeing strange characters in my report?
A "character encoding" is the system a computer uses to interpret and represent different characters. At Attendee Interactive, we receive Abstracts from all over the world. We selected "UTF-8" as our character encoding system, since it knows how to interpret a large range of characters, from scientific and technical symbols, to glyphs of many different languages. By default, Microsoft Excel opens files with Microsoft's own character encoding, which is much more limited than UTF-8. Because of this,there are a number of characters that Microsoft doesn't know how to represent properly. If you open a CSV Report with default settings, any character that Microsoft doesn't know how to read gets spit out as gibberish.
How can I fix them?
When opening CSV Reports, make sure to select UTF-8 when opening the file in Microsoft Excel. Detailed steps are outlined below.
Microsoft Windows:
1. Open Microsoft Excel, and select File > New Workbook.
2. With a blank worksheet open, select File > Import…
3. Select "CSV File".
4. Select the report you downloaded and would like to open.
5. Choose "Delimited", under 'File Origin' choose the option closest to "UTF-8", and click "Next".
6. For Delimiter, select "Comma", and unselect all other checkboxes.
7. Click Finish. Click Ok.
Related Articles
Application Reports
1. Application Status Report: This report has several filters to know the Application status at several stages like completed and/or reviewed and/or approved. Applications > Primary Reports > Application Status Report 2. Application Detail Score w/ ...
Form Reports
PRIMARY FORMS REPORTS: 1. Respondents: Select the form -Responses not Given/Responses Given and the Assigned role. Note: Do not include the Activity/Event filter in this search. This report runs against an Ask Once Form and queries all the people ...
Document Reports
1. Session Documents Report: This report gives you downloadable links to the documents uploaded by Evroles from the Speaker Ready Room; or the documents uploaded under Sessions’ ‘Manage Document’ section by the Admin from the back end. Sessions > ...
Credit Reports
1. Activity Awarded Credit Summary (Activity must be selected): This report gives a list of people and the credits earned by them for the entire Activity People > Credit Reports > Activity Awarded Credit Summary 2. Credits Report: Use this report to ...
People - Speaker Reports - Bio / Photo Reports
The data collected from the My Account > Bio / Photo feature can be pulled using People Reports. OPTION 1: Bio/Photo Report 1. Click the "Reports" option 2. Click the "People" option 3. Open the "Speaker Reports" section 4. Select button beneath ...