[Qgis_fr] [Plugin Casdastre] Manque une colonne à l'import

Message posté par : tevrard ---------------------------------------- Bonjour, J'ai un import EDIGEO + MAJIC qui me donne cette erreur : ----------------- Code : - Traitement: Erreur rencontrée pour la requête: -- Traitement: INSERT INTO pevlissage ( pevlissage, annee, ccodep, ccodir, ccocom, invar, dnupev, mlbcom, mlbsyn, mlbcu , mlbdep, mlbts1, mlbts2, mlbtas, mlbgem, mlbtom, tbfpas, mlbtfc, pev, lot ) SELECT DISTINCT REPLACE(SUBSTR(tmp,1,3)||SUBSTR(tmp,7,10)||SUBSTR(tmp,28,3),' ', '0') AS pevlissage, '2021', SUBSTR(tmp,1,2) AS ccodep, SUBSTR(tmp,3,1) AS ccodir, SUBSTR(tmp,4,3) AS ccocom, SUBSTR(tmp,7,10) AS invar, SUBSTR(tmp,28,3) AS dnupev, CASE WHEN trim(SUBSTR(tmp,36,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,36,11) AS float) END AS mlbcom, CASE WHEN trim(SUBSTR(tmp,48,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,48,11) AS float) END AS mlbsyn, CASE WHEN trim(SUBSTR(tmp,60,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,60,11) AS float) END AS mlbcu, CASE WHEN trim(SUBSTR(tmp,72,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,72,11) AS float) END AS mlbdep, CASE WHEN trim(SUBSTR(tmp,84,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,84,11) AS float) END AS mlbts1, CASE WHEN trim(SUBSTR(tmp,96,11))='' THEN NULL ELSE CAST( SUBSTR(tmp,96,11) AS float) END AS mlbts2, CASE WHEN trim(SUBSTR(tmp,108,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,108,11) AS float) END AS mlbtas, CASE WHEN trim(SUBSTR(tmp,120,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,120,11) AS float) END AS mlbgem, CASE WHEN trim(SUBSTR(tmp,132,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,132,11) AS float) END AS mlbtom, CASE WHEN trim(SUBSTR(tmp,144,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,144,11) AS float) END AS tbfpas, CASE WHEN trim(SUBSTR(tmp,168,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,168,11) AS float) END AS mlbtfc, REPLACE(SUBSTR(tmp,1,3)||SUBSTR(tmp,7,10)||SUBSTR(tmp,28,3),' ', '0') AS pev, '71' AS lot FROM bati WHERE SUBSTR(tmp,31,2) ='52' Erreur table pevlissage has no column named mlbtfc FINALISATION ----------------- Ma première impression est que l'erreur vient d'une mauvaise version de format (déclarée ici a 2021)... Pouvez vous me confirmer cette hypothèse ou sinon m'indiquer quel élément provoque cette erreur? ---------------------------------------- Le message est situé https://georezo.net/forum/viewtopic.php?pid=351199#p351199 Pour y répondre : qgis_fr(a)ml.georezo.net ou reply de votre messagerie Pour vous désabonner connectez-vous sur le forum puis Profil / Abonnement -- Association GeoRezo - le portail géomatique https://georezo.net