Convert CSV file to NACHA format with ASP.net core

Question

User-1537674085 posted

Hello  ASP.NET developers, I am new to .NET and trying to learn as much as I can.
I have a project that I am trying to accomplish but I am having some issues with it.
Basically, my scenario is as follows: Create an ASP.NET application to accept/upload a CSV or XLSX file and convert it to a formatted NACHA file.
I was wondering to ask if there are any ideas or recommendations you might suggest on how to approach this problem. I would like to create an ASP.net core application to accomplish this project, and the company that I work for does not want to use third-party software to make the conversion.
I would appreciate any help.
Thanks in advance

Answer 1

User-474980206 posted

take in multiple steps:

1) define your own data structure for the data

2) google .net read csv file, and find lots of examples. write the code to read the csv file into your data structure

3) use open xml sdk to read an excel file into your data structure (https://docs.microsoft.com/en-us/office/open-xml/open-xml-sdk)

4) google for the a spec of the type of NACHA file you want to produce.  and write code to write your data structure to the file format

put these together with a web application.