Daha çox

CSV-nin CartoDB-yə idxalı ilə bağlı problem


Yerli maşınımda CartoDB quraşdırmışam və idxal yolu ilə məlumat yükləyə bilmirəm.

Yükləmək üçün məlumatlar

Enlem, Boylam, ad 48.1,0.25, "birinci nöqtə" 49.2,1.1, "ikinci nöqtə" 47.5.0.75, "üçüncü nöqtə"

Səhvi qəbul edirəm:

true: /tmp/imports/20151014-21811-1binquy/123.csv saytından məlumatların idxalı true: Fayl əsaslı idxal yükü true: Alınan kodlaşdırma ISO-8859-1 true: Verilənlər bazası bağlantısını {: adapter => "postgres" ilə istifadə edərək, : encoding => "unicode",: host => "localhost",: port => 5432,: database => "cartodb_dev_user_f4f00efc-27e9-4321-af96-8bbb73245090_db",: username => "postgres",: conn_validator_timeout = 900,: pool => 50,: user => "development_cartodb_user_f4f00efc-27e9-4321-af96-8bbbb73245090"} false: ogr2ogr call: OSM_USE_CUSTOM_INDEXING = NO PG_USE_COPY = EVET PGCLIENTENCODING ISO-88 = " localhost port = 5432 istifadəçi = development_cartodb_user_f4f00efc-27e9-4321-af96-8bbb73245090 dbname = cartodb_dev_user_f4f00efc-27e9-4321-af96-8bbb73245090_db parol = 53e933beffd3aef71b99afe6586c9afca5804943development_cartodb_user_f4f00efc-27e9-4321-af96-8bbb73245090 "-lco DIM = 2 -lco PRECISION = NO / tmp /imports/20151014-21811-1binquy/123.csv -nln cdb_importer.importer_e2b0c8ba726711e59e5400505681560b -nlt PROMOTE_TO_MULTI doğru: ogr2o gr output: sh: -f: əmr doğru tapılmadı: ogr2ogr çıxış kodu: 32512 2015-10-14 11:37:03 UTC: Ogr2ogr YAXŞI! 2015-10-14 11:37:03 UTC: ogr2ogr.exit_code = 32512 2015-10-14 11:37:03 UTC: ogr2ogr.command = OSM_USE_CUSTOM_INDEXING = NO PG_USE_COPY = EVET PGCLIENTENCODING = ISO-8859-1 -f PostgreSQL PG "host = localhost port = 5432 istifadəçi = development_cartodb_user_f4f00efc-27e9-4321-af96-8bbb73245090 dbname = cartodb_dev_user_f4f00efc-27e9-4321-af96-8bbb73245090_db parol = 53e933beffd3aef71b99afe6586c9afca5804943development_cartodb_user_f4f00efc-27e9-4321-af96-8bbb73245090" -lco DIM = 2 -lco PRECISION = YOX /tmp/imports/20151014-21811-1binquy/123.csv -nln cdb_importer.importer_e2b0c8ba726711e59e5400505681560b -nlt PROMOTE_TO_MULTI 2015-10-14 11:37:03 UTC: ogr2ogr.omm: true /Tmp/imports/20151014-21811-1binquy/123.csv saytından məlumatların idxalı səhvdir: === LOG END === true: --------------------- ------------------------------- yanlış: ["/ opt / openmap / carto / cartodb / services / importer / lib / importer / loader.rb: 335: 'check_for_import_errors' ', "/ opt / openmap / carto / cartodb / services / importer / lib / impo rter / loader.rb: 268: 'run_ogr2ogr' "," /opt/openmap/carto/cartodb/services/importer/lib/importer/loader.rb:63:in 'blokda (2 səviyyə)' ', "/opt/openmap/carto/cartodb/lib/cartodb/stats/aggregator.rb:97:in 'method_missing'", "/opt/openmap/carto/cartodb/services/importer/lib/importer/loader.rb: 62: 'blok çalışırken' ', "/opt/openmap/carto/cartodb/lib/cartodb/stats/aggregator.rb:97:in' method_missing '", "/ opt / openmap / carto / cartodb / services / importer / lib / importer / loader.rb: 52: 'run' "," /opt/openmap/carto/cartodb/services/importer/lib/importer/runner.rb:222:in 'file_based_loader_run' "," / opt / openmap / carto / cartodb / services / importer / lib / importer / runner.rb: 177: 'import' "," /opt/openmap/carto/cartodb/services/importer/lib/importer/runner.rb: 327: 'execute_import' "," /opt/openmap/carto/cartodb/services/importer/lib/importer/runner.rb:256:in 'single_resource_import' blokunda (3 səviyyə) '"," / opt / openmap / carto / cartodb / services / importer / lib / importer / runner.rb: 249: 'each' "," / opt / openmap / carto / ca rtodb / services / importer / lib / importer / runner.rb: 249: 'every_with_index' ', "/opt/openmap/carto/cartodb/services/importer/lib/importer/runner.rb:249:in' block ( 2 düzey) single_resource_import '', "/opt/openmap/carto/cartodb/lib/cartodb/stats/aggregator.rb:97:in 'method_missing'", "/ opt / openmap / carto / cartodb / services / importer / lib / importer / runner.rb: 248: in 'block in single_resource_import' "," /opt/openmap/carto/cartodb/lib/cartodb/stats/aggregator.rb:97:in 'method_missing' "," / opt / openmap / carto / cartodb / services / importer / lib / importer / runner.rb: 226: 'single_resource_import' "," /opt/openmap/carto/cartodb/services/importer/lib/importer/runner.rb:95: 'run_import' "," /opt/openmap/carto/cartodb/services/importer/lib/importer/runner.rb:88:88 'blokda' ', "/ opt / openmap / carto / cartodb / lib / cartodb / stats / aggregator.rb: 97: 'method_missing' "," /opt/openmap/carto/cartodb/services/importer/lib/importer/runner.rb:87:in 'run' "," / opt / openmap / carto / cartodb / app / connectors / importer.rb: 39: 'run' ', "/opt/openmap/carto/cartodb/app/models/data_import.rb:618:in 'new_importer'", "/opt/openmap/carto/cartodb/app/models/data_import.rb:354:in 'dispatch' "," /opt/openmap/carto/cartodb/app/models/data_import.rb:163:in 'run_import!' "," /opt/openmap/carto/cartodb/lib/resque/importer_jobs.rb:9:in 'block in perform' "," /opt/openmap/carto/cartodb/lib/resque/base_job.rb:21: '' call '"," /opt/openmap/carto/cartodb/lib/resque/base_job.rb : 21: 'run_action' "," /opt/openmap/carto/cartodb/lib/resque/importer_jobs.rb:9:9 '' perform '"," /usr/local/lib/ruby/gems/1.9.1 /gems/resque-1.25.2/lib/resque/job.rb:240:in 'blokunda (3 səviyyə)' ', "/usr/local/lib/ruby/gems/1.9.1/gems/resque -metrics-0.1.1 / lib / resque / metrics.rb: 353: 'around_perform_metrics' ', "/usr/local/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque /job.rb:239: 'blokunda (2 səviyyə)' ', "/usr/local/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/job.rb : 247: 'çağrı' ', "/usr/local/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/ job.rb: 247: 'perform' ', "/usr/local/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/worker.rb:250:in' perform '' "," /usr/local/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/worker.rb:189::in 'in block in' ', "/ usr / local / lib / yaqut / daşlar / 1.9.1 / daşlar / resque-1.25.2 / lib / resque / worker.rb: 166: 'loop' "," /usr/local/lib/ruby/gems/1.9.1/ daşlar / resque-1.25.2 / lib / resque / worker.rb: 166: 'iş' ', "/usr/local/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/ resque / task.rb: 41: in 'blok (2 səviyyə) in '"," /usr/local/lib/ruby/1.9.1/rake/task.rb:205::' 'call' "," /usr/local/lib/ruby/1.9.1/rake/task.rb : 205: 'block in execute' "," /usr/local/lib/ruby/1.9.1/rake/task.rb:200:in 'each' "," /usr/local/lib/ruby/1.9 .1 / rake / task.rb: 200: 'execute' "," /usr/local/lib/ruby/1.9.1/rake/task.rb:158::in 'block in invoke_with_call_chain' "," / usr /local/lib/ruby/1.9.1/monitor.rb:211:in 'mon_synchronize' "," /usr/local/lib/ruby/1.9.1/rake/task.rb:151:in 'invoke_with_call_chain' " , "/usr/local/lib/ruby/1.9.1/rake/task.rb:144:in 'çağırın'", "/usr/local/lib/ruby/1.9.1/rake/application.rb:116 : 'invoke_task' "," /usr/local/lib/ruby/1.9.1/rake/application.rb:94:in 'blok (2 səviyyə) top_level' ', "/ usr / local / lib / ruby /1.9.1/rake/application.rb:94:in 'each' "," /usr/local/lib/ruby/1.9.1/rake/application.rb:94:in 'block in top_level' "," /usr/local/lib/ruby/1.9.1/rake/application.rb:133:in 'standard_exception_handling' "," /usr/local/lib/ruby/1.9.1/rake/application.rb:88:in 'top_level' "," /usr/local/lib/ruby/1.9.1/ra ke / application.rb: 66: 'block in run' "," /usr/local/lib/ruby/1.9.1/rake/application.rb:133:in 'standard_exception_handling' "," / usr / local / lib / ruby ​​/ 1.9.1 / rake / application.rb: 63: 'run' "," / usr / local / bin / rake: 32: in '
'"] doğru: --------------------------------------------- ------- 2015-10-14 11:37:03 UTC: Qeydiyyatdan keçmək davam edir 2015-10-14 11:37:03 UTC: İthalatçı çalıştırdıktan sonra 2015-10-14 11:37:03 UTC: Sonra göndərmə 2015-10-14 11:37:03 UTC: ERROR! === LOG END ===

Fikirləriniz varmı?


Heç bir həll yolu tapa bilmirsinizsə, bunu köklə edə bilərsiniz

cd / usr / local / bin mv ogr2ogr ogr2ogr2 vi ogr2ogr #! / bin / bash ogr2ogr2 "$ @"

Bu, çox pis bir fikirdir ... amma işi ...


Mənim üçün işləyən bu cavabda ətraflı olaraq GDAL-ı qurmaq idi, sonra app_config.yml altında "which ogr2ogr2" olaraq "which ogr2ogr" yazısını dəyişdirdi


Videoya baxın: Формат CSV файлов (Oktyabr 2021).