1 Reply by Lizzy Peat

  • Lizzy Peat
  • Lizzy Peat
  • Member
  • Offline
  • From: Hampshire (HBIC)
  • Registered: 17-05-2006
  • Posts: 38

Re: Recorder 6 Import, abundance qualifiers

Hello,

I'm currently running through an import from Excel using the import wizard, all fine and dandy, until the abundance qualifiers selection page where I selected a recorder match, when I should have clicked 'Make new entry'.

How can I undo this? I have tried doing 'previous' and then back to the abundance page, and even tried starting the import again from scratch, but it has helpfully remembered what I put in last time. I can't seem to delete it or anything, I just want to change it to a new entry.

I also have an abundance qualifier which has not appeared in the 'imported Data' column, I wanted to make it a new entry too but it isn't there. Um.

Thank you for any help,

Lizzy Peat
HBIC

Lizzy Peat's Website

2 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Recorder 6 Import, abundance qualifiers

Hi Lizzy,

If you can get into the database, here's what you need to do: find the IW_Matched _Abundance_Qualifiers table, then locate the qualifier you accidentally matched and delete that row. If you want to clear any of the import wizard's 'remembered matches', just clear the entries in the IW_* tables.

Regarding the qualifier that isn't appearing, could you post the exact content of the cell in the spreadsheet containing the qualifier so I can have a look.

Cheers,

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

3 Reply by Lizzy Peat

  • Lizzy Peat
  • Lizzy Peat
  • Member
  • Offline
  • From: Hampshire (HBIC)
  • Registered: 17-05-2006
  • Posts: 38

Re: Recorder 6 Import, abundance qualifiers

Thanks Charles. 

Here is the cell in the spreadsheet;

5male, 1female, 1undetermined, 1porcelaindisease


best,

Lizzy Peat
HBIC

Lizzy Peat's Website

4 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Recorder 6 Import, abundance qualifiers

Try removing the commas or, alternatively, try adding a space between the number and each qualifier, e.g.

5male 1female 1undetermined 1porcelaindisease

OR

5 male, 1 female, 1 undetermined, 1 porcelaindisease

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

5 Reply by Lizzy Peat

  • Lizzy Peat
  • Lizzy Peat
  • Member
  • Offline
  • From: Hampshire (HBIC)
  • Registered: 17-05-2006
  • Posts: 38

Re: Recorder 6 Import, abundance qualifiers

Hi Charles,

Removing the commas as suggested lead to an unhandled error just after defining the column names and clicking next-
blah blah.. EOleException : String or binary data would be truncated. . .blah blah

5 male, 1 female, 1 undetermined, 1 porcelaindisease
still didn't pick up the porcelaindisease.

I also tried 5 male, 1 female, 1 undetermined, 1 porcelaindisease,
but that didn't pick up the porcelaindisease either.

Moving the porcelaindisease from the end of the text (rather bizarrely) did work- 
5 male, 1 female, 1 porcelaindisease, 1 undetermined

Does this mean new qualifiers found on the end of text in cells is missed during imports, or is it just us?

Regards,

Lizzy Peat
HBIC

Lizzy Peat's Website

6 Reply by davec (edited by davec 24-01-2007 09:33:17)

  • davec
  • Veteran
  • Offline
  • From: Brecon, Powys, Wales
  • Registered: 11-05-2006
  • Posts: 108

Re: Recorder 6 Import, abundance qualifiers

Hi Lizy,

In the data below there is a trailing comma. I don't know if that line is the actual data, or the extra comma is a typo on the forum message, but it may be the source of the problem.

Just an idea.

Otherwise an odd problem.

Lizzy Peat wrote:

I also tried 5 male, 1 female, 1 undetermined, 1 porcelaindisease,

Regards.

Dave Cope,
Biodiversity Technology Officer,
Biodiversity Information Service for Powys and Brecon Beacons National Park.

davec's Website

7 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Recorder 6 Import, abundance qualifiers

This is indeed an odd one. Removal of the commas should work and the error would probably indicate some sort of bug in the import wizard. As for missing off the last qualifier; I have no idea why it's doing that.

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

8 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Recorder 6 Import, abundance qualifiers

Just a thought: instead of "porcelaindisease", have you tried something shorter, like "pd"?

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

9 Reply by Sarah Shaw

  • Sarah Shaw
  • Veteran
  • Offline
  • Registered: 23-06-2006
  • Posts: 267

Re: Recorder 6 Import, abundance qualifiers

Hi

I've done some investigating and can reproduce this problem. The sticking point here appears to be column width in the import file.

So if you increase the abundance column width in excel then R6 no longer ignores 'porcelaindisease'.

Lizzy- could you give this a try and let me know?

I'm not sure if something like this has been raised before, so I'll have to go back and check.

Either way, I can put this forward to be fixed (however it will be the version after next one now I'm afraid).

Kind regards,

Sarah

Sarah Shaw
Biodiversity Information Assistant
JNCC

Sarah Shaw
Biodiversity Information Assistant
JNCC

10 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Recorder 6 Import, abundance qualifiers

Ah, I did report something along these lines a while ago but it was rejected. Sarah, have a look at point 1 in my incident report 12603.

A neat way to work around this problem is to select the whole spreadsheet (click the grey 'button' to the left of the A column header) and then double-click the divider between any two column headers. This will auto-size each column to a suitable width.

Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

11 Reply by Lizzy Peat

  • Lizzy Peat
  • Lizzy Peat
  • Member
  • Offline
  • From: Hampshire (HBIC)
  • Registered: 17-05-2006
  • Posts: 38

Re: Recorder 6 Import, abundance qualifiers

Um, sorry people,
this problem isn't due to the column width in excel as all columns are fine and dandy, I have just double checked.

Changing Porcelain disease to pd as Charles suggested solves the problem, no matter where in the cell it is.
What foxes me is why 'porcelaindisease' imports quite happily if it isn't on the end of the measurements column, but if it is on the end it doesn't register;

5 male, 1 porcelaindisease, 1 undetermined - porcelaindisease appears in the 'Recorder matches' column
5 male, 1 undetermined, 1 porcelaindisease - porcelaindisease does not appear in the 'Recorder matches' column.

This strikes me as weird.
Best,

Lizzy Peat
HBIC

Lizzy Peat's Website