1 Topic by mikee

  • mikee
  • Member
  • Offline
  • Registered: 13-03-2013
  • Posts: 33

Topic: Problem with CSV Occurence importer

While importing occurences I'm  getting errors as detailed in the returned error CSV below

Species Name,CMS Username,Abundance,Location name,Grid Ref,Date,Comment,Problem,Row no.
ringlet butterfly,chloe griffiths,4 adults,"Coed Phoenix Nature Reserve, Mynydd Brith, Bronant, Ceredigion.",SN629664,10/07/2013,,"Could not find a Taxa Taxon List by looking for ""ringlet butterfly"" in the Taxon field.",2
red admiral,chloe griffiths,1 adult,"Coed Phoenix Nature Reserve, Mynydd Brith, Bronant, Ceredigion.",SN629664,10/07/2013,,"Could not find a Taxa Taxon List by looking for ""red admiral"" in the Taxon field.",3

The rejected species do exist in the DB.  I can successfully import into my test setup but not the live system.  There's 650 ocurrence in the CSV.
Using instant-indicia-0.8.2.zip and indicia-0.8.1b.zip for the Warehouse.

Any thoughts?

2 Reply by mikee

  • mikee
  • Member
  • Offline
  • Registered: 13-03-2013
  • Posts: 33

Re: Problem with CSV Occurence importer

Update:

On using the warehouse backend to upload the occurrence data I see that the Species list: dropdown is always greyed out no matter what website is selected.  Methinks this may be relevant but what to try next.

http://picpaste.com/pics/indicia_upload … 414308.png

3 Reply by mikee

  • mikee
  • Member
  • Offline
  • Registered: 13-03-2013
  • Posts: 33

Re: Problem with CSV Occurence importer

Ah fixed that last error, taxon list had to be owned by the website. 

Now I get "Please specify a value for the Survey." Eevn though I did exactly that.

4 Reply by mikee

  • mikee
  • Member
  • Offline
  • Registered: 13-03-2013
  • Posts: 33

Re: Problem with CSV Occurence importer

Another aha moment.  "Survey" in my previous message may not refer to the Survey as I have bunch of radio buttons with the label Survey.  Code below from a typical input page:

<label>Survey:</label>
<span  class="control-box "><nobr><span><input type="radio" name="occAttr:4" id="occAttr:4:0" value="116" class="{required:true, required:true} first-item" /><label for="occAttr:4:0">WWBIC</label></span></nobr> <nobr><span><input type="radio" name="occAttr:4" id="occAttr:4:1" value="117" class="{required:true, required:true}" /><label for="occAttr:4:1">INNS</label></span></nobr> <nobr><span><input type="radio" name="occAttr:4" id="occAttr:4:2" value="118" class="{required:true, required:true}" /><label for="occAttr:4:2">WTSWW</label></span></nobr> <nobr><span><input type="radio" name="occAttr:4" id="occAttr:4:3" value="119" class="{required:true, required:true}" /><label for="occAttr:4:3">Green Phoenix</label></span></nobr> </span><span id="occAttr:4_lock" class="unset-lock">&nbsp;</span><span class="deh-required">*</span><br/>

So now the problem becomes how to specify that in the Form's Preset Settings?

Ok solved it, added  occAttr:4:0=116