{"id":81819,"date":"2016-02-05T18:04:38","date_gmt":"2016-02-05T16:04:38","guid":{"rendered":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/"},"modified":"2025-09-12T10:15:45","modified_gmt":"2025-09-12T08:15:45","slug":"catalogue-update-tool","status":"publish","type":"post","link":"https:\/\/centcols.org\/en\/outil-de-mise-a-jour-des-catalogues\/","title":{"rendered":"Catalogue update tool"},"content":{"rendered":"<h2 class=\"wp-block-heading\">Goal<\/h2>\n\n\n\n<p>Members who have customised their collar files from catalogues by adding columns can update them when new versions of the catalogues are published.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Use<\/h2>\n\n\n\n<p>Three files are required for the update:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>an old catalogue with custom columns added <em>on the right<\/em> standard columns,<\/li>\n\n\n\n<li>a new version of the catalogue as it may be <a href=\"https:\/\/centcols.org\/membres\/outils\/teleCatA.php\" target=\"_blank\" rel=\"noopener\">downloaded<\/a> by members,<\/li>\n\n\n\n<li>a tool created by Christophe Aug\u00e9 (member 5783) and available in two downloadable versions:\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/centcols.org\/additifs\/majcat.xls\">Excel version (XLS)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/centcols.org\/additifs\/majcat.ods\">Open\/LibreOffice Calc version<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>Instructions for use are displayed in the file itself. The two other files opened at the same time in Excel resp. Calc.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Warnings<\/h2>\n\n\n\n<p>Please enter the file names in a case-sensitive manner. Otherwise, an error message will be displayed saying that the file is not open.<\/p>\n\n\n\n<p>Updating can take time, especially for catalogues containing several thousand passes. With the Excel version, the Cols de France catalogue, for example, normally takes a few minutes, with no progress displayed. It has also been known to take several hours, but after a system update (Windows), the speed returned to normal. So not everything is predictable. With LibreOffice, the update can take more than an hour, but you can see the progress on the display. These tools are made available after they have been tested, but <em>without any guarantee from the club<\/em>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">See also...<\/h2>\n\n\n\n<p>The <a href=\"https:\/\/centcols.org\/en\/additives\/\">additives<\/a> collar catalogues.<\/p>","protected":false},"excerpt":{"rendered":"<p>But Les membres qui ont personnalis\u00e9 leurs fichiers de cols \u00e0 partir de catalogues en leur ajoutant des colonnes peuvent les mettre \u00e0 jour quand de nouvelles versions des catalogues sont publi\u00e9es. Utilisation Trois fichiers sont n\u00e9cessaires pour faire la mise \u00e0 jour: Les instructions pour l&rsquo;utilisation sont affich\u00e9es dans le fichier lui-m\u00eame. Les deux [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":84370,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[428,260],"tags":[],"class_list":["post-81819","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutos-pour-cols","category-tutoriels"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Outil de mise \u00e0 jour des catalogues - Club des Cent Cols<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/centcols.org\/en\/catalogue-update-tool\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Outil de mise \u00e0 jour des catalogues - Club des Cent Cols\" \/>\n<meta property=\"og:description\" content=\"But Les membres qui ont personnalis\u00e9 leurs fichiers de cols \u00e0 partir de catalogues en leur ajoutant des colonnes peuvent les mettre \u00e0 jour quand de nouvelles versions des catalogues sont publi\u00e9es. Utilisation Trois fichiers sont n\u00e9cessaires pour faire la mise \u00e0 jour: Les instructions pour l&rsquo;utilisation sont affich\u00e9es dans le fichier lui-m\u00eame. Les deux [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/centcols.org\/en\/catalogue-update-tool\/\" \/>\n<meta property=\"og:site_name\" content=\"Club des Cent Cols\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/groups\/5261880558\/?locale=fr_FR\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-05T16:04:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-12T08:15:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"491\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Patrick Schleppi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Patrick Schleppi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/\"},\"author\":{\"name\":\"Patrick Schleppi\",\"@id\":\"https:\/\/centcols.org\/#\/schema\/person\/c45ad1dcfa4988b57fcd5119a431cdba\"},\"headline\":\"Outil de mise \u00e0 jour des catalogues\",\"datePublished\":\"2016-02-05T16:04:38+00:00\",\"dateModified\":\"2025-09-12T08:15:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/\"},\"wordCount\":272,\"publisher\":{\"@id\":\"https:\/\/centcols.org\/#organization\"},\"image\":{\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg\",\"articleSection\":[\"Tutos pour cols\",\"Tutoriels\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/\",\"url\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/\",\"name\":\"Outil de mise \u00e0 jour des catalogues - Club des Cent Cols\",\"isPartOf\":{\"@id\":\"https:\/\/centcols.org\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg\",\"datePublished\":\"2016-02-05T16:04:38+00:00\",\"dateModified\":\"2025-09-12T08:15:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#primaryimage\",\"url\":\"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg\",\"contentUrl\":\"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg\",\"width\":900,\"height\":491},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/centcols.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutoriels\",\"item\":\"https:\/\/centcols.org\/rubrique\/tutoriels\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Outil de mise \u00e0 jour des catalogues\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/centcols.org\/#website\",\"url\":\"https:\/\/centcols.org\/\",\"name\":\"Club des Cent Cols\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/centcols.org\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/centcols.org\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/centcols.org\/#organization\",\"name\":\"Club des Cent Cols\",\"url\":\"https:\/\/centcols.org\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/centcols.org\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/centcols.org\/wp-content\/uploads\/2025\/01\/carte-icone.png\",\"contentUrl\":\"https:\/\/centcols.org\/wp-content\/uploads\/2025\/01\/carte-icone.png\",\"width\":250,\"height\":250,\"caption\":\"Club des Cent Cols\"},\"image\":{\"@id\":\"https:\/\/centcols.org\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/groups\/5261880558\/?locale=fr_FR\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/centcols.org\/#\/schema\/person\/c45ad1dcfa4988b57fcd5119a431cdba\",\"name\":\"Patrick Schleppi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/centcols.org\/wp-content\/litespeed\/avatar\/ab1e6c82cebaaf50c03181b71859291e.jpg?ver=1777234725\",\"url\":\"https:\/\/centcols.org\/wp-content\/litespeed\/avatar\/ab1e6c82cebaaf50c03181b71859291e.jpg?ver=1777234725\",\"contentUrl\":\"https:\/\/centcols.org\/wp-content\/litespeed\/avatar\/ab1e6c82cebaaf50c03181b71859291e.jpg?ver=1777234725\",\"caption\":\"Patrick Schleppi\"},\"url\":\"https:\/\/centcols.org\/en\/author\/5845\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Catalogue update tool - Club des Cent Cols","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/centcols.org\/en\/catalogue-update-tool\/","og_locale":"en_GB","og_type":"article","og_title":"Outil de mise \u00e0 jour des catalogues - Club des Cent Cols","og_description":"But Les membres qui ont personnalis\u00e9 leurs fichiers de cols \u00e0 partir de catalogues en leur ajoutant des colonnes peuvent les mettre \u00e0 jour quand de nouvelles versions des catalogues sont publi\u00e9es. Utilisation Trois fichiers sont n\u00e9cessaires pour faire la mise \u00e0 jour: Les instructions pour l&rsquo;utilisation sont affich\u00e9es dans le fichier lui-m\u00eame. Les deux [&hellip;]","og_url":"https:\/\/centcols.org\/en\/catalogue-update-tool\/","og_site_name":"Club des Cent Cols","article_publisher":"https:\/\/www.facebook.com\/groups\/5261880558\/?locale=fr_FR","article_published_time":"2016-02-05T16:04:38+00:00","article_modified_time":"2025-09-12T08:15:45+00:00","og_image":[{"width":900,"height":491,"url":"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg","type":"image\/jpeg"}],"author":"Patrick Schleppi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Patrick Schleppi","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#article","isPartOf":{"@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/"},"author":{"name":"Patrick Schleppi","@id":"https:\/\/centcols.org\/#\/schema\/person\/c45ad1dcfa4988b57fcd5119a431cdba"},"headline":"Outil de mise \u00e0 jour des catalogues","datePublished":"2016-02-05T16:04:38+00:00","dateModified":"2025-09-12T08:15:45+00:00","mainEntityOfPage":{"@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/"},"wordCount":272,"publisher":{"@id":"https:\/\/centcols.org\/#organization"},"image":{"@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#primaryimage"},"thumbnailUrl":"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg","articleSection":["Tutos pour cols","Tutoriels"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/","url":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/","name":"Catalogue update tool - Club des Cent Cols","isPartOf":{"@id":"https:\/\/centcols.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#primaryimage"},"image":{"@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#primaryimage"},"thumbnailUrl":"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg","datePublished":"2016-02-05T16:04:38+00:00","dateModified":"2025-09-12T08:15:45+00:00","breadcrumb":{"@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#primaryimage","url":"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg","contentUrl":"https:\/\/centcols.org\/wp-content\/uploads\/2016\/02\/catalogueoutils.jpg","width":900,"height":491},{"@type":"BreadcrumbList","@id":"https:\/\/centcols.org\/outil-de-mise-a-jour-des-catalogues\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/centcols.org\/"},{"@type":"ListItem","position":2,"name":"Tutoriels","item":"https:\/\/centcols.org\/rubrique\/tutoriels\/"},{"@type":"ListItem","position":3,"name":"Outil de mise \u00e0 jour des catalogues"}]},{"@type":"WebSite","@id":"https:\/\/centcols.org\/#website","url":"https:\/\/centcols.org\/","name":"Club des Cent Cols","description":"","publisher":{"@id":"https:\/\/centcols.org\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/centcols.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/centcols.org\/#organization","name":"Club des Cent Cols","url":"https:\/\/centcols.org\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/centcols.org\/#\/schema\/logo\/image\/","url":"https:\/\/centcols.org\/wp-content\/uploads\/2025\/01\/carte-icone.png","contentUrl":"https:\/\/centcols.org\/wp-content\/uploads\/2025\/01\/carte-icone.png","width":250,"height":250,"caption":"Club des Cent Cols"},"image":{"@id":"https:\/\/centcols.org\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/groups\/5261880558\/?locale=fr_FR"]},{"@type":"Person","@id":"https:\/\/centcols.org\/#\/schema\/person\/c45ad1dcfa4988b57fcd5119a431cdba","name":"Patrick Schleppi","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/centcols.org\/wp-content\/litespeed\/avatar\/ab1e6c82cebaaf50c03181b71859291e.jpg?ver=1777234725","url":"https:\/\/centcols.org\/wp-content\/litespeed\/avatar\/ab1e6c82cebaaf50c03181b71859291e.jpg?ver=1777234725","contentUrl":"https:\/\/centcols.org\/wp-content\/litespeed\/avatar\/ab1e6c82cebaaf50c03181b71859291e.jpg?ver=1777234725","caption":"Patrick Schleppi"},"url":"https:\/\/centcols.org\/en\/author\/5845\/"}]}},"_links":{"self":[{"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/posts\/81819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/comments?post=81819"}],"version-history":[{"count":0,"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/posts\/81819\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/media\/84370"}],"wp:attachment":[{"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/media?parent=81819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/categories?post=81819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centcols.org\/en\/wp-json\/wp\/v2\/tags?post=81819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}