Thank you - I hadn't thought of *pulling* into tiddlywiki I have just been trying to *push. *I also didn't know it was possible to import. I might be able to have a two-step process - export from Excel into an intermediate format which then gets imported into TiddlyWiki.
Thanks again, Paul On Monday, 12 August 2019 14:17:20 UTC+1, Michael Wiktowy wrote: > > Hi Paul, > > Hot off the press is version 5.1.20 which has some math and string > manipulation functionality (specifically split and join) that might make > importing and exporting CSV files viable in your use-case. Nothing will be > super-automagic but tools should be there out of the box and you might find > a good workflow that has your records stored as tiddlers and sections > structured as hierarchical tags (see how table of contents work). I believe > that there are some more advanced plug-ins that handle import and export of > Excel docs that you might be able to use without building the tools > yourself. > > Also I have has some experience/pain dealing with x.x.x.x type section > numbering and the "sortan" filter seems to order those correctly. > > Footnotes might be problematic (something that I have been struggling > with) since html doesn't have a fixed concept of page and printing and > pagination control is a bit sketchy from browsers. Endnotes would be > simpler alternative. > > Good luck, > /Mike > > On Monday, August 12, 2019 at 9:53:49 AM UTC-3, Paul Richardson wrote: >> >> Good afternoon, complete beginner here. >> >> I maintain a reference document for my organisation which has some >> pre-amble and then is essentially a large table. The user looks through the >> table for their particular area of interest and then is given a particular >> category/label for their information. The document is also shared with >> partner ogranisations and suppliers and needs to be presented in a portable >> format - and it cannot be shared on the internet or in a collaborative >> manner. The document has three levels e.g. section 1, section 1.1, section >> 1.1.1 (although in some places 1.1.1.1). >> >> As the document is quite wordy (with footnotes) it is currently >> maintained in Word, but I would like to move away from this, and have been >> playing with TiddlyWiki. As I still need to provide the Word version, what >> I would quite like to do is have a master database (probably in Excel) >> which then auto-populates the Word document *and* the TiddlyWiki >> version. >> >> I am familiar with the principles of markup laguage and I have managed to >> get as far as getting Excel to generate the code for the table rows, and >> have successfully pasted these into a tiddler. However I then wanted to get >> Excel to generate the code for the tiddler itself, (the <div created >> modified tages title> but when I paste this into the HTML directly (just >> after the tiddlers I created in tiddlywiki), this doesn't seem to work (and >> yes I have closed the </div> at the end). >> >> So my immediate question is, which parts of the HTML file do I need to >> insert code into in order to add a working tiddler? >> My other question is - is my objective even possible or will there be too >> many other unseen hurdles and complications along the way? >> >> (I suppose the alternative approach is to maintain the master version in >> TiddlyWiki and then find a way of exporting the whole document to Word, but >> it needs to be clean and professional). >> >> Thank you! >> >> -- 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 tiddlywiki+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/ae187074-5029-4449-ba47-84f7b62392db%40googlegroups.com.