# -*- coding: utf-8 -*-
import sys
## changer selon le chemin du python27, present dans l'installation de fme
sys.path.append("C:/Program Files/FME/fmeobjects/python27")
import fmeobjects, os, arcpy

## changer selon le dossier ou sont les workspaces FME (attention utiliser des / et non des \)
script_fme = "//fslyo.swordgroup.lan/Clients/SIG/Client/RATP/SEC BACO/SIG_SEC_TOPOGRAPHIE/Product/Real/Scripts FME/script_fme/Livraison_1/traitements_fme"

## changer selon le chemin aux connexions d'ArcCatalog
aux='C:/Users/lfollain/AppData/Roaming/ESRI/Desktop10.6/ArcCatalog/'
ADMIN_TOPOSEC = os.path.join(aux, 'admin@tps@sigvsecbdd.lyon-dev2.local.sde')
ALIM_TOPOSEC = os.path.join(aux, 'alim@tps@sigvsecbdd.lyon-dev2.local.sde')
PREREF_TOPOSEC = os.path.join(aux, 'preref@tps@sigvsecbdd.lyon-dev2.local.sde')
REF_TOPOSEC = os.path.join(aux, 'ref@tps@sigvsecbdd.lyon-dev2.local.sde')
SFS_TOPOSEC = os.path.join(aux, 'sfs@tps@sigvsecbdd.lyon-dev2.local.sde')

## changer selon le chemin aux donnees administratives
ING_DATA = "//fslyo.swordgroup.lan/Clients/SIG/Client/RATP/SEC BACO/SIG_SEC_TOPOGRAPHIE/Product/Definit/DATA Sword/SI BACO/File GDB/ING_DATA.gdb"

## changer selon l endroit de destination des CSV et de la FGDB voulu (attention utiliser des / et non des \)
DestDataset_GEODATABASE_FILE = 'C:/Users/lfollain/Desktop'
DestDataset_CSV2 = 'C:/Users/lfollain/Desktop'

count=1
work_nb=0
print( "\n---- Creation de la base V0 -----\n"
            "0: creation_ADMIN\n"
            "1: creation_PREREF_REF_references\n"
            "11: creation_PREREF_references\n"
            "12: creation_REF_references\n"
            "2: creation_ALIM\n"
            "3: ADMIN_adm_gestion_lot\n"
            "4: creation_PREREF\n"
            "41: creation_PREREF_lis_lit\n"
            "42: creation_PREREF_lignes\n"
            "4211: creation_PREREF_lig_tro_vide\n"
            "4221: creation_PREREF_lit_lig\n"
            "4222: creation_PREREF_lit_lgu\n"
            "4223: creation_PREREF_lgu_tro\n"
            "43: creation_PREREF_tro_ferre\n"
            "44: creation_PREREF_points_regroupements\n"
            "4411: creation_PREREF_points_arret_first\n"
            "4412: creation_REF_regroupements_mom_mol_first\n"
            "4413: creation_REF_regroupements_mom_mul_first\n"
            "4414: creation_REF_regroupements_mul_mul_first\n"
            "4415: creation_PREREF_complexes_ferres_first\n"
            "4421: creation_PREREF_points_arret_modif\n"
            "4422: creation_REF_regroupements_mom_mol_modif\n"
            "4423: creation_REF_regroupements_mom_mul_modif\n"
            "4424: creation_REF_regroupements_mul_mul_modif\n"
            "4425 creation_PREREF_complexes_ferres_modif\n"
            "443: creation_PREREF_regroupements_part2\n"
            "5: creation_REF\n"
            "511: creation_REF_points_arret_modif\n"
            "512: creation_REF_regroupements_mom_mol_modif\n"
            "513: creation_REF_regroupements_mom_mul_modif\n"
            "514: creation_REF_regroupements_mul_mul_modif\n"
            "515: creation_REF_troncons_surface_modif\n"
            "516: creation_REF_troncons_ferres_modif\n"
            "517: creation_REF_complexes_ferres_modif\n"
            "518: creation_REF_lignes_modif\n"
            "519: creation_REF_lignes_unifiees_modif\n"
            "521: creation_REF_points_arret_modif\n"
            "522: creation_REF_regroupements_mom_mol_modif\n"
            "523: creation_REF_regroupements_mom_mul_modif\n"
            "524: creation_REF_regroupements_mul_mul_modif\n"
            "525: creation_REF_troncons_surface_modif\n"
            "526: creation_REF_troncons_ferres_modif\n"
            "527: creation_REF_complexes_ferres_modif\n"
            "528: creation_REF_lignes_modif\n"
            "529: creation_REF_lignes_unifiees_modif\n"
            "6: creation_SFS\n"
            "61: creation_SFS_publication_fgdb\n"
            "62: creation_SFS_publication_csv\n"
            "6211: creation_SFS_ferres_arret_mode_modif\n"
            "6212: creation_SFS_tal_complexe_ferre_modif\n"
            "6213: creation_SFS_trb_complexe_ferre_modif\n"
            "6214: creation_SFS_trb_lg_modif\n"
            "6215: creation_SFS_trb_lieu_rrs_modif\n"
            "6216: creation_SFS_trb_pass_ferre_modif\n"
            "6221: creation_SFS_ferres_arret_mode_modif\n"
            "6222: creation_SFS_tal_complexe_ferre_modif\n"
            "6223: creation_SFS_trb_complexe_ferre_modif\n"
            "6224: creation_SFS_trb_lg_modif\n"
            "6225: creation_SFS_trb_lieu_rrs_modif\n"
            "6226: creation_SFS_trb_pass_ferre_modif\n"
            "7: creation_SFS_export\n")

while count==1:
    work_nb=int(input("Quel workspace voulez-vous lancer ?: "))

    if work_nb==0:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_ADMIN.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = str(ADMIN_TOPOSEC)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_ADMIN a ete execute. Il est normalement suivi de creation_PREREF_REF_references, le workspace correspondant au numero 1')
        running = None

    elif work_nb == 1 :
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_REF_references.fmw")
        parameters = {}
        parameters['REF_TOPOSEC'] = str(REF_TOPOSEC)
        parameters['PREREF_TOPOSEC'] = str(PREREF_TOPOSEC)
        parameters['SourceDataset_FILEGDB'] = str(ING_DATA)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_references a ete execute. Il est normalement suivi de creation_ALIM, le workspace correspondant au numero 2')
        running = None

    elif work_nb == 11 :
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_references.fmw")
        parameters = {}
        parameters['REF_TOPOSEC'] = str(REF_TOPOSEC)
        parameters['PREREF_TOPOSEC'] = str(PREREF_TOPOSEC)
        parameters['SourceDataset_FILEGDB'] = str(ING_DATA)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_references a ete execute. Il est normalement suivi de creation_REF_references, le workspace correspondant au numero 12')
        running = None

    elif work_nb == 12 :
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_references.fmw")
        parameters = {}
        parameters['REF_TOPOSEC'] = str(REF_TOPOSEC)
        parameters['PREREF_TOPOSEC'] = str(PREREF_TOPOSEC)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_references a ete execute')
        running = None

    elif work_nb==2:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_ALIM.fmw")
        parameters = {}
        adm_pop = int(input("Entrer la valeur du champ ADM_POP_SEPARATEUR : "))
        parameters['adm_pop'] = str(adm_pop)
        parameters['ADMIN_TOPOSEC'] = str(ADMIN_TOPOSEC)
        parameters['ALIM_TOPOSEC'] = str(ALIM_TOPOSEC)
        parameters['PREREF_TOPOSEC'] = str(PREREF_TOPOSEC)
        num_lot_valide = 0
        while num_lot_valide == 0 :
            num_lot = int(input("Entrer le numero du lot entre 1 et 6 : "))

            if num_lot == 1:
                ## donnees lot 1, a changer si necessaire (attention utiliser des / et non des \)

                CHEMIN = "//fslyo.swordgroup.lan/Clients/SIG/Client/RATP/SEC BACO/SIG_SEC_TOPOGRAPHIE/Client/Fournitures/Export SUROIT/1-Export_SUROIT_30012018"
                parameters['SourceDataset_CSV2'] = "%s/export_BUS.csv" % CHEMIN
                parameters['SourceDataset_CSV2_5'] = "%s/export_TRAM.csv" % CHEMIN
                parameters['SourceDataset_GML'] = "%s/Expor_AIGLE_30012018/Expor_AIGLE_30012018/Tram.gml" % CHEMIN
                parameters['SourceDataset_GML_11'] = "%s/Expor_AIGLE_30012018/Expor_AIGLE_30012018/Metro_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_12'] = "%s/Expor_AIGLE_30012018/Expor_AIGLE_30012018/Metro.gml" % CHEMIN
                parameters['SourceDataset_GML_13'] = "%s/Expor_AIGLE_30012018/Expor_AIGLE_30012018/Tram_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_14'] = "%s/Expor_AIGLE_30012018/Expor_AIGLE_30012018/Rer.gml" % CHEMIN
                parameters['SourceDataset_GML_15'] = "%s/Expor_AIGLE_30012018/Expor_AIGLE_30012018/Rer_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_16'] = "%s/Expor_AIGLE_30012018/Expor_AIGLE_30012018/Bus.gml" % CHEMIN
                parameters['SourceDataset_GML_17'] = "%s/Expor_AIGLE_30012018/Expor_AIGLE_30012018/Bus_Stations.gml" % CHEMIN
                parameters['SourceDataset_XML'] = "%s/Expor_AIGLE_30012018/Expor_AIGLE_30012018/*.xml" % CHEMIN
                num_lot_valide = 1

            elif num_lot == 2 :
                ## donnees lot 2, a changer si necessaire (attention utiliser des / et non des \)
                CHEMIN = "//fslyo.swordgroup.lan/Clients/SIG/Client/RATP/SEC BACO/SIG_SEC_TOPOGRAPHIE/Client/Fournitures/Export SUROIT/2-Export_SUROIT_22022018"
                parameters['SourceDataset_CSV2'] = "%s/export_BUS_corrige.csv" % CHEMIN
                parameters['SourceDataset_CSV2_5'] = "%s/export_TRAM.csv" % CHEMIN
                parameters['SourceDataset_GML'] = "%s/Export_AIGLE_22022018/Export_AIGLE_22022018/Tram.gml" % CHEMIN
                parameters['SourceDataset_GML_11'] = "%s/Export_AIGLE_22022018/Export_AIGLE_22022018/Metro_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_12'] = "%s/Export_AIGLE_22022018/Export_AIGLE_22022018/Metro.gml" % CHEMIN
                parameters['SourceDataset_GML_13'] = "%s/Export_AIGLE_22022018/Export_AIGLE_22022018/Tram_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_14'] = "%s/Export_AIGLE_22022018/Export_AIGLE_22022018/Rer.gml" % CHEMIN
                parameters['SourceDataset_GML_15'] = "%s/Export_AIGLE_22022018/Export_AIGLE_22022018/Rer_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_16'] = "%s/Export_AIGLE_22022018/Export_AIGLE_22022018/Bus.gml" % CHEMIN
                parameters['SourceDataset_GML_17'] = "%s/Export_AIGLE_22022018/Export_AIGLE_22022018/Bus_Stations.gml" % CHEMIN
                parameters['SourceDataset_XML'] = "%s/Export_AIGLE_22022018/Export_AIGLE_22022018/*.xml" % CHEMIN
                num_lot_valide = 1

            elif num_lot == 3 :
                ## donnees lot 3, a changer si necessaire (attention utiliser des / et non des \)
                CHEMIN = "//fslyo.swordgroup.lan/Clients/SIG/Client/RATP/SEC BACO/SIG_SEC_TOPOGRAPHIE/Client/Fournitures/Export SUROIT/3-Export_SUROIT_13042018"
                parameters['SourceDataset_CSV2'] = "%s/export_BUS.csv" % CHEMIN
                parameters['SourceDataset_CSV2_5'] = "%s/export_TRAM.csv" % CHEMIN
                parameters['SourceDataset_GML'] = "%s/Export_AIGLE_13042018/Export_AIGLE_13042018/Tram.gml" % CHEMIN
                parameters['SourceDataset_GML_11'] = "%s/Export_AIGLE_13042018/Export_AIGLE_13042018/Metro_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_12'] = "%s/Export_AIGLE_13042018/Export_AIGLE_13042018/Metro.gml" % CHEMIN
                parameters['SourceDataset_GML_13'] = "%s/Export_AIGLE_13042018/Export_AIGLE_13042018/Tram_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_14'] = "%s/Export_AIGLE_13042018/Export_AIGLE_13042018/Rer.gml" % CHEMIN
                parameters['SourceDataset_GML_15'] = "%s/Export_AIGLE_13042018/Export_AIGLE_13042018/Rer_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_16'] = "%s/Export_AIGLE_13042018/Export_AIGLE_13042018/Bus.gml" % CHEMIN
                parameters['SourceDataset_GML_17'] = "%s/Export_AIGLE_13042018/Export_AIGLE_13042018/Bus_Stations.gml" % CHEMIN
                parameters['SourceDataset_XML'] = "%s/Export_AIGLE_13042018/Export_AIGLE_13042018/*.xml" % CHEMIN
                num_lot_valide = 1

            elif num_lot == 4 :
                ## donnees lot 4, a changer si necessaire (attention utiliser des / et non des \)
                CHEMIN = "//fslyo.swordgroup.lan/Clients/SIG/Client/RATP/SEC BACO/SIG_SEC_TOPOGRAPHIE/Client/Fournitures/Export SUROIT/4-Export_SUROIT_15052018"
                parameters['SourceDataset_CSV2'] = "%s/export_BUS.csv" % CHEMIN
                parameters['SourceDataset_CSV2_5'] = "%s/export_TRAM.csv" % CHEMIN
                parameters['SourceDataset_GML'] = "%s/Export_AIGLE_15052018/Export_AIGLE_15052018/Tram.gml" % CHEMIN
                parameters['SourceDataset_GML_11'] = "%s/Export_AIGLE_15052018/Export_AIGLE_15052018/Metro_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_12'] = "%s/Export_AIGLE_15052018/Export_AIGLE_15052018/Metro.gml" % CHEMIN
                parameters['SourceDataset_GML_13'] = "%s/Export_AIGLE_15052018/Export_AIGLE_15052018/Tram_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_14'] = "%s/Export_AIGLE_15052018/Export_AIGLE_15052018/Rer.gml" % CHEMIN
                parameters['SourceDataset_GML_15'] = "%s/Export_AIGLE_15052018/Export_AIGLE_15052018/Rer_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_16'] = "%s/Export_AIGLE_15052018/Export_AIGLE_15052018/Bus.gml" % CHEMIN
                parameters['SourceDataset_GML_17'] = "%s/Export_AIGLE_15052018/Export_AIGLE_15052018/Bus_Stations.gml" % CHEMIN
                parameters['SourceDataset_XML'] = "%s/Export_AIGLE_15052018/Export_AIGLE_15052018/*.xml" % CHEMIN
                num_lot_valide = 1

            elif num_lot == 5 :
                ## donnees lot 5, a changer si necessaire (attention utiliser des / et non des \)
                CHEMIN = "//fslyo.swordgroup.lan/Clients/SIG/Client/RATP/SEC BACO/SIG_SEC_TOPOGRAPHIE/Client/Fournitures/Export SUROIT/5-Export_SUROIT_15062018"
                parameters['SourceDataset_CSV2'] = "%s/export_BUS.csv" % CHEMIN
                parameters['SourceDataset_CSV2_5'] = "%s/export_TRAM.csv" % CHEMIN
                parameters['SourceDataset_GML'] = "%s/Export AIGLE_15062018/Export AIGLE_15062018/Tram.gml" % CHEMIN
                parameters['SourceDataset_GML_11'] = "%s/Export AIGLE_15062018/Export AIGLE_15062018/Metro_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_12'] = "%s/Export AIGLE_15062018/Export AIGLE_15062018/Metro.gml" % CHEMIN
                parameters['SourceDataset_GML_13'] = "%s/Export AIGLE_15062018/Export AIGLE_15062018/Tram_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_14'] = "%s/Export AIGLE_15062018/Export AIGLE_15062018/Rer.gml" % CHEMIN
                parameters['SourceDataset_GML_15'] = "%s/Export AIGLE_15062018/Export AIGLE_15062018/Rer_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_16'] = "%s/Export AIGLE_15062018/Export AIGLE_15062018/Bus.gml" % CHEMIN
                parameters['SourceDataset_GML_17'] = "%s/Export AIGLE_15062018/Export AIGLE_15062018/Bus_Stations.gml" % CHEMIN
                parameters['SourceDataset_XML'] = "%s/Export AIGLE_15062018/Export AIGLE_15062018/*.xml" % CHEMIN
                num_lot_valide = 1

            elif num_lot == 6 :
                ## donnees lot 6, a changer si necessaire (attention utiliser des / et non des \)
                CHEMIN = "//fslyo.swordgroup.lan/Clients/SIG/Client/RATP/SEC BACO/SIG_SEC_TOPOGRAPHIE/Client/Fournitures/Export SUROIT/6-Export_SUROIT_19072018"
                parameters['SourceDataset_CSV2'] = "%s/export_BUS.csv" % CHEMIN
                parameters['SourceDataset_CSV2_5'] = "%s/export_TRAM.csv" % CHEMIN
                parameters['SourceDataset_GML'] = "%s/Export_AIGLE_19072018/Export_AIGLE_19072018/Tram.gml" % CHEMIN
                parameters['SourceDataset_GML_11'] = "%s/Export_AIGLE_19072018/Export_AIGLE_19072018/Metro_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_12'] = "%s/Export_AIGLE_19072018/Export_AIGLE_19072018/Metro.gml" % CHEMIN
                parameters['SourceDataset_GML_13'] = "%s/Export_AIGLE_19072018/Export_AIGLE_19072018/Tram_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_14'] = "%s/Export_AIGLE_19072018/Export_AIGLE_19072018/Rer.gml" % CHEMIN
                parameters['SourceDataset_GML_15'] = "%s/Export_AIGLE_19072018/Export_AIGLE_19072018/Rer_Stations.gml" % CHEMIN
                parameters['SourceDataset_GML_16'] = "%s/Export_AIGLE_19072018/Export_AIGLE_19072018/Bus.gml" % CHEMIN
                parameters['SourceDataset_GML_17'] = "%s/Export_AIGLE_19072018/Export_AIGLE_19072018/Bus_Stations.gml" % CHEMIN
                parameters['SourceDataset_XML'] = "%s/Export_AIGLE_19072018/Export_AIGLE_19072018/*.xml" % CHEMIN
                num_lot_valide = 1

            else :
                print("Le numero de lot n'est pas valide. Entrer un numero entre 1 et 6")

        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_ALIM a ete execute. Il est normalement suivi de ADMIN_adm_gestion_lot, le workspace correspondant au numero 3')
        running = None

    elif work_nb==3:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "ADMIN_adm_gestion_lot.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = str(ADMIN_TOPOSEC)
        parameters['ALIM_TOPOSEC'] = str(ALIM_TOPOSEC)
        parameters['adm_tra_id'] = str(1)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('ADMIN_adm_gestion_lot a ete execute. Il est normalement suivi de creation_PREREF, le workspace correspondant au numero 4')
        running = None

    elif work_nb == 4 :
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF.fmw")
        parameters = {}
        parameters['ALIM_TOPOSEC'] = ALIM_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        parameters['RMU_IDP_non_present'] = ""
        parameters['points_sans_correspondance'] = ""
        parameters['NOM_MOMU_RMU_ID'] = "test"
        parameters['modification_complexe'] = str(1)
        parameters['creation_complexe'] = str(1)
        parameters['regroupement_individuel_mom_mol'] = str(1)
        parameters['regroupement_individuel_mom_mul'] = str(1)
        parameters['regroupement_individuel_mul_mul'] = str(1)
        parameters['points_similaire_mom_mol'] = ""
        parameters['points_similaire_mom_mul'] = ""
        parameters['points_similaire_mul_mul'] = ""
        parameters['point_rmo_selectionne'] = str(1)
        parameters['point_rmu_selectionne'] = str(1)
        parameters['point_mul_selectionne'] = str(1)
        parameters['Nom_arret_mom_mol'] = "test"
        parameters['Nom_arret_mom_mul'] = "test"
        parameters['Nom_arret_mul_mul'] = "test"
        parameters['liste_mom_mol_hors'] = ""
        parameters['liste_mom_mul_hors'] = ""
        parameters['liste_mul_mul_hors'] = ""
        parameters['liste_nom_a_choisir_mom_mol'] = ""
        parameters['liste_nom_a_choisir_mom_mul'] = ""
        parameters['liste_nom_a_choisir_mul_mul'] = ""
        parameters['list_id_mom_mol_selectionne'] = ""
        parameters['list_id_mom_mul_selectionne'] = ""
        parameters['list_id_mul_mul_selectionne'] = ""
        parameters['appariement_valide_mom_mol'] = str(1)
        parameters['appariement_valide_mom_mul'] = str(1)
        parameters['appariement_valide_mul_mul'] = str(1)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF a ete execute. Il est normalement suivi de creation_REF, le workspace correspondant au numero 5')
        running = None

    elif work_nb == 41 :
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_lis_lit.fmw")
        parameters = {}
        parameters['ALIM_TOPOSEC'] = ALIM_TOPOSEC
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_lis_lit a ete execute. Il est normalement suivi de creation_PREREF_lignes, le workspace correspondant au numero 42')
        running = None

    elif work_nb == 42:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_lignes.fmw")
        parameters = {}
        parameters['ALIM_TOPOSEC'] = ALIM_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_lignes a ete execute. . Il est normalement suivi de creation_PREREF_tro_ferre, le workspace correspondant au numero 43')
        running = None

    elif work_nb == 4211:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_lig_tro_vide.fmw")
        parameters = {}
        parameters['ALIM_TOPOSEC'] = ALIM_TOPOSEC
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        '''else:
            print('creation_PREREF_lig_tro_vide a ete execute. Il est normalement suivi de creation_PREREF_tro_ferre, le workspace correspondant au numero 43')'''
        running = None

        workspace = os.path.join(script_fme, "ADMIN_adm_log.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['adm_tra_id'] = str(2)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('ADMIN_adm_log a ete execute')
            print('creation_PREREF_lig_tro_vide a ete execute. Il est normalement suivi de creation_PREREF_tro_ferre, le workspace correspondant au numero 43')
        running = None

    elif work_nb == 4221:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_lit_lig.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_lit_lig a ete execute. Il est normalement suivi de creation_PREREF_lis_lgu, le workspace correspondant au numero 4222')
        running = None

    elif work_nb == 4222:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_lis_lgu.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['ALIM_TOPOSEC'] = ALIM_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_lis_lgu a ete execute. Il est normalement suivi de creation_PREREF_lgu_tro, le workspace correspondant au numero 4223')
        running = None

    elif work_nb == 4223:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_lgu_tro.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_lgu_tro a ete execute. Il est normalement suivi de creation_PREREF_tro_ferre, le workspace correspondant au numero 43')
        running = None

        workspace = os.path.join(script_fme, "ADMIN_adm_log.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['adm_tra_id'] = str(2)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('ADMIN_adm_log a ete execute')
        running = None

    elif work_nb == 43:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_tro_ferre.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_tro_ferre a ete execute. Il est normalement suivi de creation_PREREF_points_regroupements, le workspace correspondant au numero 44')
        running = None

    elif work_nb == 44:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_points_regroupements.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['ALIM_TOPOSEC'] = ALIM_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['RMU_IDP'] = ""
        parameters['points_sans_correspondance'] = ""
        parameters['NOM_MOMU_RMU_ID'] = "test"
        parameters['modification_complexe'] = str(1)
        parameters['creation_complexe'] = str(1)
        parameters['regroupement_individuel_mom_mol'] = str(1)
        parameters['regroupement_individuel_mom_mul'] = str(1)
        parameters['regroupement_individuel_mul_mul'] = str(1)
        parameters['points_similaire_mom_mol'] = ""
        parameters['points_similaire_mom_mul'] = ""
        parameters['points_similaire_mul_mul'] = ""
        parameters['point_rmo_selectionne'] = str(1)
        parameters['point_rmu_selectionne'] = str(1)
        parameters['point_mul_selectionne'] = str(1)
        parameters['Nom_arret_mom_mol'] = "test"
        parameters['Nom_arret_mom_mul'] = "test"
        parameters['Nom_arret_mul_mul'] = "test"
        parameters['liste_mom_mol_hors'] = ""
        parameters['liste_mom_mul_hors'] = ""
        parameters['liste_mul_mul_hors'] = ""
        parameters['liste_nom_a_choisir_mom_mol'] = ""
        parameters['liste_nom_a_choisir_mom_mul'] = ""
        parameters['liste_nom_a_choisir_mul_mul'] = ""
        parameters['list_id_mom_mol_selectionne'] = ""
        parameters['list_id_mom_mul_selectionne'] = ""
        parameters['list_id_mul_mul_selectionne'] = ""
        parameters['appariement_valide_mom_mol'] = str(1)
        parameters['appariement_valide_mom_mul'] = str(1)
        parameters['appariement_valide_mul_mul'] = str(1)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_points_regroupements a ete execute. Il est normalement suivi de creation_REF, le workspace correspondant au numero 5')
        running = None

    elif work_nb == 4411:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_points_arret_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['ALIM_TOPOSEC'] = ALIM_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_points_arret_first a ete execute. Il est normalement suivi de creation_PREREF_regroupements_mom_mol_first, le workspace correspondant au numero 4412')
        running = None

    elif work_nb == 4412:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_regroupements_mom_mol_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_regroupements_mom_mol_first a ete execute. Il est normalement suivi de creation_PREREF_regroupements_mom_mul_first, le workspace correspondant au numero 4413')
        running = None

    elif work_nb == 4413:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_regroupements_mom_mul_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_regroupements_mom_mul_first a ete execute. Il est normalement suivi de creation_PREREF_regroupements_mul_mul_first, le workspace correspondant au numero 4414')
        running = None

    elif work_nb == 4414:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_regroupements_mul_mul_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_regroupements_mul_mul_first a ete execute. Il est normalement suivi de creation_PREREF_complexes_ferres_first, le workspace correspondant au numero 4415')
        running = None

    elif work_nb == 4415:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_complexes_ferres_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_complexes_ferres_first a ete execute. Il est normalement suivi de creation_PREREF_regroupements_part2, le workspace correspondant au numero 443')
        running = None

    elif work_nb == 4421:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_points_arret_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['ALIM_TOPOSEC'] = ALIM_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_points_arret_modif a ete execute. Il est normalement suivi de creation_PREREF_regroupements_mom_mol_modif, le workspace correspondant au numero 4422')
        running = None

    elif work_nb == 4422:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_regroupements_mom_mol_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_regroupements_mom_mol_modif a ete execute. Il est normalement suivi de creation_PREREF_regroupements_mom_mul_modif, le workspace correspondant au numero 4423')
        running = None

    elif work_nb == 4423:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_regroupements_mom_mul_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_regroupements_mom_mul_modif a ete execute. Il est normalement suivi de creation_PREREF_regroupements_mul_mul_modif, le workspace correspondant au numero 4424')
        running = None

    elif work_nb == 4424:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_regroupements_mul_mul_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_regroupements_mul_mul_modif a ete execute. Il est normalement suivi de creation_PREREF_complexes_ferres_modif, le workspace correspondant au numero 4425')
        running = None

    elif work_nb == 4425:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_complexes_ferres_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_PREREF_complexes_ferres_modif a ete execute. Il est normalement suivi de creation_PREREF_regroupements_part2, le workspace correspondant au numero 443')
        running = None

    elif work_nb == 443:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_PREREF_regroupements_part2.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        '''else:
            print('creation_PREREF_regroupements_part2 a ete execute. Il est normalement suivi de creation_REF, le workspace correspondant au numero 5')'''
        running = None

        workspace = os.path.join(script_fme, "ADMIN_adm_log.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['adm_tra_id'] = str(3)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('ADMIN_adm_log a ete execute')
            print('creation_PREREF_regroupements_part2 a ete execute. Il est normalement suivi de creation_REF, le workspace correspondant au numero 5')
        running = None

    elif work_nb == 5:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['ALIM_TOPOSEC'] = ALIM_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF a ete execute. Il est normalement suivi de creation_SFS, le workspace correspondant au numero 6')
        running = None

    elif work_nb == 511:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_points_arret_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_points_arret_first a ete execute. Il est normalement suivi de creation_REF_regroupements_mom_mol_first, le workspace correspondant au numero 512')
        running = None

    elif work_nb == 512:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_regroupements_mom_mol_first.fmw")
        parameters={}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_regroupements_mom_mol_first a ete execute. Il est normalement suivi de creation_REF_regroupements_mom_mul_first, le workspace correspondant au numero 513')
        running = None

    elif work_nb == 513:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_regroupements_mom_mul_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_regroupements_mom_mul_first a ete execute. Il est normalement suivi de creation_REF_regroupements_mul_mul_first, le workspace correspondant au numero 514')
        running = None

    elif work_nb == 514:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_regroupements_mul_mul_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_regroupements_mul_mul_first a ete execute. Il est normalement suivi de creation_REF_troncons_surface_first, le workspace correspondant au numero 515')
        running = None

    elif work_nb == 515:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_troncons_surface_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_troncons_surface_first a ete execute. Il est normalement suivi de creation_REF_troncons_ferres_first, le workspace correspondant au numero 516')
        running = None

    elif work_nb == 516:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_troncons_ferres_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_troncons_ferres_first a ete execute. Il est normalement suivi de creation_REF_complexes_ferres_first, le workspace correspondant au numero 517')
        running = None

    elif work_nb == 517:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_complexes_ferres_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_complexes_ferres_first a ete execute. Il est normalement suivi de creation_REF_lignes_first, le workspace correspondant au numero 518')
        running = None

    elif work_nb == 518:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_lignes_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_lignes_first a ete execute. Il est normalement suivi de creation_REF_lignes_unifiees_first, le workspace correspondant au numero 519')
        running = None

    elif work_nb == 519:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_lignes_unifiees_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        '''else:
            print('creation_REF_lignes_unifiees_first a ete execute. Il est normalement suivi de creation_SFS, le workspace correspondant au numero 6')'''
        running = None

        workspace = os.path.join(script_fme, "ADMIN_adm_log.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['adm_tra_id'] = str(4)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('ADMIN_adm_log a ete execute')
            print('creation_REF_lignes_unifiees_first a ete execute. Il est normalement suivi de creation_SFS, le workspace correspondant au numero 6')
        running = None

    elif work_nb == 521:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_points_arret_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_points_arret_modif a ete execute. Il est normalement suivi de creation_REF_regroupements_mom_mol_modif, le workspace correspondant au numero 522')
        running = None

    elif work_nb == 522:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_regroupements_mom_mol_modif.fmw")
        parameters={}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_regroupements_mom_mol_modif a ete execute. Il est normalement suivi de creation_REF_regroupements_mom_mul_modif, le workspace correspondant au numero 523')
        running = None

    elif work_nb == 523:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_regroupements_mom_mul_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_regroupements_mom_mul_modif a ete execute. Il est normalement suivi de creation_REF_regroupements_mul_mul_modif, le workspace correspondant au numero 524')
        running = None

    elif work_nb == 524:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_regroupements_mul_mul_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_regroupements_mul_mul_modif a ete execute. Il est normalement suivi de creation_REF_troncons_surface_modif, le workspace correspondant au numero 525')
        running = None

    elif work_nb == 525:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_troncons_surface_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_troncons_surface_modif a ete execute. Il est normalement suivi de creation_REF_troncons_ferres_modif, le workspace correspondant au numero 526')
        running = None

    elif work_nb == 526:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_troncons_ferres_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_troncons_ferres_modif a ete execute. Il est normalement suivi de creation_REF_complexes_ferres_modif, le workspace correspondant au numero 527')
        running = None

    elif work_nb == 527:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_complexes_ferres_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_complexes_ferres_modif a ete execute. Il est normalement suivi de creation_REF_lignes_modif, le workspace correspondant au numero 528')
        running = None

    elif work_nb == 528:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_lignes_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_REF_lignes_modif a ete execute. Il est normalement suivi de creation_REF_lignes_unifiees_modif, le workspace correspondant au numero 529')
        running = None

    elif work_nb == 529:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_REF_lignes_unifiees_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        '''else:
            print('creation_REF_lignes_unifiees_modif a ete execute. Il est normalement suivi de creation_SFS, le workspace correspondant au numero 6')'''
        running = None

        workspace = os.path.join(script_fme, "ADMIN_adm_log.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['adm_tra_id'] = str(4)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('ADMIN_adm_log a ete execute')
            print('creation_REF_lignes_unifiees_modif a ete execute. Il est normalement suivi de creation_SFS, le workspace correspondant au numero 6')
        running = None

    elif work_nb == 6:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['SourceDataset_GEODATABASE_FILE'] = ING_DATA
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS a ete execute. Il est normalement suivi de creation_SFS_export, le workspace correspondant au numero 7')
        running = None

    elif work_nb == 61:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_publication_fgdb.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        parameters['SourceDataset_GEODATABASE_FILE'] = ING_DATA
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_publication_fgdb a ete execute. Il est normalement suivi de creation_SFS_publication_csv, le workspace correspondant au numero 62')
        running = None

    elif work_nb == 62:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_publication_csv.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        parameters['REF_TOPOSEC'] = REF_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        '''else:
            print('creation_SFS_publication_csv a ete execute. Il est normalement suivi de creation_SFS_export, le workspace correspondant au numero 7')'''
        running = None

        workspace = os.path.join(script_fme, "ADMIN_adm_log.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['adm_tra_id'] = str(5)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('ADMIN_adm_log a ete execute')
            print('creation_SFS_publication_trb a ete execute. Il est normalement suivi de creation_SFS_export, le workspace correspondant au numero 7')
        running = None

    elif work_nb == 6211:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_ferre_arret_mode_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_ferre_arret_mode_first a ete execute. Il est normalement suivi de creation_SFS_tal_complexe_ferre_first, le workspace correspondant au numero 6212')
        running = None

    elif work_nb == 6212:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_tal_complexe_ferre_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_tal_complexe_ferre_first a ete execute. Il est normalement suivi de creation_SFS_trb_complexe_ferre_first, le workspace correspondant au numero 6213')
        running = None

    elif work_nb == 6213:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_trb_complexe_ferre_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_trb_complexe_ferre_first a ete execute. Il est normalement suivi de creation_SFS_trb_lg_first, le workspace correspondant au numero 6214')
        running = None

    elif work_nb == 6214:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_trb_lg_first.fmw")
        parameters = {}
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_trb_lg_first a ete execute. Il est normalement suivi de creation_SFS_trb_lieu_rrs_first, le workspace correspondant au numero 6215')
        running = None

    elif work_nb == 6215:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_trb_lieu_rrs_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_trb_lieu_rrs_first a ete execute. Il est normalement suivi de creation_SFS_pass_ferre_first, le workspace correspondant au numero 6216')
        running = None

    elif work_nb == 6216:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_pass_ferre_first.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        '''else:
            print('creation_SFS_pass_ferre_first a ete execute. Il est normalement suivi de creation_SFS_export, le workspace correspondant au numero 7')'''
        running = None

        workspace = os.path.join(script_fme, "ADMIN_adm_log.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['adm_tra_id'] = str(5)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('ADMIN_adm_log a ete execute')
            print('creation_SFS_pass_ferre_first a ete execute. Il est normalement suivi de creation_SFS_export, le workspace correspondant au numero 7')
        running = None

    elif work_nb == 6221:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_ferre_arret_mode_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_ferre_arret_mode_modif a ete execute. Il est normalement suivi de creation_SFS_tal_complexe_ferre_modif, le workspace correspondant au numero 6222')
        running = None

    elif work_nb == 6222:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_tal_complexe_ferre_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_tal_complexe_ferre_modif a ete execute. Il est normalement suivi de creation_SFS_trb_complexe_ferre_modif, le workspace correspondant au numero 6223')
        running = None

    elif work_nb == 6223:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_trb_complexe_ferre_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_trb_complexe_ferre_modif a ete execute. Il est normalement suivi de creation_SFS_trb_lg_modif, le workspace correspondant au numero 6224')
        running = None

    elif work_nb == 6224:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_trb_lg_modif.fmw")
        parameters = {}
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_trb_lg_modif a ete execute. Il est normalement suivi de creation_SFS_ttrb_lieu_rrs_modif, le workspace correspondant au numero 6225')
        running = None

    elif work_nb == 6225:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_trb_lieu_rrs_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_trb_lieu_rrs_modif a ete execute. Il est normalement suivi de creation_SFS_pass_ferre_modif, le workspace correspondant au numero 6226')
        running = None

    elif work_nb == 6226:
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_pass_ferre_modif.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        '''else:
            print('creation_SFS_pass_ferre_modif a ete execute. Il est normalement suivi de creation_SFS_export, le workspace correspondant au numero 7')'''
        running = None

        workspace = os.path.join(script_fme, "ADMIN_adm_log.fmw")
        parameters = {}
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['adm_tra_id'] = str(5)
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('ADMIN_adm_log a ete execute')
            print('creation_SFS_pass_ferre_modif a ete execute. Il est normalement suivi de creation_SFS_export, le workspace correspondant au numero 7')
        running = None

    elif work_nb == 7:
        nom_gdb = "/TOPOSEC_DATA.gdb"
        if arcpy.Exists(DestDataset_GEODATABASE_FILE + nom_gdb) :
            print("La geodatabase existe deja, les classes d entitees vont donc etre ecrasees. Continuer (0) ou utiliser un autre nom (1) ? : ")
            ecrasser = input()
            if ecrasser == 1 :
                nom_utilisateur = str(input("Entrer un nom pour la geodatabase entre guillemets (sans l'extension) : " ))
                nom_gdb = "/" + nom_utilisateur + ".gdb"
            else :
                print("Les classes d entitees vont donc etre ecrasees")
        runner = fmeobjects.FMEWorkspaceRunner()
        workspace = os.path.join(script_fme, "creation_SFS_export.fmw")
        parameters = {}
        parameters['PREREF_TOPOSEC'] = PREREF_TOPOSEC
        parameters['SFS_TOPOSEC'] = SFS_TOPOSEC
        parameters['ADMIN_TOPOSEC'] = ADMIN_TOPOSEC
        parameters['DestDataset_GEODATABASE_FILE'] = DestDataset_GEODATABASE_FILE + nom_gdb
        parameters['DestDataset_CSV2'] = DestDataset_CSV2
        try:
            runner.runWithParameters(workspace, parameters)
        except fmeobjects.FMEException as ex:
            print(ex.message)
        else:
            print('creation_SFS_export a ete execute')
        running = None

    else:
        print('Le numero ne correspond a aucun workspace')
        break;

    continuer = int(input("Voulez vous-continuer a lancer les workspaces (oui/non)? 1/0 : "))
    if continuer != 0 and continuer != 1 :
        continuer = int(input("La reponse est incorrecte. Voulez vous-continuer a lancer les workspaces (oui/non)? 1/0 : "))
    else :
        count = continuer