I have copied the db to the sws server and made some changes to improve the sync mechanism. It will now sync the ids with an additional separate process and a check makes sure the ids are not different, so it will not insert it if the ids on the different server are out of sync.
1. When we add ID 7289407 Naoussa, Greece, the system says I have to add the parent ID 6255148 which is Europe.
When we add ID 7289301 Fish Hoek, South Africa, the system says I have to add the parent ID 6255146 which is Africa.
The same error adding 7289434 Pilanesberg Game Reserve, South Africa.
We can fix the parents manually, but is there a way for you to do it for all the ones that have this issue?
2. I'm adding GeoName ID: 2647567 (Hammersmith) to our database and it's showing alternative name: "Hammersmith tube station" as the default. This is because the wikipedia link is wrong. How can we fix it?
1. I don't understand this issue. Which system is asking you to add a parentid? GeoNames automatically assigns the country code and the continent is a consequence of the country.
1. our system. But that is not the real problem the thing is that there are a bunch of areas that don't have the right parent. Speacially in south africa the parent is Africa the continent and we were wondering if there is a way for you to fix this issue.
1. I still don't understand what I can do to fix issues with your system.
2. should be fixed now.
An other point: I see you are adding a lot of redundant names. (ex "La Colle sur Loup" for "La Colle-sur-Loup". This is neither required nor desired. The geonames search function is able to deal with 'minus' and characters and the likes.