yep, thanks! saved the day from being a total disaster :) //steve.
On Sunday, February 3, 2019 at 2:10:14 PM UTC-5, Mark S. wrote: > > Hi Steve, > > I did two things to get it to work. I'm not sure if the first was > essential, but I think it was. > > First I turned all the formulae into actual text and numbers, including > the headers. > > Second, I changed the "name" field into "title". Tiddlers have to have a > title, so if none of your columns are "title", then there is no place to > hang your data. > > I only got four of the fields, and, in review, I see that several of the > columns have spaces in them. So you will have to go back and change the > double-word titles to single words or double words with underscores. > Tiddler fields can not have spaces in them. > > There is probably other tweaking that needs to happen. In some cases the > translated formulae gave year ranges, for instance. > > Good luck! > -- Mark > > On Sunday, February 3, 2019 at 10:32:50 AM UTC-8, [email protected] > wrote: >> >> The XLSX plugin is an excellent tool for creating tiddlers based on rows >> of a sheet in a workbook (either Excel or Google sheets downloaded as >> xlsx). The tiddlers each get fields based on the columns of the sheet. If >> you've never played with it, check it out. >> >> I've just discovered the "By Column" mode which should take the first row >> of the sheet and use the labels as names of the fields, populating each >> tiddler with the value of the cell in that row. >> >> However, I can't quite get it to work -- the import just sits there and >> never actually imports...See http://xlsx-import-by-column.tiddlyspot.com/ >> for >> a demo (which, for what's it worth, links to a google sheet that >> demonstates the ability to use =importhtml() google sheets command to >> import any table in any page in wikipedia...) >> >> Any help, much appreciated! >> >> thanks, >> >> //steve. >> >> >> -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/8f6cffec-803b-4138-bc55-4cf017a70684%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
