Apptio for All

Apptio for All

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

Β View Only
  • 1.  Weird Import Error Occurring...

    Posted Sat April 23, 2022 12:19 PM
    Edited by System Admin Tue November 05, 2024 05:57 PM


    So I copy the data from a sheet (values only), save as CSV and load it, but inevitably, I get this weird import error πŸ‘‡.  Anyone see anything like this before? 

    When I do a search on Google (after putting it in quotes), I see this in the results: Excel [Content_Types].xml file generated by C# OpenXML

    This is after I copy/paste values only, though.  How can I copy/paste the data and not run into this mess? πŸ˜•πŸ€·β€β™€οΈ


    //schemas.openxmlformats.org/package/2006/content-types"><Default Extension="bin" ContentType="application/vnd.ms-excel.sheet.binary.macroEnabled.main"/><Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/><Default Extension="xml" ContentType="application/xml"/><Override PartName="/xl/worksheets/sheet1.bin" ContentType="application/vnd.ms-excel.worksheet"/><Override PartName="/xl/worksheets/binaryIndex1.bin" ContentType="application/vnd.ms-excel.binIndexWs"/><Override PartName="/xl/worksheets/sheet2.bin" ContentType="application/vnd.ms-excel.worksheet"/><Override PartName="/xl/worksheets/binaryIndex2.bin" ContentType="application/vnd.ms-excel.binIndexWs"/><Override PartName="/xl/externalLinks/externalLink1.bin" ContentType="application/vnd.ms-excel.externalLink"/><Override PartName="/xl/externalLinks/externalLink2.bin" ContentType="application/vnd.ms-excel.externalLink"/><Override PartName="/xl/externalLinks/externalLink3.bin" ContentType="application/vnd.ms-excel.externalLink"/><Override PartName="/xl/theme/theme1.xml" ContentType="application/vnd.openxmlformats-officedocument.theme+xml"/><Override PartName="/xl/connections.bin" ContentType="application/vnd.ms-excel.connections"/><Override PartName="/xl/styles.bin" ContentType="application/vnd.ms-excel.styles"/><Override PartName="/xl/sharedStrings.bin" ContentType="application/vnd.ms-excel.sharedStrings"/><Override PartName="/xl/printerSettings/printerSettings1.bin" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.printerSettings"/><Override PartName="/xl/tables/table1.bin" ContentType="application/vnd.ms-excel.table"/><Override PartName="/xl/queryTables/queryTable1.bin" ContentType="application/vnd.ms-excel.queryTable"/><Override PartName="/xl/printerSettings/printerSettings2.bin" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.printerSettings"/><Override PartName="/xl/tables/table2.bin" ContentType="application/vnd.ms-excel.table"/><Override PartName="/xl/queryTables/queryTable2.bin" ContentType="application/vnd.ms-excel.queryTable"/><Override PartName="/customXml/itemProps1.xml" ContentType="application/vnd.openxmlformats-officedocument.customXmlProperties+xml"/><Override PartName="/customXml/itemProps2.xml" ContentType="application/vnd.openxmlformats-officedocument.customXmlProperties+xml"/><Override PartName="/customXml/itemProps3.xml" ContentType="application/vnd.openxmlformats-officedocument.customXmlProperties+xml"/><Override PartName="/customXml/itemProps4.xml" ContentType="application/vnd.openxmlformats-officedocument.customXmlProperties+xml"/><Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml"/><Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml"/><Override PartName="/docProps/custom.xml" ContentType="application/vnd.openxmlformats-officedocument.custom-properties+xml"/></Types>


    #ApptioforAll


  • 2.  RE: Weird Import Error Occurring...

    Posted Mon April 25, 2022 08:02 AM
    My instinct is that something table format wise is coming over when you copy and paste. I would try opening another instance of excel, copy the values from one workbook and then Paste Special Values Only(Home > Paste > Paste Special) , then save as a csv to see if you are getting the same error. Good Luck!


  • 3.  RE: Weird Import Error Occurring...

    Posted Mon April 25, 2022 09:29 AM
    Bummer - that's what I did previously and still got that rubbish ... have even tried a copy of a copy 😭😭😭


  • 4.  RE: Weird Import Error Occurring...

    Posted Mon April 25, 2022 01:31 PM
    That's a good point.  I know sometimes when you copy it'll contain a special character or hidden formatting that causes an issue.  I usually use Notepad to see if I picked up any extra or odd characters, it resets to plaintext, and then I paste into Apptio.

    ------------------------------
    Justin Kean
    Apptio
    Sr Instructor
    ------------------------------



  • 5.  RE: Weird Import Error Occurring...

    Posted Mon April 25, 2022 03:24 PM
    Ahh, will give that a whirl, too, thanks y'all! πŸ™Œ