Index: modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/pimpa_affiliations.xslt
===================================================================
--- modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/pimpa_affiliations.xslt (revision 61897)
+++ modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/pimpa_affiliations.xslt (nonexistent)
@@ -1,23 +0,0 @@
-
-
-
-
-
- '
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
\ No newline at end of file
Index: modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/affiliations_con_matricola.xslt
===================================================================
--- modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/affiliations_con_matricola.xslt (nonexistent)
+++ modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/affiliations_con_matricola.xslt (revision 61898)
@@ -0,0 +1,23 @@
+
+
+
+
+
+ '
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
Index: modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/affiliations_senza_matricola.xslt
===================================================================
--- modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/affiliations_senza_matricola.xslt (nonexistent)
+++ modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/affiliations_senza_matricola.xslt (revision 61898)
@@ -0,0 +1,24 @@
+
+
+
+
+
+ '
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
Index: modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/readme.txt
===================================================================
--- modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/readme.txt (revision 61897)
+++ modules/dnet-isti/trunk/src/main/resources/scripts/affilitions/readme.txt (revision 61898)
@@ -2,12 +2,13 @@
- WSDL: http://pimpa.isti.cnr.it/PERSONALE/web-services/iop/iop.webservice.php?wsdl
- Method: getDataRange
-2) Eseguire l'xslt sulla risposta
+2) Eseguire gli xslt sulla risposta
3) Ricreare o svuotare la tabella temporanea affiliations_temp
- create table affiliations_temp(pid varchar(32), gid varchar(16), year int);
+ - create table affiliations_temp_no_id(name varchar(255), surname varchar(255), gid varchar(16), year int);
-4) Importare le nuopvi affiliations sulla tabella temporanea
+4) Importare le nuove affiliations sulle tabelle temporanee
5) Verificare che non esistano nuovi laboratori e/o nuove persone ed eventualmente inserirle una per una
- select distinct t.pid, p.name, p.surname from affiliations_temp t left outer join persons p on (t.pid = p.id) where p.name IS NULL;
@@ -18,7 +19,7 @@
7) Effettuare controlli a campione
-8) Cancellare la tabella temporanea
+8) Cancellare la tabell temporanea
- drop table affiliations_temp;
9) Cancellare e/o correggere (se possibile) le affiliations UNKNOWN