Improve formatting of array fields in CSV exports

Description

ENV: Bugfest OKAPI/EUREKA and Corsair Rancher

[Lists] [Organizations] The array type fields contain redundant metadata and other fields in the exported .csv doc.

PRE-CONDITION:

  • The user is on the “Lists” landing page

  • The user created a list with “Organizations” entity type

STEPS.

  1. Open the list from pre-conditions

  2. Activate all array type fields

  3. Click on “Actions” → Export visible columns (CSV)

  4. Open the exported file

ACTUAL RESULT:

Address field

IN THE APP

Address line 1

Address line 2

City

State/region

Zip code

Country

Categories

IN THE CSV

[{"city": "NEW YORK", "country": "USA", "zipCode": "10006", "language": "en", "metadata": {"createdDate": "2021-07-07T14:06:45.136+00:00", "updatedDate": "2021-07-07T14:06:45.136+00:00", "createdByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684", "updatedByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684"}, "isPrimary": true, "categories": ["9491fdad-b97b-45df-9783-337d86abc80f", "549d6d85-a51a-4cfc-8cfa-e4d46fb33823", "62042758-5266-472a-a3e9-ea1ca0ccf056"], "stateRegion": "NY", "addressLine1": "1 LIBERTY PLAZA", "addressLine2": "FLOOR 20 ", "categoriesNames": ["claim", "order", "payment"]}]

 

Emails

IN THE APP

Email

Description

Categories

IN THE CSV

[{"value": "info@filmplatform.net", "metadata": {"createdDate": "2021-07-07T14:12:54.142+00:00", "updatedDate": "2021-07-07T14:12:54.142+00:00", "createdByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684", "updatedByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684"}, "categories": [], "categoriesNames": null}]

 

Phone numbers

IN THE APP

Phone number

Categories

Type

IN THE CSV

[{"language": "en", "metadata": {"createdDate": "2021-07-07T14:06:45.136+00:00", "updatedDate": "2021-07-07T14:06:45.136+00:00", "createdByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684", "updatedByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684"}, "isPrimary": true, "categories": ["9491fdad-b97b-45df-9783-337d86abc80f", "549d6d85-a51a-4cfc-8cfa-e4d46fb33823", "62042758-5266-472a-a3e9-ea1ca0ccf056"], "phoneNumber": "(212) 337-5000", "categoriesNames": ["claim", "order", "payment"]}

 

URLs

IN THE APP

URL

Description

Categories

Notes

IN THE CSV

[{"value": "http://www.jamespublishing.com/ ", "metadata": {"createdDate": "2021-07-07T14:11:48.068+00:00", "updatedDate": "2021-07-07T14:11:48.068+00:00", "createdByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684", "updatedByUserId": "9eb67301-6f6e-468f-9b1a-6134dc39a684"}, "categories": ["71a3e461-1777-4a6f-b1cc-d4a856d141ec"], "categoriesNames": ["other"]}]

Environment

None

Potential Workaround

None

Checklist

hide

Activity

Show:

Details

Assignee

Reporter

Labels

Priority

Development Team

Corsair

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 13, 2024 at 7:04 AM
Updated January 22, 2025 at 2:26 PM
TestRail: Cases
TestRail: Runs