Export CSV pour OMEKA

Export CSV pour OMEKA items.itype remplacer xx par code type documentCe fichier tient compte du mapping de l'entete avec ceux du module CSV Import.Pour les liens images ou PDF, il suffit de cocher la case "Files".

Module Koha: 
Administration
SQL: 
SELECT SUBSTRING(ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code>="a"]'),10,4) AS Annee_Publication, biblio.title AS "Dublin Core:Title", CONCAT (ExtractValue(marcxml,'//datafield[@tag="700"]/subfield[@code>="a"][1]'),", ",ExtractValue(marcxml,'//datafield[@tag="700"]/subfield[@code>="b"][1]')," (",ExtractValue(marcxml,'//datafield[@tag="700"]/subfield[@code>="f"][1]'),")") AS "Dublin Core:Creator", CONCAT (ExtractValue(marcxml,'//datafield[@tag="701"]/subfield[@code>="a"][1]'),", ",ExtractValue(marcxml,'//datafield[@tag="701"]/subfield[@code>="b"][1]')," (",ExtractValue(marcxml,'//datafield[@tag="701"]/subfield[@code>="f"][1]'),")") AS "Dublin Core:Contributor", ExtractValue(marcxml,'//datafield[@tag="600"]/*') AS "Dublin Core:Subject", biblio.notes AS "Dublin Core:Description", CONCAT(ExtractValue(marcxml,'//datafield[@tag="210"]/subfield[@code>="c"][1]')," (",ExtractValue(marcxml,'//datafield[@tag="210"]/subfield[@code>="a"][1]'),")") AS "Dublin Core:Publisher", ExtractValue(marcxml,'//datafield[@tag="210"]/subfield[@code>="d"][1]') AS "Dublin Core:Date", ExtractValue(marcxml,'//datafield[@tag="200"]/subfield[@code>="b"][1]') AS "Dublin Core:Type", ExtractValue(marcxml,'//datafield[@tag="215"]/*') AS "Dublin Core:Format", biblioitems.lccn AS "Dublin Core:Identifier", CONCAT('École nationale des chartes, ',items.itemcallnumber) AS "Dublin Core:Source", ExtractValue(marcxml,'//datafield[@tag="101"]/subfield[@code>="a"][1]') AS "Dublin Core:Language", ExtractValue(marcxml,'//datafield[@tag="856"]/subfield[@code>="u"][1]') AS "LINK1", ExtractValue(marcxml,'//datafield[@tag="856"]/subfield[@code>="u"][2]') AS "LINK2", FROM `items` LEFT JOIN biblio USING (biblionumber) LEFT JOIN biblioitems USING (biblionumber) WHERE items.itype = 'xx' ORDER BY Annee_Publication
Type d'établissement: 
Tout type
Votre établissement: 
Ecole nationale des chartes