We added a new data administration feature to help you with maintaining your data. You can already upload data as CSV from the editor, and you can now modify data. You can find a MODIFY button in the App Data section of the Data Tab to do this.
The file you upload should contain one column with the ID of the thing you want to modify. Then values in other columns will be applied to each thing, and they should be formatted as you do with upload CSV.
One important thing to note is the box ‘Overwrite data when the field value is empty’. If this box is checked, empty values will be overwritten by an empty one if the cell is empty, while if you don’t check the box these cells will be ignored (in case of issues, keep in mind Bubble offers version control on data to recover from mistakes )
@emmanuel Very helpful! This directly solves one of the pain points I have.
An issue I’ve noticed with the bulk upload (predating this new feature), is a conflict when a mapped data field has a text mismatch. (Only asking for a fix if easy, but otherwise general FYI to others).
For instance, let’s say I have a mapped field, which relates to the table “Product Type” In the database, I have the entries Apples, Oranges, Pineapples, etc.
If my CSV had an item that was improperly written as Apple, (not plural, Apples) the whole upload is stalled.
If there was an option box that let you ignore failures and generated a list of rows with failures post upload, I would greatly appreciate it. (Otherwise, I have to close out the uploader, fix the data set, re-map the fields, etc). Mainly tedious when I’m uploading a dataset with many mapped fields.
I am using the Modify data via CSV feature & getting an error message during “Validate Data” step which reads: “There was an error analyzing your data: Undefined”. What does “Undefined” mean?
I am uploading data in that I download and modified two text fields. All I have in the upload are those two text fields and the Unique ID field. Any help would be appreciated.
I thought it was only going to modify the ‘Sender Organization’ field, but it erased all of my other fields. Is that because I checked the ‘Overwrite data when the field value is empty’ box?
UPDATE: The answer is yes. I restored the earlier version of the data type and then did the Modify without the checkbox. Problem solved.
I must have missed something but how exactly do I get these unique ids? My application doesn’t show any in the data tab. Although you mention that it’s auto generated by bubble on the first import. As far as I can tell my first import did not auto-gen these IDs. So I’m currently unable to use the modify-by-csv feature…
)