Read/Write CSV file

If unquoted text values are required then CommaTextStreamIo should be replaced with TextStreamIo, which has the same methods.

Read CSV file

        #File
        #OCCRetryCount
        #define.delimiterField(',')
        System.IO.MemoryStream  memoryStream = connector.getCurrentMemoryStream();
        CommaTextStreamIo       commaTextStreamIo = CommaTextStreamIo::constructForRead(memoryStream);
        if (commaTextStreamIo)
        {
            if (commaTextStreamIo.status())
            {
                throw error("@CLIDocuments:FileUpload_Failed");
            }

            commaTextStreamIo.inFieldDelimiter(#delimiterField);
            commaTextStreamIo.inRecordDelimiter(#delimiterCRLF);
                
            container       record;

            while (!commaTextStreamIo.status())
            {
                record = commaTextStreamIo.read();
            }
        }

Write CSV file

        CommaTextStreamIo       commaTextStreamIo = CommaTextStreamIo::constructForWrite();

        commaTextStreamIo.writeExp(['row 1 col 1', 'row 1 col 2']);
        commaTextStreamIo.writeExp(['row 2 col 1', 'row 2 col 2']);

        File::SendFileToUser(commaTextStreamIo.getStream(), 'file name.csv');
Result:


 

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own AdSense units and "buy me a coffee" link.
Join us.

Blog Tags