I’ve been trying to let my users upload a CSV with a list of employee names and emails, so that these can be added in bulk to an internal Campaign of theirs.
My data table is very simple at the moment.
Table name: CampaignEmployees
- Campaign (links to another table called Campaign)
- EmployeeName (text)
- EmployeeEmail (text)
The user is in their campaign page and only sees the list of CampaignEmployees uploaded for that specific Campaign.
There is a button there for them to download the CSV of that list and a button there for them to upload a CSV to add to that list.
I managed to have Bubble export the CSV of this list with only the CampaignEmployees registered for that Campaign.
However, I cannot make bubble.is upload the CSV when the Campaign column header is in the CSV.
The error I receive in the uploading process is: “This type of field is not supported by the upload CSV action: custom.campaign”
What I have tried:
I took the exact same file that I downloaded by using the csv download button, edited/added lines in the CSV in Excel preserving the same headers and tried to upload it. It doesn’t work. It only works when I remove the Campaign column.
The problem with it is that I cannot allow my users to upload CampaignEmployees without associating those with a campaign.
I also cannot upload these to a temporary table and then run a workflow to convert those into CampaignEmployees because there will be users of different organisations in the app and if they do it concurrently, it will be messed up.
Any idea on how to solve this one?
(I have the feature of adding one by one but this would take ages for the user if the campaign has hundreds of employees.)