<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[Forum — Exporting TVK]]></title>
		<link>https://forums.nbn.org.uk/viewtopic.php?id=7791</link>
		<atom:link href="https://forums.nbn.org.uk/extern.php?action=feed&amp;tid=7791&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Exporting TVK.]]></description>
		<lastBuildDate>Fri, 01 Apr 2022 14:23:40 +0000</lastBuildDate>
		<generator>PunBB 1.4.6</generator>
		<item>
			<title><![CDATA[Re: Exporting TVK]]></title>
			<link>https://forums.nbn.org.uk/viewtopic.php?pid=30627#p30627</link>
			<description><![CDATA[<p>Hi Linds</p><p>That&#039;s a shame. I agree it would seem reasonable to include TVK in the Report Wizard as standard. I&#039;ll add it to the future enhancements topic.</p><p>Andy</p>]]></description>
			<author><![CDATA[null@example.com (AndyFoy)]]></author>
			<pubDate>Fri, 01 Apr 2022 14:23:40 +0000</pubDate>
			<guid>https://forums.nbn.org.uk/viewtopic.php?pid=30627#p30627</guid>
		</item>
		<item>
			<title><![CDATA[Re: Exporting TVK]]></title>
			<link>https://forums.nbn.org.uk/viewtopic.php?pid=30626#p30626</link>
			<description><![CDATA[<p>Thanks Andy.&nbsp; Unfortunately because of the set up we have within the Council, we can only see the front end of Recorder ourselves, but the information from yourself and Charlie sent through will be useful if we manage to get assistance from elsewhere in the Council.&nbsp; Seems like TVK would be a useful thing to be included in the Report Wizard as standard but there must be reasons why it isn&#039;t.</p><p>Many thanks,<br />Linds</p>]]></description>
			<author><![CDATA[null@example.com (Lindsay_FifeNature)]]></author>
			<pubDate>Fri, 01 Apr 2022 08:05:17 +0000</pubDate>
			<guid>https://forums.nbn.org.uk/viewtopic.php?pid=30626#p30626</guid>
		</item>
		<item>
			<title><![CDATA[Re: Exporting TVK]]></title>
			<link>https://forums.nbn.org.uk/viewtopic.php?pid=30625#p30625</link>
			<description><![CDATA[<p>Hi Lindsay</p><p>Yes, there is a way to do it in the R6 report wizard (I&#039;ve just tried it and it works). You&#039;ll need to add an entry into two of the tables in the SQL Server database (using either SQL Server Management Studio or the linked MS Access database). The first is the REPORT_ATTRIBUTE table which defines where the field value will come from (the INDEX_TAXON_NAME table in this case) and the second is the REPORT_FIELD table which I assume defines which fields appear in the report wizard (and links to the new REPORT_ATTRIBUTE entry).</p><p>I&#039;ve attached a spreadsheet containing examples of the values to add - there are two entries in each tab, one for the TVK of the recorded taxon and the other is the TVK of the recommended taxon. It should work if you just copy and paste the records into the tables but you could edit the key fields in columns A and A + B respectively) if you want to reference your own custodian key.</p><p>I hope this all makes sense - if not let me know.</p><p>Regards<br />Andy</p>]]></description>
			<author><![CDATA[null@example.com (AndyFoy)]]></author>
			<pubDate>Wed, 30 Mar 2022 14:21:39 +0000</pubDate>
			<guid>https://forums.nbn.org.uk/viewtopic.php?pid=30625#p30625</guid>
		</item>
		<item>
			<title><![CDATA[Re: Exporting TVK]]></title>
			<link>https://forums.nbn.org.uk/viewtopic.php?pid=30612#p30612</link>
			<description><![CDATA[<p>Hi Charlie!</p><p>Thanks for your message.&nbsp; Hope all&#039;s well with you :)</p><p>That&#039;s annoying.&nbsp; Unfortunately because of the setup we have being based within Council systems, we can only see the front end ourselves.&nbsp; It would be great if you could send details over of how to do it in case we are able to get assistance from people who could potentially connect though?</p><p>Thanks,<br />Linds</p>]]></description>
			<author><![CDATA[null@example.com (Lindsay_FifeNature)]]></author>
			<pubDate>Thu, 17 Feb 2022 16:21:45 +0000</pubDate>
			<guid>https://forums.nbn.org.uk/viewtopic.php?pid=30612#p30612</guid>
		</item>
		<item>
			<title><![CDATA[Re: Exporting TVK]]></title>
			<link>https://forums.nbn.org.uk/viewtopic.php?pid=30610#p30610</link>
			<description><![CDATA[<p>Lindsay,</p><p>We had the same problem and you managed to get the information on how to implement TVK in Report Wizard from Mark Pollitt. Can you connect to the linked Access database. If you can then I can send you details of how to do it.</p><p>Charlie</p><p>Scottish Wildlife Trust</p>]]></description>
			<author><![CDATA[null@example.com (CharlieDarling)]]></author>
			<pubDate>Tue, 15 Feb 2022 17:06:58 +0000</pubDate>
			<guid>https://forums.nbn.org.uk/viewtopic.php?pid=30610#p30610</guid>
		</item>
		<item>
			<title><![CDATA[Exporting TVK]]></title>
			<link>https://forums.nbn.org.uk/viewtopic.php?pid=30606#p30606</link>
			<description><![CDATA[<p>Is there a way to include the TVK in a report as part of a record?&nbsp; I can&#039;t see it as an option in the report wizard.&nbsp; I&#039;m aware of the online TVK matching tool at <a href="https://uksi-sandbox.nhm.ac.uk/taxonmatch.php">https://uksi-sandbox.nhm.ac.uk/taxonmatch.php</a> but seems an additional unnecessary step when the info is in Recorder already but I just can&#039;t seem to get it out...</p><p>Thanks,<br />Linds</p>]]></description>
			<author><![CDATA[null@example.com (Lindsay_FifeNature)]]></author>
			<pubDate>Thu, 10 Feb 2022 16:16:44 +0000</pubDate>
			<guid>https://forums.nbn.org.uk/viewtopic.php?pid=30606#p30606</guid>
		</item>
	</channel>
</rss>
