1 Topic by philr

  • philr
  • Veteran
  • Offline
  • From: CPERC
  • Registered: 12-07-2012
  • Posts: 53

Topic: The letter D

It seems that Recorder does not like the letter D anymore!

Since upgrading to 6.30.0.291 when importing records with a DAFOR column the letter 'D' is missed out completely. This must be some sort of new bug. This is nothing to do with the column type you set for the column as it happens before you get to that stage.

When I tested it in lower case 'd' it comes through, therefore the issue just seems to be with 'D' on its own.

It is a bit annoying as you then have to add all the DAFOR D abundances to those records one by one after the import.

Phil

2 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,384

Re: The letter D

Fascinating... I can confirm!

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

3 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,384

Re: The letter D

What version of SQL Server are you on? We have some apparently imported Dafor 'D's, but this looks like it might have been before we upgraded to SQL server 2019.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

4 Reply by philr

  • philr
  • Veteran
  • Offline
  • From: CPERC
  • Registered: 12-07-2012
  • Posts: 53

Re: The letter D

We are on an earlier version than 2019, but I can't access the server at the moment to check which version. So it probably won't be because of the SQL server version.

5 Reply by charliebarnes (edited by charliebarnes 25-08-2022 14:57:14)

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,384

Re: The letter D

See https://forums.nbn.org.uk/viewtopic.php?pid=7896#p7896

... not sure what else to say except that moving the column fixes it for me.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website