Hi all,
I wonder if it is possible to update some records via csv?
I exported the records and the id field looks like this (in excel)
so when I made my changes and imported them, it would create the records not update them!
any ideas why!!
Does changing the column type to a string/text fix the generated CSV?
We’ve had quite a few issues with excel (and alike) and changing column types usually fixed the issue.
@tjerman the id field is the recordID, I think. because I don’t have a column called id in my module also some of the numbers in the middle are similar to the recordID.
I’m not sure how to change the column’s type in Excel !
will try opening the CSV file in a text editor instead … and see how it goes
Yes, id would be recordID; unsure why I decided to name it as such, apologies for confusion.
Haven’t used Excel in ages but I think it is the same as with Google Sheets – there should be something in the ones of formats/data formatting.
I usually edit all CSV files in VSCode (or similar editors) so I don’t have to deal with this.
1 Like