1 Topic by niki.clear

  • niki.clear
  • Member
  • Offline
  • Registered: 27-02-2015
  • Posts: 8

Topic: Importing verified records

Hi,
I want to upload data using the csv importer which has already been verified and validated, and I don't want to have to go through the verification process again through the verification form. Is it possible to pre-set records as verified?

I would have thought I would use the ‘Record Status’ and set this as 'verified' in the csv importer sheet, but there are no relevant attributes to map to. So I have tried to include a ‘Verified by’ column with my username, mapped to the ‘Verified by’ attribute, but this failed and returned the following error;
“Verified_by: Could not find a User by looking for "Clear, Niki" in the Username field“

How best would I set up the csv importer sheet to set the records as ‘verified’.

Thanks,
Niki

2 Reply by Jim Bacon

  • Jim Bacon
  • Veteran
  • Offline
  • From: BRC
  • Registered: 03-11-2008
  • Posts: 980

Re: Importing verified records

Hi

I guess you are doing this through a Drupal-based website rather than the warehouse interface. I.e. you would be following the instructions at http://indicia-docs.readthedocs.org/en/ … orter.html

A glance at that suggests to me that a preset of 

occurrence:record_status=V

might achieve what you want.

It would be good if you could get the verifier name to work as well. I'm not clear if it is looking for your Drupal username or your Indicia username. They are not necessarily the same. If you verified all the records then you could add another preset like

occurrence:verified_by_id=your-indicia-user-id

This is all theory on my part. If you want to give it a try, I recommend you use a csv file with just one or two of your records.

Jim Bacon

3 Reply by niki.clear

  • niki.clear
  • Member
  • Offline
  • Registered: 27-02-2015
  • Posts: 8

Re: Importing verified records

That worked.

Thanks Jim!