开发者

Uploading/Pushing Data To A Website

开发者 https://www.devze.com 2022-12-18 00:58 出处:网络
I need to let a company push information up to my site. The best way to explain what I am talking about is to explain how it is currently done with their previous website:

I need to let a company push information up to my site.

The best way to explain what I am talking about is to explain how it is currently done with their previous website:

This company uploads a CSV file to an FTP set up by the website. The website then processes the CSV file and puts it into an SQL database so that it can be used by the website.

In this case, I am the website and I am w开发者_StackOverflow中文版orking with the company. Both sides are willing to change what they do. So my question is...

What is the best way to accept batch information like this? Is there a more automated way that doesn't involve FTP? In the future I may have a lot of companies wanting to do this, and I'd hate to have to setup accounts for each one.

The project is C# ASP.NET MSSQL

Let me know if you need more information...


Set up a web service to accept incoming data. That way you can validate immediately and reject bad data before it ever gets into your system.


If you want to eliminate FTP, you could allow them to upload files to your site leveraging using FileUpload. Once the file is uploaded you can do your server side processing.

EDIT: From the OP's comment's it seems to be an automated process. That said, if their process generates the file, you could:

Allow them to continue their current process which would involve them generating their file and placing it somewhere where it could be accessed via a URI with authentication, you could access this file on a schedule and process it. From what it seems right now they generate a file and upload it to your FTP server, so there seems to a manual element to begin with.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号