Bonjour,

Il faut passer les exports en format YAML, voir la doc. C'est facile.

Bonjour,

Après la mise à jour d'une version 0.9x vers 1.1.5.2, un export paramétré affiche désormais une erreur :
" Une erreur est survenue durant l'exécution de l'export paramétré « Adherents-Groupes-Infosdyn ». "
Dans le log on trouve :
" ERROR - An error occurred while exporting | Undefined array key "query" "

----------------------
Contenu du fichier export.xml :
----------------------

<?xml version="1.0" encoding="UTF-8"?>
<exports>
	<!-- Model: List all cotisations amounts, begin and end dates with adherent name and town -->
	<!-- Name will be used for display on export.php page. filename sets the filename for output file :)
	     id must be a unique identifier in this file. All three attributes are required !
	     You can deactivate a configuration by adding attribute inactive="inactive" here.
	-->
	<export id="cotisations" name="Cotisations" description="Export de l'état des cotisations pour l'ensemble des adhérents" filename="galette_cotisations.csv">
		<!-- The Query to execute - mandatory -->
		<query>SELECT nom_adh, prenom_adh, ville_adh, montant_cotis, date_debut_cotis, date_fin_cotis FROM galette_cotisations INNER JOIN galette_adherents ON (galette_cotisations.id_adh=galette_adherents.id_adh)</query>
		<!-- CSV Headers - optionnal.
		     If not set, fields name will be exported.
		     If set to none (eg. <headers><none/></headers>, no headers will be outpoutted.
		     You can alternatively use named columns in you query instead of header tags.
                -->
		<headers>
			<!--<none/>-->
			<header>Name</header>
			<header>Surname</header>
			<header>Town</header>
			<header>Amount</header>
			<header>Begin date</header>
			<header>End date</header>
		</headers>
		<!-- CSV separator to use - optionnal.
		     If this tag is not present, it will defaults to ',' (see Csv::DEFAULT_SEPARATOR from classes/csv.class.php)
		     Accepted values are also defined in Csv class.
		-->
		<separator>;</separator>
		<!-- How to quote values - optionnal.
		     If this tag is not present, it will defaults to '"' (see Csv::DEFAULT_QUOTE from classes/csv.class.php)
		     Accepted values are also defined in Csv class.
		-->
		<quote><![CDATA["]]></quote>
	</export>
  
  	<export id="adherentsgroupesdyn" name="Adherents-Groupes-Infosdyn" description="Export des adhérents, leur(s) groupe(s) plus champs dynamiques pour l'ensemble des adhérents" filename="galette_adherent-groupes-dyn.csv">
		<!-- The Query to execute - mandatory -->
		<query>
    SELECT nom_adh, prenom_adh, ville_adh, UPPER(group_name), CONCAT('   ', '| ', '   ') AS vide, UPPER(field_name), field_val 
    FROM galette_adherents INNER JOIN galette_dynamic_fields ON (galette_adherents.id_adh=galette_dynamic_fields.item_id) 
    JOIN galette_field_types ON (galette_dynamic_fields.field_id=galette_field_types.field_id) 
    JOIN galette_groups_members ON (galette_adherents.id_adh=galette_groups_members.id_adh)
    JOIN galette_groups ON (galette_groups_members.id_group=galette_groups.id_group) 
    ORDER BY nom_adh, prenom_adh;
    </query>
		<!-- CSV Headers - optionnal.               
		     If not set, fields name will be exported.
		     If set to none (eg. <headers><none/></headers>, no headers will be outpoutted.
		     You can alternatively use named columns in you query instead of header tags.
                -->
		<headers>
			<!--<none/>-->
			<header>NOM</header>
			<header>PRENOM</header>
			<header>VILLE</header>
      <header>GROUPE</header>
      <header> </header>
			<header>REFERENCE</header>
      <header>INFO</header>
		</headers>
		<!-- CSV separator to use - optionnal.
		     If this tag is not present, it will defaults to ',' (see Csv::DEFAULT_SEPARATOR from classes/csv.class.php)
		     Accepted values are also defined in Csv class.
		-->
		<separator>;</separator>
		<!-- How to quote values - optionnal.
		     If this tag is not present, it will defaults to '"' (see Csv::DEFAULT_QUOTE from classes/csv.class.php)
		     Accepted values are also defined in Csv class.
		-->
		<quote><![CDATA["]]></quote>
	</export>
</exports>

----------------------
----------------------

Je ne sais pas corriger cela et je ne trouve plus le moyen de générer cette requête, ce qu'il me semble avoir pu faire lors de l'installation initiale ...

HELP PLEASE ! :)

Merci d'avance pour toute aide, piste et autre indication qui pourrait me permettre de résoudre cela.
_______________________________________________
Galette-users mailing list -- galette-users@mailman3.com
To unsubscribe send an email to galette-users-leave@mailman3.com