Project

General

Profile

« Previous | Next » 

Revision 11957

Added by Aaron Marcuse-Kubitza about 11 years ago

added inputs/VegBank/projectcontributor_/

View differences:

inputs/VegBank/projectcontributor_/create.sql
1 
SELECT *
2 
FROM projectcontributor
3 
LEFT JOIN party USING (party_id)
inputs/VegBank/projectcontributor_/header.csv
1 
party_id,projectcontributor_id,project_id,role_id,projectcontributor_surname,cheatrole,salutation,givenname,middlename,surname,organizationname,currentname_id,contactinstructions,email,partytype,partypublic,party_d_obscount,accessioncode
inputs/VegBank/projectcontributor_/run
1 
#!/bin/bash -e
2 
. "$(dirname "${BASH_SOURCE[0]}")"/../table.run
0 3 

  		












  

    
      inputs/VegBank/projectcontributor_/map.csv
    
  





  
  1
  
    
VegBank,VegCore,Filter,Comments


  		




  
  2
  
    
party_id,*projectcontributor_--party_id,,


  		




  
  3
  
    
projectcontributor_id,*projectcontributor_--projectcontributor_id,,


  		




  
  4
  
    
project_id,projectID,,


  		




  
  5
  
    
role_id,*projectcontributor_--role_id,,


  		




  
  6
  
    
projectcontributor_surname,*projectcontributor_--projectcontributor_surname,,


  		




  
  7
  
    
cheatrole,*projectcontributor_--cheatrole,,


  		




  
  8
  
    
salutation,*projectcontributor_--salutation,,


  		




  
  9
  
    
givenname,*projectcontributor_--givenname,,


  		




  
  10
  
    
middlename,*projectcontributor_--middlename,,


  		




  
  11
  
    
surname,*projectcontributor_--surname,,


  		




  
  12
  
    
organizationname,*projectcontributor_--organizationname,,


  		




  
  13
  
    
currentname_id,*projectcontributor_--currentname_id,,


  		




  
  14
  
    
contactinstructions,*projectcontributor_--contactinstructions,,


  		




  
  15
  
    
email,*projectcontributor_--email,,


  		




  
  16
  
    
partytype,*projectcontributor_--partytype,,


  		




  
  17
  
    
partypublic,*projectcontributor_--partypublic,,


  		




  
  18
  
    
party_d_obscount,*projectcontributor_--party_d_obscount,,


  		




  
  19
  
    
accessioncode,*projectcontributor_--accessioncode,,


  		












  

    
      inputs/VegBank/projectcontributor_/VegBIEN.csv
    
  





  
  1
  
    
link ../../../mappings/VegCore-VegBIEN.csv


  		




  0
  2
  
    

  		












  

    
      inputs/VegBank/projectcontributor_/test.xml.ref
    
  





  
  1
  
    
<!--put template-->


  		




  
  2
  
    
<VegBIEN>


  		




  
  3
  
    
    <_setDefault id="-1">


  		




  
  4
  
    
        <source_id><source><shortname>VegBank.new</shortname></source></source_id>


  		




  
  5
  
    
        <path>


  		




  
  6
  
    
            <_simplifyPath>


  		




  
  7
  
    
                <next>parent_id</next>


  		




  
  8
  
    
                <path><location><locationevent><project_id><project><sourceaccessioncode>$projectID</sourceaccessioncode></project></project_id></locationevent></location></path>


  		




  
  9
  
    
            </_simplifyPath>


  		




  
  10
  
    
        </path>


  		




  
  11
  
    
    </_setDefault>


  		




  
  12
  
    
</VegBIEN>


  		




  
  13
  
    
Inserted 3 new rows into database


  		












  

    
      inputs/VegBank/projectcontributor_/new_terms.csv
    
  





  
  1
  
    
party_id,*projectcontributor_--party_id,,


  		




  
  2
  
    
projectcontributor_id,*projectcontributor_--projectcontributor_id,,


  		




  
  3
  
    
role_id,*projectcontributor_--role_id,,


  		




  
  4
  
    
cheatrole,*projectcontributor_--cheatrole,,


  		




  
  5
  
    
salutation,*projectcontributor_--salutation,,


  		




  
  6
  
    
givenname,*projectcontributor_--givenname,,


  		




  
  7
  
    
middlename,*projectcontributor_--middlename,,


  		




  
  8
  
    
surname,*projectcontributor_--surname,,


  		




  
  9
  
    
organizationname,*projectcontributor_--organizationname,,


  		




  
  10
  
    
currentname_id,*projectcontributor_--currentname_id,,


  		




  
  11
  
    
contactinstructions,*projectcontributor_--contactinstructions,,


  		




  
  12
  
    
email,*projectcontributor_--email,,


  		




  
  13
  
    
partytype,*projectcontributor_--partytype,,


  		




  
  14
  
    
partypublic,*projectcontributor_--partypublic,,


  		




  
  15
  
    
party_d_obscount,*projectcontributor_--party_d_obscount,,


  		




  
  16
  
    
accessioncode,*projectcontributor_--accessioncode,,


  		












  

    
      inputs/VegBank/projectcontributor_/unmapped_terms.csv
    
  





  
  1
  
    
*projectcontributor_--party_id


  		




  
  2
  
    
*projectcontributor_--projectcontributor_id


  		




  
  3
  
    
*projectcontributor_--role_id


  		




  
  4
  
    
*projectcontributor_--projectcontributor_surname


  		




  
  5
  
    
*projectcontributor_--cheatrole


  		




  
  6
  
    
*projectcontributor_--salutation


  		




  
  7
  
    
*projectcontributor_--givenname


  		




  
  8
  
    
*projectcontributor_--middlename


  		




  
  9
  
    
*projectcontributor_--surname


  		




  
  10
  
    
*projectcontributor_--organizationname


  		




  
  11
  
    
*projectcontributor_--currentname_id


  		




  
  12
  
    
*projectcontributor_--contactinstructions


  		




  
  13
  
    
*projectcontributor_--email


  		




  
  14
  
    
*projectcontributor_--partytype


  		




  
  15
  
    
*projectcontributor_--partypublic


  		




  
  16
  
    
*projectcontributor_--party_d_obscount


  		




  
  17
  
    
*projectcontributor_--accessioncode


  		












Also available in:  Unified diff