Hello so I been doing alot of reading and looking at people that had the same issues and I suppose I am not understanding the solution they found so i am asking a repeated question. But to avoid from having to manually enter every State and City name is there an API that will connect externally that I can use that will do this for me? and if So may I get an explanation on how to use this with a dropdown box for users to select from?
Import the free CSV into your database US Cities Database | Simplemaps.com
You’ll need to make a datatype in your database with all those fields, then map the columns to those fields.
So I did try to upload the csv but I am not sure if I am doing this wrong but this was the error message I received
There was an issue parsing your data. Details:
Row: 0 Too few fields: expected 2 fields but parsed 1,
Row: 1 Too few fields: expected 2 fields but parsed 1,
Row: 2 Too many fields: expected 2 fields but parsed 3,
Row: 6 Too many fields: expected 2 fields but parsed 4,
Row: 7 Too few fields: expected 2 fields but parsed 1,
Row: 8 Too many fields: expected 2 fields but parsed 3,
Row: 9 Too few fields: expected 2 fields but parsed 1
I attempted a few solutions on my end but could not figure it out
1 Like