Add Bulk Upload CSV

[bbertucc]

Here is a video demo of the feature: https://www.loom.com/share/7538d9060d464570bb36282771c7c20b?sid=1e0389b1-4d86-449d-8e8a-84fefbded3fe

Important Notes:

• [x] Announce when your toggling bulk upload or single upload to screen readers
• [x] Validate URLs uploaded - announce any issues
• [x] Validate CSV columns and data - announce any issues
• [x] Announce successful upload

Here is a sample CSV: https://github.com/EqualifyEverything/eudaimonia-wp/blob/main/websites.csv

@heythisischris said he was interested in jumping on this. Bounting this issue. He is going to submit a quick proposal for approval. Adding this to our next Sprint, since @heythisischris said he can get the issue done in a few days.

[heythisischris]

Always excited to work on power tools. Here we go:

Overview

We're building a bulk CSV import tool for Equalify. The idea is to allow users to upload CSV lists of properties with the following attributes:

• Name
• URL
• Discovery

We'll have to intelligently detect what columns correspond to what fields. We can leverage GPT-4o for this purpose.

Steps

• [ ] Create API endpoint to preview Bulk Upload (POST /bulk/preview)
• [ ] Create API endpoint to handle Bulk Upload (POST /bulk/upload)
• [ ] Create API endpoint to roll back Bulk Upload (POST /bulk/rollback)
• [x] Add "Bulk Upload" button to Properties screen
• [ ] Create Start Bulk Upload route
• [ ] Create Preview Bulk Upload route
• [x] Create Bulk Upload results route
• [x] Ensure accessibility across all new routes
• [x] Test bulk uploaded properties and ensure everything is working as expected

Budget

The requested bounty is $500 for roughly 8 hours of development spread across 2 days.

This comes out to an effective rate of $62.50/hour.

Timeline

I intend to have this completed and ready for by August 23rd, 2024.

[bbertucc]

Approved.

[bbertucc]

$250 payment initiated.

[heythisischris]

https://github.com/EqualifyEverything/equalify-dashboard/pull/60

Created a pull request, would consider this issue complete after it's approved.

[bbertucc]

adding @kevinandrews1 - Kevin you should be able to test adding multiple properties under "Properties" at https://equalify.dev

@heythisischris: There is currently no validation. We need to validate:

• [x] to make sure you're adding a CSV
• [x] the csv has the correct column names
• [x] the url is a valid url
• [x] the type is a valid taype.

It incorrectly reported that this was successfully added:

name,url,type
Equalify Single,https://decubing.com,fake
Equalify Sitemap,httpfdfecubing.com/sitemap.xml,sitsfsdfemap

Feel free to push to staging and let me know when it's up there to test.

[heythisischris]

https://github.com/EqualifyEverything/equalify-dashboard/commit/d154692533fe6e24690bb28e2c08d4734910771c

@bbertucc Validation is added and pushed to staging! Handling everything that you listed above. @kevinandrews1, you can start testing over at https://equalify.dev.

[bbertucc]

@kevinandrews1 any updates on this? It's ready for you to test.

[kevinandrews1]

@bbertucc @heythisischris I will get to this and report back by the end of today.

[kevinandrews1]

For @heythisischris:

• Went to equalify.dev
• Logged in
• WEnt to Properties
• Activated Bulk Upload CSV
• I get the "reports page loaded" message with JAWS
• There should be a message that tells you the upload was successful. Basically all I get with JAWS spitting this out at me "Showing first 10 rows name url type Equalify Single..." The upload message is cleaner and more informative. Otherwise this is great! When I press submit I get the notification the property was successfully added.

[bbertucc]

Reassigning @heythisischris to add an upload confirmation

[heythisischris]

https://github.com/EqualifyEverything/equalify-dashboard/pull/60/commits/54d10c2051d5f51c90f733da237dc38f6bb740d2

@bbertucc added upload confirmation, I think this task is completed and ready to merge into production.