| Author |
Topic |
|
lordterrin
Starting Member
4 Posts |
 Posted - 2014-08-26 : 10:56:03
|
| I have been working on a rather large project for a while that bases itself off of a series of reports that are generated internally by our company in .xls format. I'm at the point where taking in all of this data and exporting it back out into another .xlsx file is just too cumbersome, and does not allow me to do what I want with it.I have an idea of how I'd like to move this project out of Excel and into something else, but I'm not sure where to start. What I'd like to do is the following:.1 - Take the various files that I get each day and run the same macros on them as I do now, but instead of populating the data back into a new sheet, populate an SQL database with the information. 2 - One of the biggest issues I'm having with Excel is the whole "only one person can use this at a time" thing. Even with shared wookbooks, it's just not a good solution when I need 50 people to be able to load data and make changes to it in real time. I want to create an internal website that will employ this SQL database and allow multiple people to make changes to the data then and there at the same time. My issue is that while I am HAPPY to read and learn how to do this, I have no idea where to start. What language this would be done in? Where can I go to read and learn how to incorporate an SQL database into a web page? What are some software packages I would need to employ in order to do this? - I wrote straight up HTML back in the day, but I haven't done anything with the web in about 10 years. All I know is buzzwords - css, php, html5?, I don't know... I'm lost here.3 - Allow users who have loaded this internal website to make changes to this data that will write back to the SQL database. My company will be installing MS SQL Server Developer for me to do this - what other software might I need on the SQL side to be able to do what I'm trying to do? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-26 : 11:06:00
|
| You will need Visual Studio. Probably your best bet is to build an ASP.NET MVC 4 application using SQL on the back end. There are good, free tutorials on ASP.NET MVC 4 available from Microsoft. At a minimum, you will need to know:1. SQL Server: How to design, develop and maintain databases2. ASP.NET MVC: how to design web apps (intranet in your case) using ASP.NET MVC3. C# (or Visual Basic or even F# if you're functionally minded)Depending on where you're starting from, you have quite a journey ahead!Here are some links to get you started:http://www.sqlservercentral.com/stairway/72899/http://www.sqlservercentral.com/stairway/72400/http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/intro-to-aspnet-mvc-4http://msdn.microsoft.com/en-us/library/aa288436(v=vs.71).aspx |
 |
|
|
lordterrin
Starting Member
4 Posts |
Posted - 2014-08-26 : 11:07:39
|
| Thank you so much - this is all i wanted to know. :) I understand it's a large undertaking, but I have the time, and the desire to learn, and I feel Excel has gotten me very far, but I really need to move away from it and learn something new that has more functionality. I really appreciate your help! |
|
|
|
lordterrin
Starting Member
4 Posts |
Posted - 2014-08-28 : 13:34:33
|
| I got MySQL Server installed, as well as XAMPP. I'm not sure why I need both of these programs. I've messed around a bit with XAMPP, through the PHPmyAdmin and I'm comfortable doing basic dba (creating stuff, adding and deleting stuff... etc.) The part that I know nothing about is how to take this database I'm making and make a web front end for it. Now that I have an SQL server running on my localhost, how do I write something to utilize that, and where do I PUT that? Is localhost my server? I'm confused... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-28 : 13:39:43
|
| I'm confused why you installed MySQL if your company is providing MS SQL Server Developer. Regarding the frontend, that's where C# and ASP.NET comes into play.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
lordterrin
Starting Member
4 Posts |
Posted - 2014-08-28 : 13:43:37
|
| I explained what I needed, and our IT guy recommended MySQL over the Microsoft solution, (I'm assuming since it's free and all.) I realize this sounds like a stupid question, but web stuff is not my forte. Even if this exists only through my machine - how do I "load" a webpage onto my localhost so I can access it, so I can write something to access the database that I've just created? |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-28 : 15:07:38
|
| MySQL is probably just fine. Are you going to build your apps using Visual Studio (ASP.NET MVC4 in C#)? If so, you'll be hosting in IIS. If not, you'll have to take this whole discussion to another forum. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-28 : 15:41:03
|
| Even if it's IIS, the questions will be better answered on a forum specializing in the programming language in use. SQLTeam's core expertise is Microsoft SQL Server.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
Excel, SQL, and websites