(Solved) importing routes

[spkier]

i'm sorry that i have multiple threads open however i tought it was a good idea to not mix them up as i have multiple problems

btw anyone who has a schedule file a little kickstart so it's a bit easier to add routes?

i attached the file i'm trying to upload to Mysql

i'm trying to import a few hundred thousend airports

this is the error i get 

Feil

SQL-spørring:

-- -- Dataark for tabell `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (678, '0II2', 'Creighton Airport', 'US', 41.4573, -86.1244, 0, 0, ''), (679, '0II3', 'Miller Strip', 'US', 40.6278, -86.0378, 0, 0, ''), (680, '0II5', 'Marshall Field', 'US', 40.6595, -86.8572, 0, 0, ''), (681, '0II6', 'Kropf Airport', 'US', 41.6431, -85.8297, 0, 0, ''), (682, '0II7', 'Frost Field', 'US', 39.7956, -85.7861, 0, 0, ''), (683, '0II9', 'Winters Airport', 'US', 39.5342, -86.5772, 0, 0, ''), (684, '0IL0', 'Hamilton Memorial Hospital Heliport', 'US', 38.0867, -88.5389, 0, 0, ''), (685, '0IL1', 'Loyola University Medical Center Heliport', 'US', 41.8609, -87.8364, 0, 0, ''), (686, '0IL3', 'Flying B Ranch Airport', 'US', 40.157, -87.6745, 0, 0, ''), (687, '0IL4', 'Good Samaritan Hospital Heliport', 'US', 41.8189, -88.0078, 0, 0, ''), (688, '0IL6', 'Kishwaukee Comm Health Heliport', 'US', 41.9631, -[...]

MySQL sa: 

#1062 - Duplicate entry '678' for key 'PRIMARY' 

phpvms_airports.sql.zip

Edited February 28, 2018 by spkier

[spkier]

17 minutes ago, spkier said:

i'm sorry that i have multiple threads open however i tought it was a good idea to not mix them up as i have multiple problems

btw anyone who has a schedule file a little kickstart so it's a bit easier to add routes?

i attached the file i'm trying to upload to Mysql

i'm trying to import a few hundred thousend airports

this is the error i get 

Feil

SQL-spørring:

-- -- Dataark for tabell `phpvms_airports` -- INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES (678, '0II2', 'Creighton Airport', 'US', 41.4573, -86.1244, 0, 0, ''), (679, '0II3', 'Miller Strip', 'US', 40.6278, -86.0378, 0, 0, ''), (680, '0II5', 'Marshall Field', 'US', 40.6595, -86.8572, 0, 0, ''), (681, '0II6', 'Kropf Airport', 'US', 41.6431, -85.8297, 0, 0, ''), (682, '0II7', 'Frost Field', 'US', 39.7956, -85.7861, 0, 0, ''), (683, '0II9', 'Winters Airport', 'US', 39.5342, -86.5772, 0, 0, ''), (684, '0IL0', 'Hamilton Memorial Hospital Heliport', 'US', 38.0867, -88.5389, 0, 0, ''), (685, '0IL1', 'Loyola University Medical Center Heliport', 'US', 41.8609, -87.8364, 0, 0, ''), (686, '0IL3', 'Flying B Ranch Airport', 'US', 40.157, -87.6745, 0, 0, ''), (687, '0IL4', 'Good Samaritan Hospital Heliport', 'US', 41.8189, -88.0078, 0, 0, ''), (688, '0IL6', 'Kishwaukee Comm Health Heliport', 'US', 41.9631, -[...]

MySQL sa: 

#1062 - Duplicate entry '678' for key 'PRIMARY' 

phpvms_airports.sql.zip

Solved i had to delete the old table first