Schnittstelle CampusOnline (TU Graz) zu SuperX-Modul COSTAGE
http://www.superx-projekt.de/doku/costage_modul/
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
71 lines
6.2 KiB
71 lines
6.2 KiB
--Freemarker Template |
|
|
|
<#assign files = [ |
|
{"srcfile":"px_st_abschlussziele_amtstat_v.csv", "targettable":"costage_st_abschlussziele_amtstat", "targetfile":"costage_st_abschlussziele_amtstat.unl"}, |
|
{"srcfile":"px_st_abschlussziele_lokal_v.csv", "targettable":"costage_st_abschlussziele_lokal", "targetfile":"costage_st_abschlussziele_lokal.unl"}, |
|
{"srcfile":"px_st_fachsemester_v.csv", "targettable":"costage_st_fachsemester", "targetfile":"costage_st_fachsemester.unl"}, |
|
{"srcfile":"px_st_fakultaeten_v.csv", "targettable":"costage_st_fakultaeten", "targetfile":"costage_st_fakultaeten.unl"}, |
|
{"srcfile":"px_st_hauptstudien_v.csv", "targettable":"costage_st_hauptstudien", "targetfile":"costage_st_hauptstudien.unl"}, |
|
{"srcfile":"px_st_hoererstatus_v.csv", "targettable":"costage_st_hoererstatus", "targetfile":"costage_st_hoererstatus.unl"}, |
|
{"srcfile":"px_st_laender_v.csv", "targettable":"costage_st_laender", "targetfile":"costage_st_laender.unl"}, |
|
{"srcfile":"px_st_land_regionen_v.csv", "targettable":"costage_st_land_regionen", "targetfile":"costage_st_land_regionen.unl"}, |
|
{"srcfile":"px_st_semester_v.csv", "targettable":"costage_st_semester_neu", "targetfile":"costage_st_semester.unl"}, |
|
{"srcfile":"px_st_studienarten_v.csv", "targettable":"costage_st_studienarten", "targetfile":"costage_st_studienarten.unl"}, |
|
{"srcfile":"px_st_studienfaecher_v.csv", "targettable":"costage_st_studienfaecher", "targetfile":"costage_st_studienfaecher.unl"}, |
|
{"srcfile":"px_st_studiengaenge_mtsg_v.csv", "targettable":"costage_st_studiengaenge_mtsg", "targetfile":"costage_st_studiengaenge_mtsg.unl"}, |
|
{"srcfile":"px_st_studiengaenge_v.csv", "targettable":"costage_st_studiengaenge_neu", "targetfile":"costage_st_studiengaenge.unl"}, |
|
{"srcfile":"px_st_studienkennzahlen_v.csv", "targettable":"costage_st_studienkennzahlen_neu", "targetfile":"costage_st_studienkennzahlen.unl", "specialrule":""}, |
|
{"srcfile":"px_st_studienstatus_v.csv", "targettable":"costage_st_studienstatus", "targetfile":"costage_st_studienstatus.unl"}, |
|
{"srcfile":"px_st_studien_spoversionen_v.csv", "targettable":"costage_st_studien_spoversionen", "targetfile":"costage_st_studien_spoversionen.unl"}, |
|
{"srcfile":"px_st_studien_v.csv", "targettable":"costage_st_studien", "targetfile":"costage_st_studien.unl"}, |
|
{"srcfile":"px_st_studierendenstammdaten_v.csv", "targettable":"costage_st_studierendenstammdaten_neu", "targetfile":"costage_st_studierendenstammdaten.unl", "specialrule":"update costage_st_studierendenstammdaten_neu set aufnahmedatum=now() where st_studstamm_nr=419856"}, |
|
{"srcfile":"px_st_hzb_v.csv", "targettable":"costage_st_hzb", "targetfile":"costage_st_hzb.unl", "specialrule":""}, |
|
{"srcfile":"px_bw_bewerbungen_v.csv", "targettable":"costage_bw_bewerbungen", "targetfile":"costage_bw_bewerbungen.unl"}, |
|
{"srcfile":"px_bw_bewerbung_kombination_v.csv", "targettable":"costage_bw_bewerbung_kombination", "targetfile":"costage_bw_bewerbung_kombination.unl"}, |
|
{"srcfile":"px_bw_bewerb_hzb_v.csv", "targettable":"costage_bw_bewerb_hzb", "targetfile":"costage_bw_bewerb_hzb.unl"}, |
|
{"srcfile":"px_bw_bewerb_sb_status_v.csv", "targettable":"costage_bw_bewerb_sb_status", "targetfile":"costage_bw_bewerb_sb_status.unl"}, |
|
{"srcfile":"px_bw_sb_status_v.csv", "targettable":"costage_bw_sb_status", "targetfile":"costage_bw_sb_status.unl"}, |
|
{"srcfile":"px_bw_sb_status_werte_v.csv", "targettable":"costage_bw_sb_status_werte", "targetfile":"costage_bw_sb_status_werte.unl"}, |
|
{"srcfile":"px_bw_sb_stat_vorl_zuordnung_v.csv", "targettable":"costage_bw_sb_stat_vorl_zuordnung", "targetfile":"costage_bw_sb_stat_vorl_zuordnung.unl"}, |
|
{"srcfile":"px_bw_zulassungsarten_v.csv", "targettable":"costage_bw_zulassungsarten", "targetfile":"costage_bw_zulassungsarten.unl"}, |
|
{"srcfile":"px_land_subregionen_v.csv", "targettable":"costage_land_subregionen", "targetfile":"costage_land_subregionen.unl"}, |
|
{"srcfile":"px_st_studienformen_v.csv", "targettable":"costage_st_studienformen", "targetfile":"costage_st_studienformen.unl"}, |
|
{"srcfile":"px_st_adressen_v.csv", "targettable":"costage_st_adressen", "targetfile":"costage_st_adressen.unl"}, |
|
{"srcfile":"px_st_urlaube_v.csv", "targettable":"costage_st_urlaube", "targetfile":"costage_st_urlaube.unl"}, |
|
{"srcfile":"px_st_urlaubs_typen_v.csv", "targettable":"costage_st_urlaubs_typen", "targetfile":"costage_st_urlaubs_typen.unl"}, |
|
{"srcfile":"px_st_abmeldungsarten_v.csv", "targettable":"costage_st_abmeldungsarten", "targetfile":"costage_st_abmeldungsarten.unl"}, |
|
{"srcfile":"px_st_personen_abmeldungen_v.csv", "targettable":"costage_st_personen_abmeldungen", "targetfile":"costage_st_personen_abmeldungen.unl"}, |
|
{"srcfile":"px_st_ersthochschulen_v.csv", "targettable":"costage_st_ersthochschulen", "targetfile":"costage_st_ersthochschulen.unl"}, |
|
{"srcfile":"sx_st_hochschulsemester_v.csv", "targettable":"costage_st_hochschulsemester", "targetfile":"costage_st_hochschulsemester.unl"}, |
|
{"srcfile":"sx_leistungen_v.csv", "targettable":"costage_leistungen", "targetfile":"costage_leistungen.unl"}, |
|
{"srcfile":"px_leistungen_detail_typen_v.csv", "targettable":"costage_leistungen_detail_typen", "targetfile":"costage_leistungen_detail_typen.unl"}, |
|
{"srcfile":"px_leistungen_typen_v.csv", "targettable":"costage_leistungen_typen", "targetfile":"costage_leistungen_typen.unl"}, |
|
{"srcfile":"px_antritte_v.csv", "targettable":"costage_antritte", "targetfile":"costage_antritte.unl"}, |
|
{"srcfile":"px_leistungen_status_typen_v.csv", "targettable":"costage_leistungen_status_typen", "targetfile":"costage_leistungen_status_typen.unl"}, |
|
{"srcfile":"px_bw_hzb_arten_v.csv", "targettable":"costage_bw_hzb_arten", "targetfile":"costage_bw_hzb_arten.unl"} |
|
] /> |
|
|
|
\! echo "Folgende Dateien lassen sich laden:" |
|
|
|
<#foreach file in files> |
|
\! echo "${file.srcfile}" |
|
</#foreach> |
|
<#foreach file in files> |
|
|
|
truncate table ${file.targettable}; |
|
vacuum full ${file.targettable}; |
|
|
|
--falls sie nicht existieren werden sie mit 0 bytes angelegt: |
|
\! touch 'unl/${file.srcfile}' |
|
\! sx_recode_iso2utf.x unl/${file.srcfile} |
|
|
|
\copy ${file.targettable} from 'unl/${file.srcfile}' with delimiter ',' quote '"' null as '' csv header encoding 'UTF-8' |
|
|
|
<#if file.specialrule?exists> |
|
|
|
${file.specialrule}; |
|
|
|
</#if> |
|
|
|
\! sx_unload_table.x ${file.targettable} unl/${file.targetfile} |
|
</#foreach>
|
|
|