Wow....thats a lot of information.....give me a bit of time to get my head around all these amazing possibilities......and THANKS
Skye On 14 Set, 14:49, Eric Shulman <[email protected]> wrote: > > Have found this plugin useful, and have come across a problem. I am > > using it to import financial information which is generated by > > OpenOffice Calc...and which will be read by DataPlugin....so the > > format of the incoming text has the format - ,<<formTiddler > > PagamentoForm>><data>{"ref":"900614" "date":"40064" "month....... > > The text is generated correctly by Calc, and copies into the Plugin > > correctly....but when I hit create tiddlers....the plugin strips out > > the "..........so then formTiddler cant read the data !!!!!! > > I don't quite understand... what you've pasted above doesn't look like > CSV (Comma-Separated Values). As noted in the in-tiddler help (click > on the "CSV-formatted data" slider link): > > any values that contain quotes or commas are surrounded by double- > quotes, and quotes occuring within the values are doubled-up > > Thus, instead of: > , <<formTiddler PagamentoForm>><data>{"ref":"900614" ... , > the CSV content must be: > , "<<formTiddler PagamentoForm>><data>{""ref"":""900614"" ... ", > > Also, if you are using Calc to write out a CSV-bearing *file* with the > appropriate heading row (i.e., 'title', 'text', 'tags', etc.), then > it's easy to use > http://www.TiddlyTools.com/#ImportTiddlersPlugin > to read that CSV file! The plugin will automatically process the CSV > data and fill the tiddler listbox in the import control panel, just as > if it had been reading them from a regular TW-formatted file. Simply > select the tiddlers you want (i.e., 'all'), and click the 'import' > button. > > Note: you can also *write* tiddler data to CSV format using > http://www.TiddlyTools.com/#ExportTiddlersPlugin > or > http://www.TiddlyTools.com/#SaveAsPlugin > > This allows you to make a complete "round trip" from spreadsheet, into > TW, and then back to the spreadsheet, or vice versa. You could, for > example, use ExportTiddlersPlugin to write a CSV file containing a > whole bunch of tiddlers, and then load that CSV into a spreadsheet in > order to 'bulk edit' the tiddler data. When all changes have been > made, you can write out a new CSV file and then import it back into > TW. > > Or, you could convert that old office contact list spreadsheet into an > elegant TiddlyWiki contact manager document... and then let folks edit > their own contact info using TW. Then, after gathering all the > tiddler changes in one document, you could export it to CSV and bring > it back into the spreadsheet for re-distribution to other folks who > may still be using conventional formats and applications. > > ... and, when the above methods are applied to move data between TW > and a database app (most of which can handle CSV), the possibilities > really start to get interesting. For example, you could use TW's > interactive interface to edit a whole set of tiddlers with custom > fields corresponding to columns in database tables, and then export > those tiddlers to the database. You could also use TW as an ad-hoc > query tool to search through tiddlers, and as a report generator to > produce formatted output from imported database content. > > enjoy, > -e --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
