|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → Feature Requests → Taxon Version Key in reports
Unless I've missed something I cannot see a way to add the Taxon Version Key or Preferred TVK to the standard suite of reports - this would be a useful addition
Craig
Hi Craig,
This would need an extra clause in the xml reports.
Can I ask you to elaborate on why this is useful to you and what you are particularly using it for.
Thanks,
Lynn
Reason for use:
I use exports from Recorder to populate various pages on my web-site and these have linkages to the NBN Gateway using the Taxon Version Key as the link because it is more reliable than relying on the Binomial. I'm currently writing my exports in NBNData, but to be able to do them via Recorder itself would be much more convenient.
Craig
OK, so simply including the TVK in the xml reports would be useful to you?
Lynn
YES !
Would anyone else find this feature useful?
Lynn
Perhaps rather than adding the TVK to all of the XML Reports it would be better to post details on how to add the TVK to an XML report? The beauty of XML Reports is that they can be edited by anyone.
Is having the TVK in the reports something specialist that only a few people would use? - its hard to gauge how useful this might be to most Recorder users. I think posting the info on how to add the TVK to reports is a very good idea if this is not that well used by the majority.
Thanks Charles,
Lynn
Yeah, I would definitely say the TVK is quite a specialised key. I usually use Taxon_List_Item_Key if I'm working with Recorder because it's in INDEX_TAXON_NAME, but I gather Taxon_Version_Key is the one used on the NBN Gateway.
It is quite easy to add the TVK to the XML reports on an as-needed basis; you just join the Taxon_List_Item_Key to the TAXON_LIST_ITEM table from which you can get the TVK.
Craig, did you simply want to know how to add the TVK to specific XML reports, or is it something else you were after?
Just a thought, if TVK was added to the metadata popup in the Taxon Dictionary, and all the reports were set up so that clicking a taxon name loaded them up into the dictionary screen, then it would be just a couple of clicks to get the TVK whether or not they are included in the report. I think otherwise there are bound to be occasions where the report in front of you has not got TVK in it and you realise you need to find it out - modifying then re-running the report would be a pain.
Cheers
If you want the Taxon Version Key to be available in the report wizard you can probably add it in using instructions on the Wiki. The attributes available in the report wizard are controlled via the USABLE_TABLE, USABLE_FIELD, REPORT_ATTRIBUTE, etc. tables in the database. You can modify these to include extra attributes, e.g. ENTRY_DATE and CHANGED_DATE from TAXON_OCCURRENCE. There are elementary instructions for doing this on the Wiki on the Recorder 6 web-site www.recordersoftware.org. The links to follow are: Documentation Wiki – Recorder 6 – Reporting – Report Wizard – Adding New Report Attributes. However, I don’t think this contains enough information on the entries needed in USABLE_TABLE and USABLE_FIELD. I will forward you the instructions I wrote years ago for these in Recorder 2002. Hopefully these two sets of instructions will will enable you to include what you want.
Thanks Sally.
Lynn
Brilliant ! :D ... I've followed Sally's recommendation and used the guidance in the Wiki and have successfully added my extra output field in the Wizard Report, BUT it was quite difficult to get the syntax for the JOIN_SQL correct - took quite a few goes!
Craig
I would like to be able to add the Taxon version key as an export field in the report wizard, but I do not think I will be able to modify the sql myself! Do you have a copy of the query that I could use?
thank you
Lorna
These are the entries I added to Recorder to enable the Preferred Taxon Version Key to appear in the available fields for a report:
REPORT_ATTRIBUTE table:
REPORT_ATTRIBUTE_KEY = SR00001100000001
ITEM_GROUP = Taxon
SOURCE_TABLE = TAXON
ITEM_NAME = Preferred TVK
ATTRIBUTE_SQL = #REPORT_OUTPUT.[Preferred TVK] = NAMESERVER.RECOMMENDED_TAXON_VERSION_KEY
REPORT_JOIN_KEY = SR00001100000001
REPORT_WHERE_KEY = null
ENTERED_BY = SR000011000002QA
ENTRY_DATE = 15/04/2009 14:58:00
CHANGED_BY = null
CHANGED_DATE = null
SYSTEM_SUPPLIED_DATE = 0
REPORT_JOIN table:
REPORT_JOIN_KEY = SR00001100000001
JOIN_SQL = FROM #REPORT_OUTPUT LEFT JOIN TAXON_LIST_ITEM ON TAXON_LIST_ITEM.TAXON_LIST_ITEM_KEY = #REPORT_OUTPUT.LIST_ITEM_KEY LEFT JOIN TAXON_VERSION ON TAXON_VERSION.TAXON_VERSION_KEY = TAXON_LIST_ITEM.TAXON_VERSION_KEY LEFT JOIN NAMESERVER ON NAMESERVER.INPUT_TAXON_VERSION_KEY = TAXON_VERSION.TAXON_VERSION_KEY
ENTERED_BY = SR000011000002QA
ENTRY_DATE = 15/04/2009 14:47:00
CHANGED_BY = null
CHANGED_DATE = null
SYSTEM_SUPPLIED_DATA = 0
REPORT_FIELD table:
REPORT_FIELD_KEY = SR00001100000001
REPORT_ATTRIBUTE_KEY = SR00001100000001
FIELD_ITEM_NAME = Preferred TVK
FIELD_TYPE = varchar
FIELD_SIZE = 16
ENTERED_BY = SR000011000002QA
ENTRY_DATE = 15/04/2009 14:59:00
CHANGED_BY = null
CHANGED_DATE = null
SYSTEM_SUPPLIED_DATA = 0
Forum → Feature Requests → Taxon Version Key in reports
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.