{"id":5101,"date":"2016-11-24T20:44:50","date_gmt":"2016-11-24T19:44:50","guid":{"rendered":"http:\/\/latelierdediablotin.fr\/WordPress3\/?p=5101"},"modified":"2016-11-24T20:46:03","modified_gmt":"2016-11-24T19:46:03","slug":"une-base-de-donnees-en-etat-de-marche","status":"publish","type":"post","link":"https:\/\/latelierdediablotin.fr\/WordPress3\/une-base-de-donnees-en-etat-de-marche\/","title":{"rendered":"Une base de donn\u00e9es en \u00e9tat de marche !"},"content":{"rendered":"<p style=\"text-align: justify;\"><a href=\"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-5102\" src=\"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD-300x193.jpg\" alt=\"discobdd\" width=\"300\" height=\"193\" srcset=\"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD-300x193.jpg 300w, https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD-768x493.jpg 768w, https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD.jpg 839w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\u00c7a y est, j\u2019ai enfin fini de peaufiner la base de donn\u00e9es qui me sert \u00e0 recenser et classer ma discoth\u00e8que. A dire vrai, il existe un tas d\u2019outils plus ou moins bien faits qui permettent de r\u00e9aliser cette op\u00e9ration plus ou moins ais\u00e9ment, avec une jolie interface et avec des options plus ou moins nombreuses, mais ils se r\u00e9v\u00e8lent, \u00e0 l\u2019usage, plus ou moins fonctionnels d\u00e8s lors qu\u2019on veut y entrer des informations complexes dans le cas d\u2019une discoth\u00e8que classique. Et donc, aucun ne me convenait r\u00e9ellement. Je me suis donc lanc\u00e9 dans l&rsquo;utilisation de <a href=\"http:\/\/www.filemaker.com\/fr\/products\/filemaker-pro\/\" target=\"_blank\"><span style=\"text-decoration: underline;\"><strong>File Maker<\/strong><\/span><\/a>, que je n&rsquo;avais plus c\u00f4toy\u00e9 depuis des lustres&#8230; Mais, assez rapidement, de vieux r\u00e9flexes se sont rappel\u00e9s \u00e0 mon souvenir !<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD_2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-medium wp-image-5104\" src=\"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD_2-300x212.jpg\" alt=\"discobdd_2\" width=\"300\" height=\"212\" srcset=\"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD_2-300x212.jpg 300w, https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD_2-768x543.jpg 768w, https:\/\/latelierdediablotin.fr\/WordPress3\/wp-content\/uploads\/2016\/11\/DiscoBDD_2.jpg 842w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>Je me suis donc lanc\u00e9 il y a quelques temps, et j\u2019ai import\u00e9 les donn\u00e9es issues de mon fichier Excel, \u00e0\u00a0 jour, mais <del>difficilement utilisable<\/del> inutilisable pour lancer des requ\u00eates crois\u00e9es, et servant donc plus de catalogue que de vraie base de donn\u00e9es complexe. J\u2019ai opt\u00e9 pour une interface aussi sobre et lisible que possible &#8211;<em>les couleurs bariol\u00e9es fa\u00e7on Windows 3.1 piquent vite les yeux !!!<\/em>-, tant pour l\u2019affichage \u00e0 l\u2019\u00e9cran &#8211;<em>cliquer sur l\u2019imagette de gauche pour voir comment cela s\u2019affiche<\/em>&#8211; que pour les \u00e9ventuelles impressions &#8211;<em>\u00e7a peut toujours servir pour envoyer \u00e0 l\u2019un ou l\u2019autre qui me demande ce que contient tel ou tel album : cliquer sur l\u2019imagette de droite pour en avoir une id\u00e9e. Il faudra simplement que je supprime de ce mod\u00e8le les boutons de requ\u00eates, qui ne servent \u00e0 rien sur du papier&#8230;<\/em>-.<\/p>\n<p style=\"text-align: justify;\">Evidemment, le plus gros du travail a consist\u00e9\u00a0\u00e0 saisir l\u2019ensemble des donn\u00e9es, mais je m\u2019\u00e9tais d\u00e9j\u00e0 adonn\u00e9 \u00e0 cet exercice fastidieux <a href=\"https:\/\/latelierdediablotin.fr\/WordPress3\/2014\/02\/travail-de-titan\/\" target=\"_blank\"><span style=\"text-decoration: underline;\"><strong>il y a fort longtemps<\/strong><\/span><\/a>.<\/p>\n<p style=\"text-align: justify;\">D\u00e9sormais, je cherche un moyen simple d\u2019incorporer une image de chaque pochette \u00e0 chaque fiche, ce qui n\u2019est pas si \u00e9vident que \u00e7a en a l\u2019air, et il semble qu&rsquo;il faille que je m&rsquo;oriente vers un croisement de deux bases de donn\u00e9es, dont l&rsquo;une en contiendrait que les illustrations\u2026 Pour le reste, les boutons de script appelant des requ\u00eates fonctionnent parfaitement bien !<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00c7a y est, j\u2019ai enfin fini de peaufiner la base de donn\u00e9es qui me sert \u00e0 recenser et classer ma discoth\u00e8que. A dire vrai, il existe un tas d\u2019outils plus ou moins bien faits qui permettent de r\u00e9aliser cette op\u00e9ration plus ou moins ais\u00e9ment, avec une jolie interface et avec des options plus ou moins [&hellip;]<\/p>\n","protected":false},"author":667,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[86,46,35],"class_list":["post-5101","post","type-post","status-publish","format-standard","hentry","category-au-jour-le-jour","tag-discotheque","tag-logiciel","tag-ordinateur"],"_links":{"self":[{"href":"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-json\/wp\/v2\/posts\/5101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-json\/wp\/v2\/users\/667"}],"replies":[{"embeddable":true,"href":"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-json\/wp\/v2\/comments?post=5101"}],"version-history":[{"count":0,"href":"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-json\/wp\/v2\/posts\/5101\/revisions"}],"wp:attachment":[{"href":"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-json\/wp\/v2\/media?parent=5101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-json\/wp\/v2\/categories?post=5101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/latelierdediablotin.fr\/WordPress3\/wp-json\/wp\/v2\/tags?post=5101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}