* Describe the bug
* Environment
-
NocoBase version: 1.6.28
-
Database type and version: MySQL
-
OS: docker
-
Deployment Methods: docker
-
Docker image version: latest
* How To Reproduce
I upgraded to the new version 1.6.28, and after that upgrade, I couldn’t import from Excel anymore.
It throws an error on line 2, which is the first line with information in Excel. The Excel file I’m using is the one from the spreadsheet the system generates using the Import button.
Expected behavior
Screenshots
Logs
nocobase_dev | {"level":"error","message":"Import failed at row 2","meta":{"err":"ImportError: Import failed at row 2\n at XlsxImporter.performImport (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/services/xlsx-importer.js:197:17)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async XlsxImporter.run (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/services/xlsx-importer.js:81:24)\n at async importXlsxAction (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/actions/import-xlsx.js:73:25)\n at async importXlsx (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/actions/import-xlsx.js:89:5)\n at async triggerWorkflowActionMiddleware (/app/nocobase/node_modules/@nocobase/plugin-workflow-action-trigger/dist/server/ActionTrigger.js:61:7)\n at async dataTemplate (/app/nocobase/node_modules/@nocobase/server/lib/middlewares/data-template.js:36:3)\n at async app.acl.use.after (/app/nocobase/node_modules/@nocobase/plugin-acl/dist/server/server.js:534:9)\n at async middlewares.add.tag (/app/nocobase/node_modules/@nocobase/acl/lib/acl.js:398:9)\n at async /app/nocobase/node_modules/@nocobase/acl/lib/allow-manager.js:108:7\n at async ACLMiddleware (/app/nocobase/node_modules/@nocobase/acl/lib/acl.js:288:14)\n at async setCurrentRole (/app/nocobase/node_modules/@nocobase/plugin-acl/dist/server/middlewares/setCurrentRole.js:87:3)\n at async AuthManagerMiddleware (/app/nocobase/node_modules/@nocobase/auth/lib/auth-manager.js:125:7)\n at async validateFilterParams (/app/nocobase/node_modules/@nocobase/server/lib/middlewares/validate-filter-params.js:39:12)\n at async /app/nocobase/node_modules/@nocobase/plugin-users/dist/server/server.js:223:7\n at async deleteRolesCache (/app/nocobase/node_modules/@nocobase/plugin-users/dist/server/server.js:212:7)","cause":{}},"module":"Productos","submodule":"importXlsx","method":"error-handler","app":"main","reqId":"b9f13266-eb9d-426d-b067-9bf0ca53748e","dataSourceKey":"main","timestamp":"2025-05-12 15:27:19"}
nocobase_dev | {"level":"error","message":"Invalid value, expected string","stack":"Error: Invalid value, expected string\n at _InputInterface.toValue (/app/nocobase/node_modules/@nocobase/database/lib/interfaces/input-interface.js:50:11)\n at XlsxImporter.performImport (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/services/xlsx-importer.js:183:58)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async XlsxImporter.run (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/services/xlsx-importer.js:81:24)\n at async importXlsxAction (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/actions/import-xlsx.js:73:25)\n at async importXlsx (/app/nocobase/node_modules/@nocobase/plugin-action-import/dist/server/actions/import-xlsx.js:89:5)\n at async triggerWorkflowActionMiddleware (/app/nocobase/node_modules/@nocobase/plugin-workflow-action-trigger/dist/server/ActionTrigger.js:61:7)\n at async dataTemplate (/app/nocobase/node_modules/@nocobase/server/lib/middlewares/data-template.js:36:3)\n at async app.acl.use.after (/app/nocobase/node_modules/@nocobase/plugin-acl/dist/server/server.js:534:9)\n at async middlewares.add.tag (/app/nocobase/node_modules/@nocobase/acl/lib/acl.js:398:9)\n at async /app/nocobase/node_modules/@nocobase/acl/lib/allow-manager.js:108:7\n at async ACLMiddleware (/app/nocobase/node_modules/@nocobase/acl/lib/acl.js:288:14)\n at async setCurrentRole (/app/nocobase/node_modules/@nocobase/plugin-acl/dist/server/middlewares/setCurrentRole.js:87:3)\n at async AuthManagerMiddleware (/app/nocobase/node_modules/@nocobase/auth/lib/auth-manager.js:125:7)\n at async validateFilterParams (/app/nocobase/node_modules/@nocobase/server/lib/middlewares/validate-filter-params.js:39:12)\n at async /app/nocobase/node_modules/@nocobase/plugin-users/dist/server/server.js:223:7","app":"main","reqId":"b9f13266-eb9d-426d-b067-9bf0ca53748e","timestamp":"2025-05-12 15:27:19"}