Skip to content

Editing row in excel appends to table instead of replacing if table has no primary key #7

@KatiRG

Description

@KatiRG

CKAN version

2.11.1 commit fd86be7f7 Update version number for 2.11.1

ckan.ini:
ckan.plugins = activity excelforms tabledesigner datatables_view datastore xloader

Describe the bug

Editing a specific row of a CSV resource by clicking on the "Edit in Excel" option downloads that row into an excel template, but uploading the edits with the file selection input next to the “Excel template” button below the preview causes the edited row to be appended to the original table, if the table does not have a primary key specified:

Image

If, however, the table does have a primary key (in this example, the first column uid), then repeating the same process does result in the row being replaced by the edits:

Image

Expected behaviour

An existing row in the table without a primary key should be replaced with edited values if that row is selected for editing using excel forms.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions