{"id":12685,"date":"2025-01-07T00:25:54","date_gmt":"2025-01-06T23:25:54","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=12685"},"modified":"2025-01-07T00:26:34","modified_gmt":"2025-01-06T23:26:34","slug":"projet-ixp-v1-21beta-mise-a-jour-en-ligne","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=12685","title":{"rendered":"Projet IXP (v1.21beta) : nouvelle version en ligne"},"content":{"rendered":"<p style=\"text-align: justify;\">La derni\u00e8re version d&#8217;IXP (1.21beta) est en ligne pour tests ! Les principales nouveaut\u00e9s concernent le langage LIXP.<\/p>\n<p style=\"text-align: justify;\">Le <strong>langage LIXP s\u2019enrichit<\/strong> de nouvelles fonctions : traitement de <strong>fichiers texte<\/strong>, bases <strong>MULTIFEC<\/strong>, base de donn\u00e9es <strong>ACCESS<\/strong>&#8230;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12700\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/IXP-1.21beta.png\" alt=\"IXP 1.21beta\" width=\"682\" height=\"602\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/IXP-1.21beta.png 682w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/IXP-1.21beta-300x265.png 300w\" sizes=\"auto, (max-width: 682px) 100vw, 682px\" \/><\/p>\n<p style=\"text-align: justify;\">Exemple d&#8217;expression assurant la cr\u00e9ation d&#8217;une base MULTIFEC avec des FEC d\u00e9sign\u00e9s \u00e0 partir d&#8217;une liste de num\u00e9ros SIREN stock\u00e9e dans un fichier texte :<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">\u00a7 -----------------------------------------------------------------------\r\n\u00a7  CREATION BASE MULTIFEC\r\n\u00a7  31\/12\/2024 B. RIVIERE\r\n\u00a7 -----------------------------------------------------------------------\r\n\r\nENTVAR[\"Ann\u00e9e civile \u00e0 charger ?\";ANNEE]:\r\n\r\n\"C:\\Users\\UT01\\OneDrive\\Echanges PADoCC_Ecritures\\Sources\\FEC\\\"ANNEE\"1231\\\":DRC[chemin_FEC]:\r\n\r\n\u00a7 Suppression des FEC d\u00e9j\u00e0 charg\u00e9s\r\nFEC_LIBERERTOUT[]:\r\n\r\n\u00a7 Ouverture du fichier liste SIREN\r\nFTXT_OUVRE[\"SIREN\";\"LISTE SIREN \"ANNEE]:\r\nFTXT_NBENREG[\"SIREN\"]:DRC[nb_siren]:\r\n\r\n\u00a7 Chargement des FEC\r\nBOUCLE_COMPTEUR[e;1;nb_siren;1;\r\n    FEC_CHARGER[chemin_FEC\"\"FTXT_LIT[\"SIREN\"]\"FEC\"ANNEE\"1231.txt\";\"\"]\r\n]:\r\nFTXT_FERME[\"SIREN\"]\r\n\r\n\u00a7 Exportation MULTIFEC\r\n\"MULTIFEC \"ANNEE:DRC[nom_MULTIFEC]\r\nFEC_EXPORT[\"Exports\/MULTIFEC\/\"nom_MULTIFEC]\r\n\r\n\u00a7 Envoi m\u00e9l\r\n\"Cr\u00e9ation MULTIFEC \"nom_MULTIFEC\" termin\u00e9e.\":DRC[message]:\r\nENVOI_MEL[\"Identifiants m\u00e9l.txt\";\"benoit@auditsi.eu\";\"\";\"\";\"MAJ MULTIFEC\";message;\"\"]<\/pre>\n<p style=\"text-align: justify;\">La g\u00e9n\u00e9ration de bases MULTIFEC a \u00e9t\u00e9 test\u00e9e de mani\u00e8re concluante sur de grands volumes de FEC (plusieurs dizaines de FEC charg\u00e9s en m\u00e9moires simultan\u00e9ment).<\/p>\n<p style=\"text-align: justify;\">Liste des fonctions LIXP de gestion de fichiers texte :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12688\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/LIXP-TRTT-FICHIERS-TEXTE.png\" alt=\"LIXP TRTT FICHIERS TEXTE\" width=\"986\" height=\"556\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/LIXP-TRTT-FICHIERS-TEXTE.png 986w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/LIXP-TRTT-FICHIERS-TEXTE-300x169.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/LIXP-TRTT-FICHIERS-TEXTE-768x433.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/LIXP-TRTT-FICHIERS-TEXTE-730x412.png 730w\" sizes=\"auto, (max-width: 986px) 100vw, 986px\" \/><\/p>\n<p style=\"text-align: justify;\">Liste des FEC charg\u00e9s en m\u00e9moire :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12689\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/IXP-LISTE-FEC.png\" alt=\"IXP LISTE FEC\" width=\"795\" height=\"359\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/IXP-LISTE-FEC.png 795w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/IXP-LISTE-FEC-300x135.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/IXP-LISTE-FEC-768x347.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/IXP-LISTE-FEC-730x330.png 730w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/p>\n<p style=\"text-align: justify;\">Exemple d\u2019expression de mise \u00e0 jour d\u2019une base MULTIFEC \u00e0 l\u2019aide de FEC \u00e0 jour :<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">\u00a7 -----------------------------------------------------------------------\r\n\u00a7  MAJ BASE MULTIFEC\r\n\u00a7  31\/12\/2024 B. RIVIERE\r\n\u00a7 -----------------------------------------------------------------------\r\n\r\nENTVAR[\"Ann\u00e9e civile \u00e0 charger ?\";ANNEE]\r\n\r\n\"C:\\Users\\UT01\\OneDrive\\Echanges PADoCC_Ecritures\\Sources\\FEC\\\"ANNEE\"1231\\\":DRC[chemin_FEC]\r\n\r\n\"MULTIFEC \"ANNEE:DRC[nom_MULTIFEC]\r\n\r\nENTVAR[\"Nb de FEC \u00e0 MAJ ?\";nb_FEC]\r\n\r\n\u00a7 Suppression des FEC d\u00e9j\u00e0 charg\u00e9s\r\nFEC_LIBERERTOUT[]\r\n\r\n\u00a7 Chargement base MULTIFEC\r\nMULTIFEC_CHARGER[\"Exports\/MULTIFEC\/\"nom_MULTIFEC]\r\n\r\nBOUCLE_COMPTEUR[compteur;1;nb_FEC;1]\r\n    \u00a7 S\u00e9lection du FEC\r\n    FEC_SELECT[\"\"]:DRC[nom_fec]:\r\n    \u00a7 Calcul du n\u00b0 SIREN \u00e0 partir du nom du FEC\r\n    GAUCHE[DROITE[nom_fec;24];9]:DRC[siren]:\r\n    \u00a7 Calcul AAAAMM \u00e0 partir du nom du FEC\r\n    GAUCHE[DROITE[nom_fec;12];6]:DRC[aaaamm]:\r\n    \u00a7 Lib\u00e9ration FEC\r\n    FEC_LIBERER[siren;aaaamm]\r\n    \u00a7 Chargement du FEC\r\n    FEC_CHARGER[chemin_FEC\"\"nom_FEC;\"\"]\r\n]\r\n\r\n\u00a7 Exportation MULTIFEC\r\n\"MULTIFEC \"ANNEE:DRC[nom_MULTIFEC]\r\nFEC_EXPORT[\"Exports\/MULTIFEC\/\"nom_MULTIFEC]\r\n\r\n\u00a7 Envoi m\u00e9l\r\n\"MAJ MULTIFEC \"nom_MULTIFEC\" termin\u00e9e.\":DRC[message]:\r\nENVOI_MEL[\"Identifiants m\u00e9l.txt\";\"benoit@auditsi.eu\";\"\";\"\";\"MAJ MULTIFEC\";message;\"\"]<\/pre>\n<p style=\"text-align: justify;\">Exemple d\u2019utilisation d\u2019une base MULTIFEC pr\u00e9alablement enregistr\u00e9e sur le PC : une fois la base MULTIFEC charg\u00e9e en m\u00e9moire, extraction des soldes de caisse quotidiens (requ\u00eate E258) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12686\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/MULTIFEC-E258.png\" alt=\"MULTIFEC &amp; E258\" width=\"726\" height=\"643\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/MULTIFEC-E258.png 726w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2025\/01\/MULTIFEC-E258-300x266.png 300w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><\/p>\n<p style=\"text-align: justify;\">Listing de l&#8217;expression :<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">FEC_LIBERERTOUT[]:\r\n\"MULTIFEC MARY 2024\":DRC[nom_MULTIFEC]:\r\nMULTIFEC_CHARGER[\"Exports\/\"nom_MULTIFEC]:\r\nFEC_EXPORT_E258_CAISSE_SLDQUOTID[\"\"]<\/pre>\n<p style=\"text-align: justify;\">Plus d&#8217;infos sur le projet et t\u00e9l\u00e9chargements : <a href=\"https:\/\/www.auditsi.eu\/?page_id=12603\">rendez-vous sur la page du projet<\/a>.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Le&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?tag=ixp\"><strong>projet IXP<\/strong><\/a> est un interpr\u00e9teur d&#8217;expression dot\u00e9 de nombreuses <strong>fonctions de calculs<\/strong>&nbsp;(langage d\u2019expression 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). Le langage LIXP assure l\u2019<strong>automatisation<\/strong> de la r\u00e9alisation de l\u2019ensemble de ces t\u00e2ches.<\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\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.21beta%29%20%3A%20nouvelle%20version%20en%20ligne\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>La derni\u00e8re version d&#8217;IXP (1.21beta) est en ligne pour tests ! Les principales nouveaut\u00e9s concernent le langage LIXP. Le langage LIXP s\u2019enrichit de nouvelles fonctions : traitement de fichiers texte, bases MULTIFEC, base de donn\u00e9es ACCESS&#8230;. Exemple d&#8217;expression assurant la cr\u00e9ation d&#8217;une base MULTIFEC avec des FEC d\u00e9sign\u00e9s \u00e0 partir d&#8217;une liste de num\u00e9ros SIREN &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=12685\" class=\"more-link\">Continue reading &lsquo;Projet IXP (v1.21beta) : nouvelle version en ligne&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.21beta%29%20%3A%20nouvelle%20version%20en%20ligne\";<\/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":[50,3292,3291,49],"tags":[166,2314,2318,3296,1210,986,3294,3295,3297,1794],"class_list":["post-12685","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-ixp","category-lixp","category-logiciels-daudit","tag-analyse-de-donnees","tag-caisse","tag-caisse-creditrice","tag-expression","tag-fec","tag-fichier-texte","tag-ixp","tag-lixp","tag-multifec","tag-paiement-en-especes"],"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\/12685","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=12685"}],"version-history":[{"count":3,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12685\/revisions"}],"predecessor-version":[{"id":12702,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12685\/revisions\/12702"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}