[tw5] Re: Re-importing a previously exported CSV (JSON Mangler? XLXS Utils?)

2021-01-18 Thread Osin
This worked, thank you so much Joshua! For anyone reading, make sure that you copy/paste the CSV data from something like Notepad, and not Excel. On Sunday, January 17, 2021 at 3:20:26 AM UTC-5 joshua@gmail.com wrote: > Gotcha. This is actually very do-able with a local copy of my

[tw5] Re: Re-importing a previously exported CSV (JSON Mangler? XLXS Utils?)

2021-01-17 Thread TW Tones
I will just add, although I do use the JSON mangler; another option is to open the CSV file and copy the content of all entries and past into a tiddlers text field. Now along with few methods such as; <$list filter="[{Data}splitregexp[\n]limit[10]]"> Then another list parameter that splits

[tw5] Re: Re-importing a previously exported CSV (JSON Mangler? XLXS Utils?)

2021-01-17 Thread Joshua Fontany
Ack, the `type` should be `application/csv`. I misspelled it once. :) On Sunday, January 17, 2021 at 12:20:26 AM UTC-8 Joshua Fontany wrote: > Gotcha. This is actually very do-able with a local copy of my JsonMangler > Demo Wiki. > > The following will import a CSV as one tiddler per line, as

[tw5] Re: Re-importing a previously exported CSV (JSON Mangler? XLXS Utils?)

2021-01-17 Thread Joshua Fontany
Gotcha. This is actually very do-able with a local copy of my JsonMangler Demo Wiki. The following will import a CSV as one tiddler per line, as regular tiddlers (not json), but it packs them as shadow tiddlers into a plugin tidder. I'll try to step you through it. :) - Go to:

[tw5] Re: Re-importing a previously exported CSV (JSON Mangler? XLXS Utils?)

2021-01-16 Thread Osin
Hi Josh, Thanks a lot! I am already halfway through with the headers (TW exports them as such, so I just kept the same structure). I actually considered this route, but abandoned it because I wasn't able to find a CSV to JSON converter that ran locally - I work with protected data so I'll avoid

[tw5] Re: Re-importing a previously exported CSV (JSON Mangler? XLXS Utils?)

2021-01-15 Thread Joshua Fontany
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