Why doesn't my Klip display any data?

Problem:

You can't figure out why the Klip is not displaying data the way you think it should, even though it seems to contain no errors.

Solution:

If your Klip doesn't include any scripting, it could be something as simple as a missing semicolon in the <style> block.

If it does include JavaScript, you can use the traceln() function to see if any of your script is returning unexpected values. Some APIs, such as the Salesforce and ODBC Engines, also provide methods to output errors specific to them.

Here is a list of tips for debugging your Klip:

• A good troubleshooting strategy is simplifying the stylesheet. Try removing columns/styles until you find the one causing the problem.

• For troubleshooting in a drilldown Klip, it helps to set <autodrilldown> to false to see all the items in the Klip.

• Is your Klip dim? Then it means that the data can't be accessed. Try copying and pasting the content of <contentsource> into the browser. Are you able to access it? If not, check for typos. If your machine can't access the data, neither can your Klip.

• Is your Klip active but says "No Data"? It could mean that the Klip got the data but doesn't know how to display it, possibly due to any of the following:

• Are you missing any semicolons (;) after each set of "property: value;" in your <style> block? You shouldn't be.

• Did you close all XML tags? You should.

• Did you check to make sure all style definitions are opened and closed with curly brackets? They look like this: { }.

• Do you have any unfinished style definitions? For example, you should not do this:

areaCode {
    itemcol: 1;
    noterow
}

• Do you have a selector defined with type: item;? Without it, Klipfolio Dashboard cannot know what tag contains a block of item data. If the data source is CSV, TSV, or Excel worksheet, use row for type: item like this:

row {
    type: item;
    definition: all;
}

• Is your data source CSV? Don't forget to add @parse csv; right under <style>.

<style>
    @parse csv;
    row {
        type: item;
        definition: all;
        }
    ...

And make sure you replace any spaces in the tag with an underscore (_). For example, if the header for a column is "Sales Rep", do this:

Sales_Rep {
    ...

• Do all your CSS selectors match the capitalization used in the content source? For example, if the source has <zipCode>10451</zipCode>, your selector should look like this, with a capital C:

zipCode {
    ...
}

• Are you using klipscript to create and set data for a column? Make sure you use definition: all; with type: item to make sure all style definitions in the <style> block get their space reserved for them, regardless of where their data comes from.

• Is your Klip using an Excel worksheet as its content source? Check out the Excel Klip troubleshooting article.

• Is your Klip using our ODBC Engine? Make sure that you are following the steps described in the ODBC Klip article.

• Are you using CSS properties in your <style> block that require quotation marks for their values, such as for name, label, asset and format? Be sure to close the quotation marks and not do this:

estimate {
    label: "Estimate;
}

• Are you using multiple format values? If so, don't insert spaces between the values. Do this:

format: "percent,decimal(2)";

Not this:

format: "percent, decimal( 2 )";

• If you are seeing fewer items than expected, there may be a problem with the way keys are defined. See this how-to article to define it properly.