# HG changeset patch
# User siwaa
# Date 1764951175 0
# Node ID 3dfb066dcdabc7046466cba6ef2738e03491046b
# Parent  b91beff0963c6bd0a88a0d9de7bec9ed72cf1ba1
"planemo upload for repository https://forgemia.inra.fr/redelac/redelac-toolbox/-/tree/e8749ba309ff18daeaea5c4a9e7ee4b7448bd58d/tools/REDELACxlsx2csv commit e8749ba309ff18daeaea5c4a9e7ee4b7448bd58d-dirty"

diff -r b91beff0963c -r 3dfb066dcdab redelacxlsx2csv.py
--- a/redelacxlsx2csv.py	Thu Jul 06 10:16:26 2023 +0000
+++ b/redelacxlsx2csv.py	Fri Dec 05 16:12:55 2025 +0000
@@ -7,6 +7,7 @@
 redelacIniOutputFile = sys.argv[4]
 redelacStationOutputFile = sys.argv[5]
 redelacListe_plantesOutputFile = sys.argv[6]
+redelacSuccessionsOutputFile = sys.argv[7]
 
 # loading
 
@@ -15,6 +16,7 @@
 IniPdf = pd.read_excel(redelacXlsxInputFile, engine = 'openpyxl', sheet_name='Ini')
 StationPdf = pd.read_excel(redelacXlsxInputFile, engine = 'openpyxl', sheet_name='Station')
 Liste_plantesPdf = pd.read_excel(redelacXlsxInputFile, engine = 'openpyxl', sheet_name='Liste_plantes')
+Successions = pd.read_excel(redelacXlsxInputFile, engine = 'openpyxl', sheet_name='liste_USMs') 
 
 # sanityzing
 
@@ -22,8 +24,10 @@
 
 TecPdf[julCol] = TecPdf[julCol].astype('Int64')
 
-USMsPdf['fclim1'] = USMsPdf['fclim1'].astype('string')
-USMsPdf['fclim2'] = USMsPdf['fclim1'].astype('string')
+
+
+USMsPdf['fclim1'] = USMsPdf['fclim1'].apply(lambda x: format(x, ".4f")).astype('string')
+USMsPdf['fclim2'] = USMsPdf['fclim2'].apply(lambda x: format(x, ".4f")).astype('string')
 USMsPdf['rcp'] = USMsPdf['rcp'].astype('string')
 
 USMsPdf['Début'] = pd.to_datetime(USMsPdf['Début'], dayfirst = True)
@@ -38,3 +42,4 @@
 IniPdf.to_csv(redelacIniOutputFile, sep=';', date_format='%d/%m/%Y', decimal = ',', index=False)
 StationPdf.to_csv(redelacStationOutputFile, sep=';', date_format='%d/%m/%Y', decimal = ',', index=False)
 Liste_plantesPdf.to_csv(redelacListe_plantesOutputFile, sep=';', date_format='%d/%m/%Y', decimal = ',', index=False)
+Successions.to_csv(redelacSuccessionsOutputFile, sep=';', index=False)
diff -r b91beff0963c -r 3dfb066dcdab redelacxlsx2csv.xml
--- a/redelacxlsx2csv.xml	Thu Jul 06 10:16:26 2023 +0000
+++ b/redelacxlsx2csv.xml	Fri Dec 05 16:12:55 2025 +0000
@@ -1,11 +1,11 @@
-<tool id="redelacXlsx2Csv" name="redelacXlsx2Csv" version="1.0.0">
+<tool id="redelacXlsx2Csv" name="redelacXlsx2Csv" version="1.0.1">
   <description>to split a xlsx spatial unit configuration file into csv sheet 4 REDELAC</description>
   <requirements>
-    <container type="singularity">docker://registry.forgemia.inra.fr/redelac/redelac-toolbox:latest</container>
+    <container type="singularity">docker://registry.forge.inrae.fr/redelac/redelac-toolbox:latest</container>
   </requirements>
   <command detect_errors="aggressive">
     <![CDATA[
-	     python  $__tool_directory__/redelacxlsx2csv.py ${REDELACrot} ${USMs} ${Tec} ${Ini} ${Station} ${Liste_plantes}
+	     python  $__tool_directory__/redelacxlsx2csv.py ${REDELACrot} ${USMs} ${Tec} ${Ini} ${Station} ${Liste_plantes} ${Successions}
      ]]>
   </command>
   <inputs>
@@ -18,6 +18,7 @@
     <data name="Tec" format="csv" label="TecSheet${Tag}"/>
     <data name="Ini" format="csv" label="IniSheet${Tag}"/>
     <data name="Liste_plantes" format="csv" label="Liste_plantesSheet${Tag}"/>
+    <data name="Successions" format="csv" label="Successions${Tag}"/>
   </outputs>
   <tests>
   </tests>