Generate Text File Upon Button Action and Save to local Drive using Acumatica

Question

I am trying to generate a text file on an Action Button, with contents of a dataview created in a Graph Class and Save the file in my Local Drive. But i am unable to do it.

Please help me with the file generation...Thanks

I AM USING Acumatica Version 2019R2 (v 19.203.0042)

MY CODE GOES HERE...

public PXSelect<MayBankGIRO> Document; //this is my dataview
public PXAction<MayBankGiroFilter> createTextFile;
        [PXUIField(DisplayName = "Create Text File")]
        [PXButton()]
        public virtual IEnumerable CreateTextFile(PXAdapter adapter)
        {
            string filepath = "C:\\Subhashish Dawn";
            System.IO.StreamWriter sw = new System.IO.StreamWriter(filepath);
            MayBankGIRO giroObject = this.Document.Current;
            List<object> myListObject = new List<object> { };
            FixedLengthFile flatFile = new FixedLengthFile();
            foreach (MayBankGIRO dacRecord in this.Document.Select())
            {
                if (giroObject.ReordType == "00")
                {
                    myListObject.Add(dacRecord.ReordType + "|" + dacRecord.CorporateID + "|" + dacRecord.ClientBatchID + "|");
                }
                else
                {
                    myListObject.Add(dacRecord.ReordType + "|" + dacRecord.CorporateID + "|" + dacRecord.ClientBatchID + "|" + dacRecord.Country + "|");
                    string data = dacRecord.ReordType;

                }

                this.Document.Update(dacRecord);
            }
            flatFile.WriteToFile(myListObject, sw); 

            sw.Flush();
            sw.FlushAsync();

            string path = "DAWN" + ".txt";
            PX.SM.FileInfo file = new PX.SM.FileInfo(Guid.NewGuid(), path, null, System.Text.Encoding.UTF8.GetBytes(**path**)); // what shall i substitite in place of  **path**
            throw new PXRedirectToFileException(file, true);
}
``````````````````````````````````````````````````````
Can anyone please specify what changes in have to make in the above code.

markoan markoan · Accepted Answer · 2020-05-13T07:30:13

Assuming your Document object is the view you need and its Select() method returns all the data records you need inside your file, this should work:

// We need at least these, listing them for reference
using PX.Data;
using System;
using System.Collections;
using System.Collections.Generic;
using System.IO;

// This is your dataview
public PXSelect<MayBankGIRO> Document; 

// Your action delegate
public PXAction<MayBankGiroFilter> createTextFile;

[PXUIField(DisplayName = "Create Text File")]
[PXButton()]
public virtual IEnumerable CreateTextFile(PXAdapter adapter)
{
    // You can use this method to print debug information for your customizations
    // Just remove when you are done testing
    PXTrace.WriteInformation("Generating records");

    // We will build the content as a string list first
    List<string> myList = new List<string> { };

    // If the value of 'ReordType' can change for each record, you don't need this
    MayBankGIRO giroObject = this.Document.Current;

    foreach (MayBankGIRO dacRecord in this.Document.Select())
    {
        // Does 'ReordType' change for each record?
        // if it does you may need to use 'dacRecord.ReordType' in this if instead
        if (giroObject.ReordType == "00")
        {
            // This only works if all these members are strings or can be cast to strings
            myList.Add(dacRecord.ReordType + "|" + dacRecord.CorporateID + "|" + dacRecord.ClientBatchID + "|");
        }
        else
        {
            // This only works if all these members are strings or can be cast to strings
            myList.Add(dacRecord.ReordType + "|" + dacRecord.CorporateID + "|" + dacRecord.ClientBatchID + "|" + dacRecord.Country + "|");
        }
    }

    PXTrace.WriteInformation("Generating file");

    // Set the name
    string filename = "DAWN" + ".txt";

    // Use our download method
    Download(myList, filename);
}

// We can define a static method to be able to reuse this later for other DACs
public static void Download(List<string> lines, string name)
{
    var bytes = default(byte[]);

    // Write all lines to stream
    using (MemoryStream stream = new MemoryStream())
    {
        StreamWriter sw = new StreamWriter(stream);
        foreach (string line in lines)
        {
            sw.WriteLine(line);
        }
        sw.Close();

        stream.Position = 0;
        bytes = stream.ToArray();
    };

    // Save content to file object
    PX.SM.FileInfo textDoc = new PX.SM.FileInfo(name, null, bytes);

    if (textDoc != null)
    {
        // Trigger file download
        throw new PXRedirectToFileException(textDoc, true);
    } else {
      //TODO: You could raise an exception here also to notify the user
      PXTrace.WriteInformation("Could not generate file");
    }
}

Generate Text File Upon Button Action and Save to local Drive using Acumatica

3 Answers