Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
CypLef opened this issue Oct 4, 2024 · 0 comments
Labels
0. Needs triage Pending approval or rejection. This issue is pending approval. bug Something isn't working

Comments

@CypLef
Copy link

CypLef commented Oct 4, 2024

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.

@CypLef CypLef added 0. Needs triage Pending approval or rejection. This issue is pending approval. bug Something isn't working labels Oct 4, 2024
@CypLef CypLef changed the title Ewport/import data duplicate row instead of updating it (even with "ID" column left untouched) Export/import data duplicate row instead of updating it (even with "ID" column left untouched) Oct 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending approval or rejection. This issue is pending approval. bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant