Skip to content

Export/import data duplicate row instead of updating it (even with "ID" column left untouched) #1403

Open
@CypLef

Description

@CypLef

Steps to reproduce

  1. create a table and a view with "ID" column selected
  2. Export all row of this view
  3. Edit it on your computer to modify data on one or many row (no change on columns)
  4. import the modified file into the view

Expected behavior

  1. The row should just update and not duplicate, (because the "ID" column is left untouched and is unique per row)
  2. The second column "ID" should not be created

Actual behavior

  1. Every row is now duplicate, half is the old version, half is the new version
  2. Also a new column is automatically created (a ID column), even if the choice "create missing column" is not choosen

Tables app version

0.7.5

Browser

firefox

Client operating system

windows

Operating system

Debian

Web server

Nginx

PHP engine version

None

Database

PostgreSQL

Additional info

Nextcloud 29.0.5

The reason why i want to do this:
I want to modify a lots of row quickly, and doing it in Table, editing row one by one is just toooooooo long.
Right now, the only solution i found is to export data, delete it, modify it on my computer, and import it again.

Metadata

Metadata

Assignees

No one assigned

    Labels

    0. Needs triagePending approval or rejection. This issue is pending approval.enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions