Yeah, I have a large amount of metadata that is changing, and the source of that data is either going to be:
1. Originating in the metadata of the SQL tables (attached to the tables and columns) - kind of basic data dictionary things which will look like: <DataElement><TableName /><ColumnName /><DataType /><Source /><ChangeEvents /><Discussion /></DataElement> Where we would want to generate a page for every one of these automatically from the source code (mostly manually edited) during the build. There might be also editable narratives to go with them. 2. It is going to be in rules that original in Excel (manually edited), go through XML and then become data in mapping tables. These are kind of similar, but have much more data about the source data that matches the rule and the output data, plus the edited narratives are more likely to include screenshots and longer explanations. <DataElement><TableName /><ColumnName /><DataType /><Ruleset /><Rule /><SourceCriteria /><Values /><Lookups /><Discussion /></DataElement> 3. Other things: Perhaps pages of build results like any warnings, exceptions or errors in the rulesets in the current build process that we detected from #2. Technically we already get these as logs or tables, but makes sense to include them in the set of pages if we have an HTML framework to put them in now. It's unlikely I want to put TiddlyWiki on the front end of this process because I do need to check in structural changes like new tables, columns, views and procedures with their metadata all together. Plus I don't think generating all my SQL from TiddlyWiki pages makes a lot of sense. Plus, I would need to transition writing the rules from a spreadsheet to TiddlyWiki Tables - and we do occasionally use Excel macros to make these more functional for data input and validation. There are two obvious approaches: One is to generate the page framework from all the data we have and incorporate manually edited data somehow - like another manually edited source. The other is to have manual set of pages which can embed automatically generated content as some kind of widgets or plugins of the form <Documenter.DataElement Category='CategoryName' DataElement='DataElementName' /> or whatever There currently isn't any web-based application built that is hitting this data warehouse. If I had that I could make some kind of service to serve up the metadata and plug it into manual pages as a widget or plugin. I could also just build an app that lets you navigate the metadata and allows annotation and stores it somewhere and displays it all to the user. But I didn't really want to build an app yet until we've explored the gaps in the data and the features people will need. I could just going to generate a bunch of HTML pages with links. But I would have to style them, have some framework, navigation, etc. Again, not ready to build all that just yet - just looking to output something people can interact with and tell me what's missing so we can get it added somewhere in the process. Basically, anything where I can load a big file like <pages><page name="Home">wiki markup here</page><page name="Category">wiki markup here</page><page name="Element">wiki markup here</page></pages> would be great. In fact, that's basically what I am starting to generate for whatever presentation layer we end up using. So I was looking to potentially push out a pre-built TiddlyWiki at the end of this process right now so people can browse it and see where the gaps are and what they would like to see. I think ideally it would probably morph into something where they could edit any of the discussions or narratives and have that change recorded and save and potentially fed back through some change management process. Who knows, maybe TiddlyWiki is the perfect platform for the whole thing with some kind of plugin. Thanks, Cade On Friday, August 9, 2019 at 3:51:35 PM UTC-5, Mat wrote: > > Hi Cade and welcome! > > Reading your text I was thinking "OK, that is super simple" ...until you > said > > So is there a way to generate a set of pages or the content for the pages >> and have them "loaded" into TiddlyWiki? >> > > Oh. That is a different matter. Someone just very recently posted > something about this (within the last month) but the crucial thing is if > you want your content to be actively integrated in TW or not. Now you state > you have not quite defined what you want so may I suggest that you just do > it all in TiddlyWiki? You can very easily export tiddlers as e.g ready made > html pages or as e.g json files. Or just leave it in the TW because it is a > single file which you can manage as a unit. > > Would that work? > > I suggest you play around a bit with TW to see how it works so you can > express your needs more in "TW terms". > > <:-) > -- 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/dee7d202-dede-475b-a3e5-99a1ca2fb5ca%40googlegroups.com.
