Opened 8 years ago

Last modified 8 years ago

#15980 closed defect

Error when importing data from Excel files with the OpenData plugin — at Version 2

Reported by: wolfgang8 Owned by: Don-vip
Priority: normal Milestone:
Component: Plugin opendata Version:
Keywords: template_report Cc:

Description (last modified by Don-vip)

What steps will reproduce the problem?

  1. Start JOSM
  2. Menu "File/Open" -> File "qry_OSM_Import_Orte.xls"
  3. Menu "File/Open" -> File "qry_OSM_Import_Orte.csv"

The two files (see appendix) each contain three identical data sets with address data. The second data record does not contain a house number but a value in the column "fixme".

File content "qry_OSM_Import_Places. csv":

latitude;longitude;name;addr:postcode;addr:city;addr:place;addr:street;addr:housenumber;fixme
48,415625;15,644857;Straße 20;3500;Gemeinde;Ort;Straße;20;
48,414732;15,646047;Straße;3500;Gemeinde;Ort;Straße;;highway
48,415423;15,644489;Straße 19;3500;Gemeinde;Ort;Straße;19;

What is the expected result?

For the second dataset, the value "highway" should be assigned to the tag "fixme" of the address point. This should be the case for the address points of both files.

What happens instead?

With the file "qry_OSM_Import_Orte. csv" the result is as expected.
With the file "qry_OSM_Import_Orte. xls" the value of the column "fixme" (=highway) is not assigned to the tag "fixme", but to the tag "addr: housenumber".

Please provide any additional information below. Attach a screenshot if possible.

URL:http://josm.openstreetmap.de/svn/trunk
Repository:UUID: 0c6e7542-c601-0410-84e7-c038aed88b3b
Last:Changed Date: 2018-01-28 23:08:56 +0100 (Sun, 28 Jan 2018)
Build-Date:2018-01-28 22:25:44
Revision:13367
Relative:URL: ^/trunk

Identification: JOSM/1.5 (13367 de) Windows 10 64-Bit
OS Build number: Windows 10 Home 1709 (16299)
Memory Usage: 247 MB / 247 MB (82 MB allocated, but free)
Java version: 1.8.0_111-b14, Oracle Corporation, Java HotSpot(TM) Client VM
Screen: \Display0 1920x1080
Maximum Screen Size: 1920x1080

Plugins:
+ AddrInterpolation (33692)
+ FixAddresses (33963)
+ OpeningHoursEditor (33876)
+ PicLayer (34021)
+ alignways (33784)
+ apache-commons (33668)
+ austriaaddresshelper (1511306130)
+ buildings_tools (34040)
+ ejml (32680)
+ geotools (33958)
+ graphview (33938)
+ jts (32699)
+ opendata (34019)
+ reverter (34036)
+ terracer (33839)
+ undelete (33980)
+ utilsplugin2 (33991)

Tagging presets:
+ https://josm.openstreetmap.de/josmfile?page=Presets/ParkingLanes&zip=1
+ https://josm.openstreetmap.de/josmfile?page=Presets/NewTags&zip=1
+ https://josm.openstreetmap.de/josmfile?page=Presets/NewParkingFeatures&zip=1
+ https://josm.openstreetmap.de/josmfile?page=Presets/Crafts&zip=1
+ https://josm.openstreetmap.de/josmfile?page=Presets/Historical_Objects&zip=1
+ https://josm.openstreetmap.de/josmfile?page=Presets/Heritage&zip=1
+ https://raw.githubusercontent.com/yopaseopor/traffic_signs_preset_JOSM/master/A.zip
+ https://josm.openstreetmap.de/josmfile?page=Presets/Communication_Towers&zip=1
+ https://josm.openstreetmap.de/josmfile?page=Presets/BuildingPreset&zip=1
+ https://josm.openstreetmap.de/josmfile?page=Presets/MobilePhoneBaseStations&zip=1

Map paint styles:
- https://github.com/simon04/coloured-addresses.mapcss/raw/master/dist/coloured-addresses.mapcss
- https://josm.openstreetmap.de/josmfile?page=Styles/AddressValidator&zip=1
- https://josm.openstreetmap.de/josmfile?page=Styles/Surface&zip=1
- https://josm.openstreetmap.de/josmfile?page=Styles/Surface-DataEntry&zip=1
- https://www.dropbox.com/s/qo3ai47fpv241jf/Styles_Fixme_and_Notes.zip?raw=1
- https://josm.openstreetmap.de/josmfile?page=Styles/Coloured_Streets&zip=1
- https://josm.openstreetmap.de/josmfile?page=Styles/Coloured_Postcode&zip=1
- https://josm.openstreetmap.de/josmfile?page=Styles/Coloured_buildings&zip=1
- https://josm.openstreetmap.de/josmfile?page=Styles/AddressValidator&zip=1
- https://josm.openstreetmap.de/josmfile?page=Styles/Modified&zip=1
- https://josm.openstreetmap.de/josmfile?page=Styles/Fixme&zip=1

Last errors/warnings:
- W: No configuration settings found.  Using hardcoded default values for all pools.
- W: Warnung: Das Absuchen der Datei 'site-svn.openstreetmap.org-_applications_editors_josm_plugins_opendata_modules.txt' nach Modulinformationen ist fehlgschlagen. Überspringe.

Change History (4)

by wolfgang8, 8 years ago

Attachment: qry_OSM_Import_Orte.xls added

Excel-Datei

by wolfgang8, 8 years ago

Attachment: qry_OSM_Import_Orte.csv added

CSV-Datei

comment:1 by Don-vip, 8 years ago

Description: modified (diff)
Summary: Fehler beim Datenimport von Excel-Dateien mit dem OpenData-PluginError when importing data from Excel files with the OpenData plugin

Thanks for the report. Next time, can you please use English, so I don't have to translate it?

comment:2 by Don-vip, 8 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.