{"id":1094,"date":"2022-12-09T15:27:18","date_gmt":"2022-12-09T14:27:18","guid":{"rendered":"http:\/\/daxvisionerp.com\/?p=1094"},"modified":"2025-10-22T14:33:07","modified_gmt":"2025-10-22T14:33:07","slug":"read-write-import-export-text-csv-ascii-file","status":"publish","type":"post","link":"https:\/\/daxvisionerp.com\/home\/read-write-import-export-text-csv-ascii-file\/","title":{"rendered":"Read and write file example"},"content":{"rendered":"\n

Here I share a simple example for exporting data in ASCII ‘csv’ file format. The file is saved to the folder that is set up in the web browser.<\/p>\n\n\n\n

    public static void main(Args _args)\n    {\n       Filename fileName = 'Filename.Txt';\n        AsciiStreamIo asciiIo = AsciiStreamIo::constructForWrite();\n\n        asciiIo.outRecordDelimiter(\"\\r\\n\");\n        asciiIo.outFieldDelimiter(\";\");\n\n        asciiIo.write('Line 1');\n        asciiIo.write('Line 2');\n        File::SendFileToUser(asciiIo.getStream(),'asciiFile.txt');\n    }<\/code><\/pre>\n\n\n\n
Here is another example code. This one is reading \/ importing data in ASCII ‘csv’ file format. The csv file can be selected by the user from his or her local disk.<\/p>\n\n\n\n
public static void main(Args _args)\n{\n    FileUploadTemporaryStorageResult    uploadFileResult = File::GetFileFromUser();\n    System.IO.Stream                    readStream = File::UseFileFromURL(uploadFileResult.getDownloadUrl());\n    AsciiStreamIo                       inFile = AsciiStreamIo::constructForRead(readStream);\n\n    container               readCon;\n    str                     recordRead;\n    int                     nRead;\n\n    inFile.inFieldDelimiter(\"\\r\\n\");\n    inFile.inRecordDelimiter(\"\\r\\n\");\n\n    if (!inFile)\n    {\n        \/\/FileName = uploadFileResult.getFileName();\n        Error('Cannot open file. Import failed.');\n    }\n    else\n    {\n        readCon = inFile.read();\n        while (inFile.status() == IO_Status::OK)\n        {\n            recordRead = conPeek(readCon, 1);\n            info(recordRead);\n            readCon = inFile.read();\n            nRead++;\n        }\n    }\n}<\/code><\/pre>\n\n\n\n
\"\"<\/a>
Browse file dialog displayed by File::GetFileFromUser()<\/figcaption><\/figure>\n\n\n\n
You can paste these codes to a runnable class and it will work or copy from https:\/\/github.com\/PeterProkopecz\/AX\/tree\/master\/D365FO_FileReadWrite<\/a>. You can customize them to fit your needs. Use ‘TextStreamIo’ class instead of ‘AsciiStreamIo’ in case you want to use normal text files.<\/p>\n\n\n

<\/span>ascii<\/a>, <\/span>browse file<\/a>, <\/span>csv file<\/a>, <\/span>export file<\/a>, <\/span>import file<\/a>, <\/span>MSDyn365FO<\/a>, <\/span>read file<\/a>, <\/span>text file<\/a>, <\/span>write file<\/a><\/div>","protected":false},"excerpt":{"rendered":"
Here I share a simple example for exporting data in ASCII ‘csv’ file format. The file is saved to the folder that is set up in the web browser. Here is another example code. This one is reading \/ importing data in ASCII ‘csv’ file format. The csv file can be selected by the user […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"1080","footnotes":""},"categories":[19],"tags":[157,159,161,163,165,151,167,169,171],"class_list":["post-1094","post","type-post","status-publish","format-standard","hentry","category-dynamics-365fo","tag-ascii","tag-browse-file","tag-csv-file","tag-export-file","tag-import-file","tag-msdyn365fo-2","tag-read-file","tag-text-file","tag-write-file"],"_links":{"self":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts\/1094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/comments?post=1094"}],"version-history":[{"count":2,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts\/1094\/revisions"}],"predecessor-version":[{"id":1343,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/posts\/1094\/revisions\/1343"}],"wp:attachment":[{"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/media?parent=1094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/categories?post=1094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/daxvisionerp.com\/home\/wp-json\/wp\/v2\/tags?post=1094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}