1 Topic by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Topic: Strange Import behaviour

I don't know if something has been changed in the Import routine because I've never encountered this before

We have just done an import where the Abundance data for one record was '>5 adult' however, when the data were imported, this Taxon Occurrence had two measurements: '5 adult' and '& gt' where gt was the measurement qualifier

It would appear the import routine converted the '>' symbol into its HTML code of '>' and then parsed that as an addition measurement

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by MikeWeideli

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

Re: Strange Import behaviour

I don't think anything  has changed in the abundance parsing for a long time.   I will investigate.

Mike Weideli

MikeWeideli's Website

3 Reply by MikeWeideli

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

Re: Strange Import behaviour

I can't duplicate this using input in Excel. Could it be something in the import file format ?

Mike Weideli

MikeWeideli's Website

4 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Strange Import behaviour

It was an XLSX file

Craig Slawson
Staffordshire Ecological Record

ser's Website

5 Reply by charliebarnes

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

Re: Strange Import behaviour

Do you know what computer the file come from and what program generated it?

XLSX stores > as > and it sounds like that has got mangled somehow. Opening up the raw contents of the XLSX would probably show you where the problem is (if there is one in the file).

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

6 Reply by BDeed

  • BDeed
  • Veteran
  • Offline
  • From: Bolton
  • Registered: 01-03-2011
  • Posts: 451

Re: Strange Import behaviour

We've also been having some import issues since upgrading Windows to 10 so just in case its useful be aware that system settings in W10 will override program settings. This has been a particular issue around dates where the system was set to English (US) an impacted on Microsoft Office programs as well as the likes of MapInfo and some others. Similar issues have been encountered with special characters and moving between text and spreadsheet formats..

Natural History & Biodiversity Data Enthusiast

7 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Strange Import behaviour

I'm about to do another import which include '>' in abundance, I'll let you know the result

Craig Slawson
Staffordshire Ecological Record

ser's Website