从哪里开始创建一个通过csv更改用户上传数据的网站，然后允许用户下载更改的数据？ [英] Where to start to create a website that changes user uploaded data via csv, then allow changed data to be downloaded by user?

问题描述

我是编程新手，除了我自己教的东西之外什么都不知道，所以如果我的问题很容易，请原谅我。我不是在寻找一种直接的方法，只需要我需要开始的信息或地点，以及我需要学习的东西。



我正在寻找一种方法，用户可以将他们的CSV文件上传到我的网站，然后脚本会更改他们要求更改的数据。这个数据需要简单的价格和日期更改，通过API到另一个具有更好功能的网站，然后我可以提供。



我有并且可以通过谷歌脚本来做到这一点，但它仅限于谷歌表和谷歌驱动器。 （这是目前我知道如何编程的唯一方法）数据存储在谷歌工作表上，然后通过谷歌脚本在工作表上操作，然后通过电子邮件发送给用户。



我现在想制作一个实际的网络应用程序，它将上传的文件更改需要更改的数据，然后允许下载新文件，或发送给用户的新文件。



我的问题是我从哪里开始？我是否倾向于MySQL，然后如何通过api与MySQL更改数据？还有什么其他语言有用吗？就像我说我什么都不知道，我知道有很多资源可以用于精益编程，我只需要指出正确的方向。任何事情都会有所帮助，谢谢。



我尝试过的事情：



我曾尝试使用谷歌脚本来做到这一点。问题是我不知道如何提高效率，使用电子表格而不是数据库效率不高。

I am new to programming and know nothing more then what I have taught myself, so please forgive me if my question is to easy. I am not looking for a direct way to do this just information or places I need to start, and things I need to learn.

I am looking for a way that users can upload their CSV files to my site, and then a script would change the data they requested to be changed. Just simple price and date changes that this data would need, via an API to another site that has better capabilities then I could offer.

I have and can do this via google script, but it is limited to only google sheets and google drive. (this is currently the only way I know how to program) The data was stored on a google sheet then manipulated on sheet via google script then emailed to user.

I now want to make an actual web app that would take the file uploaded change the data that needs to be changed and then allow new file to be downloaded, or send new file to user.

My question is where do I start? Do I lean MySQL then how to change data via api with MySQL? What other langues are useful? Like I said I know nothing, and I know there are a lot of sources out there to lean programming, I just need to be pointed in the right direction. Anything would help, thanks.

What I have tried:

I have tried to use google scripts to do this. The problem is I don't know how to make it more efficient, using spreadsheets and not a database is not efficient.

推荐答案

如果你这是一个很大的问题对编程一无所知。您将需要学习一种不是1天任务的.NET语言（C＃或VB.NET）。您还需要学习HTML，Javascript（或PHP）以及网站运作的基础知识。能够在几个月内完成这项工作的机会，更不用说几周了。



但是这里有一些链接可以帮助你入门：

Charles Petzold的.NET Book Zero [ ^ ]。

ASP。 NET | ASP.NET站点 [ ^ ]。

SQL Server Compact Edition 3.5入门|奥术代码 [ ^ ]。

That is quite a big ask if you know nothing about programming. You will need to learn one of the .NET languages (C# or VB.NET) which is not a 1-day task. You will also need to learn HTML, Javascript (or PHP) and the fundamentals of how websites operate. The chances of being able to complete this in a few months, let alone weeks, are not high.

However here are some links to get you started:
.NET Book Zero by Charles Petzold[^].
ASP.NET | The ASP.NET Site[^].
Getting Started with SQL Server Compact Edition 3.5 | Arcane Code[^].

这篇关于从哪里开始创建一个通过csv更改用户上传数据的网站，然后允许用户下载更改的数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！