Current i import GeoNames tab delimited databases of all Countries, States/Regions and Cities of the world as Nodes. It works fine with Feeds.

What for modules i use?

Feeds
Feeds Tamper
Field Validation
i18n
Entity Translation
Entity Reference
Feeds Entity Translation

GeoNames are separated in few CSV/TXT files.

I use this file http://download.geonames.org/export/dump/allCountries.zip to import all countries, states/regions and cities and assign the node types (Country, State, City) with Entity Reference. Each Node type has a Feeds import profile. With Feeds Tamper and Keyword Filter i can filter the location types. Here i use ADM1 and PPLA4.

The GeoID is an Unique ID which i set with Field Validator (the Patch is installed to work with Feeds module together)

It works all but now i need to translate the Entities like Title field. Here i have a separated file: http://download.geonames.org/export/dump/alternateNames.zip

This file also contains the unique GeoID. Now i want for example import only additional german language (source language is english). I tried but it doesn't update the exist nodes with the new Language. I use for that the Feeds Entity Translation module and set in the Mapping the Title Scope on "German" - de.

Maybe someone can help me or has a better solution?

Greetings

Comments

alexander.sibert’s picture

Status: Active » Closed (works as designed)