WBAUnofficial
Web design question - Printable Version

+- WBAUnofficial (https://wbaunofficial.org.uk)
+-- Forum: WBAUnofficial (https://wbaunofficial.org.uk/forumdisplay.php?fid=3)
+--- Forum: WBAUnofficial (https://wbaunofficial.org.uk/forumdisplay.php?fid=4)
+--- Thread: Web design question (/showthread.php?tid=34207)

Pages: 1 2 3 4


RE: Web design question - CarlosCorbewrong - 06-29-2024

(06-29-2024, 01:11 PM)Midget In A Pinstripe Suit Wrote: I do love the irony of you asking a serious question on ere pal. If it’s not about electric smokers I ay interested.

I know.  I deserve pelters but actually everyone's v helpful.


RE: Web design question - waffle - 06-29-2024

If it’s fairly static data it’d take someone 30 mins to convert from your excel speadsheet into any database. MySQL is fairly popular.


RE: Web design question - Birdman1811 - 06-29-2024

I'd look to move the data from excel to a proper database, but that can be scripted easily enough.

Then it's a case of creating a front end to read and display that data, it's honestly not really difficult.


RE: Web design question - MrBater - 06-30-2024

You need a database connection, or access to a 3rd
Party API, the. You need a language that understands what info is being sent back to it and in turn it transposes that info into a usable display.

My personal choice these days is Blazor server, which uses C#. No need for JS or a thing else. You can get Visual Studio Code for free I believe that will allow you to do it.

It all really depends on how / where your data is coming from. The postcode look up things may need to utilise some maths to calculate miles between two points, which you can easily do using an API like postcode.io which is free and will provide latitude and longitude, or you may just want to go for the start part of the code. Again it depends on your data source as to what's doable.

(06-29-2024, 12:38 PM)CarlosCorbewrong Wrote: Sorry fuzz, I was a little unclear but the look up on the database would just be typing in the name of the local council and then bringing up all matches, a bit like this: https://www.compare-school-performance.service.gov.uk/?_ga=2.45135715.639694599.1719658706-577194799.1719658706

When you guys say database does MS Access work?

It's not ideal, you could probably get away with SQL Express if you've not got loads of web traffic.

assuming you have the data I could do that in around an hour, but if you wanted it pretty, then that's where most of the work is


RE: Web design question - Fulham Fallout - 07-01-2024

If only there was someone on here that had taught themselves one of the best and widely used languages to interact with websites, they’d be able to tell you what you need.   Rolleyes

Python is the code to use. 

Re the back end, if it’s numerical comparison and analysis you require,  then excel would work fine.  Just make sure the data output is in the best way to utilise the info, country, county, town, school name, year grouping, result 1, result 2, result 3 etc 

With Python you would create a table or csv file of info to be populated in to the website, town, school name etc

Python would then open the webpage you specify in the code, read the table or csv file (with the info o be sent to the webpage) a row at a time and populate the webpage accordingly.  Python can also click on whatever radio button you require, select downs and click on any button on a page. 

With a lot of webpages, the search criteria you enter onscreen then forms the url which os used to retrieve the info to the webpage.  So you can create the urls in a table which Python loads and opens the relevant search page result webpages. 

Python can then select whatever info is displayed on the screen and extract it as a table or csv file or manipulate the data however you want.   It could look at dates the info was loaded on the website and compare that to previously extracted data in an output file to see if you’ve previously extracted that information and therefore not to extract it again. 

Once all the info for one school has been extracted, the Python code would then go to the next school in the table / csv file to be queried. 

Python is a very powerful tool Soph and better still, it’s free.  I then use PyCharm front end to code Python.  Again, that’s free.

It would be a good idea if you manually extracted all the info you required for say 3 schools, then put that in to excel and perform whatever analysis on this data that you would with all the data.  Just so you know what you need to extract and what you want to do with the data once extracted and if excel is the right tool for the back-end. 

You haven’t really mentioned what you want to do with the data once extracted.  That would drive what you need at the back end. 

But use Python to intereact with the websites and extract the info.


RE: Web design question - Derek Hardballs - 07-01-2024

You need a web developer who understands databases not a web designer. That’s my top tip.


RE: Web design question - Fulham Fallout - 07-01-2024

(07-01-2024, 06:50 AM)Derek Hardballs Wrote: You need a web developer who understands databases not a web designer. That’s my top tip.

Databases are a piece of piss Dekka

But you’re right that a web designer isn’t required, but neither is a web developer!!  it’s someone with experience in wesbsote scraping that’s required. Someone with Python skills.


RE: Web design question - NewWanker - 07-01-2024

(07-01-2024, 07:12 AM)Fulham Fallout Wrote:
(07-01-2024, 06:50 AM)Derek Hardballs Wrote: You need a web developer who understands databases not a web designer. That’s my top tip.

Databases are a piece of piss Dekka

But you’re right that a web designer isn’t required, but neither is a web developer!!  it’s someone with experience in wesbsote scraping that’s required. Someone with Python skills.

Oh God the I'm the best persona is fucking back chatting about stuff he really doesn't know.


RE: Web design question - Fulham Fallout - 07-01-2024

(07-01-2024, 08:08 AM)NewWanker Wrote:
(07-01-2024, 07:12 AM)Fulham Fallout Wrote:
(07-01-2024, 06:50 AM)Derek Hardballs Wrote: You need a web developer who understands databases not a web designer. That’s my top tip.

Databases are a piece of piss Dekka

But you’re right that a web designer isn’t required, but neither is a web developer!!  it’s someone with experience in wesbsote scraping that’s required. Someone with Python skills.

Oh God the I'm the best persona is fucking back chatting about stuff he really doesn't know.


Morning Wanker! 

Except, I’ve been writing Python code for over a year. 

As you were.


RE: Web design question - NewWanker - 07-01-2024

(07-01-2024, 08:12 AM)Fulham Fallout Wrote:
(07-01-2024, 08:08 AM)NewWanker Wrote:
(07-01-2024, 07:12 AM)Fulham Fallout Wrote:
(07-01-2024, 06:50 AM)Derek Hardballs Wrote: You need a web developer who understands databases not a web designer. That’s my top tip.

Databases are a piece of piss Dekka

But you’re right that a web designer isn’t required, but neither is a web developer!!  it’s someone with experience in wesbsote scraping that’s required. Someone with Python skills.

Oh God the I'm the best persona is fucking back chatting about stuff he really doesn't know.


Morning Wanker! 

Except, I’ve been writing Python code for over a year. 

As you were.

wooooooo big fucking whoop. Try 20+= years doing C# , JS, TSQL,VB, VBA, and a right load of other languages and frameworks in between. now run along, the adults are talking.

I'm still waiting for the mass PM of all of the Bored members from your amazing code.