Continuing the discussion from Idea of multi field data tiddler like a data base : I have a Tiddlywiki I use to make notes about decks I build playing Magic: the Gathering. I have a JSON file with data about the cards (card name, the card’s “cost” in-game, its card type, and a URI to an image of the…

@technome … Do you control how the JSON tiddler with the cards is created? If yes, you could try to create a JSON file, that can be imported as single tiddlers, per card, to run tests. Using json-operators is relatively complex, even if the structure is relatively simple. TW is optimised to be use…

[image] technome: I’ll play around with both of these ideas tomorrow and report back on what I find. If you can share the CSV I can give you back a plugin to get you started? In the mean time I want to see how hard it would be to query the csv directly.

I’ve added it to my original wiki linked above in the tidder MtGQuery.csv https://mtg-sketchbook.tiddlyhost.com/#MtGQuery.csv

[image] EricShulman: When you press the “make cardname list” button, it invokes the make() macro, which will take a LOOOONG time to complete since it has to process all 29677 cards! This definitely seems like a “right tool for the job situation”! I tried this but got impatient, stopped it, an…

[image] technome: I’ve added it to my original wiki linked above in the tidder MtGQuery.csv My TiddlyWiki — a non-linear personal web notebook As far as I can see that is not CSV

It attached it as a binary file (not sure why, maybe because my system has CSV associated with Excel?) I have deleted and re-added a new tiddler with the same name and copied the contents in. I’ve also created a rough sketch of what I would like each card to look like if I can create all 29,667 tid…

[image] pmario: Do you control how the JSON tiddler with the cards is created? I do have control over it, as I had to filter out a lot of data I didn’t want to import. [image] pmario: If "name": will be changed to "title:", it should be possible to import it into TW. Is the JSON forma…

I have imported it into a wiki with JSON Mangler and another required plugin. I changed the type to application/csv known in the wiki with JSONMangler installed Using the import tools that appear on the CSV because of JSON Managler I imported it with no setting changes Note there is a display issu…

[image] technome: Is the JSON format for import documented somewhere? I know I’ve seen examples of what it looks like but I am struggling to find an example now. I would want to set the title and multiple fields along with a tag of “Card” See: How do TWs JSON Formats Look Like – It basically …

[image] pmario: If "name": will be changed to "title:", it should be possible to import it into TW. in addition to that size wize i imagine using a key/tiddler to link field name text to number title:obj-key 1: image_uris.normal 2: legalities.commander 3: mana_cost 4: set_name 5: typ…

Update: I swear that when I answered there were no other answers! I must have been blind. Sorry, this post doesn’t add much to the discussion. [image] technome: I’ve only shown 4 cards of data but the total list is 29,000 cards (!!), far more than I think would be reasonable to create static …

JSON Filters of Data in an Array

pmario October 27, 2025, 7:46am 17

See: How do TWs JSON Formats Look Like – It basically is the first format, that is described.