Conversion file.xls and file.ods in tiddlywiki file

[Sergey Shishkin]

Maybe someone has already put such a problem and there are solutions. Ideal to set certain parameters of any column as the name tiddlers, content tiddlers, the type of dates and reference data (eg a pattern in http://historydates.tiddlyspot.com). The rest of the fields in the form tiddlers. Tiddler - this, of course, a record in the table.

More would be good to learn how to grab the popular blogs such as blogger.com, wordpress.com, livejournal.com etc.Comments are not mandatory, but with reference to the original source.

[Danielo Rodríguez]

xls is a closed source format, so I don't think it could be doable.

there is a parser for csv already

[Sergey Shishkin]

And file.ods?

there is a parser for csv already

 And how to use the parser to solve the problem?

понедельник, 1 августа 2016 г., 15:43:21 UTC+2 пользователь Danielo Rodríguez написал:

[Mark S.]

Export from excel to CSV. Then use CSV converter.

For clipping blog content, including URL info, see:

http://tiddlyclip.tiddlyspot.com/

-- Mark

[Sergey Shishkin]

Then use CSV converter

And somewhere we can really see how the linies of table into a tiddlers?

Where are the data for the tiddlers?

Probably, if I knew the answer, I would not have asked the question.

понедельник, 1 августа 2016 г., 16:29:30 UTC+2 пользователь Mark S. написал:

[Birthe C]

Have  you looked at http://skplugins.tiddlyspot.com/
The tablehelper might be what you are looking for.


Birthe

[Sergey Shishkin]

Wow! I went to study. Thank you. As always, great answers.

I spied on http://historydates.tiddlyspot.com. And I realized that I do not understand how to do tiddlers with tables with dynamic entries variables. It's about the tiddlers chronology (or journal).

Sergey

вторник, 2 августа 2016 г., 11:19:12 UTC+2 пользователь Birthe C написал:

[Stephen Kimmel]

Sergey,

I have one additional plugin that I have been working on that isn't quite ready yet. It will convert rows of a TiddlyWiki table into individual tiddlers. If that is where you're ultimately going, I'll put some additional effort into it so I can put it up more quickly.

[Sergey Shishkin]

Stephen,

I'm happy! I'll wait! This is cool!

I found the service tiddliwki! 

https://dl.dropboxusercontent.com/s/tk91wqty552z6z1/designwrite.html?dl=0

Now I have a JSON tiddler or CSV?.

Example

dl=0
[
    {
        "title": "Test2.csv",
        "type": "text/plain",
        "text": "Date,Place,Type,Name,Discription,F1,F2\r\n20161010,London,State,Tiddler,same text,for field,for field\r\n20161010,Paris,State,Tiddler,same text,for field,for field\r\n20161010,Berlin,State,Tiddler,same text,for field,for field\r\n"
    }
]

My tiddlers matching structure:

The name became the name, description - text in tiddlers, date to the date, place at place (as here http://historydates.tiddlyspot.com/#historic%20question%20asked), type in the type (abstract string), F1 (note external link!, but optional) field of the tiddlers links and other field something else ...

Once again, thanks for the comment! I will wait. I would quickly learn tiddliwiki, but translation of documentation takes time. So I have these questions. Although I think that such a thing would be very useful!

With great respect

Sergey

вторник, 2 августа 2016 г., 20:19:30 UTC+2 пользователь Stephen Kimmel написал:

[Stephen Kimmel]

Sergey,

If you go to http://skplugins.tiddlyspot.com/ you'll find the preliminary version of the new plugin, TabletoTiddlers, under Experimental Plugins. I've included an example data table which I've derived from the example you gave. It's not an exact match but it should give you a pretty good idea of how it works.

Note that although I've used this routine quite a bit, you should still consider it as experimental. Assume there are more bugs in it. Truth be told, that's part of why I'm letting you have it now. My hope is that you'll help me find the bugs so  I can fix them or at least offer suggestions to make it better.

Stephen

[Sergey Shishkin]

Stephen, it's great!

I realized and ready to be a tester of all functions. And active when I finish translating documents. This will happen until September 1, this month.

I tried to find TabletoTidlers, but did not find. But I saw an example of a wiki. Wow. It is likely that you could rip structure http://www.livejournal.com there I have three blogs and would like to get three tiddli file. Each blog posts about 2000 and I wanted to do everything by hand.

That's exactly the structure that I need.

<$reveal type="nomatch" state=<<folded-state>> text="hide" tag="div" retain="yes" animate="yes">

<div class="tc-subtitle">

Дата:<$link to={{!!chdate}}>

<$view field="chdate" format="date YYYYMMDD" template={{$:/language/Tiddler/DateFormat}}/>

</$link> 

<$list filter="[is[current]!has[info]]">

Место:<$link to={{!!chplace}}>

<$view field="chplace"/>

</$link>

</$list> 

<$list filter="[is[current]has[info]]">

Место: <a href={{!!url}} target="blank">{{!!info}}</a>

</$list> 

Процесс:<$link to={{!!chprocess}}>

<$view field="chprocess"/>

</$link> 

</div>

</$reveal>

http://dev.livejournal.com

http://www.livejournal.com/developer

But, still, why can not I find a plugin? 

Sergey

среда, 3 августа 2016 г., 14:57:50 UTC+2 пользователь Stephen Kimmel написал:

[Stephen Kimmel]

I tried to find TabletoTidlers, but did not find. But I saw an example of a wiki. Wow. It is likely that you could rip structure http://www.livejournal.com there I have three blogs and would like to get three tiddli file. Each blog posts about 2000 and I wanted to do everything by hand.

You'll find all the plugins if you click on the gear icon in the sidebar that opens the control panel. The fifth tab in the control panel goes to the Plugin tab. There is a second row of tabs titled Plugins, Themes and Languages. Click on the one marked Plugins and you'll see a listing of all the plugins in the wiki. Well down the list is a plugin titled "Table to Tiddlers". Drag and drop that into your wiki.

Alternatively you can simply go to this link: http://skplugins.tiddlyspot.com/#Table%20to%20Tiddlers

About halfway down the tiddler, you'll find a link to the actual plugin:

Plugin Tiddler

$:/plugins/sk/TabletoTiddlers

Drag and drop that into your wiki to import the tiddler. You'll have to save and reload your wiki to activate it.

[Sergey Shishkin]

Stephen

It would be better to solve these particular problems first.

1. Translation of table rows in tiddlers

2. Hack livejournal

The fact that it is important not only for me personally, but for all members of our historic club. We created a lot of content and it would stimulate the transition to tiddliwiki.

And I am all at your disposal. I went to watch the plugin. Thank you.

P. S. OK! Looked. And in what format I should be at the table?

четверг, 4 августа 2016 г., 14:10:54 UTC+2 пользователь Stephen Kimmel написал:

[Sergey Shishkin]

Stephen

Internal JavaScript Error
Well, this is embarrassing. It is recommended that you restart TiddlyWiki by refreshing your browser
Script error

I probably still too early to push the button. But I'm willing to wait as much as necessary, when you are informed that the buttons start trying to do something.

I have, in fact, such a question. 

In what format are assumed to be the source data? How can I get the tables containing TiddlyWiki formatting. Or, finally, it will be possible even html?

Segey

четверг, 4 августа 2016 г., 14:10:54 UTC+2 пользователь Stephen Kimmel написал: