Hi Osin, Plugin author of JsonMangler here. The CSV options in JsonMangler are complex and can be a bit hard to figure out.
What I would do in your situation is to ensure that you have column headers in your Excel file, and that one of the column headers is "title" and one colum header is "text" (all headers need to be lower case, and "tags" would be a good one to include). Then, run your file through a CSV/XLMS -> JSON converter. This should turn your file into an "array of objects" with each object having at least a "title" property. You can then drag and drop this JSON file into vanilla TW5 and it should import as 1-tiddler-per-object. Here is a converter that would work for you: https://json-csv.com/reverse For example I ran this small sample CSV through the converter: title,tags,text One,test,Question One? Two,test,Question Two? Three,test,Question Three? Which renders as: [{ "title": "One", "tags": "test", "text": "Question One?" },{ "title": "Two", "tags": "test", "text": "Question Two?" },{ "title": "Three", "tags": "test", "text": "Question Three?" } ] SAVE this output as a text file with the "*.josn" extension (it comes out of that converter as "result.json"). Then, simply drag and drop this Json file into a Tiddlywiki. If it is a file with this correct format, each object will become a separate (regular) tiddler. This will help you use the other features, like Filters, etc on your tiddlers without worrying about them being "json tiddlers". Best, Joshua Fotnany On Wednesday, January 13, 2021 at 6:08:04 PM UTC-8 Osin wrote: > Hello, > > I am working on transforming an FAQ contained in an Excel workbook (with > only one spreadsheet) into a simple TW. I posted about it here : > https://groups.google.com/g/tiddlywiki/c/i6-Ge9ahVCQ/m/X8BhP54IDAAJ , got > some great feedback, and I have been testing and playing around TW, I think > I'm starting to wrap my head around it (Mat's "Big Picture" text really > made things click, thanks!). > > The original FAQ Excel file contains about 60 entries, one entry per row. > I manually "transferred" 10 of them into tiddlers, linked them with tags > and created a TOC within a TW5 instance. However, the full 60 entries will > need to be revised and edited by two of my teammates before I go ahead and > import everything. > > I exported the 10-tiddler TW into a .CSV file. It gave me (and my > colleagues) a good idea about how the data is structured. I am now at the > stage of modifying the CSV by adding the remaining 50 QAs after my > colleagues have reviewed them, and re-importing the CSV into TW. I'm doing > a test-run and adding 6 additional rows to the CSV. > > How can I easily re-import the CSV? Tones mentioned JSON Mangler in the > other thread, but I am a bit lost in the documentation (again). I found a > thread about it as well, but there is talk of shadow tiddlers, turning the > import into a plug-in, and other options I am not sure concern my use case. > At this point, I'm unsure whether I should just just transfer everything > manually, it might be quicker than troubleshooting the import. I also saw > there is xlsx-utils, would that plugin serve a similar purpose? > > Thank you. > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/7b2784d4-46b8-4708-bf25-63ca592b2facn%40googlegroups.com.
