Thx for the solution With my clumsy english I was trying to convey that I had solved the problem of getting the spreadsheet data to become new tiddlers, with text, titles, tags, labels, etc though your suggestion obviously has a bit more elegance to it. My main problem was instead that the tags of my many new tiddlers didnt seem to be active untill each and every one of them had been opened (e.i. the edit-window) and closed - which is why I wanted a way of opening all tiddlers and closing them again.
Not actually having tried your solutions yet, I fear the same problem will occur => lots of new tiddlers with tons of tags but no way of crossreferencing the tags untill i have opened and closed all individual tiddlers (somehow activing the tags). I hope I am making sense this time. On Sep 8, 9:31 pm, Eric Shulman <[email protected]> wrote: > > My problem is that im loading a lot of data from a spreadsheet in > > Excel, I have coded the data using the newTiddler macro so I get a lot > > I'm not sure what you mean by 'coded the data use the newTiddler > macro'... > > However, you might want to try using > http://www.TiddlyTools.com/#ImportTiddlersPlugin > > which has the capability to read CSV (comma-separated value) data > files output by Excel (and other spreadsheet apps). Basically, just > create column headings in the first row of your spreadsheet, where the > headings are the tiddler field names. You need to have a heading > named "title", and should also have ones named "text" and "tags". You > can also use 'created' and 'modified' headings to enter tiddler dates, > and 'modifier' to enter an author name. Any other headings will be > used to create custom fields. The tags field value is entered as a > space-separated, bracketed list (i.e., same syntax as in the tiddler > editor). > > Once you've saved the file in CSV format from Excel, you can then use > the interactive 'control panel' provided by ImportTiddlerPlugin to > open that file, read the CSV-formatted tiddler data, and show the list > of tiddlers in a multi-select listbox. Then, simply select all (or > some) of the items in the list, and press "import" to create the > tiddlers in your document with just one click! > > The following other TiddlyTools plugins also work with CSV files: > > http://www.TiddlyTools.com/#ExportTiddlersPlugin > - select tiddlers in your document and write them to a separate > file > > http://www.TiddlyTools.com/#LoadTiddlersPlugin > - non-interactive macro to import tiddlers into your document > > http://www.TiddlyTools.com/#SaveAsPlugin > - non-interactive macro to export tiddlers to a separate file > > enjoy, > -e > Eric Shulman > TiddlyTools / ELS Design Studios --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/tiddlywiki?hl=en -~----------~----~----~----~------~----~------~--~---
