[tw5] Uncaught TypeError: title.substr is not a function

Google Group (Read Only)
#1

Hi. I import data from this googlespreadsheet Магазин картин 2.0 - Google Spreadsheets
by this Tiddlywiki
Интернет-магазин Heeg.html загружается..... — Heeg.html

and get error

Well, this is embarrassing. It is recommended that you restart TiddlyWiki by refreshing your browser
Uncaught TypeError: title.substr is not a function

if I use the same TW, but use another spreadsheet everything is good
https://heeg.ru/shop2_2.html?id=16gDZVsB8FOIxrsFKbkbBNWC37lPUAfKOGf-rCVxeOmY

I think TW don’t like something in my table, but I don’t understand what…

#2

I’m not certain, but I think you need a spreadsheet column with heading of “title”, so the import knows what to name each imported tiddler.

-e

#3

this table Google магазин 2.2 - Google Spreadsheets don’t have title column too, but works good.
for spreadsheet import script id=title

The problem that, when I see " title.substr is not a function" I am not able to find part of data from my table, which destroys my Tidlywiki. Console F12 doesn’t help me

пятница, 20 августа 2021 г. в 16:11:06 UTC+3, Eric Shulman:

#4

the problem was that title could non be a number (only a string), when we create tiddler by
if($tw.browser) {$tw.wiki.addTiddler(new $tw.Tiddler($tw.wiki.getModificationFields(),fields,$tw.wiki.getCreationFields()))};

so I make .toString() to all values and now it works

пятница, 20 августа 2021 г. в 16:11:06 UTC+3, Eric Shulman:

#5

Siniy-kit,

I don’t know how to help, but if I were in this situation I would try and use the JSON Mangler plugin or XLSX Utilities edition to import the same spread sheet. Perhaps one of these will not experience the bug or fail gracefully helping you identify the problem.

Do join us in discourse talk.tiddlywiki.org

Tones