dolthub / dolthub-issues

Issues for dolthub.com
https://dolthub.com
4 stars 1 forks source link

Include a download link for the import job, allowing the downloaded file to be modified and reimported #519

Closed IraMelamud closed 10 months ago

IraMelamud commented 10 months ago

Current status: When uploading a file in jobs/PR section, and getting comments to change things, you need to re-create the csv file, do the changes needed and re upload the file, while connecting it to a temp branch. additionally, no other teammate can resolve the task, due to not having the original file that was uploaded to a certain job in Dolt. Purpose: Improve user experience, making it easier and faster to resolve comments in PRs. Allowing different teammates to have access to file in progress. Posible solution: When having csv file in jobs section, to have the ability to download it from jobs, make all needed changes and re-upload again, a- to same branch b- to temp branch and then to merge them. It will make UX much better and will allow few different teammates to work on same project.

Screen Shot 2023-12-05 at 21 35 37
liuliu-dev commented 10 months ago

After further consideration, I believe a more effective approach would be to directly modify the table within the import/pull request branch.

In the screenshot you provided, the branch JOINS_ira is created during the CSV file import. To modify the data in this file, you can directly work on this branch using the following steps:

Click on the branch name JOINS_ira on this pull request page, which will navigate you to the database on this branch.

Once on the database page, you have several options for modifying the table:

  1. Use the cell dropdown menu: Screenshot 2023-12-05 at 12 06 49 PM

  2. Use the SQL editor: Screenshot 2023-12-05 at 12 09 06 PM

Using either the cell dropdown or SQL editor, a workspace will be created. From there, select commit directly, and the changes will be applied directly to the chosen branch JOINS_ira.

You can also use the spreadsheet editor on DoltHub to modify your table:

Note that the spreadsheet method will create a new branch based on JOINS_ira. Let me know if you have any question:)