Posts: 11,923
Threads: 798
Joined: Oct 2022
Reputation:
50
Alright nerds?
Sometimes the Mail and other sites have articles which allow you to look up performance of schools, or outcomes of FOIs from councils etc. You type in your postcode or the name of the school and then the Mail brings up their performance or response.
If I want someone to do this for me what coding/skills etc do I need to make sure they have?
Would rather talk to ChatGPT
Posts: 2,414
Threads: 94
Joined: Jan 2019
Reputation:
19
Hardly any, it's fairly basic Javascript/Typescript. It just collects the input and makes an API call. You'd need to know the database that holds the info you want and pay for an API key I would imagine.
Posts: 11,923
Threads: 798
Joined: Oct 2022
Reputation:
50
(06-29-2024, 11:03 AM)ChamonixBaggie Wrote: Hardly any, it's fairly basic Javascript/Typescript. It just collects the input and makes an API call. You'd need to know the database that holds the info you want and pay for an API key I would imagine.
Cheers mon. It's just an excel sheet of about 400 lines, 4000 fields?
Would rather talk to ChatGPT
Posts: 2,414
Threads: 94
Joined: Jan 2019
Reputation:
19
Weirdly that's probably harder than if it was in an actual database but you can create a PHP program that will read from Excel. It would be easier if you had it in a proper DB though that's money I suppose. The excel file would obviously need to be hosted somewhere the website can get at it which might be more expensive that just paying for a DB from one of the cloud providers.
Posts: 11,923
Threads: 798
Joined: Oct 2022
Reputation:
50
Cheers Mon. One last question: to build a basic text plus image page with this functionality impeded in it... how many hours work roughly?
Would rather talk to ChatGPT
Posts: 6,719
Threads: 355
Joined: Mar 2024
Reputation:
40
Is the end product going to be something where you type in your postcode and it tells you where the chip shop is and whether there are any lovely arses in there? Asking for a banned friend. Also, I might invest!
Rarely, I read a thread on here where I haven't got a clue what people are talking about. Fuckin ignoramus I am.
Posts: 11,923
Threads: 798
Joined: Oct 2022
Reputation:
50
(06-29-2024, 12:08 PM)man in the corner shop Wrote: Is the end product going to be something where you type in your postcode and it tells you where the chip shop is and whether there are any lovely arses in there? Asking for a banned friend. Also, I might invest!
Rarely, I read a thread on here where I haven't got a clue what people are talking about. Fuckin ignoramus I am.
It's about shapely arses in chip-shops, now.
Would rather talk to ChatGPT
Posts: 1,712
Threads: 20
Joined: Jan 2019
Reputation:
18
06-29-2024, 12:28 PM
(This post was last modified: 06-29-2024, 12:29 PM by fuzzbox.)
Assuming you want easy "as the crow flies" wouldn't you have to convert all the places into longtitude and latitude? Then convert the querying postcode in the same way. Googlemaps API would do that.
If it has to be a spreadsheet and a very approximate distance is acceptable, you could get a table showing long/lat of the first part of the postcodes (b1,b2 etc) and then perform a vlookup on this in excel. It would be very rough, but maybe good enough for your project. Had a quick look and the data is freely available on the internet.
Having said that, I'd go with the original responder and make it a database. I would imagine you could go to elancer or fiverr and trace someone who has done a similar project before. They'll probably give you a cheap quote as they've already done the work.
Posts: 11,923
Threads: 798
Joined: Oct 2022
Reputation:
50
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.s...1719658706
When you guys say database does MS Access work?
Would rather talk to ChatGPT
Posts: 7,863
Threads: 158
Joined: Jan 2019
Reputation:
13
I do love the irony of you asking a serious question on ere pal. If it’s not about electric smokers I ay interested.
In the form of his life.