1 Topic by HarryClarke

  • HarryClarke
  • Veteran
  • Offline
  • From: Surrey
  • Registered: 11-10-2011
  • Posts: 99

Topic: Batch update - changing subspecies

I want to run a batch update to correct an error, that changes the subspecies for all relevant records.
I tried running Det1, but was presented with the error message "Must declare the scalar variable "@New_TLI_Key"

I notice that there have been reported problems in the past, so I tried running Det3 which ran without problem, returning almost immediately. I chose the incorrect subspecies and correct subspecies from the same checklist.
On running a report, I find that no changes have occurred and the old subspecies is still present.

Running the latest version of Recorder 6 and dictionaries.

What do I need to do to?

Harry Clarke
Surrey County Butterfly Recorder

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Batch update - changing subspecies

It looks like it should work.  I wonder if the  Taxon_List_Item key for the incorrect species is correct. It  needs to be the one used for the input, which may not have been the preferred list.  If you have the extra info addin installed you can get  the actual key from there.  Alternatively report H7 (It is is in System Supplied Reports/Information) will list all species in the system with the TLI key used. If you have used the correct key, then I will  do some more tests.

I have had a quick go at fixing Det 1 attached, but i think Det3 is a safer bet.

Post's attachments

JNCCDet1Determinations.xml 3.81 kb, 1 downloads since 2016-08-07 

You don't have the permssions to download the attachments of this post.
Mike Weideli

MikeWeideli's Website

3 Reply by HarryClarke

  • HarryClarke
  • Veteran
  • Offline
  • From: Surrey
  • Registered: 11-10-2011
  • Posts: 99

Re: Batch update - changing subspecies

When I ran Det2, I ran it choosing the subspecies from the Agassiz Checklist that was used to enter the data. Checking on one record, I am presented with the following information

As entered
Taxon List Item Key = NHYSYS0021135555
Taxon Gatekeeper or Hedge Brown
Taxon List = LEPIDOPTERA ...(Agassiz...)

Prefereed
Taxon List Item Key = NHYSYS0021137892
Taxon Pyronia tithonus tithonus (Linnaeus, 1771)
Taxon List = LEPIDOPTERA ...(Agassiz...)

Recommended
Taxon List Item Key = NHYSYS0000499678
Taxon Pyronia tithonus subsp. tithonus (Linnaeus, 1771)
Taxon List = Checklist of Lepidopetera ... (..Bradley, 2000)

This was some data that I imported this year, and I would have used the Agassiz checklist.

Harry Clarke
Surrey County Butterfly Recorder

4 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Batch update - changing subspecies

Thanks. I will look again.

Mike Weideli

MikeWeideli's Website

5 Reply by HarryClarke

  • HarryClarke
  • Veteran
  • Offline
  • From: Surrey
  • Registered: 11-10-2011
  • Posts: 99

Re: Batch update - changing subspecies

I tried running Det3 again, without success.
I then tried running the modified Det1, which ran, and seemed to work, in that the subspecies name had been changed for all 941 instances. However, when I click on the "Extra Info" button for one of the changed entries, the query times out. But it works OK with other entries not modified.
What should I do, leave the database as is, or restore back to the version prior to the update?

Harry Clarke
Surrey County Butterfly Recorder

6 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Batch update - changing subspecies

Slightly worrying that addin timed out. I suggest that you restore from backup. I will see if I can see any reason for the time out and also run Det1 myself and see what it actually does.

Mike Weideli

MikeWeideli's Website

7 Reply by HarryClarke

  • HarryClarke
  • Veteran
  • Offline
  • From: Surrey
  • Registered: 11-10-2011
  • Posts: 99

Re: Batch update - changing subspecies

I found that the usual options for database management (e.g. restore) where all missing. On exiting Recorder 6, it stated that I had a number of uncommitted batch updates, which I responded positively to. On restarting Recorder 6, full functionality had been returned. On checking the entries that I had modified, I found that "Extra Info" button now worked and returned the following information

As Entered
Taxon List Item Key = NHYSYS0021137891
Taxon Pyronia tithonus britanniae (Verity, 1915)
Taxon List = LEPIDOPTERA ...(Agassiz...)

Preferred
Taxon List Item Key = NHYSYS0021137891
Taxon Pyronia tithonus britanniae (Verity, 1915)
Taxon List = LEPIDOPTERA ...(Agassiz...)

Recommended
Taxon List Item Key = NHYSYS0000499677
Taxon Pyronia tithonus subsp. britanniae (Verity, 1915)
Taxon List = Checklist of Lepidopetera ... (..Bradley, 2000)

Harry Clarke
Surrey County Butterfly Recorder

8 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Batch update - changing subspecies

I think I have worked this all out now. Det 3 doesn't run because the taxon is being held as a common name and it only works on a preferred name. Det 1 uses a different approach and I think the revised version  works, but there is a problem with it which stops it being run more than once without closing Recorder.

If you view the records  then you need to commit the changes via the tools menu, or close Recorder and open it again. Otherwise the Extra Info addin doesn't work on the record.

Mike Weideli

MikeWeideli's Website

9 Reply by HarryClarke

  • HarryClarke
  • Veteran
  • Offline
  • From: Surrey
  • Registered: 11-10-2011
  • Posts: 99

Re: Batch update - changing subspecies

Thanks Mike
Committing the changes enables "Extra Info" to work. But, you have to stop Recorder 6 to be able to run another Batch job, as it says there a New table already exists.
All the changes I wanted to make seemed to have worked OK now using the modified Det1.

Harry Clarke
Surrey County Butterfly Recorder