Learning Servers

D

DragonDon

Guest
Greetings all,

I have an idea and would love some feedback and suggestion on how to go about it.

Basically, I would like to setup a server that monitors a CSV sheet and displays that information on a website/server.

I've setup many websites where any content was manually entered (i.e. static pages, CMS-styles...) but not one that reads a CSV and displays the data.

I'm not sure what I need to learn in order to do that or which setup would work best to accomplish this.

Thanks in advance!
 

kkshravan

New member
Its pretty simple. CSV is just comma separated, so you don't even need excel readers. You can open them as plain text files through server side apps like JSP/ASP/PHP and read the file to display the contents using the same. These would be dynamic pages so content would be rendered dynamically. But you need to understand several things before designing such a file based content repository to display contents on web pages. How large are the files? How frequently do they change? Are they user access based? Why not have a scheduler which runs and parses the files and puts in a DB/CMS which your webpages can pick...WIsh you good luck. Let me know if I can help you code that in Java.
 
R

raghuprasad

Guest
If you are using Python, you can use csv module (https:// docs.python.org/2/library/csv.html) to read and write CSV files. You do need to have some programming expertise in Python. If you want to generate HTML pages from the CSV file, then cheetah template engine (https:// pypi.python.org/pypi/Cheetah/2.4.4) and csv module can be your friends. And for a minimal web development framework in Python, you can use Bottle (http:// bottlepy.org/docs/dev/).
 

Server_Guy

New member
I am very sorry if my post lacks some detail but i am still at ground zero in the programming topic.
In order to read that info from a CSV and display on a website you have to learn how to code dynamic websites and you need to know how to use a database to store that contents inside it after proccessing.
To do this you need to learn at least PHP and SQL(the language not MSSQL), and then you need to learn how to use what you have learned to make the application you described.
Note: you can use other languages and DBs such as ASP.NET with MSSQL, but i recommend PHP and MYSQL or MARIADB because they are the most popular and most used, you will find lots of tutorials and resources online for these.

Good Luck