IBM Apptio

Apptio

A place for Apptio product users to learn, connect, share and grow together.


#Aspera
#Apptio
#Automation
#FinOps
#Apptio
#ITAutomation
 View Only
  • 1.  "?" Symbols in my data

    Posted 03/20/15 07:31 PM

    I've loaded some data into apptio and i am seeing a question mark symbol in a black diamond appear in my data set. Has anyone run into this before? If so, what causes this and how do I fix this?






    #Platform
    #CostingStandard(CT-Foundation)


  • 2.  Re: "?" Symbols in my data
    Best Answer

    Posted 03/21/15 10:47 PM

    Andrew, one thing that can cause this is if you upload foreign characters such as ñ or ü without first converting the CSV to UTF-8 formatting.

     

    To do this, open the CSV in a text editor such as Notepad++, and use the encoding feature to convert to UTF-8, then re-upload.


    #CostingStandard(CT-Foundation)


  • 3.  Re: "?" Symbols in my data

    Posted 03/23/15 07:00 PM

    Great answer Mark, I'd also like to point out if I may, that one can also just use NotePad, on Windows, if IT has strict rules around application installations.


    #CostingStandard(CT-Foundation)


  • 4.  Re: "?" Symbols in my data

    Posted 03/24/15 02:18 PM

    Adding another note here, the file can also be saved as "Unicode Text" directly in Excel, and the format will upload properly into Apptio:

     

    CSV Example of Test Strings:

    2015-03-24 11_11_55-Apptio - (mverkruyse.apptio.com) Reference CTF -.png

     

    Unicode Text Example of Test Strings:

    2015-03-24 11_12_25-Apptio - (mverkruyse.apptio.com) Reference CTF -.png


    #CostingStandard(CT-Foundation)