Bonjour,
Il faut passer les exports en format YAML, voir la doc. C'est facile.
Cordialement,
GEORGES *BEYNA*
[email protected] a écrit :
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 [email protected]
To unsubscribe send an email [email protected]
_______________________________________________
Galette-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
