Reading CSV File in hosted application

Question

I have created an MVC ASP.Net application and hosted in within IIS. Part of my app allows for users to upload a csv file. The data then needs to be read out of the csv and into an object to be used elsewhere.

The problem I have is when hosted in IIS the file can not be read. Here is my code:

            using (StreamReader CsvReader = new StreamReader(filePath))
            {
                MessageHandler.NewNote("Opened CSV Reader");
                string inputLine = "";
                int lineNumber = 0;     
                while ((inputLine = CsvReader.ReadLine()) != null && !string.IsNullOrEmpty(inputLine))
                {
                    //Do something here
                }
            }

Can someone please advise how I get this working. The filepath is generated using the following upload form:

    <div id="UploadForm">
        <% using (Html.BeginForm("FileUpload", "ImportExport", Model,
                FormMethod.Post, new { enctype = "multipart/form-data" }))
    {%>
        <input name="uploadFile" type="file" accept=".csv" style="width:70%;" />
        <input type="submit" value="Upload File" />               
        <%} %>
    </div>

What do you mean "cannot be read"? Is there an error? How does it not perform as expected? You need to provide this information up front, rather than us needing to ask you for it. — mason
– mason, Commented Apr 20, 2015 at 16:24

Bruno · Accepted Answer · 2015-04-20 16:32:14Z

1

The filePath is coming from the client, there should be no file existing on the server at the given file path.

You need to read the data from the Stream coming from the upload form instead of the file path.

Please refer to the following link

http://msdn.microsoft.com/en-us/library/system.web.httprequest.inputstream.aspx

edited Apr 20, 2015 at 16:32

answered Apr 20, 2015 at 16:25

Bruno

4,6757 gold badges65 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sam Brueton Over a year ago

perfect exactly what I was looking for.

Collectives™ on Stack Overflow

Reading CSV File in hosted application

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related