{"id":21317,"date":"2022-10-26T16:08:53","date_gmt":"2022-10-26T14:08:53","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/case-studies\/export\/csv-file-raw-data\/"},"modified":"2024-05-07T10:34:01","modified_gmt":"2024-05-07T08:34:01","slug":"csv-file-raw-data","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/case-studies\/export\/csv-file-raw-data\/","title":{"rendered":"CSV file Raw data"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>var FINAL_PATH_FOLDER = 'C:\\\\Documents\\\\Capture';\r\nvar FILE_NAME = \"BDC.csv\";\r\nvar CSV_SEPARATOR = \";\";\r\nvar FINAL_PATH_FILE = FINAL_PATH_FOLDER + \"\\\\\"+FILE_NAME;\r\n\r\n\/*===================================== FUNCTIONS ===================================== *\/\r\n\r\nvar createPathIfNeededAndReadFileIfExist = function(){\r\n    var result = \"\";\r\n    JSE_File.createDirectory(FINAL_PATH_FOLDER);\r\n    var files = JSE_File.getFiles(FINAL_PATH_FOLDER);\r\n    if(files != null &amp;&amp; files.length > 0){\r\n        for(var i=0;i&lt;files.length;i++){\r\n            if(files&#91;i] == FINAL_PATH_FILE)\r\n                result = JSE_File.readFile(FINAL_PATH_FILE); \r\n        }\r\n    }\r\n\r\n    return result;\r\n}\r\n\r\nvar getHeaders = function(){\r\n    return \"TIERS;NUMERO FACTURE;DATE;TOTAL TTC\\n\";\r\n};\r\n\r\nvar writeDocumentDetail = function(pParameters){\r\n    return THIRDPART.name \r\n        + CSV_SEPARATOR\r\n        + getTextFromIndexInfo(getFirstIndexFromID(pParameters,\"INVOICE_NUMBER\"))\r\n        + CSV_SEPARATOR\r\n        + getTextFromIndexInfo(getFirstIndexFromID(pParameters,\"DATE_INDEX\"))\r\n        + CSV_SEPARATOR\r\n        + getTextFromIndexInfo(getFirstIndexFromID(pParameters,\"AMOUNT_INCLUDING_VAT_INDEX\"))\r\n        +\"\\n\";\r\n};\r\n\r\n\/*===================================== MAIN CODE ===================================== *\/\r\n\r\nvar result = createPathIfNeededAndReadFileIfExist();\r\nif(result == null || result == \"\")\r\n    result = getHeaders();\r\n\r\nresult += writeDocumentDetail(pParameters);\r\nJSE_File.writeFile(FINAL_PATH_FILE, result);\r\nreturn true;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":97,"featured_media":0,"parent":21275,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-21317","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/users\/97"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=21317"}],"version-history":[{"count":1,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21317\/revisions"}],"predecessor-version":[{"id":21318,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21317\/revisions\/21318"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21275"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=21317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}