id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
15980	Error when importing data from Excel files with the OpenData plugin	wolfgang8	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.
}}}
"	defect	closed	normal		Plugin opendata		fixed	template_report