This actually worked very well on a 4700rowx10col table (a bacterial genome feature table, mainly numbers, id codes, a short descriptor) pasted from Excel. Just swap to tab as delimiter and make sure you have the Force wrap numbers in quotes option enabled. I then did a search/replace to identify the title and text fields, the remainder ending up as footer fields (or whatever they're called). Import of the resulting json paused a couple of times but pressing Continue ultimately saw the operation complete successfully.
On Monday, March 9, 2015 at 5:58:14 PM UTC, Peter Miller wrote: > > Again, an offline kludge but may be of interest in converting csv to and > from json. Can roundtrip single-line text though I wouldn't like to say how > reliable it is. http://www.convertcsv.com/ > > bw > > Peter > > On Thursday, March 5, 2015 at 3:01:15 PM UTC, Andreas Hahn wrote: >> >> Hi Peter, >> >> very interesting workarounds to get charts into TW, I think for now that >> is about the best way to do it. >> There are d3 widgets (namnely a bar chart and a cloud chart) available as >> a plugin in TW, however, they are very difficult to use in terms of input >> data formatting. Currently they require a specific json input, maybe >> someday they can handle csv data that could be pasted straight from excel. >> I think I also saw other widgets offering other chart types, but I am not >> sure. >> >> /Andreas >> >> Am 05.03.2015 um 15:35 schrieb Peter Miller: >> >> In similar vein, you can convert charts in Excel to SVG format in a >> slightly roundabout way, viz move them to their own tab, save to PDF, use >> cloudconvert.com to generate an SVG file and add it to Tw5 by >> drag-and-drop. I'm not sure whether that has any significant advantages but >> may be of interest until such time as a charting plugin becomes available. >> >> bw >> >> Peter >> >> On Wednesday, March 4, 2015 at 3:09:45 PM UTC, Peter Miller wrote: >>> >>> I don't know how long it will be there but RAW at >>> http://app.raw.densitydesign.org/ provides some nice visualizations and >>> specimen data. The exported SVG plays nicely with TiddlyWiki as far as I >>> can tell though I've yet to work out how to make it editable in SVG-Edit. >>> >> -- >> 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 http://groups.google.com/group/tiddlywiki. >> For more options, visit https://groups.google.com/d/optout. >> >> >> -- 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 http://groups.google.com/group/tiddlywiki. For more options, visit https://groups.google.com/d/optout.
