Archives de la liste a​i​d​e​@p​a​h​e​k​o​.c​l​o​u​d​

Échec dans l'import d'écritures en format CSV

Charles VALANCOGNE

22/03/2023 11:03:50

Pardonnez-moi ce doublon. Mon envoi précédent est passé comme une 
réponse à une autre question alors que c'est un nouveau sujet.

---

Bonjour,

J'ai exporté les écritures d'un exercice au format CSV avec le type 
d'export "Complet (comptabilité d'engagement)" depuis un site 
Garradin/Paheco en version 1.2.5.

J'ai voulu importer les données au format CSV ainsi récupérées dans une 
nouvelle installation en version 1.2.7, après avoir initialisé 
l'exercice pour la même période.
J'ai utilisé pour l'import le type "Complet (comptabilité
d'engagement)".
Je bloque sur une erreur à la ligne 2, "Cette écriture comporte moins de 
deux lignes".  :

Et pourtant, il y a bien les écritures sur au moins 2 lignes, 10 lignes 
pour la première.

Je n'ai pas vu de différences entre des exports de la version 1.2.7 par 
rapport à la 1.2.5 si ce n'est un entête "Projet analytique" qui a 
remplacé "Compte analytique", et qui peut ne pas être utilisé dans
l'import.

Ci après, les 35 premières lignes de mon fichier CSV.

Merci pour votre aide.

Charles Valancogne

========================================

"Numéro
d'écriture","Type","Statut","Libellé","Date","Remarques","Numéro

pièce comptable","Numéro compte","Libellé 
compte","Débit","Crédit","Référence
ligne","Libellé 
ligne","Rapprochement","Compte analytique","Membres
associés"
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","890","Bilan

d'ouverture","240,00","0","","chèque 1400 du
16/12/2018 non 
débité","0","",""
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","890","Bilan

d'ouverture","0","450,00","","Prêt au
Courrier International","0","",""
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","890","Bilan

d'ouverture","0","7033,28","","Compte Frat
nationale","0","",""
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","890","Bilan

d'ouverture","0","6138,38","","Compte
Courrier","0","",""
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","890","Bilan

d'ouverture","0","42445,86","","Livret
A","0","",""
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","5112","Chèques

à encaisser","0","240,00","","chèque 1400 du
16/12/2018 non 
débité","0","",""
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","512A","SG
Frat 
nationale","7033,28","0","","Compte Frat nationale
au 31/12/2018","0","",""
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","512B","SG

Courrier","6138,38","0","","ompte Courrier au
31/12/2018","0","",""
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","512C","SG

Livret A","42445,86","0","","Livret A au
31/12/2018","0","",""
"2","Avancé","","Balance
d'ouverture","01/01/2019","","","4687","Divers

- Produits à recevoir","450,00","0","","Prêt au
Courrier 
International","0","",""
"19","Avancé","","Edition Services -
graphiste","01/01/2019","Edition 
Services - graphiste","","512B","SG 
Courrier","0","1152,00","chèque","","0","",""
"19","Avancé","","Edition Services -
graphiste","01/01/2019","Edition 
Services - graphiste","","60101","COURRIER 
Composition","1152,00","0","chèque","","0","",""
"20","Avancé","","CORLET
Impression","01/01/2019","CORLET 
Impression","","512B","SG
Courrier","0","1843,63","chèque","","0","",""
"20","Avancé","","CORLET
Impression","01/01/2019","CORLET 
Impression","","60102","COURRIER Impression 
Routage","1843,63","0","chèque","","0","",""
"21","Avancé","","CORLET
Routage","01/01/2019","CORLET 
Routage","","512B","SG
Courrier","0","407,69","chèque","","0","",""
"21","Avancé","","CORLET
Routage","01/01/2019","CORLET 
Routage","","60102","COURRIER Impression 
Routage","407,69","0","chèque","","0","",""
"3","Avancé","","Intérêt Livret A année 
2018","03/01/2019","","","768","Autres
produits 
financiers","0","318,27","Virement","","0","",""
"3","Avancé","","Intérêt Livret A année 
2018","03/01/2019","","","512C","SG
Livret 
A","318,27","0","Virement","","0","",""
"4","Avancé","","Commission SOGECASH
NET","03/01/2019","","","512A","SG 
Frat
nationale","0","9,60","Prélèvement","","0","",""
"4","Avancé","","Commission SOGECASH 
NET","03/01/2019","","","627","Services
bancaires et 
assimilés","9,60","0","Prélèvement","","0","",""
"22","Avancé","","La
Poste","09/01/2019","La
Poste","","512B","SG 
Courrier","0","393,38","Prélèvement","","0","",""
"22","Avancé","","La
Poste","09/01/2019","La
Poste","","60103","COURRIER 
Poste","393,38","0","Prélèvement","","0","",""
"23","Avancé","","Divers","11/01/2019","Divers","","70814","COURRIER
non 
affecté en
Région","0","20,00","chèque","","0","",""
"23","Avancé","","Divers","11/01/2019","Divers","","512B","SG

Courrier","20,00","0","chèque","","0","",""
"24","Avancé","","Divers","11/01/2019","Divers","","70814","COURRIER
non 
affecté en
Région","0","40,00","chèque","","0","",""
"24","Avancé","","Divers","11/01/2019","Divers","","512B","SG

Courrier","40,00","0","chèque","","0","",""
"25","Avancé","","Divers","11/01/2019","Divers","","70814","COURRIER
non 
affecté en
Région","0","20,00","chèque","","0","",""
"25","Avancé","","Divers","11/01/2019","Divers","","512B","SG

Courrier","20,00","0","chèque","","0","",""
"26","Avancé","","Divers","11/01/2019","Divers","","70814","COURRIER
non 
affecté en
Région","0","20,00","chèque","","0","",""
"26","Avancé","","Divers","11/01/2019","Divers","","512B","SG

Courrier","20,00","0","chèque","","0","",""
"27","Avancé","","Divers","11/01/2019","Divers","","70814","COURRIER
non 
affecté en
Région","0","20,00","chèque","","0","",""
"27","Avancé","","Divers","11/01/2019","Divers","","512B","SG

Courrier","20,00","0","chèque","","0","",""
"28","Avancé","","Divers","11/01/2019","Divers","","70814","COURRIER
non 
affecté en
Région","0","27,00","chèque","","0","",""
"28","Avancé","","Divers","11/01/2019","Divers","","512B","SG

Courrier","27,00","0","chèque","","0","",""

Échec dans l'import d'écritures en format CSV

BohwaZ/Paheko

22/03/2023 18:57:15

Ton CSV correspond au format "complet" et tu essaye d'importer le
format "groupé".

Donc forcément ça ne peut pas marcher, pour importer au format "groupé"
il faut un export au format "groupé", forcément :)

Je te laisse donc refaire un export au bon format :)

Bonne soirée.

Échec dans l'import d'écritures en format CSV

Charles VALANCOGNE

22/03/2023 20:43:43

Un grand merci.
Et pardonne-moi pour le dérangement. J'ai lu un peu trop vite les notes 
dans la page d'import.
Ça marche bien.

Je pense maintenant pouvoir éviter de nombreuses saisies pour échapper à 
un problème de base qui a dû être corrompue au gré des évolutions de 
version en fin d'année 2022 et début 2023.

J'ai 2 sites chez OVH. Les mises à jour automatiques ne se faisaient pas 
toujours correctement. J'ai dû en faire manuellement par sftp. Pas de 
problème majeur pour l'un, mais pour l'autre impossible de mettre à jour 
après la version 1.2.5.

Bonne soirée.

Charles

Le 22/03/2023 à 18:56, BohwaZ/Paheko a écrit :
> Ton CSV correspond au format "complet" et tu essaye d'importer
le
> format "groupé".
>
> Donc forcément ça ne peut pas marcher, pour importer au format
"groupé"
> il faut un export au format "groupé", forcément :)
>
> Je te laisse donc refaire un export au bon format :)
>
> Bonne soirée.
>