Strapi Excel Export

Discord Q&A strapi-questions
1

Hi! I have an issue with Excel Export plugin. Steps what I done:

  1. Install plugin from Excel Export | Strapi Market
  2. Create file config/excel.js
  3. Add to this file content:
    module.exports = {
    config: {
    “api::testowo.testowo”: {
    columns: [
    “datetime”,
    “recipeName”,
    “isPositive”,
    “comment”,
    “userIngredients”
    ],
    locale: “true”
    },
    },
    };

And this is my schema:
{
“kind”: “collectionType”,
“collectionName”: “testowos”,
“info”: {
“singularName”: “testowo”,
“pluralName”: “testowos”,
“displayName”: “testowo”,
“description”: “”
},
“options”: {
“draftAndPublish”: true
},
“pluginOptions”: {
“i18n”: {
“localized”: true
}
},
“attributes”: {
“datetime”: {
“pluginOptions”: {
“i18n”: {
“localized”: true
}
},
“type”: “datetime”
},
“recipeName”: {
“pluginOptions”: {
“i18n”: {
“localized”: true
}
},
“type”: “string”
},
“isPositive”: {
“pluginOptions”: {
“i18n”: {
“localized”: true
}
},
“type”: “boolean”,
“default”: true
},
“comment”: {
“pluginOptions”: {
“i18n”: {
“localized”: true
}
},
“type”: “richtext”
},
“userIngredients”: {
“pluginOptions”: {
“i18n”: {
“localized”: true
}
},
“type”: “text”
}
}
}

  1. Add some records to collection type ‘testowo’

  2. Trying export data from collection type and get console error after choose collection type in excel export:
    “Cannot convert undefined or null to object
    TypeError: Cannot convert undefined or null to object”

My TS knowledge is bad so please be easy with me.

Thank you for any help

This topic has been created from a Discord post (1244917530733051966) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord

2

you prolly want to write issue on thier github

3

It’s their plugin. Ok my bad. Thank you

4

alos you mention TS

5

but this is a JS syntax:

module.exports = {
  config: {
    "api::testowo.testowo": {
      columns: [
        "datetime",
        "recipeName",
        "isPositive",
        "comment",
        "userIngredients"
      ],
      locale: "true"
    },
  },
};
6

if your ptoject is TS you need something like:
excel.ts

export {config: {
    "api::testowo.testowo": {
      columns: [
        "datetime",
        "recipeName",
        "isPositive",
        "comment",
        "userIngredients"
      ],
      locale: "true"
    },
  },
}
7

I fix this