changes for vernacular names import

[cdmlib-apps.git] / cdm-pesi / src / main / java / eu / etaxonomy / cdm / app / pesi / PesiSources.java

diff --git a/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/PesiSources.java b/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/PesiSources.java
index 4a2f53c9a3ce589d97ad2b084eb5fa6967af3a93..e376ff4e8ab675a3d30fc078b2a1bf7c1d121967 100644 (file)
--- a/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/PesiSources.java
+++ b/cdm-pesi/src/main/java/eu/etaxonomy/cdm/app/pesi/PesiSources.java
@@ -23,14 +23,31 @@ public class PesiSources {
        @SuppressWarnings("unused")\r
        private static final Logger logger = Logger.getLogger(PesiSources.class);\r
        \r
        @SuppressWarnings("unused")\r
        private static final Logger logger = Logger.getLogger(PesiSources.class);\r
        \r

+       public static Source faunEu_pesi3(){\r
+               //      Fauna Europaea auf pesiimport3\r
+               String dbms = Source.SQL_SERVER_2008;\r
+        String strServer = "pesiimport3";\r
+        String strDB = "FaunEu";\r
+               int port = 1433;\r
+               String userName = "pesiExportFaunaEu";\r
+               return  ImportUtils.makeSource(dbms, strServer, strDB, port, userName, null);\r
+       }\r
+       \r
+       public static Source mfn_faunEu_pesi3(){\r
+               //      Fauna Europaea auf pesiimport3\r
+               String dbms = Source.SQL_SERVER_2008;\r
+        String strServer = "pesiimport3";\r
+        String strDB = "MfN_FaunaEuropaea";\r
+               int port = 1433;\r
+               String userName = "pesiExportFaunaEu";\r
+               return  ImportUtils.makeSource(dbms, strServer, strDB, port, userName, null);\r
+       }\r
+       \r

        public static Source faunEu(){\r
                //      Fauna Europaea\r
        public static Source faunEu(){\r
                //      Fauna Europaea\r

-               \r

                String dbms = Source.SQL_SERVER_2008;\r
                String dbms = Source.SQL_SERVER_2008;\r

-           \r
-               String strServer = "BGBM42";               // "192.168.1.36";\r
-            \r
-               String strDB = "FaunEu";\r
+               String strServer = "BGBM42";               // "192.168.1.36";\r
+        String strDB = "FaunEu";\r

                int port = 1433;\r
                String userName = "WebUser";\r
                return  ImportUtils.makeSource(dbms, strServer, strDB, port, userName, null);\r
                int port = 1433;\r
                String userName = "WebUser";\r
                return  ImportUtils.makeSource(dbms, strServer, strDB, port, userName, null);\r


@@ -38,23 +55,17 @@ public class PesiSources {
        \r
        public static Source faunaEu_previous(){\r
                //      Fauna Europaea\r
        \r
        public static Source faunaEu_previous(){\r
                //      Fauna Europaea\r

-               \r

                String dbms = Source.SQL_SERVER_2008;\r
                String dbms = Source.SQL_SERVER_2008;\r

-           \r
-               String strServer = "BGBM42";               // "192.168.1.36";\r
-            \r
-               String strDB = "FaunEu_2_2";\r
+               String strServer = "BGBM42";               // "192.168.1.36";\r
+               String strDB = "FaunEu_2_2";\r

                int port = 1433;\r
                String userName = "WebUser";\r
                return  ImportUtils.makeSource(dbms, strServer, strDB, port, userName, null);\r
        }\r
        public static Source faunaEu_old(){\r
                //      Fauna Europaea\r
                int port = 1433;\r
                String userName = "WebUser";\r
                return  ImportUtils.makeSource(dbms, strServer, strDB, port, userName, null);\r
        }\r
        public static Source faunaEu_old(){\r
                //      Fauna Europaea\r

-               \r

                String dbms = Source.SQL_SERVER_2008;\r
                String dbms = Source.SQL_SERVER_2008;\r

-           \r

                String strServer = "BGBM42";               // "192.168.1.36";\r
                String strServer = "BGBM42";               // "192.168.1.36";\r

-            \r

                String strDB = "FaunaEu_1_3";\r
                int port = 1433;\r
                String userName = "WebUser";\r
                String strDB = "FaunaEu_1_3";\r
                int port = 1433;\r
                String userName = "WebUser";\r


@@ -72,6 +83,36 @@ public class PesiSources {
        }\r
        \r
        \r
        }\r
        \r
        \r

+       public static Source PESI3_ERMS(){\r
+               //      BerlinModel - Pesi-ERMS\r
+               String dbms = Source.SQL_SERVER_2008;\r
+               String strServer = "Pesiimport3";\r
+               String strDB = "ERMS";\r
+               int port = 1433;\r
+               String userName = "pesiexport";\r
+               return  makeSource(dbms, strServer, strDB, port, userName, null);\r
+       }\r
+       \r
+       public static Source PESI3_IF(){\r
+               //      BerlinModel - Pesi-ERMS\r
+               String dbms = Source.SQL_SERVER_2008;\r
+               String strServer = "Pesiimport3";\r
+               String strDB = "IF_2014_06";\r
+               int port = 1433;\r
+               String userName = "pesiExportFaunaEu";\r
+               return  makeSource(dbms, strServer, strDB, port, userName, null);\r
+       }\r
+       \r
+       public static Source PESI_IF(){\r
+               //      BerlinModel - Pesi-IF\r
+               String dbms = Source.SQL_SERVER_2008;\r
+               String strServer = "BGBM42";\r
+               String strDB = "IF";\r
+               int port = 1433;\r
+               String userName = "WebUser";\r
+               return  makeSource(dbms, strServer, strDB, port, userName, null);\r
+       }\r
+       \r

        /**\r
         * Initializes the source.\r
         * @param dbms\r
        /**\r
         * Initializes the source.\r
         * @param dbms\r