I try to import this big file http://download.geonames.org/export/dump/allCountries.zip and filter the import with Feeds Tamper and Feeds says the import was complete but i missing a lot of entries.

The file is saved in my Drupal private directory.

The main 'geoname' table has the following fields :
---------------------------------------------------

  1. geonameid : integer id of record in geonames database
  2. name : name of geographical point (utf8) varchar(200)
  3. asciiname : name of geographical point in plain ascii characters, varchar(200)
  4. alternatenames : alternatenames, comma separated, ascii names automatically transliterated, convenience attribute from alternatename table, varchar(10000)
  5. latitude : latitude in decimal degrees (wgs84)
  6. longitude : longitude in decimal degrees (wgs84)
  7. feature class : see http://www.geonames.org/export/codes.html, char(1)
  8. feature code : see http://www.geonames.org/export/codes.html, varchar(10)
  9. country code : ISO-3166 2-letter country code, 2 characters
  10. cc2 : alternate country codes, comma separated, ISO-3166 2-letter country code, 60 characters
  11. admin1 code : fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt for display names of this code; varchar(20)
  12. admin2 code : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)
  13. admin3 code : code for third level administrative division, varchar(20)
  14. admin4 code : code for fourth level administrative division, varchar(20)
  15. population : bigint (8 byte int)
  16. elevation : in meters, integer
  17. dem : digital elevation model, srtm3 or gtopo30, average elevation of 3''x3'' (ca 90mx90m) or 30''x30'' (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat.
  18. timezone : the timezone id (see file timeZone.txt) varchar(40)
  19. modification date : date of last modification in yyyy-MM-dd format

I filter for example the field "Feature code" with Keyword filter: ADM1

But not all items with Feature code ADM1 are imported. I tried also to import only the GeoID 2838632 but it doesn't import. The import process runs without any errors in Frontend.

If i use a small file only with 10 lines for example it works fine.

Comments

alexander.sibert’s picture

Issue summary: View changes
alexander.sibert’s picture

Issue summary: View changes