{"id":12654,"date":"2024-12-14T16:13:32","date_gmt":"2024-12-14T15:13:32","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=12654"},"modified":"2024-12-14T16:13:32","modified_gmt":"2024-12-14T15:13:32","slug":"projet-ixp-v1-2beta-requetes-sql-sur-bases-de-donnees-access","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=12654","title":{"rendered":"Projet IXP (v1.2beta) : requ\u00eates SQL sur bases de donn\u00e9es Access"},"content":{"rendered":"<p style=\"text-align: justify;\">Mon projet IXP (interpr\u00e9teur d\u2019expressions) int\u00e8gre progressivement de <strong>nouvelles fonctions<\/strong>. Pour m\u00e9moire, ce logiciel effectue des calculs et du traitement de donn\u00e9es comptables. Il est bas\u00e9 sur un langage d\u2019expression LIXP qui permet de cha\u00eener et automatiser des calculs pr\u00e9programm\u00e9s, des requ\u00eates SQL, des appels API, des exports (fichiers texte)\u2026<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12655\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-7.png\" alt=\"EX IXP 7\" width=\"1344\" height=\"745\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-7.png 1344w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-7-300x166.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-7-1024x568.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-7-768x426.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-7-730x405.png 730w\" sizes=\"auto, (max-width: 1344px) 100vw, 1344px\" \/><\/p>\n<p style=\"text-align: justify;\">Derni\u00e8res fonctions en date (en lien avec le <strong>processus ETL<\/strong>) : collecte de donn\u00e9es (<strong>requ\u00eates SQL<\/strong>) sur des <strong>bases de donn\u00e9es Access<\/strong> (boucle de calcul sur l&#8217;ensemble des bases de donn\u00e9es situ\u00e9es dans un dossier et r\u00e9pondant \u00e0 des crit\u00e8res pr\u00e9cis&#8230;) et <strong>envoi de fichiers par m\u00e9l<\/strong>.<\/p>\n<p>___<\/p>\n<p style=\"text-align: justify;\">Le <strong>projet IXP<\/strong> est dot\u00e9 de nombreuses <strong>fonctions de calculs<\/strong> (langage d&#8217;expression LIXP) qui portent sur des sujets vari\u00e9s qu\u2019un r\u00e9viseur ou auditeur comptable retrouve dans son quotidien : reconstitution d\u2019\u00e9ch\u00e9ancier d\u2019emprunt, calcul de RSP (r\u00e9serve sp\u00e9ciale de participation) avec prise en compte du forfait social, pourcentage d\u2019int\u00e9r\u00eat (y compris avec participation crois\u00e9e sur la consolidante) et analyse des comptes de soci\u00e9t\u00e9s \u00e0 partir du FEC (fusion de FEC, diff\u00e9rence de versions entre deux FEC, requ\u00eates SQL sur FEC, analyse de la TVA\u2026).<\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Projet%20IXP%20%28v1.2beta%29%20%3A%20requ%C3%AAtes%20SQL%20sur%20bases%20de%20donn%C3%A9es%20Access\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Mon projet IXP (interpr\u00e9teur d\u2019expressions) int\u00e8gre progressivement de nouvelles fonctions. Pour m\u00e9moire, ce logiciel effectue des calculs et du traitement de donn\u00e9es comptables. Il est bas\u00e9 sur un langage d\u2019expression LIXP qui permet de cha\u00eener et automatiser des calculs pr\u00e9programm\u00e9s, des requ\u00eates SQL, des appels API, des exports (fichiers texte)\u2026 Derni\u00e8res fonctions en date (en &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=12654\" class=\"more-link\">Continue reading &lsquo;Projet IXP (v1.2beta) : requ\u00eates SQL sur bases de donn\u00e9es Access&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Projet%20IXP%20%28v1.2beta%29%20%3A%20requ%C3%AAtes%20SQL%20sur%20bases%20de%20donn%C3%A9es%20Access\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[8,3292,3291,282],"tags":[2415,60,166,2116,2707,3296,1210,1838,3294,3295,3293,57,1643],"class_list":["post-12654","post","type-post","status-publish","format-standard","hentry","category-extractions-de-donnees","category-ixp","category-lixp","category-sql","tag-accdb","tag-access","tag-analyse-de-donnees","tag-api","tag-etl","tag-expression","tag-fec","tag-interpreteur-de-fomules","tag-ixp","tag-lixp","tag-projet-ixp","tag-requete-sql","tag-sql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12654"}],"version-history":[{"count":2,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12654\/revisions"}],"predecessor-version":[{"id":12657,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12654\/revisions\/12657"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}