[tw5] Re: Generating a complete TiddlyWiki from Excel
Thanks for your detailed reply, I'll look into those ideas. Paul On Monday, 12 August 2019 13:53:49 UTC+1, 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 organisations 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). > > [image: Untitled.png] > > 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 manually. > > |4.1|Wordy description of situation A| class4 > | class4 | class2 > | > |4.11|Wordy description of situation B| class3 div> | class3 | class1 | > > > [image: Capture.JPG] > > However I then wanted to get Excel to generate the code for the whole > tiddler itself, (the ), but when I paste > the complete tiddler ( header and the content and the closing) > into the HTML directly (just after the tiddlers I created in tiddlywiki), > this doesn't seem to work. It looks identical in format to other tiddlers I > have added in the usual manner, so there must be other parts of the HTML I > need to edit.. (I can see my tiddlers both in the "static" area and in one > other place and have added equivalent entries in both). > > title="Description"> > |4.1|Wordy description of situation A| class4 > | class4 | > class2 | > |4.11|Wordy description of situation B| class3 > | class3 | > class1 | > > > I know the HTML isn't intended to be directly edited but what can I say! > > 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/843534e1-8abb-488d-bf21-5a8445dcbb20%40googlegroups.com.
[tw5] Re: Generating a complete TiddlyWiki from Excel
Many thanks - I will have a look! On Monday, 12 August 2019 14:49:29 UTC+1, PMario wrote: > > Hi Paul, > > This may be of interest: https://tiddlywiki.com/editions/xlsx-utils/ > > -m > -- 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/50d4a996-e288-4317-a179-34bad40ea3fb%40googlegroups.com.
[tw5] Re: Generating a complete TiddlyWiki from Excel
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 > 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 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.
[tw5] Generating a complete TiddlyWiki from Excel
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 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 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/b44e0694-c365-42c2-a734-64d737d31596%40googlegroups.com.
