Comments (8)
Also 43,588 towns!
Yes, that's a lot. :) I agree, it may not be a good idea to seed them during installation.
I think your association (treated Counties as States and Cities as towns) is fairly common in software that are not specifically tailored to UK customers - I'd be happy with that.
With regards to handling address fields in the UK, I think the most common and probably most user-friendly approach is to use some sort of an address lookup service so that users only need to enter their house number (if applicable) and their postcode and select the appropriate address. These services, however, usually are not free services.
For now, I think the City could be just an input element instead of a select - or keep the select but allow users to enter the city / town name manually.
from crater.
Also 43,588 towns!
Yes, that's a lot. :) I agree, it may not be a good idea to seed them during installation.
I think your association (treated Counties as States and Cities as towns) is fairly common in software that are not specifically tailored to UK customers - I'd be happy with that.
With regards to handling address fields in the UK, I think the most common and probably most user-friendly approach is to use some sort of an address lookup service so that users only need to enter their house number (if applicable) and their postcode and select the appropriate address. These services, however, usually are not free services.
For now, I think the City could be just an input element instead of a select - or keep the select but allow users to enter the city / town name manually.
Totally agreed with what you said!
We've already implemented the process you mentioned, so on the next update, we'll delete the existing 5-10 cities that are on the system for UK in the current version and we've updated the address forms to show an text input field (instead of a select input) when no cities are found so the users can add the city/town manually.
from crater.
@pszucs Hey! thanks for letting us know. can you help us list down the states and cities for the UK?
We took the list of states, countries & city list from another open-source project.. so we'll need to fix this manually :)
from crater.
A quick search provided these two, potentially useful links:
https://en.wikipedia.org/wiki/List_of_counties_of_the_United_Kingdom
https://www.townscountiespostcodes.co.uk/towns-in-uk/
Our database currently has a total of 69 Cities in UK (United Kingdom).
Our database currently has a total of 43,588 Towns/Villages in UK (United Kingdom).
from crater.
Yes, I asked for the list because I was confused as I couldn't find the states.. As a user how would you feel if we treated Counties as States and Cities as towns?
Otherwise, we'll need to make a lot of country-specific changes.. We need to think more on this..
from crater.
Also 43,588 towns! that's a lot of data that we would need to Seed in order to show a select box ( and that obviously increase the time it would take for installation)
Need to check how other popular systems handle address fields for UK.
from crater.
When you select "US" as the country, and any state, it only shows the cities in Alaska and only a few of the larger ones.
Check out this SO answer for information on storing addresses and maybe consider not seeding the database. Convert everything to text fields and let users type their addresses. From experience, maintaining these kinds of lists is a nightmare.
from crater.
When you select "US" as the country, and any state, it only shows the cities in Alaska and only a few of the larger ones.
Check out this SO answer for information on storing addresses and maybe consider not seeding the database. Convert everything to text fields and let users type their addresses. From experience, maintaining these kinds of lists is a nightmare.
Agreed! It's going to be a huge pain to maintain the list of States & Cities for each country, so we've decided to get rid of them as you said.
Also, many users are reporting that they get Execution timeout failed
error on installation because it takes a lot of time to seed States and Cities.
Other seeds are pretty minimal so this will improve the installation speed exponentially ๐
from crater.
Related Issues (20)
- Undefined array key \"tax\" and items not shown on invoice with admin API call HOT 1
- It is still in development? HOT 5
- Try InvoiceShelf fork based on Crater! ๐ซถ HOT 4
- Incorrect Currency Symbol in Report for New Company HOT 2
- when i'm changing Logo of crater App, But getting error "Please check your internet connection or wait until servers are back online" HOT 3
- Please make the Crater IOS App also available for Switzerland HOT 2
- Publish Container to Dockerhub? HOT 2
- 403 Forbidden You don't have permission to access this resource HOT 3
- Currency Missing: LYD HOT 2
- Customizing logo on customer login page HOT 2
- Unable to edit notes HOT 2
- Fresh docker install: "pull access denied for crater-php, repository does not exist or..." HOT 3
- Page not redirecting after login HOT 2
- Tax Negative IRPF Spain HOT 3
- delete this
- Visualizzare le imposte nei report HOT 1
- Europe, "VAT Identification Number" or "Tax Identification Number" HOT 1
- Add mandatory legal fields for Europe to the customer record. HOT 1
- In reports, Taxes, Withholdings with negative amounts. HOT 1
- โAttentionโ Please migrate to InvoiceShelf, a fork of crater which continues the development of this project.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from crater.