Project

General

Profile

« Previous | Next » 

Revision 11960

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/VegBank/projectcontributor_/map.csv, postprocess.sql: added project_participant

View differences:

inputs/VegBank/projectcontributor_/postprocess.sql
1 
SELECT util.search_path_append('util');
2 

  		




  
  3
  
    

  		




  
  4
  
    
SELECT mk_derived_col((:table_str, 'project_participant'),


  		




  
  5
  
    
$$_join_words(project_participant_name_first::text, project_participant_name_middle::text, project_participant_name_last::text)$$)


  		




  
  6
  
    
; -- runtime: ~0 ("2.887 ms") @starscream


  		












  

    
      inputs/VegBank/projectcontributor_/map.csv
    
  





  6
  6
  
    
projectcontributor_surname,*projectcontributor_--projectcontributor_surname,,


  		




  7
  7
  
    
cheatrole,*projectcontributor_--cheatrole,,


  		




  8
  8
  
    
salutation,*projectcontributor_--salutation,,


  		




  9
  
  
    
givenname,*projectcontributor_--givenname,,


  		




  10
  
  
    
middlename,*projectcontributor_--middlename,,


  		




  11
  
  
    
surname,*projectcontributor_--surname,,


  		




  
  9
  
    
givenname,project_participant_name_first,,


  		




  
  10
  
    
middlename,project_participant_name_middle,,


  		




  
  11
  
    
surname,project_participant_name_last,,


  		




  12
  12
  
    
organizationname,*projectcontributor_--organizationname,,


  		




  13
  13
  
    
currentname_id,*projectcontributor_--currentname_id,,


  		




  14
  14
  
    
contactinstructions,*projectcontributor_--contactinstructions,,


  		












  

    
      inputs/VegBank/projectcontributor_/test.xml.ref
    
  





  5
  5
  
    
        <path>


  		




  6
  6
  
    
            <_simplifyPath>


  		




  7
  7
  
    
                <next>parent_id</next>


  		




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


  		




  
  8
  
    
                <path>


  		




  
  9
  
    
                    <location>


  		




  
  10
  
    
                        <locationevent>


  		




  
  11
  
    
                            <project_id>


  		




  
  12
  
    
                                <project>


  		




  
  13
  
    
                                    <projectcontributor><party_id><party><fullname>$project_participant</fullname></party></party_id></projectcontributor>


  		




  
  14
  
    
                                    <sourceaccessioncode>$projectID</sourceaccessioncode>


  		




  
  15
  
    
                                </project>


  		




  
  16
  
    
                            </project_id>


  		




  
  17
  
    
                        </locationevent>


  		




  
  18
  
    
                    </location>


  		




  
  19
  
    
                </path>


  		




  9
  20
  
    
            </_simplifyPath>


  		




  10
  21
  
    
        </path>


  		




  11
  22
  
    
    </_setDefault>


  		




  12
  23
  
    
</VegBIEN>


  		




  13
  
  
    
Inserted 3 new rows into database


  		




  
  24
  
    
Inserted 5 new rows into database


  		












  

    
      inputs/VegBank/projectcontributor_/new_terms.csv
    
  





  1
  1
  
    
party_id,*projectcontributor_--party_id,,


  		




  2
  2
  
    
projectcontributor_id,*projectcontributor_--projectcontributor_id,,


  		




  3
  3
  
    
role_id,*projectcontributor_--role_id,,


  		




  
  4
  
    
projectcontributor_surname,*projectcontributor_--projectcontributor_surname,,


  		




  4
  5
  
    
cheatrole,*projectcontributor_--cheatrole,,


  		




  5
  6
  
    
salutation,*projectcontributor_--salutation,,


  		




  6
  
  
    
givenname,*projectcontributor_--givenname,,


  		




  7
  
  
    
middlename,*projectcontributor_--middlename,,


  		




  8
  
  
    
surname,*projectcontributor_--surname,,


  		




  
  7
  
    
givenname,project_participant_name_first,,


  		




  
  8
  
    
middlename,project_participant_name_middle,,


  		




  
  9
  
    
surname,project_participant_name_last,,


  		




  9
  10
  
    
organizationname,*projectcontributor_--organizationname,,


  		




  10
  11
  
    
currentname_id,*projectcontributor_--currentname_id,,


  		




  11
  12
  
    
contactinstructions,*projectcontributor_--contactinstructions,,


  		












  

    
      inputs/VegBank/projectcontributor_/unmapped_terms.csv
    
  





  4
  4
  
    
*projectcontributor_--projectcontributor_surname


  		




  5
  5
  
    
*projectcontributor_--cheatrole


  		




  6
  6
  
    
*projectcontributor_--salutation


  		




  7
  
  
    
*projectcontributor_--givenname


  		




  8
  
  
    
*projectcontributor_--middlename


  		




  9
  
  
    
*projectcontributor_--surname


  		




  
  7
  
    
project_participant_name_first


  		




  
  8
  
    
project_participant_name_middle


  		




  
  9
  
    
project_participant_name_last


  		




  10
  10
  
    
*projectcontributor_--organizationname


  		




  11
  11
  
    
*projectcontributor_--currentname_id


  		




  12
  12
  
    
*projectcontributor_--contactinstructions


  		












Also available in:  Unified diff