Modify

#15980 closed defect (fixed)

Error when importing data from Excel files with the OpenData plugin

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.

Attachments (2)

qry_OSM_Import_Orte.xls (25.5 KB) - added by wolfgang8 20 months ago.
Excel-Datei
qry_OSM_Import_Orte.csv (286 bytes) - added by wolfgang8 20 months ago.
CSV-Datei

Download all attachments as: .zip

Change History (6)

Changed 20 months ago by wolfgang8

Attachment: qry_OSM_Import_Orte.xls added

Excel-Datei

Changed 20 months ago by wolfgang8

Attachment: qry_OSM_Import_Orte.csv added

CSV-Datei

comment:1 Changed 20 months ago by Don-vip

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 Changed 20 months ago by Don-vip

Description: modified (diff)

comment:3 Changed 20 months ago by wolfgang8

Sorry - I will gladly do it next time.

comment:4 Changed 20 months ago by Don-vip

Resolution: fixed
Status: newclosed

Fixed in [o34072:34073].

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Don-vip.
as The resolution will be set.
The resolution will be deleted.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.