CreateTiddlersFromCSV - TiddlyTools

[skye riquelme]

Hi All

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 !!!!!!

Anyway around this???

Thanks

Skye

[Eric Shulman]

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

[skye riquelme]

Wow....thats a lot of information.....give me a bit of time to get my
head around all these amazing possibilities......and THANKS

Skye