Tinderbox User-to-User Forum (for formal tech support please email: info@eastgate.com)
http://www.eastgate.com/Tinderbox/forum//YaBB.cgi
Tinderbox Users >> Tinderbox applications >> Documenting Access Database
http://www.eastgate.com/Tinderbox/forum//YaBB.cgi?num=1384161291

Message started by Simon Knight on Nov 11th, 2013, 4:14am

Title: Documenting Access Database
Post by Simon Knight on Nov 11th, 2013, 4:14am

I have a task to document a complex Access Database.  I have started using Tinderbox for my notes and am wondering if Tinderbox is powerful enough to do more for me.  I am able to extract TSV data from the Access database that describes its design and propose adding this information to a Tinderbox file.  I would like to list the major components along with their data sources in an attempt to identify unused objects.  For instance, if I create notes about queries and include an attribute that lists all the data tables that the query uses is it possible to create agents that list all the queries that use a certain table?

best wishes

Simon

Title: Re: Documenting Access Database
Post by Mark Anderson on Nov 11th, 2013, 9:30am

In short, Yes! How much extra metadata you need to apply (i.e. user attributes) will depend on whether existing text you import produces notes with sufficiently unique data to query.

Worst case, you may need to add user attribute(s) to allow you 'tag' notes with a term for which it is easy to query. Trivial example - you want to look for 'XYZ' but many notes you don't want also hold that value. Make a String attribute and store 'XYZ' - or some suitable value, in the attribute for the relevant notes.

Tip. After you've done an import of the data, make a copy of the TBX document using a new name. Open the latter and delete most of the new data. Leave only enough for you to be able to design and test representative agents, prototypes, etc. The temptation is to dive straight in. That may work, but if not this approach of using a smaller dataset to help figure the code you need can be very helpful. As you figure what's needed you can then implement the ideas in you full data file.

Does that help?

Title: Re: Documenting Access Database
Post by Simon Knight on Nov 11th, 2013, 11:05am

Yes that helps and thanks for the tip.

Simon

Tinderbox User-to-User Forum (for formal tech support please email: info@eastgate.com) » Powered by YaBB 2.2.1!
YaBB © 2000-2008. All Rights Reserved.