Hi Jimmy, Once you have your data in the wiki as a csv tiddler, open the csv options slider (csv file button in the header), then open the $:/Import options (last one, paperclip slider button). Choose an import type & click the "$:/Import ThisTiddler" button once all import settings are confirmed.
The widget in the UI will the automatically save the data as one or more (one per row) new tiddlers in a new $:/Import tiddler in the Story. Confirm from there. Best, Joshua Fontany On Wed, Feb 5, 2020, 5:38 PM Jimmy Liew <[email protected]> wrote: > Hi Joshua, > > How to import a CSV file? > I attempt to drag and drop to the TW5, and it creates a new tildder > instead. > > > > On Wednesday, 5 February 2020 12:08:05 UTC+8, Joshua Fontany wrote: >> >> Hi Everybody, >> >> I'm very excited about the new release of Json Mangler. I'm calling this >> the Over 9000 Csv Update! >> >> (I hope enough of the audience gets that...) >> >> This update turns Json Mangler into a swiss-army-knife-data-conversion >> tool. Nearly all databases can export to csv tables, and now all your base >> are belong to tiddlywiki. >> >> ;D >> >> - New $csv widget parses and renders any tiddler with type = >> 'application/csv'! >> - Simply drag/drop your *.csv text-file, complete the import, (type >> is auto-set to 'application/csv')!! >> - OR use a 'tiddlywiki.files' file to import whole folders of Csv >> data at once!!! >> - CSV does not mean COMMA seperated values, it means CHARACTER >> separated values (set your own - no UI on first release)!!!! >> - Fully configurable access to the included PapaParse library via a >> "state" tiddler for each $csv widget onscreen!!!!! >> - Peek/preview to limit the rows loaded, skip-to-page to jump around >> LARGE datasets, a whole bunch of cool options!!!!!! >> - Sophisticated CSV Import - like, whoa!!!!!!! >> - Import the whole thing as one JSON Array tiddler, or import each >> row of the Csv as a Json or regular Tiddler!!!!!!!! >> - Dynamic creation of "simplified" field-names when importing >> individual tiddlers based on column index# or a "slugged" version of the >> original column name!!!!!!!! >> >> I have included a test Csv in the new example wiki (below), which is a >> database of video game sale from a few years ago. It has 16,600 rows >> (including an empty row, and a headers row), so you can play around with >> all of the peek, display, and import options. >> >> Thanks very much for any feedback! >> >> Github repo: https://github.com/joshuafontany/TW5-JsonMangler >> >> Github release: >> https://github.com/joshuafontany/TW5-JsonMangler/releases/tag/2.0.8 >> >> Example wiki: https://joshuafontany.github.io/TW5-JsonMangler/ >> >> This plugin is a work in progress; any suggestions or bug reports are >> very welcome. >> Please report any issues on GitHub: >> https://github.com/joshuafontany/TW5-JsonMangler/issues >> >> If you find this useful and would care to donate, please use my PayPal: >> https://paypal.me/JoshuaFontany >> >> Best, >> Joshua Fontany >> > -- > You received this message because you are subscribed to a topic in the > Google Groups "TiddlyWikiDev" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/tiddlywikidev/wwMaABzyabE/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/tiddlywikidev/2d44ba3a-fec8-4b98-a685-592c35020111%40googlegroups.com > <https://groups.google.com/d/msgid/tiddlywikidev/2d44ba3a-fec8-4b98-a685-592c35020111%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "TiddlyWikiDev" 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/tiddlywikidev/CAM1fME4za7%3DA2p03Z9bvPyh27B0qr2hYfamwTX-kCJqvHriiyQ%40mail.gmail.com.
