Revision 11987
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/SALVIAS/party_code_party_/create.sql | ||
|---|---|---|
| 1 |
SELECT * |
|
| 2 |
FROM party_code_party |
|
| 3 |
LEFT JOIN party USING (party_id) |
|
| 4 |
; |
|
| trunk/inputs/SALVIAS/party_code_party_/header.csv | ||
|---|---|---|
| 1 |
party_id,party_code,fullname,party_type,firstname,middle_inits,lastname,email,Institution,state_province,country |
|
| trunk/inputs/SALVIAS/party_code_party_/run | ||
|---|---|---|
| 1 |
#!/bin/bash -e |
|
| 2 |
. "$(dirname "${BASH_SOURCE[0]}")"/../table.run
|
|
| 0 | 3 | |
| trunk/inputs/SALVIAS/party_code_party_/map.csv | ||
|---|---|---|
| 1 |
SALVIAS,VegCore,Filter,Comments |
|
| 2 |
party_id,*party_code_party_--party_id,, |
|
| 3 |
party_code,*party_code,, |
|
| 4 |
fullname,*party_code_party_--fullname,, |
|
| 5 |
party_type,*party_code_party_--party_type,, |
|
| 6 |
firstname,*party_code_party_--firstname,, |
|
| 7 |
middle_inits,*party_code_party_--middle_inits,, |
|
| 8 |
lastname,*party_code_party_--lastname,, |
|
| 9 |
email,*party_code_party_--email,, |
|
| 10 |
Institution,*party_code_party_--Institution,, |
|
| 11 |
state_province,*party_code_party_--state_province,, |
|
| 12 |
country,*party_code_party_--country,, |
|
| trunk/inputs/SALVIAS/party_code_party_/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| trunk/inputs/SALVIAS/party_code_party_/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN/>Inserted 0 new rows into database |
|
| trunk/inputs/SALVIAS/party_code_party_/new_terms.csv | ||
|---|---|---|
| 1 |
party_id,*party_code_party_--party_id,, |
|
| 2 |
fullname,*party_code_party_--fullname,, |
|
| 3 |
party_type,*party_code_party_--party_type,, |
|
| 4 |
firstname,*party_code_party_--firstname,, |
|
| 5 |
middle_inits,*party_code_party_--middle_inits,, |
|
| 6 |
lastname,*party_code_party_--lastname,, |
|
| 7 |
email,*party_code_party_--email,, |
|
| 8 |
Institution,*party_code_party_--Institution,, |
|
| trunk/inputs/SALVIAS/party_code_party_/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*party_code_party_--party_id |
|
| 2 |
*party_code |
|
| 3 |
*party_code_party_--fullname |
|
| 4 |
*party_code_party_--party_type |
|
| 5 |
*party_code_party_--firstname |
|
| 6 |
*party_code_party_--middle_inits |
|
| 7 |
*party_code_party_--lastname |
|
| 8 |
*party_code_party_--email |
|
| 9 |
*party_code_party_--Institution |
|
| 10 |
*party_code_party_--state_province |
|
| 11 |
*party_code_party_--country |
|
Also available in: Unified diff
mapped inputs/SALVIAS/party_code_party_/