appsmith icon indicating copy to clipboard operation
appsmith copied to clipboard

fix: Add support for xls,json,tsv file types in file widget

Open rajatagrawal opened this issue 2 years ago • 10 comments

Fixes #17946

This PR adds support for parsing XLS,XLSX, TSV, JSON and CSV files in file widget v2.

Type of change

  • New feature (non-breaking change which adds functionality)
  • This change requires a documentation update

Testing

How Has This Been Tested?

  • [x] Manual
  • [x] Cypress

Test Plan

Import following file types to test if the feature works fine.

  1. Import xls, xlsx, json, tsv, csv file.
  2. Import a large file > 1 MB, > 5 MB to test the feature.
  3. Import file types of text,binary and base64 to test existing functionality since the whole importing code has been refactored.

Checklist:

Dev activity

  • [x] My code follows the style guidelines of this project
  • [x] I have performed a self-review of my own code
  • [x] I have commented my code, particularly in hard-to-understand areas
  • [ ] I have made corresponding changes to the documentation
  • [x] My changes generate no new warnings
  • [x] I have added tests that prove my fix is effective or that my feature works
  • [x] New and existing unit tests pass locally with my changes
  • [ ] PR is being merged under a feature flag

rajatagrawal avatar May 10 '23 05:05 rajatagrawal

/ok-to-test sha=2fdb155

rajatagrawal avatar May 10 '23 05:05 rajatagrawal

Tests running at: https://github.com/appsmithorg/appsmith/actions/runs/4933543421. Workflow: Appsmith External Integration Test Workflow. Commit: 2fdb155. PR: 23159. Perf tests will be available at https://app.appsmith.com/app/performance-infra-dashboard/pr-details-638dd7cd2913ba43778b915e?pr=23159&runId=4933543421_1

github-actions[bot] avatar May 10 '23 05:05 github-actions[bot]

/build-deploy-preview env=release

rajatagrawal avatar May 10 '23 05:05 rajatagrawal

Deploying Your Preview: https://github.com/appsmithorg/appsmith/actions/runs/4933546121. Workflow: On demand build Docker image and deploy preview. skip-tests: ``. env: release. PR: 23159. recreate: .

github-actions[bot] avatar May 10 '23 05:05 github-actions[bot]

/build-deploy-preview env=release

rajatagrawal avatar May 10 '23 06:05 rajatagrawal

/ok-to-test sha=0587e0a

rajatagrawal avatar May 10 '23 06:05 rajatagrawal

Deploying Your Preview: https://github.com/appsmithorg/appsmith/actions/runs/4933874630. Workflow: On demand build Docker image and deploy preview. skip-tests: ``. env: release. PR: 23159. recreate: .

github-actions[bot] avatar May 10 '23 06:05 github-actions[bot]

Tests running at: https://github.com/appsmithorg/appsmith/actions/runs/4933874899. Workflow: Appsmith External Integration Test Workflow. Commit: 0587e0a. PR: 23159. Perf tests will be available at https://app.appsmith.com/app/performance-infra-dashboard/pr-details-638dd7cd2913ba43778b915e?pr=23159&runId=4933874899_1

github-actions[bot] avatar May 10 '23 06:05 github-actions[bot]

Deploy-Preview-URL: https://appsmith-4l666txtc-get-appsmith.vercel.app

github-actions[bot] avatar May 10 '23 06:05 github-actions[bot]

Workflow run: https://github.com/appsmithorg/appsmith/actions/runs/4933874899. Commit: 0587e0a. The following are new failures, please fix them before merging the PR:

  1. cypress/integration/Regression_TestSuite/ClientSideTests/OtherUIFeatures/Omnibar_spec.js
To know the list of identified flaky tests - Refer here

github-actions[bot] avatar May 10 '23 08:05 github-actions[bot]

This PR has not seen activitiy for a while. It will be closed in 7 days unless further activity is detected.

github-actions[bot] avatar May 18 '23 16:05 github-actions[bot]

/ok-to-test sha=9a053be

rajatagrawal avatar May 24 '23 10:05 rajatagrawal

/build-deploy-preview env=release

rajatagrawal avatar May 24 '23 10:05 rajatagrawal

Deploying Your Preview: https://github.com/appsmithorg/appsmith/actions/runs/5067734876. Workflow: On demand build Docker image and deploy preview. skip-tests: ``. env: release. PR: 23159. recreate: .

github-actions[bot] avatar May 24 '23 10:05 github-actions[bot]

Tests running at: https://github.com/appsmithorg/appsmith/actions/runs/5067734719. Workflow: Appsmith External Integration Test Workflow. Commit: 9a053be. PR: 23159. Perf tests will be available at https://app.appsmith.com/app/performance-infra-dashboard/pr-details-638dd7cd2913ba43778b915e?pr=23159&runId=5067734719_1

github-actions[bot] avatar May 24 '23 10:05 github-actions[bot]

Deploy-Preview-URL: https://appsmith-orzgoo6ky-get-appsmith.vercel.app

github-actions[bot] avatar May 24 '23 11:05 github-actions[bot]

@somangshu @dilippitchika does this feature need to go part of What's new updates ?

rajatagrawal avatar May 24 '23 11:05 rajatagrawal

@rajatagrawal yes please

somangshu avatar May 24 '23 11:05 somangshu

Workflow run: https://github.com/appsmithorg/appsmith/actions/runs/5067734719. Commit: 9a053be. The following are new failures, please fix them before merging the PR:

  1. cypress/e2e/Regression/ClientSide/Templates/Fork_Template_Existing_app_spec.js
  2. cypress/e2e/Sanity/Datasources/Airtable_Basic_Spec.ts
To know the list of identified flaky tests - Refer here

github-actions[bot] avatar May 24 '23 12:05 github-actions[bot]

/ok-to-test sha=79deda2

rajatagrawal avatar May 25 '23 02:05 rajatagrawal

/build-deploy-preview env=release

rajatagrawal avatar May 25 '23 02:05 rajatagrawal

Tests running at: https://github.com/appsmithorg/appsmith/actions/runs/5075561131. Workflow: Appsmith External Integration Test Workflow. Commit: 79deda2. PR: 23159. Perf tests will be available at https://app.appsmith.com/app/performance-infra-dashboard/pr-details-638dd7cd2913ba43778b915e?pr=23159&runId=5075561131_1

github-actions[bot] avatar May 25 '23 02:05 github-actions[bot]

Deploying Your Preview: https://github.com/appsmithorg/appsmith/actions/runs/5075562016. Workflow: On demand build Docker image and deploy preview. skip-tests: ``. env: release. PR: 23159. recreate: .

github-actions[bot] avatar May 25 '23 02:05 github-actions[bot]

@sbalaji1192 I have fixed the review feedback. You can review the changes. Thanks!

rajatagrawal avatar May 25 '23 02:05 rajatagrawal

Deploy-Preview-URL: https://appsmith-2axb1jgg5-get-appsmith.vercel.app

github-actions[bot] avatar May 25 '23 03:05 github-actions[bot]

Workflow run: https://github.com/appsmithorg/appsmith/actions/runs/5075561131. Commit: 79deda2. The following are new failures, please fix them before merging the PR:

  1. cypress/e2e/Regression/ClientSide/Templates/Fork_Template_spec.js
  2. cypress/e2e/Regression/ServerSide/GenerateCRUD/MySQL1_Spec.ts
  3. cypress/e2e/Sanity/Datasources/Airtable_Basic_Spec.ts
To know the list of identified flaky tests - Refer here

github-actions[bot] avatar May 25 '23 03:05 github-actions[bot]

/ok-to-test sha=80f6f7c

rajatagrawal avatar May 27 '23 03:05 rajatagrawal

/build-deploy-preview env=release

rajatagrawal avatar May 27 '23 03:05 rajatagrawal

Deploying Your Preview: https://github.com/appsmithorg/appsmith/actions/runs/5096781307. Workflow: On demand build Docker image and deploy preview. skip-tests: ``. env: release. PR: 23159. recreate: .

github-actions[bot] avatar May 27 '23 03:05 github-actions[bot]

Tests running at: https://github.com/appsmithorg/appsmith/actions/runs/5096781390. Workflow: Appsmith External Integration Test Workflow. Commit: 80f6f7c. PR: 23159. Perf tests will be available at https://app.appsmith.com/app/performance-infra-dashboard/pr-details-638dd7cd2913ba43778b915e?pr=23159&runId=5096781390_1

github-actions[bot] avatar May 27 '23 03:05 github-actions[bot]