Opened 14 years ago

Last modified 13 years ago

#5038 new enhancement

Proposal for editing object attributes in spreadsheet mode

Reported by: thePlaneMad@… Owned by: team
Priority: major Milestone:
Component: Core Version: latest
Keywords: selection, editing, spreadsheet, attribute table Cc: thePlaneMad@…, joshdoe

Description (last modified by joshdoe)

At the moment there is no way to edit individual values of a group selection. Making a change in the property table would apply it to the whole selection. Its also not possible to view individual values for certain objects without losing the selection.

I propose having a spreadsheet view of the attributes of the selected objects. This would enable easier modification of attributes of a large number of objects at once instead of individual selection and modification.

I have attached a mockup of how this would work.

  1. A selection of objects is made either manually or using the find command
  2. After the selection is loaded in the spreadsheet, the common tags for the selection is listed seperately, this would help to add/remove a tag that would affect the whole selection
  3. A spreadsheet view of the keys having different values is given, clicking on any of the rows will automatically zoom the josm map to the object
  4. Double clicking any of the fields makes it editable, any corrections/additions can easily be made this way
  5. One can add a new column if required
  6. the header row contains the key which is also editable. deleting a key would remove that entire column. The particular tag will be deleted from the selection.
  7. The spreadsheet can be exported to a csv if required

I am also working on how the import csv function can work. It would help in mass adding some attribute information from a list or table like updating icao/iata codes for airports, or maybe elevation information for peaks.

Attachments (1)

josm table edit.png (43.9 KB ) - added by thePlaneMad@… 14 years ago.
mockup of the attribute spreadsheet view

Download all attachments as: .zip

Change History (3)

by thePlaneMad@…, 14 years ago

Attachment: josm table edit.png added

mockup of the attribute spreadsheet view

comment:1 by joshdoe, 13 years ago

Cc: thePlaneMad@… joshdoe added
Description: modified (diff)

I think this is an excellent idea, as I just had the same idea and came across this ticket after searching the web for "josm spreadsheet". You outlined the concept almost exactly as I had imagined it. Hopefully I or someone else will get to this at some point.

comment:2 by joshdoe, 13 years ago

Modify Ticket

Change Properties
Set your email in Preferences
as new The owner will remain team.
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from team to the specified user.
Next status will be 'needinfo'. The owner will be changed from team to thePlaneMad@….
as duplicate The resolution will be set to duplicate. Next status will be 'closed'. The specified ticket will be cross-referenced with this ticket.
The owner will be changed from team to anonymous. Next status will be 'assigned'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.